Versions Compared

Old Version 327

changes.mady.by.user Atle Olaf Hanssen

Saved on

compared with

New Version Current

changes.mady.by.user Atle Olaf Hanssen

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
title0951_SecurityReport_DW

RTC-52380

Description:

  • Report allows to monitor security-sensitive activities performed by cashiers/operators in the store, including manual discounts, returns, gift card transactions, and voucher usage.

Selections:

  • Date from: Default yesterday
  • Date to: Default yesterday
  • Retail store: Single select on store (because of performance). Default first available.
  • Operator: Default all operators for the selected store

Output:

Security activity statistics shown individually per each cashier security-relevant activities like manual discounts, returns, gift card sales/redemptions, and voucher usage with reference to receipt number.

Additionally there are totals for each operator and each store.

Columns:

  • Retail Store - Store identifier and name
  • Manual discounts - Sum of manual discount amounts (line and sub-total discounts)
  • Manual returns - Quantity of items returned without reference to original transaction
  • Online returns - Quantity of items returned with reference to original transaction
  • Giftcards out - Quantity of gift cards sold
  • Giftcards in - Count of gift card redemptions/usage
  • Voucher/coupon used - Count of voucher/coupon usage transactions

Sorting:

  • Retail Store (default)
  • Operator Display
  • Transaction ID

Source:

  • Lindbak POS Reporting DW - Data Warehouse database


Anchor
0952_ItemQuantityStores
0952_ItemQuantityStores

Expand
title0952_ItemQuantityStores

RTP-43325

Image Added

Description:

Report displays item quantity sales data aggregated by retail store with support for mix and campaign analysis. It provides detailed sales information including quantity sold, number of customers, turnover, and promotional sales breakdown. The report allows drill-down from article level to individual store performance.

Selections:

  • Date from: Default today
  • Date to: Default today
  • Team: Multivalue; default all
  • Profile: Multivalue; default all
  • Store: Multivalue; default all (filtered by Team selection)
  • Department: Multivalue; default all
  • Article area: Multivalue; default all
  • Article group: Multivalue; default all
  • Mix: Multivalue; default all
  • EAN list: Text input; default empty (comma-separated list of EAN codes)
  • Include VAT: Boolean; default true (toggles between amounts including/excluding VAT)
  • Expand all: Boolean; default false (when true, automatically expands all article groups to show store details)

Output:

Article sales statistics grouped by EAN with drill-down capability to individual store level. Report shows:

  • Summary row per article (EAN) with aggregated data across all stores
  • Detail rows per store showing individual store performance (visible when expanded)
  • Mix numbers and campaign information displayed as comma-separated lists when multiple values exist

Columns:

  • Retail Store: Article EAN and name (at summary level)
  • Articles: Article EAN and name (at detail level)
  • Quantity: Total quantity sold
  • Customers: Distinct receipt count (number of customers)
  • Mix: Mix numbers and names (comma-separated if multiple mixes apply to the article-store combination)
  • Campaigns: Campaign numbers and names (comma-separated if multiple campaigns apply)
  • Turnover: Total sales amount (with or without VAT based on Include VAT parameter)
  • Sold in Promotion: Quantity sold with discounts/campaigns (calculated as: Total Quantity - Quantity Not Discounted)
  • % of Total Sales: Percentage of article turnover compared to total report turnover

Sorting:

  • Primary: EAN (ascending)
  • Secondary: Retail Store Number (ascending)

Clarifications:

  • Quantity Not Discounted logic: Shows quantity only when Mix is 1, -1, or Unknown AND Campaign is Adhoc, NoCampaign, Not Available, or Unknown. Otherwise returns NULL.
  • Mix and Campaign Display: Uses LookupSet function to aggregate multiple mixes/campaigns per article-store combination with "|" delimiter for matching
  • Parameter Dependencies: Store parameter options are dynamically filtered based on Team selection

Source:

  • Lindbak POS Reporting Cube (OLAP)

Anchor
4000_ItemSaleQuantityReport
4000_ItemSaleQuantityReport

...