Versions Compared

Key

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

...

Expand
title0614_StoreSettlementPerWorkstation

CO-262513 RTC-31644


Description:

Report allows to follow up store settlement. On first page per store, data for all selected cash registers (if all cash registers are selected it equals whole store settlement) and settlement per each cash register on following pages. Report is divided in subreports which will be descriped separatly below.

Selections:

  • Date from: Default today
  • Date to: Default today
  • Store: Multivalue; default all
  • Workstation: Multivalue; default all (filtered by store)

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
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
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
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
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
title1014_subReturnReasonCodes

Description:

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

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


Anchor
0615_StoreSettlement_CSV
0615_StoreSettlement_CSV

Expand
title0650_CreditInfo

CO-273435

Image Added


Description:

Report lists data from some of sub-reports used in 0612. Output is to make it easier for exporting data to csv format.

Selections: 

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

Output:

Report lists data from sub-reports listed below in one line per store section (sub-report) type and measure. Data is aggregated per store within date selection.

Columns: 

  • Store num. - Store number
  • Store name - Store name
  • GLN - Global location number
  • Section - Section (sub-report) is Tender type, Tax accounting, Deposit Refund


Anchor
0650_CreditInfo
0650_CreditInfo

...