Versions Compared

Key

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

...

Expand
title0503_Nonsale_std

Standard report

Description:

Report allows to follow up daily sales nonsales statistics per item per one of following: Store/Profile/Team/TotalStore 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 num
  • Sotre 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
  • Last year

Sorting:

  • Pages by store
  • Rows by date

Source:

  • Lindbak POS Reporting cube (OLAP)


Anchor
0504_KeyFigures_std
0504_KeyFigures_std

Expand
title0504_KeyFigures_std

Standard report

Image Added

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: Default Monady 
  • Statistics: There you can set on which level you want your sales grouped
    • Item Subgroup sales
    • Item Group sales
    • Item Area sales
    • Department sales
    • Store sales
  • Sales Ex. VAT: Yes/No
  • Department: Default all
  • Article area: Default all
  • Article group: Default all
  • Article subgroup: Default all
  • Team: Default all
  • Profile: Defaul all
  • Retail store: Default all

Output:

One row per selected level in Statistics parameter.

Columns: 

  • EAN
  • Item name
  • 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 amount

Sorting:

  • Pages by store
  • Rows by date

Source:

  • Lindbak POS Reporting cube (OLAP)


...