Versions Compared

Key

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

...

Expand
title0015_StoreSettlementPerOperator_std

Standard report


Description:

Report allows to follow up store settlement: on first page settlement for all selected cashiers (if all cashiers are selected it equals whole store settlement) and settlement per each cashier on following pages. Report is divided in 12 subreports which will be descriped separatly below.

Selections (applies to all subreports): 

  • Date from: Default today
  • Date to: Default today
  • Store: Single value; default first available from the list.
  • Operator: Multivalue; default all
  • Price channels: Multivalue; default all

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_subDepositRefound

Image Added

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
title1005_subDepositRefound

Image Removed

Expand
title1013_subTenderType

Image Removed

1013_subTenderType

Image Added

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

Image Added

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
title1009_subSalePerHour
Image Removed
Expand
title1010_subArticleSale



Expand
title1012_subTaxAccounting

Expand
title1002_subBank

Expand
title1003_subBankSettlement

Expand
title1004_subCreditNote

Expand
title1007_subGiftCard

Expand
title1011_subStatistics

Expand
title1006_subDiscounts


Source:

  • Lindbak POS Reporting cube (OLAP)


Anchor
0057_NonsalePerOperator
0057_NonsalePerOperator

...

Expand
title0450_StoreSettlementPerOperator

CO: 156791. Based on report 0709.


Description:

Report allows to follow up store settlement: on first page settlement for all selected cashiers (if all cashiers are selected it equals whole store settlement) and settlement per each cashier on following pages. Report is divided in 9 subreports which will be descriped separatly below.

Selections (applies to all subreports): 

  • Date from - Default today
  • Date to - Default today
  • Store - Default all
  • Operator -Default all

Subreports:

Expand
title1410_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
  • Qunatity - 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
title1423_subCurrencyRate

Description:

Average currency rate (rigidly set to SEK/NOK) for given period.


Expand
title1424_subValueCoupon

Description:

This subreport shows sum sales amount inc. VAT and sales sum quantity for EAN set in hidden parameter: pValueCouponEAN (default: 926)


Expand
title1707_subRounding

Description:

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

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
title1405_subDepositRefound

Columns:

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

Rows:

  • Received manuall deposit refund: Amount for returns, etc. ( direction in ) per item group set in hidden parameter: pArtGrpManualDepositRefundIn (default: 502)
  • Deposit refund received: Amount for returns, etc. ( direction in ) per item group set in hidden parameter: pArtGrpDepositRefundIn (default: 501)
  • Deposit refund sold:  Sales (direction out) per item group set in hidden parameter: pArtGrpDepositRefundSold (default: 500)
  • Deposit refund balance: sum of 3 values above


Expand
title1406_subDiscounts

Coulmns:

  • Amount: Discount amount
  • Quantity: Number of receipts with discount

Rows:

  • Customer disc.: discount with discount key: CustomerGroup
  • Personnel discount: discount for employees with discount key: Subtotal
  • General discount: discount with key: Line


Expand
title1411_subStatistics

Columns:

  • Amount: Sales amount inc. VAT (valid only for Repurchase and Price change)
  • Qunatity: Number of receipts for Cancelled receipts and Repurchase; number of items for Deleted items and Price change

Rows:

  • Cancelled receipts: Number of deleted/cancelled receipts
  • Repurchase: All returns except those for item groups set in hidden parameters: pArtGrpManualDepositRefundIn (default 502) and pArtGrpDepositRefundIn (default 501)
  • Deleted items: Items from Cancelled receipts
  • Price change: Number of items sold with changed price

Source:

  • Lindbak POS Reporting cube (OLAP)


...