MichelVerhaegen
21st August 2006, 09:46
Hello friends,
Baan IVc and 5.0c
I would like to instal the Electronic Bank Statements.
Can someone send me an exemple of the ascii-file:
Is there a header, detail and footer?
Thanks
avpatil
22nd August 2006, 03:48
What transactions are you trying to do thru EBS? In our case we have implemented EBS to apply cash to sales invocie and in AP side for check reconcillation. We have implemented EDI with Bank and then we convert them into a flat file. We have our custom sessions that fills up the EBS tables and then standard BAAN program takes over.
Arvind
MichelVerhaegen
22nd August 2006, 09:41
Hello Arvind,
What do you mean by your custom session. Is this an Exchange scheme to fill the tables?
If yes, can you send me the script of this scheme,
Thanks,
Michel
avpatil
22nd August 2006, 14:43
Michel,
It is not a custom exchange scheme. It is our customized session to fill up tfcmg501 and other tables. What transaction are you trying to bring thru EBS?
Arvind
MichelVerhaegen
22nd August 2006, 15:04
In the first phase we want to allocated all bank-transactions to specific ledger accounts.
The purpose is that all bank-transactions are allocated to a ledger account:
e.g.: Incoming receipts Ledger account customer department
Outgoing payments suppliers Ledger account suppliers department
Outgoing non suppliers payments Ledger account Accounting department
In the electronic bank-statement from the bank, we can find the coding to define what kind of transaction we have in the bank-file: customer receipt, supplier payment, bank-fee, etcÂ…
The second phase is to find a method to allocate the customers receipts. In our case is this a very difficult matter because we have a lot of foreign receipts with deduction of bank-fees.
:) Michel