Commission Functionality in Dynamics GP

Anyone who has tried to use the Commissions functionality in Dynamics GP knows that it is not the most intuitive tool in the system. Entering the commissions, getting reports of the commissions, and making sure the commissions are paid are the most important aspects of using commissions. However, they are also some of the least explained aspects of commissions in GP.

Entering Commissions

Entering commissions in GP is simple as long as the way you calculate commissions is simple. If you use a simple percentage based calculation, GP commissions will easily track your commissions for each sale. You just need to be sure that the correct salesperson is selected on the transaction, and that this salesperson is setup correctly with their commission percentage.

Commission Reports

The default reports for commissions are very basic, and in order to be useful they will need to be modified. Even simple modifications, such as adding the customer name for each invoice listed in the report will greatly improve the usability of the reports.

Mark Commission Reports as Paid

Making sure commissions are paid, or marking them as paid is a necessary function of calculating and paying commissions. The way you pay them will depend on whether you use Payroll through GP or through an outside provider. Either way you’ll need to mark the commissions as paid. This you are able to do through a routine in the Sales Module.

What this routine does is take the commissions that are eligible to be paid and marks them as paid. It also prints a report of what it has marked as paid. This report you can use to calculate the commission amount for each employee for that time period. The time period is since the last time you ran this transfer commission routine.

The commissions that are marked as eligible to be paid will depend on the commissions settings, mainly whether or not you have marked the Pay Commissions After Invoice Paid in Receivables Management Setup. After the process is run, if you run the regular default reports, you can modify them to have an “X” next to the invoices that have been marked as paid.

The Bottom Line

Overall, the commission functionality is useful if you have simple commission calculations and patience.

If you have complex commission calculations, I recommend having a SQL Reporting Services Report developed to manage complex commission structures.