{"id":21420,"date":"2020-12-28T10:50:52","date_gmt":"2020-12-28T10:50:52","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagex3\/?p=21420"},"modified":"2020-12-28T10:50:54","modified_gmt":"2020-12-28T10:50:54","slug":"how-to-setup-commission-factor-for-sales-representative-in-x3","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2020\/12\/28\/how-to-setup-commission-factor-for-sales-representative-in-x3\/","title":{"rendered":"How to setup commission factor for sales representative in X3"},"content":{"rendered":"\n<p>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\u2019ll pay for different levels of sales output, employee&#8217;s base salaries, and potential bonuses or incentives to include.<\/p>\n\n\n\n<p>It&#8217;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.<\/p>\n\n\n\n<p>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\u2019s sales territory.<\/p>\n\n\n\n<p><strong>Commission in Sagex3:<\/strong><\/p>\n\n\n\n<p>Commissions in Sage X3 assign at the time of sales order creation\/Sales Invoice creation based on sales rep.<\/p>\n\n\n\n<p><strong>Create Sales Rep with Commission Rate:<\/strong><\/p>\n\n\n\n<p><em><strong>Navigate to: Common Data>Bps>Sales Rep<\/strong><\/em><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"919\" height=\"485\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/12\/Fig1.1-Creation-of-Sales-Rep.png\" alt=\"\" class=\"wp-image-21423\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/12\/Fig1.1-Creation-of-Sales-Rep.png 919w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/12\/Fig1.1-Creation-of-Sales-Rep-300x158.png 300w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/12\/Fig1.1-Creation-of-Sales-Rep-768x405.png 768w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/12\/Fig1.1-Creation-of-Sales-Rep-660x348.png 660w\" sizes=\"(max-width: 919px) 100vw, 919px\" \/><figcaption><strong>Fig1.1 : Creation of Sales Rep<\/strong><\/figcaption><\/figure>\n\n\n\n<p>On General Tab, Commission base section, from the list % on Net price,% on Margin,% on formula.<\/p>\n\n\n\n<p>Select % on Net Price. if % on formula selected then commission formula 1 and 2 field get enabled.<\/p>\n\n\n\n<p>Commission Rate section has Sales categories,commerical rate 1,commerical rate 2.<\/p>\n\n\n\n<p>Sales categories-category 1 example may be Direct sale, Category 2 example may be whole sale.<\/p>\n\n\n\n<p>Commercial rate 1 which is applicable for primary sales rep and commercial rate 2 which is applicable for secondary sale rep.<\/p>\n\n\n\n<p>Financial section, selecting Accounting code where sales rep accounting setup can be defined.<\/p>\n\n\n\n<p><strong>Commission Setup on Customer Master:<\/strong><\/p>\n\n\n\n<p><em><strong>Navigate to: Common Data>Bps>Customer<\/strong><\/em><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"875\" height=\"690\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/12\/Fig-2.1-Sales-Rep-Setup-on-Customer-screen-2.png\" alt=\"\" class=\"wp-image-21424\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/12\/Fig-2.1-Sales-Rep-Setup-on-Customer-screen-2.png 875w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/12\/Fig-2.1-Sales-Rep-Setup-on-Customer-screen-2-300x237.png 300w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/12\/Fig-2.1-Sales-Rep-Setup-on-Customer-screen-2-768x606.png 768w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/12\/Fig-2.1-Sales-Rep-Setup-on-Customer-screen-2-660x520.png 660w\" sizes=\"(max-width: 875px) 100vw, 875px\" \/><figcaption><strong>Fig 2.1: Sales Rep Setup on Customer screen<\/strong><\/figcaption><\/figure>\n\n\n\n<p>On Commercial tab ,under sales reps section, choose commission category and primary sales rep 1 and secondary sales rep 2.<\/p>\n\n\n\n<p>Ship-to customer tab also has primary and secondary sales rep ,which override the commercial tab sales rep&#8217;s.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"940\" height=\"604\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/12\/Fig-2.2-Sales-Rep-Setup-on-Customer-screenship-to-customer-Tab.png\" alt=\"\" class=\"wp-image-21425\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/12\/Fig-2.2-Sales-Rep-Setup-on-Customer-screenship-to-customer-Tab.png 940w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/12\/Fig-2.2-Sales-Rep-Setup-on-Customer-screenship-to-customer-Tab-300x193.png 300w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/12\/Fig-2.2-Sales-Rep-Setup-on-Customer-screenship-to-customer-Tab-768x493.png 768w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/12\/Fig-2.2-Sales-Rep-Setup-on-Customer-screenship-to-customer-Tab-660x424.png 660w\" sizes=\"(max-width: 940px) 100vw, 940px\" \/><figcaption><strong>Fig 2.2 : Sales Rep Setup on Customer screen(ship-to customer Tab)<\/strong><\/figcaption><\/figure>\n\n\n\n<p><strong>Sales Order- Automatic allocation of Sales Rep:<\/strong><\/p>\n\n\n\n<p><em><strong>Navigate to: Sales >Orders>Orders<\/strong><\/em><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"719\" height=\"486\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/12\/Fig-3.1-Sales-Rep-on-Sales-Order-Screen.png\" alt=\"\" class=\"wp-image-21426\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/12\/Fig-3.1-Sales-Rep-on-Sales-Order-Screen.png 719w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/12\/Fig-3.1-Sales-Rep-on-Sales-Order-Screen-300x203.png 300w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/12\/Fig-3.1-Sales-Rep-on-Sales-Order-Screen-660x446.png 660w\" sizes=\"(max-width: 719px) 100vw, 719px\" \/><figcaption><strong>Fig 3.1: Sales Rep on Sales Order Screen<\/strong><\/figcaption><\/figure>\n\n\n\n<p>On Management tab, sales rep will automatically flow based on the customer chosen on header level.<\/p>\n\n\n\n<p>On the Lines tab, Select the action button pop up view for the product and view corresponding sales rep1 and 2.<\/p>\n\n\n\n<p><strong>Sales Invoice-Automatic allocation of Sales Rep:<\/strong><\/p>\n\n\n\n<p>On Management tab, sales rep will automatically flow based on the customer chosen on header level.<\/p>\n\n\n\n<p>On the Lines tab, Select the action button pop up view for the product and view corresponding sales rep1 and 2.<\/p>\n\n\n\n<p><strong>Sales Price List Setup For Sales Rep:<\/strong><\/p>\n\n\n\n<p><em><strong>Navigate to: Setup>Sales>Price Lists >Setup<\/strong><\/em><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"719\" height=\"562\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/12\/Fig-4.1-Setting-Sales-rep-commission-factor-on-Price-List-Screen.png\" alt=\"\" class=\"wp-image-21427\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/12\/Fig-4.1-Setting-Sales-rep-commission-factor-on-Price-List-Screen.png 719w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/12\/Fig-4.1-Setting-Sales-rep-commission-factor-on-Price-List-Screen-300x234.png 300w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/12\/Fig-4.1-Setting-Sales-rep-commission-factor-on-Price-List-Screen-660x516.png 660w\" sizes=\"(max-width: 719px) 100vw, 719px\" \/><figcaption><strong>Fig 4.1 Setting Sales rep commission factor on Price List Screen<\/strong><\/figcaption><\/figure>\n\n\n\n<p>On T20 Price List, price\/Free tab sale rep commission, commission factor set to yes and click on Yes for &#8220;This pricing contain lines ,Do you want to continue?&#8221;,finally click on save.<\/p>\n\n\n\n<p>This factor will flow to sales invoice which is having corresponding sales rep.<\/p>\n\n\n\n<p><strong>Report Selection for Sales Rep. Bonus List :<\/strong><\/p>\n\n\n\n<p><em><strong>Navigate to: More>Reports>Reports<\/strong><\/em><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"705\" height=\"567\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/12\/Fig-5.1-Report-Screen.png\" alt=\"\" class=\"wp-image-21428\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/12\/Fig-5.1-Report-Screen.png 705w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/12\/Fig-5.1-Report-Screen-300x241.png 300w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/12\/Fig-5.1-Report-Screen-660x531.png 660w\" sizes=\"(max-width: 705px) 100vw, 705px\" \/><figcaption><strong>Fig 5.1: Report Screen<\/strong><\/figcaption><\/figure>\n\n\n\n<p>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.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>About Us<\/strong><\/h2>\n\n\n\n<p>Greytrix \u2013 a globally recognized and one of the oldest Sage Development Partners is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, 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.<\/p>\n\n\n\n<p id=\"block-28013e99-0882-44c6-b705-7b16c85053b2\">Greytrix&nbsp;has some unique integration solutions developed for&nbsp;<a href=\"https:\/\/www.greytrix.com\/sage-crm\/\">Sage CRM<\/a>&nbsp;with Sage ERPs&nbsp;namely&nbsp;<a href=\"https:\/\/www.greytrix.com\/sage-x3-erp\/\">Sage X3<\/a>,&nbsp;<a href=\"https:\/\/www.greytrix.com\/sage-intacct\/\">Sage Intacct<\/a>,&nbsp;<a href=\"https:\/\/www.greytrix.com\/sage-100-erp\/\">Sage 100<\/a>,&nbsp;<a href=\"https:\/\/www.greytrix.com\/sage-500-erp\/\">Sage 500<\/a>,&nbsp;and&nbsp;<a href=\"https:\/\/www.greytrix.com\/sage-300-erp\/\">Sage 300<\/a>. We also offer best-in-class&nbsp;Sage ERP&nbsp;and&nbsp;Sage CRM&nbsp;customization and development services&nbsp;to&nbsp;Business&nbsp;Partners,&nbsp;End&nbsp;Users, and Sage PSG worldwide. Greytrix&nbsp;helps in&nbsp;the migration of Sage CRM from&nbsp;Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes&nbsp;addons like&nbsp;&nbsp;Greytrix Business Manager,&nbsp;Sage CRM Project Manager,&nbsp;Sage CRM Resource Planner,&nbsp;Sage CRM Contract Manager,&nbsp;Sage CRM Event Manager,&nbsp;Sage CRM Budget Planner,&nbsp;Gmail Integration,&nbsp;Sage CRM Mobile Service Signature,&nbsp;Sage CRM CTI Framework.<\/p>\n\n\n\n<p id=\"block-4bc42a09-fb13-4598-8137-ce5f7b91ce28\">Greytrix is a recognized&nbsp;Sage Champion Partner&nbsp;for GUMU&#x2122; Sage X3 \u2013 Sage CRM integration listed on&nbsp;<a href=\"https:\/\/www.sage.com\/marketplace\/asb_ListingDetail?listingId=a1h24000007PC3aAAG\" target=\"_blank\" rel=\"noreferrer noopener\">Sage Marketplace<\/a>&nbsp;and Sage CRM \u2013 Sage Intacct integration listed on&nbsp;<a href=\"https:\/\/marketplace.intacct.com\/MPListing?lid=a2D0H000007kiHyUAI\" target=\"_blank\" rel=\"noreferrer noopener\">Sage Intacct Marketplace<\/a>. The&nbsp;<a href=\"https:\/\/www.greytrix.com\/gumu\/\" target=\"_blank\" rel=\"noreferrer noopener\">GUMU&#x2122; Cloud framework<\/a>&nbsp;by Greytrix forms the backbone of cloud integrations that are managed in real-time for the processing and execution of application programs at the click of a button.<\/p>\n\n\n\n<p id=\"block-76376301-1c3e-4250-8a09-727595a606f0\">For more information on our integration solutions, please contact us at&nbsp;<a href=\"mailto:sage@greytrix.com\">sage@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>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\u2019ll pay for different levels of sales output, employee&#8217;s base salaries, and potential bonuses or incentives\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2020\/12\/28\/how-to-setup-commission-factor-for-sales-representative-in-x3\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,10],"tags":[3177,3176,1655,1983,1997],"class_list":["post-21420","post","type-post","status-publish","format-standard","hentry","category-sage-erp-x3","category-standard","tag-bonus","tag-commision","tag-reports","tag-sales-order","tag-sales-representative"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/21420","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=21420"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/21420\/revisions"}],"predecessor-version":[{"id":21429,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/21420\/revisions\/21429"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=21420"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=21420"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=21420"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}