MS Dynamics GP Royalty Report and Credit Cards

(0) Share

Report

Posted on by Richard Wheeler

75,730

I have been brought in on another report project. This project will involve royalties. The trick with this report is that they would like to be able to incorporate the credit card fees per transaction they incur into the royalty report. This will give them a much more accurate report as to the true pofit per transaction and, hence, the royalties due. Has anyone created such a report in the past and, if so, how did you obtain the per transaction credit card fee?

*This post is locked for comments

All responses (2)

Answers (0)

Richard Wheeler 75,730 on at

Like (0)

Report

RE: MS Dynamics GP Royalty Report and Credit Cards

Thanks for the tips Victoria. They process about 500 credit card orders per day so there are a lot of transactions. I will find out what type of information they get electronically and then decide on a plan.
Victoria Yudin 22,766 on at

Like (0)

Report
RE: MS Dynamics GP Royalty Report and Credit Cards

Hi Richard,

There are a number of different credit cards and credit card processors, and the fees may be very different for each transaction depending on the exact agreement with the credit card processor. Each credit card processor will also have different reporting. Many that I have seen make it pretty difficult to determine the exact cost of each transaction. All that said, I think you have 2 options:

Give the users a way to retroactively add the fee to the transaction. Maybe it's an Extender window or something like that on posted transactions.

Pros: They are able to track and thus report on the exact cost of each transaction. Or maybe they populate this directly into a custom table that simply holds the Doc Type, Doc Number and Fee.

Cons: If there are a lot of transactions this may get very cumbersome. If it is not always so easy to determine the exact cost, this may become a frustrating and time consuming exercise for users.

Determine a formula that estimates the credit card fee and use that for your reporting. While it may not always be exact, it will hopefully be close.

Cons: Users don't have to do anything extra. A lot of time saved if the transaction volume is high.

Pros: If the costs of the transactions are very different (ie, a domestic transaction might cost 2.5% vs. an international one might be 5% and you're talking large amounts), then you may not be able to come up with a good enough formula to always estimate properly.