Versions Compared

Old Version 306

changes.mady.by.user Atle Olaf Hanssen

Saved on

compared with

New Version 307

changes.mady.by.user Atle Olaf Hanssen

Saved on

Key

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

...

Expand
title4003_HourlySalesPerItem

RTC-46808

Description:

Report showing number of sold items per hour for selected date. Also showing total for hierarchy.

Selections:

  • 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

Source:

Lindbak POS Reporting Cube (Olap)

Anchor
4004_SalesByDepartmentAreaAndGroup
4004_SalesByDepartmentAreaAndGroup

Expand
title4004_SalesByDepartmentAreaAndGroup

RTC-46772

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

Selections:

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

Output:

One 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

Source:

Lindbak POS Reporting Cube (Olap)

Anchor
8000_InvoiceAging
8000_InvoiceAging

...