Fixed Asset Status?

(0) Share

Report

Posted on by Community Member

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

All responses (1)

Answers (0)

Mehtab Hassan 80 on at

Like (0)

Report

RE: Fixed Asset Status?

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.