Inferred promotions with eCoupons (RTC-30286)

Changed reading offer number from ExternalReference to OfferNo in POSLog. This is to avoid creating inferred offers with eCoupon name.

NB! this change requires latest version of POSLog.

New view with list of reports (RTC-36630)

A new view with list of reports (dashboards) was implemented under Dashboards menu entry. The list consist of three predefined dashboards, including previously implemented sales dashboard. The user can navigate to specific reports, as well as see recently used reports and flag the favourite ones with a star.

Image Added

Each dashboard can be also accessed with a direct link. The direct links support cashier login functionality.

Example: to access Sales dashboard with a cashier login, navigate here: https://reportingmanagement.chainweb.lindbaktest.com/dashboards/1?loginTenantId=????????????&loginStoreNumber=???

Reporting.Export.FlightSaleStatistics - adjustments in formatting (RTC-41456)

The following adjustments in file formatting were implemented:

• quotation marks removed from string columns,
• scheduled date time column extended with seconds and milliseconds,
• scheduled date time column values for fake flights set to 9999-12-31 22:59:59.999.

Budget menu with view and export/import functionality (RTC-36630)

A new menu with budget rows and import/export functionality.

The grid is accessible from the main menu:

Image Added

The following common level permission can be used to limit user's access to the functionality:

Image Added

The grid displays rows directly from the data warehouse. The following data is presented:

• store number,
• store name,
• budget date,
• budget measures:
  • amount,
  • net amount,
  • gross margin,
  • average amount per receipt.

In the bottom right corner, there are two buttons that allow the user to export the data to Excel file and import new rows:

Image Added

The exported file can be used as a template for import; it is possible to attach more than a single file.
The asynchronous import starts soon after selecting the file(s) and submitting.

Reporting dashboards - custom filters (RTC-40682)

A new feature in edit mode was added to make the dashboards in Reporting module even more customizable. It is now possible to configure a custom set of filters per each page.

The filter configuration is simple and intuitive. In the edit mode, a new filter can be added by clicking on + button:

Image Added

The next step is to select the filter dimension value and the filter is ready to use. All tiles on the dashboard are affected by a custom filter. Removing a filter is also simple and intuitive and it can be done by clicking on Delete button.

All changes are effective only after saving them in the edit mode.

The filter is ignored if no values are selected.

Export job - prevent exceptions during the initial run (RTC-41028)

Update to prevent exceptions during the initial run of job for new blob types.

Adjustment in exported flight blobs (RTC-41151)

The following changes to the flight blobs were implemented:

• Reporting.Export.FlightSaleStatistics:
  • set encoding of the file to UTF-8 BOM,
  • add prefix EG_ to the filename,
  • remove header,
  • column Quantity: round to the nearest whole number (no decimals),
  • column Amount: keep 4 decimals only,
  • column ScheduledDateTimeUtc: value for fake and dummy flights should be: 9999-12-31 22:59
• Reporting.Export.MemberFlightSaleStatistics:
  • set encoding to UTF-8 BOM.