Document status: RELEASED
Date:
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: YES
Extension of Store Settlement with O-file export
Store Settlement export was extended with RIGAL O-file. This uses same setup and triggers the same way as F-file. To enable the export of O-file, ItemGroup has to be added to existing parameter SettlementType in config file for POS Services worker. Example: <add key="SettlementType" value="Store,Operator,Workstation,ItemGroup" />
Following fields are exported, see RIGAL documentation for further information.
Field - Name - Description
1 - Code - OHDN (Normal price) and OHDT (discount price) are supported.
2 - Store number - Same as F-file
3 - Date - Settlment date, same as F-file.
5 - Item group numer
6 - Net amount
7 - Net cost
8 - Quantity
9 - Receipt count
10 - VAT amount
11 - Discount
15 - Item group name
20 - VAT code
NB! Reporting v82 is required or updated version of procedure sp_msvc_GetItemGroupSalesPerVATCode in "Lindbak POS Reporting DW"
Support fuel sales without tank structure data in the database
Reporting on fuel nozzle sales without having to import the tank structure is now possible. A support for creating inferred fuel nozzles in the data warehouse was implemented.
Thsi functionality is controlled by a new parameter in LindbakPOSReportingConfig.dtsConfig - varEnableInferredFuelNozzle - default false.
If set to true, a new nozzle in DimFuelNozzle is created based on the nozzle data in POSLog. If false, RT-job fails if nozzle is missing.
Extension of DimArticle with item type
DimArticle table was extended with item type number and item type name from Item Service. This information is also available in OLAP. It is now possible to report on these values in both DW and the cube.
Extension of FactRetailTransactionTender with tender control type
Tender information in the database and the cube (OLAP) was extended to include which tender types are used in control transactions. This will make it possible to report which tender type are used in e.g. payment on account.
Support for new price channel: Outdoor
New price channel: Outdoor was added to the Price Channel dimension to support outdoor fuel sales.
General improvements
- Reporting Data Integration package
Support for 255 characters long item short names (ItemShortText in Item Service, ArticleName in the data warehouse). Previously, only 64 characters long names were supported.
Export PDF/XML files with SSRS reports to the FTP server (A&D)
Sometimes it is necessary to create subscription on reports in Reporting Services, especially if a single subscription per store is required and Chain Web does not cover it.
A Powershell script was created to help with setting such subscriptions up. Contact Team Dataman to get the script.