Versions Compared

Old Version 287

changes.mady.by.user Jakub Bańkowski

Saved on

compared with

New Version 288

changes.mady.by.user Atle Olaf Hanssen

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
title0757_MixSales

Description:

Reports lists mix coupons for selected stores in selected period of time.

Selections:

  • Date from - Default today
  • Date to - Default today
  • Profile - Default all
  • Team - Default all
  • Store - Default all
  • Mix - Default all

Output:

Report shows extended mixmatch sales statistics. For one page per store there is a list grouped by mix. Report has a total summaty at the end of table.

Columns:

  • Mix - Mix number and mix name
  • EAN
  • Item name
  • Department
  • Item area
  • Item group
  • % of total sales - Percentage of total turnover excluding VAT
  • Items sold - Number of items sold in mix
  • % items sold - Percetnage of item sold in mix
  • Discount ex. VAT - Mix discounts excluding VAT
  • Receipts with mix
  • Share mix receipts - Share of mix receipts
  • Amount in mix receipts ex. VAT - Amount in mix receipts excluding VAT
  • Avg. sales customer - Average sales customer
  • Gr. prof. % mix - Gross profit percentage mix
  • Gr. prof. % total - Gross profit percentage total
  • Gross profit

Clarifications:

Report has a star explanation for a few columns. It means that summary values for particular mix are calculated including all transactions in store. As an example '% Items sold' is calculating by taking quantity and dividing it by whole store quantity. For whole mix it will be store quantity of all items in store. For particular article in that mix '% Items sold', quantity of that product in mix will be divided by all articles in that mix. Summary for mix (grey grouped row) takes whole statistics about store, even if it is not mix.

Source:

  • Lindbak POS Reporting Cube (OLAP)


Anchor
0758_SalesPerHour
0758_SalesPerHour

Expand
title0758_SalesPerHour

CO-271850 based on 0603_SalesPerHour


Image Added


Description:

Report lists sales per hour with counting customer inside and outside. It also compares inside / outside data with selected period.

Selections:

  • Periode – default month
  • Year – Default current year
  • Month – Default current month
  • Week – Default current week
  • Date from – Default today
  • Date to – Default today
  • Compare date from - Default yesterday.
  • Compare date to - Default yesterday.
  • Profile – Default all
  • Team – Default all
  • Store – Default all
  • Exclude groups – Default false
  • Excluded groups – Default list of excluded groups

Parameters:

  • pExcludedGroupsList - Parameter to create list of itemgroups to use in excluded groups selection (<name>;<itemgroupnumber>,<name>;<itemgroupnumber>). Default = Bilvask;93
  • pPriceChannelIn - Parameter to define pricechannel for inside customers. Default = [Price Channel].[Price Channel Key].&[Cashier]
  • pPriceChannelOut - Parameter to define pricechannel for outside customers. Default = [Price Channel].[Price Channel Key].&[ShopAndGoCheckTerminal]
  • pHourFrom and pHourTo - Parameters to define which hours should be shown in report. Default 0 - 23.

Output:

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

Columns:

  • Hour – Hour of a day
  • Sales – Sales amount
  • Net cost
  • VAT – VAT amount
  • Gr. prof. % - Gross profit percentage
  • Share
  • Items – Sales quantity
  • Quantity - Customer inside/Customer outside quantity for period and comparison period
  • Sale per customer - Customer inside/Customer outside sale per customer for period and comparison period
  • Sales/item – Sales amount divided by item quantity Items per customer
  • Items per customer
  • Sales – Campaign sales amount
  • Items – Campaign item quantity
  • Customers – Campaign customer count

Source:

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


Anchor
0780_DailyReport
0780_DailyReport

...