Versions Compared

Key

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

...

Expand
title0002_ArticlesPerOperator_DW

Standard report

Description:

  • Report allows to follow up cashiers sale performance.

Selections:

  • Date from: Default today
  • Date to: Default today
  • Retail store from: Default 1first from store list
  • Retail store to: Default 1first from store list
  • Operator from: Default 0
  • Operator to: Default 999999

Output:

Item sale statistics showed individually per each cashier (with number between Operator from and Operator to) per each stores (with number between Retail store from and Retail store to).

Additionally there are totals for each cashier and each store.

Columns:

  • EAN
  • Item name
  • Quantity
  • Discount % - Share of discount amount in original prize
  • Gross profit
  • Gross profit % - (gross profit)/(sales ex. VAT)
  • Sales amount - sales inc. VAT

Sorting:

  • EAN (default)
  • Qunatity (interactive)
  • Gross profit (interactive)

Source:

  • Lindbak POS Reporting DW


...

Expand
title0003_OperatorStatisticsPerStore

Standard report

Description:

Report is devided one page per store and shows cashiers sale statistics. On the last page there is summary for all selected stores.

Selection:

  • Date from: Default today
  • Date to: Default today
  • Retail store from: Default 1first from store list
  • Retail store to: Default 1first from store list
  • Operator from: Default 0
  • Operator to: Default 999999

Output:

  • One row per one cashier showing his/her sales performance
  • On the last page: one row per store without division per cashier

Columns:

  • Number: Cashier number
  • Cashier name
  • Number: Quantity of sold items
  • Cust#: Number of receipts
  • Sales amount: Sales amount inc. VAT
  • Discount %: Share of discount in original price
  • Gr. prof.%: Share of Gross profit in Net amount.
  • Gross profit
  • Price pr. Art.: (Sales amount) / (Number (of all items sold))
  • Sale pr. cust.: (Sales amount) / (Cust#)
  • Items pr. Cust.: (Number (of all items sold)) / (Cust#)

Sorting:

  • Pages (stores) by store number
  • Rows:
    • Number (of items sold) - interactive
    • Gross profit - interactive

Source:

  • Lindbak POS Reporting cube (OLAP)


...

Expand
title0006_SalesPerVendorPerOperator_DW

Standard report

Description:

Report allows to follow up sales statistics per cashier and per vendor (supplier). Report is devided sections per each selected cashier. Each section shows sales statistics per vendor.

Selection:

  • Date from: Default today
  • Date to: Default today
  • Retail store from: Default 1first from store list
  • Retail store to: Default 1first from store list
  • Operator from: Default 0
  • Operator to: Default 999999

Output:

  • One page per store. One section per each cashier showing sales statistics divided per each vendor (supplier) with not null sale amount.

Columns:

  • Vendor number
  • Vendor name
  • Items: Quantity of sold items
  • Discount %: Share of discount in original price
  • Gross profit
  • Gr. prof.%: Share of Gross profit in Net amount.
  • Sales amount: Sales amount inc. VAT

Source:

  • Lindbak POS Reporting DW


...