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 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

I have the same question (0)
  • ezzve Profile Picture
    35 on at

    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...

  • soma Profile Picture
    24,410 on at

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

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
Community Member Profile Picture

Community Member 4

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

#2
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans