{"id":16049,"date":"2017-06-30T13:41:37","date_gmt":"2017-06-30T13:41:37","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=16049"},"modified":"2024-03-12T04:17:53","modified_gmt":"2024-03-12T04:17:53","slug":"automation-on-po-quantity","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/06\/30\/automation-on-po-quantity\/","title":{"rendered":"Automation on PO Quantity"},"content":{"rendered":"

Recently we had a chance to work on automation on purchase order quantity where our customer was looking for the P\/O Screen to add two columns and a multiplication of both the new column would calculate order quantity. Essentially, they need the purchase order Qty. column to be calculated by two additional columns Length and No. of Sheets. The Length column should be populated by an Optional Field in the item record and the No. of Sheets column will be manual and editable so that user can enter a required value in it.<\/p>\n

New Stuff:\u00a0Migrate Sales Credit Note from Sage Pro to Sage 300 ERP<\/a><\/p>\n

In this blog, we would be discussing about automation of Purchase Order Quantity in detail.<\/p>\n

In order to calculate the purchase order quantity automatically we need to follow the process below.<\/p>\n

1. We have used the Item Master optional fields for storing the characteristic of the Item i.e. Length.<\/p>\n

2. We have applied \u201cLENGTH\u201d optional field to I\/C Item and at the Order Detail so that it gets flowed from Item master to Order details.<\/p>\n

3. We have assigned the \u201cLENGTH\u201d optional field to Item \u201cA1-103\/0\u201d with value 3.30.<\/p>\n

\"IC<\/a><\/p>\n

We need to apply the Length optional field to Purchase Order detail as well, refer the screenshot below.<\/p>\n

\"PO<\/a>
\n<\/a>4. If user selects the item in the purchase order detail line which has optional field \u201cLENGTH\u201d applied in I\/C Item will carry the value of \u201cLENGTH\u201d to the purchase order detail optional field. Refer the screenshot below.<\/p>\n

\"PO<\/a>5. As per the customization request \u201cNo. of Sheets\u201d and the \u201cLength\u201d are the new fields which we have added into the purchase order detail line. The value from the purchase order detail optional field will be automatically copied into the new field i.e. \u201cLength\u201d.<\/p>\n

6. In the purchase order below user inputs 2.00 into no. of sheets and 3.30 is value of Length so 3.30 * 2.00 = 6.6000. The quantity order gets calculated automatically. Refer the screenshot below.<\/p>\n

\"Purchase<\/a><\/p>\n

This customization is available for Sage 300 v2016.<\/p>\n

Also Read:- <\/u><\/strong><\/p>\n

1. \u00a0 Alternate solution to License Issue in Sage 300 ERP<\/a><\/u>
\n2.\u00a0\u00a0\u00a0Significance of using Contract Structures screen in Sage 300 PJC<\/a><\/u>
\n3.\u00a0\u00a0\u00a0Error: \u201cControl is not properly installed\u201d while opening customized screen in Sage 300 ERP<\/a><\/u>
\n4.\u00a0\u00a0\u00a0Confirm On Print Preferences in Sage 300<\/a><\/u>
\n5. \u00a0 New Feature with Sage 300 v2017 Patch 2 for Email Settings on Company Profile<\/a><\/u><\/p>\n

About Us<\/strong><\/p>\n

Greytrix is 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.
\nGreytrix<\/a>\u00a0have some unique solutions of\u00a0Sage 300 integration with Sage CRM,<\/a>\u00a0Salesforce.com\u00a0<\/a>and\u00a0Magento eCommerce<\/a> along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class\u00a0Sage 300 customization and development services<\/a>\u00a0to Sage business partners, end users, and Sage PSG worldwide.
\nFor more details on Sage 300 Services, please contact us at\u00a0accpac@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"

Recently we had a chance to work on automation on purchase order quantity where our customer was looking for the P\/O Screen to add two columns and a multiplication of both the new column would calculate order quantity. Essentially, they need the purchase order Qty. column to be calculated by two additional columns Length and\u2026 Read More »<\/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":[2],"tags":[312,314,1960,2324,2357],"class_list":["post-16049","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-automation","tag-automation-on-po-quantity","tag-po-quantity-automatic","tag-sage-300","tag-sage-300-erp"],"yoast_head":"\nAutomation with Regard to PO Quantity<\/title>\n<meta name=\"description\" content=\"Learn how to automate purchase order quantity, as our customer requested that the P\/O Screen add two columns and then multiply the additional columns to calculate order quantity.\" \/>\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\/sageaccpacerp\/2017\/06\/30\/automation-on-po-quantity\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Automation with Regard to PO Quantity\" \/>\n<meta property=\"og:description\" content=\"Learn how to automate purchase order quantity, as our customer requested that the P\/O Screen add two columns and then multiply the additional columns to calculate order quantity.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/06\/30\/automation-on-po-quantity\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2017-06-30T13:41:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-12T04:17:53+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/06\/PurchaseOrderQtyAutomation_4.jpg\" \/>\n<meta name=\"author\" content=\"sage300\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"sage300\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/06\/30\/automation-on-po-quantity\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/06\/30\/automation-on-po-quantity\/\",\"name\":\"Automation with Regard to PO Quantity\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/06\/30\/automation-on-po-quantity\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/06\/30\/automation-on-po-quantity\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/06\/PurchaseOrderQtyAutomation_4.jpg\",\"datePublished\":\"2017-06-30T13:41:37+00:00\",\"dateModified\":\"2024-03-12T04:17:53+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"description\":\"Learn how to automate purchase order quantity, as our customer requested that the P\/O Screen add two columns and then multiply the additional columns to calculate order quantity.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/06\/30\/automation-on-po-quantity\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/06\/30\/automation-on-po-quantity\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/06\/30\/automation-on-po-quantity\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/06\/PurchaseOrderQtyAutomation_4.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/06\/PurchaseOrderQtyAutomation_4.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/06\/30\/automation-on-po-quantity\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Automation on PO Quantity\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\",\"name\":\"Sage 300 ERP \u2013 Tips, Tricks and Components\",\"description\":\"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?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\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\",\"name\":\"sage300\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/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\":\"sage300\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Automation with Regard to PO Quantity","description":"Learn how to automate purchase order quantity, as our customer requested that the P\/O Screen add two columns and then multiply the additional columns to calculate order quantity.","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\/sageaccpacerp\/2017\/06\/30\/automation-on-po-quantity\/","og_locale":"en_US","og_type":"article","og_title":"Automation with Regard to PO Quantity","og_description":"Learn how to automate purchase order quantity, as our customer requested that the P\/O Screen add two columns and then multiply the additional columns to calculate order quantity.","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/06\/30\/automation-on-po-quantity\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2017-06-30T13:41:37+00:00","article_modified_time":"2024-03-12T04:17:53+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/06\/PurchaseOrderQtyAutomation_4.jpg","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/06\/30\/automation-on-po-quantity\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/06\/30\/automation-on-po-quantity\/","name":"Automation with Regard to PO Quantity","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/06\/30\/automation-on-po-quantity\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/06\/30\/automation-on-po-quantity\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/06\/PurchaseOrderQtyAutomation_4.jpg","datePublished":"2017-06-30T13:41:37+00:00","dateModified":"2024-03-12T04:17:53+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"description":"Learn how to automate purchase order quantity, as our customer requested that the P\/O Screen add two columns and then multiply the additional columns to calculate order quantity.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/06\/30\/automation-on-po-quantity\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/06\/30\/automation-on-po-quantity\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/06\/30\/automation-on-po-quantity\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/06\/PurchaseOrderQtyAutomation_4.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/06\/PurchaseOrderQtyAutomation_4.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/06\/30\/automation-on-po-quantity\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Automation on PO Quantity"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/","name":"Sage 300 ERP \u2013 Tips, Tricks and Components","description":"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?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\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5","name":"sage300","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/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":"sage300"},"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/16049","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/comments?post=16049"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/16049\/revisions"}],"predecessor-version":[{"id":33870,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/16049\/revisions\/33870"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=16049"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=16049"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=16049"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}