RBC IAT EFT Payment file issue for USD payment for CAD region

(0) Share

Report

Posted on by Rahul.

In NA Business Central 16.6 (Platform 16.0.17024.0 + Application 16.6.17046.0),

I have configured a Data Exchange Definition to manage IAT file structure for RBC Bank that extract payment transaction in file for USD bank accounts.

So far, the results look fine but when it has been verified in RBC Bank website, we found following correction in EFT Payment file where I need assistance for it.

1. System generate a separate file per vendor, instead of 1 file with all payments. However, if I make two different payments for same vendor, then it extract mulitple payment details and failed in case of different vendor code.

2. Remittance Output and Payment Amount in detail and footer of IAT file should show in USD dollar. Currently, the file show Amount (LCY) value that show CAD amount value. For instance below, payment is booked for $1 while file shows $1.28 in CAD.

3. File footer show a static dummy lines with value 99999999999999.

Categories:

Dynamics 365 Business Central

All responses (2)

Sort by

Marco Mels Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello,

If you do not get further traction from the community, feel free to raise it to Microsoft support via your partner or CSP.

Thanks.
Sai Ragavan 51 on at

Like (0)

Report
Copy link

Link copied!

Hi Rahul, I see the same issue as well. Were you able to get a resolution on this? Much appreciated.

Thanks

Sai