Page History

...

Expand

title	Expand all reports at once

It is external simple extension to expand all reports below at once.

In web browser create new bookmark "Add page..."
In URL paste: javascript:(function()%7B%24(".expand-control").each(function()%7B %24(this).trigger("click")%3B%7D)%7D)()
Save bookmark

Thanks to this solution all report will expand at once after clicking bookmark. Now searching by CTRL+F is much simpliersimpler.

Anchor

	0001_ArticlesPerOperator
	0001_ArticlesPerOperator

...

Expand

title	0004_OperatorStatisticsPerStore_DW

Standard report

Description:

Report is devided divided one page per store and shows cashiers sale statistics. On the last page there is summary for all selected stores.

Selection:

Date from: Default today
Date to: Default today
Retail Store: Default all, multivalue (possibility to select more than one store)
Operator: Default all, multivalue (possibility to select more than one operator)

Output:

One row per one cashier showing his/her sales performance
On the last page: one row per store without division per cashier

Columns:

Number: Cashier number
Cashier name
Number: Quantity of sold items
Cust#: Number of receipts
Sales amount: Sales amount inc. VAT
Discount %: Share of discount in original price
Gr. prof.%: Share of Gross profit in Net amount.
Gross profit
Price pr. Art.: (Sales amount) / (Number (of all items sold))
Sale pr. cust.: (Sales amount) / (Cust#)
Items pr. Cust.: (Number (of all items sold)) / (Cust#)

Sorting:

Pages (stores) by store number
Rows:
- Number (of items sold) - interactive
- Gross profit - interactive

Source:

Lindbak POS Reporting DW

...

Expand

title	0005_SalesPerVendorPerOperator

Standard report

Description:

Report allows to follow up sales statistics per cashier and per vendor (supplier). Report is devided sections per each selected cashier. Each section shows sales statistics per vendor.

Selection:

Date from: Default today
Date to: Default today
Retail store: Default firts first from store list
Operator: Default all

Output:

One section per each cashier showing sales statistics divided per each vendor (supplier) with not null sale amount.

Columns:

Vendor number
Vendor name
Items: Quantity of sold items
Discount %: Share of discount in original price
Gross profit
Gr. prof.%: Share of Gross profit in Net amount.
Sales amount: Sales amount inc. VAT

Source:

Lindbak POS Reporting cube (OLAP)

...

Expand

title	0006_SalesPerVendorPerOperator_DW

Standard report

Description:

Report allows to follow up sales statistics per cashier and per vendor (supplier). Report is devided divided sections per each selected cashier. Each section shows sales statistics per vendor.

Selection:

Date from: Default today
Date to: Default today
Retail store from: Default first from store list
Retail store to: Default first from store list
Operator from: Default 0
Operator to: Default 999999

Output:

One page per store. One section per each cashier showing sales statistics divided per each vendor (supplier) with not null sale amount.

Columns:

Vendor number
Vendor name
Items: Quantity of sold items
Discount %: Share of discount in original price
Gross profit
Gr. prof.%: Share of Gross profit in Net amount.
Sales amount: Sales amount inc. VAT

Source:

Lindbak POS Reporting DW

...

Expand

title	0780_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

title	1801_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

title	1802_subProductSales

Columns:

Item Group Name
Item Group Number
Quantity
Amount

Rows:

Subtotal Fuel
Subtotal Non Fuel

______________________________________________________________________________________

Total

Expand

title	1803_subTenderSales

Columns:

Tender Type
Quantity
Amount

Rows:

Cash
Outdoor Cash
Indoor Cash
Credit
Other
Rounding

_____________________________________________________________________________________

Total

Expand

title	1804_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

title	1805_subCardMovement

Columns:

Tender Type
Quantity
Amount

Rows:

Card
Cashback
Station Credit Payment
In Payment

_____________________________________________________________________________________

Total

Expand

title	1806_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

title	1807_subCardSales

Columns:

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

Rows:

One row per Card

______________________________________________________________________________________

Total

Expand

title	1808_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

title	07900781_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 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

Expand

title	0790_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:
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

title	0791_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

...

Space shortcuts

Page tree

Versions Compared

Old Version 291

New Version Current

Key