
Hi -
According to the GP help manual there are 4 status' to fixed Assets:
Active, Deleted, Partial Open, and Retired.
Question 1: Do you know what numbers correlate with each status in the tables? I think it goes 1)Active 2)Deleted 3)Partial Open and 4)Retired. Can anyone confirm this?
Question 2: In the table there is a AssetStatus of 0. Does anyone know what causes this or why this is happening? On the front end of GP it shows up active.
Thank you for your help!
*This post is locked for comments
I have the same question (0)Hi juliemyung,
regarding Q1-it is confirmed as you mentioned above.
and in Q2- AssetStatus 0 show the Inactive asset.
find it in the FA00100 Asset Master table and make sure the ASSETSTATUS = '1' on it instead of 0 (inactive).
There is an issue (#83434 to be fixed in GP 2015 R2) in the Asset General window that if the user chooses the purchasing drop-down BEFORE adding the asset ID, a script is called that will blank out the asset status and makes it unusable.
You need to enter the asset ID, select the purchase, and then enter a Class ID. If you select purchases first, and then enter the asset ID and class last, that causes the issue. To resolve, simply update the asset with a status of 1 in the FA00100 table.