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)

• Quantity (interactive)

• Gross profit (interactive)

Source:

• Lindbak POS Reporting DW

Standard report

Description:

• Report is divided 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 divided 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 divided sections per each selected cashier. Each section shows sales statistics per vendor.

Selection:

• Date from: Default today

• Date to: Default today

• Retail store: Default first 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 divided 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

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

• Quantity

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

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: department 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 compare 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 hierarchy levels (department, area, group, subgroup, item) expanded as selected in Statistics parameter.

Report is divided 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 calculated as simple subtraction 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 beginnStore

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