Page History

Image RemovedImage Added

Description:

Report lists sales per itemgroup.

Selections:

• EOD date from - Default select date from
• EOD date to - Default select date to

Output:

Report shows sales statistics for itemgroup in selected period of time and for selected store.

Columns:

• Item group
• Gr. name – Group name
• Quantity
• VAT class
• VAT %
• Ex. VAT – Excluding VAT
• VAT
• Sales w/VAT

Source:

• Lindbak POS Reporting DW
• Lindbak POS Message Service

RTP-33121

General report for item transaction. This report will show all item transactions with reason code.

Report is similar to 0541 without item number and two extra columns for net cost.

Source: 

• Lindbak POS Reporting cube ((OLAP) Item Transaction RealTime measure)

Selections:

• Date from - Default today
• Date to - Default today
• Store - Default All (if HQ user)
• Transaction type - Default All types. It is possible to removed transaction types from list with hidden parameter pTransactionTypesToExclude, see relevant parameters for details
• Reason code - Default all available codes. List shows only reasoncodes linked to selected transaction types. NB! Depending on Chain Web version. When you select transaction type, only first available reason code will be selected. Workaround for this is to de-select all reason codes before seleting transaction type(s).
• Absolute values - Default off. This will show all values as positive values. Used to get correct quantity when you have transactions with positive and negative values. Note that this will not affect sum of same item / reasoncode. Default selection can be changed in parameter pShowAbsoluteValues
• Grouping - Default Group.  This will decide on which level of hierarchy report is generated. Report always shows item, it will also show total for group, area, department and store depending on selection. Default selection can be changed in parameter pGrouping
• Department - To filter result on department
• Article area - To filter result on article area
• Article group - To filter result on article group

Relevant parameters:

• pTransactionTypesToExclude - Comma separated list of transactions types not to show in list of transaction types. E.g. If customer never uses transaction type Aricle Service and Inventory, put in Normal,ArticleSerivce,Inventory in string (Normal shoul always be excluded)
• pShowAbsoluteValues - To change default value for 'Absolute values' selection
• pGrouping - To change default value for 'Grouping' selection

Output:

List of item transactions with reason code

Columns (sum for store and each level of hierarchy. Sum total on last row):

• EAN - EAN of item
• Item name - Item name
• Transaction type - Transaction type
• Reason code - Reason code
• Date - Date of transaction
• Unit net code - Net cost per item
• Net price - Net price per unit
• Price w/VAT - Price including VAT per unit
• Quantity - quantity
• Net cost amount - Net cost for transaction
• Net amount - Net amount (Net price * Quantity)
• Amount w/VAT - Amount including VAT (Price w/VAT * Quantity)
• GP% - Gross profit in percentage

Clarifications:

• Action code is not supported, only reason code (action code not available in Olap (reporting v77))
• Report shows only item transactions from poslog (no Rigal)
• Showing absolute values for same item / reasoncode is not possible (reporting v77). Report will always show sum of same item / reasoncode even if there are positive and negative values.
  • Exampe: 
  • Image Added
  • Without absolute values Report will show Quantity = -3 which is correct
  • With absolute values report will show Quantity = 3, ideally it should split this into two lines

Image RemovedImage Added

Description:

Report lists shows sales and waste per articleaggregated by article group and VAT.

Selections:

• Periode – Default monthStore - Default select a single store
• Year – - Default current year
• Month from – Default current month
• Month to – Default current month
• Week from – Default current week
• Week to – Default current week
• Date from – Default today
• Date to – Default today
• Maingroup – Default all
• Year comparable – Default previous year
• Month from comparable – Default current month
• Week from comparable – Default current week
• Date from comparable – Default today
• Profile – Default all
• Team – Default all
• Store – Default select a multi value

Output:

• Totals in the beginning of new hierarchy level for:
  • Store
  • Month
  • Article group
  • Article subgroup
  • Article name

Columns:

• EOD Date from - Default selected date automatically
• EOD Date to - Default selected date atomatically
• Include nonsale - Default true

Output:

Report shows sales per itemgroup. Report shows three tables: fuel, bulk products and item sales. Report has summary for each table and total summary for all stores.

Columns:

• Item group
• Gr. name – Group name
• Quantity
• VAT class
• VAT % - VAT percentage
• Ex. VAT – Excluding VAT
• VAT
• Sales w/VAT – Sales with VAT
• Buttons for expanding and collapsing all drilldowns
• Item
• Period 1/Period 2
• Net amount
• Quantity
• Waste amount ex. VAT – Waste amount excluding VAT
• Waste qty – Waste quantity
• Gross profit after waste
Gross % after – Gross profit percentage after waste

Source:

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

Image RemovedImage Added

Description:

Report lists sales and waste per articleitem group sales with drilldown for selected stores

Selections:

• Periode – Default default month
• Year – Default current year
• Month from – Default current month
• Month to – Default current month
• Week from – Default current week
• Week to – Default current week
• Date from – Default today
• Date to – Default today
• Maingroup – Default all
• Year comparable – Default previous year
• Month from comparable – Default current month
• Week from comparable – Default current week
• Date from comparable – Default today
• Profile – Default all
• Team – Default all
• Store – Default select a multi valueall

Output:

• One page per store. Report has a summary on each column.
• Summary totals Report is based on report 0604 from RIGAL files. Totals in the beginning of  of new hierarchy level for store.

Columns:

• Store
• Month
Article Item group
• Article subgroup
• Article name

Columns:

• Buttons for expanding and collapsing all drilldowns
• Item
• Period 1/Period 2
  • Net amount
  • Quantity
  • Waste amount ex. VAT – Waste amount excluding VAT
  • Waste qty – Waste quantity
  • Gross profit after waste
  • Gross % after – Gross profit percentage after waste

• Sales – sales net amount
• Sales last year – Sales net amount last year
• Diff. – Difference for sales, total sales, customers, average sales and gross profit
• Diff. % - Difference percentage
• Total sales YTD – Total sales year to date
• Total sales YTD LY – Total sales year ro date last year
• Cust # - Number of customers
• Customers LY – Customers last year
• Average sale
• Average sale last year
• GP % - Gross profit percentage
• Gr. prof. % LY – Gross profit percentage last year
• GP – Gross profit
• GP LY – Gross profit last year

Clarifications:

Negative values are colored red.

Source:

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

Image RemovedImage Added

Description:

Report lists sales statistics about items in selected store and comparable store and their differenceper hour with counting customer inside and outside.

Selections:

• Period Periode – Default default month
• Year – Default current year
• Month from – Default current month
• Month to – Default current month
• Week from – Default current week
• Week to – Default current week
• Date from – Default today
• Date to – Default today
• Store Profile – Default select a single valueall
• Team Year comparable – Default last yearall
• Store Month from comparable – Default current monthMonth to comparable all
• Exclude groups – Default courrent month
• Week from comparable – Default last week
• Week to comparable – Default last week
• Date from comparable – Default same day last year ago
• Date to comparable – Default same day last year ago
• Store comparable – Default select a single value
• Vendor – Default all
• Producer – Default all Department – Default all
• Area – Default all Article group – Default all
• EANlist – Default empty

Output:

• Report has a total summary on the end of table for each column.
• Totals in the beginning of new hierarchy level for:
  • Department
  • Item area
  • Item group

Columns:

• false
• Excluded groups – Default list of excluded groups

Output:

• Report has a summary at the end of table on each column.
• Summary totals in the beginning  of new hierarchy level for store.

Columns:

• Hour – Hour of a day
• Sales – Sales amount
• Net cost
• VAT – VAT amount
• Gr. prof. % - Gross profit percentage
• Share
• Items – Sales quantity
• Quantity - Customer inside/Customer outside quantity
• Sale per customer - Customer inside/Customer outside sale per customer
• Sales/item – Sales amount divided by item quantity Items per customer
• Sales – Member/Campaign sales amount
• Items – Member/Campaign item quantity
• Customers – Member/Campaign customer count
• Buttons for expanding and collapsing all drilldowns
• EAN
• Item name
• Store/Comparable store in selected period of time
  • Net amount
  • Quantity
  • Gross profit
  • GP % - Gross profit percentage
• Difference
• Net amount
• Diff % - Difference percentage
• Quantity
• Gross profit
GP % - Gross profit percentage

Source:

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

Image RemovedImage Added

Description:

Report lists sales and waste per item.article

Selections:

• Store Periode – Default select a single storemonth
• Year – Default current year
• EOD Date Month from – Default empty, automatically selected date
• EOD Date to - Default empty, automatically selected date
• Include nonsale – Defualt true
• Article group – Default all

Output:

Report shows sales per item with summary for item groups and total summary for all item groups.

Columns:

• current month
• Month to – Default current month
• Week from – Default current week
• Week to – Default current week
• Date from – Default today
• Date to – Default today
• Maingroup – Default all
• Year comparable – Default previous year
• Month from comparable – Default current month
• Week from comparable – Default current week
• Date from comparable – Default today
• Profile – Default all
• Team – Default all
• Store – Default select a multi value

Output:

• Totals in the beginning of new hierarchy level for:
  • Store
  • Month
  • Article group
  • Article subgroup
  • Article name

Columns:

• Buttons for expanding and collapsing all drilldowns
• Item
• Period 1/Period 2
  • Net amount
  • Quantity
  • Waste amount ex. VAT – Waste amount excluding VAT
  • Waste qty – Waste quantity
  • Gross profit after waste
  • Gross % after – Gross profit percentage after waste
• EAN Item – Article name
• Quantity
• VAT class
• VAT % - VAT percentage
• Ex. VAT – Excluding VAT
• VAT
• Sales w/VAT – Sales with VAT

Source:

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

Image RemovedImage Added

Description:

Report lists sales and waste per departmentarticle

Selections:

• Store Periode – Default select a single storemonth
• Year – Default current year
• Month from – Default current month
• Month to – Default current month
• Week from – Default current week
• Week to – Default current week
• EOD Date from – Default empty, automatically selected datetodayEOD
• Date to - Default empty, automatically selected date
• Include nonsale – Defualt true

Output:

Report shows four tables: fuel, retail goods, automatic car wsa and groups. Each table has a summary and report has total summarize for all tables.

Columns:

• – Default today
• Maingroup – Default all
• Year comparable – Default previous year
• Month from comparable – Default current month
• Week from comparable – Default current week
• Date from comparable – Default today
• Profile – Default all
• Team – Default all
• Store – Default select a multi value

Output:

• Report is based on report 0604 from RIGAL files. Totals in the beginning of new hierarchy level for:
  • Store
  • Month
  • Article group
  • Article subgroup
  • Article name

Columns:

• Buttons for expanding and collapsing all drilldowns
• Item
• Period 1/Period 2
  • Net amount
  • Quantity
  • Waste amount ex. VAT – Waste amount excluding VAT
  • Waste qty – Waste quantity
  • Gross profit after waste
  • Gross % after – Gross profit percentage after waste
• Department – Department key
• Dept name – Department name
• Area no – Area number
• Area name
• Quantity
• VAT class
• VAT % - VAT percentage
• Ex. VAT – Sales amount without excluding VAT
• VAT
• Sales w/VAT – Sales with VAT

Source:

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

RTC-14247Image Added

Image Removed

Description:

Report lists sales per article group with breakagestatistics about items in selected store and comparable store and their difference.

Selections:

• EOD date from  - Default select a single date
• EOD date to – Default select a single date

Output:

Report shows sales per article group with breakage

Columns:

• Article Group – Article group key
• Article Group name
• Quantity
• VAT Class
• VAT % - VAT perentage
• Ex. VAT – Excluding VAT
• VAT
• Sales w/VAT – Sales without VAT
• Butikknr – Store number
• Dato – CSV Date
• Net cost
• Breakage
• Breakage Net

Source:

• Lindbak POS Reporting DW
• Lindbak POS Message Service

• Period – Default month
• Year – Default current year
• Month from – Default current month
• Month to – Default current month
• Week from – Default current week
• Week to – Default current week
• Date from – Default today
• Date to – Default today
• Store – Default select a single value
• Year comparable – Default last year
• Month from comparable – Default current month
• Month to comparable – Default courrent month
• Week from comparable – Default last week
• Week to comparable – Default last week
• Date from comparable – Default same day last year ago
• Date to comparable – Default same day last year ago
• Store comparable – Default select a single value
• Vendor – Default all
• Producer – Default all Department – Default all
• Area – Default all Article group – Default all
• EANlist – Default empty

Output:

• Report has a total summary on the end of table for each column.
• Totals in the beginning of new hierarchy level for:
  • Department
  • Item area
  • Item group

Columns:

• Buttons for expanding and collapsing all drilldowns
• EAN
• Item name
• Store/Comparable store in selected period of time
  • Net amount
  • Quantity
  • Gross profit
  • GP % - Gross profit percentage
• Difference
  • Net amount
  • Diff % - Difference percentage
  • Quantity
  • Gross profit
  • GP % - Gross profit percentage

Source:

Lindbak POS Reporting Cube (OLAP)

Image Added

CO-256310, RTC-30351

Image Removed

Description:

Report allows to follow up store settlement: on first page settlement for all selected workstations and settlement per each workstation on following pages. Report is divided in 16 subreports which will be descriped separatly below.

Selections (applies to all subreports):

• Date from - Default today
• Date to - Default todauy
• Store - Default all
• Workstation - Default all

Parameters:

• pExcludeDonationArticleGroups - Comma separated list of article groups to exclude from donations sectiton
• pIncludeArticleStockToRefund - Comma separated list of article groups to include in depositrefund section (deposit refund sold).

Clarifications:

Report is mostly based on 0016_StoreSettlementPerWorkstation_std report. Additionaly report contains new 1022_subPaymentCard report, GLN code for each store in title and multivalue selections for stores.

Subreports:

lists sales per department

Selections:

• Store – Default select a single store
• Year – Default current year
• EOD Date from – Default empty, automatically selected date
• EOD Date to - Default empty, automatically selected date
• Include nonsale – Defualt true

Output:

Report shows four tables: fuel, retail goods, automatic car wsa and groups. Each table has a summary and report has total summarize for all tables.

Columns:

• Department – Department key
• Dept name – Department name
• Area no – Area number
• Area name
• Quantity
• VAT class
• VAT % - VAT percentage
• Ex. VAT – Sales amount without excluding VAT
• VAT
• Sales w/VAT – Sales with VAT

Source:

• Lindbak POS Reporting DW

Source:

• Lindbak POS Reporting Cube (OLAP)

CO-273435262513 RTC-31644

Image AddedImage Removed

Description:

Report lists data from some of sections used in 0612. Output is to make it easier for exporting data to csv formatallows to follow up store settlement. On first page per store, data for all selected cash registers (if all cash registers are selected it equals whole store settlement) and settlement per each cash register on following pages. Report is divided in subreports which will be descriped separatly below.

Selections: 

• Date from - : Default today
• Date to - : Default today
• Profile - Default all
• Store - Default all

Parameters:

• pDepositRefundArticleGroups - List of articlegroups for deposit refund. This is used for Deposit refund sold.

Output:

Report lists data from sub-reports listed below in one line per store section (sub-report) type and measure. Data is aggregated per store within date selection.

Columns: 

• Store num. - Store number
• Store name - Store name
• GLN - Global location number
• Section - Section (sub-report) is Tender type, Tax accounting, Deposit Refund

• Store: Multivalue; default all
• Workstation: Multivalue; default all (filtered by store)

Subreports:

• - Default all

Parameters:

• pDepositRefundArticleGroups - List of articlegroups for deposit refund. This is used for Deposit refund sold.

Output:

Report lists data from sub-reports listed below in one line per store section (sub-report) type and measure. Data is aggregated per store within date selection.

Columns: 

• Store num. - Store number
• Store name - Store name
• GLN - Global location number
• Section - Section (sub-report) is Tender type, Tax accounting, Deposit Refund

Image RemovedImage Added

Description:

Report lists cash register frequence per daysales in department per store.

Selections:

• Date from – Default today
• Date to – Default today
• Team Store – Default all
• Store – Default single value to select
• Workstation type – Default ordinary
• Department – Default all

Output:

Each department has own column. Report has a summary for each column except Total share. One store per row.

Columns:

• Store -Store number and store name
• Net amount
• Gr. prof % - Gross profit percentage
• Share – Share of net amount percentage

Clarifications:

Each new added department to report create new column in report table. Report table can be too large and may be divided into several pages.

Source:

• Lindbak POS Reporting Cube (OLAP)
  

Image RemovedImage Added

Description:

Report lists cash register frequence per hour for stores in selected workstationsCoupon summary for particular store.

Selections:

• Date from -– Default today
• Date to – -Default today
• Team – Default all
• Store – Default all
• Workstation type – Default ordinary
• Workstation – Default all
• Price channels – Defaul all
• Include VAT – Default true
• Include nonsale – Default false
• Department – Default all
• select a single value

Output:

• Report shows

• total summary on quantity and value columns. Report shows coupon types in selected store.
• Totals in the beginning of new hierarchy level for:
  • Value check

Columns:

• Buttons for expanding and collapsing all drilldowns.
• Coupon type – Coupon number
• Quantity – Quantity of transactions
• Value – Sales amount
• Date – End date time
• Time – End date time
• Workstation
• Cashier name

Columns:

• Hour – Hour of a day
• Number of workstations
• Turnover
• Accumulated – Accumulated amount
• Share
• Customers
• Items
• Items per customer
• Avg. sales customer – Average sales customer
• Average price per item
• Customers pricechannel
• Avg. sales per customer pricechannel – Average sales per customer pricechannel
• Turnover pricechannel
• Share pricechannel

Source:

• Lindbak POS Reporting Cube (OLAP)

Additional info:

• The report contains two hidden parameters: pHourFrom (default: 8) and pHourTo (default: 16) that can be used to specify the range of hours in the output (default range is 8-17).

• DW

Image Added

Based on 0037 Report.

Image Removed

Description:

Report lists sales for selected store in period of time.credit sales per customer.

Selections:

• Date from – Default Defualt today
• Date to – Default today
• Store – Default all

Output:

• One page per store.

Columns:

• Store num. -Store number
• Store name
• Total Sales - Amount
• Sale ex. VAT – Net amount
• Tax amount
• Cost – Net cost
• Quantity
• Customers – Receipt count
• ATV – Average transaction value
• UPT – Units per transaction
• Gr. prof % - Gross profit percentage
• Gross profit

Sorting:

• Report has a summary for store at the end of table.
• Totals in the beginning of new hierarchy level for: Date

Columns:

• Buttons for expanding and collapsing all drilldowns
• Customer num. – Customer number
• Customer
• Quantity
• Amount – Tender amount

Source:

• Lindbak POS Reporting Cube (OLAP)

Image RemovedImage Added

Description:

Report lists historical balance on given date.discount per cashier

Selections:

• Store – Default allType
• Item group – Default all
• Date from – Default Gift cardtoday
• Date to – Default today

Output:

• Report

• shows summary on quantity and discount columns.
• Totals in the beginning of new hierarchy level for:
  • EAN

Columns:

• Buttons for expanding and collapsing all drilldowns.
• EAN
• Item name
• Reason code
• Item group
• Quantity
• Discount
• Discount % - Discount percentage
• Ord. price – Ordinary price, amount and discount divided by quantity
• Cashier – Cashier number

Columns:

• Store – Store number
• Balance – Scrip balance

Source:

• Lindbak RetailPOS Reporting Cube (OLAP)

Image Added

CO: 10400, PBI#90853

Image Removed

Description:

Report allow to follow up store settlement: all selected Chahiers (if all cashiers are selected it equals whole store settlement) and settlement per each Cashier on following pageslists cash register frequence per day.

Selections:

• Retail store – Single value; select a value from the list
• Operator – Defaul all
• Date from – Default today
• Date to – Default today

Subreports:

• Team – Default all
• Store – Default single value to select
• Workstation type – Default ordinary
• Workstation – Default all
• Price channel – Default all
• Include VAT – Default true
• Include nonsale – Default false
• Department – Default all

Output:

Report shows table for selected store with cash register frequence per day. Report has a summary for each column.

Columns:

• Date
• Turnover
• Accumulated – Acumulated amount
• Share
• Customers
• Items
• Items per customer
• Avg. sales customer – Average sales customer
• Average price per item
• Customers pricechannel
• Avg. sales per customer pricechannel – Average sales per customer pricechannel
• Turnover pricechannel
• Share pricechannel

Source:

Lindbak POS Reporting Cube (OLAP)

Based on 0037 Report.

Image Added

CO: 10625, PBI#116476

Image Removed

Description:

Report lists sales per store with comparison sales and differencefor selected store in period of time.

Selections:

• Date from – Default first day of a current weektoday
• Date to – Default today
• Compare date from - Default the same day of week as Date from year before
• Compare date to - Default the same day of week as Date to but year before
• Store – Default all
• Department – Default all
• Area- Deafult all
• Article group – Default all
• EAN list – Default empty
• Vendor – Default all
• Subvendor – Default all
• Store – Default all

Output:

Report lists sales in stores in selected period of time and comparison sales in other selected period of time with difference both sales. Report has a summary of each for one row per store. Report sum up every column.

Columns:

• Store – num. -Store number
• Store and name
• Sales w/VAT – Sales amount with VAT
• Sales ex/VAT – Sales net amount excluding VAT
• Total Sales - Amount
• Sale ex. VAT – Net amount
• Tax amount
• Cost – Net cost
• Quantity
• Customers – Receipt count
• ATV – Average transaction value
• UPT – Units per transaction
• Gr. prof Gross profit GP % - Gross profit percentage

Clarifications:

• Gross profit

Sorting:

Interactive sorting on all except Sale ex. VAT, Tax amount, Cos and Gross profitNegative values are colored red.

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

CO: 10603, PBI#116490

Image Removed

Description:

Report lists sales per department with comparison saleshistorical balance on given date.

Selections:

• Store – Default all
• Type – Default Gift card
• Date
• Date from – Default first day of a current week
• Date to – Default today
• Compare date from - Default the same day of week as Date from year before
• Compare date to - Default the same day of week as Date to but year before
• Department – Default all
• Store – Default all
• Include VAT – Default true

Output:

• Report shows sales per department for selected stores and period of time and comparison sales in other period of time.
• Report has a summary of each column.
• One page per store.

Columns: