Versions Compared

Old Version 323

changes.mady.by.user Atle Olaf Hanssen

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
title0781_CashierStatisticsWithDiscount

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

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
07900783_CashierStatisticsDailyReportVat0790
0783_CashierStatisticsDailyReportVat

Expand
title07900783_CashierStatisticsDailyReportVat

Standard report

Image Added

Image Added

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

Image Removed

Description:

Report

allows to follow up Cashiers sales and selected activities.

provides comprehensive daily settlement and sales statistics per store. Similar to 0780_DailyReport but with enhanced VAT breakdown. Report is divided into multiple sections showing product sales, tender types, cash reconciliation, card payments, and drive-off tracking.

Selections (applies to all sub reports)Selections:

  • Date from: Default
    • today
  • yesterday
  • Date to: Default
    • today
  • yesterday  
  • Retail store:
    • Default all
  • Operator: Default all
  • Single value; default first available from the list

Hidden parameters:

  • pFuelItemType: Default \[Article\].\[Item Type\].&\[Fuel\] - Defines which item types qualify as fuel
  • pOtherPaymentCards: Default 30,31,32,33,34,35,36,37,38,39 - Payment card numbers for "other payments" section
  • pReasonCodeBreakage: Default \[Reason Code\].\[Reason Code\].&\[Avstikk\]&\[Return\] - Reason code for drive-off tracking
  • pPriceChannelOutdoor: Default \[Price Channel\].\[Price Channel\].&\[11\] - Price channel qualifying as outdoor sales

Source:

  • Lindbak POS Reporting Cube (OLAP) - All reports
  • Lindbak POS Reporting DW - 1812, Item Group Driveoff section only


Expand
title1802_subProductSales

Image Added

Columns:

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

Rows:

  • Subtotal Fuel
  • Subtotal Non Fuel

______________________________________________________________________________________

  • Total


Expand
title1804_subVAT

Image Added

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

Image Added

Columns: 

  • Tender Type
  • Quantity
  • Amount

Rows:

  • Card

  • Cashback

  • Station Credit Payment
  • In Payment

_____________________________________________________________________________________

  • Total
Expand
title1806_subCashBalance

Image Added

Columns: 

  • Tender Type
  • Quantity
  • Amount

Rows:

  • Cash = TenderAmount for TenderType.Cash - ControlAmount for TenderControlType.PayedIn + ControlAmount for TenderControlType.PayedOut
  • Drop = ControlAmount for TenderControlType.Drop
  • Paid In = ControlAmount for TenderControlType.PayedIn
  • Paid Out = ControlAmount for TenderControlType.PayedOut
  • Cashback = TenderAmount for TenderType.CashBack
  • Station Credit Payment = TenderAmount for TenderControlType.Cash and TenderControlType.PaymentOnAccount

_____________________________________________________________________________________

  • Total (Cash - Cashback - Drop + Paid In + Paid Out(negative) - Station Credit Payment)
    = TenderAmount for TenderType.Cash - This is sum of all cash sales from tender except controltransactions.
    - ControlAmount for TenderControlType.Drop - Sum of all cash sales from tender with controltransaction Drop
    + ControlAmount for TenderControlType.PayedIn - Sum of all cash sales from tender with controltransaction PayedIn
    - ControlAmount for TenderControlType.PayedOut - Sum of all cash sales from tender with control transaction PayedOut
    + TenderAmount for TenderType.CashBack (negative value)
    - TenderAmount for TenderControlType.Cash and TenderControlType.PaymentOnAccount
  • Balance Amount Cash = BalanceAmount for TenderType.Cash

_____________________________________________________________________________________

  • Difference (Balance Amount Cash - Total)
Expand
title1807_subCardSales

Image Added

Columns:

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

Rows:

  • One row per Card

______________________________________________________________________________________

  • Total
Expand
title1809_subItemGroupSalesVat

Image Added

Columns:

  • Item Group Name
  • Item Group Number  
  • VAT: VAT percentage
  • Quantity: Sold quantity
  • Amount: Sales amount inc. VAT
  • Type: Fuel or Non-Fuel classification

Grouping:

  • Data grouped by Fuel vs Non-Fuel products
  • Subtotals per fuel type
  • Grand total for all item groups
Expand
title1811_subTenderSales_2

Image Added

Columns:

  • Tender Type
  • Quantity: Number of transactions
  • Amount: Tender amount

Rows:

  • Cash: Cash payments (excluding control transactions)
  • Outdoor Card: Card payments via outdoor price channel
  • Indoor Card: Card payments via indoor price channels  
  • Station Credit: Station credit payments
  • Other: Other tender types
  • Rounding: Subtotal rounding amount
  • Total: Sum of all tender types


Expand
title1810_subTenderSalesOtherPayments

Image Added

Columns:

  • Tender Type: Payment card number and name
  • Quantity: Number of transactions
  • Amount: Tender amount

Rows:

  • One row per payment card included in pOtherPaymentCards parameter (default: cards 30-39)
  • Total row
  • Rows with zero amount are hidden
Expand
title1812_subItemGroupDriveoff

Image Added

Columns:

  • Item Group Name: Article group name
  • Amount: Total sales amount inc. VAT
  • Drive Off: Breakage amount (negative transactions)
  • Drive Off Paid: Sold/paid amount (positive transactions)  
  • Net Amount: Grand total (Amount + Drive Off + Drive Off Paid)

Rows:

  • One row per article group
  • Total row
  • Entire section hidden if both totals are zero

Clarifications:

  • Uses reason code from pReasonCodeBreakage parameter to identify drive-off transactions
  • Drive Off column shows negative values from item transactions
  • Drive Off Paid shows positive values from item transactions
  • Only includes fuel item types specified in pFuelItemType parameter

Sorting:

  • No interactive sorting
  • Data sorted by natural hierarchy (Store, Article Group, etc.)


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 (

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)


...

Expand
title0951_SecurityReport_DW

RTC-52380

Image Modified

Description:

  • Report allows to monitor security-sensitive activities performed by cashiers/
operators in the store, including manual discounts, returns, gift card transactions, and voucher usage
  • operators in the store, including manual discounts, returns, gift card transactions, and voucher usage.

Selections:

  • Date from: Default yesterday
  • Date to: Default yesterday
  • Retail store: Single select on store (because of performance). Default first available.
  • Operator: Default all operators for the selected store

Output:

Security activity statistics shown individually per each cashier security-relevant activities like manual discounts, returns, gift card sales/redemptions, and voucher usage with reference to receipt number.

Additionally there are totals for each operator and each store.

Columns:

  • Retail Store - Store identifier and name
  • Manual discounts - Sum of manual discount amounts (line and sub-total discounts)
  • Manual returns - Quantity of items returned without reference to original transaction
  • Online returns - Quantity of items returned with reference to original transaction
  • Giftcards out - Quantity of gift cards sold
  • Giftcards in - Count of gift card redemptions/usage
  • Voucher/coupon used - Count of voucher/coupon usage transactions

Sorting:

  • Retail Store (default)
  • Operator Display
  • Transaction ID

Source:

  • Lindbak POS Reporting DW - Data Warehouse database


Anchor
0952_ItemQuantityStores
0952_ItemQuantityStores

Expand
title0952_ItemQuantityStores

RTP-43325

Image Added

Description:

Report displays item quantity sales data aggregated by retail store with support for mix and campaign analysis. It provides detailed sales information including quantity sold, number of customers, turnover, and promotional sales breakdown. The report allows drill-down from article level to individual store performance.

Selections:

  • Date from: Default
yesterday
  • today
  • Date to: Default
yesterday
  • Retail store: Single select on store (because of performance). Default first available.
  • Operator: Default all operators for the selected store

    • Output:

    Security activity statistics shown individually per each cashier security-relevant activities like manual discounts, returns, gift card sales/redemptions, and voucher usage with reference to receipt number.

    Additionally there are totals for each operator and each store.

    Columns:

    • Retail Store - Store identifier and name
    • Manual discounts - Sum of manual discount amounts (line and sub-total discounts)
    • Manual returns - Quantity of items returned without reference to original transaction
    • Online returns - Quantity of items returned with reference to original transaction
    • Giftcards out - Quantity of gift cards sold
    • Giftcards in - Count of gift card redemptions/usage
    • Voucher/coupon used - Count of voucher/coupon usage transactions

    Sorting:

    • Retail Store (default)
    • Operator Display
    • Transaction ID

    Source:

    • today
    • Team: Multivalue; default all
    • Profile: Multivalue; default all
    • Store: Multivalue; default all (filtered by Team selection)
    • Department: Multivalue; default all
    • Article area: Multivalue; default all
    • Article group: Multivalue; default all
    • Mix: Multivalue; default all
    • EAN list: Text input; default empty (comma-separated list of EAN codes)
    • Include VAT: Boolean; default true (toggles between amounts including/excluding VAT)
    • Expand all: Boolean; default false (when true, automatically expands all article groups to show store details)

    Output:

    Article sales statistics grouped by EAN with drill-down capability to individual store level. Report shows:

    • Summary row per article (EAN) with aggregated data across all stores
    • Detail rows per store showing individual store performance (visible when expanded)
    • Mix numbers and campaign information displayed as comma-separated lists when multiple values exist

    Columns:

    • Retail Store: Article EAN and name (at summary level)
    • Articles: Article EAN and name (at detail level)
    • Quantity: Total quantity sold
    • Customers: Distinct receipt count (number of customers)
    • Mix: Mix numbers and names (comma-separated if multiple mixes apply to the article-store combination)
    • Campaigns: Campaign numbers and names (comma-separated if multiple campaigns apply)
    • Turnover: Total sales amount (with or without VAT based on Include VAT parameter)
    • Sold in Promotion: Quantity sold with discounts/campaigns (calculated as: Total Quantity - Quantity Not Discounted)
    • % of Total Sales: Percentage of article turnover compared to total report turnover

    Sorting:

    • Primary: EAN (ascending)
    • Secondary: Retail Store Number (ascending)

    Clarifications:

    • Quantity Not Discounted logic: Shows quantity only when Mix is 1, -1, or Unknown AND Campaign is Adhoc, NoCampaign, Not Available, or Unknown. Otherwise returns NULL.
    • Mix and Campaign Display: Uses LookupSet function to aggregate multiple mixes/campaigns per article-store combination with "|" delimiter for matching
    • Parameter Dependencies: Store parameter options are dynamically filtered based on Team selection

    Source:

    • Lindbak POS Reporting Cube (OLAP)
    Lindbak POS Reporting DW - Data Warehouse database

    Anchor
    4000_ItemSaleQuantityReport
    4000_ItemSaleQuantityReport

    Expand
    title4000_ItemSaleQuantityReport

    RTC-46626

    Image RemovedImage Added

    Description:

    Report shows number of sold items per day of week. Grouped by week.

    Selections:

    • From date - default first date of current week.
    • To date - default today
    • Team - default all
    • Retail store - default all
    • Department - default all
    • Article area - default all
    • Article group - default all
    • Article subgroup - default all
    • Vendor - default all

    Note that is is possible to select default e.g article groups by selecting group(s) in parameter pArticleGroup

    Output:

    One row for ean item with columns for each day of week. In addition one column for notes.

    Columns:

    • EAN - EAN
    • Item ID - Item number
    • Item name - Item name
    • Week - Week number
    • Monay - Friday - One column for each day
    • Remarks / Notes - Empty column.

    Source:

    Lindbak POS Reporting Cube (Olap)


    ...