Standard report
Description: Report gives detailed sales statistics with campaign information. 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).
- Price channels: Multivalue; default all
Output: Sale statistics for all items with not null sale amount narrowed down only by selections. One row per item. Totals in the begining of new hierarchy level for: - Store
- Department
- Item area
- Item group
- Subgroup
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 for 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 %: on item level it is share of campain sales for given item in all sales for the item (Campaign sale / Turnover with tax Total). On totals level: sum of Campaign sale % from item level which doesn't sum up to 100%
- 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: Hidden parameters: - pAllowedPriceChannelsKeys: Default all. If changed it will narrow down possible Price channel selection
- pUseLongItemText: Default false. If set to true Item name will be changed to Article Long Name
Source: - Lindbak POS Reporting cube (OLAP)
|