Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The multi-part identifier <field> could not be bound. Native error:4104 The cursor was not declared - when accessing Fixed Assets module

When switching to the Fixed Assets module or when trying to sort the Asset list by department, a single user may receive the errors:

Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The multi-part identifier "FAASSETS.DEPARTMENT" could not be bound. Native error:4104 The cursor was not declared, Error:16945

Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The multi-part identifier "FAASSETS.ACQUISITIONDATE" could not be bound. Native error:4104 The cursor was not declared, Error:16945
This may occur with just one single user. If so, reset the user's registry settings associated with The Financial Edge using the steps here:
How to reset all user options using the Reset Registry utility

Steps to Duplicate

1. In Records > Assets > View All Assets > click the column header for department to sort by department
2. Receive Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The multi-part identifier ;FAASSETS.DEPARTMENT; could not be bound. Native error:4104 The cursor was not declared, error:16945 
Warning
Maintenance in Progress: During this period, you can view your data, but you can’t add, edit, or delete data.

Was this article helpful?