Page History

Standard report

Image Added

Image Added

[RTC-39849] TRN: Cashier security statistics report with turnover split and price checks - EG A/S

Image Removed

Description:

Report

provides comprehensive daily settlement and sales statistics per store. Similar to 0780_DailyReport but with enhanced VAT breakdown. Report is divided into multiple sections showing product sales, tender types, cash reconciliation, card payments, and drive-off tracking.

Selections (applies to all sub reports)Selections:

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

Output:

One page per store

One row per cashier

Columns:

• No: Operator number
• Name: Operator name
• Tender (NB! this is tender data and does not represent turnover).
  • Cash
  • Other (ohter than cash)
• Receipts: number of reciepts
• Returns
• Deleted receipts
• Deleted item lines
• Receipts on hold
• Null: Number of drawer opening without any transaction
• Ovr. prc.: Overriden price count
• Scan %: Scan divided by Quantity of sold items
• Discount: Discount quantity
• Price check: How many times price check funtion is used.

Sorting:

• No sorting

Source:

• Lindbak POS Reporting cube (OLAP)

• Single value; default first available from the list

Hidden parameters:

• pFuelItemType: Default \[Article\].\[Item Type\].&\[Fuel\] - Defines which item types qualify as fuel
• pOtherPaymentCards: Default 30,31,32,33,34,35,36,37,38,39 - Payment card numbers for "other payments" section
• pReasonCodeBreakage: Default \[Reason Code\].\[Reason Code\].&\[Avstikk\]&\[Return\] - Reason code for drive-off tracking
• pPriceChannelOutdoor: Default \[Price Channel\].\[Price Channel\].&\[11\] - Price channel qualifying as outdoor sales

Source:

• Lindbak POS Reporting Cube (OLAP) - All reports
• Lindbak POS Reporting DW - 1812, Item Group Driveoff section only

CO-99233,  PBI#155902. Based on report 0519

Image AddedImage Removed

Description:

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

Selections:

• Loyalty program – Default loyalty program
• Date from – Default first day of a current weektoday
• 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:

• Store – Default all

Output:

Report is divided on 4 tables and 2 charts. Every table has a stotal sumamry at the end table for each column.

Columns:

• New members in period table
  • Sex – Female, male and unknown
  • This year – Number of new members
  • Last year – Number of new members last year
• New member in period circle chart
  • This year – New member this year
  • Last year – New member last year
• Sales statistics table
  • Member and not member rows
  • Num of receipts – Number of receipts
  • Tot. sales amt. – Total sales amount
  • Avg amount – Average amount
  • Items – Items quantity
  • Items/cust – Number of items over number of sales for members.
  • Gross profit
  • Gr. prof. % - Gross profit percentage
• Sales by gender/age groups table
  • Age group
  • Male/Female
    • Sales – Sales amount
    • Gross profit
    • Gr. prof. % - Gross profit percentage
• Sales by gender/age groups chart
  • X – axis – Age group
  • Y – axis – Sales amount
  • Legend – Male and Female bars
• Sales by gender/department table
  • Department
  • Sales amount
    • Male – Male sales amount
    • Female – Female sales amount
    • Unknown – Unknown sales amount
    • Total – Total amount for all genders
  • Total %
    • Male – Male sales amount percentage
    • Female – Female sales amount percentage
    • Unknown – Unknown sales amount percentage
    • Total – Total sales amount for all genders percentage

Source:

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

CO-92729, PBI#155905

Image AddedImage Removed

Description:

Report lists sales per department and comparison sales in selected period of timestores in loyalty clubs. Report also present turnover chart.

Selections:

• Region Loyalty program – Default allStore – Default allfirst loyalty program
• 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
• Default today
• Team Department – Default all
• Article group Store – Default all
• Article subgroup – Default all
• Vendor Department – Default all

Output:

• Report shows sales statistics in loyalty club for selected stores. Report has a summary for at the end of each column for all selected departments.
• Summary totals in the beginning of new hierarchy level for:
  • Department
  • Article group
  • Article subgroup

Columns:

• .
• Report has a turnover bar chart. On x-axis are turnover information bars: total, not member, member  and employees. On y-axis is turnover amount.

Columns:

• No – Store number
• Store – Store name
• Turnover
  • Total – Total turnover amount
  • Not member – Turnover amount without members
  • Member - Turnover amount with members
  • Employees – Turnover employees amount
• % of total sales
  • Not member – Percentage of total sales without members
  • Member - Percentage of total sales with members
• Gross profit %
  • Total – Total gross profit percentage
  • Not member – Total gross profit percentage without members
  • Member - Total gross profit percentage with members
  • Employees – Total gross profit percentage
• Average quantity sold
  • Total
  • Not member
  • Member
• Average sale in sum
  • Total
  • Not member
  • Member
• Buttons for expanding and collapsing all drilldowns
• Department – Department number and name
• Share Ex. VAT – Sales Excluding VAT
• Compared sales ex. VAT – Compared sales excluding VAT
• Diff % - Difference percentage between sales excluding VAT
• Gross profit amt. – Gross profit amount
• Compared gross profit
• Gross profit % - Gross profit percentage
• Compared gross profit % - Compared gross profit percentage
• Diff. gr. prof. %-units – Difference gross profit percentage in units
• Quantity
• Compared quantity
• Average sales per customer inc VAT – Average sales per customer including VAT
• Discount ex. VAT – Discount excluding VAT
• Activity result – Activity result between discount exc. VAT and exc. VAT

Source:

• Lindbak POS Reporting Cube (OLAP)

Image RemovedImage Added

Description:

Report lists sales per assortment and comparison sales in selected period of time.

Selections:

list shift statistic for selected stores and period time

Selections:

• Date from – Default today
• Date to – default 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
• Article group – Default all
• Article subgroup – Default all
• Vendor – Default all
• Item number – Default empty

Output:

• Report has a summary for each column for all selected stores.
• Summary totals in the beginning of new hierarchy level for stores.

Columns:

• 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
• Buttons for expanding and collapsing all drilldowns
• Store – Store name
• Region – Region team Share Ex. VAT – Sales Excluding VAT
• Compared ex. VAT – Compared sales excluding VAT
• Diff % - Difference percentage between sales and compared sales
• Gross profit amt. – Gross profit amount Compared gross profit
• Gross profit % - Gross profit percentage
• Compared gross profit % - Compared gross profit percentage
• Diff gr. prof. %-units – Difference gross profit percentage in units
• Quantity
• Compared quantity
• Average sales per customer inc. VAT – Average sales per customer including VAT
• Compared average sales per customer inc. VAT – Compared average sales per customer including VAT

Source:

• Lindbak POS Reporting Cube (OLAP)

Image RemovedImage Added

Description:

Report lists dashboard comparison sales, gross profit and customers with compare date for one day and the whole weekReport allow to follow up tender per shift. Report has two subreports, one settlement and second about statistics.

Selections:

• Date – from - Default today
• Compare date – Default last week from today
• Team – Default all
• Store – Defaul all

Output:

• Report shows sales, gross profit and customers statistics for selected date and selected compared date. Appropriately report shows statistics for whole week for that selected day.
• Report has six Gauge panels which compared statistics from current hour in percentage.

Columns:

• Date to - Default today
• Retail Store - Default select a single store
• Workstation - Default all
• Shift - Default select a single value

Subreports:

Source:

• Lindbak POS Reporting Cube (OLAP)

Image RemovedImage Added

Description:

Report lists reconciliation of giftcardsmember sales per association.

Selections:

• Type Loyalty program – Default gift card
• GiftCard type- Default all
• Store – Default all
• loyalty program
• Date from – Default today
• Date to – Default today
• Customer – Default empty

Output:

• Report

Columns:

• Store – Store number
• Issued – Sum amount issue
• Redeemed – Sum amount redeemed
• Accumulater expired balance
• Corrections – Corrections amount

Interactive sorting:

Interactive sorting on all columns

Source:

• Lindbak Retail

• has expand all and collapse all buttons for drilldowns.
• Totals in the beginning of new hierarchy level for:
  • Association No.
  • Association

Columns:

• Buttons for expanding and collapsing all drilldowns
• Association
• No. Association
• Amount
• Bonus amount
• Members in period
• Linked members

Source:

• Lindbak POS Reporting Cube (OLAP)

Image RemovedImage Added

Description:

Report lists giftcard balance per store.new discount tgroup for member

Selections:

• Store Quarter – Default allquarter 1Type
• Show – Default gift cardGiftCard type – Default allall (Changed discount group or unchanged discount group)

Output:

Report has a summary at the end of table.

Columns:

shows customer discount group list for member

Columns:

• Customer num. – Customer number
• Customer – Customer name
• So far this year – Amount this year
• Estimated amount
• Discount group
• Estimated discount group
• Store – Store number
• Balance - ScripBalance

Source:

Lindbak

POS Reporting Cube (OLAP)

Image RemovedImage Added

Description:

Report lists reconciliation of giftcards per store.new member per week/month

Selections:

• Date from Loyalty program – Default todayDate to loyalty program
• Calculate per – Default todayper month
• Type Year – Default gift card
• Store – Default all
• select a single value

Output:

Report has table for each store and summary at the end of each column on that tableshows two charts and one table for new members per week or per month.

Columns:

• Giftcard number
• Issued amount
• Redeemed amount
• Balance correction amount
• Issued date
• Redeemed date

Interactive sorting:

• Total number of members chart
  • X-axis – Time
  • Y-axis – Members – number of members
• New members per week/month chart
  • X-axis – Time
  • Y-axis – New members number
  • Legend – Number of members for this year and last year
• New members per week table
  • Week
  • This year/Last year
    • Increase – Number of new members
    • Total
  • Total increase
    • Quantity – Difference between this year and last year
    • Percent – Percentage difference between this year and last year

Clarifications:

Negative values are marked redInteractive sorting on all columns.

Source:

• Lindbak RetailPOS Reporting DW

Based on report 0107, but uses SQL instead of MDX

Image Added

Descriptions:

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

CO-99244, PBI#155899

Image Removed

Description:

Report lists members and e-mail/SMS subscriptions

Selections:

• Loyalty program – default 1
• Date from – Default today
• Date to – Default today
• Team – Default Loyalty programall
• 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 number and store name
• Members – Members quantity
• Email – Email quantity
• Mobile – Mobile quantity

• 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

CO-99233,  PBI#155902. Based on report 0519: 154926

Image AddedImage Removed

Description:

Report lists loyalty cashiers statistics for selected stores.

Selections:

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

Output:

Report is divided on 4 tables and 2 charts. Every table has a stotal sumamry One page per store. Report has a summary for each column at the end table for each columneach store's table.

Columns:

• Cashier No and Name – Cashier number and cashier name
• Returns quantity and amount
• Deleted receipts quantity and amount
• Deleted item lines quantity and amount
• Manual discounts quantity and amount
• Diff settlement amount – Difference settlement amount
• Deleted web order quantity and amount
• New customer orders quantity and amount
• Offline coupons quantity and amount 
• Personnel disc. qty – Personnel discount quantity
• New members in period table
  • Sex – Female, male and unknown
  • This year – Number of new members
  • Last year – Number of new members last year
• New member in period circle chart
  • This year – New member this year
  • Last year – New member last year
• Sales statistics table
  • Member and not member rows
  • Num of receipts – Number of receipts
  • Tot. sales amt. – Total sales amount
  • Avg amount – Average amount
  • Items – Items quantity
  • Items/cust – Number of items over number of sales for members.
  • Gross profit
  • Gr. prof. % - Gross profit percentage
• Sales by gender/age groups table
  • Age group
  • Male/Female
    • Sales – Sales amount
    • Gross profit
    • Gr. prof. % - Gross profit percentage
• Sales by gender/age groups chart
  • X – axis – Age group
  • Y – axis – Sales amount
  • Legend – Male and Female bars
• Sales by gender/department table
• Department
• Sales amount
  • Male – Male sales amount
  • Female – Female sales amount
  • Unknown – Unknown sales amount
  • Total – Total amount for all genders
Total %
• Male – Male sales amount percentage
• Female – Female sales amount percentage
• Unknown – Unknown sales amount percentage
Total – Total sales amount for all genders percentage

Source:

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

RTC-27636 / CO-92729, PBI#155905222611

Image RemovedImage Added

Description:

Report lists sales in selected stores in loyalty clubs. Report also present turnover chart.shows information about issued, redeemed and balance for bonus checks, per month and store for the last 12 months.

Selections:

• Loyalty program – - Default first loyalty program
• Date from – Default today
• Date to – Default today
• 1
• Team - Team – Default all
• Store – - Default all Department – Default allavailable in selected teams

Output:

• Report shows sales statistics in loyalty club for selected stores. Report has a summary at the end of each column.
• Report has a turnover bar chart. On x-axis are turnover information bars: total, not member, member  and employees. On y-axis is turnover amount.

Columns:

• No – Store number
• Store – Store name
• Turnover
  • Total – Total turnover amount
  • Not member – Turnover amount without members
  • Member - Turnover amount with members
  • Employees – Turnover employees amount
• % of total sales
  • Not member – Percentage of total sales without members
  • Member - Percentage of total sales with members
• Gross profit %
  • Total – Total gross profit percentage
  • Not member – Total gross profit percentage without members
  • Member - Total gross profit percentage with members
  • Employees – Total gross profit percentage
• Average quantity sold
  • Total
  • Not member
  • Member
• Average sale in sum
  • Total
  • Not member
  • Member

Source:

• Lindbak POS Reporting Cube (OLAP)

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

RTP-43325

Image Added

Image Removed

Description:

Report

displays item quantity sales data aggregated by retail store with support for mix and campaign analysis. It provides detailed sales information including quantity sold, number of customers, turnover, and promotional sales breakdown. The report allows drill-down from article level to individual store performance.

Selections:

• Date from
-
• : Default today
• Date to
-
• : Default today
• Retail Store - Default select a single store
• Workstation - Default all
• Shift - Default select a single value

Subreports:

Source:

• Lindbak POS Reporting Cube (OLAP)

• Team: Multivalue; default all
• Profile: Multivalue; default all
• Store: Multivalue; default all (filtered by Team selection)
• Department: Multivalue; default all
• Article area: Multivalue; default all
• Article group: Multivalue; default all
• Mix: Multivalue; default all
• EAN list: Text input; default empty (comma-separated list of EAN codes)
• Include VAT: Boolean; default true (toggles between amounts including/excluding VAT)
• Expand all: Boolean; default false (when true, automatically expands all article groups to show store details)

Output:

Article sales statistics grouped by EAN with drill-down capability to individual store level. Report shows:

• Summary row per article (EAN) with aggregated data across all stores
• Detail rows per store showing individual store performance (visible when expanded)
• Mix numbers and campaign information displayed as comma-separated lists when multiple values exist

Columns:

• Retail Store: Article EAN and name (at summary level)
• Articles: Article EAN and name (at detail level)
• Quantity: Total quantity sold
• Customers: Distinct receipt count (number of customers)
• Mix: Mix numbers and names (comma-separated if multiple mixes apply to the article-store combination)
• Campaigns: Campaign numbers and names (comma-separated if multiple campaigns apply)
• Turnover: Total sales amount (with or without VAT based on Include VAT parameter)
• Sold in Promotion: Quantity sold with discounts/campaigns (calculated as: Total Quantity - Quantity Not Discounted)
• % of Total Sales: Percentage of article turnover compared to total report turnover

Sorting:

• Primary: EAN (ascending)
• Secondary: Retail Store Number (ascending)

Clarifications:

• Quantity Not Discounted logic: Shows quantity only when Mix is 1, -1, or Unknown AND Campaign is Adhoc, NoCampaign, Not Available, or Unknown. Otherwise returns NULL.
• Mix and Campaign Display: Uses LookupSet function to aggregate multiple mixes/campaigns per article-store combination with "|" delimiter for matching
• Parameter Dependencies: Store parameter options are dynamically filtered based on Team selection

RTC-46626

Image AddedImage Removed

Description:

Report lists new discount tgroup for member

Selections:

• Quarter – Default quarter 1
• Show – Default all (Changed discount group or unchanged discount group)

Output:

Report shows customer discount group list for member

Columns:

• Customer num. – Customer number
• Customer – Customer name
• So far this year – Amount this year
• Estimated amount
• Discount group
• Estimated discount group

Source:

Lindbak POS Reporting Cube (OLAP)

shows number of sold items per day of week. Grouped by week.

Selections:

• From date - default first date of current week.
• To date - default today
• Team - default all
• Retail store - default all
• Department - default all
• Article area - default all
• Article group - default all
• Article subgroup - default all
• Vendor - default all

Note that is is possible to select default e.g article groups by selecting group(s) in parameter pArticleGroup

Output:

One row for ean item with columns for each day of week. In addition one column for notes.

Columns:

• EAN - EAN
• Item ID - Item number
• Item name - Item name
• Week - Week number
• Monay - Friday - One column for each day
• Remarks / Notes - Empty column

RTC-46798

Image Added

Description

Based on report 0107, but uses SQL instead of MDX

Image Removed

Descriptions:

Report lists sale statistics for total sales also sales statistics for member and campaign sales. Graph in bottom showing Total, campaign and member sales.

Report show only hours with sales loyalty club sales for selected stores depending on loyalty program and team.

Selections:

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

Relevant parameters:

• - default today
• Hour from - default 0 (start of hour, meaning 0 is between 0 and 1.
• Hour from - default 23 (start of hour, meaning 23 is between 23 and 00.
• Profile - default All
• Team - default All
• Retail store - default All
• Department - default All
• Article area - default All
• Article group - default All
• EAN list - default empty
pCustomerGroupsEmployees – Customer group used for employees, default 1.

Output:

One row per hour with sale. One page per store

and one for All stores. Bottom of page showing graph for Total-, Campaign- and Member-sales.

Columns:

• Hour - Showing from - to hour.
• Total
  • Amount - Sales amount including VAT
  • Net cost - Net cost
  • VAT amount - VAT amount
  • Gr. profit % - Gross profit in percentage
  • Total % - Share of sales for this hour
  • Article count - Number of articles sold
  • Customer count - Number of receipts / customers
  • Sales / Customer - Average sales per customer
  • Sales / Item - Average sales amount per item
  • Articles / Customer - Average items per customer / receipt
• Members (where there is member in receipt)
  • Sales amount - Sales amount including VAT
  • Articles - Number of articles
  • Customer - Number of customers
• Campaign (where there is discount type Campaign)
  • Sales amount - Sales amount including VAT
  • Articles - Number of articles
  • Customer - Number of customers

Sorting:

Sorted by hour, earliest first

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)

RTC-46685

Image Added

CO: 154926

Image Removed

Description:

Report lists cashiers statistics for selected storesshowing revenue per cash regsiter for store with sale.

Selections:

• Date from – Default - default today
• Date to
– Default today
• Store – Default all
Operator – Default operator
• - default today
• Profile - default all
• Team - default all
• Retail store - default all

Output:

One page per store. Report has a summary for each column at the end each store's table.

Columns:

• Cashier No and Name – Cashier number and cashier name
• Returns quantity and amount
• Deleted receipts quantity and amount
• Deleted item lines quantity and amount
• Manual discounts quantity and amount
• Diff settlement amount – Difference settlement amount
• Deleted web order quantity and amount
• New customer orders quantity and amount
• Offline coupons quantity and amount 
• Personnel disc. qty – Personnel discount quantity

row for each workstation in store with statistics about customers and sales. NB! Showing all cash registers for store but only stores with sales. Also showing total per store and total nonsale per store.

Columns:

• Customers - Number of customer/receipts
• Sales / customer - Average sale per customer/receipt
• Articles / customer - Average article per customer/receipt
• GR + return - Gross sales including return. Gross sales is sales including depositrefunt
• Amount - Sales amount including VAT

Source:

Lindbak POS Reporting Cube (

Olap)

RTC-27636 / CO-22261146808

Image AddedImage Removed

Description:

Report shows information about issued, redeemed and balance for bonus checks, per month and store for the last 12 monthsshowing number of sold items per hour for selected date. Also showing total for hierarchy.

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:

• Date - single selction of date, default today
• Hour from - Showing only hours from selected hour. Hour in selection is start of hour (7 is hour 7-8). Default 7.  Default can be changed by parameter pHourFrom
• Hour to - Showing only hours to selected hour. Hour in selection is start of hour (23 is hour 23-00). Default 23. Default can be changed by parameter pHourTo
• Profile - default All
• Team - default All
• Retail store - default All
• Department - default All
• Article area - default All
• Article group - default All

Not that is is possible to select default e.g article groups by selecting group(s) in parameter pArticleGroup

Output:

One row per item with total for group, area and department.

Columns:

• EAN - EAN
• Item name - Item name
• Vendor number - Vendor number
• Date - Date selected
• One column for each selected hour
Month

Source:

Lindbak POS Reporting

Cube (Olap)

RTC-4662646772

Image RemovedImage Added

Description:

Report shows number of sold items per day of weekReport showing statistics about sales, gross profit and discount. Report is either on department, are or group depending on selection. Also share of gross profit and sales for department and store.

Selections:

From date
• Date from - default
first date of current week.
• today
• Date to
To date
• - default today
• Team - default all
• Retail store - default all
• Department - default all
• Article area - default all
• Article group default all
• Profile - default all
Article subgroup
• Team - default all
Vendor
• Retail store - default all

• Report type - Which lever of hierarchy report will be created on. Default Department.

Output:

One row for ean item with columns for each day of week. In addition one column for notes.

Columns:

line per level of selected hierarcy with total for department.

Columns:

• Cost price - Net cost
• Sales - Sales amount including VAT
• Gr.prof. - Gross profit in amount
• GP% - Gross profit in percentage
• Customer disc. - Customer grup discount
• Eployee discount - Personal discount
• General discount - Other discounts except customer and personal
• Gross sales - Sales amount including depositdefund items
• Department
  • Part of sales - Percentage part of sales per department
  • Part of GP - Percentage part of gross profit per department
• Store 
  • Part of sales - Percentage part of sales per store
  • Part of GP - Percentage part of gross profit per store
• EAN - EAN
• Item ID - Item number
• Item name - Item name
• Monay - Friday - One column for each day
Remarks / Notes - Empty column.

Source:

Lindbak POS Reporting Cube (Olap)

RTC-4679847002

Image RemovedImage Added

Description:

Report lists sale statistics for total sales also sales statistics for member and campaign sales. Graph in bottom showing Total, campaign and member sales.

Report show only hours with sales.

Selections:

• Date from - default today
• Date to - default today
• Hour from - default 0 (start of hour, meaning 0 is between 0 and 1.
• Hour from - default 23 (start of hour, meaning 23 is between 23 and 00.
• Profile - default All
• Team - default All
• Retail store - default All
• Department - default All
• Article area - default All
• Article group - default All
• EAN list - default empty

Output:

One row per hour with sale. One page per store and one for All stores. Bottom of page showing graph for Total-, Campaign- and Member-sales.

Columns:

• Hour - Showing from - to hour.
• Total
  • Amount - Sales amount including VAT
  • Net cost - Net cost
  • VAT amount - VAT amount
  • Gr. profit % - Gross profit in percentage
  • Total % - Share of sales for this hour
  • Article count - Number of articles sold
  • Customer count - Number of receipts / customers
  • Sales / Customer - Average sales per customer
  • Sales / Item - Average sales amount per item
  • Articles / Customer - Average items per customer / receipt
• Members (where there is member in receipt)
  • Sales amount - Sales amount including VAT
  • Articles - Number of articles
  • Customer - Number of customers
• Campaign (where there is discount type Campaign)
  • Sales amount - Sales amount including VAT
  • Articles - Number of articles
  • Customer - Number of customers

Sorting:

Sorted by hour, earliest first.

Source:

Lindbak POS Reporting Cube (Olap)

showing statistics per cashier in store. Because of performence report has single selct on store.

NB! Report require minimum reporting v84

Selections:

• Date from - default today
• Date to - default today
• Profile - defalt all
• Team - default all
• Retail store - single selct, first available store selected
• Operator - defalt all for selected store
• Cashiers with no sale - default off. If on report will list all cashiers from store even if no sales

Hidden parameters:

• pDeletedArticlesStatuses - Which deleted status will be included in row for Deleted items. Default: 2 - Deleted,12 - Deleted is last registered, 13 - Deleted is last remaining,14 - Deleted is last remaining and is last registered
• pDeletedOtherStatuses - Which deleted status will be included in row for Deleted other. Default: 7 - Deleted from on hold, 10 - Deleted in on hold from on hold, 15 - Deleted unfinished receipt, 16 - Deleted from unfinished receipt
• pDeletedReceiptStatuses - Which deleted status will be included in row for Deleted receipt. Default: 3 - Delted receipt
• pGeneralDiscount - Which discount types will be included in row for General discount. Default: 2 - Line discount, 3 - Group discount, 4 - Customer group discount, 5 - Adhoc package, 6 - Model discount, 7 - Member discount, 8 - Campaign discount, 9 - Giftcard discount, 10 - Personal discount, 11 - Subtotal discount
• pManualDepositRefundInArtEAN - Comma separated list of items which will be included in row for Deposit refund manual. Default 99

Output:

Rows for data with one column for each operator.

Rows:

• Store - Storename and number
• Cashier - Cashier name and number
• Net amount - Net amount sales
• Quantity - Number of articles sold
• Sale/cust - Average sale per customer
• Item/cust - Average items per customer
• Total items open ex. PLU - Items sold without open price
• Total items open PLU - Items sold with open price
• Nullsale - Number of receipts finished with salesamount 0
• Total credit sales Amount - Amount sold on tendertype Credit
• Total credit sales - Number of sales with tendertype Credit
• Giftcards out Amount - Amount of sold gift cards (sale with articletype giftcard)
• Giftcards out - Number of gift cards sold (sale with articletype giftcard)
• Returned items Amount - Amount of returned items (sales with direction in)
• Returned items - Quantity of returned items (sales lines with direction in)
• General discount Amount - Sum of discount for discount types set in parameter pGeneralDiscount
• General discount - Quantity of items with discount types set in parameter pGeneralDiscount
• Deleted items Amount - Amount of deleted items with deleted status from parameter pDeletedArticlesStatuses
• Deleted items - Quantity of deleted items with deleted status from paramter pDeletedArticlesStatuses
• Deleted other Amount - Amount of deleted items with deleted status from parameter pDeletedOtherStatuses
• Deleted other - Quantity of delted items with deleted status from parameter pDeletedOtherStatuses
• Deleted receipt Amount - Amount of deleted receipts with deleted status from parameter pDeletedReceiptStatuses
• Deleted receipt - Quanity of deleted receipts with deleted status from parameter pDeletedReceiptStatuses
• Deposit - Number of deposit sales
• Difference - Difference between cash from balance and cash from tender
• Received deposit refund (manual) Amount - Sum of sales with direction In from articles with article type = depositrefund where article is in parameter pManualDepositRefundInArtEAN 
• Received deposit refund (manual) - Quantity of items with direction In from articles with article type = depositrefund where article is in parameter pManualDepositRefundInArtEAN 
• Received deposit refund (auto) Amount - Sum of sales with direction In from articles with article type = depositrefund where article is NOT in parameter pManualDepositRefundInArtEAN 
• Received deposit refund (auto) - Quantity of items with direction In from articles with article type = depositrefund where article is NOT in parameter pManualDepositRefundInArtEAN 

Source: 

RTC-4680847005

Image RemovedImage Added

Description:

Report showing number of sold items per hour for selected date. Also showing total for hierarchyfor comparing basic sales between two stores with date selection for each store.

Selections:

• Date from -
single selction of date, default today
• Hour from - Showing only hours from selected hour. Hour in selection is start of hour (7 is hour 7-8). Default 7.  Default can be changed by parameter pHourFrom
• Hour to - Showing only hours to selected hour. Hour in selection is start of hour (23 is hour 23-00). Default 23. Default can be changed by parameter pHourTo
• Profile - default All
• Team - default All
• Retail store - default All
• Department - default All
• Article area - default All
• Article group - default All

Not that is is possible to select default e.g article groups by selecting group(s) in parameter pArticleGroup

Output:

One row per item with total for group, area and department.

Columns:

• Start date for reference store. Default today
• Date to - End date for reference store. Default today
• Compare date from - Start date for comparing store. Default today
• Compare date to - End date for comparing store. Default today
• Retail store ref - Reference store. Default all
• Retail store comp - Comparing store. Default all
• Department - default all
• Article area - default all
• Article group - default all
• Article subgroup - default all
• Statistic - Which level of hierarcy to run report for. Department, Area, Group, SubGroup and Item. Default Department.

Output:

One row for each level of selected hierarchy. Totals for all level of hierarchy above selected. Hierarchy above selected is colored dark grey.

Columns:

• Item
  • Number and name of hierarchy.
• Reference store with date selections.
  • Sales ex/VAT - Sales excluding VAT
  • Gr.prof. - Gross profit
  • Gr.prof. % - Gross profit in percentage
• Comparing store with date selections
  • Sales ex/VAT - Sales excluding VAT
  • Gr.prof. - Gross profit
  • Gr.prof. % - Gross profit in percentage
• Difference
  • Sales ex/VAT - Difference between reference store and comparing store
  • Gr.prof. - Difference between reference store and comparing store
  • Gr.prof. % - Difference between reference store and comparing store
• EAN - EAN
• Item name - Item name
• Vendor number - Vendor number
• Date - Date selected
One column for each selected hour

Source:

Lindbak POS Reporting Cube (Olap)

RTC-4677247013

Image RemovedImage Added

Description:

Report showing statistics about sales, gross profit and discount. Report is either on department, are or group depending on selection. Also share of gross profit and sales for department and store.giving information about revenue payment methods and settlement for cashiers

Selections:

• Date from - default today
• Date to - default today
Department
• Team - default all
Article area
• Profile - default all
• Article group default all
Profile
• Retail store - default all
Team
• Operator - default all
• Retail store - default all
Report type - Which lever of hierarchy report will be created on. Default Department.
• for selected store(s)

Output:

One line per level of selected hierarcy with total for departmentGrouped by store with one row for each cashier.

Columns:

• Cashier - <storenum>-<cashiernum>
• First name - First name of cashier
• Last name - Last name of cashier
• Registered revenue
• Cost price - Net cost
Sales
• - Sales amount including VAT
• Gr.prof. - Gross profit in amount
• GP% - Gross profit in percentage
• Customer disc. - Customer grup discount
• Eployee discount - Personal discount
• General discount - Other discounts except customer and personal
• Gross sales - Sales amount including depositdefund items
• Department
  • Part of sales - Percentage part of sales per department
  • Part of GP - Percentage part of gross profit per department
Store 
• Part of sales - Percentage part of sales per store
Part of GP - Percentage part of gross profit per store
• Bank card - Tender used with bank card (CreditDebit)
• Credit - Tender used with Credit
• Paid in - Controltransaction with Paid in
• Drop / paid out - Controltransactions with Drop and paid out
• Other payment methods - Tender with tender types not mentioned above or below.
• Received cash/check - Tender used with Cash and Check
• Cash settlement - Balance transaction with tender type Cash and Check
• Difference - Difference between Cash Settlement and Received cash/check

Source:

Lindbak POS Reporting Cube (Olap)

RTC-4700247014

Image RemovedImage Added

Description:

Report showing statistics per cashier in store. Because of performence report has single selct on store.NB! Report require minimum reporting v84giving information about revenue payment methods and settlement for cash registers

Selections:

• Date from - default today
• Date to - default today
• Profile - defalt all
• Team - default all
• Retail store - single selct, first available store selected
• Operator - defalt all for selected store
• Cashiers with no sale - default off. If on report will list all cashiers from store even if no sales

Hidden parameters:

• pDeletedArticlesStatuses - Which deleted status will be included in row for Deleted items. Default: 2 - Deleted,12 - Deleted is last registered, 13 - Deleted is last remaining,14 - Deleted is last remaining and is last registered
• pDeletedOtherStatuses - Which deleted status will be included in row for Deleted other. Default: 7 - Deleted from on hold, 10 - Deleted in on hold from on hold, 15 - Deleted unfinished receipt, 16 - Deleted from unfinished receipt
• pDeletedReceiptStatuses - Which deleted status will be included in row for Deleted receipt. Default: 3 - Delted receipt
• pGeneralDiscount - Which discount types will be included in row for General discount. Default: 2 - Line discount, 3 - Group discount, 4 - Customer group discount, 5 - Adhoc package, 6 - Model discount, 7 - Member discount, 8 - Campaign discount, 9 - Giftcard discount, 10 - Personal discount, 11 - Subtotal discount
• pManualDepositRefundInArtEAN - Comma separated list of items which will be included in row for Deposit refund manual. Default 99

Output:

Rows for data with one column for each operator.

Rows:

• Store - Storename and number
• Cashier - Cashier name and number
• Net amount - Net amount sales
• Quantity - Number of articles sold
• Sale/cust - Average sale per customer
• Item/cust - Average items per customer
• Total items open ex. PLU - Items sold without open price
• Total items open PLU - Items sold with open price
• Nullsale - Number of receipts finished with salesamount 0
• Total credit sales Amount - Amount sold on tendertype Credit
• Total credit sales - Number of sales with tendertype Credit
• Giftcards out Amount - Amount of sold gift cards (sale with articletype giftcard)
• Giftcards out - Number of gift cards sold (sale with articletype giftcard)
• Returned items Amount - Amount of returned items (sales with direction in)
• Returned items - Quantity of returned items (sales lines with direction in)
• General discount Amount - Sum of discount for discount types set in parameter pGeneralDiscount
• General discount - Quantity of items with discount types set in parameter pGeneralDiscount
• Deleted items Amount - Amount of deleted items with deleted status from parameter pDeletedArticlesStatuses
• Deleted items - Quantity of deleted items with deleted status from paramter pDeletedArticlesStatuses
• Deleted other Amount - Amount of deleted items with deleted status from parameter pDeletedOtherStatuses
• Deleted other - Quantity of delted items with deleted status from parameter pDeletedOtherStatuses
• Deleted receipt Amount - Amount of deleted receipts with deleted status from parameter pDeletedReceiptStatuses
• Deleted receipt - Quanity of deleted receipts with deleted status from parameter pDeletedReceiptStatuses
• Deposit - Number of deposit sales
• Difference - Difference between cash from balance and cash from tender
• Received deposit refund (manual) Amount - Sum of sales with direction In from articles with article type = depositrefund where article is in parameter pManualDepositRefundInArtEAN 
• Received deposit refund (manual) - Quantity of items with direction In from articles with article type = depositrefund where article is in parameter pManualDepositRefundInArtEAN 
• Received deposit refund (auto) Amount - Sum of sales with direction In from articles with article type = depositrefund where article is NOT in parameter pManualDepositRefundInArtEAN 
• Received deposit refund (auto) - Quantity of items with direction In from articles with article type = depositrefund where article is NOT in parameter pManualDepositRefundInArtEAN 

Source: 

Lindbak POS Reporting Cube (Olap)

• Team - default all
• Profile - default all
• Retail store - default all
• Workstation - default all for selected store(s)

Output:

Grouped by store with one row for each workstation.

Columns:

• Workstation - <storenum>-<workstationnum>
• Registered revenue - Sales amount including VAT
• Bank card - Tender used with bank card (CreditDebit)
• Credit - Tender used with Credit
• Paid in - Controltransaction with Paid in
• Drop / paid out - Controltransactions with Drop and paid out
• Other payment methods - Tender with tender types not mentioned above or below.
• Received cash/check - Tender used with Cash and Check
• Cash settlement - Balance transaction with tender type Cash and Check
• Difference - Difference between Cash Settlement and Received cash/check

Source:

Lindbak POS Reporting Cube (Olap)