{"id":61,"date":"2013-01-04T12:26:00","date_gmt":"2013-01-04T12:26:00","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagemas\/?p=61"},"modified":"2025-04-24T05:48:55","modified_gmt":"2025-04-24T05:48:55","slug":"assign-item-price-based-on-cost-and-quantity-in-sage-100-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2013\/01\/04\/assign-item-price-based-on-cost-and-quantity-in-sage-100-erp\/","title":{"rendered":"Assign Item Price based on Cost and Quantity in Sage 100 ERP"},"content":{"rendered":"\n<div dir=\"ltr\" style=\"text-align: left;\">\n<p><strong>Scenario:<\/strong> Mr X wants to assign Pricing to Items based on cost and quantity of items rather than using just standard and retail pricing for Items in Sales Order. How he can make profit from Item sales, when Item Cost exceeds the Standard Cost of Items?<\/p>\n<p>To handle such scenarios in <a href=\"https:\/\/www.greytrix.com\/product\/erp-development\/sage-100-erp\" target=\"_blank\" rel=\"noopener noreferrer\">Sage 100 ERP<\/a> (earlier known as Sage Mas 90\/200 ERP), they have provided a unique Pricing Code feature, which calculates Item Price based on Cost, Discount and Quantity. Thus, navigate to Sage 100 &gt;&gt;Inventory Management &gt;&gt;Setup &gt;&gt;Price Code Maintenance.<\/p>\n<p><strong>In Price Code Maintenance:<\/strong> Enter a price code representing the Pricing group to add or maintain, or click on Lookup button to list all price codes. Price codes can be assigned to any number of items in Inventory.<\/p>\n<p><strong>Description:<\/strong> Type an appropriate description for the Price code.<\/p>\n<figure><a style=\"margin-left: 1em; margin-right: 1em;\" href=\"https:\/\/2.bp.blogspot.com\/-Jbidy4SNgFA\/UObAyw1ax5I\/AAAAAAAACSo\/T5AP1uPQY5M\/s1600\/1.+Price+Code+Maintenance.JPG\"><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone\" title=\"Price Code maintenance\" src=\"https:\/\/2.bp.blogspot.com\/-Jbidy4SNgFA\/UObAyw1ax5I\/AAAAAAAACSo\/T5AP1uPQY5M\/s640\/1.+Price+Code+Maintenance.JPG\" alt=\"Price Code maintenance\" width=\"640\" height=\"398\" border=\"0\"><\/a><\/figure><div style=\"clear: both; text-align: center;\"><\/div>\n<p><strong>Price Level:<\/strong> If it\u2019s a new entry, default Price level appears. If standard price level information for a price code has already been established, users can create additional price levels. Click on the Lookup button to list all Price levels established for Price code. If users delete the standard price level, all price levels for the Price code are deleted. Users can delete specific non-standard price levels for Price code without deleting entire price code.<\/p>\n<p><strong>Pricing Method:<\/strong> Users need to select method for calculating the item price.<\/p>\n<ul>\n<li>Select Cost Mark-up Amount to add dollar amount to the item\u2019s standard cost.&nbsp;In this case, Price will be calculated as Standard cost of Item + Entered mark-up Amount.<\/li>\n<li>Select Cost Mark-up % to add percentage of the item\u2019s standard cost to the item&#8217;s standard cost.&nbsp;In this case, Price will be calculated as Standard cost of Item + Entered mark-up percentage of the Cost.<\/li>\n<li>Select Price Discount Amount to subtract dollar amount from the item\u2019s standard price. In this case, Price will be calculated as Standard cost of Item &#8211; Entered Discount Amount.<\/li>\n<li>Select Price Discount % to subtract a percentage of the item\u2019s standard price from the item&#8217;s standard price. In this case, Price will be calculated as Standard cost of Item &#8211; Entered Discount Percentage Amount of Cost.<\/li>\n<\/ul>\n<p><strong>To Quantity:<\/strong> Type the maximum quantity for each quantity break, or click Calculator button to enter a quantity using the calculator. Mark up Amount \/ Mark up % \/ Discount Amount \/ Discount %.<\/p>\n<p>If Cost Mark-up Amount or Cost Mark-up % is selected at the Pricing Method field, type the mark-up amount or percent. If Price Discount Amount or Price Discount % is selected at the Pricing Method field, type the price discount amount or percent. Click on Calculator button to enter an amount or percentage.<\/p>\n<p>Now, users have to assigned the above created Pricing code to the Inventory Item; Say to item code \u2018D100\u2019.So by default the item &nbsp;will take pricing as per the assigned pricing code in Sales Order.<\/p>\n<p>Say for an example; we would calculate the Price of an Item by adding margin Percentage amount into Cost of the Item based on entered quantity in the sales order.<\/p>\n<ol>\n<li>In below screenshot, we have assigned the created pricing code to the Inventory Item.<\/li>\n<\/ol>\n<figure><a style=\"margin-left: 1em; margin-right: 1em;\" href=\"https:\/\/3.bp.blogspot.com\/-mlp5uxREqds\/UObAzc7T6zI\/AAAAAAAACSw\/b1Y-8MZNf0s\/s1600\/2.+Item+Maintenance.JPG\"><img decoding=\"async\" class=\"alignnone\" title=\"create pricing code\" src=\"https:\/\/3.bp.blogspot.com\/-mlp5uxREqds\/UObAzc7T6zI\/AAAAAAAACSw\/b1Y-8MZNf0s\/s640\/2.+Item+Maintenance.JPG\" alt=\"create pricing code\" width=\"640\" height=\"364\" border=\"0\"><\/a><\/figure><div style=\"clear: both; text-align: center;\"><\/div>\n<ol start=\"2\">\n<li><span style=\"font-family: Arial, sans-serif; font-size: 11pt; line-height: 115%;\">Now, we will assign it to the same price level in order to follow the pricing info mentioned in Price code Maintenance.<\/span><\/li>\n<\/ol>\n<figure><a style=\"margin-left: 1em; margin-right: 1em;\" href=\"https:\/\/3.bp.blogspot.com\/-HCk5oZgZEN0\/UObAzQhAIqI\/AAAAAAAACSs\/Z6Efp5qM8II\/s1600\/3.+Customer+Maintenance.JPG\"><img decoding=\"async\" class=\"alignnone\" title=\"customer maintenance\" src=\"https:\/\/3.bp.blogspot.com\/-HCk5oZgZEN0\/UObAzQhAIqI\/AAAAAAAACSs\/Z6Efp5qM8II\/s640\/3.+Customer+Maintenance.JPG\" alt=\"customer maintenance\" width=\"640\" height=\"362\" border=\"0\"><\/a><\/figure><div style=\"clear: both; text-align: center;\"><\/div>\n<ol start=\"3\">\n<li><span style=\"font-family: Arial, sans-serif; font-size: 11pt; line-height: 115%;\">Let\u2019s see an impact of above procedure by creating a Sales order with Item for which have assigned the price code and the Customer \u201801-AVNET\u2019 for which we have assigned Price Level \u2018A\u2019.<\/span><\/li>\n<\/ol>\n<figure><a style=\"margin-left: 1em; margin-right: 1em;\" href=\"https:\/\/1.bp.blogspot.com\/-fkhwHMuHz6s\/UObA0R5B60I\/AAAAAAAACS4\/WrPWwk41VaQ\/s1600\/4.+Sales+Order+Entry.JPG\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"sales order entry\" src=\"https:\/\/1.bp.blogspot.com\/-fkhwHMuHz6s\/UObA0R5B60I\/AAAAAAAACS4\/WrPWwk41VaQ\/s640\/4.+Sales+Order+Entry.JPG\" alt=\"sales order entry\" width=\"640\" height=\"386\" border=\"0\"><\/a><\/figure><div style=\"clear: both; text-align: center;\"><\/div>\n<p><i><span lang=\"EN-IN\" style=\"font-family: 'Arial','sans-serif'; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-IN; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;\">As we can see, Standard Cost of the selected Item is $450.00 and we have entered quantity as 10. So the calculation as per the defined criteria in price Code Maintenance is as follows;<\/span><\/i><br><i><span lang=\"EN-IN\" style=\"font-family: 'Arial','sans-serif'; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-IN; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;\"><br><\/span><\/i><i><span lang=\"EN-IN\" style=\"font-family: 'Arial','sans-serif'; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-IN; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;\">Unit Price = Standard Cost + (Standard Cost*50\/100)<\/span><\/i><br><i><span lang=\"EN-IN\" style=\"font-family: 'Arial','sans-serif'; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-IN; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;\">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<\/span><\/i><i><span lang=\"EN-IN\" style=\"font-family: 'Arial','sans-serif'; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-IN; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;\">= 450 + (450*50\/100)<\/span><\/i><br><i><span lang=\"EN-IN\" style=\"font-family: 'Arial','sans-serif'; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-IN; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;\">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<\/span><\/i><i><span lang=\"EN-IN\" style=\"font-family: 'Arial','sans-serif'; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-IN; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;\">= $ 675<\/span><\/i><br><i><span lang=\"EN-IN\" style=\"font-family: 'Arial','sans-serif'; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-IN; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;\"><br><\/span><\/i><i><span lang=\"EN-IN\" style=\"font-family: 'Arial','sans-serif'; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-IN; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;\">As per same method, we can calculate price of Item by other method like as Cost Margin Amount, Discount Percentage and Discount Amount.<\/span><\/i><\/p>\n<p><strong>About Us<\/strong><br><a href=\"https:\/\/www.greytrix.com\/\">Greytrix<\/a>&nbsp;is a one stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.<\/p>\n<p>Greytrix&nbsp;has some unique solutions of&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/sage-crm\/gumu-sage-100-erp-integration\">Sage 100 integration with Sage CRM<\/a>,&nbsp;and&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/sage-100-erp\/gumu-100-salesforce-integration\">Salesforce.com<\/a>&nbsp;along with&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/sage-100-erp\/sage-50-us-sage-100-migration\">Sage 100 Migration from Sage 50 US<\/a>,&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/intacct-apps-and-products\/gumu-sage-intacct-sage-100-migration\">Sage Intacct<\/a>,&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/sage-100-erp\/quickbooks-sage-100-migration\">QuickBooks<\/a>, Sage Business Vision and Sage Business Works. We also offer best-in-class&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/erp-development\/sage-100-erp\">Sage 100 customization and development services&nbsp;<\/a>to Sage business partners, end users, and Sage PSG worldwide.<\/p>\n<p>For more details on Sage 100 Services, please contact us at&nbsp;<a href=\"mailto:sage@greytrix.com\">sage@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Scenario: Mr X wants to assign Pricing to Items based on cost and quantity of items rather than using just standard and retail pricing for Items in Sales Order. How he can make profit from Item sales, when Item Cost exceeds the Standard Cost of Items? To handle such scenarios in Sage 100 ERP (earlier\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2013\/01\/04\/assign-item-price-based-on-cost-and-quantity-in-sage-100-erp\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[101,102,104,151,177,187],"tags":[576,387,399,400],"class_list":["post-61","post","type-post","status-publish","format-standard","hentry","category-item-cost","category-item-discount","category-item-price","category-price-code","category-sage-100-erp","category-sage-mas-90200-erp","tag-pricing-code-feature","tag-sage-100-erp","tag-sage-100-technical-assistance","tag-sage-100-technical-blogs"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>In Sage 100 ERP, set the item price according to quantity and cost.<\/title>\n<meta name=\"description\" content=\"Find out about the Lookup button&#039;s ability to display all price codes. In inventory, any number of things can have price codes applied it.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2013\/01\/04\/assign-item-price-based-on-cost-and-quantity-in-sage-100-erp\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"In Sage 100 ERP, set the item price according to quantity and cost.\" \/>\n<meta property=\"og:description\" content=\"Find out about the Lookup button&#039;s ability to display all price codes. In inventory, any number of things can have price codes applied it.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2013\/01\/04\/assign-item-price-based-on-cost-and-quantity-in-sage-100-erp\/\" \/>\n<meta property=\"og:site_name\" content=\"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2013-01-04T12:26:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-24T05:48:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/2.bp.blogspot.com\/-Jbidy4SNgFA\/UObAyw1ax5I\/AAAAAAAACSo\/T5AP1uPQY5M\/s640\/1.+Price+Code+Maintenance.JPG\" \/>\n<meta name=\"author\" content=\"greysagemas\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagemas\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2013\/01\/04\/assign-item-price-based-on-cost-and-quantity-in-sage-100-erp\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2013\/01\/04\/assign-item-price-based-on-cost-and-quantity-in-sage-100-erp\/\",\"name\":\"In Sage 100 ERP, set the item price according to quantity and cost.\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2013\/01\/04\/assign-item-price-based-on-cost-and-quantity-in-sage-100-erp\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2013\/01\/04\/assign-item-price-based-on-cost-and-quantity-in-sage-100-erp\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/2.bp.blogspot.com\/-Jbidy4SNgFA\/UObAyw1ax5I\/AAAAAAAACSo\/T5AP1uPQY5M\/s640\/1.+Price+Code+Maintenance.JPG\",\"datePublished\":\"2013-01-04T12:26:00+00:00\",\"dateModified\":\"2025-04-24T05:48:55+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728\"},\"description\":\"Find out about the Lookup button's ability to display all price codes. In inventory, any number of things can have price codes applied it.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2013\/01\/04\/assign-item-price-based-on-cost-and-quantity-in-sage-100-erp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2013\/01\/04\/assign-item-price-based-on-cost-and-quantity-in-sage-100-erp\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2013\/01\/04\/assign-item-price-based-on-cost-and-quantity-in-sage-100-erp\/#primaryimage\",\"url\":\"https:\/\/2.bp.blogspot.com\/-Jbidy4SNgFA\/UObAyw1ax5I\/AAAAAAAACSo\/T5AP1uPQY5M\/s640\/1.+Price+Code+Maintenance.JPG\",\"contentUrl\":\"https:\/\/2.bp.blogspot.com\/-Jbidy4SNgFA\/UObAyw1ax5I\/AAAAAAAACSo\/T5AP1uPQY5M\/s640\/1.+Price+Code+Maintenance.JPG\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2013\/01\/04\/assign-item-price-based-on-cost-and-quantity-in-sage-100-erp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Assign Item Price based on Cost and Quantity in Sage 100 ERP\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/\",\"name\":\"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components\",\"description\":\"Welcome to the GUMU\u2122 blog, your one-stop source to gain all the insights on seamless integration solutions for ERP and CRM systems. Developed by Greytrix, GUMU\u2122 is a powerful integration platform that bridges the gap between your business applications. Whether you\u2019re looking to integrate a CRM (Salesforce, Dynamics 365 CRM, and Sage CRM) or an ERP (Sage ERP, Acumatica) with each other or any other third-party application, GUMU\u2122 is a robust and reliable integrator tailored to your unique needs. Join us as we explore the abilities of GUMU\u2122 and learn how it transforms your integration experience. \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728\",\"name\":\"greysagemas\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagemas\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/author\/greysagemas\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"In Sage 100 ERP, set the item price according to quantity and cost.","description":"Find out about the Lookup button's ability to display all price codes. In inventory, any number of things can have price codes applied it.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2013\/01\/04\/assign-item-price-based-on-cost-and-quantity-in-sage-100-erp\/","og_locale":"en_US","og_type":"article","og_title":"In Sage 100 ERP, set the item price according to quantity and cost.","og_description":"Find out about the Lookup button's ability to display all price codes. In inventory, any number of things can have price codes applied it.","og_url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2013\/01\/04\/assign-item-price-based-on-cost-and-quantity-in-sage-100-erp\/","og_site_name":"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","article_published_time":"2013-01-04T12:26:00+00:00","article_modified_time":"2025-04-24T05:48:55+00:00","og_image":[{"url":"https:\/\/2.bp.blogspot.com\/-Jbidy4SNgFA\/UObAyw1ax5I\/AAAAAAAACSo\/T5AP1uPQY5M\/s640\/1.+Price+Code+Maintenance.JPG","type":"","width":"","height":""}],"author":"greysagemas","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagemas","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2013\/01\/04\/assign-item-price-based-on-cost-and-quantity-in-sage-100-erp\/","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2013\/01\/04\/assign-item-price-based-on-cost-and-quantity-in-sage-100-erp\/","name":"In Sage 100 ERP, set the item price according to quantity and cost.","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2013\/01\/04\/assign-item-price-based-on-cost-and-quantity-in-sage-100-erp\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2013\/01\/04\/assign-item-price-based-on-cost-and-quantity-in-sage-100-erp\/#primaryimage"},"thumbnailUrl":"https:\/\/2.bp.blogspot.com\/-Jbidy4SNgFA\/UObAyw1ax5I\/AAAAAAAACSo\/T5AP1uPQY5M\/s640\/1.+Price+Code+Maintenance.JPG","datePublished":"2013-01-04T12:26:00+00:00","dateModified":"2025-04-24T05:48:55+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728"},"description":"Find out about the Lookup button's ability to display all price codes. In inventory, any number of things can have price codes applied it.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2013\/01\/04\/assign-item-price-based-on-cost-and-quantity-in-sage-100-erp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagemas\/2013\/01\/04\/assign-item-price-based-on-cost-and-quantity-in-sage-100-erp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2013\/01\/04\/assign-item-price-based-on-cost-and-quantity-in-sage-100-erp\/#primaryimage","url":"https:\/\/2.bp.blogspot.com\/-Jbidy4SNgFA\/UObAyw1ax5I\/AAAAAAAACSo\/T5AP1uPQY5M\/s640\/1.+Price+Code+Maintenance.JPG","contentUrl":"https:\/\/2.bp.blogspot.com\/-Jbidy4SNgFA\/UObAyw1ax5I\/AAAAAAAACSo\/T5AP1uPQY5M\/s640\/1.+Price+Code+Maintenance.JPG"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2013\/01\/04\/assign-item-price-based-on-cost-and-quantity-in-sage-100-erp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagemas\/"},{"@type":"ListItem","position":2,"name":"Assign Item Price based on Cost and Quantity in Sage 100 ERP"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/","name":"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","description":"Welcome to the GUMU\u2122 blog, your one-stop source to gain all the insights on seamless integration solutions for ERP and CRM systems. Developed by Greytrix, GUMU\u2122 is a powerful integration platform that bridges the gap between your business applications. Whether you\u2019re looking to integrate a CRM (Salesforce, Dynamics 365 CRM, and Sage CRM) or an ERP (Sage ERP, Acumatica) with each other or any other third-party application, GUMU\u2122 is a robust and reliable integrator tailored to your unique needs. Join us as we explore the abilities of GUMU\u2122 and learn how it transforms your integration experience. ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagemas\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728","name":"greysagemas","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagemas"},"url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/author\/greysagemas\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/61","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/comments?post=61"}],"version-history":[{"count":4,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/61\/revisions"}],"predecessor-version":[{"id":6272,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/61\/revisions\/6272"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/media?parent=61"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/categories?post=61"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/tags?post=61"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}