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 - when sorting the Asset list by department

When trying to sort the Asset list by department, a single user may receive the error, 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
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 

Was this article helpful?