Versions Compared

Key

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

...

Expand
title0781_CashierStatisticsWithDiscount

[RTC-44550] [YXB] New cashier statistics report (0781) with Fuel column (CO-344179)

PIC - TO BE UPDATEDImage Added

Description:

  • Report allows to follow up Cashiers sales and selected activities (based on: 0019)

Selections:

  • Date from: Default today
  • Date to: Default today
  • Retail store: Default all
  • Operator: Default all
  • Include VAT: Allows to decide if Vat is included in sales amount or not; default yes.

Hidden parameters: 

  • pFuelItemType - Item type number used to identify fuel items - Default: [Article].[Item Type].&[10]
  • pDiscountKeys - Discount keys to include in discount statistics - Default: [Discount].[Discount Key].[ALL]
  • pExcludeStores - Store numbers to be excluded from the report - Default: 9997,9998,99900,99901

Output:

One page per store - one row per cashier

Columns:

  • No: Operator number
  • Name: Operator name
  • Turnover inc VAT/ Turnover ex VAT - total turnover, except for fuel items (items of type fuel - defined in hidden parameter pFuelItemType)
  • Fuel inc VAT/Fuel ex. VAT - total turnover for fuel items (items of type fuel - defined in hidden parameter pFuelItemType)
  • Receipts: number of reciepts
  • Returns
  • Deleted receipts
  • Deleted item lines
  • Receipts on hold
  • Deleted on hold
  • Null: Number of drawer opening without any transaction
  • Ovr. prc.: Overriden price count
  • Manual Discount Amount
  • Manual Discoun percent.: Discount Amount divided by Original amount
  • Scan: Number of scanned articles
  • Discount: Discount quantity
  • Scan %: Scan divided by Quantity of sold items

Sorting:

  • No sorting

Source:

  • Lindbak POS Reporting cube (OLAP)


...