Standard report
Description: Report gives detailed sales statistics with campaign sales statistics included with easier access to needed information than 0012. 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).
- Subvendor: Multivalue; default all
- Vendor: Multivalue; default all
- EAN list: Allows to add specific items ignoring other selections; default blank
- Expand to: Expands drill down to selected level; default Area
- Include Nonsale: If Include Nonsale was box checked, nonsale data will be included to statistics.
- Price channels: Multivalue; default all
Output: Sale statistics for all items with not null sale (or sale + nonsale if include nonsale box checked) 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: if you clicked on item group you would be moved to report 0014_SalesStatisticsPrArticles_std with saved selections and you will be able to see sales statistics for items in given 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 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: Hidden parameters: - pAllowedPriceChannelsKeys: Default all. If changed it will narrow down possible Price channel selection
Source: - Lindbak POS Reporting cube (OLAP)
|