Skip to Content
author's profile photo Former Member
Former Member

Bank Statement Import option

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Nov 20, 2007 at 06:49 AM

    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,

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 20, 2007 at 12:32 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.