Page History

Description:

Report lists item group sales with drilldown for selected stores

Selections:

• Periode – default month (it will decide if we use Year, Month, Week or Date parameters to choose selected and reference time scope) 
• Year – Default current year
• Month – Default current month
• Week – Default current week
• Date from – Default today
• Date to – Default today
• Maingroup – Default all
• Profile – Default all
• Team – Default all
• Store – Default all

Output:

• One page per store. Report has a summary on each column.
• Summary totals in the beginning  of new hierarchy level for store.

Columns:

• Item group
• Sales – sales net amount
• Sales last year – Sales net amount last year
• Diff. – Difference for sales, total sales, customers, average sales and gross profit
• Diff. % - Difference percentage
• Total sales YTD – Total sales year to date
• Total sales YTD LY – Total sales year ro date last year
• Cust # - Number of customers
• Customers LY – Customers last year
• Average sale
• Average sale last year
• GP % - Gross profit percentage
• Gr. prof. % LY – Gross profit percentage last year
• GP – Gross profit
• GP LY – Gross profit last year

Clarifications:

Negative values are colored red.

Use pPeriod=Date for subscriptions with dynamic periods in chain web to use dynamic dateFrom dateTo. 

Source:

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

CO-211507 / RTC-45144

Updated: 

Image Added

Description:

Report shows sales statistics in a hierarchy from store to department, item area, item group and item. Report show statistics for all selected stores and a total page for all selected store.

Selections:

• Date from – Default today
• Date to – Default today
• Compare date from – Default last year from today
• Compare dat to – Default last year from today
• Hour from – Default 0:00
• Hour to – Default 24:00
• Team – Default all
• Stores – Default all
• Department – Default all
• Article area – Default all
• Article group – Default all
• Vendor – Default all
• Subvendor – Default all
• EAN list  - Default empty
• Include VAT – Default false
• Exclude groups  - Default false
• Excluded groups – Default groups 2 and 92.  Appears when Exclude groups is switched to true

Output:

One line per item with the hierarchy from store, department, item area and item group.

Columns:

• EAN - Shows the entire hierchy down to EAN
• Item name - Item name
• Item num. - Item number
• Share - Percentage share of sales
• Sales - Sales amount
• 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 percentage points – Difference gross profit percentage in unitspercentage points
• Quantity
• Compared quantity
• Diff % - Difference percentage between quantity and 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

Hidden parameters:

• pExcludedGroupsList – Report contain hidden parameter with selected article groups to be exluded by default. This parameter and pExcludedGroups will not work until parameter pExludeGroups will be set as True by user.

Source:

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

Description:

Report lists acciunts receivable invoice aging with invoice details.

Selections:

• Date – Default today. Decides on slice of time allowing for checking state in the past. Limits to only invoices/payments that happened before that date.
• Store – Default all
• From customer – Default 0
• To customer – Default 99999999

Output:

Reports shows invoice details for customers in stores. Report has a total summary at the end of table.

Columns:

• Customer – Customer number
• Name – Customer name
• Invoice no – Inovice number
• Store num. – Store number
• Last purchase
• Balance
• Not due
• Due
• Days due:
  • 0-15
  • 16-30
  • 31-60
  • 61-90
  • 91-

Source:

• Lindbak Retail
• Lindbak POS Reporting Cube (OLAP)