Any suggestions on how to correct this situation would be greatly appreciated.
Problem: A/P open invoice’s Unapplied Amount doubled so that the Current Transaction Amount for the invoice is now twice the correct invoice amount. There are no corresponding general ledger transactions for the increase in the invoice’s Current Transaction Amount.
Details: The invoice’s Doc Amount shown on a Historical Aged Trial Balance report is correct. However the Unapplied Amount listed for the invoice is twice the correct amount in Inquiry -> Purchasing -> Transaction by Vendor. Likewise, a Smartlist report for open transactions shows the Current Transaction Amount for the invoice as twice what it should be.
Circumstances Surrounding the Error: I was trying to train a new employee over the telephone in how to produce a check for an invoice from the same Vendor that now has the invoice problem. To walk the new employee through creating a check batch I created a check batch while the new employee also created a check batch. Both check batches were built for this one particular Vendor only. We both edited our check batches to de-select several open invoices that were not to be paid. I did not de-select every open invoice that was not to be paid because my intention was to delete my check batch. The new employee, I assume, de-selected all the other open invoices leaving just the one invoice that was supposed to be paid in the check batch. The new employee then printed the check and it was generated and printed just fine. The new employee then posted the check. Sometime around when it seemed that the employee would generate a good check, I closed the Edit Check window and closed the Select Payables Checks window. Then I deleted the Payables Check Batch I created. To verify everything was processed correctly, I accessed Inquiry -> Purchasing -> Transaction by Vendor to ensure the payment that the new employee processed was correcly applied to the invoice. This is when I noticed the other open invoice’s Unapplied Amount had doubled.
More Details: I tried to create a Credit Memo to be applied to the invoice with the error and I received an error message that said it couldn’t be done because there are outstanding unapplied amounts for the invoice
*This post is locked for comments
I have the same question (0)