{"id":15845,"date":"2017-05-25T10:16:28","date_gmt":"2017-05-25T10:16:28","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=15845"},"modified":"2017-05-25T10:16:28","modified_gmt":"2017-05-25T10:16:28","slug":"automation-on-oe-order-quantity","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/05\/25\/automation-on-oe-order-quantity\/","title":{"rendered":"Automation on OE Order Quantity"},"content":{"rendered":"

Recently we had a chance to work on automation on order quantity where our customer was looking for the O\/E Screen to add two columns and a multiplication of both the new column would be a calculate order quantity. Essentially, they need the Qty Ordered 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:\u00a0Adding custom button in Accpac View List<\/a><\/p>\n

In this blog, we would be discussing about same automation of OE Order Quantity in detail.
\nIn order to calculate the quantity order 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>4. If user selects the item in the order detail line which has optional field \u201cLENGTH\u201d applied in I\/C Item will carry the value of \u201cLENGTH\u201d to the order detail optional field. Refer the screenshot below.<\/p>\n

\"IC<\/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 order detail line. The value from the order detail optional field will be automatically copied into the new field i.e. \u201cLength\u201d.\\<\/p>\n

6. In the 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

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

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

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

    \n
  1. Printing Sales Report Country Wise<\/a><\/li>\n
  2. New Features in Order Entry Payment Screen<\/a><\/li>\n
  3. Sage 300 PJC \u2013 Posting Date Option<\/a><\/li>\n
  4. How to remove payroll check lock if previous process is incomplete<\/a><\/li>\n
  5. Optional field Validation on Order Entry Screen<\/a><\/li>\n<\/ol>\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.
    \n    Greytrix<\/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.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Recently we had a chance to work on automation on order quantity where our customer was looking for the O\/E Screen to add two columns and a multiplication of both the new column would be a calculate order quantity. Essentially, they need the Qty Ordered 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":[311,313,2138,2357],"class_list":["post-15845","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-automatic-quantity","tag-automation-on-oe-order-quantity","tag-quantity-order-calculate-automatically","tag-sage-300-erp"],"yoast_head":"\nAutomation on OE Order Quantity - Sage 300 ERP \u2013 Tips, Tricks and Components<\/title>\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\/05\/25\/automation-on-oe-order-quantity\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Automation on OE Order Quantity - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Recently we had a chance to work on automation on order quantity where our customer was looking for the O\/E Screen to add two columns and a multiplication of both the new column would be a calculate order quantity. Essentially, they need the Qty Ordered column to be calculated by two additional columns Length and\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/05\/25\/automation-on-oe-order-quantity\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2017-05-25T10:16:28+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/05\/OrderQtyAutomation_5.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=\"2 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\/05\/25\/automation-on-oe-order-quantity\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/05\/25\/automation-on-oe-order-quantity\/\",\"name\":\"Automation on OE Order Quantity - Sage 300 ERP \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/05\/25\/automation-on-oe-order-quantity\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/05\/25\/automation-on-oe-order-quantity\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/05\/OrderQtyAutomation_5.jpg\",\"datePublished\":\"2017-05-25T10:16:28+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/05\/25\/automation-on-oe-order-quantity\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/05\/25\/automation-on-oe-order-quantity\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/05\/25\/automation-on-oe-order-quantity\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/05\/OrderQtyAutomation_5.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/05\/OrderQtyAutomation_5.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/05\/25\/automation-on-oe-order-quantity\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Automation on OE Order 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 on OE Order Quantity - Sage 300 ERP \u2013 Tips, Tricks and Components","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\/05\/25\/automation-on-oe-order-quantity\/","og_locale":"en_US","og_type":"article","og_title":"Automation on OE Order Quantity - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"Recently we had a chance to work on automation on order quantity where our customer was looking for the O\/E Screen to add two columns and a multiplication of both the new column would be a calculate order quantity. Essentially, they need the Qty Ordered column to be calculated by two additional columns Length and\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/05\/25\/automation-on-oe-order-quantity\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2017-05-25T10:16:28+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/05\/OrderQtyAutomation_5.jpg","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/05\/25\/automation-on-oe-order-quantity\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/05\/25\/automation-on-oe-order-quantity\/","name":"Automation on OE Order Quantity - Sage 300 ERP \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/05\/25\/automation-on-oe-order-quantity\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/05\/25\/automation-on-oe-order-quantity\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/05\/OrderQtyAutomation_5.jpg","datePublished":"2017-05-25T10:16:28+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/05\/25\/automation-on-oe-order-quantity\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/05\/25\/automation-on-oe-order-quantity\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/05\/25\/automation-on-oe-order-quantity\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/05\/OrderQtyAutomation_5.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/05\/OrderQtyAutomation_5.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/05\/25\/automation-on-oe-order-quantity\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Automation on OE Order 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\/15845","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=15845"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/15845\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=15845"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=15845"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=15845"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}