Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

MS Dynamics GP Royalty Report and Credit Cards

Posted on by 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

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    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 Profile Picture
    Victoria Yudin 22,766 on at
    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:

    1. 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. 
      1. 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.
      2. 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.
    2. 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.
      1. Cons: Users don't have to do anything extra. A lot of time saved if the transaction volume is high.
      2. 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. 

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans