Change ASSET ID

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (8)

Answers (0)

Community Member on at

Like (0)

Report

Changing from 1000-16

Was this reply helpful? Yes No
RogerRogerATX 1,515 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

No, we do not have PSTL installed.

Was this reply helpful? Yes No
RogerRogerATX 1,515 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Redbeard 12,931 on at

Like (0)

Report

I would suggest using the Fixed Asset Delete Utility and then placing the asset into service under the correct asset ID.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (1)

Report

Gosh Patrick. The easiest thing to do is to install the PSTL. You only need to install it on the workstation you want to use to make the change.

Kind regards,

Leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No