{"id":10507,"date":"2015-03-24T12:07:18","date_gmt":"2015-03-24T12:07:18","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=10507"},"modified":"2015-03-24T12:07:18","modified_gmt":"2015-03-24T12:07:18","slug":"error-while-migrating-data-from-lower-version-to-higher-version","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/03\/24\/error-while-migrating-data-from-lower-version-to-higher-version\/","title":{"rendered":"Error while migrating data from lower version to higher version"},"content":{"rendered":"<p>Sage 300 ERP helps organizations to maintain their operational and financial data. As time progresses, the ERP gets better and better with new features added in it. So Sage releases new versions of Sage 300 ERP with the new features and new look. Currently Sage is providing \u201cSage 300 ERP 2014 version\u201d.<br \/>\nSo to make the database compatible with the versions, consultants or users have to upgrade their data to the next higher version. Many times the user or consultant get stuck in the error <strong>\u201cIncorrect procedure. You must post or delete all open batches before activating Accounts Payable<\/strong>\u201d while migrating the database from lower version to the higher one. Please refer the below screen shot.<br \/>\n<span style=\"color: #800000\"><em><strong>New Stuff:\u00a0<\/strong><\/em><\/span><a title=\"AP Invoice Report\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/03\/24\/ap-invoice-report\/\" target=\"_blank\">AP Invoice Report<\/a><br \/>\n<a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/03\/1.png\" target=\"_blank\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter wp-image-10508\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/03\/1.png\" alt=\"1\" width=\"670\" height=\"522\" \/><\/a><br \/>\nThe above error occurs because there are some batches which are not posted from AP, AR, GL modules. Following are the detailed steps to overcome such errors.<br \/>\n\u2981 Navigate to Accounts Payable AP Transactions.<br \/>\n\u2981 Open AP Invoice Batch list and uncheck the \u201c<strong>Show posted and deleted Batches<\/strong>\u201d so Batch list will \u00a0 \u00a0 show all the open batches from the AP invoice. Please refer the below screen shot.<br \/>\n<a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/03\/2.png\" target=\"_blank\"><img decoding=\"async\" class=\"aligncenter wp-image-10509 size-full\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/03\/2.png\" alt=\"2\" width=\"689\" height=\"399\" \/><\/a><br \/>\n\u2981 User has to post all the open batches with an amount greater than zero and need to delete all the \u00a0 \u00a0 \u00a0 \u00a0 batches with amount zero (highlighted in screen shot).<br \/>\n\u2981 And also, the user will need to do the reconciliation of these entries from the Bank module.<br \/>\n\u2981 Similarly if error came for Account receivable then user needs to follow the same process.<br \/>\nIn this way consultant or user can overcome this error by following the above steps.<br \/>\n<span style=\"color: #800000\"><em><strong>Also Read:<\/strong><\/em><\/span><br \/>\n1.<a title=\"Warn for Non Inventory Item Option in PO in Sage 300 ERP\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/02\/27\/warn-for-non-inventory-item-option-in-po-in-sage-300-erp\/\" target=\"_blank\">Warn for Non Inventory Item Option in PO in Sage 300 ERP<\/a><br \/>\n2.<a title=\"I\/C Update Item Pricing for Sage 300 ERP\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/02\/27\/ic-update-item-pricing-for-sage-300-erp\/\" target=\"_blank\">I\/C Update Item Pricing for Sage 300 ERP<\/a><br \/>\n3.<a title=\"Creating Purchase Work Flow Requisition using PO Requisition in SAGE 300 ERP\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/02\/24\/creating-purchase-work-flow-requisition-using-po-requisition-in-sage-300-erp\/\" target=\"_blank\">Creating Purchase Work Flow Requisition using PO Requisition in SAGE 300 ERP<\/a><br \/>\n4.<a title=\"Remit-To Locations in Sage 300 ERP\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/02\/24\/remit-to-locations-in-sage-300-erp\/\" target=\"_blank\">Remit-To Locations in Sage 300 ERP<\/a><br \/>\n5.<a title=\"Allow Edited After Invoices Printed\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/02\/24\/allow-edited-after-invoices-printed\/\" target=\"_blank\">Allow Edited After Invoices Printed<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sage 300 ERP helps organizations to maintain their operational and financial data. As time progresses, the ERP gets better and better with new features added in it. So Sage releases new versions of Sage 300 ERP with the new features and new look. Currently Sage is providing \u201cSage 300 ERP 2014 version\u201d. So to make\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/03\/24\/error-while-migrating-data-from-lower-version-to-higher-version\/\">Read More &raquo;<\/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":[903,1300,1610,2357],"class_list":["post-10507","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-error-while-migrating-data","tag-incorrect-procedure-you-must-post-or-delete-all-open-batches","tag-migrate-data","tag-sage-300-erp"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Error while migrating data from lower version to higher version - 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\/03\/24\/error-while-migrating-data-from-lower-version-to-higher-version\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Error while migrating data from lower version to higher version - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Sage 300 ERP helps organizations to maintain their operational and financial data. As time progresses, the ERP gets better and better with new features added in it. So Sage releases new versions of Sage 300 ERP with the new features and new look. Currently Sage is providing \u201cSage 300 ERP 2014 version\u201d. So to make\u2026 Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/03\/24\/error-while-migrating-data-from-lower-version-to-higher-version\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2015-03-24T12:07:18+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/03\/1.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=\"1 minute\" \/>\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\/03\/24\/error-while-migrating-data-from-lower-version-to-higher-version\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/03\/24\/error-while-migrating-data-from-lower-version-to-higher-version\/\",\"name\":\"Error while migrating data from lower version to higher version - 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\/03\/24\/error-while-migrating-data-from-lower-version-to-higher-version\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/03\/24\/error-while-migrating-data-from-lower-version-to-higher-version\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/03\/1.png\",\"datePublished\":\"2015-03-24T12:07:18+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/03\/24\/error-while-migrating-data-from-lower-version-to-higher-version\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/03\/24\/error-while-migrating-data-from-lower-version-to-higher-version\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/03\/24\/error-while-migrating-data-from-lower-version-to-higher-version\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/03\/1.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/03\/1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/03\/24\/error-while-migrating-data-from-lower-version-to-higher-version\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Error while migrating data from lower version to higher version\"}]},{\"@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":"Error while migrating data from lower version to higher version - 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\/03\/24\/error-while-migrating-data-from-lower-version-to-higher-version\/","og_locale":"en_US","og_type":"article","og_title":"Error while migrating data from lower version to higher version - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"Sage 300 ERP helps organizations to maintain their operational and financial data. As time progresses, the ERP gets better and better with new features added in it. So Sage releases new versions of Sage 300 ERP with the new features and new look. Currently Sage is providing \u201cSage 300 ERP 2014 version\u201d. So to make\u2026 Read More &raquo;","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/03\/24\/error-while-migrating-data-from-lower-version-to-higher-version\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2015-03-24T12:07:18+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/03\/1.png","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/03\/24\/error-while-migrating-data-from-lower-version-to-higher-version\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/03\/24\/error-while-migrating-data-from-lower-version-to-higher-version\/","name":"Error while migrating data from lower version to higher version - 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\/03\/24\/error-while-migrating-data-from-lower-version-to-higher-version\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/03\/24\/error-while-migrating-data-from-lower-version-to-higher-version\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/03\/1.png","datePublished":"2015-03-24T12:07:18+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/03\/24\/error-while-migrating-data-from-lower-version-to-higher-version\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/03\/24\/error-while-migrating-data-from-lower-version-to-higher-version\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/03\/24\/error-while-migrating-data-from-lower-version-to-higher-version\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/03\/1.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/03\/1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/03\/24\/error-while-migrating-data-from-lower-version-to-higher-version\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Error while migrating data from lower version to higher version"}]},{"@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\/10507","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=10507"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/10507\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=10507"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=10507"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=10507"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}