[RTC-44692] [TRN] Shift balance report (CO-335148) PIC - TO BE UPDATED
Description: - The report gives an overview of all shifts in the selected date range and for selected store(s) and workstations.
Selections: - Date from: default today
- Date to: default today
- Retail store: default all
- Workstation: default all
- Main currency (hidden): default NOK - the main currency for cash calculations.
Output: The report consist of four tables: - Shift overview - lists all shifts in the selected date range and for given store(s) and cash registers and contains the details about each shift balance (if registered).
- Currency - lists all currencies (except the main currency), their exchange rates and amount in main currency
- VAT overview - lists all VAT rates with sales gross, net and tax amount
- Payment card overview - lists all payment cards and related statistics (number of transactions and amount)
Columns: - Shift overview
- Store - store number,
- ShiftID - ID of the shift,
- Shift date - shift start date,
- Balance receipt ID - ID of the balance receipt for given shift,
- Cashier No - cashier number,
- All tenders - total tender amount for given shift,
- Card - total amount paid by cards for given shift (tender types: CreditDebit, ECreditDebit, CreditDebitOffline),
- Cash - total amount paid by cash in main currency for given shift,
- Other - other tender types, aggregated, for given shift
- Currency - total amount paid by cash in foreign currencies (all except main currency) for given shift,
- Counted cash - balance amount of cash tender type in main currency for given shift,
- Counted currency - balance amount of cash tender type in foreign currencies for given shift,
- Difference: (Counted cash - Cash) + (Counted currency - Currency)
- Bag number - bag number registered on the balance receipt
- Currency
- Code - currency code (3 letter code),
- Exchange rate - the average exchange rate for selected period,
- Currency amount - amount in currency,
- Amount in XXX - amount in main currency (default NOK)
- VAT overview
- VAT rate,
- Sales inc. VAT,
- VAT amount,
- Sales excl. VAT,
- Nonsale
- Payment card overview:
- Card - card issuer ID and name,
- Quantity - number of transactions,
- Amount - total amount of transactions
Sorting: - Shift overview - sorted by store number and shift date (ascending),
- Currency - sorted by currency code (A to Z),
- VAT overview - sorted by VAT rate (ascending),
- Payment card overview - sorted by card issuer ID (ascending)
Source: - Lindbak POS Reporting cube (OLAP)
- Lindbak POS Reporting DW
|
