Comments
Short Version:
This issue is related to the fact that Gen. Journal Posting does not allow Entry Type 'Payment' have a Negative Amount for Vendors.
I have created an Open Source PTE to resolve this: https://github.com/TheDoubleH/BCVoidPayment
Long Version:
From a Technical perspective, here is the issue:
When a User voids a check from the Check Ledger Entries page, A call is made to Codeunit 367 – CheckManagement -> Function FinancialVoidCheck
That function sets the Document Type to “ “ (Blank), which leads to the Vendor Ledger Entry to have a Blank Entry Type.
While the Check Ledger is flagged as Voided and the Balance is correctly adjusted, the Detail Vendor Ledger Entry will not tell a complete story;
If We look at Check 206, the ‘initial’ Detailed Vendor Ledger Entries created end up like this:
The issue is that the Calculation formula for the Payments (LCY) Field on the Vendor Table, filters for Entry Type = Initial Entry, “Initial Document Type” = Payment (And Vendor No and other fields)
And THIS leads the Payment to show an incorrect amount on the Vendor Statistics Factbox
By now, I hope You realize that this is indeed an issue that needs to be resolved.
How do we fix it?
I suspect that the Document Type is left blank, due to the fact that codeunit 11 - Gen. Jnl.-Check Line prevents a Vendor Payment with a Negative Amount (Which makes perfect sense).
Luckily the Check Management Financial Void Check function sets a field: “Financial Void” to true. This means, that we have a possibility to negate the Negative Amount for Vendor Payments in CU11, as well as Positive Amounts for Customer Refunds.
I note that this is "planned" functionality. The 2021 Release Wave 1 preview on Bank Reconciliation says:
The bank reconciliation report, known as the test report for bank reconciliation, is now also available for posted bank reconciliations (bank statements).
I am looking at the Preview version and I can't see that this can be printed. So is it part of this release or not?