Reporting on-premise

Previous Reporting on-premise release notes

Reporting v.84

Released 07.02.2025

New control transactions

(RTC-43210, RTC-43209)

Reporting supports new control transactions: Float and Spot check.

New report: Cash drawer control transactions (0161)

(RTC-46639)

New report showing control transactions which affects the cash drawer. For complete documentation see confluence: List of reports.

Reporting view pub.vSales extended with LineNote

(RTC-44249)

Line notes from article lines has been included in the view: pub.vSales.

Cash settlement: F-file supports new currencies

(RTC-41883)

F-file was extended with new settlement codes to support new currencies: CAD, CHF and JPY.

Improvements

Avoid duplicate balance transactions

(RTC-44695)

Balance transaction updates have been improved to avoid duplicates.

Reporting v. 83

Released 24.06.2024

Requirements:

*or a separate script (see upgrade guide for details).

Rebuild cube: NO

End of day consolidation

(RTC-41365)

Solution to export end of day data to a new blob type: Reporting.Export.EndOfBusinessDayStatistics.

Solution consists of two parts:

• when EOBD receipts are updated from cash register, total number of EOBD candidates is saved in a new column WorkstationsCount in table dbo.FactEndOfBusinessday.

• new on-prem LIP-job EndOfBusinessDayStatisticsExport in ReportingDataIntegration package will check new entries in FactEndOfBusinessDay table and see if the number of EOBD receipts for given store and date matches the number in WorkstationsCount (the job runs on schedule, default: every minute). If it does, the job will export EOBD data and publish it to the configured blob storage.

For further technical information about the job, see ReportingDataIntegration LIP package documentation.

Further information about the content in EndOfBusinessDayStatisticsExport can be found swagger (ReportingService): https://docs.egretail.cloud/.