Versions Compared

Old Version 292

changes.mady.by.user Lise Berntsen

Saved on

compared with

New Version Current

changes.mady.by.user Atle Olaf Hanssen

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
07900781_CashierStatisticsCashierStatisticsWithDiscount0790
0781_CashierStatisticsCashierStatisticsWithDiscount

Expand
title07900781_CashierStatisticsCashierStatisticsWithDiscount

[RTC-39849] TRN: Cashier security statistics report with turnover split and price checks - EG A/S44550] [YXB] New cashier statistics report (0781) with Fuel column (CO-344179)

Image AddedImage Removed

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

- 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 pFuelItemTypeTender (NB! this is tender data and does not represent turnover).
  • Cash
    • Other (ohter than cash)
  • 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 articlesScan %: Scan divided by Quantity of sold items
  • Discount: Discount quantityPrice check: How many times price check funtion is used.
  • Scan %: Scan divided by Quantity of sold items

Sorting:

  • No sorting

Source:

  • Lindbak POS Reporting cube (OLAP)


Anchor
0790_CashierStatistics
0790_CashierStatistics

Expand
title0790_CashierStatistics

[RTC-39849] TRN: Cashier security statistics report with turnover split and price checks - EG A/S

Image Added


Description:

  • Report allows to follow up Cashiers sales and selected activities.

Selections:

  • Date from: Default today
  • Date to: Default today
  • Retail store: Default all
  • Operator: Default all

Output:

One page per store

One row per cashier

Columns:

  • No: Operator number
  • Name: Operator name
  • Tender (NB! this is tender data and does not represent turnover).
    • Cash
    • Other (ohter than cash)
  • Receipts: number of reciepts
  • Returns
  • Deleted receipts
  • Deleted item lines
  • Receipts on hold
  • Null: Number of drawer opening without any transaction
  • Ovr. prc.: Overriden price count
  • Scan %: Scan divided by Quantity of sold items
  • Discount: Discount quantity
  • Price check: How many times price check funtion is used.

Sorting:

  • No sorting

Source:

  • Lindbak POS Reporting cube (OLAP)


Anchor
0791_ShiftBalanceReport
0791_ShiftBalanceReport

Expand
title0791_ShiftBalanceReport

[RTC-44692] [TRN] Shift balance report (CO-335148)

PIC - TO BE UPDATED


Description:

  • The report gives an overview of all shifts in the selected date range and for selected store(s) and workstations.

Selections:

  • Date from: default today
  • Date to: default today
  • Retail store: default all
  • Workstation: default all
  • Main currency (hidden): default NOK - the main currency for cash calculations.

Output:

The report consist of four tables:

  • Shift overview - lists all shifts in the selected date range and for given store(s) and cash registers and contains the details about each shift balance (if registered). 
  • Currency - lists all currencies (except the main currency), their exchange rates and amount in main currency
  • VAT overview - lists all VAT rates with sales gross, net and tax amount 
  • Payment card overview - lists all payment cards and related statistics (number of transactions and amount)

Columns:

  • Shift overview
    • Store - store number,
    • ShiftID - ID of the shift,
    • Shift date - shift start date,
    • Balance receipt ID - ID of the balance receipt for given shift,
    • Cashier No - cashier number,
    • All tenders - total tender amount for given shift,
    • Card - total amount paid by cards for given shift (tender types: CreditDebit, ECreditDebit, CreditDebitOffline),
    • Cash - total amount paid by cash in main currency for given shift,
    • Other - other tender types, aggregated, for given shift
    • Currency - total amount paid by cash in foreign currencies (all except main currency) for given shift,
    • Counted cash - balance amount of cash tender type in main currency for given shift,
    • Counted currency - balance amount of cash tender type in foreign currencies for given shift,
    • Difference: (Counted cash - Cash) + (Counted currency - Currency)
    • Bag number - bag number registered on the balance receipt
  • Currency
    • Code - currency code (3 letter code),
    • Exchange rate - the average exchange rate for selected period,
    • Currency amount - amount in currency,
    • Amount in XXX - amount in main currency (default NOK)
  • VAT overview
    • VAT rate,
    • Sales inc. VAT,
    • VAT amount,
    • Sales excl. VAT,
    • Nonsale
  • Payment card overview:
    • Card - card issuer ID and name,
    • Quantity - number of transactions,
    • Amount - total amount of transactions

Sorting:

  • Shift overview - sorted by store number and shift date (ascending),
  • Currency - sorted by currency code (A to Z),
  • VAT overview - sorted by VAT rate (ascending),
  • Payment card overview - sorted by card issuer ID (ascending)

Source:

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


Anchor
0800_TopXArticlesSold
0800_TopXArticlesSold

...