DBD: AR - Multi Commission Code Feature
DBD: Accounts Receivable - Multi Commission Code Feature
🔵 Overview This module will allow for commission to be calculated for each salesperson based on their individual commission code setup.
For this feature to be in effect, the associated module will need to be activated, as well as changing a setting in the A/R System Setup Parameters (ARGMPC AR Parameter Setup III Optional features):
"Enable Commission Feature for Individual Salesperson"
⚠️ CRITICAL UPDATE NOTE: Please note that once this parameter has been turned on, disabling it may cause inconsistent results.
Before any processing can begin, a new utility will need to be run to create entries from existing OPEN ORDERS in the new multiple commissions file AXS. ALL AR INVOICING BATCHES MUST BE CLOSED before this is run. This utility will be run at time of installation.
Once this feature is enabled, all Order and Invoice Entry programs will now have a new panel that can be displayed to view or modify each salesperson's commission code when the user accesses the commission code field.
Throughout the system, where commission is being calculated, the system will now calculate based on each salesperson's commission code, and all results are kept in detail in the new AXS file.
All commission code priority hierarchy will still be maintained.
💡 Note: Your commission calculation must all be based on commission by line. If you are planning to use this feature, please review all current commission codes and verify this setup.
This feature will need to be enabled for your system by DemandBridge Implementation. This will be done by installing a current release of the software to your system.
Step 1: Turn On the Parameter Setting
Make sure that all batches have been updated.
Turn on the parameter setting in: AR, Setup, System, System Setup, Parameters, Panel 3
AR Parameter Setup - III *** Optional Features *** - ARGMPC
Step 2: Run the Setup Utility
The next step is to run the utility to process your data to setup the multi commission files on each of your open orders.
💡 Note: The utility is accessible thru the CHUI interface — contact support to work with you.
- From the menu, type in: AR2UUC. This program will create new multiple commissions records (AXS) from existing open orders. All FS1 records will be checked for the 'Invoicing in Progress' flag. This utility will assume all AR batches have been closed.
- Select the option F7 to proceed.
New Panel Options with Multi-Commission
Customer Constant Data - Salesreps tab - ARGMAB
No changes are required at the customer level unless you would like to review your current split on these accounts. Remember, this is the % share for these accounts.
Order Header — Salesperson Info
Sales Order Header - Salesperson Info - FMGODA
As you proceed thru Order Entry, you will notice in the order header, panel 3 (Salesperson Info), next to the Commission Code field you will now see the Multi Comm button rather than the commission code.
When you select this button, you will see the following panel.
Multiple Salesman Commission Codes - ARGSCM
This will display the salespeople associated with the order and their respective commission codes.
Order Line Entry — Pricing Panel
Order Line Entry - Pricing tab - FMGODB
The Multi Comm button is here in the Pricing tab in Order Line Entry. If you are using streamlined order entry, you need to select the actual line from the Order Summary if you wish to review this field.
If you are using commission substitution at the product code / vendor level, then you would be able to see that the system is applying the appropriate commission for each salesperson, taking these options into consideration.
A/R Invoicing Entry
A/R Invoice Entry - ARGEAC
Please notice that you will not have the ability to change the Commission, Salesperson, or split amount in the invoice header. If these need to be changed, you would need to delete the invoice and make these changes at the order level.
A/R Invoice Entry - Lines - ARGEAC.2
Multi Comm button available at invoice line level.
A/R Invoice Entry - Summary - ARGEAC.3
The commission code displayed here is just a display of the first code. The commission total reflects the calculation for all salespeople associated with this invoice.
Commission Reporting
Here is an example of the Commission Pending report for this invoice. You will see that salesperson 0120 received 40% Gross Profit of their 50% share. Salesperson 0125 received 50% Gross Profit of their 50% share.
Commission Pending Report — Salesperson 0120
Commission Pending Report — Salesperson 0125
Maintenance File
System administrators can access a Multiple Salesman Commission Maintenance feature to review the details of the calculated commission for every invoice. This information is available as soon as the invoice is entered.
💡 Note: For further information on accessing this information, contact support.
Multiple Salesman Commission Maintenance - ARGMCU
An administrator can access this utility if needed to review the specific coding that was in place to generate the commission on each invoice. This provides a user-friendly screen to review the data in AXS for specific invoices. You do not have the ability to modify the details.
Frequently Asked Questions
Q: What does the Multi Commission Code feature actually do?
A: It calculates commission for each salesperson on an order/invoice based on their own individual commission code, rather than a single commission code for the whole transaction, with results tracked in detail in the new AXS file.
Q: How do I turn this feature on?
A: It must be enabled for your system by DemandBridge Implementation by installing a current release of the software, then activated via the A/R System Setup Parameters III (ARGMPC), "Enable Commission Feature for Individual Salesperson."
Q: What has to happen before I turn this feature on?
A: Make sure all batches have been updated, and review your current commission codes — your commission calculation must all be based on commission by line.
Q: What do I need to do right after turning the parameter on?
A: Run the AR2UUC utility (accessible through the CHUI interface — contact support) to create multiple commissions records (AXS) from existing open orders. All AR invoicing batches must be closed before running it.
Q: Is it safe to turn this feature off again later?
A: No — once this parameter has been turned on, disabling it may cause inconsistent results.
Q: Can I change the commission split on an invoice directly?
A: No — you cannot change the Commission, Salesperson, or split amount in the invoice header or lines. If changes are needed, you must delete the invoice and make the changes at the order level.
Q: How can I review the exact commission calculation for a specific invoice?
A: System administrators can use the Multiple Salesman Commission Maintenance feature to review the details as soon as an invoice is entered. This is view-only — you cannot modify the details there.
Tags: accounts-receivable, commissions, multi-commission-code, axs-file, salesperson-split, DB-distributor