Discrepency
Find customers whose ledger balance does not agree with the total of their outstanding invoices, and optionally write the difference off.
How to Open
Menu → Administration → Discrepency
Keyboard Shortcuts
F1 Help F12 Save F10 Report Esc Close
📝
How to Use
➕ Adding a New Row
- Open Discrepency from the menu
- Select the filter dropdown if applicable
- Click New to add a blank row at the bottom of the grid
- Fill in the required columns
- Press F12 or click Save
✏️ Editing Existing Rows
- Select the row you want to edit in the grid
- Click on the cell and modify the value
- Modified rows will turn light yellow
- Press F12 or click Save to save all changes
📋
Field Descriptions
Write off Checkbox
When ticked, the difference shown for each customer is written off on save rather than only reported.
📊
Grid Columns
| Column | Type | Required | Description |
|---|---|---|---|
| CUSTOMER | Text | — | Customer the discrepancy was found for. Read-only. |
| TOWN | Text | — | Town the customer belongs to. Read-only. |
| BALANCE | Decimal | — | Balance held on the customer ledger. Read-only. |
| COLDIFF | Decimal | — | Difference between the ledger balance and the total of outstanding invoices. Read-only. |
| INV # | Text | — | Invoice the outstanding amount belongs to. Read-only. |
| DATE | Text | — | Invoice date. Read-only. |
| OST AMOUNT | Decimal | — | Amount still outstanding on the invoice. Read-only. |
| WRITE OFF | Decimal | — | Amount to be written off against the invoice. |
🔘
Buttons
| Button | Shortcut | What it Does |
|---|---|---|
| 💾 Save | F12 | Saves all changes. The system will ask for confirmation before saving. |
| ➕ New | F5 | Adds a new blank row to the grid for data entry. |
| ❌ Close | Esc | Closes the Discrepency screen. |
💡
Important Notes
Writing Off Changes Balances: Saving with Write off ticked adjusts customer balances. Run the report first and check the differences before you save.
Refresh: Click Refresh to rebuild the list after balances have changed elsewhere.