Great Plains Sales Commission Report – Consultant Highlights

Microsoft Dynamics GP serves an empty spectrum of industries, and a large percentage of Great Plains customers are likely to implement the Sales Order Processing module, especially if they also track inventory and need sales order or invoice breakdown. In Dynamics GP out of the box you should be able to set up a basic commission scheme for your salespeople and even sales territories, however real life is often different and requires commissions to be increased on very complex rules. We would like to discuss some commission calculation formulas and provide you with technical highlights:

1. Calculations of sales commissions related to credit cards. Since the credit card processor in turn has its own commission, it is probably trying to discourage your sales reps from selling with a credit card. Instead, you probably encourage your sales people to tip the customer to send checks the next day or do wire transfers. However, in e-commerce scenarios, credit cards are often the only way to work with passing customers and you have to accept credit cards. Complications with the credit card acceptance business can be related to gradation into preferred and less desirable credit card networks. In this scenario, you would like to generate a sales commission report with the credit card fees subtracted from the sales amount, subject to commissions

2. Project completion commission schemes. These are when you hold your sales staff accountable for the delivery of the project, including manufacturing overhead and associated purchasing. In this scenario, you would like to calculate commission for delivered projects, which means that invoices not yet delivered in the sense of production orders and drop-shipping purchases must be put on hold.

3. Other sales commission schemes. These may be related to sales quota for the quarter or month, discounted items vs. cash cow item differentiation, just to give you real life scenarios, which would be difficult to implement in standard functionality. from Dynamics GP.

4. How the commission logic could be implemented. In our opinion, Dynamics GP, being aimed at small and medium-sized companies, makes it feasible to do commissions at the reporting level with the following data entry results reports in AP or in the payroll module for commission disbursement .

5. Technological knowledge. Commission reports must be based on a complex commission calculation SQL stored procedure or view. The reporting tool could be one of the industry standards: Crystal Reports, SQL Server Reporting Services, Excel, Microsoft Access, Great Plains Dexterity, C# or VB.Net reporting web publishing