AMC Banking Import Error to Natwest

(0) Share

Report

Posted on by Community Member

Hello,

Is anyone else struggling with the AMC Banking App when linked to Natwest?

We are downloading the payment list from BC on a weekly basis. Most weeks we have multiple invoices due for our vendors and when exporting the csv file for importing into Natwest it always errors. The Natwest system seems to not like the commas which separate the vendor invoice numbers in the exported file.

Is there any way to set up the formatting of the report in BC before it is exported which would remove the commas in between the vendor invoices? Once they are removed from the report, it's re-saved, and imported again without them it always seems to run fine?

Any guidance someone can give on this would be really appreciated.

Thanks,

Amy

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Renni 960 on at

Like (0)

Report

Hello again Amy,

In my previous experience with this but to Barclays not natwest you could set a template so it did this.

You are exporting it as csv (comma separated value) so the comma should be there.

You may be able to change the data exchange definition in BC

Find the relevant code and open the card

Go to file type and change to variable text then in column separator you can set space instead of coma

Was this reply helpful? Yes No