Edit

• Export - Will be active when data is available to export. Select to create export file. Where multiple bank accounts in use, a bank account must be selected to activate the button

• Cancel - Select to return to BECS export page to allow process to begin again with no action being executed

Validations and Alerts

Below are alerts you may see during this process and the reasons why they have happened. In most cases, you should be able to identify a data error and once corrected, Save or Post the record.

On Navigation to the Accounts / Export / BECS / Reimbursements (ABA) Screen

• Banking details require set up! - There are no bank account records in your system. Check for entries in glbankaccounts and glbankaccountabamappings (process type becs). Contact Catch-e Support to check and update your banking set up

New

• Nothing to reimburse! - There are no outstanding claims to reimburse. Click on OK to be returned to the screen. If you are sure there are records that should be showing, contact Catch-e Support to check your banking set up

Create

• Warning! Reimbursements cannot be exported for the following drivers: - The listed drivers have missing bank details. This error can occur if a user has removed the Driver's banking details after a claim has been raised and posted, but has not yet been paid. To correct these errors, go to the Drivers / Finances tab and add or correct the details in the "BSB Number" and "Bank Account Number" fields for the listed drivers. Up to eight (8) driver records can be displayed on the alert message pop-up. If more than eight drivers have missing bank details, they will show progressively as displayed records are corrected and the invalid list reduces. Note that bank account numbers can only be 9 characters long. If there are driver records that you cannot update at this time, you can still create a file for the valid records by clicking Create. Claims that have missing bank details will be skipped. The invalid records will be displayed again the next time you create a reimbursements file

  Warning: Reimbursements cannot be exported for the following drivers: {driverid}

• There are reimbursements due for export but none can be exported due to insufficient data! - This alert occurs where the listed driver or drivers have missing bank details (like the alert above) and there are no valid records that can be selected to create a reimbursement file. For example, all the claims that should be reimbursed are linked to drivers with missing bank details

• Problem creating BECS export - Unexpected transactions! - This alert will show if your banking setup and system data do not match. This can happen because of a setup issue. Contact Catch-e Support to check the banking setup

Export

• Print failed, check client banking details! - Client: {givenname} {surname} Account: {bank_account}. Go to the Drivers / Finances tab and add or correct the details in the "BSB Number" and "Bank Account Number" fields for the listed drivers

• File cannot be generated. Contact Support - Since this batch was originally created, the stored aba file has been corrupted and cannot be re-created. This scenario could happen if multiple bank accounts have been set up since the batch was created, which means due to the data constraints, the file can no longer be reconstructed automatically

Useful Queries

select * from gl_bank_accounts; select * from gl_bank_account_aba_mappings where process_type = 'becs'; select ba.bank_account_id, ba.bank, ba.account_name, ba.account_name_short, baam.process_type, baam.apca_number, baam.aba_description, baam.aba_self_balancing_flag from gl_bank_accounts as ba inner join gl_bank_account_aba_mappings as baam on baam.bank_account_id = ba.bank_account_id where baam.process_type = 'becs';