Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Payment posted to GL but not showing up in PM reconciliation

(0) ShareShare
ReportReport
Posted on by 35

Hi,


I had an invoice entered in CAD$ (which is our functioning currency) but we ended up paying the invoice from our USD chequebook for the same amount of the invoice. I set the exchange rate at 1.0 and went through the regular process of cutting a cheque and posting the payment and everything worked without error. The invoice no longer showed up in our Purchasing Trial Balance (A/P) and the amount was recorded as a credit to our USD chequebook.

However, when reconciling PM to GL, the payment was posted to GL but wasn't debited in A/P. Even checking the A/P account, I see that the transaction was never recorded despite the distribution being set to debit A/P.


I've checked that our currency accounts are set up, that there's multicurrency access, that the report is to show multicurrency data, and that the A/P account also has USD listed as a currency and then voided and re-did the payment but it still doesn't show up in A/P.


I did try the same transaction in a test company we have setup with the same settings and it worked out there, but not in our actual company.

Can anyone help out with this?

*This post is locked for comments

  • soma Profile Picture
    soma 24,406 on at
    RE: Payment posted to GL but not showing up in PM reconciliation

    Have you compared your Purchasing Trial Balance (A/P) report options with test company report options window?

  • ezzve Profile Picture
    ezzve 35 on at
    RE: Payment posted to GL but not showing up in PM reconciliation

    Update: So I voided and redid the payment which didn't initially show up in the trial balance, but now the void and new payment do show up and cancel each other out because the original debit never showed up so my balance doesn't change. So now I'd somehow need to void the payment without posting it and then redo it...

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans