{"id":11796,"date":"2016-01-21T13:10:41","date_gmt":"2016-01-21T13:10:41","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=11796"},"modified":"2023-10-04T07:27:37","modified_gmt":"2023-10-04T07:27:37","slug":"implementing-real-time-product-functionality","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/21\/implementing-real-time-product-functionality\/","title":{"rendered":"Implementing Real time Product functionality"},"content":{"rendered":"

In our GUMU for Sage CRM \u2013 Sage 100 integration product, user can creates orders\/Invoices using Sage 100 inventory items in sage CRM and later they can promote the same from sage CRM to Sage 100. For creating Orders\/Invoices user can import the Item from Sage 100 using Import Product process<\/a>. We do have another feature where items can be created\/updated on real time<\/a> basis from Sage 100 to Sage CRM.<\/p>\n

New Stuff: <\/em><\/strong><\/span>Map single Sage CRM User with multiple Sage 100 Salespersons<\/a><\/p>\n

Once the integration is configured, user can access the import product feature but for implementing the real time changes user will have to manually follow some steps. In this blog, we would like to walkthrough with the steps for implementing the Real time Product import changes. Before we proceed with the implementing the changes, Please make sure that you have proper backups of Sage 100 system.<\/p>\n

1. Once done with back up, login to Sage 100 Application. Go to the Custom office > Main>User-Defined Field and Table Maintenance.<\/p>\n

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

2. Click on the \u201cUser-Defined Field and Table Maintenance\u201d it will open a window as shown below.<\/p>\n

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

3. Select the Common Information folder which will open the list of sub folders.<\/p>\n

4. Select the CI Item Master and then click on the user Defined Script button as shown in the below.<\/p>\n

5. It will open the screen \u201cUser Defined Script\u201d as shown below and then click on the add button.<\/p>\n

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

6. It will open Add Script screen. Select the Table- Post-Write from the Event dropdown and then click the Create\/edit script button as shown below.<\/p>\n

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

7. Once you click the Create\/Edit Script button, it will open a window. Fill the Script Id as \u201cUpdate Product\u201d and then click tab button of Keyboard.
\n8. In the Script section you will need to copy the script from the UpdateProduct.txt file located in GUMU installation directory inside the script folder on Sage CRM server. Copy all the content present in the UpdateProduct.txt to the script section.
\n\"skp5\"<\/a>
\n9. Once you have copied the script click on the Check Script button present in the right side you will get the \u201cscript passed\u201d message. Then click on the save button and then accept button.
\n10. It will navigate back to the user-Defined script screen. Click ok and then close all the windows. Once you have closed all the windows, finally it will open the script Compile screen. Click on the compile button and then close.
\n\"skp6\"<\/a>
\nThis will allow creation of Product from Sage 100 to Sage CRM on real time basis.
\nAlso Read:<\/em><\/strong><\/span>
\n1. GUMU\u2122 Module installation for Sage 100 Premium version<\/a>
\n2. GUMU\u2122 for Sage CRM \u2013 Sage 100 integration with AvaTax \u2013 II<\/a>
\n3. GUMU\u2122 for Sage CRM \u2013 Sage 100 integration with AvaTax \u2013 III<\/a>
\n4. Promote order from Sage CRM to Sage 100 using comment line item<\/a>
\n5. GUMU\u2122 Sage CRM \u2013 Sage 100 Integration \u2013 New Features<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

In our GUMU for Sage CRM \u2013 Sage 100 integration product, user can creates orders\/Invoices using Sage 100 inventory items in sage CRM and later they can promote the same from sage CRM to Sage 100. For creating Orders\/Invoices user can import the Item from Sage 100 using Import Product process. We do have another\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[1286,1409,1435,1818,1872],"class_list":["post-11796","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-gumumas","tag-importing-products","tag-integration","tag-product-import","tag-real-time"],"yoast_head":"\nImplementing Real time Product functionality - Sage CRM \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\/sagecrm\/2016\/01\/21\/implementing-real-time-product-functionality\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Implementing Real time Product functionality - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"In our GUMU for Sage CRM \u2013 Sage 100 integration product, user can creates orders\/Invoices using Sage 100 inventory items in sage CRM and later they can promote the same from sage CRM to Sage 100. For creating Orders\/Invoices user can import the Item from Sage 100 using Import Product process. We do have another\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/21\/implementing-real-time-product-functionality\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2016-01-21T13:10:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-04T07:27:37+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/01\/skp1.jpg\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\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\/sagecrm\/2016\/01\/21\/implementing-real-time-product-functionality\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/21\/implementing-real-time-product-functionality\/\",\"name\":\"Implementing Real time Product functionality - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/21\/implementing-real-time-product-functionality\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/21\/implementing-real-time-product-functionality\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/01\/skp1.jpg\",\"datePublished\":\"2016-01-21T13:10:41+00:00\",\"dateModified\":\"2023-10-04T07:27:37+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/21\/implementing-real-time-product-functionality\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/21\/implementing-real-time-product-functionality\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/21\/implementing-real-time-product-functionality\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/01\/skp1.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/01\/skp1.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/21\/implementing-real-time-product-functionality\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Implementing Real time Product functionality\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?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\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/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\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Implementing Real time Product functionality - Sage CRM \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\/sagecrm\/2016\/01\/21\/implementing-real-time-product-functionality\/","og_locale":"en_US","og_type":"article","og_title":"Implementing Real time Product functionality - Sage CRM \u2013 Tips, Tricks and Components","og_description":"In our GUMU for Sage CRM \u2013 Sage 100 integration product, user can creates orders\/Invoices using Sage 100 inventory items in sage CRM and later they can promote the same from sage CRM to Sage 100. For creating Orders\/Invoices user can import the Item from Sage 100 using Import Product process. We do have another\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/21\/implementing-real-time-product-functionality\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2016-01-21T13:10:41+00:00","article_modified_time":"2023-10-04T07:27:37+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/01\/skp1.jpg","type":"","width":"","height":""}],"author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/21\/implementing-real-time-product-functionality\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/21\/implementing-real-time-product-functionality\/","name":"Implementing Real time Product functionality - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/21\/implementing-real-time-product-functionality\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/21\/implementing-real-time-product-functionality\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/01\/skp1.jpg","datePublished":"2016-01-21T13:10:41+00:00","dateModified":"2023-10-04T07:27:37+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/21\/implementing-real-time-product-functionality\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/21\/implementing-real-time-product-functionality\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/21\/implementing-real-time-product-functionality\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/01\/skp1.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/01\/skp1.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/21\/implementing-real-time-product-functionality\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Implementing Real time Product functionality"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?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\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/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":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/11796","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=11796"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/11796\/revisions"}],"predecessor-version":[{"id":27822,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/11796\/revisions\/27822"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=11796"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=11796"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=11796"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}