We help IT Professionals succeed at work.

GP: Tying a Credit Card to More Than One G/L Account

Hi:

In the Microsoft Dynamics GP Credit Card Setup window, is there a way of tying a credit card to more than one G/L account?

An end user has three separate Cash accounts in the chart of accounts but does not want to create a separate Visa credit card for each account.  She wants the one Visa credit card - not three.

Thanks!

Software Engineer
Comment
Watch Question

Victoria YudinOwner / Dynamics GP Consultant

Commented:
I can't see how this would be possible. That's like saying I have a shortcut to a website, but it's linked to 3 different websites at the same time.
How would GP know which one to use when?

What is the business need for this request? What are they trying to accomplish?

Author

Commented:
Hi Victoria:

There's an integrating third-party that requires a one to one relationship between its product's setup of a credit card and GP's setup.

Software Engineer

Commented:
Does the GP customer actually have 3 different Visa credit cards that relate to the 3 different GL cash accounts?

If there are 3 different GL cash accounts for 3 Visa cards, why would the user only want one Visa card in GP?  Or why does the user NOT want 3 Visa cards in GP?

Or if there is really only 1 Visa card, what are the 3 GL cash accounts?

Author

Commented:
Hi Steve:

There's an integrating third-party that requires a one to one relationship between its product's setup of a credit card and GP's setup.

Software Engineer
Victoria YudinOwner / Dynamics GP Consultant

Commented:
That doesn't answer the question, unfortunately. What is the 3rd party software? What is the actual business reason for having 3 GL accounts and not 1? What are the transactions that will be entered using these credit cards and how/when is it determined which GL account needs to be used?

It's possible that there is a different way to address the issue, but to do that it's imperative to understand the entire picture.

Author

Commented:
Hi Victoria:

I'm afraid to mention the ISV in a public forum.  The client has three separate cash accounts recognizing three areas of her business.  These will be SOP invoices.  The credit card payment will reference the applicable cash account.

Software Engineer
Owner / Dynamics GP Consultant
Commented:
I am not sure these forums are actually "public", but why not mention the ISV? If it's credit card processing in GP, there are only a handful anyway. Up to you, of course.

Realistically, they (you) should have a long conversation with their GP partner about the best way to set this up and a workaround for what they want to accomplish. We can try to do this in a bunch of messages back and forth, but it might be a bit painful. If it's not credit card processing, let me know, as that means I am going in the wrong direction.

First question: Are there actually 3 DIFFERENT bank accounts that the cash gets deposited into when the credit cards are processed? Or is it one physical bank account, but there are 3 different GL accounts for it in GP? And if the latter...does that mean they're not using GP's bank rec module?