How to setup commission factor for sales representative in X3

Commission also called a sales commission, is a payment given to salespeople for each individual sale. When planning a commission structure, sales leaders should consider factors like how much of their budget they can allocate for commission, how much they’ll pay for different levels of sales output, employee’s base salaries, and potential bonuses or incentives to include.

It’s the amount of money a salesperson earns based on the number of sales they have made. This is additional money that often complements a base salary.

A sales commission rate can reflect factors like the value of products or services sold, employee involvement in the sales process, or the size of an employee’s sales territory.

Commission in Sagex3:

Commissions in Sage X3 assign at the time of sales order creation/Sales Invoice creation based on sales rep.

Create Sales Rep with Commission Rate:

Navigate to: Common Data>Bps>Sales Rep

Fig1.1 : Creation of Sales Rep

On General Tab, Commission base section, from the list % on Net price,% on Margin,% on formula.

Select % on Net Price. if % on formula selected then commission formula 1 and 2 field get enabled.

Commission Rate section has Sales categories,commerical rate 1,commerical rate 2.

Sales categories-category 1 example may be Direct sale, Category 2 example may be whole sale.

Commercial rate 1 which is applicable for primary sales rep and commercial rate 2 which is applicable for secondary sale rep.

Financial section, selecting Accounting code where sales rep accounting setup can be defined.

Commission Setup on Customer Master:

Navigate to: Common Data>Bps>Customer

Fig 2.1: Sales Rep Setup on Customer screen

On Commercial tab ,under sales reps section, choose commission category and primary sales rep 1 and secondary sales rep 2.

Ship-to customer tab also has primary and secondary sales rep ,which override the commercial tab sales rep’s.

Fig 2.2 : Sales Rep Setup on Customer screen(ship-to customer Tab)

Sales Order- Automatic allocation of Sales Rep:

Navigate to: Sales >Orders>Orders

Fig 3.1: Sales Rep on Sales Order Screen

On Management tab, sales rep will automatically flow based on the customer chosen on header level.

On the Lines tab, Select the action button pop up view for the product and view corresponding sales rep1 and 2.

Sales Invoice-Automatic allocation of Sales Rep:

On Management tab, sales rep will automatically flow based on the customer chosen on header level.

On the Lines tab, Select the action button pop up view for the product and view corresponding sales rep1 and 2.

Sales Price List Setup For Sales Rep:

Navigate to: Setup>Sales>Price Lists >Setup

Fig 4.1 Setting Sales rep commission factor on Price List Screen

On T20 Price List, price/Free tab sale rep commission, commission factor set to yes and click on Yes for “This pricing contain lines ,Do you want to continue?”,finally click on save.

This factor will flow to sales invoice which is having corresponding sales rep.

Report Selection for Sales Rep. Bonus List :

Navigate to: More>Reports>Reports

Fig 5.1: Report Screen

This blog helps us to understand how commission is assigned to individual sales rep and setting up the price list for sales rep commission and report to view sales rep bonus.

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 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 will like to hear from you.