The issue is that we have some vendors who want to use a bank savings account type for payments.
When the EFT export file is created and generated, BC assigns a default code of 22, which represents a checking account type.
The Data Exchange Definition does not allow the Bank Code from the Vendor Bank Account card to be mapped for the EFT export format..
After consulting with Microsoft, below is the response received:
From Microsoft:
"The issue you are experiencing with the EFT payment export, with the bank code not displaying, and also how to edit the Data Exchange Definition using the right transformation rule.
If the intent is to dynamically set the value based on whether the “vendor’s bank account” is checking or savings, which is the situation in this case, this is currently not feasible within standard Business Central functionality.
This is because the Vendor Bank Account page includes very few fields that flow through to EFT, and those that do are already designated for specific purposes.
Anyone have any thoughts? We are now using a manual process to handle these vendor payments.