I have an Asset that has been under the wrong Asset ID for a year. All of the connected accounts are going to the correct place, so there is no need to adjust depreciation or the GL. But for reporting purposes, I would like to change the Asset ID this item is attached to and change it to 1001-5. I have attempted the Transfer Utility, but either have not fully understood how it works, or it is not designed to allow this. Any help would be appreciated.
*This post is locked for comments
It turns out we do have the PSTL installed and I had the SA attempt the change. It turns out that as a change was attempted to the 1000-16 to 1001-XX (where XX is the next available sub ID) that the system is designed to change all 1000-XX's to 1001-XX. I retired the asset to back out the asset and depreciation and simply entered a new asset with the same YTD and LTD depreciation.
Thank you, but this seems to renumber all of the sub items of that asset ID as well. I have decided to retire the asset and place it into service under the correct asset ID.
Hmm PSTL is the best option. You should be able to do this in SQL but there are a few tables that would have to be updated with the new asset ID info. The Asset Index should not be changed. I've done this in our dev environment and didn't run into any problems but doing things like this should be tested first and backups made just in case.
These are the tables that I found that reference the Asset ID (excluding the GL entry detail, FA00902 detail) and Suffix:
SELECT * FROM dbo.FA00100
SELECT * FROM dbo.FA01002
SELECT * FROM dbo.FA00700
SELECT * FROM dbo.FA00701
SELECT * FROM dbo.FA00800
SELECT * FROM dbo.FA00801
SELECT * FROM dbo.FA01100
SELECT * FROM dbo.FACNVDTL
SELECT * FROM dbo.FA01300
SELECT * FROM dbo.FA10200
So in theory if you updated the existing asset ID records in those tables with the new asset ID and suf it should work. But again:
PSTL is best
Test in your system and make backups
No, we do not have PSTL installed.
Do you have PSTL installed? That does have a tool that will allow you to adjust the main asset ID field of an asset. Not sure about the suffix though.
Changing from 1000-16
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
