Versions Compared

Old Version 28

changes.mady.by.user Unknown User (wojsy@eg.dk)

Saved on

compared with

New Version 29

changes.mady.by.user Unknown User (wojsy@eg.dk)

Saved on

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
  • 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:

  • 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%

Source:

  • Lindbak POS Reporting cube (OLAP)


Anchor
0519_LoyaltyStatistics
0519_LoyaltyStatistics

...

Expand
title0752_SalesStatistics

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 group
  • Item Area number - 
  • Item Group number
  • EAN

Clarifications:

  • Hour selection applies to each day in selected date period

Source:

  • Lindbak POS Reporting cube (OLAP)

Anchor
0755_TopSalesPerItem
0755_TopSalesPerItem

Expand
title0755_TopSalesPerItem

Description:

Report allows to find given number of best or worst selling items on multiple levels (amount, quantity, gross profit) in two date intervals. Possible to select specific hourly interval.

Selections: 

  • Date from - Default today
  • Date to - Default today
  • Compare date from - Default the same day of week as Date from year before
  • Compare date to- Default the same day of week as Date to but year before
  • 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
  • Number of items - Number of best or worst items to display - default 10
  • 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
  • Vendor - default all
  • Subvendor- default all
  • Include VAT - Default on
  • Exclude groups - Default false
  • Excluded groups - Appears when Exclude groups is switched to true

Output:

Sale statistics for selected number of best or worst items per store sorted by selected sort measure devided in two selected date intervals in selected hour range.

Columns: 

  • Store
  • Dept. - Department
  • Area
  • Grp. - Item group
  • EAN
  • Item name
  • Quantity
  • Turnover ex. VAT
  • Gross profit
  • Gross profit %
  • Num of receipts

Sorting:

  • Selected sort measure

Clarifications:

  • Hour selection applies to each day in selected date period

Source:

  • Lindbak POS Reporting cube (OLAP)
  • Lindbak POS Reporting DW

Anchor
0756_CreditSalesWithPaymentsOnAccount
0756_CreditSalesWithPaymentsOnAccount

Expand
title0756_CreditSalesWithPaymentsOnAccount

Image Added

Description:

Report shows credit sales and payments on account to get a better overview over drive-offs.


Report name: Credit sales with payments on account
Filename: 0756_CreditSalesWithPaymentsOnAccount
Datasource:  Database "Lindbak POS Reporting DW"


Parameters:

  • Date from - showing transaction between and including Date from and Date to,
  • Date to - showing transaction between and including Date from and Date to,
  • Team - filters stores within selected team,
  • Retail store - store selection.

Rows: one row per transaction group by store and customer; total for each store.

Columns: 

  • Date - date of the transaction,
  • Receipt - receipt number of the transaction,
  • Ref.no - reference number of the credit tender transaction,
  • Ref.text - reference text of the credit tender transaction,
  • Amount - amount of the credit tender transaction,
  • Tax amount - VAT amount from articles,
  • On account - payments when using payment on account function in POS.


Source:

  • Lindbak POS Reporting DW