We are using BaanIVc4.

We are planning to outsource our suppliers payment to bank. The bank required us to submit a payment bankfile in ascii format to them via connection to their server.

The will provide the file layout which will consist such as, payment invoices details, payment date, supplier name, address & etc. This is to be output from the Baan.

The bank will prepare the cheque per supplier based on the bankfile submitted to them, at the sametime, bank will print the payment advice together with the cheque and send to the suppliers. After payment, the bank will return to us a bankfile (ascii) which consists cheque number and payment invoice details.
The file is to be used to update the A/P and I'm not sure which table and which field to update the cheque number in the baan.

Is there anyone has done this ?

Need advise.

Hi,

We have done similar thing with Citibank. Let me know if you need more info. About getting file back from Bank and updating baan,there are couple of threads on the board which explain this in detail. Please search EBS or Electronic Bank ... on Baanboard.

regards,

Hi Akshay,

I would happy to receive more info from you.

I will be meeting Citibank for their presentation on cash management and it will be very good if I have more info.

Thanks.

Dear Akshay,
Can you pl give more information regarding the outsourcing the Cheque printing.

Thanks
Nilesh

To generate a payment file from Baan is very simple. While Maintaining the payment methods the field Output type is to be "file". So when the payment Advice is processed it will generate a file instead of printing Cheques and Payment advise. The file that gets generated have to to customised to the requirement of the Bank.

As far as receiving the file from the Bank you will have to use the Electronic Banking System (EBS) functionality of Baan.