Versions Compared

Old Version 325

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
title0783_DailyReportVat

Standard report

Description:

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

  • Date from: Default yesterday
  • Date to: Default yesterday  
  • Retail store: 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

Columns:

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

Rows:

  • Subtotal Fuel
  • Subtotal Non Fuel

______________________________________________________________________________________

  • 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 = 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

Columns:

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

Rows:

  • One row per Card

______________________________________________________________________________________

  • Total
Expand
title1809_subItemGroupSalesVat

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

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

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

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.)

h4. Source:
* Lindbak POS Reporting Cube (OLAP) - All sections except Item Group Driveoff
* Lindbak POS Reporting DW - Item Group Driveoff section only

h4. Technical Notes:
* Report uses RSToolkit for language localization via User!Language
* Date parameters converted using Code.RSToolkit.ToTimeHierarchyString
* Multiple subreports with conditional visibility based on data availability
* Visibility logic: Rows/sections hidden when amounts are null or zero
* Report displays one page per selected store
* Footer displays "0780_DailyReport" (report name), page numbers, and current datetime


Anchor
0790_CashierStatistics
0790_CashierStatistics

...

Expand
title0951_SecurityReport_DW

RTC-52380

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.

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 today
  • Date to: Default 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)

Anchor
4000_ItemSaleQuantityReport
4000_ItemSaleQuantityReport

...