Disclaimer!
Backup Warning:
Use warning whilst operating with the underneath product functionality. Always create a backup of your facts earlier than intending with superior solutions. If necessary, are trying to find the help of a certified Sage commercial enterprise partner, community administrator, or Sage customer service analyst.
In this blog, we are explaining how to Export and Import Company Records in Sage
Resolution: Step I: Export the listing in a textual content report:
1. Select File.
2. Select Import / Export.
3. Select Export Records....
4. Select Export information to a Sage 50 import report format.
5. Select Next.
6. Select the report kind you want to export (for instance Vendors).
7. Enter a call for the export report.
8. Enter the region wherein you would really like to save the report (Browse to the region then choose OK).
9. Select Next.
10. On the Select Records window, choose the accounts/information you want to export.
11. Select Next, the export report might be generated.
12. When exporting is completed, you may see a summary, affirm that the facts you chose has been exported efficiently and are marked "has been exported".
13. Select OK.
14. The Export Wizard will display you the region and call of the exported report. Please notice this statistics.
15. Select Finish
Also Read: How to Create an Inventory or Service Item records in Sage 50
Step II: Import the textual content report into the brand new Sage 50 organization report:
1. Select File, Import / Export, then Import Records....
2. Select Sage 50 import format.
3. Select Next.
4. If necessary, create a backup of the organization report previous to importation. Select Back Up... and observe the wizard's instructions.
5. Select Next after backup completes.
6. Select the Browse button subsequent to the containers you want to import and choose the report or documents you formerly exported.
7. Select Next.
8. Sage 50 will show all of the information that have been brought and the purpose why a few have been now no longer imported if applicable.
9. Select OK.
10. Select Finish.
Keywordsimport information, export information, export information from one organization to some other new organization
Additional statisticsBefore uploading the documents, one have to affirm the exported textual content report for the statistics underneath:
The first line of every textual content report has to include a Version Number, Country Code, after which the words 'Vendors', 'Customers', 'Accounts', etc. For instance you may see : 21001,3,Accounts (model 2014 for French Canada).
Version:1. Simply Accounting model 2005 Version Number = 12001
2. Simply Accounting model 2006 Version Number = 13001
3. Simply Accounting model 2007 Version Number = 14001
4. Simply Accounting model 2008 Version Number = 15001
5. Simply Accounting model 2009 Version Number = 16001
6. Simply Accounting model 2010 Version Number = 17001
7. Simply Accounting model 2011 Version Number = 18001
8. Simply Accounting model 2012 Version Number = 19001
9. Sage 50 model 2013 Version Number = 20101
10. Sage 50 model 2014 Version Number = 21001
11. Sage 50 model 2015 Version Number = 22001
12. Sage 50 model 2016 Version Number= 23001
13. Sage 50 model 2017 Version Number= 24001
14. Sage 50 model 2018 Version Number= 25001
15. Sage 50 model 2019 Version Number= 26001
16. Sage 50 model 2020.1 Version Number= 27101
Country Code primarily based totally at the reputation of your model of Sage 50 facts report:
a. Canada = 1
b. USA = 2
c. French Canada = 3
d. Australia = 5
e. International = 7
