Reconciliation > Bank reconciliation > Error when recording a bank reconciliation

Looking for something specific in the page and not quite sure where to find it? You can always press CTRL + F on your keyboard and type a keyword. Or you can do a search (in the top right corner).

« AgExpert Analyst Knowledge Base

Error when recording a bank reconciliation

The following error message may appear when you try to record a bank reconciliation:

An unexpected error has occurred. Close the software and reopen it.

If this error continues, call FCC Management Software at 1-800-667-7893 for help.

The data type is not valid for the boolean operation. [ Data type (if known) = uniqueidentifier,Data type (if known) = nvarchar ]

SQL Server Compact ADO.NET Data Provider

at System.Data.SqlServerCe.SqlCeCommand.CompileQueryPlan()

at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options)

at System.Data.SqlServerCe.SqlCeCommand.ExecuteNonQuery()

at AEF.clsDbHelper.Execute(String strSql)


  1. Select a different bank account in the Bank Reconciliation dialogue box. Then select the original bank account. This will refresh the screen and you’ll be able to record the bank reconciliation.


Last updated on August 22, 2014 by FCC AgExpert