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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Dynamics GP 2016 R2- C...
Microsoft Dynamics GP (Archived)

Dynamics GP 2016 R2- Credit Card Payment processing

(0) ShareShare
ReportReport
Posted on by Lisa Benedict 20

Hi everyone, I have two clients on GP 2016 and that are experiencing problems with the cc payments since their upgrade. There are two issues they are encountering:

A. Both clients use the new payment method "Credit Card" option in the Payables Batch Entry window for vendors' invoices they paid with a cc. When they post the batch, the system posted the payment into the checkbook. Then they make the payment to the cc vendor and it posts a second entry in the checkbook. Both payment entries appear in the Bank Reconciliation window as items to reconcile. The only entry that should appear in the checkbook and bank rec windows is the payment to the cc vendor.

B. When the clients enter payments with the invoice in Payables Transaction window, the system adds two additional "PAY" lines in the distribution window.

Is this a setup issue and do they need to adjust the setup from the previous GP version?

*This post is locked for comments

I have the same question (0)
  • Cheryl Waswick Profile Picture
    Cheryl Waswick Microsoft Employee on at

    Hi Lisa,


    We have seen the cc's update Bank Rec, if you are not using Multicurrency, and the user pulls the batch up after it was initially created.  There is a quality issue #91182 that in this instance, the 'Card Name' field on the batch gets changed to 'Checkboook ID' and then it updates bank rec when you post the batch.   So if the user hadn't reopened the batch again, this would not have happened.  (The quality issue is being monitored and has no target fix date set at this time.)  The best work-around is to activate Multicurrency, and give users access to only the functional currency ID.  Having MC activated (whether you need MC or not) is the direction we recommend users to take, since now a functional currency is required on the company in GP.  All our testing is done with MC enabled, so you will run into less issues going forward if you just activate MC and just have one currency ID on everything.  If you just use the functional currency ID, then you do not need to set up any exchange rates or anything, so is easy to do. 

    Hope that helps, 

    Cheryl

    Microsoft Dynamics GP Community Support

  • Lisa Benedict Profile Picture
    Lisa Benedict 20 on at

    Cheryl, thanks for your reply.

    With respect to issue A, Multicurrency was already turned on in both the TEST as well as the production company database. Both companies behaved in the same manner as I described in the original post. Just on a hunch, I ran Check Links and it worked after that.

    On issue B, in the TEST company the distribution is correct but in the production database, the system is still adding two "PAY" distribution line (dr and cr) when recording the invoice and payment (cash, check or cc) in the Payables Transaction window. Is this particular issue related?

  • Cheryl Waswick Profile Picture
    Cheryl Waswick Microsoft Employee on at

    Hi Lisa,

    Issue A - If you have MC turned on, then you should not running into the known quality issue.  And that was only when they saved the batch and then reopened it up.  So be sure to test doing things like that as well.   But I'm glad to hear it seems to be working for you now.

    Issue B -  Do you mean when they enter the payment on the fly with the invoice and post it, the distributions show two 'PAY' lines along with the Purch and Cash like this:

    PURCH  DR $

    PAY                 CR -$

    PAY       DR $

    CASH               CR  -$

    If so, this is correct.  The invoice would be the debit to purchasing and a credit to accounts Payables.  And then the payment would be a debit to A/P to clear it out and a credit to Cash to reduce the balance.   You will see all four distribution lines when you have the 'Separate payment distributions' option marked in the company setup options.  If you didn't want to see the dr and cr wash to the AP acct, then you could unmark this option in the company setup options.   But most users like to have this marked so they can see the full activity that took place.   But it's up to you.

    Repost if any questions.

    Thanks

    Cheryl

    Microsoft Online Community

  • Lisa Benedict Profile Picture
    Lisa Benedict 20 on at

    Cheryl, following your instructions for question B, I unchecked the "Separate Payment Distributions" option in Company Setup Options and it worked as it did previously. Thank you very much for your help!

  • Community Member Profile Picture
    Community Member on at

    Hi Cheryl: Do you know if this issue has been addressed in the latest version ie: 2018?

    Thanks, Jim Robinson

  • Cheryl Waswick Profile Picture
    Cheryl Waswick Microsoft Employee on at

    Hi Jim,

    The issue with the credit card batch changing the 'Credit card ID' to the 'Checkbook ID' if you reopen the saved payables check batch (#91182) has not been fixed.  The reason is that this does not happen when Multicurrency is enabled, and that is the direction we would like users to take, so it provides incentive for the user to enable MC, whether or not they use it.    So there are no plan to fix this at this time as we want customers to activate MC, as they will run into less issues in the future (as we do not test without it). 

    Cheryl

  • Community Member Profile Picture
    Community Member on at

    Hi Cheryl: I could not see where she was re-opening the batch to process and issue was still happening. I also looked at the multi-currency tables and walked through setting them up for just the one currency ZUS…. But still had the issue…

    Not sure what I’m missing…. But for now, advised her to go back to processing through manual checks as she used to ….

    Wondering if you can get me a list of minimal setup requirements for MC, in order to make this work….

    Thanks for getting back so fast!

    Jim R.

  • Cheryl Waswick Profile Picture
    Cheryl Waswick Microsoft Employee on at

    Hello Jim,

    On the quality issue writeup for #91182, it says the only work-around is to enable Multicurrency and grant access to the functional currency ID only.  You do not need to set up any rate tables at all, if you will only be using the functional currency ID. 

    I would say to try this:

    1.  Go to Tools | setup | System | Registration and make sure MC is marked. 

    2.  Go to Tools | setup | System | Multicurrency access, click on your currency ID on the left and mark the ACCESS checkbox for all your companies on the right.   Click OK. 

    3. Go to Tools | setup | Financial | Multicurrency, make sure the Functional Currency ID is filled in.  Also enter the same for Reporting Currency.  Click OK. 

    4.  Make a backup. 

    5. Go to Microsoft Dynamics GP| Maintenance | check links,  Insert over 'Multicurrency account master' and 'Multicurrency Setup'. click OK to process. 

    6. Go to Cards | Financial | Checkbook and verify a currency ID is filled in on your checkbook setups. 

    7. Now test with a BRAND NEW payables batch. 

    We do generally give out KB 858730 for MC, but that more pertains to using MC, so has all the steps in it, including rate tables, which you do not need.   Just make sure to test with a brand new payables batch that has not already been changed.  (So delete the pm batch and regenerate it again.) 

    Thanks, 

    Cheryl

  • Community Member Profile Picture
    Community Member on at

    Hi Cheryl: Yes, this does work.... Not fond of the check links process as is has to tag every transaction both open and history (w/ currency id) in every module, but once done, it does work. Also, my colleagues and I are not excited to have to turn on MC for customers that really have no need for it, but.... I guess it is what it is,, for now..... Thanks for your assistance. Jim Robinson DXC/ Tribridge

  • Cheryl Waswick Profile Picture
    Cheryl Waswick Microsoft Employee on at

    Hi Jim, 

    Great, thanks for the update.   If you turn on MC and only grant access to the functional currency ID, then the users won't even know the difference.  (and there is no setup needed).   They will also run into less issues going forward with new features (as we only test with MC activated).  Plus a lot of reporting tools like MR are moving in the direction of using currency ID's.   So even if they don't use it, it sets them in the right direction that software is going.  

    Thanks

    Cheryl

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans