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 1
  • Retail store to - : Default 1
  • 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 1
  • Retail store to - : Default 1
  • 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 DWcube (OLAP)


Anchor
0004_OperatorStatisticsPerStore_DW
0004_OperatorStatisticsPerStore_DW

Expand
title0004_OperatorStatisticsPerStore_DW


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: Default all, multivalue (possibility to select more than one store)
  • Operator: Default all, multivalue (possibility to select more than one operator)

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 DW

Anchor
0005_SalesPerVendorPerOperator
0005_SalesPerVendorPerOperator

Expand
title0005_SalesPerVendorPerOperator

Image Added

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


Anchor
0057_NonsalePerOperator
0057_NonsalePerOperator

...