Document status: RELEASED
Date:
Requirements:
Component | Version |
|---|---|
POS Master* | 3.0.0.62 |
POS JournalService | 2.82.xxx.x / 3.82.xxx.x |
POSLog XML | 82 |
*or a separate script (see upgrade guide for details).
Sales statistics for bonus check
To better follow up bonus rollout, we are able to get sale statistics for receipt where bonus check was used.
Calculation works as follows: as before, bonus check is redeemed in CR and updated in Member Service. Reporting gets this transaction from loyalty database and stores in in FactMemberTransaction table. Now we also get transactionid. N-job will use this transactionid and calculate salesamount from receipt lines in FactRetailTransactionArticle.
To use this solution new package UpdateMemberTransactionSales must be activated by removing it from varPackagesToDisable in LindbakPOSReportingConfig.dtsConfig
Support for Loyalty endpoint in Reporting Service
To fully support all data required by loyalty dashboard, OLAP is extended with deleted date for member.
Supplier information in DimArticle view
The information about supplier phone number is added to Reporting. The field is exposed in the existing view pub.vDimArticle.
The existing information about supplier phone number is also added to the same view.
Inferred member functionality for workstations and VAT
When processing POSLogs with unknown workstations and / or VAT codes, Reporting will now create new dimension data instead of stopping Rt-job.
It also means that Workstation and VAT dimensions in Reporting are independent of POS Master now.
Reservation statistics for all stores
A relation between Retail Store and Order Line is added to OLAP to get correct values for Order and shipped amount / quantity. This will affect existing method orderStatistics when run for a single store. Change will happen when Reporting is upgraded to v76 or later. This is also used by new method orderStatisticsPerStore, which returns order statistics for all available stores.
Original scan code in Sales view
To better follow up item sales, information about OriginalScanCode in poslog is added to FactRetailTransactionArticle. Existing view pub.vSales is extended with new column OriginalScanCode.
Bug fixes and improvements
(RTC-23305, RTC-23392, RTC-25159)
- The collation issues with ArticleHierarchyMaintenance package were resolved. The package runs successfully, regardless of the database collation settings.
- UpdateMemberTransactions package was updated with the latest BonusCalc (4.9.0.2). This makes it possible to recalculate bonus amount at night including new bonus rules (amount on discounted items).
When looking up members from POSLog, it is possible to link unknown member to member 999999999999999990 instead of creating a new inferred member. Parameter varDisableInferredMemberForMember controls this.