Posting Error: Source Not Balanced after Sales Order=>Doc.Action="Void"
Description
Accounting Schema: Use Suspense Balancing=N
When voiding a sales order (same probably true for purchase orders), the system sets the order quantity in the sales order line to 0. => OK. As a result, the system updates sales order line amount to 0 => OK. The system also resets the tax amount to 0 => OK
At the same time, the sales order header fields "Total Lines" and "Grand Total" are NOT updated with the changed line amounts, still showing the original accumulated total line amounts.
As a result the Balancing check at the time of posting fails with Posting Error: Source Note Balanced. Based on a simulation, setting Use Suspense Balancing=Y resolves this issue, however, activating suspense balancing is absolutely not desired because predictable value flows and GL account postings are imperative w/o the system silently balancing un-balanced postings using a suspense account.
A good solution would be if the system updated the sales order header with the changed line item amounts.
Environment
None
Attachments
1
Activity
Michael Powacht
September 3, 2017 at 8:03 AM
Issue can be closed, I don't seem to have the necessary privilege.
Accounting Schema: Use Suspense Balancing=N
When voiding a sales order (same probably true for purchase orders), the system sets the order quantity in the sales order line to 0. => OK.
As a result, the system updates sales order line amount to 0 => OK.
The system also resets the tax amount to 0 => OK
At the same time, the sales order header fields "Total Lines" and "Grand Total" are NOT updated with the changed line amounts, still showing the original accumulated total line amounts.
As a result the Balancing check at the time of posting fails with Posting Error: Source Note Balanced. Based on a simulation, setting Use Suspense Balancing=Y resolves this issue, however, activating suspense balancing is absolutely not desired because predictable value flows and GL account postings are imperative w/o the system silently balancing un-balanced postings using a suspense account.
A good solution would be if the system updated the sales order header with the changed line item amounts.