{"id":18082,"date":"2019-08-14T06:37:18","date_gmt":"2019-08-14T06:37:18","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagex3\/?p=18082"},"modified":"2019-08-21T10:36:10","modified_gmt":"2019-08-21T10:36:10","slug":"block-sales-order-if-gross-price-is-equal-to-or-less-than-cost-price","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2019\/08\/14\/block-sales-order-if-gross-price-is-equal-to-or-less-than-cost-price\/","title":{"rendered":"Block Sales Order if gross price is equal to or less than cost price"},"content":{"rendered":"\n<p>In a live scenario, there is always a possibility that the company would want to keep control on the pricing that is defined during the sales. The scenario would be that the gross price should not exceed or matches with the cost price of the products entered in the sales process.<\/p>\n\n\n\n<p>This will help the company to control the sales and keep a validation that the gross price should not be less than or equal to cost price which will lead to a loss for the company.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"504\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/Image-1-2-1024x504.jpg\" alt=\"\" class=\"wp-image-18105\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/Image-1-2-1024x504.jpg 1024w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/Image-1-2-300x148.jpg 300w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/Image-1-2-768x378.jpg 768w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/Image-1-2-660x325.jpg 660w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/Image-1-2.jpg 1088w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Below is the setup that has to be followed in Sage X3.<\/p>\n\n\n\n<p><ul><li><p>Go to the Product Master and under the sales tab enter value \u201c1\u201d in the Minimum margin field.<\/p><\/li><\/ul><\/p>\n\n\n\n<p>Through this setup, the user has to enter the gross price more than cost price at least by 1%.<\/p>\n\n\n\n<p>Below is the creation of the sales order with the possible\nscenarios.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"1024\" height=\"494\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/Image2-1024x494.jpg\" alt=\"\" class=\"wp-image-18106\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/Image2-1024x494.jpg 1024w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/Image2-300x145.jpg 300w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/Image2-768x370.jpg 768w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/Image2-660x318.jpg 660w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/Image2.jpg 1089w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Here the gross price is 161.6000 and cost price is also\n161.6000 so the system will give the below error and block the sales order as\nthe margin has to be more than 1 %.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"1024\" height=\"476\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/Image3-1024x476.jpg\" alt=\"\" class=\"wp-image-18107\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/Image3-1024x476.jpg 1024w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/Image3-300x140.jpg 300w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/Image3-768x357.jpg 768w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/Image3-660x307.jpg 660w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2019\/08\/Image3.jpg 1101w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n","protected":false},"excerpt":{"rendered":"<p>In a live scenario, there is always a possibility that the company would want to keep control on the pricing that is defined during the sales. The scenario would be that the gross price should not exceed or matches with the cost price of the products entered in the sales process. This will help the\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2019\/08\/14\/block-sales-order-if-gross-price-is-equal-to-or-less-than-cost-price\/\">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":[1],"tags":[],"class_list":["post-18082","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/18082","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=18082"}],"version-history":[{"count":6,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/18082\/revisions"}],"predecessor-version":[{"id":18112,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/18082\/revisions\/18112"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=18082"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=18082"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=18082"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}