Description: Report gives detailed sales statistics with campaign sales statistics per article with grouping only per store. Selections: - Date from: Default today
- Date to: Default today
- Retail store: Multivalue; default all
- Profile: Multivalue; default all
- Department: Multivalue; default all
- Article area: Multivalue; default all
- Article group: Multivalue; default all
- Article subgroup: Multivalue; default all
- Article identifier: Possible to select Item ID or Model (ModelKey).
Output: Sale statistics for all items with not null sale amount narrowed down only by selections. One row per item. One page per store. Columns: - EAN
- Model/ItemID: Article identifier (Item ID or ModelKey)
- Item name: Item name (will change to Article Long Name if pUseLongItemText was switched true)
- Quantity sold Total
- Quantity sold Campaign: Sold item quantity in campaigns with discount keys: CampaignPrice, Group, MemberPrice
- Turnover with tax Total
- Turnover with tax Share: Share of sales amount inc. VAT for given item (group, area, ...) in all sales for given store.
- Campaign sale Total: Sale amount inc. VAT for campaigns with discount keys: CampaignPrice, Group, MemberPrice
- Campaign sale %: Share of campain sales for given item in all sales for the item (Campaign sale / Turnover with tax Total)
- Gross profit Total
- Gross profit Total %: Share of Gross profit in Net Amount
- Gross profit % exc. campaign: Share of gross profit for all sales except campaigns in Net amount for all sales except campaigns
- Gross profit Campaign: Gross profit for Campaign sale Total
- Gross profit Campaign %: Gross profit Campaign/ Net Amount for campaign sales
Sorting: Source: - Lindbak POS Reporting cube (OLAP)
| 
