05-11-2017 3:52 PM
Deal All,
I'am in Rwanda and our company is trying to use EFT(Electronic Fund Transfer) to Import the Bank Statement into SAP Business One.
I would like to ask for any assistance about how to work with bank statement file format project in SAP, and how to import it into SAP Business One, Because the Bank Statement file i am trying to import gives me this ERROR
" Loading the bank statement file 'D:\SAP Business One\Electronic Found\EFM\EFM\Samples\BFP\csb43.txt' 2017-05-11 16:38:49 0 Parsing the bank statement file 'D:\SAP Business One\Electronic Found\EFM\EFM\Samples\BFP\csb43.txt' 2017-05-11 16:38:50 0 "RecordCode - " not exist. 2017-05-11 16:38:50 0 "Nines - " not exist. 2017-05-11 16:38:50 0 Verifying bank statement # with 7 row(s) 2017-05-11 16:38:50 0 0 bank statement row(s) will be included 2017-05-11 16:38:50 0 7 row(s) with an incorrect bank account will be ignored 2017-05-11 16:38:50 0 Bank statement # ignored 2017-05-11 16:38:50 0 0 succeeded, 1 ignored 2017-05-11 16:38:50 0 Operation failed 2017-05-11 16:38:50 0 Failed to save bank statement 'D:\SAP Business One\Electronic Found\EFM\EFM\Samples\BFP\csb43.txt' to database 2017-05-11 16:38:50 0 Failed to import bank statement 'D:\SAP Business One\Electronic Found\EFM\EFM\Samples\BFP\csb43.txt' 2017-05-11 16:38:50 0 "
Any Kind of Help will be Hihly Appreciated.
05-11-2017 11:47 PM
Dear Mr Janvier Isabane,
I am not if I understand your concern, however I will suggest you follow the steps as listed below and if the issue persists please revert to us with much more details and steps involved.
Description
When uploading a bank statement file an error message is displayed.
Reproducing the Issue
Cause
The error messages received while uploading bank statements are due to incorrect Bank Statement File. Customer need to check with the bank for these inconsistencies in the file.
Resolution
Example:
In a BAI2 file, line 03
represents the statement header. The following record types can appear
in the relevant bank statement file:
010-Opening
Ledger
015-Closing Ledger
100-Total
Credits
400-Total Debits
05-29-2017 4:42 PM
Dear Kokouvi Tossenou.
Thank you for you're response
These are all process of importing my BFP File to SAP Business.
This figure is showing how the Bank Statement File Format was created.
The 2nd Figure is Data Preview
The 3rd Figure is for assigning the BFP File to House Bank Account.
The Last One is the Error given after Importing File.
the problems of ERRORS comes to this stage and i don't how to deal with it.
Maybe these Screenshot may help somehow to get an idea of what i was asking.
Anyone can help on this.
Thank you.
01-10-2018 8:49 PM
Hi,
The "incorrect bank account" relates to the account in the transaction rows, which must match the account for the house bank you are importing for
02-02-2021 5:46 PM
Dear Mr Janvier Isabane,
How did resolve this Error, when you Imported the file.txt?
Thank you.