Dynamics GP 2013 - Integration Manager - Fixed Assets - Error Number = 5348 Stored Procedure= taCreateAssetID Error Description = Unable to obtain the next Financial Index

• Issue
• Running the Integration Manager integration for Fixed Assets produces this error
• Cause
• Fixed Asset tables are not correct
• Most likely an older version of the tables is still in use from an earlier FA install
• The FAINDEX table has invalid data
• The FA00902 table has no Financial Index records to lookup
• Resolution
• Try manually entering an Asset with general and book data AND running depreciation against it (This worked for me)
• Once you get some records in your FA00902 table, run your integration
• OR
• https://support.microsoft.com/en-us/kb/897747
• Manually update the tables as described in the previous link
• Try clearing the FAINDEX table
• Replace TWO with your company database
• DELETE TWO..FAINDEX
• OR
• Run the database maintenance and reload all of the FA objects