Announcements
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.
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.
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
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156