Standard report
Description: Report allows to follow up nonsales statistics per item per Store or all stores. Selections: - Date from: Default today
- Date to: Default today
- Week day from: Default Monady
- Week day to: Default Sunday - Report will show data only for selected week days
- Accumulation - Store/Profile/Team/Total/Vendor - Should make report show statistics per selected accumulation. If total is selected, the report shows sales per day per all stores. Now only Store and total are working correctly
- Team: Default all
- Profile: Defaul all
- Retail store: Default all
- Department: Default all
- Article area: Default all
- Article group: Default all
- Article subgroup: Default all
- Vendor: Default all
- Assortment: Default all
- EAN from: Default all
- EAN to: Default all - range of ean can be manually set here
- Item ID from: Default all
- Item ID to: Default all - range of Item ID can be manually set here.
- Tandem: Dafault yes, if switched to no, then instead of EAN, Main EAN is shown in EAN column.
Output: One page per selected accumulation(Store/Total) One row per Article (EAN or Main EAN if tandem switched to no) Article statistics are grouped on multile levels: Subgrouo, Group, Area, Department and Columns: - Store numEAN
- Sotre Item name
- Profile
- Day
- Week
- Month
- Year
- Dept no
- Dept name
- Area no
- Area name
- Sgr. no
- Subgr. name
- This year:
- Sales ex. VAT(inc. VAT if Sales ex VAT set to No)
- Gross profit
- Camp w. VAT
- Camp gr. prof.
- Items
- Quantity
- Ex. VAT Amount
- Ex. VAT Total %: Share of sales on given item(dept/area/group) to total store sale
- Gross profit Amount
- GP %: Share of gross profit in net amountLast year
Sorting: - Pages by store
- Rows by date
Source: - Lindbak POS Reporting cube (OLAP)
|