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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Reconcile to GL - Unma...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Reconcile to GL - Unmatched Transactions

(0) ShareShare
ReportReport
Posted on by Rosemary 10

Good day,

I know the Reconcile to GL is just a tool to identify errors, and it does that. So my question is why would credit card payments show up as 'unmatched'? The invoice and payment are entered via the Payables Transaction entry screen. Payment entered as credit card, the associated vendor number is selected and posted.

I am seeing the entry in the vendor as an invoice and payment and the same amount in the credit card vendor. The card is paid via a manual payment, this I am seeing in the report on both the sub ledger and GL side.

So what am I missing?

Regards

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Jeff Grant Profile Picture
    Jeff Grant on at

    HI Rosemary,

    I am not able to replicate your issue in the very latest Dynamics GP code (18.4) so you are likely experiencing a known code issue that was present in prior installations, such as the following:

    90433: PMPAY transaction details are displaying under potentially matched transaction table for the credit card manual payment transactions posted in batch.
    90474: Credit card invoice details are not coming in the Reconcile to GL report for the partially paid Payables transaction

    In your process, are you posting at the transaction level or from a batch?  In my test I was posting at the transaction level so please test in this route as well if posting via a batch.

    Best Regards,
    Jeff

  • Rosemary Profile Picture
    Rosemary 10 on at

    Thank you for your response, I am posting at the batch level. This report, Reconcile to GL, is used by the Finance users a lot and they are confused as to why this is happening. They have also only recently starting using the facility of entering transactions paid by credit card as a credit card payment.

    Not sure how it is expected to be represented in the GL. At the subledger I am seeing the transaction and the credit card payment.

    Regards

  • Jeff Grant Profile Picture
    Jeff Grant on at

    Hi Rosemary,

    I am not able to replicate on the latest version posting via batch as well, so your performance may be the result of one of the known code issues outlined prior.

    What is the exact version of Dynamics GP you are getting your result?  If not on the very latest Dynamics GP code you may want to upgrade to avoid your outlined performance accordingly.

    As far as GL entries, when you manually pay an invoice with a CC in Dynamics GP the distributions of the manual payment use the same PAY account for the full debit/credit amount to create a 'wash' entry and a new invoice is created for the CC Vendor ID for the same amount to accommodate a future payment to the CC Vendor ID.

    Note that he CC Vendor may or may not have the same PAY account as the initial Vendor ID, dependent on the account settings in place at the Vendor level (Cards | Purchasing | Vendor | Accounts) during the payment.  

    Best Regards,

    Jeff

  • Suggested answer
    Rosemary Profile Picture
    Rosemary 10 on at

    Thanks very much for your response, you did confirm what the system was already doing. Relative to what you described it may appear as a duplication when it's not.

    Thanks

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 646 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 529 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans