Versions Compared

Old Version 293

changes.mady.by.user Mateusz Kobylka

Saved on

compared with

New Version 294

changes.mady.by.user Mateusz Kobylka

Saved on

Key

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

...

Expand
title0780_DailyReport

Standard report


Description:

Report allows to follow up sales in a specified store: comparing fuel and non fuel articles on all product groups, selected tender measures, VAT and measures like: cash balance, card movements, card sales and shift statistics. Depending on number of results it can be multi page. Report is divided in 8 subreports which will be descriped separatly below.

Selections (applies to all subreports): 

  • Date from: Default yesterday
  • Date to: Default yesterday
  • Store: Single value; Default first available from the list.

Hidden parameters: 

  • pFuelItemType - Item type number used to identify fuel items - Default: [Article].[Item Type].&[10]
  • pPriceChannelOutdoor - Price channel number (in Reporting) used to identify outdoor sales - Default: [Price Channel].[Price Channel].&[11]
  • pReasonCodeBreakage - Reason code name used to identify Driveoff - Default: [Reason Code].[Reason Code].&[Avstikk]&[Return]

Subreports:


Expand
title1801_subItemGroupSales

Columns:

  • Item Group Name
  • Item Group Number
  • Quantity
  • Amount

Rows:

  • One row per item group with divide to fuel and non fuel.
  • Subtotal: Total for all rows above Subtotal

______________________________________________________________________________________

  • Total
Expand
title1802_subProductSales

Columns:

  • Item Group Name
  • Item Group Number
  • Quantity
  • Amount

Rows:

  • Subtotal Fuel
  • Subtotal Non Fuel

______________________________________________________________________________________

  • Total


Expand
title1803_subTenderSales

Columns:

  • Tender Type
  • Quantity
  • Amount

Rows:

  • Cash
  • Outdoor Cash
  • Indoor Cash
  • Credit
  • Other
  • Rounding

_____________________________________________________________________________________

  • Total
Expand
title1804_subVAT

Columns:

  • VAT
  • Tax Amount
  • Net Amount
  • Amount

Rows:

  • One row per VAT with divide to fuel and non fuel.
  • Subtotal: Total for all rows above Subtotal

______________________________________________________________________________________

  • One row per VAT
  • Total 
Expand
title1805_subCardMovement

Columns: 

  • Tender Type
  • Quantity
  • Amount

Rows:

  • Card

  • Cashback

  • Station Credit Payment
  • In Payment

_____________________________________________________________________________________

  • Total
Expand
title1806_subCashBalance

Columns: 

  • Tender Type
  • Quantity
  • Amount

Rows:

  • Cash
  • Cashback
  • Drop
  • Paid In
  • Paid Out
  • Station Credit Payment

_____________________________________________________________________________________

  • Total (Cash - Cashback - Drop + Paid In + Paid Out(negative) - Station Credit Payment)
  • Balance Amount Cash

_____________________________________________________________________________________

  • Difference (Balance Amount Cash - Total)
Expand
title1807_subCardSales

Columns:

  • Card Number
  • Card Name
  • Quantity Outdoor
  • Amount Outdoor
  • Quantity Indoor
  • Amount Indoor
  • Quantity
  • Amount

Rows:

  • One row per Card

______________________________________________________________________________________

  • Total
Expand
title1808_subShiftStatistics

Columns: 

  • Tender Type Grouping
  • Tender Type
  • Quantity
  • Amount

Rows:

  • Return Transaction
    • Fuel
    • Non Fuel

_____________________________________________________________________________________

  • Subtotal (section above)

_____________________________________________________________________________________

  • Discounts
    • Manual
    • Automatic

_____________________________________________________________________________________

  • Subtotal (section above)

_____________________________________________________________________________________

  • Fillings
    • Post Pay
    • Outdoor Card

_____________________________________________________________________________________

  • SubTotal (section above)

_____________________________________________________________________________________

  • Miscellaneous
    • Cancelled Receipts
    • Drive Off
    • Pos Shift Count

Source:

  • Lindbak POS Reporting cube (OLAP)


Anchor
0781_CashierStatisticsWithDiscount
0781_CashierStatisticsWithDiscount

Expand
title0781_CashierStatisticsWithDiscount

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

PIC - TO BE UPDATED

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)


Anchor
0790_CashierStatistics
0790_CashierStatistics

...