How to set up commission rate in Sales Commission Module.

By | September 22, 2021

In Sage X3, commission module provides enhancement of existing commission feature of Sage X3. It helps in overcoming challenges such as accuracy in sales commission calculation, timely payment to sales representatives, track of commissions of sales representatives, etc.

In this blog we will learn how to setup commission rate for different combinations such as customer category, product category, sales site, shipment site, state group, etc. in sales commission module.

Navigate to All -> Commission -> Setup -> Commission rate setup

Below screen will appear.

Fig 01: Commission rate setup screen

The commission rate setup screen contains fields such as State group code, sales site, customer category, product category, shipment site, commission calculation method, commission base, range and commission. The commission can be set for multiple combinations of sales site, shipment site, state group, customer category and product category where customer category and product category are mandatory fields.

Consider an example of customer category and product category combination for commission rate setup such that “US” as Customer category and “BMSOL” as product category, “Flat” as Commission Calculation Method, “Net Price” as Commission Base. The commission rate setup screen provides an option to select commission in single range as well as multiple ranges. If the “Range” checkbox is ticked a pop up screen appears for adding multiple ranges for different combinations.

Fig 02: Commission Range Screen

After clicking on “OK”, the range will be added in the grid and first range will be visible to the user.

If the “Range” checkbox not selected, then the user can enter direct commission value as shown below.

Fig 03: Edit range button

Click on “Save” button to save the record.

Also, this range screen can be accessed from the left action button in the grid as “Edit Range” button so that user can edit the already entered range as shown in above figure.

The commission will be calculated on the above setup in sales order and sales invoice transactions.

Consider a sales order transaction for the above customer category and product category commission rate setup.

Navigate to All-> Sales -> Orders -> Select a transaction and create a sales order.

Fig 04: Sales order(a)

After selecting the customer, sales group code gets automatically populated in header from the Customer screen itself.

Fig 05: Sales order (b)

Here, in the line section the customer is “NA001” which is of “US” customer category and Products “BMS001” and “DIS001” are of product categories “BMSOL” and “DISTR” respectively. After passing the first line, the system.

checks whether commission is defined for the combination of entered customer category, product category, sales site, shipment site, state group, etc. If setup is present, then the “Commission Flat Amt” field will get field automatically filled as per setup if “Commission Cal. Method” is set “Flat” otherwise, if set as “Percent” then “Commission Rate” field will get filled in Line section of transaction.

Fig 06: Commission amount

As per commission rate setup above the first line falls in third range defined in commission range screen i.e. “15” and the second line will be given direct commission value i.e. “200” as defined in commission rate setup screen.

By using above steps we can we can setup commission rate for customer category and product category in sales commission module and similarly it can be done for sales sites, shipment site as well as state group combinations for both sales order and sales invoice transactions.

This blog helps us in creating a setup for commission rate in Sales Commission Module of Sage X3.

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation competence. 

Greytrix caters to a wide range of Sage X3, a Sage Business Cloud Solution, offerings. Our unique GUMU™ integrations include Sage X3 for Sage CRMSalesforce.com, Dynamics 365 CRM and Magento eCommerce along with Implementation and Technical Support worldwide for Sage X3. Currently we are Sage X3 Implementation Partner in East Africa, Middle East, Australia, Asia, US, UK. We also offer best-in-class Sage X3 customization and development services, integrated applications such as POS | WMS | Payment Gateway | Shipping System | Business Intelligence | eCommerce and have developed add-ons such as Catch – Weight  and Letter of Credit and India Legislation for Sage X3 to Sage business partners, end users and Sage PSG worldwide. Greytrix Sales Commission App for Sage X3 simplifies commission calculations and postings on sales transactions.

The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for processing and execution of application programs at the click of a button.

Greytrix is a recognized Sage champion ISV Partner for GUMU™ Sage X3 – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage X3 – Salesforce is a 5-star rated app listed on Salesforce AppExchange and GUMU™ integration for Dynamics 365 CRM – Sage ERP listed on Microsoft AppSource.

For more information on Sage X3 Integration and Services, please contact us at x3@greytrix.com, We would like to hear from you.