Versions Compared

Old Version 269

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

Saved on

compared with

New Version 270

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

Saved on

Key

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

...

Expand
title0516_Zreport


Description:

Report allows to follow up store settlement for selected Z number. Report is divided in 10 subreports which are descriped separatly below.

Selections (applies to all subreports):

  • Retail store – Default select single value
  • Workstation – Default select single value
  • Z-number – Default select date

Clarifiacations:

Z number is End of bussiness day date for selected store and workstation

Subreports:


Expand
title1008_subSettlement_2

Rows:

  • Gross amount: Amount inc. VAT + General discount - Returns 
  • Deducted bonus check: Return amount on article group set in hidden parameter: pBonusCheckArticleGroup 
  • Return total: All rerutns amount - Deducted bonus check 
  • General discount: Discount  amount with keys: Line and Subtotal

__________________________________________________________________________________

  • Net amount - 0% tax: Net amount with 0% tax
  • Net amount - other taxes: Net amount
  • Tax total: tax amount
  • Rounding: Subtotal rounding amount

__________________________________________________________________________________

  • Net amount rounded: both Net amounts + Rounding


  • Shoes serviece (Store cost and total):  balance amount with tender type: InboundChangeBalance; Sales inc. VAT per article with article type: Service 
  • Inbound change: Return amount per article with article type: Service 
  • Outbound change: Remaining Amoun tIn Drawer; difference: Remaining Amoun tIn Drawer - balance amount with tender type: InboundChangeBalance


Expand
title1012_subTaxAccounting

Columns:

  • Tax group: tax type
  • Tax base: Net amount
  • Tax amount: tax
  • Sum: Turnover inc. VAT

Rows:

  • One row per one tax type
Expand
title1020_subSalesExVAT

Description:

Gross excluding returns and discount amount.

Expand
title1013_subTenderType

Columns:

  • Qunatity
  • Qunatity %: Share of given tender type quantity in whole quantity
  • Amount: Sales inc. VAT per tender type

Rows:

  • One row per one tender type
Expand
title1018_subZReportSpecificValues

Rows:

  • Donations
  • Paid in
  • Paid out
  • Sold giftcards
  • Electronic giftcard out
  • Credit note
Expand
title1014_subReturnReasonCodes

Description:

Amount inc. VAT and quantity of items returned. One row per reason code.

Expand
title1006_subDiscounts

Columns:

  • Amount: Discount amount
  • Quantity: quantity of items sold with given discount
  • Total %: Share of given discount amount in all discounts amount

Rows:

  • One row per one type of discount
Expand
title1011_subStatistics

Rows:

  • Gross sale amount: Amount inc. VAT

Total%:

  • Deposit refund: Deposit refound amount / Gross sale amount
  • Returned items: Returned items amount/ Gross sale amount
  • Deleted sales: Deleted amount/ Gross sale amount
  • Deleted reciept: Deleted receipts amount/ Gross sale amount
  • Scanned: Scanned quantity/ Gross sale qunatity
Expand
title1019_subGrandTotals

Description:

Grand Subreport shows amount of grand total gross and grand total returns with total summary.

Expand
title1022_subPaymentCard

DescriptionColumns:

  • Paymentcard – Type of paymentcard
  • Quantity
and sales amount with paymentcards
  • – Tender count
  • Amount – Tender amount

Output:

  • Subreport lists one row per type of payment card.
  • Table has a total summary quantity and amount for all payment cards.

Source:

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


...

Expand
title0518_Xreport

Description:

Report allows to follow up store settlement for selected workstation Report is divided in 9 subreports which are descriped separatly below.

Selections (applies to all subreports):

  • Retail store – Default select single value
  • Workstation – Default select single value
  • Date – Default select date

Subreports:


Expand
title1008_subSettlement_2

Rows:

  • Gross amount: Amount inc. VAT + General discount - Returns 
  • Deducted bonus check: Return amount on article group set in hidden parameter: pBonusCheckArticleGroup 
  • Return total: All rerutns amount - Deducted bonus check 
  • General discount: Discount  amount with keys: Line and Subtotal

__________________________________________________________________________________

  • Net amount - 0% tax: Net amount with 0% tax
  • Net amount - other taxes: Net amount
  • Tax total: tax amount
  • Rounding: Subtotal rounding amount

__________________________________________________________________________________

  • Net amount rounded: both Net amounts + Rounding


  • Shoes serviece (Store cost and total):  balance amount with tender type: InboundChangeBalance; Sales inc. VAT per article with article type: Service 
  • Inbound change: Return amount per article with article type: Service 
  • Outbound change: Remaining Amoun tIn Drawer; difference: Remaining Amoun tIn Drawer - balance amount with tender type: InboundChangeBalance


Expand
title1012_subTaxAccounting

Columns:

  • Tax group: tax type
  • Tax base: Net amount
  • Tax amount: tax
  • Sum: Turnover inc. VAT

Rows:

  • One row per one tax type
Expand
title1020_subSalesExVAT

Description:

Gross excluding returns and discount amount.

Expand
title1013_subTenderType

Columns:

  • Qunatity
  • Qunatity %: Share of given tender type quantity in whole quantity
  • Amount: Sales inc. VAT per tender type

Rows:

  • One row per one tender type
Expand
title1018_subZReportSpecificValues

Rows:

  • Donations
  • Paid in
  • Paid out
  • Sold giftcards
  • Electronic giftcard out
  • Credit note
Expand
title1014_subReturnReasonCodes

Description:

Amount inc. VAT and quantity of items returned. One row per reason code.

Expand
title1006_subDiscounts

Columns:

  • Amount: Discount amount
  • Quantity: quantity of items sold with given discount
  • Total %: Share of given discount amount in all discounts amount

Rows:

  • One row per one type of discount
Expand
title1011_subStatistics

Rows:

  • Gross sale amount: Amount inc. VAT

Total%:

  • Deposit refund: Deposit refound amount / Gross sale amount
  • Returned items: Returned items amount/ Gross sale amount
  • Deleted sales: Deleted amount/ Gross sale amount
  • Deleted reciept: Deleted receipts amount/ Gross sale amount
  • Scanned: Scanned quantity/ Gross sale qunatity
Expand
title1022_subPaymentCard

Description:

Quantity and sales amount with paymentcards

Columns:

  • Paymentcard – Type of paymentcard
  • Quantity – Tender count
  • Amount – Tender amount

Output:

  • Subreport lists one row per type of payment card.
  • Table has a total summary quantity and amount for all payment cards.

Source:

  • Lindbak POS Reporting Cube (OLAP)


...

Expand
title0612_StoreSettlementPerWorkstation

CO-256310, RTC-30351

Description:

Report allows to follow up store settlement: on first page settlement for all selected workstations and settlement per each workstation on following pages. Report is divided in 16 subreports which will be descriped separatly below.

Selections (applies to all subreports):

  • Date from - Default today
  • Date to - Default todauy
  • Store - Default all
  • Workstation - Default all

Clarifications:

Report is mostly based on 0016_StoreSettlementPerWorkstation_std report. Additionaly report contains new 1022_subPaymentCard report, GLN code for each store in title and multivalue selections for stores.

Subreports:

Expand
title1010_subSettlement

Columns:

  • Quantity
  • Amount
  • Balance amount
  • Difference: Balance amount - Amount

Rows:

One row per tender type . In means received, out means given (returns etc...)

  • Cash: Tender type key = Cash or CashBack
  • Check
  • Coupon
  • Finance
  • Credit
  • Gift card in
  • Gift card out
  • Gift card foreign in
  • Gift card foreign out
  • Credit note in
  • Credit note foreign in
  • Credit note out
  • Bank: Tender Type Key = CreditDebit or CreditDebitOffline or ECreditDebit
  • Subtotal: Total for all rows above Subtotal

______________________________________________________________________________________

  • Deposit refound balance: Tender type key DepositRefund received - DepositRefund given
  • Rounding: Subtotal rounding
  • Paid in: Tender Control Type Key: PayedIn
  • Payment on account: Tender Control Type Key: PaymentOnAccount
  • Deposit: Article Type Key: Deposit
  • Paid out: Tender Control Type Key: PayedOut
  • Drop: Tender Control Type Key: Drop
Expand
title1005_subDepositRefund

Columns:

  • Amount: Sales amount inc. VAT 
  • Qunatity: Number of receipts. 

Rows:

  • Deposit refund received: Amount (or number of receipts) for direction in for Article Type Key: DepositRefund
  • Deposit refund sold:  Amount (or number of receipts) for direcion out for Article Type Key: DepositRefund
  • Deposit refund balance: Received - sold
Expand
title1013_subTenderType

Columns:

  • Qunatity
  • Qunatity %: Share of given tender type quantity in whole quantity
  • Amount: Sales inc. VAT per tender type

Rows:

  • One row per one tender type
Expand
title1009_subSalePerHour

Description:

Sales statistics hour by hour with graph showing sales Amount.

Columns:

  • Hour
  • Sales amount: sales inc. VAT
  • Number: sold quantity
  • Cust #: number of receipts
  • Total %:  Share of sales amount per hour in whole sales amount

Rows:

  • one row per hour with total in the end
Expand
title1008_subSettlement_2

Rows:

  • Gross amount: Amount inc. VAT + General discount - Returns 
  • Deducted bonus check: Return amount on article group set in hidden parameter: pBonusCheckArticleGroup 
  • Return total: All rerutns amount - Deducted bonus check 
  • General discount: Discount  amount with keys: Line and Subtotal

__________________________________________________________________________________

  • Net amount - 0% tax: Net amount with 0% tax
  • Net amount - other taxes: Net amount
  • Tax total: tax amount
  • Rounding: Subtotal rounding amount

__________________________________________________________________________________

  • Net amount rounded: both Net amounts + Rounding


  • Shoes serviece (Store cost and total):  balance amount with tender type: InboundChangeBalance; Sales inc. VAT per article with article type: Service 
  • Inbound change: Return amount per article with article type: Service 
  • Outbound change: Remaining Amoun tIn Drawer; difference: Remaining Amoun tIn Drawer - balance amount with tender type: InboundChangeBalance


Expand
title1000_subArticleSales

Columns: 

  • Sales amount With VAT:
  • Sales amount Campaign: Sale amount inc. VAT for campaigns with discount keys: CampaignPrice, Group, MemberPrice
  • Sales amount campaign %: Share of campain sales in all sales (Sales amount Campaign / Sales amount With VAT)
  • Gross profit Amount
  • Gross profit In %: Share of Gross profit in Net Amount
  • Gross profit Campaign: Gross profit for Campaign
  • Gross profit Campaign %: Share of gross profit for campains in campaign sales (Gross profit Campaign/ Sales amount Campaign)

Rows:

  • One row for totals
Expand
title1012_subTaxAccounting

Columns:

  • Tax group: tax type
  • Tax base: Net amount
  • Tax amount: tax
  • Sum: Turnover inc. VAT

Rows:

  • One row per one tax type
Expand
title1002_subBank

Rows:

  • Bank sold: Sales amount for tender types: CreditDebit, CreditDebitOffline, ECreditDebit
  • Bank cash back: tender type Cash back
  • Bank delivered: tender type: DeliveredBalance
Expand
title1003_subBankSettlement

Rows:

  • Bank: Amount for tender types: CreditDebit, CreditDebitOffline, ECreditDebit, Cash back
  • Electronic giftcard: Amount for few hard coded payment card keys
  • Offline: Amount for CreditDebitOffline
  • Electronic giftcard out: Outcoming amount for few hard coded payment card keys
Expand
title1004_subCreditNote

Rows:

  • Credit note sold: Quantity/ Amount of sold by store credit notes
  • Credit note used: Credit notes used in the store
  • Credit note foreign used: Foreign credit notes used in the store
Expand
title1007_subGiftCard

Columns:

  • Quantity: number of gift cards
  • Amount: Amount on gift cards

Rows:

  • Gift Card sold: Gift cards sold by given operator in given store
  • Gift card foreign sold: Foreign gift cards sold by given operator in given store
  • Gift card discount
  • Gift card used: Sales amount inc. VAT made with gift cards. (Number of transactions made with gift cards)
  • Gift card foreign used: Sales amount inc. VAT made with foreign gift cards. (Number of transactions made with foreign gift cards)
Expand
title1011_subStatistics

Rows:

  • Gross sale amount: Amount inc. VAT

Total%:

  • Deposit refund: Deposit refound amount / Gross sale amount
  • Returned items: Returned items amount/ Gross sale amount
  • Deleted sales: Deleted amount/ Gross sale amount
  • Deleted reciept: Deleted receipts amount/ Gross sale amount
  • Scanned: Scanned quantity/ Gross sale qunatity
Expand
title1006_subDiscounts

Columns:

  • Amount: Discount amount
  • Quantity: quantity of items sold with given discount
  • Total %: Share of given discount amount in all discounts amount

Rows:

  • One row per one type of discount
Expand
title1014_subReturnReasonCodes

Description:

Amount inc. VAT and quantity of items returned. One row per reason code.

Expand
title1015_subDonations

Description:

Nonsale Amount and number of transactions per article.

Clarification:

Articles to displayed can be narrowed down by changing parameter: pArticlesSet

Expand
title1022_subPaymentCard

Description:

Quantity and sales amount with paymentcards

Columns:

  • Paymentcard – Type of paymentcard
  • Quantity – Tender count
  • Amount – Tender amount

Output:

  • Subreport lists one row per type of payment card.
  • Table has a total summary quantity and amount for all payment cards.

Source:

  • Lindbak POS Reporting Cube (OLAP)


...

Expand
title0709_Settlement

CO: 10400, PBI#90853

Description:

Report allow to follow up store settlement: all selected Chahiers (if all cashiers are selected it equals whole store settlement) and settlement per each Cashier on following pages.

Selections:

  • Retail store – Single value; select a value from the list
  • Operator – Defaul all
  • Date from – Default today
  • Date to – Default today

Subreports:

Expand
title1700_subSettlement

Columns:

  • Tender type - payment method
  • Received - Sales amount inc. VAT received in given tender type
  • Balance - Money amount registered in the end of the day (sum for selected operators who made balance and selected days)
  • Difference - Balance - Received
  • Quantity - Number of items sold in given tender type

Output:

One row per one tender type.

Clarifications:

  • Balance and Difference make sense only for cash since only cash it's kept in cash register.
Expand
title1701_subCurrency

Columns:

  • Currency
  • Balance (Beholdning): Sales amount inc. VAT in main currency
  • Balance local value: Sales amount inc. VAT in received currency
  • Balance (Oppgjør): Money amount registered in the end of the day in given currency (sum for selected operators who made balance and selected days)
  • Difference: Balance (Oppgjør) - Balance (Beholdning)
  • Diff. local value: Balance (Money amount registered in the end of the day) in main currency - Balance local value


Expand
title1702_subNonSale

Columns:

  • Type - Non sale type
  • Amount - non sale amount

Output:

One row per one non sale type.

Expand
title1703_subPaymentOut

Columns:

  • Description - Reason codes
  • Amount - Control amount
  • Quantity - Control transaction quantity

Output:

One row per one one reason code.

Clarifications:

  • Tender control type relates to Paid in control type.
Expand
title1704_subPaymentIn

Columns:

  • Description - Reason codes
  • Amount - Control amount
  • Quantity - Control transaction quantity

Output:

One row per one one reason code.

Clarifications:

  • Tender control type relates to Paid out control type.
Expand
title1705_subVAT

Coumns:

  • Gross: Sales amount inc. VAT
  • Net: Sales net amount
  • VAT

Output:

One row per sum one type of VAT. Vaules are summed for given store, date period and operators


Expand
title1706_subSatistics

Columns:

  • Description - Type of Reason code
  • Amount
  • Quantity
  • Share

Output:

One Subreport lists one row per one one reason code type.

Expand
title1707_subRounding

Description:

Sum of all transactions subtotal rounding (for given period, store and operators) 

Source:

  • Lindbak POS Reporting Cube (OLAP)


...

Expand
title0752_SalesStatistics

CO based on report 0714

Description:

Report allows to follow up article sales on multiple levels with possibility to select specific hourly intervals and exclude specific item groups.

Selections: 

  • Date from - Default today
  • Date to - Default today
  • Hour from - Default 0:00
  • Hour to - Default 24:00
  • Team - Default all
  • Store - Default all
  • Department - Default all
  • Article area - Default all
  • Article group - Default all
  • Include VAT - Default on
  • Exclude groups - Default false
  • Excluded groups - Appears when Exclude groups is switched to true

Output:

Article sale statistics for selected stores, for selected date interval and for selected time interval grouped by department, area and group.

By default data is shown for department and it is possible to drill down to item level manually by clicng plus button or by using expand all button to expand everithing to item level at once.

Columns: 

  • Buttons for expanding and collapsing all drilldowns.
  • EAN - EAN code
  • Item name - Article name
  • Quantity
  • Total- Quantity sold
  • Turnover inc. VAT or Turnover ex. VAT depending on selection.
  • Total - Amount sold. Inc. or ex. VAT depending on selection
  • Share - Share of this department / area / group / item related to total sale.
  • Cost price - Cost price
  • Gross profit
  • Total - Gross profit amount
  • Total % - Gross profit percentage.

Sorting:

  • Department number 
  • Item Area number 
  • Item Group number
  • EAN

Clarifications:

  • Hour selection applies to each day in selected date period

Source:

  • Lindbak POS Reporting cube (OLAP)

  • Article group list is narrowed by selecting article areas. By preventing problems with Excluded groups parameter, report will set all article groups in ExludedGroups (parameter is hidden and switched off until set true by user) if default groups in pExcludedGroupsList are not contain in previously selected article area. If user change article area and want set true on Exclude groups which not containg default groups to exclude, user have to manually choose new article groups to exclude, instead of all selected.

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)


Anchor
0753_SalesPerHourForArticle
Anchor
0753_SalesPerHourForArticle0753_SalesPerHourForArticle

...

Expand
title0754_TopSalesPerItemWithCompareDate

Description:

Report lists top sales statistics per item with compare date.

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
  • Grouping – Default Depertment
  • Number of items – Default 10 items
  • Sorting – Default by best
  • Vendor – Default all
  • Subvendor – Default all
  • Measure - Defualt by amount
  • 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:

Report shows table for all store on the beginning and one store table per page. Report has a summary for each table at the end of columns.

Columns:

  • Dept. – Department
  • Area – Article area
  • Grp. – Article group
  • EAN
  • Brand
  • Item name
  • Selected period of time/Comparable period of time
  • Quantity
  • Turnover ex. VAT – Turnover excluding VAT
  • Gross profit
  • Gr. prof. % - Gross profit percentage
  • Num of receipts – Number of receipts

Clarifications:

  • Negative values are marked red.
  • Article group list is narrowed by selecting departments and article areas. By preventing problems with Excluded groups parameter, report will set all article groups in ExludedGroups (parameter is hidden and switched off until set true by user) if default groups in pExcludedGroupsList are not contain in previously selected department or article area. If user change department or article area and want set true on Exclude groups which not containg default groups to exclude, user have to manually choose new article groups to exclude, instead of all selected.

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.
  • pAccumulation – Parameter with Values Total and Store (default vaule is total). If default value is store, all stores are selected.

Source:

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


...

Expand
title0755_TopSalesPerItem

CO: 207212. Based on report 0754

Description:

Report allows to find given number of best or worst selling items on multiple levels (amount, quantity, gross profit) in two date intervals. Possible to select specific hourly interval.

Selections: 

  • Date from - Default today
  • Date to - Default today
  • Compare date from - Default the same day of week as Date from year before
  • Compare date to- Default the same day of week as Date to but year before
  • Hour from - Default 0:00
  • Hour to - Default 24:00
  • Team - Default all
  • Store - Default all
  • Department - Default all
  • Article area - Default all
  • Article group - Default all
  • Number of items - 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
  • Vendor - default all
  • Subvendor- default all
  • Include VAT - Default on
  • Exclude groups - Default false
  • Excluded groups - Appears when Exclude groups is switched to true

Output:

Sale statistics for selected number of best or worst items per store sorted by selected sort measure devided in two selected date intervals in selected hour range.

Columns: 

  • Store
  • Dept. - Department
  • Area
  • Grp. - Item group
  • EAN
  • Item name
  • Quantity
  • Turnover ex. VAT
  • Gross profit
  • Gross profit %
  • Num of receipts

Sorting:

  • Selected sort measure

Clarifications:

  • Hour selection applies to each day in selected date period
  • Negative values are colored red

  • Article group list is narrowed by selecting departments and article areas. By preventing problems with Excluded groups parameter, report will set all article groups in ExludedGroups (parameter is hidden and switched off until set true by user) if default groups in pExcludedGroupsList are not contain in previously selected department or article area. If user change department or article area and want set true on Exclude groups which not containg default groups to exclude, user have to manually choose new article groups to exclude, instead of all selected.

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


...

Expand
title0851_PaymentTypesPerShift

Description:

Report allow to follow up tender per shift. Report has two subreports, one settlement and second about statistics.

Selections:

  • Date from - Default today
  • Date to - Default today
  • Retail Store - Default select a single store
  • Workstation - Default all
  • Shift - Default select a single value

Subreports:

Expand
title1700_subSettlement

Columns:

  • Tender type - payment method
  • Received - Sales amount inc. VAT received in given tender type
  • Balance - Money amount registered in the end of the day (sum for selected operators who made balance and selected days)
  • Difference - Balance - Received
  • Quantity - Number of items sold in given tender type

Output:

One row per one tender type.

Clarifications:

  • Balance and Difference make sense only for cash since only cash it's kept in cash register.
Expand
title1706_subSatistics

Columns:

  • Description - Type of reason code
  • Amount
  • Quantity
  • Share

Output:

One Subreport lists one row per per  one one reason code type.

Source:

  • Lindbak POS Reporting Cube (OLAP)


...