Steps to Rebuild Sage 50 Company
Reach out for Sage 50 database repair service 800-475-1047 for pricing
Top 7 reasons to rebuild a Sage 50 company – Sage 50 Data Repair Steps
Rebuilding a Sage 50 company is not an easy task but is possible when a proper strategy is in place to minimize the down time created when you begin the Sage 50 rebuild process. If you system is running slow and you want to see if a few minor adjustments can increase performance read this.
- Bad data due to corruption
- Change the number of accounting periods
- Modify the fiscal year setup
- Change from Cash to Accrual Accounting Basis
- Change from Accrual to Cash Accounting Basis
- Merging multiple companies
- Start over to minimize data file sizes
Warning: If your company data is damaged or possibly corrupt, it is not suggested that you rebuild your company using this method. It is possible that damaged data will also be present in the new company. There are several considerations when working with a Sage 50 company file where known data corruption exists.
If you company has special characters in the lists and transaction files there will be manual clean up that will be required in the intermediary excel files. These may include (,) (“) (#) and several others.
The Sage 50 rebuild process
Accounting Business Solutions by JCS has performed hundreds of Sage 50 company rebuilds and know the tips and tricks to successfully rebuilding a Sage 50 Company data file. Give us a call 800-475-1047.
How to start rebuilding a Sage 50 company by creating a new company in Sage 50 and copying all the module settings from the original company as well as the chart of accounts. Rebuilding an existing Sage 50 company involves creating a new company and using the import/export process to transfer your existing data to the new company.
Set up a new company, copying default settings from an existing company.
- Select File, and then select New Company
- Click Next
- Enter the company information for now, add New to the company name so you can distinguish it from the original company (this will be changed back to the real company name once the rebuild is complete), and then click Next
- Select Copy settings from an existing Sage 50 company, and then click Next
- If changing accounting period structure, be sure to clear Accounting Periods, and then click Next
- Select an accounting method, this should be the same as in the original company, unless you are rebuilding to change accounting methods, and then click Next
- Select a posting method, and then click Next
- If you chose not to copy Accounting Periods, you will need to choose an accounting period structure, and then click Next
- Choose the month of Period 1, and then click Next
- Click Finish
Copy over needed files
- Select File, and then select New Company
- Click Next
- Enter the company information for now, add New to the company name so you can distinguish it from the original company (this will be changed back to the real company name once the rebuild is complete), and then click Next
- Select Copy settings from an existing Sage 50 company, and then click Next
- If changing accounting period structure, be sure to clear Accounting Periods, and then click Next
- Select an accounting method, this should be the same as in the original company, unless you are rebuilding to change accounting methods, and then click Next
- Select a posting method, and then click Next
- If you chose not to copy Accounting Periods, you will need to choose an accounting period structure, and then click Next
- Choose the month of Period 1, and then click Next
- Click Finish
Export maintenance record lists out of the old company, and import them into the new company
(all in a specific order). You must import in the exact order listed and make a unique backup after each successful import.
Open Sage 50 and the original company
Select File, Select Import/Export, and then export each of the following items:
- Chart of Accounts List (General Ledger) if using Budgets
- Budget List (General Ledger)
- Employee List (Payroll)
- Vendor List (Accounts Payable)
- Customer List (Accounts Receivable)
- U/M List (Inventory) Premium for Distribution, Premium for Manufacturing and Quantum Accounting only
- Inventory Item List (Inventory)
- Bill of Materials Listing (Inventory)
- Phase List (Jobs) for Complete, Premium, and Quantum Accounting only
- Cost Code List (Jobs) for Complete, Premium, and Quantum Accounting only
- Job List (Jobs)
Establish the opening balances. The invoice numbers on the customers and vendors must be an exact match or the cash receipts and cash disbursements on future transactions will fail to import. In addition the bank reconciliation balances must be established in the reconciliation as of the new start date
Export journal data out of the old company, and import it into the new company (import these all in the same order as exported)
When exporting, set the date range on the Filter tab to All, then manually enter the date range you wish to copy.
Open the original company
Go to File, and then click Select Import/Export
Export the following items:
- General Journal (General Ledger)
- Purchase Order Journal (Accounts Payable)
- Purchases Journal (Accounts Payable)
- Assemblies Journal (Inventory)
- Work Ticket Journal (Inventory) for Premium for Distribution, Premium for Manufacturing and Quantum Accounting only
- Adjustments Journal (Inventory)
- Sales Order Journal (Accounts Receivable)
- Sales Journal (Accounts Receivable)
- Time Ticket Register (Time/Expense) for Complete, Premium, and Quantum Accounting only
- Expense Ticket Register (Time/Expense) for Complete, Premium, and Quantum Accounting only
- Payments Journal (Accounts Payable)
- Cash Receipts Journal (Accounts Receivable)
- Payroll Journal (Payroll)
Go to the new company and then click select Import / Export
Import these items
Post all journals, and print the necessary reports to compare the two companies. Then find and correct any transactions that need to be corrected.
Note: Each step must be completed successfully in the order mentioned above before continuing with the next step.
Sage 50 Rebuilds
Sag 50 rebuild may be needed or Sage 50 Data repair run for corrupt data files. Sage 50 rebuild data errors have specific fixes for the sage 50 database. Often repair can correct sage 50 error messages for missing files caused when a single Sage 50 error occurs or multiple sage 50 errors are the issue. A Sage 50 company rebuild is needed for multiple corrupted files. To correct the database damaged installation or when a workstation disconnects from the network software may need to be reinstalled.
Questions on Sage 50 errors
What are the causes of Sage 50 corrupt data?
Orphaned records, network disconnected and corrupted data, old workstations, large database is too big for the system.
When do I know if my Sage 50 company data file has issues, what are the signs?
Often error messages are displayed, reports are missing information, or transactions are not displayed as entered.
Where do I see error messages for in Sage 50?
Sometimes during entering transactions, printing reports, logging in and printing financial statements.
How to I fix the Sage 50 company file and resolve the issue?
The correction process is based on the actual error message or issue you are having in the data base. There are exact fixes for exact Sage 50 errors.
Sage 50 rebuild frequently asked questions
Question: Can I import Sage 50 transactions from Excel?
Answer: Yes, however this process is not easy if you understand the data base in Sage 50 this is possible or it may be easier to use the SDK to bring in transactions but most customers decide this is not cost effective
Question: How do I perform a Sage 50 transaction CSV Import?
Answer: Look under file and import export you can find the different import options that are easy to use. If you are rebuilding a company this is easy because the record layouts for the export and the import are very similar.
Question: Where can I find Sage 50 import templates?
Answer: There is help in the Sage knowledge base and help included in the Sage 50 software application. However, we have learn how to really use the import and export tools from performing over 500 company rebuilds.
Question: Can I import sales orders into Sage 50?
Answer: Yes, The best way to import Sage 50 sales orders is to use the SDK (Software developer kit)
Question: Can I import purchase orders into Sage 50?
Answer: Yes, The best way to import Sage 50 purchase orders is to use the SDK (Software developer kit)
Question: Can I bring over Sage 50 history transactions?
Answer: Yes, as long as you are not performing a rebuild because of corrupt data
Question: Can I bring over history transactions from another accounting package?
Yes, but this is a very tedious process and can take a lot of time to complete
How can I copy a new company in Sage 50 from and existing company file?
- create the new company
- backup the original company
- log into the NEW company
- restore the company from the backup of the original company
- copy over the reports
- copy over the forms
How to set up a new company on Sage 50 accounts
- Select File
- Then select New Company
- follow the prompts
What are the steps to migrate Sage 50 to a new server?
- Install all updates on the original server
- download all payroll tax updates
- On the new server install the software and all updates
- download all payroll tax updates
- Create the company data file on the new server
- Backup the original company on the original server
- Login to Sage 50 on the new server and restore the company
- Restore all reports and archived company data files
- Print reports from the original server
- PDF the same reports on the new server
- Compare both sets of reports
- Confirm balances from original to new reports
Can I install Sage 50 on a new PC and then uninstall from the old PC?
Yes, simply go thru the installation on the new PC and then use the steps outlined to migrate your company data files.
Can I speed up my Sage 50?
I ran the data purge but my system is still running slow. Read this – you may still need to perform a rebuild to increase performance if your company data files are too large.
With over 25 years of accounting and business knowledge as well as proficient technical background you get the training and support your business needs and deserves working with a proficient expert consultant. You can work with the same consultant to help you master your Sage Software and for those occasional questions you need help with so you can understand best practices and how to manage your company information and books. For assistance with Sage 50 give us a call 800-475-1047 or visit www.jcscomputer.com
Put our 25 years of experience to work for you!
“Your Success is Our Goal”
Like us on Facebook and follow us on Twitter
Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming
