Versions Compared

Key

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

...

Expand
title0458_SalesAndWaste

Description:

Report allows to follow up article sales and waste grouped per store and per (item group or item area).

Selections: 

  • Date from - Default today
  • Date to - Default today
  • Store - Default all
  • Article area - Default all
  • Article group - Default all
  • Reason Code - Default all
  • Grouping - item area or item group - Default Item area
  • Exclude items without breakage - Default false

Output:

Article sales and waste statistics grouped per store and per item group or item area sorted by highest Lost amount. There is a page break per each store and total all stores in the bottom of last page. If Exclude items without breakage parameter is set to true there will be only items with breakage.

Columns: 

  • Buttons for expanding and collapsing all drilldowns.
  • ItemNo - Item number
  • Item name - Article name
  • Sales quantity - number of sold items
  • Sales ex. VAT - sales amount
  • Net cost - net cost of sold items
  • Waste qty - number of broken items
  • Lost amount - net cost of broken items
  • Breakage % - share of Waste qty in Sales quantity
  • Lost amount % - share of Lost amount in Net cost

Sorting:

  • Department number - age group
  • Item Area number - 
  • Item Group number
  • EAN

Clarifications:

  • On all levels (store, area, group and item): by Lost amount from highest to lowest.

Clarifications:

  • If there are no sales on items with breakage, Breakage % and Lost amount % will be 100%Hour selection applies to each day in selected date period

Source: Lindbak POS Reporting cube (OLAP)


...