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