...
Use the following checklist to identify and resolve the issue:
1. Verify Cash Balance
Open the Cash Assets Balances Report.
...
When creating or posting a document (like such as a payment), the system doesn’t just check verifies not only the balance on the document date . It also checks if, on any future date, the account balance will still be sufficient. If a later document would cause the balance to go negative, but also ensures that the balance remains sufficient on all future dates.
Example: The balance shows 3,000, but the system blocks the current posting.
Example: Today’s balance looks fine, but if you schedule a payment for next week that will make the balance negative, the system won’t allow today’s posting because it would eventually cause a shortfall.
|
Note!!!
...
The system checks balances up to the selected date, not the document date.
...
This means payments can be created in advance, even if no balance exists on that document date.
...
For accurate reporting, always use the Current Date as the "On Date".
...
posting of a cash payment document with an insufficient balance error.
This occurs because a payment document has already been posted for a later date, and creating a new document with an earlier date when there is insufficient balance triggers this error. Posting is blocked to prevent the balance from going negative in the following week.
To see the overall and current balance, review the report without specifying a date
To prevent discrepancies, record documents on the actual date of receipt or payment, and re-post any pre-dated or post-dated
...
entries to
...
maintain accurate balances.
2. Type of Cash Account/Entity
Check that the correct Cash Account is selected in the document. Sometimes accounts may have the same name but different codes (for example, two accounts named PETTY CASH). To avoid confusion, it is advisable to keep a slight difference in their descriptions. Always verify the Account Code when posting to ensure the correct account is used.
...
If multiple entities exist, verify that the correct Entity and Account are selected, then post the document.
3. Check Document Chronology and Compliance
Ensure that all documents (receipts, payments, transfers) are recorded in the correct chronological order.
...
A list of documents contributing to the balance will then be displayed. This will help identify any missing documents or incorrectly dated entries and ensure the running balance is accurate.
4. Review GL Movements
To review GL movements, generate the statement for the relevant GL account (e.g., 2050100 - Cash on Hand) and check the debits, credits, and running balances up to the posting date to identify why the error occurred
...