Hello, I have imported 300 fixed assets for a customer, and now I have to change the no series for all of them. How can I update the no series with config package? Or is there another way to do it, then delete all and reimport.
The fixed asset no. is the primary key on that table so you would need to do the following:
1. If you don't have any fixed asset ledger entries. Using a configuration packge, select delete all table records and then upload the fixed asset list with new numbering:
2. Use edit in excel and delete all the lines, publish your changes and reload data.
If you have fixed asset ledger entries this will complicate the approach. You can always manually renumber the records that do have fixed asset ledger entries and then delete and recreate the others. If all fixed assets have acquisition and depreciation entries posted already you may need to consult a partner or get a developer to help renumber those records.
Best,
Teagen
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.