Page History

Standatd report

Description:

Report allows to find given number of best or worst selling items per store, per cashier on multiple levels (amount, quantity, net cost, gross profit).

Selections: 

• Date from - : Default today
• Date to - : Default today
• Store - Retail store: Default all
• Number of items - : Number of best or worst items to display - default 5
• Sort type - : worst or best - report will display given number of worst or best selling items - default best
• Sort measure - : amount/quantity/net cost/gross profit/gross profit % - set the measure on which the items are sorted. - default amount
• Article group - : Default all

Output:

One page per each store. One section per each cashier. Inside the section selected number of best (or worst) selling items for given cashier.

Columns:

• Qunatity
• Amount: Sales amount inc. VAT
• Net Cost
• Gross profit
• Gr. profit %: Share of Gross profit in Net amount

Sorting:

• Selected sort measure

Source:

• Lindbak POS Reporting cube (OLAP)

CO based on report 0714

Description:

Report allows to follow up article sales on multiple levels with possibility to select specific hourly intervals and exclude specific item groups.

Selections: 

• Date from - Default today
• Date to - Default today
• Hour from - Default 0:00
• Hour to - Default 24:00
• Team - Default all
• Store - Default all
• Department - Default all
• Article area - Default all
• Article group - Default all
• Include VAT - Default on
• Exclude groups - Default false
• Excluded groups - Appears when Exclude groups is switched to true

Output:

Article sale statistics for selected stores, for selected date interval and for selected time interval grouped by department, area and group.

By default data is shown for department and it is possible to drill down to item level manually by clicng plus button or by using expand all button to expand everithing to item level at once.

Columns: 

• Buttons for expanding and collapsing all drilldowns.
• EAN - EAN code
• Item name - Article name
• Quantity
• Total- Quantity sold
• Turnover inc. VAT or Turnover ex. VAT depending on selection.
• Total - Amount sold. Inc. or ex. VAT depending on selection
• Share - Share of this department / area / group / item related to total sale.
• Cost price - Cost price
• Gross profit
• Total - Gross profit amount
• Total % - Gross profit percentage.

Sorting:

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

Clarifications:

• Hour selection applies to each day in selected date period

Source:

• Lindbak POS Reporting cube (OLAP)