{"id":377,"date":"2011-10-13T07:36:44","date_gmt":"2011-10-13T07:36:44","guid":{"rendered":"http:\/\/greytrix.com\/blogs\/sagecrm\/?p=377"},"modified":"2025-04-21T05:15:59","modified_gmt":"2025-04-21T05:15:59","slug":"dropdown-sync-in-sage-crm-system","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/10\/13\/dropdown-sync-in-sage-crm-system\/","title":{"rendered":"Dropdown Sync in Sage CRM System"},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n\n

Everyone must be aware that standard Sage CRM system allows us to integrate with the Sage Accpac system. We have developed many routines for showing data from Sage Accpac in Sage CRM. I would like to explain one of the functionality of Sync Dropdowns using a new field lookup in Accpac.
Let\u2019s say assume you want to sync the Account Set table into CRM and even want use it in Promote to Customer and Promote to Vendor event under Promote to Accpac tab which is at Company level.
1. First of all you need to create a new table say Account Set in Sage CRM and then create fields that you want to sync.
2. One more important thing that you need to is create translation entries as that are done for Customer Groups table.
3. Now, for synching purpose we need to modify the standard pages that are used for synching other tables (Customer Groups, Tax Group, Terms Code etc.).
4. Now our next step is to add a new checkbox option Account Set in the Administration > Sage Accpac Administration > Synchronize Tables option.
5. Lastly, you just need to modify the Synchronize button routine as per Account Set table.
\"\"<\/a>
6. Once synchronization button routine is done and table is synched in Sage CRM then we can easily show the Account Set option in the Promote to Customer\/ Promote to Vendor event.
\"\"<\/a>
7. All you need to do is modify the existing CRM pages and make it compatible with our requirement.
We have developed dropdown sync routine for Segment Codes, ICITEM, Account Set, Ship Via, Ship to Location, UOM and FOB Point tables of Sage Accpac. If you need something that is not listed here then you can drop me an email regarding the same.
If you find this content useful, please drop us an email at crm@greytrix.com<\/a>. <\/b><\/p>\n","protected":false},"excerpt":{"rendered":"

Everyone must be aware that standard Sage CRM system allows us to integrate with the Sage Accpac system. We have developed many routines for showing data from Sage Accpac in Sage CRM. I would like to explain one of the functionality of Sync Dropdowns using a new field lookup in Accpac.Let\u2019s say assume you want\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":[332],"tags":[1017,2003,2010,2373],"class_list":["post-377","post","type-post","status-publish","format-standard","hentry","category-sage-crm","tag-dropdowns","tag-sage-accpac","tag-sage-crm","tag-sync"],"yoast_head":"\nDropdown Sync in Sage CRM System - 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\/2011\/10\/13\/dropdown-sync-in-sage-crm-system\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Dropdown Sync in Sage CRM System - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Everyone must be aware that standard Sage CRM system allows us to integrate with the Sage Accpac system. We have developed many routines for showing data from Sage Accpac in Sage CRM. I would like to explain one of the functionality of Sync Dropdowns using a new field lookup in Accpac.Let\u2019s say assume you want\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/10\/13\/dropdown-sync-in-sage-crm-system\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2011-10-13T07:36:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-21T05:15:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2025\/04\/01.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\/2011\/10\/13\/dropdown-sync-in-sage-crm-system\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/10\/13\/dropdown-sync-in-sage-crm-system\/\",\"name\":\"Dropdown Sync in Sage CRM System - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/10\/13\/dropdown-sync-in-sage-crm-system\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/10\/13\/dropdown-sync-in-sage-crm-system\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2025\/04\/01.jpg\",\"datePublished\":\"2011-10-13T07:36:44+00:00\",\"dateModified\":\"2025-04-21T05:15:59+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/10\/13\/dropdown-sync-in-sage-crm-system\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/10\/13\/dropdown-sync-in-sage-crm-system\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/10\/13\/dropdown-sync-in-sage-crm-system\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2025\/04\/01.jpg\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2025\/04\/01.jpg\",\"width\":711,\"height\":147},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/10\/13\/dropdown-sync-in-sage-crm-system\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Dropdown Sync in Sage CRM System\"}]},{\"@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":"Dropdown Sync in Sage CRM System - 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\/2011\/10\/13\/dropdown-sync-in-sage-crm-system\/","og_locale":"en_US","og_type":"article","og_title":"Dropdown Sync in Sage CRM System - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Everyone must be aware that standard Sage CRM system allows us to integrate with the Sage Accpac system. We have developed many routines for showing data from Sage Accpac in Sage CRM. I would like to explain one of the functionality of Sync Dropdowns using a new field lookup in Accpac.Let\u2019s say assume you want\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/10\/13\/dropdown-sync-in-sage-crm-system\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2011-10-13T07:36:44+00:00","article_modified_time":"2025-04-21T05:15:59+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2025\/04\/01.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\/2011\/10\/13\/dropdown-sync-in-sage-crm-system\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/10\/13\/dropdown-sync-in-sage-crm-system\/","name":"Dropdown Sync in Sage CRM System - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/10\/13\/dropdown-sync-in-sage-crm-system\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/10\/13\/dropdown-sync-in-sage-crm-system\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2025\/04\/01.jpg","datePublished":"2011-10-13T07:36:44+00:00","dateModified":"2025-04-21T05:15:59+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/10\/13\/dropdown-sync-in-sage-crm-system\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/10\/13\/dropdown-sync-in-sage-crm-system\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/10\/13\/dropdown-sync-in-sage-crm-system\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2025\/04\/01.jpg","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2025\/04\/01.jpg","width":711,"height":147},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/10\/13\/dropdown-sync-in-sage-crm-system\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Dropdown Sync in Sage CRM System"}]},{"@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\/377","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=377"}],"version-history":[{"count":4,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/377\/revisions"}],"predecessor-version":[{"id":29229,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/377\/revisions\/29229"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=377"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=377"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=377"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}