This information was provided by Jonathan Fear back in Jul 2011
If you need to upgrade 309/Fixed Assets and keep the data for that module you have to restore the databases back to GP 9 SP4 and then upgrade Fixed Assets (I would guess it was not installed during this upgrade). Otherwise if you do not need the FA data you can use the following scripts to reinstall the module:
1. UPDATE DYNAMICS..DB_Upgrade SET db_verOldMajor=0, db_verOldMinor=0, db_verOldBuild=0, db_status=0 WHERE PRODID=309 and db_name = 'xxx'
2. Delete DYNAMICS..DU000020 WHERE PRODID=309 and companyid = 'x'
3. Run the following scripts against the company database:
A. Drop table FA41000
B. Drop table FA00200
C. Drop table FAINST01
You can find the db_name and companyid in the SY01500 table.
Let me know if you have any other questions.