{"id":32180,"date":"2026-05-29T10:20:16","date_gmt":"2026-05-29T10:20:16","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagex3\/?p=32180"},"modified":"2026-05-29T10:55:03","modified_gmt":"2026-05-29T10:55:03","slug":"automating-po-pricing-in-sage-x3","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2026\/05\/29\/automating-po-pricing-in-sage-x3\/","title":{"rendered":"Automating PO Pricing in Sage X3"},"content":{"rendered":"\n

Managing accurate pricing in purchase transactions is essential for maintaining cost control and consistency. In Sage X3<\/a>, the Price List functionality allows businesses to automate pricing in Purchase Orders based on predefined conditions. One of the most useful features is the ability to define prices based on a Supplier\u2013Product combination<\/strong>, ensuring that the correct gross price is automatically applied during Purchase Order entry.<\/p>\n\n\n\n

In this blog, we\u2019ll walk through how to maintain supplier-specific price lists and how they influence the gross price in Purchase Orders.
In Sage X3, price lists can be configured to apply under different conditions. For purchasing, the T20 Supplier\/Product Price List <\/strong>is specifically designed to handle pricing based on a combination of supplier and product.<\/p>\n\n\n\n

This reduces manual intervention and minimizes pricing errors.<\/p>\n\n\n\n

To maintain these price lists, follow the navigation path below:<\/p>\n\n\n\n

Path:<\/strong>
Go To \u2192 Purchasing \u2192 Price Lists \u2192 Price List Entry
Within this section, select the T20 Supplier\/Product Price List<\/strong> type.<\/p>\n\n\n\n

New Stuff: <\/strong>How We Fixed Sage X3 Workflow Notification Emails Not Sending After User Approval<\/a><\/p>\n\n\n\n

\"[Fig<\/a><\/center> \n
[Fig 1. Purchase Price List]<\/center><\/font>\n\n\n\n

To better understand how the Supplier\u2013Product Price List works in Sage X3, let\u2019s look at a practical example.<\/p>\n\n\n\n

In the Price List Entry screen, we have selected:
\u2022Supplier: <\/strong>SCP0093
\u2022Product:<\/strong> FG-BLOWER-0001
\u2022Gross Price: 1200<\/strong><\/p>\n\n\n\n

Now, when we create a Purchase Order using the same Supplier (SCP0093) <\/strong>and Product (FG-BLOWER-0001)<\/strong>, the system automatically retrieves the predefined price from the price list. As a result, the gross price of 1200 <\/strong>is directly populated in the Purchase Order line.<\/p>\n\n\n\n

This confirms that the pricing is successfully flowing from the price list into the transaction without requiring manual entry. Refer Fig. 2.<\/p>\n\n\n\n

\"G[Fig<\/a><\/center> \n
[Fig 2. Purchase Order – 1]<\/center><\/font>\n\n\n\n

Condition 1: Price Derivation from Last Purchase Order<\/strong><\/p>\n\n\n\n

In scenarios where a Supplier\u2013Product price combination <\/strong>is not maintained in the T20 Supplier\/Product Price List<\/strong>, Sage X3 provides a fallback mechanism to ensure that pricing is still populated in the Purchase Order.<\/p>\n\n\n\n

Under this condition, the system automatically retrieves the gross price from the most recent Purchase Order <\/strong>created for the same:
\u2022Supplier
\u2022Product<\/strong><\/p>\n\n\n\n

This helps maintain continuity in pricing and reduces the need for manual data entry, especially when price list records are not available.<\/p>\n\n\n\n

\"[Fig<\/a><\/center> \n
[Fig 3. Purchase Order – 2]<\/center><\/font>\n\n\n\n

Example for Condition 1: Using Last Purchase Order Price<\/strong><\/p>\n\n\n\n

As shown in Fig. 3<\/strong>, we have created a Purchase Order for the first time with the following details:
\u2022Product: FG<\/strong>-BLOWER-0002
\u2022Supplier:<\/strong> SCP0093
\u2022Gross Price Entered: <\/strong>100<\/p>\n\n\n\n

Since this is the first transaction for this Supplier\u2013Product combination and no price list entry exists, the user has manually entered the price.<\/p>\n\n\n\n

Creating a Subsequent Purchase Order<\/strong><\/p>\n\n\n\n

Now, when we create another Purchase Order using the same Product (FG-BLOWER-0002) <\/strong>and Supplier (SCP0093)<\/strong>, the system will automatically pick the gross price from the last Purchase Order<\/strong>, which is 100<\/strong>, and populate it in the new transaction.<\/p>\n\n\n\n

\"[Fig<\/a><\/center> \n
[Fig 4. Purchase Order – 3]<\/center><\/font>\n\n\n\n

As shown in Fig. 4, for the product FG-BLOWER-0002, the gross price 100 is automatically populated in the Purchase Order.<\/p>\n\n\n\n

This happens because the system identifies that the same Supplier\u2013Product combination was used in a previous Purchase Order, where the price 100 was entered. Since no price list entry exists for this combination, Sage X3 retrieves the price from the last transaction and applies it to the current Purchase Order.<\/p>\n\n\n\n

Condition 2: No Price List and No Previous Purchase Order<\/strong><\/p>\n\n\n\n

In this scenario, when a Supplier\u2013Product combination <\/strong>is neither maintained in the T20 Supplier\/Product Price List <\/strong>nor exists in any previous Purchase Order, the system is unable to derive a price automatically.<\/p>\n\n\n\n

Example:<\/strong><\/p>\n\n\n\n

As shown in Fig. 4<\/strong>, in the second line:
\u2022Product: <\/strong>FG-BLOWER-0003
\u2022This product is not available in the price list<\/strong>.
\u2022There is also no previous Purchase Order<\/strong> for this Supplier\u2013Product combination.<\/p>\n\n\n\n

Therefore, the system does not fetch any price, and we have manually entered the price<\/strong> for this product.<\/p>\n\n\n\n

Overall, this layered pricing approach helps organizations streamline their purchasing process, minimize errors, and maintain better control over procurement costs while still providing the flexibility to handle exceptions when needed.<\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

Managing accurate pricing in purchase transactions is essential for maintaining cost control and consistency. In Sage X3, the Price List functionality allows businesses to automate pricing in Purchase Orders based on predefined conditions. One of the most useful features is the ability to define prices based on a Supplier\u2013Product combination, ensuring that the correct gross\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,13],"tags":[3700,937,4297,1511,1534,1565,2211],"class_list":["post-32180","post","type-post","status-publish","format-standard","hentry","category-sage-erp-x3","category-integration","tag-automatically","tag-gross-price","tag-manually","tag-price-list","tag-product","tag-purchase-order","tag-supplier"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/32180","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=32180"}],"version-history":[{"count":7,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/32180\/revisions"}],"predecessor-version":[{"id":32187,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/32180\/revisions\/32187"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=32180"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=32180"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=32180"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}