web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

A/P open invoice’s Unapplied Amount doubled after deleting a check batch

(0) ShareShare
ReportReport
Posted on by 60

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)
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,619 Super User 2025 Season 2 on at
    Re: A/P open invoice’s Unapplied Amount doubled after deleting a check batch

    This may be a dumb question but have you run Reconcile on the Payables tables?

  • Heather Roggeveen Profile Picture
    9,146 on at
    Re: A/P open invoice’s Unapplied Amount doubled after deleting a check batch

    Check links may also help - don't forget to back up before running.  If neither the Reconcile or Check Links does any good, you will need to get the data fixed in the SQL tables.

  • Verified answer
    Zad Sail Profile Picture
    60 on at
    Re: A/P open invoice’s Unapplied Amount doubled after deleting a check batch

    Long, long way I corrected the unapplied invoice amount error......................................

    I was, in fact, able to apply a credit memo for the invoice's original amount (but not the total, incorrect unapplied amount of original amount x 2).  After reducing the invoice's unapplied amount back to it's original amount Great Plains then let me void the invoice.  I then had to re-enter the invoice.  Also I had to record a journal entry to the A/P account through the general ledger to reverse out the credit memo.  Everything balances and there seems to be no residual problems.

    I couldn't run checklinks on the tables because ultimate software oversight is handled at our national headquarters and they restrict certain functions.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans