Migrating entity data to aACE

Entity data is that which is required to complete a transaction. Because one entity is often related to another, it is most efficient to follow the order listed below when migrating your data to aACE. Records can be imported or entered by hand. Regardless of the method you choose, aACE has data management tools to make the migration process easier.

  1. Offices / Departments - they are required in Team Member records
  2. Team Members
  3. GL Accounts (Chart of Accounts) - they are required in Categories
  4. Tax Profiles - optional - can be linked to Companies
  5. Rate Cards - optional - can be linked to Categories and Companies
  6. Companies - can be linked to Categories as preferred vendors
  7. Activity Categories - do these before Task Groups if you plan to link them to Task Groups
  8. Task Groups - optional - can be linked to Categories
  9. Item Categories - these can be used as Bill of Materials in Assembly Categories
  10. Inventoried Item Categories- these can be used as Bill of Materials in Assembly Categories
  11. Assembly Item Categories - these can be used as Bill of Materials in other Assembly Item Categories
  12. Inventoried Assembly Items- these can be used as Bill of Materials in other Assembly Item Categories
  13. Purchase Categories
  14. Other Categories
  15. Contacts - if not done with Company records

Links to topics on importing

It is important to follow all import instructions closely so that data imports properly. We recommend backing up your live files prior to any large data import so that you have a file set to return to should something go awry. 

IMPORTANT NOTE: Large imports can take a while to process and can block access to a module during the import. Be sure to consider other users if you are preparing a large data import. 

How to import records

How to download an import template

How to prepare a file for importing

Mapping import fields

Handling data validation errors

Importing GL Accounts

Helpful Hints

Keep in mind that all List Views have batch record updating tools available (see the Actions menus). These tools can update fields and record relationships for large batches of records. Using them can save you time and reduce data entry errors. 

See Also

Understanding the data migration process

Have more questions? Submit a request
Powered by Zendesk