Commission Setup
If you do not have a tenant for Microsoft Dynamics 365 Business Central, you can sign up for a free trial.
Once you have completed the sign up and your tenant is up and running, you can add the NAV-X Commission Management app from the AppSource Marketplace. If you have questions about the installation process of an app through Microsoft AppSource, you can find more information on installing apps on the Microsoft Docs site.
You can configure the initial setup using the Assisted Setup or the Manual Setup as described below. You can also always make changes to the setups accessing Commission Setup page. Choose the 
icon, enter Commission Setup, and then choose the related link to start the setup page.
General
The General fast tab defines the general system behavior and the commission rules. Each field is described below
| Enable Commission | Activates the Commission Management functionality. You can setup everything until you are ready for processing |
| Calculate Commissions on | You can select the basis for the commission calculations. Depending on the value that you select here, the commission rates will be applied to different base amounts. You can define defaults here and then also override this setup on each salesperson. - Gross Profit: Commissions are calculated on the difference between Sales Amount and Cost. - Sales: Commissions are calculated on the sales amount. - Quantity: The commissions are calculated based on the quantity that is sold. This is primarily important for royalty payments. |
| Commission Effective Date | - Date Entered: The work date the sales transaction is entered - Order Date: The date the order was placed. This is the “Order Date” on the sales document. - Shipment Date: The date the order will be shipped. This is based on the Shipment Date field on the sales document. - Invoice Date: The date the document will be posted. This is based on the “Posting Date” field on the sales document. - Due Date: The commission rates will be determined based on the Due Date of the document. - Date Paid: The commissions rates will be determined based on the actual date the invoice is paid. Initially, the due date will be used to determine the commission rates, which then will be adjusted to different rates when the invoice is paid. This can only be used when Commission Payable On is set to Cash Receipt |
| Commission Payable On | You can define different settings based on when commissions become payable to the salespeople. - Order Entry: As soon as sales document is entered - Shipment: When the shipment is posted, the shipped portion of the document will have payable commissions - Invoice: When the invoice is posted, the commission on the invoice amount becomes payable. - Cash Receipt:The commission for the paid amount of an invoice becomes payable. |
| Accrue Commissions in General Ledger | Defines, if you want the system to accrue commissions in general ledger accounts. If you activate “Automatic Commission Posting to G/L”, the system will post the commissions against liability and expense accounts when they are created and paid. If you disable this setting, you can still run a processing report at month’s end that will post the commission transactions to the G/L. |
| Use only most specific Commission Rates | By selecting Use only most specific Commission Rates, you can define different rates on different levels of the hierarchy. The system will always use the most specific rate setup when retrieving the commission rates. |
| Prevent Negative Commissions | By default, commissions are calculated on positive and negative lines on a sales transaction, which means that a specific sales transaction could turn into a negative total commission or a commission claw back. If you want to not claw back commissions from your salespeople in this scenario, place a check mark in this field. Whenever credit memos are processed, those credit memos result in negative commissions. This field does not affect the commission calculation for credit memos. |
| Prevent Negative Total Commissions | If a salesperson sold less during a period than the credit memos processed for this salesperson’s customers, the commission amount could be negative at the end of the period. If you do not want to claw back commissions from your salespeople in this scenario, you can activate the field. |
| Create Zero Amount Ledger Entries | If you want to use tiered or “Hockey Stick” commissions, you will have to activate the check mark in this field. This will create commission ledger entries, even if a salesperson does not receive a commission for a specific sale, but is involved in the sale. This then will be counted towards the total sales amount in a given period. |
| Create Zero Amount Ledger Entries for Resources | If you want to use tiered or "Hockey Stick" commissions for Resources, you will have to activate this field. This will create commission ledger entries, even if the resource doesn't receive a commission for the specific work. The resource must be defined on the document. |
| Include Current Document | If this field is enabled, the next commission tier is reached, when this current document brings the total sales over the commission tier minimum. |
| Do not synchronize Commission Split | If this field is enabled, the Commission Split will not be copied from the Customer or Ship-to Addresses, but will be defined based on the Salesperson Code on the sales document or the Commission Split Mappings. Read more about Commission Split Mappings. |
| Do not use Commission Splits defined on the header | If this field is enabled, the Commission Split will ony be calculated based on the Commission Splits defined on the document lines. |
| Commission Calendar | When commissions are calculated based on Percentage Billable, this field defines the calendar used to define the working days in a period. This can also be overwritten on Resources, Resource Groups, Items, or Item Categories. |
| Work Date for Resources | When commissions are calculated based on Percentage Billable, the date used as the Commission Effective Date can be defined in this field. Any date fields from the Sales Lines can be picked. |
| Limit Maximum Commission Split to 100% | If this field is activated, the total Commission Split defined on a document cannot exceed a total of 100%. |
Reason Codes
| Invoice Paid Adjust. Reason Code | If the Commission Effective Date is set to Date Paid, you must enter a reason code that will be used to post the adjusting Commission Ledger Entries required to adjust the commissions to the rates effective when the invoice is paid. |
| Commission Draw Reason Code | When using the commission draw functionality, this reason code is used on commission ledger entries to identify those entries as commission draw commission ledger entries. Read more about Commission Draws |
| Recalculate Adjust. Reason Code | Define the reason code that will be applied to any commission ledger entries when the entry is created due to a recalculation of the commissions using one of the processes in the system. |
Filter Criteria
The Filter Criteria fast tab enables you to customize what the system considers a commissionable document. Most fields are only available, if you choose Cash Receipt as the point in time when commissions will become payable.
| Min. Comm. Gross Profit% | Specifies the minimum gross profit that is required for commissions to be calculated on a single document line. If the gross profit is below the margin, salespeople do not receive commission on the transaction. This can be used to prevent salespeople from "price dumping" to make sales. |
| Process only fully paid invoices | Only fully paid invoices will make commissions payable. |
| Exclude Past Due invoices | If an invoice is paid late, the invoice will not produce commissions, even if it is paid eventually. |
| Exclude Customers with Past Due invoices | When a customer has an invoice that is past due, no commission will be paid for this customer. It will be paid when no invoices are past due anymore. |
| Exclude Customers with Past Due invoices for | When customers with past due invoices should be excluded, this allows adding a grace period. For instance, only exclude customers that have a past due invoice that is more than 90 days past due. |
| Exclude Customers if Past Due is more than (%) | Customers with past due invoices will only be excluded, if the amount past due is greater than a percentage of the full outstanding amount. |
| Exclude Credit Memos from Commissions | You can select, if you want to include or exclude credit memos from commission calculations. If credit memos are included, negative commissions will be calculated on credit memos and these commissions will be charged back to the salesperson. Credit memos lower the salesperson’s commissions in the month that they are posted. |
| Sales Growth Period | Our Commission Management app has the ability to define commission rates based on the growth of sales over time. To define the period length that is used to calculate the sales growth over the different periods, you can define the Sales Growth Period as Day, Week, Month, Quarter, or Year. |
Initial Rates
The Initial Rates fast tab enables you to define whether the system should allow different commission rates for initial sales to a specific customer.
| Initial Rate per Campaign | Customers with past due invoices will only be excluded, if the amount past due is greater than a percentage of the full outstanding amount. |
| Initial Rate per Ship-to | Customers with past due invoices will only be excluded, if the amount past due is greater than a percentage of the full outstanding amount. |
| Initial Rate per Salesperson | Customers with past due invoices will only be excluded, if the amount past due is greater than a percentage of the full outstanding amount. |
| Initial Rate per Entity | Customers with past due invoices will only be excluded, if the amount past due is greater than a percentage of the full outstanding amount. |
| Initial Rate Starting Date | Defines how the system will calculate the starting date of what constitutes an initial sale. The options are: - Document Date: The initial rate time frame starts from the time that the first order/transaction was entered. - Shipment Date: The initial rate timeframe start from the time that the first shipment was sent to the customer. - Invoice Date: The initial rate time frame starts from the date the first invoice was posted. |
| Initial Rate Duration | Together with the field Initial Rate Period this defines the time frame for the initial sale commissions. If the fields Initial Rate Starting Date, Initial Rate Duration, and Initial Rate Period are empty, only the first sale qualifies for the additional commission rates. |
| Initial Rate Period | Together with the field Initial Rate Period this defines the time frame for the initial sale commissions. The possible options are: - Day - Week - Month - Quarter - Year |
| Add Initial Commission | If this field is enabled, the initial commission defined will be added to the normal commissions rather than it replacing the normal commissions. |
Reporting
The Reporting fast tab enables you to configure sending commission reports automatically via email to your salespeople. You have to configure the SMTP Mail Setup before you can send emails automatically to your salespeople. The automatic emailing functionality is processed through a job defined on the job queue. To review and activate the job, please review the job queue setup.
| New Email Body Report Name | A Standard Report is defined that will be used to create the email body that is sent to your salespeople. You can create your own report to include additional information or you can update the layout and define it in the next field |
| New Email Body Layout Name | If no layout is defined, the default layout of the report defined above is used. The layout defines the actual content of the email body that is sent to your salespeople. |
| Send Email Every | You can define when the reports should be sent out. Together with the Send Email Period, you can define the number of periods when the report should be sent. For instance, you can send it once a month by entering 1 into this field and Month into Send Email Period. |
| Send Email Period | You can define the period on how often the report should be sent. |
| Process By | - Salesperson: No detail is going to be sent. Only one line per salesperson is going to be displayed. - Document: One line per document will be displayed on the report, showing totals per document. - Detail: Full Details will be shown on the report. A line per line will be displayed with detailed commission information. |
| Print Zero Commission Lines | The report can display year to date information about accumulated commission amounts. With this field, you can define what date is used to summarize the commission amounts. |
| Aged by | The report can display year to date information about accumulated commission amounts. With this field, you can define what date is used to summarize the commission amounts. - Commission Date: The commission date is the posting date of a commission ledger entry. - Date Payable: The date a commission is payable depends on the setup when commissions become payable. - Effective Date: The effective date is defined based on the commission setup. |
| Period End Date | Defines the end date of the period for which the report will be run. |
| No. of Periods | You can define the number of periods that should be included in the report. It is defaulted to one period, but can be more |
| Period Length | The type of the period that the report should be printed for. You can not only define Days, Weeks, Months, Quarters, or Years, but also for the Fiscal Year, or Accounting Periods. |
Commission Processing
| Document No. for Post Commissions to G/L | You can define the document number that should be used when running the Post Commissions to G/L report in a summary mode. The parameters that can be used are the following: - %1 = Day - %2 = Month - %3 = Year - %4 = Month Text - %5 = Salesperson No. |
| Document No. for Processing Commissions | You can define the document number that should be used when posting purchase invoices or other documents when paying commissions to your salespeople. The parameters that can be used are the following:
- %1 = Day
- %2 = Month
- %3 = Year
- %4 = Month Text
- %5 = Salesperson No. |
| Document No. for Commission Draws | You can define the document number that should be used when posting commission draws for your salespeople. The parameters that can be used are the following:
- %1 = Day
- %2 = Month
- %3 = Year
- %4 = Month Text
- %5 = Salesperson No. |
| Document No. for Manager Commissions | You can define the document number that should be used when posting manager commissions. The parameters that can be used are the following:
- %1 = Day
- %2 = Month
- %3 = Year
- %4 = Month Text
- %5 = Salesperson No. |
| Manager Customer Posting Group | When calculating Manager Commissions, the setting in this field will be used to define how the commissions are posted to the General Ledger. |
Performance
| Don't calculate commissions on transactions | This turns off any automatic commission calculation completely. To calculate commissions, you will have to run the Recalculate Sales Document Commissions or Recalculate Posted Sales Document Commissions. |
| No Calculation During Document Entry | If you notice decreased performance during order entry, you can activate this switch. It will then not calculate any commissions automatically anymore during the document entry, but will make the following switches available to activate. If none of these switches are activated, commissions are not automatically calculated and will have to be calculated manually. |
| Calculation During Document Release | This switch can only be activated, if No Calculation During Document Entry is enabled. If this is set, the commissions for the current document are automatically calculated at the time of document release. |
| Calculation before Posting | This switch can only be activated, if No Calculation During Document Entry is enabled. If this is set, the commissions for the current document are automatically calculated at the time of posting the document. |
| Do not calculate Commission Data | Specifies whether the commission rates and commission amounts are calculated or commission ledgere entries are created without this information. If you set this flag, you must recalculate commissions at the end of the period. |
Features
The Features fast tab enables you to disable features that you are not using to show a simplified user interface. You can also always personalize your user interface to your liking using the standard features provided by Business Central.
| Commissions by Campaigns | You can define different commission rates per sales campaigns that you are running. Only when this campaign is defined on the document, the rate is calculated from the specific rates defined for this campaign. If you do not anticipate using this feature, please make sure that this is not checked. |
| Commissions by Managers | You can define commission calculations for sales managers that receive commission payments based on the performance of their team. You can define different commission rates per sales campaigns that you are running. Only when this campaign is defined on the document, the rate is calculated from the specific rates defined for this campaign. If you do not anticipate using this feature, please make sure that this is not checked. |
| Different Commissions for overdue Documents | You can define that commissions are reduced for overdue invoices. If a customer does not pay an outstanding invoice on time, you can define different percentages to define how much the commissions are reduced based on the days overdue. If you do not anticipate using this feature, please make sure that this is not checked. |
| Different Commissions based on initial sale for a customer | You can calculate different commissions for the initial sale for a new customer. This can be used to incentivize salespeople to sign up new customers. |
| Different Commissions by Dimensions | You can define different commission rates based on the dimension values for global dimensions 1 and 2. If you do not anticipate using this feature, please make sure that this is not checked. |
| Use Maximum Commission Limits | You can define maximum amounts that will be paid as commission per period. This can limit the commission a salesperson can receive per period based on different filter criteria. If you do not anticipate using this feature, please make sure that this is not checked. |
| Use Commission Types | Commission types are tags on different commission rates to classify commissions. These types are posted to the Commission Ledger Entries and can be used for reporting. They do not have any other functionality in the system. |
| Use Recalculate Period | If sales for a specific salesperson reaches the next commission tier, the commission for already posted and possibly paid commissions can be recalculated to increase the commission rates based on the new commission rate for this tier. |
| Calculation Commission on General Journal | If you are importing financial transactions from other systems and want to calculate commissions on those transactions, activate this field. |
| Use Time Based Commission | If you are calculating commissions based on hours billed, activate this field |
| Allow Commission Payments to Resources | If you are calculating commissions based on hours billed and want to configure resources to be paid for the commissions instead of using salespeople, activate this field |
| Include Commissions from all Companies | If the salespeople selling or resources are working for multiple companies within your Business Central environment, you can activate this field to accummulate the sales and worked hours from all companies to apply commission tiers based on the combined numbers. |
Defaults
You can configure default settings for Items, Resources, Item Charges, and G/L Accounts. If you activate any of the fields, the system will configure new Items, Resources, Item Charges, or G/L Accounts marked as Commissionable.
General Changes
| Display Unit Cost on Sales Order | The unit cost can be displayed on the standard sales order page. This is typically a hidden field. |
General Journal Commissions
| Take Customer from General Journal Line Field | Select a field from the General Journal Line that will contain the customer to define the salespeople involved in the transactions. |
Actions
Process > Auto-Assign Salespeople
When initially setting up your new Commission Management System, you most likely have already salespeople assigned to your customers. NAV-X Commission Management allows the definition of an unlimited amount of salespeople responsible for a customer. Therefore, this functionality is provided for you to be able to use the existing salesperson assignment as the default salesperson for your existing customers. A salesperson commission split is defined for each customer with the salesperson defined in the “Salesperson Code” on the Customer Card. The split percentage is defined as 100 %.
Process > Calculate Commission Sales Documents
After setting up all commission splits and commission rates for your salespeople, you might want to add the commissions to your existing sales documents. You can use this report to calculate commissions for all or a subset of the existing sales documents. Learn more about recalculating sales document commissions.
Process > Calculate Commission Posted Sales Documents
After setting up all commission splits and commission rates for your salespeople, you might want to add the commissions to your posted sales documents. You can use this report to calculate commissions for all or a subset of the posted sales documents. Learn more about recalculating posted sales document commissions.
Help > Online Help
You can access this documentation directly from within Business Central.
Help > Start Product Tour
NAV-X Commission Management includes a product tour that can be used in your sandbox environment to walk through some of the features of NAV-X Commission Management. You can start the product tour from here. Learn more about the Product Tour.