Skip to main content

Error - 'Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements...' when revaluing a nominal

If you are trying to revalue the nominal ledger for a currency but getting the error:
"Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0.Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0.Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0.Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0."

This error is caused by the Nominal Exchange Difference nominal account that is set against your currency not existing. To check what nominal account it is trying to use:

  1. Click System, then click Currencies.

  2. Select the currency you are trying to revalue.

  3. Click the Eye icon.

  4. On the Defaults tab, make a note of the nominal in the Nominal Exchange Diff field.

  5. If the nominal does not exist, change the Nominal Exchange Difference to a valid account or create the missing nominal.

Did this answer your question?