Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Payment posted to GL but not showing up in PM reconciliation

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,928 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans