Bank Statement Import option

[Former Member]

Hai,

I am using SAP B1 2005 B PL :27

I have received a statement from bank in XLS format. Please let me know how can i import to SAP B1 for reconcilation purpose.

regards

Suresh S

[Former Member]

HI Suresh

You can upload bank statement through DTW.

Use bank pages template to upload the Bank Statement and use ref 3 for cheque no for automatic reconciliation option.

regards

kamlesh

[former_member186095]

Hello,

You could use payment engine addon, it is free and included in the product CD. The latest PL can be downloaded is PL 75.. Another way out is developing the UI/DI addon.

Actually there is a template to import process bank external statement that received from bank but some of the columns there can't be used. The template name is bankpages.you can also use that.

Rgds,

[Former Member]

Hi,

Thanks for the same. Please let me know from which menu i can import the XLS file received from Bank, so that it can be helpfull for reconcilation.

regards

suresh S

[former_member186095]

If you use addon bank payment, there is a button in the right corner bottom named bank file. you could use that. The addon provide cash and bank statement feature to allow you import bank statement too.

If you use the template I said, it means you use data tranasfer workbench.

Rgds,