{"id":10063,"date":"2015-02-12T11:43:50","date_gmt":"2015-02-12T11:43:50","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=10063"},"modified":"2019-11-12T09:05:20","modified_gmt":"2019-11-12T09:05:20","slug":"migrate-banks-from-sage-businessworks-to-sage-300-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/02\/12\/migrate-banks-from-sage-businessworks-to-sage-300-erp\/","title":{"rendered":"Migrate Banks from Sage BusinessWorks to Sage 300 ERP"},"content":{"rendered":"

Our GUMU™ utility is a Sage certified migration tool which helps in smooth data migration of various source ERPs to target ERP systems. Today, we are going to discuss a very important data migration option \u2013 Bank.<\/p>\n

When converting Bank data from Sage BusinessWorks to Sage 300 ERP, we ensure that all the details which are there in the Sage BusinessWorks are covered. Now, let\u2019s have a quick look at the Sage BusinessWorks Bank screen.<\/p>\n

New Stuff: <\/em><\/strong>Migrate Salesperson from Sage PRO ERP To Sage 300 ERP<\/a><\/p>\n

You can view Banks in Sage Business Works from the following path \u2013
\nSage Business Works –> Cash Management \u00e0Accounts –> Maintain Cash Accounts
\n\"BN\"<\/a>As you can see in the above screenshot, there are near about 8 banks in Sage Business Works.
\nYou can view Bank Balance in Sage Business Works from the following path \u2013
\nSage Business Works –> General Ledger–> Accounts –> Maintain Chart of Accounts
\n\"BN2\"<\/a>In the above screenshot, you can see the monthly balance of SDFCU-Checking Bank with GL Account Number 1016 and balance 187595.25<\/p>\n

In Sage 300 ERP the Banks are converted as follows:
\nBelow is a screenshot of the converted Sage 300 ERP Bank with Bank Code SDF1.
\nSage 300 ERP –> Common Services –>  Bank Services –> Banks<\/em>
\n\"BN3\"<\/a>Check the highlighted Bank Account, Write-Off Account, and Credit Card Charges Account of the same bank in below screenshot.
\n\"BN4\"<\/a>You might have seen that the BusinessWorks report screen shows some amount in bank balance field but in Sage 300 ERP window screen bank balances are null. This is due to the migrated bank Transaction entries of open balance amounts that are not yet posted. So we need to post the same so that it is updated in Sage 300 bank balances.<\/p>\n

Navigate to Common services –> Bank services –> Bank transactions –> Bank Entry. Select bank transaction entry and click on post button.
\n\"BN5\"<\/a>After posting transactions navigate to common services –> Bank services –> Banks and check the bank balance.
\n\"BN6\"<\/a>After data migration from Sage BusinessWorks the field values of Sage BusinessWorks Banks get converted with the following mapping:
\n\"BN7\"<\/a>In this way, Sage BusinessWorks Banks and their balances are migrated into target Sage 300 ERP company database. For more information on ERP data migration, drop us a mail at erpmig@greytrix.com<\/a><\/p>\n

About 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 Sage 300 with Sage CRM,<\/a> Salesforce.com <\/a>and Magento 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 Sage 300 customization and development services<\/a> and 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  to 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 accpac@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"

Our GUMU™ utility is a Sage certified migration tool which helps in smooth data migration of various source ERPs to target ERP systems. Today, we are going to discuss a very important data migration option \u2013 Bank. When converting Bank data from Sage BusinessWorks to Sage 300 ERP, we ensure that all the details which are\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":[2],"tags":[349,409,888,1166,2445],"class_list":["post-10063","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-banks","tag-business-works","tag-erpmig","tag-gumu","tag-sage-accpac"],"yoast_head":"\nMigrate Banks from Sage BusinessWorks to Sage 300 ERP - 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\/2015\/02\/12\/migrate-banks-from-sage-businessworks-to-sage-300-erp\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Migrate Banks from Sage BusinessWorks to Sage 300 ERP - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Our GUMU™ utility is a Sage certified migration tool which helps in smooth data migration of various source ERPs to target ERP systems. Today, we are going to discuss a very important data migration option \u2013 Bank. When converting Bank data from Sage BusinessWorks to Sage 300 ERP, we ensure that all the details which are\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/02\/12\/migrate-banks-from-sage-businessworks-to-sage-300-erp\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2015-02-12T11:43:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-11-12T09:05:20+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/02\/BN.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=\"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\/2015\/02\/12\/migrate-banks-from-sage-businessworks-to-sage-300-erp\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/02\/12\/migrate-banks-from-sage-businessworks-to-sage-300-erp\/\",\"name\":\"Migrate Banks from Sage BusinessWorks to Sage 300 ERP - 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\/2015\/02\/12\/migrate-banks-from-sage-businessworks-to-sage-300-erp\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/02\/12\/migrate-banks-from-sage-businessworks-to-sage-300-erp\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/02\/BN.jpg\",\"datePublished\":\"2015-02-12T11:43:50+00:00\",\"dateModified\":\"2019-11-12T09:05:20+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/02\/12\/migrate-banks-from-sage-businessworks-to-sage-300-erp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/02\/12\/migrate-banks-from-sage-businessworks-to-sage-300-erp\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/02\/12\/migrate-banks-from-sage-businessworks-to-sage-300-erp\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/02\/BN.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/02\/BN.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/02\/12\/migrate-banks-from-sage-businessworks-to-sage-300-erp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Migrate Banks from Sage BusinessWorks to Sage 300 ERP\"}]},{\"@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":"Migrate Banks from Sage BusinessWorks to Sage 300 ERP - 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\/2015\/02\/12\/migrate-banks-from-sage-businessworks-to-sage-300-erp\/","og_locale":"en_US","og_type":"article","og_title":"Migrate Banks from Sage BusinessWorks to Sage 300 ERP - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"Our GUMU™ utility is a Sage certified migration tool which helps in smooth data migration of various source ERPs to target ERP systems. Today, we are going to discuss a very important data migration option \u2013 Bank. When converting Bank data from Sage BusinessWorks to Sage 300 ERP, we ensure that all the details which are\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/02\/12\/migrate-banks-from-sage-businessworks-to-sage-300-erp\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2015-02-12T11:43:50+00:00","article_modified_time":"2019-11-12T09:05:20+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/02\/BN.jpg","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\/2015\/02\/12\/migrate-banks-from-sage-businessworks-to-sage-300-erp\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/02\/12\/migrate-banks-from-sage-businessworks-to-sage-300-erp\/","name":"Migrate Banks from Sage BusinessWorks to Sage 300 ERP - 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\/2015\/02\/12\/migrate-banks-from-sage-businessworks-to-sage-300-erp\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/02\/12\/migrate-banks-from-sage-businessworks-to-sage-300-erp\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/02\/BN.jpg","datePublished":"2015-02-12T11:43:50+00:00","dateModified":"2019-11-12T09:05:20+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/02\/12\/migrate-banks-from-sage-businessworks-to-sage-300-erp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/02\/12\/migrate-banks-from-sage-businessworks-to-sage-300-erp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/02\/12\/migrate-banks-from-sage-businessworks-to-sage-300-erp\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/02\/BN.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/02\/BN.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/02\/12\/migrate-banks-from-sage-businessworks-to-sage-300-erp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Migrate Banks from Sage BusinessWorks to Sage 300 ERP"}]},{"@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\/10063","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=10063"}],"version-history":[{"count":2,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/10063\/revisions"}],"predecessor-version":[{"id":27346,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/10063\/revisions\/27346"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=10063"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=10063"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=10063"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}