I am trying to combine two fixed asset databases in the Sage fixed asset system. Currently, we have two databases, one of which contains a total of close to 18,000 fixed assets, and the second one contains a subset of around 7,000 of the fixed assets from the first one. This subset represents assets that were revalued in the acquisition of our company by another company.
My thought process to complete this was as follows:
1. Copy all of the assets from our historical database to a new database.
2. Create a group in the new database for the assets that were revalued.
3. Copy the data from the internal book of the revalued assets to the Custom 2 book.
3. Update the internal book of the revalued assets with the stepped-up values.
As I was trying to execute this plan, I ran into a couple of issues that I need help in overcoming:
1. I do not see an easy way to set up groups of random systems numbers through an excel upload, and keying all these system numbers would take forever.
2. I found out that updating assets in the Sage fixed asset system only allows for updated information in the general information fields, and not in any of the books.
Is there any way to get around these issues so that I can combine the two databases and retain all of the asset history?
Thanks,
Angie P.