on 07-23-2017 6:36 PM
Hello All,
I am trying to use CVS /Excel file bank statement in SAP ByD as follows
Liquidity Management-New-inbound file-File type(bank statement)-
After selecting Bank ID,it populates Import Format as BAI2 US.
So how can i use CSV/Excel bank statement format in above step.
Please Guide.
Thank You.
Hi Nikitanikhil
It isn't clear from your question where exactly the problem lies.
Do you need to know how to assign your downloaded format to the correct format in ByD for your bank account?
Does the format not exist in ByD and are you trying to create a new Bank Statement format to accept the uploaded file?
Please supply some clarity and I will try to help you.
John Meadows
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello John,
Thanks for the reply.
Does the format not exist in ByD and are you trying to create a new Bank Statement format to accept the uploaded file?
Yes the bank statement is in excel file or csv file and SAP ByD accepts BAI2 format. I don't have BAI2 format available.
How do i convert my excel bank statement into BAI2 format?
Thanks
there are 2 solutions.
you can create your own input file format in the fine tune activity "Automatically Generated Bank Statements"
However if this doesn't work (due to data format, or special circumstances) you can build a bank statement file import process using the Cloud Application Studio Localisation toolkit (from help.sap.com)
John
Hello John ,
Thank You for your response.I managed to get BAI2 file, but when i am uploading it gives me conversion error . Can you guide on this. Also Cloud Application Studio Localisation toolkit which you mention , is it free to download ?
Can i do modifications in standard reports like adding our company logo, adding more fields on selection screen .
Thanks,
Nikita
SAP doesn't support the BAI2 file format import, so will need to create the import routine via the Cloud Application studio. This is not free, so contact you partner business manager to get a contract in place. when you have that let me know and I can share the "how-to" documents,
Regards
John
Hi Nikitanikhil,
There is a Business configuration setting> Automatically Generated Bank Statements activity>Assign Import formats for bank statements and
here you can add extra formats for the respective company(ISO20022 is a standardized xml format). Hope this will meet your requirement.
Best Regards,
Annapurna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
you just have to upload the bank statement which you received it from the bank. the bank statement should have the below items
1. opening balance
2. closing balance
3. total debit balance (if any debit transaction mentioned in the bank statement)
4. total credit balance (if any credit transaction mentioned in the bank statement).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.