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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Payment doubled on invoices.

(0) ShareShare
ReportReport
Posted on by

Please I need your help.

Below is part of a e-mail I received from my controller, and I can't find an answer for her.

Last year we had an issue where a few checks within the 9/14/17 check run were cut and for some reason the payment was doubled on the invoices. The total amount of the double payments for all 3 vendors was $43,315.22

 

The issue still resides in my A/P Historical Aged Trial Balance report, where the double payment and invoice still appears (see below). In addition, we created credits for the double payment; however, by doing so this has reduced the general ledger accounts by making them all understated. I need to do a journal entry to correct; however, the offset would be a/c #2100 Accounts Payable. By doing the journal entry this will put my general ledger and the accounts payable sub-ledger out of balance, because I can’t get the invoices and double payment off. Can you look into and see how to remove the amounts from the accounts payable sub-ledger? They do not show up when doing a check run.

Thank you,

Glenn

*This post is locked for comments

I have the same question (0)
  • Tucker Profile Picture
    175 on at

    In GP, the way an item is entered is how it needs to be corrected. Thus, you are correct the GL entry initially entered to correct this issue needs to be reversed. You can try the Utility 'Reconcile/Reconcile Purchasing Document', this will allow you to select the specific Vendor(s)/Documents for correction. Hopefully, GP will correct itself. If not, the correction should be entered in the sub-ledger ONLY, prior to posting the sub-ledger correcting entry, turn-off the POST TO and POST THROUGH GL in the 'Posting' setup window: Tools>>Setup>>Posing, select Purchasing as the Series, select the Origin, and remove the checks from Post to General Ledger and Post Through General Ledger files. If this is your elected method of correcting this issue. PLEASE DO NOT...for get to change the setup back once the item is corrected. I hope this helps.

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans