Finance | Project Operations, Human Resources, ...

Asset Suffix marked as inactive when entering a new asset

(0) Share

Report

Posted on by Richard Wheeler

75,788 Moderator

On the Fixed Asset General screen I am trying to add a new asset. I am getting the message " Asset XXXXX suffix 1 is not an ACTIVE asset and cannot be accessed via cards".

How can this be given this is a new asset? I can enter other assets just fine.

Categories:

Microsoft Dynamics GP

All responses (2)

Answers (0)

Richard Wheeler 75,788 Moderator on at

Like (0)

Report

RE: Asset Suffix marked as inactive when entering a new asset

Thanks Adam, this issue turns out to be too many cooks in the kitchen. I was asked to import assets into Fixed Assets. Unbeknownced to me someone was manually entering the same assets and had marked some as Inactive. This became clear once I examined FA00100.ASSETSTATUS.
Suggested answer

agaber on at

Like (0)

Report

RE: Asset Suffix marked as inactive when entering a new asset

Hi Richard-

Thank you for posting your question on the Forums. I would double check if you have a corrupt record in the FA00100/200 tables.

select * from FA00100 order by DEX_ROW_ID desc

Do you see the erring Asset Index? If so, double check the FA00200

select * from FA00200 where ASSETINDEX 'XXX'

If not, just run a generic select and see if anything looks off:

select * from FA00200 order by DEX_ROW_ID desc

If you see any corrupt records, restore a backup to TEST and delete them there and see if the issue persists or not.

If you don't see anything suspicious in either table and/or removing records does not work, it would be best to open a support case so we can take a deeper look at the FA tables and/or grab a log of the error if needed.

Have a great day!

Adam G.

Microsoft Dynamics GP