Versions Compared

Key

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

...

Expand
title0013_SaleStatisticsWithDrill_std

Standard report 

Description:

Report gives detailed sales statistics with campaign sales statistics included with easier access to needed information than 0012.

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). 
  • Subvendor: Multivalue; default all
  • Vendor: Multivalue; default all
  • EAN list: Allows to add specific items ignoring other selections; default blank
  • (star) Expand to: Expands drill down to selected level; default Area
  • Include Nonsale: If Include Nonsale was box checked, nonsale data will be included to statistics.
  • Price channels: Multivalue; default all

Output:

Sale statistics for all items with not null sale (or sale + nonsale if include nonsale box checked) amount narrowed down only by selections. One row per item.

Totals in the begining of new hierarchy level for:

    • Store
    • Department
    • Item area
    • (star) Item group: if you clicked on item group you would be moved to report 0014_SalesStatisticsPrArticles_std with saved selections and you will be able to see sales statistics for items in given 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 %: Share of campain 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

Hidden parameters:

  • pAllowedPriceChannelsKeys: Default all. If changed it will narrow down possible Price channel selection

Source:

  • Lindbak POS Reporting cube (OLAP)


Anchor
0014_SaleStatisticsPerArticle_std
0014_SaleStatisticsPerArticle_std

Expand
title0014_SaleStatisticsPerArticle_std

Image Added

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 campain 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)


Anchor
0057_NonsalePerOperator
0057_NonsalePerOperator

...