RTC-49375 
Description Report to follow up store settlement for all selected workstations / cash registers. Report is divided into 11 different sub reports wich will be described separatly below. Selections (applies to all sub reports) - Date from: Default today
- Date to: Default today
- Retail store: Single selct, default first available store.
- Workstation: Default all for selected store
Source: - Lindbak POS Reporting cube (OLAP)
Parameters: - pAutomaticDepositRefundEans - List of EAN's used for automatic deposit refund
- pManualDepositRefundEans - List of EAN's used for manual deposit refund
Subreports: | Expand |
|---|
| title | 1023_subSettlement_3 |
|---|
| 
Columns: - Quantity
- Amount
- Balance amount
- Difference
Rows: One row per tendertype with subtotal. - Cash
- 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 not out
- Bank
- Gift card (MBXP)
One row for other transaction types with tender. With subtotal - Deposit refund balance
- Rounding
- Paid in
- Payment on account
- Paid out
- Drop
|
| Expand |
|---|
| title | 1024_subDepositRefund_2 |
|---|
| 
Columns: Rows - Received deposit refund (manual) - Deposit refund for list of ean's in parameter pManualDepositRefundEans (in main report)
- Received deposit refund (auto) - Deposit refund for list of ean's in parameter pAutomaticDepositRefundEans(in main report)
- Deposit refund sold - Sold deposit refund (article type)
- Deposit refund balance = Received - sold
|
| Expand |
|---|
|  Image Added
Columns Rows - Bank sold
- Bank out
- Bank cash back
- Total = sold + out + cash back
|
| Expand |
|---|
| title | 1026_subBankSettlement_2 |
|---|
|  Image Added
Columns: Rows - Bank - Sold bank
- Electronic giftcard
- Offline Cooppay - Offline transactions with Cooppay
- Offline Softpay - Offline transactions with SoftPay
- Electronic giftcard out
- bank netthandel -
- Cooppay
- SoftPay
|
| Expand |
|---|
| title | 1027_subMemberSale_2 |
|---|
|  Image Added
Columns Rows - Own - Sale for members in own cooperative
- Visitors - Sale for members in other cooperatives.
|
| Expand |
|---|
| title | 1028_subPayedInOutReasonCodes |
|---|
|  Image Added
Columns Rows - Paid in. One row for each Paid in reason code.
- Paid out. One row for each Paid out reason code.
|
| Expand |
|---|
|  Image Added
Columns - Net cost
- Gross profit
- Amont
Rows - One row for each nonsale type. With total
|
| Expand |
|---|
| title | 1030_subPriceChannel |
|---|
|  Image Added
Columns - Article count
- Num of receipts
- Items per receipt
- Time per receipt - Difference between startdatetime and enddatetime.
Rows - One row for each price channel.
|
| Expand |
|---|
| title | 1032_subSalePerHour_2 |
|---|
|  Image Added
Columns - Hour
- Sales amount
- Number - Number of items
- Cust # - Number of customers
- Total % - Share
Rows - One row for each hour set in parameter pHourFrom and pHourTo
Parameters - pHourFrom - Report will show hours between pHourFrom and pHourTo (starting hour)
- pHourTo - Report will show hours between pHourFrom and pHourTo (starting hour)
|
| Expand |
|---|
| title | 1031_subStatistics_2 |
|---|
|  Image Added
Columns Rows - Gross sale
- Deposit refund
- Returned items
- Campaign discount
- Discount mixmatch
- Discount digital coupon
- Discount for date items
- Discount for mispriced items
- Discount for other reasons
- Best before
- Member discount
- Customer discount
- Personell discount
- General discount
- Deleted sales
- Deleted other
- Deleted receipt
- On hold receipt
- On hold, not reused receipts
- Deleted in on hold
- Article count
- Scanned
- Total items open ex. PLU
- Price check
- Overridden price
- Price change
- Nullsale
- Customers
- Per customer
- Deposit
- Nonsale
- Prize payout
- Internal sales
- Ispection cart
- Inspection cart approved
- ID requirement age OK
- ID requirement date approved
- ID requirement date rejected
|
| 