{"id":17572,"date":"2018-01-16T04:48:48","date_gmt":"2018-01-16T04:48:48","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=17572"},"modified":"2024-03-26T05:39:37","modified_gmt":"2024-03-26T05:39:37","slug":"automated-process-create-optional-field-from-macro-to-sage-300","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/16\/automated-process-create-optional-field-from-macro-to-sage-300\/","title":{"rendered":"AUTOMATED PROCESS TO CREATE OPTIONAL FIELD FROM MACRO IN SAGE 300"},"content":{"rendered":"

There are many benefit\/advantage in implementing Enterprise Resource Planning (ERP) software namely productivity, increase in efficiency costing and automating business processes. \u00a0However, businesses vary and many times client requirements will be complicated So, Today in the blog we will discuss how we can store huge information at the time of creating Entries?<\/p>\n

With the help of creating optional field user can store that information. However, instead of doing this process manually, we have developed Macros for creating multiple optional fields at a time so that user can put optional field name in the same code and with the execution of code, System will automatically create Optional field into Common services in SAGE 300<\/a>.<\/p>\n

New Stuff<\/em>:<\/strong>\u00a0User-defined options to migrate vendor masters into Sage 300 ERP<\/a><\/p>\n

Here is process to create Optional field:-<\/strong>
\nLet’s take an example to create Optional field REMARKS1, REMARKS2, REMARKS3\u2026\u2026\u2026\u2026\u2026\u2026.. REMARKS50
\n\"\"<\/a>As per above screenshot and example, we have put optional field name next to value field that is highlighted in red border and Optional field description which is highlighted in Sky blue border. As per user command, we need to create Optional field until REMARKS50 so we will execute Loop until the value of 50 that is highlighted in Orange color.<\/p>\n

For more clarification and understanding, we have shared a screenshot of the created Optional field in SAGE 300.
\n\"\"<\/a>
\nAbout Us<\/strong><\/span>
\nGreytrix<\/a> a globally recognized Premier Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring 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

Greytrix<\/a> offers unique GUMU™ integrated solutions of\u00a0Sage 300 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<\/a>. We also offer best-in-class\u00a0Sage 300 customization and development services<\/a>\u00a0and integration service for applications such as POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP<\/a> and in Sage 300c development services we offer services such as upgrades of older codes and screens to new web screens, newer integrations using sdata and web services \u00a0to Sage business partners, end users and Sage PSG worldwide. Greytrix offers over 20+ Sage 300 productivity-enhancing utilities that we can help you with such as GreyMatrix<\/a>, Document Attachment<\/a>, Document Numbering<\/a>, Auto-Bank Reconciliation<\/a>, Purchase Approval System<\/a>, Three way PO matching<\/a>, Bill of Lading<\/a> and VAT for Middle East<\/a>.<\/p>\n

For more details on Sage 300 and 300c Services, please contact us at\u00a0accpac@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"

There are many benefit\/advantage in implementing Enterprise Resource Planning (ERP) software namely productivity, increase in efficiency costing and automating business processes. \u00a0However, businesses vary and many times client requirements will be complicated So, Today in the blog we will discuss how we can store huge information at the time of creating Entries? With the help\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":[305,497,570,593,1510,1803],"class_list":["post-17572","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-automate","tag-common-services","tag-create","tag-creation-of-optional-field","tag-macro","tag-optional-field"],"yoast_head":"\nAUTOMATED PROCESS FOR CREATING OPTIONAL FIELD FROM MACRO IN SAGE 300<\/title>\n<meta name=\"description\" content=\"Implementing enterprise resource planning (ERP) software has several advantages, including increased productivity, cost savings, and process automation.\" \/>\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\/2018\/01\/16\/automated-process-create-optional-field-from-macro-to-sage-300\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"AUTOMATED PROCESS FOR CREATING OPTIONAL FIELD FROM MACRO IN SAGE 300\" \/>\n<meta property=\"og:description\" content=\"Implementing enterprise resource planning (ERP) software has several advantages, including increased productivity, cost savings, and process automation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/16\/automated-process-create-optional-field-from-macro-to-sage-300\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2018-01-16T04:48:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-26T05:39:37+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/01\/1-4.png\" \/>\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=\"3 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\/2018\/01\/16\/automated-process-create-optional-field-from-macro-to-sage-300\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/16\/automated-process-create-optional-field-from-macro-to-sage-300\/\",\"name\":\"AUTOMATED PROCESS FOR CREATING OPTIONAL FIELD FROM MACRO IN SAGE 300\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/16\/automated-process-create-optional-field-from-macro-to-sage-300\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/16\/automated-process-create-optional-field-from-macro-to-sage-300\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/01\/1-4.png\",\"datePublished\":\"2018-01-16T04:48:48+00:00\",\"dateModified\":\"2024-03-26T05:39:37+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"description\":\"Implementing enterprise resource planning (ERP) software has several advantages, including increased productivity, cost savings, and process automation.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/16\/automated-process-create-optional-field-from-macro-to-sage-300\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/16\/automated-process-create-optional-field-from-macro-to-sage-300\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/16\/automated-process-create-optional-field-from-macro-to-sage-300\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/01\/1-4.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/01\/1-4.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/16\/automated-process-create-optional-field-from-macro-to-sage-300\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"AUTOMATED PROCESS TO CREATE OPTIONAL FIELD FROM MACRO IN SAGE 300\"}]},{\"@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":"AUTOMATED PROCESS FOR CREATING OPTIONAL FIELD FROM MACRO IN SAGE 300","description":"Implementing enterprise resource planning (ERP) software has several advantages, including increased productivity, cost savings, and process automation.","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\/2018\/01\/16\/automated-process-create-optional-field-from-macro-to-sage-300\/","og_locale":"en_US","og_type":"article","og_title":"AUTOMATED PROCESS FOR CREATING OPTIONAL FIELD FROM MACRO IN SAGE 300","og_description":"Implementing enterprise resource planning (ERP) software has several advantages, including increased productivity, cost savings, and process automation.","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/16\/automated-process-create-optional-field-from-macro-to-sage-300\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2018-01-16T04:48:48+00:00","article_modified_time":"2024-03-26T05:39:37+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/01\/1-4.png","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/16\/automated-process-create-optional-field-from-macro-to-sage-300\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/16\/automated-process-create-optional-field-from-macro-to-sage-300\/","name":"AUTOMATED PROCESS FOR CREATING OPTIONAL FIELD FROM MACRO IN SAGE 300","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/16\/automated-process-create-optional-field-from-macro-to-sage-300\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/16\/automated-process-create-optional-field-from-macro-to-sage-300\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/01\/1-4.png","datePublished":"2018-01-16T04:48:48+00:00","dateModified":"2024-03-26T05:39:37+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"description":"Implementing enterprise resource planning (ERP) software has several advantages, including increased productivity, cost savings, and process automation.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/16\/automated-process-create-optional-field-from-macro-to-sage-300\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/16\/automated-process-create-optional-field-from-macro-to-sage-300\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/16\/automated-process-create-optional-field-from-macro-to-sage-300\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/01\/1-4.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/01\/1-4.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/16\/automated-process-create-optional-field-from-macro-to-sage-300\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"AUTOMATED PROCESS TO CREATE OPTIONAL FIELD FROM MACRO IN SAGE 300"}]},{"@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\/17572","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=17572"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/17572\/revisions"}],"predecessor-version":[{"id":24237,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/17572\/revisions\/24237"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=17572"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=17572"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=17572"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}