How to copy company data into another company in Sage 100
Description
Cause
Resolution
[BCB:1:Backup warning:ECB]

 

 

 

How to create a NEW Destination company code (if needed):

  1. Open Library Master, Main menu, Company Maintenance
  2. Click the Company Code field lookup, note which company codes already exist, and then click Cancel to return to Company Maintenance
  3. 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.
  4. Enter the new Company Name and any other applicable information.
    • Note: The company code is the only required field.
  5. Click Accept
  6. 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!)

  1. Open Library Master, Main menu, Company Maintenance
  2. For Company Code, enter the three-character destination company code
  3. Note: Don’t use "CON" or "SOA" for the company code. Avoid "001" or "000" as well
  4. Click Copy button
  5. Click OK, to the warning "Integration with any copied module should be reviewed."
  6. If a new company code was created in step #2, click Yes to "The company record must be saved before data can be copied.."
  7. In the Source Company field, click lookup and select the Company Code you want to copy data FROM
  8. All of the modules activated for the source company are selected by default. Deselect any of the modules that shouldn’t be copied
  9. 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.)
  10. Click Proceed
  11. Click Yes, at the prompt "Do you want to copy all data files to the selected company?"
  12. Click Accept
  13. Close Company Maintenance

 

 

How to copy a company from a test system back to production when a "File in Use" message occurs

 

  1. Everyone exit Sage 100
  2. Browse to ..\..\MAS90 directory on the server
  3. Rename MAS_XXX to origMAS_XXX (where XXX represents the company we’re trying to write to)
  4. In that directory right click and create a new folder
  5. Rename to MAS_XXX
  6. Open Company Maintenance in Sage 100
  7. Select XXX
  8. Click Activate
  9. Click Cancel
  10. Click Accept
  11. This refreshes Sage and what it sees for the PEI company code
  12. Select XXX again
  13. Click Copy
  14. Select your Source Company as usual
  15. Proceed with the copy

 




Steps to duplicate
Related Solutions

How to copy all data for a module other than General Ledger or Common Information, from one company code into another company code

How to delete a company code and remove all data for a company from Sage 100