Electronic Bank Statement - .CSV files
One of our client located in UK. They are using Electronc bank system.
Now they requested some changes as below:
NatWest Bank are discontinuing BAI files in favour of CSV.
We currently connect to Backline using a modem dial-up connection. All of our account transactions are downloaded into a text file called u2018BAI.txtu2019.
NatWest have informed us that they will be discontinuing the modem dial-up service in two weeks time, in favour of a web based version. This web based version doesn't produce BAI.txt files, which we import into SAP. Instead it produces CSV files that have a completely different format and so won't import into SAP without either SAP or the file being modified.
All of our over-seas accounts from Ulster Bank also get fed into the NatWest system and exported into the BAI.txt files so that they can be imported into SAP.
Could you please suggest me how to implement these changes.
Thanks in advance.