Problem: Duplicate Asset ID and Suffix Error When Adding a New Asset. This problem is related to Microsoft Great Plain FA module. I found this error in GP 7.5 and 9.0
Solution: Take backup of your database depending on your condition. Run a delete statement on the FAINDEX in your Company database. “Delete FROM FAINDEX”