List of reports

Standard Report

Description:

• Report allows to follow up cashiers sale performance.

Selections:

• Date from: Default today
• Date to: Default today
• Retail store: Default first available (from list of stores ordered by store number)
• Operator: Default all
• Price channels - Default all

Output:

Item sale statistics showed individually per each cashier (with number between Operator from and Operator to) per each stores (with number between Retail store from and Retail store to).

Additionally there are totals for each cashier and each store.

Columns:

• EAN
• Item name
• Quantity
• Discount % - Share of discount amount in original prize
• Gross profit
• Gross profit % - (gross profit)/(sales ex. VAT)
• Sales amount - sales inc. VAT

Sorting:

• EAN (default)

Source:

• Lindbak POS Reporting cube (OLAP)

Standard report

Description:

• Report allows to follow up cashiers sale performance.

Selections:

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

Item sale statistics showed individually per each cashier (with number between Operator from and Operator to) per each stores (with number between Retail store from and Retail store to).

Additionally there are totals for each cashier and each store.

Columns:

• EAN
• Item name
• Quantity
• Discount % - Share of discount amount in original prize
• Gross profit
• Gross profit % - (gross profit)/(sales ex. VAT)
• Sales amount - sales inc. VAT

Sorting:

• EAN (default)
• Qunatity (interactive)
• Gross profit (interactive)

Source:

• Lindbak POS Reporting DW

Standard report

Description:

Report is devided 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 from: Default first from store list
• Retail store to: Default first from store list
• Operator from: Default 0
• Operator to: Default 999999

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 cube (OLAP)

Standard report

Description:

Report is devided 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

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

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

Standatd report

Description:

Report allows to find given number of best or worst selling items per store, per cashier on multiple levels (amount, quantity, net cost, gross profit).

Selections: 

• Date from: Default today
• Date to: Default today
• Retail store: Default all
• Number of items: Number of best or worst items to display - default 5
• Sort type: worst or best - report will display given number of worst or best selling items - default best
• Sort measure: amount/quantity/net cost/gross profit/gross profit % - set the measure on which the items are sorted. - default amount
• Article group: Default all

Output:

One page per each store. One section per each cashier. Inside the section selected number of best (or worst) selling items for given cashier.

Columns:

• Qunatity
• Amount: Sales amount inc. VAT
• Net Cost
• Gross profit
• Gr. profit %: Share of Gross profit in Net amount

Sorting:

• Selected sort measure

Source:

• Lindbak POS Reporting cube (OLAP)

Standard report

Description:

Report allows to find given number of best or worst selling items on multiple levels (amount, quantity, gross profit, etc.) per selected hierarchy level (department,item area, etc.)

Selections: 

• Date from: Default today
• Date to: Default today
• Store: Possible to select one store or all available; default all
• Profile: Multivalue; default all
• Department: Multivalue; default all
• Article area: Multivalue; default all
• Article group: Multivalue; default all
• Article subgroup: Multivalue; default all
• Article identifier: Possible to select Item ID or Model. Only name of column is changed - field is always Item ID
• Grouping: Selection of hierarchy level for which number of best items will be displayed. Possible selections: Department, Article area, Article group, Article sub group, Store; default Area.
• Count: Number of best or worst items to display - default 10
• Sort type - worst or best - report will display given number of worst or best selling items - default best
• Sort measure - amount/quantity/net cost/gross profit/gross profit % - set the measure on which the items are sorted. - default amount

Output:

Sale statistics for selected number of best or worst items per selected grouping (store or hierarchy level) sorted by selected sort measure with totals on higher levels (e.g. for grouping: article area there are totals for department and store, but for grouping: depratment there will be only total per store)

Columns: 

• Dept.: Department number
• Area: Item area number
• Grp.: Item group number
• Srg.: Subgroup number
• EAN
• Model/ItemID: Article identifier (ItemID - see clarifications)
• Item name
• Quantity
• Amount: Sales amount inc. VAT
• Net cost
• Gross profit
• Gr. prof. %: Share of Gross profit in Net amount

Sorting:

• Selected sort measure

Clarifications:

• Article identifier: Possible to select Item ID or Model. Only name of column is changed - field is always Item ID
• Totals for given level are always placed in the end of list of items belonging to given level.

Source:

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

Standard report

Description:

Report allows to comapare sales between two selected stores.

Selections: 

• Date from: Default today
• Date to: Default today
• Retail store ref: Reference store; default first from store list
• Retail store comp: Store to compare; default first from store list
• Statistics: Expands drill down to selected level; possible selections:
  • Item: expands to area level
  • Model: (as in print screen, expands to lowest level - item). It also changes column No from EAN to ModelKey
  • Group: expands to group level
  • Area: expands to area level
  • Department: expands to department level
• Department: Default all
• Article area: Default all
• Article group: Default all
• Article subgroup: Default all

Output:

Sales statistics per all item ierarchy levels (department, area, group, subgroup, item) expanded as selected in Statiscitcs parameter.

Report is devoded in 3 sections:

• •  per 1. store
  •  per 2. store
  •  difference between selected stores

Columns: 

• No: EAN (or Model key if Model was selected for Statistics parameter)
• Name: Article name (or Model name if Model was selected for Statistics parameter)
• Cost: blank (should be Net cost)
• Sales amount: Sales amount inc. VAT
• Gr. prof.: Gross profit
• Gr. prof %: Share of Gross profit in Net Amount

Sorting:

• No sorting

Clarifications:

• In difference section columns are caltulated as simple subtruction on columns from store 1 minus store 2

Source:

• Lindbak POS Reporting cube (OLAP)

Standard report

Description:

Report gives detailed sales statistics with campaign sales statistics included.

Selections: 

• Date from: Default today
• Date to: Default today
• Retail store: Multivalue; default all
• Profile: Multivalue; default all
• Department: Multivalue; default all
• Article area: Multivalue; default all
• Article group: Multivalue; default all
• Article subgroup: Multivalue; default all
• Article identifier: Possible to select Item ID or Model (ModelKey). 
• Price channels: Multivalue; default all

Output:

Sale statistics for all items with not null sale amount narrowed down only by selections. One row per item.

Totals in the begining of new hierarchy level for:

• • Store
  • Department
  • Item area
  • Item group
  • Subgroup

Columns: 

• EAN
• Model/ItemID: Article identifier (Item ID or ModelKey)
• Item name: Item name (will change to Article Long Name if pUseLongItemText was switched true)
• Quantity sold Total
• Quantity sold Campaign: Sold item quantity in campaigns with discount keys: CampaignPrice, Group, MemberPrice
• Turnover with tax Total
• Turnover with tax Share: Share of sales amount inc. VAT for given item (group, area, ...) in all sales for given store.
• Campaign sale Total: Sale amount inc. VAT for campaigns with discount keys: CampaignPrice, Group, MemberPrice
• Campaign sale %: on item level it is share of campain sales for given item in all sales for the item (Campaign sale / Turnover with tax Total). On totals level: sum of Campaign sale % from item level which doesn't sum up to 100%
• Gross profit Total
• Gross profit Total %: Share of Gross profit in Net Amount
• Gross profit % exc. campaign: Share of gross profit for all sales except campaigns in Net amount for all sales except campaigns
• Gross profit Campaign: Gross profit for Campaign sale Total
• Gross profit Campaign %:  Gross profit Campaign/ Net Amount for campaign sales

Sorting:

• No sorting

Hidden parameters:

• pAllowedPriceChannelsKeys: Default all. If changed it will narrow down possible Price channel selection
• pUseLongItemText: Default false. If set to true Item name will be changed to Article Long Name

Source:

• Lindbak POS Reporting cube (OLAP)

Standard report 

Description:

Report gives detailed sales statistics with campaign sales statistics included with easier access to needed information than 0012.

Selections: 

• Date from: Default today
• Date to: Default today
• Retail store: Multivalue; default all
• Profile: Multivalue; default all
• Department: Multivalue; default all
• Article area: Multivalue; default all
• Article group: Multivalue; default all
• Article subgroup: Multivalue; default all
• Article identifier: Possible to select Item ID or Model (ModelKey). 
• Subvendor: Multivalue; default all
• Vendor: Multivalue; default all
• EAN list: Allows to add specific items ignoring other selections; default blank
• Expand to: Expands drill down to selected level; default Area
• Include Nonsale: If Include Nonsale was box checked, nonsale data will be included to statistics.
• Price channels: Multivalue; default all

Output:

Sale statistics for all items with not null sale (or sale + nonsale if include nonsale box checked) amount narrowed down only by selections. One row per item.

Totals in the begining of new hierarchy level for:

• • Store
  • Department
  • Item area
  • Item group: if you clicked on item group you would be moved to report 0014_SalesStatisticsPrArticles_std with saved selections and you will be able to see sales statistics for items in given item group.
  • Subgroup

Columns: 

• EAN
• Model/ItemID: Article identifier (Item ID or ModelKey)
• Item name: Item name (will change to Article Long Name if pUseLongItemText was switched true)
• Quantity sold Total
• Quantity sold Campaign: Sold item quantity in campaigns with discount keys: CampaignPrice, Group, MemberPrice
• Turnover with tax Total
• Turnover with tax Share: Share of sales amount inc. VAT for given item (group, area, ...) in all sales for given store.
• Campaign sale Total: Sale amount inc. VAT for campaigns with discount keys: CampaignPrice, Group, MemberPrice
• Campaign sale %: Share of campain sales for given item in all sales for the item (Campaign sale / Turnover with tax Total)
• Gross profit Total
• Gross profit Total %: Share of Gross profit in Net Amount
• Gross profit % exc. campaign: Share of gross profit for all sales except campaigns in Net amount for all sales except campaigns
• Gross profit Campaign: Gross profit for Campaign sale Total
• Gross profit Campaign %:  Gross profit Campaign/ Net Amount for campaign sales

Sorting:

• No sorting

Hidden parameters:

• pAllowedPriceChannelsKeys: Default all. If changed it will narrow down possible Price channel selection

Source:

• Lindbak POS Reporting cube (OLAP)

Standard report

Description:

Report gives detailed sales statistics with campaign sales statistics per article with grouping only per store.

Selections: 

• Date from: Default today
• Date to: Default today
• Retail store: Multivalue; default all
• Profile: Multivalue; default all
• Department: Multivalue; default all
• Article area: Multivalue; default all
• Article group: Multivalue; default all
• Article subgroup: Multivalue; default all
• Article identifier: Possible to select Item ID or Model (ModelKey).

Output:

Sale statistics for all items with not null sale amount narrowed down only by selections. One row per item. One page per store.

Columns: 

• EAN
• Model/ItemID: Article identifier (Item ID or ModelKey)
• Item name: Item name (will change to Article Long Name if pUseLongItemText was switched true)
• Quantity sold Total
• Quantity sold Campaign: Sold item quantity in campaigns with discount keys: CampaignPrice, Group, MemberPrice
• Turnover with tax Total
• Turnover with tax Share: Share of sales amount inc. VAT for given item (group, area, ...) in all sales for given store.
• Campaign sale Total: Sale amount inc. VAT for campaigns with discount keys: CampaignPrice, Group, MemberPrice
• Campaign sale %: Share of campain sales for given item in all sales for the item (Campaign sale / Turnover with tax Total)
• Gross profit Total
• Gross profit Total %: Share of Gross profit in Net Amount
• Gross profit % exc. campaign: Share of gross profit for all sales except campaigns in Net amount for all sales except campaigns
• Gross profit Campaign: Gross profit for Campaign sale Total
• Gross profit Campaign %:  Gross profit Campaign/ Net Amount for campaign sales

Sorting:

• No sorting

Source:

• Lindbak POS Reporting cube (OLAP)

Standard report

Description:

Report allows to follow up store settlement: on first page settlement for all selected cashiers (if all cashiers are selected it equals whole store settlement) and settlement per each cashier on following pages. Report is divided in 12 subreports which will be descriped separatly below.

Selections (applies to all subreports): 

• Date from: Default today
• Date to: Default today
• Store: Single value; default first available from the list.
• Operator: Multivalue; default all
• Price channels: Multivalue; default all

Subreports:

Source:

• Lindbak POS Reporting cube (OLAP)

Description:

Report allows to follow up store settlement: on first page settlement for all selected workstations (if all cashiers are selected it equals whole store settlement) and settlement per each workstation on following pages. Report is divided in 15 subreports which will be descriped separatly below.

Selections (applies to all subreports): 

• Date from: Default today
• Date to: Default today
• Store: Single value; default first available from the list.
• Workstation: Multivalue; default all

Subreports:

Source:

• Lindbak POS Reporting cube (OLAP)

Standart report

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
• Include VAT: Allows to decide if Vat is included in sales amount or not; default yes.

Output:

One page per store

One row per cashier

Columns:

• No: Operator number
• Name: Operator name
• Turnover inc VAT/ Turnover ex VAT
• 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
• Scan: Number of scanned articles
• Waste: Breakage amount
• Discount: Discount quantity
• Scan %: Scan divided by Quantity of sold items

Sorting:

• No sorting

Source:

• Lindbak POS Reporting cube (OLAP)

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
• Include VAT: Allows to decide if Vat is included in sales amount or not; default yes.

Output:

One page per store

One row per cashier

Columns:

• No: Operator number
• Name: Operator name
• Turnover inc VAT/ Turnover ex VAT
• 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
• Waste: Breakage amount
• Discount: Discount quantity
• Scan %: Scan divided by Quantity of sold items

Sorting:

• No sorting

Source:

• Lindbak POS Reporting cube (OLAP)

Description:

Report lists items, their quantity and amount for selected, specific values.

Selections:

• Date from – Default today
• Date to – Default today
• Store – Default all
• Group – Default all
• Sort – Default: Best
• Accumulation – Default: Total + Store
• Measure – Default: Amount
• Count – Default set 10

Output:

Report shows bestsellers or worst sold items and their quantity and sum amount for selected store (one store per site) and period time.

Columns:

• No – Item id
• Name – Article name
• Quantity
• Sum - Amount
• Gross profit
• Gr. prof. % - Gross profit percentage

Clarifications:

Report can show counted number of products, Accumulation and can be measured by amount, quantity or gross profit.

Source:

• Lindbak POS Reporting Cube (OLAP)

Description:

Report lists cashiers from stores and their sales.

Selections:

• Date from – Default today
• Date to – Default today
• Store – Default all Item list- Default all
• Article group – Default all
• Article EAN – Default all

Output:

• Reports lists all cashiers fom selected stores and their sales for customers for selected period of time, item list and article group.
• Report has a total summary at the end of list for each column.

Columns:

• Seller name – Cashier name
• Seller nr – Cashier number
• Total Sales -Total Amount
• Customer – Number of receipts
• ATV – Average transaction value
• UPT – Units per transaction
• Gr. prof. % - Gross profit percentage
• Makeup % - Article group sales percentage
• Item List % Gifts % - Gift sales percentage
• Item group sales

Interactive sorting:

Everything except Makeup %, Item list%,  Gifts % and Item group sales

Source:

Lindbak POS Reporting Cube (OLAP)

Description:

Report lists besteller items in stores.

Selections:

• Date from – Default today
• Date to – Default today
• Count – Default 10
• Store – Default all
• Area – Default all
• Group – Default all
• Subgroup – Default all
• Measure – Default Amount

Output:

Report lists selected number of bestellers items including their quantity and amount in selected stores and period of time.

Columns:

• Item num. – Item number
• EAN
• Item name
• Quantity
• Amount
• Gross profit
• Gross profit %

Source:

Lindbak POS Reporting Cube (OLAP)

Description:

Report lists discounts of items in stores.

Selections:

• Date from – Default today
• Default to – Default today
• Stores – Default all
• Discounts – Default all

Output:

• Report shows for selected stores all discounts of items and percentage discount and gross profit of items in selected period of time.
• Summary for each column.
• One row per item number within selected date range

Columns:

• Date
• Item num. – Item number
• Item name
• Quantity
• Discounts
• Discount %
• GP % - Gross profit percentage

Interactive sorting:

• Date
• Discounts
• Discount %
• GP %

Source:

Lindbak POS Reporting Cube (OLAP)

Description:

Report lists sales for selected storse in selected period of time. 

Selections:

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

Output:

• Report lists total sales, one store per row.
• Report sum up every column.

Columns:

• Store num. – Store number
• Store name Total sales
• Quantity
• Customers
• ATV – Average tranaction value
• UPT – Units per transaction
• Gr. prof. % - Gross profit percentage
• Makeup % - Article group sales percentage

Interactive sorting:

Interactive sorting on all except Makeup %.

Source:

Lindbak POS Reporting Cube (OLAP)

Description:

Report lists bestseller products in each store.

Selections:

• Date from – Default today
• Date to – Default today
• Count – Default 10
• Team – Default all
• Profile – Default all
• Store – Default all
• Sort – Default best
• Accumulation – Default: OverAll + Store
• Measure – Default: Amount

Output:

Report lists bestseller items with quantity and gross profit for seleected period of time for each selected store, one page per store.

Columns:

• EAN
• Item name
• Quantity
• Amount in thousand
• Gross profit
• Gross profit % - Gross profit percentage

Source:

Lindbak POS Reporting Cube (OLAP)

CO attached to PBI #12200

Description:

• Report allows to check Nonsale quantity among stores and cashiers.

Selections:

• Date from: Default today
• Date to: Default today
• Retail store: Default all
• Operator: Default all

Output:

One row per item showing quantity of nonsale transaction on given item. Total per each cashier and per each store.

Columns:

• EAN
• Item name
• Quantity

Sorting:

• Store number
• Cashier number

Source:

• Lindbak POS Reporting cube (OLAP)

CO: 190338

Description:

Report allows to follow up bonus rollout checks usage and sales made using bonus checks.

Selections:

• Year from (default last year)
• Year to (default current year)
• Bonus rollout name (default all) - report shows data for available rollouts within selected period
• Loyalty program

Output:

Bonus checks usage and sales statistics grouped per store. Report lists all the stores in which checks were issued or redeemed.

Columns:

• Store - StoreNumber - Store name
• Number redeemed - Number of redeemed bonus checks issued in selected rollout(s)
• Sum redeemed - Sum of redeemed bonus checks
• Redeemed of total issued % - Share of redeemed bonus checks number for store compared to issued bonus checks number for all stores
• Average sale - Average sale inc. VAT made using bonus checks

Sorting:

• StoreNumber

Clarifications:

• Check is considered redeemed even if it was only partialy used
• Check is conntected to the store in which it was redeemed, not issued

Source:

• Lindbak POS Reporting cube (OLAP)

Description:

Report lists loyalty statistic per week in selected year.

Selections:

• Loyalty program -Default 1
• Year – Default today
• Week- Default 4

Output:

Report shows new members in period and new members years to date in this year and last year for each store in selected year and week

Columns:

• Store – Store name
• This year
• Last year
• Diff % - Percentage difference between this year and last year

Source:

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

CO: 176619

Description:

Report shows all items which were not counted during inventory since given date.

Selection:

• Not counted since - Shows items that are not counted since this date. Default same date last month.
• Retail store - Only available for HQ users. Default first available store.
• Supplier - Filter result on supplier. Default all
• Item group - Filter result on item group. Default all
• Brand - Filter result on brand. Default all
• Show total only - If selected it will only show total, not any items. Default not selected.

Output:

All items which don't appear on last stocktaking. First row is total where under EAN there is a number of all items not counted.

Columns:

• Supplier - Supplier name
  
• EAN - EAN number
  
• Item number - Item number
  
• Item text - Item text
  
• Quantity - Last number in stock -Shows quantity from last stocktaking
  
• Net cost - Last Net cost - Shows total netcost for item from last stocktaking

Sorting:

• EAN

Source:

• Lindbak Retail database

CO: 225452

RTC-28001

Description:

Report lists changes in bonus balance and how much bonus is issued and used over a period of time

Selection:

• Loyalty id - Loyalty program, default 1
• Date From - Default today
• Date To - Default today
• Store - Default all

Output:

Bonus checks overview. For each store sum of issued, redeemed, spent, expired and balance bonus checks with number of sales and members who got/used bonus. Next table with issued amount and member with bonus independent of chosen period. Total sum of each column for all selected stores.

Columns:

• Members with bonus - Number of members with bonus amount balance greater than 0 (independent of chosen period)
• Issued amount - Total bonus amount issued (independent of chosen period)
• Store num - Store number
• Store name - Store name (default sorted on this column)
• Total - The sum of issued amount in the selected period
• Ordinary sales - The sum of bonus amount issued after purchases in the selected period
• Manual checks - The sum of bonus amount issued manually in the selected period
• Spent bonus - total sum of redeemed amount in the selected period
• Expired bonus - Total sum of amount that expires in the selected period (check expiration date is between date from and date to)
• Receipts paid with bonus - Number of sales (receipts) paid with bonus checks in the selected period
• Members who used bonus - Number of unique members who have used bonus, redeemed transaction in the selected period
• Member who got bonus - Number of unique members who got bonus, issued transaction in the selected period
• Bonus balance - Sum of not-expired bonus amount at the end of the selected period

Clarifications:

• Receipts paid with bonus column shows count values selected on distinct member number and distinct transaction date, it resolves issues with the same transaction id at different webshops.
• All data is based on FactMemberTransaction.

Source:

• Lindbak POS Reporting DW

Descriptions:

Report lists all manual discounts for all Cashiers in selected stores.

Selections:

• Date from – Default today
• Date to – Default today Store – Default all
• Operator – Default all
• Reason code – Default all

Output:

Report lists item number with manual discount per cashier name in selected stores. Quantity and Discount are summed up at the end of report.

Columns:

• Store – Store number
• Number – Operator number
• Cashier name – Cashier full name
• Item num. – item number
• Item name
• Quantity
• Reason code
• Discount - Discount of article
• Discount %

Sorting:

• Interactive sorting on all columns

Source:

• Lindbak POS Reporting cube (OLAP)

CO-96179

Descriptions:

Report shows detailed customer club sales.

Selections:

• Date – Default today
• Store – Default all

Output:

Report lists receipts with price and number of items for selected stores and particular day.

Columns:

• Store – Store number
• Workstation – Workstation number
• Cashier – Cashier number
• Receipt – Transaction id
• Member number
• Sales incl. VAT – Amount
• Sales excl. VAT – Net amount
• Items – quantity of items

Source:

• Lindbak POS Reporting DW

CO: 156791. Based on report 0709.

Description:

Report allows to follow up store settlement: on first page settlement for all selected cashiers (if all cashiers are selected it equals whole store settlement) and settlement per each cashier on following pages. Report is divided in 9 subreports which will be descriped separatly below.

Selections (applies to all subreports): 

• Date from - Default today
• Date to - Default today
• Store - Default all
• Operator -Default all

Subreports:

Source:

• Lindbak POS Reporting cube (OLAP)

CO-167575

Descriptions:

Report lists broken and waisted items.

Selections:

• Date from – Default today
• Date to – Default today
• Store – Default all
• Subvendor – Default all
• Article area – Default all
• Article group – Default all
• Transaction type – Default all
• Reason code – Default all

Relevant parameters:

• pTransactionTypesToExclude - Comma separated list of transactions types not to show in list of transaction types.

Output:

Report shows items, their transaction type with price and quantity for selected stores and their subvendors.

Columns:

• Store – Store number and store name
• Subvendor – Subvendor number and subvendor name
• EAN
• Item name
• Item number
• Number - Cashier number T
• ransaction type
• Reason code
• Date - Date of transaction
• Net price
• Quantity
• Net price total – Total net price number of items

Clarifications:

Report allow to show same items with different transaction types and sum up of quantity and price. It happens under each selected subvendor,  which is placed under selected store.

Source:

• Lindbak POS Reporting Cube (OLAP)

CO: 190620

Description:

Report allows to follow upcoming and ongoing campaigns and also browse expired campaigns.

Selections: 

• Date from - Default today
• Date to - Default today
• Store - Default all
• Apply date filter to - Start date (Date from <= Start date <= Date to)/ End date (Date from <= End date <= Date to)/ Ongoing (Date from <= End date and Date to <= Start date) - default Start date
• Status  - Expired/Active/Not approved - default all
• Include profile campaigns -default false

Output:

One row per campaign

Columns: 

• Store
• Campaign group
• Campaign ID
• Campaign name
• Status - Expired/Active/Not approved
• Start date
• Start time
• End date
• End time
• Created by

Sorting:

• Interactive sorting on all columns except time

Source:

• dsProgress

CO: 191144

Description:

Report allows to follow up article sales and waste grouped per store and per (item group or item area).

Selections: 

• Date from - Default today
• Date to - Default today
• Store - Default all
• Article area - Default all
• Article group - Default all
• Reason Code - Default all
• Grouping - item area or item group - Default Item area
• Exclude items without breakage - Default false

Output:

Article sales and waste statistics grouped per store and per item group or item area sorted by highest Lost amount. There is a page break per each store and total all stores in the bottom of last page. If Exclude items without breakage parameter is set to true there will be only items with breakage.

Columns: 

• Buttons for expanding and collapsing all drilldowns.
• ItemNo - Item number
• Item name
• Sales quantity - number of sold items
• Sales ex. VAT - sales amount ex. VAT
• Net cost - net cost of sold items
• Waste qty - number of broken items
• Lost amount - net cost of broken items
• Breakage % - share of Waste qty in Sales quantity
• Lost amount % - share of Lost amount in Net cost

Sorting:

• On all levels (store, area, group and item): by Lost amount from highest to lowest.

Clarifications:

• If there are no sales on items with breakage, Breakage % and Lost amount % will be 100%

Source:

• Lindbak POS Reporting cube (OLAP)

Description:

Report allows to follow up daily sales statistics per one of following: Store/Profile/Team/Total.

Selections: 

• Date from: Default today
• Date to: Default today
• Week day from: Default Monady 
• Week day to: Default Sunday - Report will show data only for selected week days
• Accumulation - Store/Profile/Team/Total - makes report show statistics per selected accumulation. If total is selected, the report shows sales per day per all stores.
• Team: Default all
• Profile: Defaul all
• Retail store: Default all

Output:

One page per selected accumulation(Store/Profile/Team/Total)

One row per day within selected date range and only day within Week day from and Week day to.

Columns: 

• Date
• Gross sales
• Member disc.: Discount Key = MemberPrice
• Customer disc.: Discount Key = CustomerGroup
• Personel disc.: Discount Key = Personal
• Other discounts.
• Sales inc. VAT
• Sales ex. VAT
• Gross Profit
• Gr. proc. %: Share of gross profit in net amount

Sorting:

• Pages by accumulation 
• Rows by date

Source:

• Lindbak POS Reporting cube (OLAP)

Standard report

Description:

Report allows to follow up nonsales statistics per item per Store or all stores.

Selections: 

• Date from: Default today
• Date to: Default today
• Week day from: Default Monady 
• Week day to: Default Sunday - Report will show data only for selected week days
• Accumulation - Store/Profile/Team/Total/Vendor - Should make report show statistics per selected accumulation. If total is selected, the report shows sales per day per all stores. Now only Store and total are working correctly
• Team: Default all
• Profile: Defaul all
• Retail store: Default all
• Department: Default all
• Article area: Default all
• Article group: Default all
• Article subgroup: Default all
• Vendor: Default all
• Assortment: Default all
• EAN from: Default all
• EAN to: Default all - range of ean can be manually set here
• Item ID from: Default all
• Item ID to: Default all - range of Item ID can be manually set here.
• Tandem: Dafault yes, if switched to no, then instead of EAN, Main EAN is shown in EAN column.

Output:

One page per selected accumulation(Store/Total)

One row per Article (EAN or Main EAN if tandem switched to no)

Article statistics are grouped on multile levels: Subgrouo, Group, Area, Department and

Columns: 

• EAN
• Item name
• Quantity
• Ex. VAT Amount
• Ex. VAT Total %: Share of sales on given item(dept/area/group) to total store sale
• Gross profit Amount
• GP %: Share of gross profit in net amount

Sorting:

• Pages by store
• Rows by date

Source:

• Lindbak POS Reporting cube (OLAP)

Standard report

Description:

Report allows to follow up nonsales statistics per item per Store or all stores.

Selections: 

• Date from: Default today
• Date to: Default today
• Week day: select days for which you're gonna see staistics; default Friday.
• Statistics: There you can set on which level you want your sales grouped.
  • Item Subgroup sales
  • Item Group sales
  • Item Area sales
  • Department sales
  • Store sales

• Sales Ex. VAT: Yes/No
• Department: Default all
• Article area: Default all
• Article group: Default all
• Article subgroup: Default all
• Team: Default all
• Profile: Defaul all
• Retail store: Default all

Output:

One row per level selected in Statistics parameter.

Columns: 

• Store num
• Sotre name
• Profile
• Day
• Week
• Month
• Year
• Dept no
• Dept name
• Area no
• Area name
• Sgr. no
• Subgr. name
• This year:
  • Sales ex. VAT(inc. VAT if Sales ex VAT set to No)
  • Gross profit
  • Camp w. VAT sales inc .VAT with Discount Key = CampaignPrice
  • Camp gr. prof.: Gross profit from campaign sales
  • Items: Quantity of sold items
• Last year: Same stasitics as This year but last year

Sorting:

• Rows by store

Source:

• Lindbak POS Reporting cube (OLAP)

Description:

Report allows to follow up sales statistics on Department level.

Selections: 

• Date from: Default today
• Date to: Default today
• Week day: Default Friday
• Department: Default all
• Article area: Default all
• Team: Default all
• Profile: Defaul all
• Retail store: Default all

Output:

One page per Store

One row per Department

Columns: 

• Department:
  • no
  • Department
  • Cost: Net cost
• Sales Amount
  • w/VAT: Sales exc. VAT
  • Gr. prof.
  • In %: Share of Gross Profit in Net Amount
• Discount:
  
  • Member disc.: Discount Key = MemberPrice
  • Customer disc.: Discount Key = CustomerGroup
  • Staff disc.: Discount Key = Personal
  • Other: Other discounts sales amount
• Undiscounted Sales Amount
• Share of: Share of given department in all department sales
  • Sales amount
  • Gr. prof.

Sorting:

• Pages by store number
• Rows by department number

Source:

• Lindbak POS Reporting cube (OLAP)

Standard report

Description:

Report allows to follow up store settlement: on first page settlement for all selected cashiers (if all cashiers are selected it equals whole store settlement) and settlement per each cashier on following pages. Report is divided in subreports which will be descriped separatly below.

Selections (applies to all subreports): 

• Date from: Default today
• Date to: Default today
• Team: Multivalue; default all
• Profile: Multivalue; default all
• Store: Single value; default first available from the list.
• Operator: Multivalue; default all

Subreports:

Source:

• Lindbak POS Reporting cube (OLAP)

Standard report

Description:

Report allows to follow up store settlement: on first page settlement for all selected workstations (if all cashiers are selected it equals whole store settlement) and settlement per each workstation on following pages. Report is divided in subreports which will be descriped separatly below.

Selections (applies to all subreports): 

• Date from: Default today
• Date to: Default today
• Team: Multivalue; default all
• Profile: Multivalue; default all
• Store: Multivalue; default all
• Workstation: Multivalue; default all

Subreports:

Source:

• Lindbak POS Reporting cube (OLAP)

Standard report

Description:

Report allows to follow up meber and member sale statistics divided by member age and member gender.

Selections: 

• Date from - Default today
• Date to - Default today
• Retail store - Default all
• Loyalty program

Output:

Report is devided in 5 sections:

1. Graph and table showing number of members who joined in the selected date range, compared to the number of members who joined the year before.
2. Sales statistics divided between members and not member customers
3. Graph and table showing sales amount by gender and age groups
4. Sale statistics divided by member seniority level
5. Sale amount grouped per department, divided by gender

Columns: 

• Section 1
  • This year - number of members who joined in the selected date range,
  • Last year - number of members who joined the year before selected date range 
• Section 2
  • Num of receipts
  • Avg amount - (Sale amount inc. VAT)/(Num of receipts)
  • Items - number of items sold
  • Items/Cust - average number of sold items per customer
  • Gross profit
  • Gross profit % - Share of Gross profit in Sale amount
• Section 3
  • Age group
  • Sales inc. VAT
  • Gross profit
  • Gross profit % - Share of Gross profit in Sale amount
• Section 4
  • level - member characteristic
  • Num of receipts
  • Avg amount - (Sale amount inc. VAT)/(Num of receipts)
  • Items - number of items sold
  • Items/Cust - average number of sold items per customer
  • Gross profit
  • Gross profit % - Share of Gross profit in Sale amount
• Section 5
  • Department - Department name
  • Female - Sale amount inc. VAT for scpecific department generated by women
  • Female % - Share of sale amount inc. VAT for scpecific department generated by women in all sales inc. VAT across all departments and all genders
  • Total -Sale amount inc. VAT for scpecific department
  • Total % - Share of sale amount inc. VAT for scpecific department  in all sales inc. VAT across all departments

Sorting:

• Section 3 - Age group
• Section 4 - Level
• Section 5 - Department name

Clarifications:

• This year, las year - if date range is 2020/01/01 - 2022-/01/01, then This year is 2020/01/01 - 2022-/01/01 and Last year is 2019/01/01 - 2021/01/01

Source:

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

Standard report

Description:

Report allows to follow up specific member activities.

Selections: 

• Loyalty program: Dafault: 0 - Default loyalty program
• Date from: Default today
• Date to: Default today
• Member ID: Member key which needs to be written manually.

Output:

There are two sections:

• Member transactions: All transactions for given member in given date period
• Mamber sale: All sales made by given member in given date period

Columns: 

• Member transactions
  • Date
  • Transaction Type: Transaction type from DimMemberActivity
  • Activity name
  • Bonus points
• Member sale:
  • Date
  • Amount: Amount inc. VAT

Source:

• Lindbak POS Reporting cube (OLAP)

Standard report

Description:

Report allows to follow up sales in specific locations.

Selections: 

• Date time from: Date period is alway from 'Date time from' to today
• Retail store: Single selection. Default first from list.
• Workstations: Available workstations for given Retail store. Default: all available workstations for given Retail store.
• Article group: Default all

Output:

One row per one item sold in specific LocationKey from DimStockLocation. Data is presented per item group.

Columns: 

• Model nr
• Item name
• Color
• Size
• EAN
• Price: Sum of sale amount inc. VAT.
• Quatity: Sum of sold item quantity.

Source:

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

Standard report

Description:

Report allows to follow usage of giftcards.

Selections: 

• Date time from: Date period is alway from 'Date time from' to today
• Retail store: Single selection. Default first from list.
• Workstations: Available workstations for given Retail store. Default: all available workstations for given Retail store.
• Article group: Default all

Output:

One row per one item sold in specific LocationKey from DimStockLocation. Data is presented per item group.

Columns: 

• Model nr
• Item name
• Color
• Size
• EAN
• Price: Sum of sale amount inc. VAT.
• Quatity: Sum of sold item quantity.

Source:

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

Description:

Report allows to follow up sales in specific locations.

Selections: 

• Date time from: Date period is alway from 'Date time from' to today
• Retail store: Single selection. Default first from list.
• Workstations: Available workstations for given Retail store. Default: all available workstations for given Retail store.
• Article group: Default all

Output:

One row per one item sold in specific LocationKey from DimStockLocation. Data is presented per item group.

Columns: 

• Model nr
• Item name
• Color
• Size
• EAN
• Price: Sum of sale amount inc. VAT.
• Quatity: Sum of sold item quantity.

Source:

• Lindbak POS Reporting DW

Description:

Report allows to follow up article sales on multiple levels with possibility to select specific hourly intervals and exclude specific item groups.

Selections: 

• Date from - Default today
• Date to - Default today
• Hour from - Default 0:00
• Hour to - Default 24:00
• Team - Default all
• Store - Default all
• Department - Default all
• Article area - Default all
• Article group - Default all
• Include VAT - Default on
• Exclude groups - Default false
• Excluded groups - Appears when Exclude groups is switched to true

Output:

Article sale statistics for selected stores, for selected date interval and for selected time interval grouped by department, area and group.

By default data is shown for department and it is possible to drill down to item level manually by clicng plus button or by using expand all button to expand everithing to item level at once.

Columns: 

• Buttons for expanding and collapsing all drilldowns.
• EAN - EAN code
• Item name - Article name
• Quantity
• Total- Quantity sold
• Turnover inc. VAT or Turnover ex. VAT depending on selection.
• Total - Amount sold. Inc. or ex. VAT depending on selection
• Share - Share of this department / area / group / item related to total sale.
• Cost price - Cost price
• Gross profit
• Total - Gross profit amount
• Total % - Gross profit percentage.

Sorting:

• Department number 
• Item Area number 
• Item Group number
• EAN

Clarifications:

• Hour selection applies to each day in selected date period

Source:

• Lindbak POS Reporting cube (OLAP)

Description:

Report allows to follow up article sales on multiple levels with possibility to select specific hourly intervals and exclude specific item groups.

Selections: 

• Date from - Default today
• Date to - Default today
• Hour from - Default 0:00
• Hour to - Default 24:00
• Team - Default all
• Store - Default all
• Department - Default all
• Article area - Default all
• Article group - Default all
• Include VAT - Default on
• Exclude groups - Default false
• Excluded groups - Appears when Exclude groups is switched to true

Output:

Article sale statistics for selected stores, for selected date interval and for selected time interval grouped by department, area and group.

By default data is shown for department and it is possible to drill down to item level manually by clicng plus button or by using expand all button to expand everithing to item level at once.

Columns: 

• Buttons for expanding and collapsing all drilldowns.
• EAN - EAN code
• Item name - Article name
• Quantity
• Total- Quantity sold
• Turnover inc. VAT or Turnover ex. VAT depending on selection.
• Total - Amount sold. Inc. or ex. VAT depending on selection
• Share - Share of this department / area / group / item related to total sale.
• Cost price - Cost price
• Gross profit
• Total - Gross profit amount
• Total % - Gross profit percentage.

Sorting:

• Department number 
• Item Area number 
• Item Group number
• EAN

Clarifications:

• Hour selection applies to each day in selected date period

Source:

• Lindbak POS Reporting cube (OLAP)

Description:

Report allows to follow up sales in specific locations.

Selections: 

• Date time from: Date period is alway from 'Date time from' to today
• Retail store: Single selection. Default first from list.
• Workstations: Available workstations for given Retail store. Default: all available workstations for given Retail store.
• Article group: Default all

Output:

One row per one item sold in specific LocationKey from DimStockLocation. Data is presented per item group.

Columns: 

• Model nr
• Item name
• Color
• Size
• EAN
• Price: Sum of sale amount inc. VAT.
• Quatity: Sum of sold item quantity.

Source:

• Lindbak POS Reporting DW

Description:

Report allows to follow up sales in specific locations.

Selections: 

• Date time from: Date period is alway from 'Date time from' to today
• Retail store: Single selection. Default first from list.
• Workstations: Available workstations for given Retail store. Default: all available workstations for given Retail store.
• Article group: Default all

Output:

One row per one item sold in specific LocationKey from DimStockLocation. Data is presented per item group.

Columns: 

• Model nr
• Item name
• Color
• Size
• EAN
• Price: Sum of sale amount inc. VAT.
• Quatity: Sum of sold item quantity.

Source:

• Lindbak POS Reporting DW

Description:

Report allows to follow up sales in specific locations.

Selections: 

• Date time from: Date period is alway from 'Date time from' to today
• Retail store: Single selection. Default first from list.
• Workstations: Available workstations for given Retail store. Default: all available workstations for given Retail store.
• Article group: Default all

Output:

One row per one item sold in specific LocationKey from DimStockLocation. Data is presented per item group.

Columns: 

• Model nr
• Item name
• Color
• Size
• EAN
• Price: Sum of sale amount inc. VAT.
• Quatity: Sum of sold item quantity.

Source:

• Lindbak POS Reporting DW

Description:

Report allows to follow up store settlement: on first page settlement for all selected workstations (if all cashiers are selected it equals whole store settlement) and settlement per each workstation on following pages. Report is divided in subreports which will be descriped separatly below.

Selections (applies to all subreports): 

• Date
• Store: Single value; default first
• Workstation: Single value; default first

Subreports:

Description:

Report allows to check new members.

Selections: 

• Date from
• Date to
• Loyalty program

Output:

One row per new member

Columns: 

• Member number
• First Name
• Last name
• Email
• Postal adress
• Main store: Store in which member was added
• Registered date

Source:

• Lindbak POS Reporting cube (OLAP)

Description:

Report allows to check new members.

Selections: 

• Date from
• Date to
• Loyalty program
• Sales from: min Sales amount on member
• Sales to: max Sales amount on member
• Top X: number of top members
• Top X based on: selection of measure on which Top X is selected
• Department
• article group
• Retail Store
• Sex
• Age group
• Employee
• Active
• Email Status
• Mobile status
• EAN list
• Assortment
• Brand

Output:

One row per new member

Columns: 

• Member number
• First Name
• Last name
• Email
• Postal adress
• Main store: Store in which member was added
• Registered date

Source:

• Lindbak POS Reporting cube (OLAP)

Description:

Report allows to follow up workstation settlement: on first page settlement for all selected workstations (if all cashiers are selected it equals whole store settlement) and settlement per each workstation on following pages. Report is divided in subreports which will be descriped separatly below.

Selections (applies to all subreports): 

• Date
• Store: Single value; default first
• Workstation: Single value; default first

Subreports:

Description:

Report allows to follow up avg. member sales. Report divides sales data for months

Selections: 

• Date - date to
• Loyalty program

Output:

Graphs show sales amount and sales quantity. Table is divided in to parts - amount and quantity

Columns: 

• Amount inc. VAT
• Quantity

Source:

• Lindbak POS Reporting cube (OLAP)

Description:

Report allows to follow up avg. member sales. Report divides sales data for weeks

Selections: 

• Date - date to
• Loyalty program

Output:

Graphs show sales amount and sales quantity. Table is divided in to parts - amount and quantity

Columns: 

• Amount inc. VAT
• Quantity

Source:

• Lindbak POS Reporting cube (OLAP)

Description:

Report allows to follow up meber and member sale statistics divided by member age and member gender.

Selections: 

• Date from - Default today
• Date to - Default today
• Retail store - Default all
• Loyalty program

Output:

Report is devided in 5 sections:

1. Graph and table showing number of members who joined in the selected date range, compared to the number of members who joined the year before.
2. Sales statistics divided between members and not member customers
3. Graph and table showing sales amount by gender and age groups
4. Sale statistics divided by member seniority level
5. Sale amount grouped per department, divided by gender

Columns: 

• Section 1
  • This year - number of members who joined in the selected date range,
  • Last year - number of members who joined the year before selected date range 
• Section 2
  • Num of receipts
  • Avg amount - (Sale amount inc. VAT)/(Num of receipts)
  • Items - number of items sold
  • Items/Cust - average number of sold items per customer
  • Gross profit
  • Gross profit % - Share of Gross profit in Sale amount
• Section 3
  • Age group
  • Sales inc. VAT
  • Gross profit
  • Gross profit % - Share of Gross profit in Sale amount
• Section 4
  • level - member characteristic
  • Num of receipts
  • Avg amount - (Sale amount inc. VAT)/(Num of receipts)
  • Items - number of items sold
  • Items/Cust - average number of sold items per customer
  • Gross profit
  • Gross profit % - Share of Gross profit in Sale amount
• Section 5
  • Department - Department name
  • Female - Sale amount inc. VAT for scpecific department generated by women
  • Female % - Share of sale amount inc. VAT for scpecific department generated by women in all sales inc. VAT across all departments and all genders
  • Total -Sale amount inc. VAT for scpecific department
  • Total % - Share of sale amount inc. VAT for scpecific department  in all sales inc. VAT across all departments

Sorting:

• Section 3 - Age group
• Section 4 - Level
• Section 5 - Department name

Clarifications:

• This year, las year - if date range is 2020/01/01 - 2022-/01/01, then This year is 2020/01/01 - 2022-/01/01 and Last year is 2019/01/01 - 2021/01/01

Source:

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

Description:

Report lists all member activities for selected member.

Selections:

• Loyalty program - Default: 0 - Default loyalty program
• Member number - Member key which needs to be written manually.

Output:

List of member activities and sales.

Columns:

• Activity - Activity number (default sorted on this column)
• Item name - Article name
• ID - Transaction ID + EAN number defining as Item ID
• Campaign - Campaign name + Campaign reference
• Description - description from member activity
• Date - End date time defining as transaction date from transaction article
• Amount - original face amount drom transaction article
• Discount - discount from transaction article
• Bonus points - Bonus amount
• Store - Store number + Store name

Clarifications:

• There is union all operator which combine values from different tables: FactRetailTransactionArticle article and FactMemberTransaction. It combines sales activity with bonus checks and points for the selected member. 

Source:

• Lindbak POS Reporting DW

Description:

Created on request from product because funtion SALE_STAT in CR only gets data from Chain classic.

This report is optimized to run from Cash register with resolution set to 1024 * 768. Meant to use for cashiers to check sales statistics from today.

Selections: 

• Date from - Default today
• Date to - Default today
• Retail store - Since this report is meant to run from cash register, parameter is hidden. When setting up repor in buttonconfig use "pRetailStore=[Retail Store].[Retail Store Num].&[@Storenum@]" in Parameter_1

Output:

Report is divided into two sections. First is showing graphical sale per hour. Second is showing sale statistics for cashiers.

Columns:

For seciton one. One row per cashier and one row for total on top.

• No - Cashier number
• Name - Cashier name
• Turnover - Sales inc. VAT
• Items - Number of items sold
• Customers - Number of customers / receipt
• Sale per customer - Average sale per customer / receipt
• Items per customer - Average items per customer / receipt
• Gr. prof % - Gross profit in percentage

Sorting:

• Sorting by cashier number

Clarifications:

• Not optimized for running in Chain Web, only Cash register.

Source:

• Lindbak POS Reporting cube (OLAP)

Description:

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

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
• Item number - Item number
• Transaction type - Transaction type
• Reason code - Reason code
• Date - Date of transaction
• Net price - Net price per unit
• Price w/VAT - Price including VAT per unit
• Quantity - quantity
• 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: 
  • 
  • 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

RTC-27768

Description:

Report lists all reasoncodes for all stores. Layout of the report makes it easy to export data to Excel.

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

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 codes

Columns (interactive sorting on Storenum, Storename, Transaction type and Reason code):

• Store num - Store number
• Store name - Store name
• Transaction type - Transaction type
• Reason code - Reason code (default sorted on this column)
• Net cost - Total net cost (cost price) for row
• Quantity - Total quantity for row
• Net amount - Total amount without VAT for row
• Amount w / VAT - Total amount with VAT for row
• 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: 
  • 
  • 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

CO-1904

Description:

Report lists credit sales for all stores in selected period time.

Selections:

• Date from – Default today
• Date to – Default today
• Show all credit sales – Default true

Output:

Report lists every sale in period time with name of customer, references and amount. Report sum up Amount and Tax amount.

Columns:

• Date – Sales date
• Dept. – Store number
• Receipt – Transaction id
• Customer – Customer name
• Ref. no – reference number
• Ref. text – reference text
• Amount
• Tax amount – VAT amount

Source:

• Lindbak POS Reporting DW

Based on 0037 Report.

Description:

Report lists sales for selected store in period of time.

Selections:

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

Output:

Report lists sales for one row per store. Report sum up every column.

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:

Interactive sorting on all except Sale ex. VAT, Tax amount, Cos and Gross profit

Source:

• Lindbak POS Reporting Cube (OLAP)

CO: 115424

Description:

Report lists expiration dates of items including transaction type internal use with reason code.

Selections:

• Date From – Default today
• Date to – Default today
• Store – Default first avaible store
• Department – Default all
• Article area – Default all
• Article group – Default all
• Date type – Default all
• Shelf life date – Default today
• All shelf life dates – Default true

Columns:

• EAN Item name – Arcticle name
• Item number – Item id
• Cashier
• Date – End date time defining as transaction date
• Net price – Item price exluding VAT
• Price inc VAT – Item price including VAT
• Quantity
• Cost price - NetCost
• Amount
• Gross profit
• Expiration date – shelf life date
• Date type – shelf life date type
• Reason code
• Action code

Output:

Raport shows list of items for selected store and departments, and also for selected Article ares and groups. It is one row per EAN and present expiration date including transaction type internal use with reason code.

Clarifications:

• Report does not contain sum.
• Report is order by expiration date and department.

Source:

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

CO based on report 0714

Description:

Report allows to follow up article sales on multiple levels with possibility to select specific hourly intervals and exclude specific item groups.

Selections: 

• Date from - Default today
• Date to - Default today
• Hour from - Default 0:00
• Hour to - Default 24:00
• Team - Default all
• Store - Default all
• Department - Default all
• Article area - Default all
• Article group - Default all
• Include VAT - Default on
• Exclude groups - Default false
• Excluded groups - Appears when Exclude groups is switched to true

Output:

Article sale statistics for selected stores, for selected date interval and for selected time interval grouped by department, area and group.

By default data is shown for department and it is possible to drill down to item level manually by clicng plus button or by using expand all button to expand everithing to item level at once.

Columns: 

• Buttons for expanding and collapsing all drilldowns.
• EAN - EAN code
• Item name - Article name
• Quantity
• Total- Quantity sold
• Turnover inc. VAT or Turnover ex. VAT depending on selection.
• Total - Amount sold. Inc. or ex. VAT depending on selection
• Share - Share of this department / area / group / item related to total sale.
• Cost price - Cost price
• Gross profit
• Total - Gross profit amount
• Total % - Gross profit percentage.

Sorting:

• Department number 
• Item Area number 
• Item Group number
• EAN

Clarifications:

• Hour selection applies to each day in selected date period

Source:

• Lindbak POS Reporting cube (OLAP)

CO: 207212. Based on report 0754

Description:

Report allows to find given number of best or worst selling items on multiple levels (amount, quantity, gross profit) in two date intervals. Possible to select specific hourly interval.

Selections: 

• Date from - 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
• Hour from - Default 0:00
• Hour to - Default 24:00
• Team - Default all
• Store - Default all
• Department - Default all
• Article area - Default all
• Article group - Default all
• Number of items - Number of best or worst items to display - default 10
• Sort type - worst or best - report will display given number of worst or best selling items - default best
• Sort measure - amount/quantity/net cost/gross profit/gross profit % - set the measure on which the items are sorted. - default amount
• Vendor - default all
• Subvendor- default all
• Include VAT - Default on
• Exclude groups - Default false
• Excluded groups - Appears when Exclude groups is switched to true

Output:

Sale statistics for selected number of best or worst items per store sorted by selected sort measure devided in two selected date intervals in selected hour range.

Columns: 

• Store
• Dept. - Department
• Area
• Grp. - Item group
• EAN
• Item name
• Quantity
• Turnover ex. VAT
• Gross profit
• Gross profit %
• Num of receipts

Sorting:

• Selected sort measure

Clarifications:

• Hour selection applies to each day in selected date period
• Negative values are colored red

Source:

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

CO: 208778. Based on report 0650 

Description:

Report shows credit sales and payments on account to get a better overview over drive-offs.

Selections:

• Date from - Default today
• Date to - Default today
• Team - Default all
• Retail store - Default all available in selected team

Output:

One row per transaction grouped by store and customer. Page break and total for each store.

Columns: 

• Date - date of the transaction,
• Receipt - receipt number of the transaction,
• Ref.no - reference number of the credit tender transaction,
• Ref.text - reference text of the credit tender transaction,
• Amount - amount inc. VAT of the credit tender transaction,
• Tax amount - VAT amount from articles,
• On account - payments when using payment on account function in POS.

Sorting:

• Store number
• Customer key
• Transaction date

Clarifications:

Transaction can be either Credit sale or Payment on account. If transaction is Payment on account there is no data available for columns: Ref.no and Ref.text

Source:

• Lindbak POS Reporting DW

Description:

Report lists top items sold in selected stores in period time.

Selections:

• Region – Default all
• Store – Default all
• Date from – Default today
• Date to – Default today
• Department – Default all
• Article Group – Default all
• Article Subgroup – Default all
• Vendor – Default all
• Top X – Number of rows, default set 10

Output:

Report shows top x items and item groups with their amount, gross profit and quantity in selected ranges. Report sum up all columns with numbers.

Columns:

• Item num. – Item number
• Item name – Article long name
• Item group – Group number and article group
• Vendor
• name Ex. VAT – Net amount
• Gross profit
• Gross profit % - Gross profit percentage
• Quantity
• Average price inc VAT – Average price including VAT
• Discount ex. VAT - Item discount excluding VAT

Clarifications:

If vendor name is not avaible return empty rows.

Source:

• Lindbak POS Reporting Cube (OLAP)

Description:

Report lists how often customer buys product in comparison to previous period time.

Selections:

• Date from – Default today
• Date to – Default today
• Compare date from - Default year ago from today
• Compate date to - Default year ago from today
• Region – Default all
• Store – Default all

Output:

Report shows amount, number of customers and sold items for selected stores, regions and period time in comparison to previous selected period time. Raport presents percentage differences and sum up all columns for selected stores

Columns:

• Store – Store name
• Region- Team name
• Share – percentage net amount
• Ex. VAT – net amount
• Compared sales ex. VAT – Compared net amount
• Diff % - Percentage difference to compared date
• Customers num – Customer number
• Compared number of customers
• Diff % - Percentage difference to compared date
• Items per customer
• Compared items per customer
• Diff % - Percentage difference to compared date
• Avg. sales customer – Average sales customer
• Compared average sales per customer
• Diff % - Percentage difference to compared date

Clarifications:

Diff % is percentage difference (increase or decrease)  between date and comparable date

Source:

• Lindbak POS Reporting Cube (OLAP)

Description:

Report list shift statistic for selected stores and period time

Selections:

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

Relevant parameters:

•  pDeletedStatuses - Comma separated list of statuses keys not to show in deleted receipts.

Output:

• Report shows shift statistic for each cashier with served customers, null sales and average amount for selected stores and period time.
• Report sum up customers, null sales, deleted amount, deleted quantity and average amount for each store.

Columns:

• Store – Store number and store name
• ShiftID
• Start – Shift start
• Stop – Shift end
• Cashier
• Customers – receipts count
• Nullsale – Total zero count
• Deleted amount – deleted receipts amount
• Deleted quantity – Deleted receipts quantity
• Avg amount – Average amount

Source:

• Lindbak POS Reporting Cube (OLAP)

Based on report 0107, but uses SQL instead of MDX

Descriptions:

Report lists loyalty club sales for selected stores depending on loyalty program and team.

Selections:

• Loyalty program – default 1
• Date from – Default today
• Date to – Default today
• Team – Default all
• Store – Default all

Relevant parameters:

• pCustomerGroupsEmployees – Customer group used for employees, default 1.

Output:

• One row per store.
• Raport show turnover, percentage of total sales, gross profit percentage and average quantity sold.
• Total sum of each column for selected stores.

Columns:

• No – Store number
• Store – Store name
• Turnover
  • Total – total mount
  • Not member – Amount without Loyalty program
  • Member – Amount with Loyalty program
  • Employess – Amount with Customer group
• % of total sales
  • Not member – percentage members without Loyalty program
  • Member – percentage members with Loyalty program
• Gross profit %
  • Total – percentage total of gross profit
  • Not member – percentage of gross profit for members without Loyalty program
  • Member – percentage of gross profit  for members with Loyalty program
  • Employess – percentage of gross profitt for members with customer group
• Average quantity sold
  • Total – quantity of articles per customers
  • Not member - quantity of articles per customers without Customer club
  • Member - quantity of articles per customers with Customer club

Clarifications:

Customer club refers to LoyaltyProgramKey and Employees refers to CustomerGroupKey. Gross profit is a value referred to NetCost deducted from NetAmount.

Source:

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

RTC-27636 / CO-222611

Description:

Report shows information about issued, redeemed and balance for bonus checks, per month and store for the last 12 months.

Selections:

• Loyalty program - Default 1
• Team - Default all
• Store - Default all available in selected teams

Output:

One page per store. For each month sum of issued, redeemed, balance and expired bonus checks. One sum for manual issued checks, checks issued from sales and total. First page of report is total for all stores.

Columns:

• End of month - Shows last date in each month for the last 12 months.
• Bonus type - For each month there is one row for manual issues checks, checks issued from sales and total.
• Issued - Sum of bonus amount issued.
• Redeemed - Sum of redeemed bonus amount.
• Balance - Sum of not exipred, not used bonus amount.
• Expired Sum of bonus amount expired at the end of month.

Sorting:

• Month

Source:

• Lindbak POS Reporting DW

Description:

Report shows payments for invoices.

Selections:

• Store – Default number 100
• Date from – Default today
• Date to – Default today

Output:

Report lists invoice number, created date and amount for each customer for selected store and date range.

Columns:

• Customer num. – Customer number
• Customer – customer name
• Invoice no – Invoice number
• Date – Created date Amount

Source:

• Lindbak POS Reporting DW