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)

Solution

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 March 10, 2014 by FCC AgExpert