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) / MS Dynamics GP Royalty...
Microsoft Dynamics GP (Archived)

MS Dynamics GP Royalty Report and Credit Cards

(0) ShareShare
ReportReport
Posted on by Richard Wheeler 75,854 Moderator

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

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,769 on at

    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. 
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,854 Moderator on at

    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.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans