| How to copy company data into another company in Sage 100 |
Resolution | [BCB:1:Backup warning:ECB] How to create a NEW Destination company code (if needed): - Open Library Master, Main menu, Company Maintenance
- Click the Company Code field lookup, note which company codes already exist, and then click Cancel to return to Company Maintenance
- For Company Code, enter a new three-character destination company code that doesn’t already exist
- Note: Don’t use "CON" or "SOA" for the company code. Avoid "001" or "000" as well.
- Enter the new Company Name and any other applicable information.
- Note: The company code is the only required field.
- Click Accept
- Close Company Maintenance
How to copy data from a Source company code into a Destination company code: (Warning: This will overwrite data in the destination company code!) - Open Library Master, Main menu, Company Maintenance
- For Company Code, enter the three-character destination company code
- Note: Don’t use "CON" or "SOA" for the company code. Avoid "001" or "000" as well
- Click Copy button
- Click OK, to the warning "Integration with any copied module should be reviewed."
- If a new company code was created in step #2, click Yes to "The company record must be saved before data can be copied.."
- In the Source Company field, click lookup and select the Company Code you want to copy data FROM
- All of the modules activated for the source company are selected by default. Deselect any of the modules that shouldn’t be copied
- Note: You won’t be able to deselect Common Information or General Ledger. For information on copying data for just one module, see the Related Resources section below.)
- Click Proceed
- Click Yes, at the prompt "Do you want to copy all data files to the selected company?"
- Click Accept
- Close Company Maintenance
How to copy a company from a test system back to production when a "File in Use" message occurs - Everyone exit Sage 100
- Browse to ..\..\MAS90 directory on the server
- Rename MAS_XXX to origMAS_XXX (where XXX represents the company we’re trying to write to)
- In that directory right click and create a new folder
- Rename to MAS_XXX
- Open Company Maintenance in Sage 100
- Select XXX
- Click Activate
- Click Cancel
- Click Accept
- This refreshes Sage and what it sees for the PEI company code
- Select XXX again
- Click Copy
- Select your Source Company as usual
- Proceed with the copy
|
|