Customer History
The complete customer statement: opening balance, every invoice, return, collection, and adjustment with a running balance - then the prepayment card below it. The report for reconciling with a customer.
Questions It Answers
- Why is this customer's balance what it is - from which transactions?
- When did the customer last pay, and how?
- How much customer prepayment is left, and which invoices used it?
Filters
| Filter | What it does |
|---|---|
| Transaction Date | Date range of the shown; transactions before the start date are summarised as Opening balance. Empty means the whole history - slow on years of data, so always fill it. |
| Customer | One customer only. A role locked to a specific customer gets it pre-filled and read-only. |
| Division | Pre-filled from the user role's default division. A role locked to one division cannot change it. |
| Currency | Only transactions in that currency. Amounts are still shown in the company default currency. |
How To Read It
One block per customer (code, name, address, credit limit). First the receivable card, then the prepayment card.
| Column | Meaning |
|---|---|
| Opening balance | Receivable before the filter start date. Includes all older transactions, so the date range never hides history. |
| Transaction | Its type: sales invoice (also cashier receipts), return, receivable collection, or the name of the receivable adjustment type. |
| Debit | Increases the receivable: invoice value. |
| Credit | Decreases it: payments on the invoice, returns, receivable collections, adjustments. |
| Balance | Running balance = previous balance + Debit - Credit. |
| Customer Prepayment | Second card: prepayments received (Debit) and prepayments used on invoices (Credit) per payment type, with its own opening and running balance. |
Why The Numbers May Differ
- An invoice paid in cash on the spot shows both Debit and Credit - net zero, but the row is still there.
- Receivable collections are posted on their accepted date, not the entry date; a collection not yet accepted is absent here even though it already reduces the Accounts Receivable report.
- All amounts are converted to the default currency at each transaction's rate.
- Documents still waiting for approval are not counted. If the approval workflow is on and the figures look low, check the Approval Queue.
Menu Location
- Sales & POS / Sales Reports / Customer History
/report/customerhistories