Importing Bank statements

[Former Member]

HI

Can bank statements can be imported for Indian localisation in SAP B1 8.8 PL13?

Any help is appreciated.

[Former Member]

Hi

Thank you so much

[Former Member]

if you got any issue reply same.

Thanks

manvendra

[Former Member]

Hello,

Try this .... i

Steps for Bank Reconcilliation Statement

1) Select check (Install Bank & Statement Processing) in company detail form.

2) Fill the house bank informaion on the same window.

3.After that need to installed BTHF add-on from Add-on Administration window for activation of import option on Bank statement process form(in Banking Module.

4.Need to install FD (Formate Definination) from same form by use this add-on we make bank format(indian bank format in SAP.

After made this format then it should be assign to house bank account level.

Administration>Setup>Banking>House bank Account and select column (import file Name) then new window will appear from this window we can make new file formate after filled relavent info (format name (SAP_TEST),formate Type(Bank Statement)).

After that assign to file format(.bfp) which made by another Add-on(FormatDefination).

click on the row which was added as file format name

After select correct file name update the file format setup form

Here we assign file format to house bank account

For Mapping on the basis of Amount :-

Now here make Internal code which will link with external code(which provided by bank ) this code will use at the time of Bank Statement Summery this code also identify that which type of posting method used at the time of bank statement processing(i.e. BP from/to Bank Account, G/L Account from/to Bank, Interim Account from/to Bank Account etc.)

Adminstration>Setup>Banking>Bank Statement Process> Internal Bank Operation Code

Administration>Setup>Banking>Bank Statement Process> External Bank Operation Code

Banking>Bank Statement And external reconciliation>Bank Statement Process form(When we click on Import from file button then here we select Bank Statement file for processing

) After successfuly import the bank statement file it show as draft document.

If we want to finilize the bank statement then double click on same draft row then new window will appear

When we import bank statement in SAP then if party have any open invoive either A/P or A/R it should be reflect for making incomming or outgoing payment. Its totally depends on which type of posting method user have mapped.

After that SAP user can adjust or reconcile all bank transaction. If user double clicks on row then new window again open for adjustment.

.

Thanks

Manvendra

Edited by: Manvendra Singh Niranjan on May 13, 2011 4:13 PM

[Former Member]

HI

your suggestion is very helpful but i want to how to convert the format using the format definition addon....I am new to this...

Please guide....

[Former Member]

Hello,

Try this

First you should installed FD add-on which is available in Add-on Administration.

After installation select Tool option in menu bar there are new open available call format definition form .

form here you can make new format according to bank.

OR

For existing format goto Administration>Setup>Banking>House bank Account > and select last column import file name.

then find the existing open ,again open new form, select new option >finally you reach File format setup form.

now right click on row level there is a option download file format.

so now you can easily modify existing format in FD add-on selecting file format(.bfp).

when you will make new format(.bfp) then locate house bank account.

It is very difficult to explain but i will try my best.....

Thanks

Manvendra

[Former Member]

HI

Done it...Thanks for ur valuable explanation....thank u