Versions Compared

Old Version 81

changes.mady.by.user Unknown User (wojsy@eg.dk)

Saved on

compared with

New Version 82

changes.mady.by.user Unknown User (wojsy@eg.dk)

Saved on

Key

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

...

Expand
title0011_SalesDifferencePerStore_std

Standard report

Description:

Report allows to comapare 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 ierarchy levels (department, area, group, subgroup, item) expanded as selected in Statiscitcs parameter.

Report is devoded 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 caltulated as simple subtruction on columns from store 1 minus store 2

Source:

  • Lindbak POS Reporting cube (OLAP)


Anchor
0012_SalesStatistics_std
0012_SalesStatistics_std

Expand
title0012_SalesStatistics_std

Standard report

Image Added

Description:

Report gives detailed sales statistics with campaign information.

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 begining of new hierarchy level for:

    • Store
    • 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 quantity for 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 campain 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:
  • Gross profit Campaign:
  • Gross profit Campaign %:

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)


Anchor
0057_NonsalePerOperator
0057_NonsalePerOperator

...