Reporting v. 85
Released 15th of May 2025
Requirements:
Component | Version |
|---|---|
POS Master* | 3.0.0.90 |
POS JournalService | 2.92.xxx.x / 3.92.xxx.x |
POSLog XML | 92 |
*or a separate script (see upgrade guide for details).
Rebuild cube: YES
Return reason codes report
Shows reason codes used for returns on sale transactions. Helps identify why items are returned, making it easier to follow up on common issues or trends.
The report is available in the report list under EG Retail Chain.
Full description of report: List of reports - EG Retail Chain - Confluence EG A/S
Sales revenue report
Shows sales revenue across all cash registers in stores where sales take place. Helps track store performance and compare sales between locations.
Details about how the report works are available in the report list on Confluence:
List of reports - EG Retail Chain - Confluence EG A/S
Articles sold with open price
The data cube includes a new measure that shows how many articles are sold using open price. This helps track and analyze manually priced sales more accurately.
Cashier safety report
A new report shows statistics per cashier, such as transaction counts and exceptions. This supports internal control and improves visibility on individual cashier activity. Requires Reporting version 84.
For a full description, see: List of reports - EG Retail Chain - Confluence EG A/S
Compare sales between two stores
Use a new report to compare sales between two stores. The report shows differences in revenue, number of transactions, and other key sales figures side by side. This helps identify trends, performance gaps, or similarities between store locations.
Detailed explanation is available in Confluence.: List of reports - EG Retail Chain - Confluence EG A/S
Cashier report
Shows total revenue and a breakdown of payment methods used by each cashier during their shift. This helps store managers track sales performance and understand how customers pay:.List of reports - EG Retail Chain - Confluence EG A/S
Workstation report
Shows sales and payment methods per workstation. Use this report to see how much each workstation sells and which payment methods are used. This makes it easier to track performance and understand how customers pay at different locations or registers: List of reports - EG Retail Chain - Confluence EG A/S
Order line changes added to history table in POSLog extractor
The POSLog extractor adds order line changes to the history table. This makes it possible to report on changes made to individual order lines, such as quantity or product updates, using the on-premise reporting solution.
Order line history tracking
Order lines import into the FactOrderLinesHistory table. This makes it possible to report on changes to individual order lines over time.
Cleanup of FactOrderLinesHistory
A new package has been implemented to clean up old records in the FactOrderLinesHistory table. The retention period is configurable via the parameter varDaysToKeepOrderHistoryLines in the LindbakPOSReportingConfig.dtsConfig file.
The package runs as part of the N-job and is enabled by default.
Audit of shopping control
To enhance reporting on shopping cart controls, a new control transaction has been added to the Reporting database and cube. Additionally, a new Audit dimension has been introduced to enable reporting on the results of these controls.
Age control enhancement
The existing solution has been extended to include social/age control by adding the corresponding dimension name and integrating the related data into the OLAP cube.
Payment card types
To enhance reporting on card types, the database and OLAP cube have been extended to include PaymentCardTypes.
Improvements
Bonus calculation for returns with zero quantity items (RTC-47629)
Bonus points are no longer calculated for returned items if the quantity is zero. This avoids incorrect bonus adjustments when returns include items with no remaining quantity.
Supplier information (RTC-48639)
To support reporting on suppliers, the article information in the OLAP cube has been extended to include SupplierItemNO.
Reporting v. 84
Released 7th of February 2025
Requirements:
Component | Version |
|---|---|
POS Master* | 3.0.0.90 |
POS JournalService | 2.92.xxx.x / 3.92.xxx.x |
POSLog XML | 92 |
*or a separate script (see upgrade guide for details).
Rebuild cube: YES
New control transactions
Reporting supports new control transactions: Float and Spot check.
New report: Cash drawer control transactions (0161)
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
Line notes from article lines has been included in the view: pub.vSales.
Cash settlement: F-file supports new currencies
F-file was extended with new settlement codes to support new currencies: CAD, CHF and JPY.
Improvement
Avoid duplicate balance transactions
Balance transaction updates have been improved to avoid duplicates.
Reporting v. 83
Released 24.06.2024
Requirements:
Component | Version |
|---|---|
POS Master* | 3.0.0.90 |
POS JournalService | 2.82.xxx.x / 3.82.xxx.x |
POSLog XML | 82 |
*or a separate script (see upgrade guide for details).
Rebuild cube: NO
End of day consolidation
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/.