EFT / Cheque batch does not activate and there is no error message - 7.00.157, 7.01.00 and 7.02.00

Owned by Beth Blok (Unlicensed)
Last updated: Nov 21, 2022 by Mike SheenVersion comment
2 min read

Problem

EFT / Cheque batch will not activate although everything looks fine.  There is no error message to indicate what the error could be.  

Solution

There was an issue in 7.00.157 (corrected in 7.00.175) where activating purchase invoices was posting to the CR_Trans table at more than 2 decimal places.  This could result in the activation of a EFT / Cheque incorrectly trying to post a rounding value for local creditors.

Alert

The solutions should only be implemented after discussion with the Jiwa Solution Provider and Jiwa Support. A sound knowledge of SQL is required. If the database has FX Creditors, the scripts MUST NOT be run without consultation with Jiwa Support

The solution in 7.00.157 is two-pronged. Firstly allow the posting of errored journals so the EFT batch can be activated. Secondly implement a rounding script to round the creditor transactions before paying the invoices.

  1. System Settings > System Configuration > Ledger > SaveErroredSets. Tick this setting and save
  2. Activate the EFT / Cheque Batch
  3. Load the Errored journal set and correct the set
  4. System Settings > System Configuration > Ledger > SaveErroredSets. Un-tick this setting and save
  5. Run CR_TransactionsRound and then CR_AllocationsRound to update existing data
  6. Create an SQL task to run CR_TransactionsRound as often as required - e.g. daily

Remember

Cancel the repeating SQL task once the database has been upgraded to 7.00.175 or later