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 yearMonth
• EOD Date 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:

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

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

Source:

• 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 weekWeek 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
  • Month
  • Article group
  • Article subgroup
  • Article name

Columns:

• store.

Columns:

• Item group
• 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 yearMonth from – Default current month
• Month to – Default current monthWeek 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

Image Added

RTC-14247

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-217863, RTC-25043

Image Removed

Description:

Report lists sales per article subgroup and VATdepartment

Selections:

• Store – Default select a single store
• Run for latest EOBD period Year – Default falsecurrent year
• EOD date Date from – Default select a single empty, automatically selected date
• EOD date Date to – Default select a single date- Default empty, automatically selected date
• Include nonsale – Defualt true

Output:

Report shows sales per item subgroup. Report four tables: fuel, retail goods, automatic car wsa and groups. Each table has a summary for each item group and report has total summary for whole tablesummarize for all tables.

Columns:

• Department – Department key
• Dept name – Department name
• Area no – Area number
• Area
• Sgr. No – Subgroup number
• Subgr. name – Subgroup name
• Quantity
• VAT class
• VAT % - VAT percentage
• Ex. VAT – Amount Sales amount without excluding VAT
• VAT
• Sales w/VAT – Sales with VATCost price

Source:

• Lindbak POS Reporting DWLindbak POS Message Service

CO-256310, RTC-3035114247

Image RemovedImage Added

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.lists sales per article group with breakage.

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

Source:

• Lindbak POS Reporting Cube (OLAP)

CO-262513 RTC-27343531644

Image RemovedImage Added

Description:

Report lists data from some of sub-reports 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

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:

Image RemovedImage Added

Description:

Report lists cash register frequence per hour for stores in selected workstationssales in department per 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

Output:

Report shows tables for selected stores with frequence of cash registerEach department has own column. Report has a summary for each column , for each tableexcept 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 Added

Based on 0037 Report.

Image Removed

Description:

Report lists sales for selected store in period of time.shows sales per department and store

Selections:

• Date from – - Default today
• Date to – Default today
• Store – Default all
• Price channels – Default all

Relevant parameters:

pHourFrom and pHoursTo are used to shows hours in column

Output:

• Report lists

• cash register frequence during all day with hours.
• Reports shows table for each selected store with summary on each column except column accumulated.
• There are two tables per one page.

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:

• Hour
• Number of workstations – Number of active workstations Amount
• Accumulated
• Share - Share of net amount percentage
• Customers
• Items
• Avg. sales customer – Average sales customer
• Price pr. Art. – Price per article
• Customers pricechannel
• Avg. sales per customer pricechannel – Average sales per customer pricechannel
• Turnover pricechannel
• Share pricechannel

Source:

• Lindbak POS Reporting Cube (OLAP)

Image RemovedImage Added

Description:

Report lists historical balance on given dateCoupon summary for particular store.

Selections:

• Store Date from – Default all
• Type – Default Gift card
• today
• Date to -Default today
• Store – Default select a single valueDate – Default today

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:

• Store – Store number
• Balance – Scrip balance

Source:

• Lindbak RetailPOS Reporting DW

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 credit sales per customer.

Selections:

• Operator – Defaul all
• Date from – Default Defualt today
• Date to – Default today

Subreports Output:

Image Added

CO: 10625, PBI#116476

Image Removed

Description:

Report lists sales per store with comparison sales and differencecash register frequence per hour for stores in selected workstations.

Selections:

• Date from – Default first day of a current week-Default today
• 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
• Team – Default all
• Store – Default allDepartment
• Workstation type – Default allordinary
• Workstation – Default Area- Deafult allArticle group
• Price channels – Default Defaul all
• EAN list Include VAT – Default emptytrue
• Vendor Include nonsale – Default allfalse
• Subvendor Department – 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 salesshows tables for selected stores with frequence of cash register. Report has a summary of for each column, for each table.

Columns:

• Store – Store number and name
• Sales w/VAT – Sales amount with VAT
• Sales ex/VAT – Sales net amount excluding VAT
• Gross profit GP % - Gross profit percentage

Clarifications:

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

Based on 0037 Report.

Image Added

CO: 10603, PBI#116490

Image Removed

Description:

Report lists sales per department with comparison salesfor 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
• Department – Default all
• Store – Default all
• Include VAT – Default true