Why does the Invoice Workbench Show Fully Accounted Invoices with Status Accounted = No?
Cause: Unpublished Bug 6975868 – SELF ASSESSED TAX DISTRIBUTIONS ARE NOT REVERSED AFTER CHANGING IT TO SALES TAX The current code used to determine the accounting status for invoices looks at distributions in the ap_invoice_distributions_all and the ap_self_assessed_tax_dist_all table. Data affected by this bug will have out of sync posted flags in these two tables i.e. Both tables reference the same accounting event that is accounted, but the posted flags in ap_invoice_distributions_all are correctly set to Y, and the posted flags in the ap_self_assessed_tax_dist_all table are incorrectly set to N. The fix is included in the following files: apetxsrb.pls 120.81.12000000.40 apaprvlb.pls 120.94.12000000.38 apeventb.pls version 120.45.12000000.18. The fix is available in Patch 6975868 (This patch is available through controlled release. Please contact support for assistance with obtaining the patch.) See Note 603740.1 for more information.