An error saying “Bank No must have a value in ACH RB Detail” appears while trying to Generate EFT files

Information 

• Products: Sparkrock 365 
• Summary: An error saying “Bank No must have a value in ACH RB Detail” appears while trying to Generate EFT files 

Details

This error is often caused by a wrong input in any of the Vendor Bank Accounts that you are paying to with this Payment Journal.

Resolution

To resolve this issue, follow these steps: 

1. Navigate to Payment Journals and select the batch for which you are trying to generate the EFT/ACH. 

2. For each line, you will need to expand the Recipient Bank Account dropdown and click “Select from full list” 

3. Open the Vendor Bank Account card and verify that all the information is correct.

4. Confirm that the Country Code has the same value across all vendors that you are paying to, in general it should be US or CA 

If you would like to review all vendors at once, you can export a Configuration Package with the table Vendor Bank Account (288) and filter by the correct country code to find missing or incorrect values  

Impact / Risks: 

None

Workaround

Not applicable. 

Related Information

Using Configuration Packages to export and import data in Sparkrock 365

Update History

The following are the dates and actions pertinent to the history of this issue. 

Attachment

Not Applicable.  

Attachments (2)

SBAM-94_1.png
156 KB

SBAM-94_2.png
220 KB