Skip to Content

Updating CreditLine on SAP Business One HANA using DTW

Hi SAP B1 experts,

I need to update the field "CreditLine" on SAP Business One using DTW with empty value. I tried to use 0 value but it wasn´t work. B1 understood it was a new credit limit $ 0,00. So, every new transaction show up the warning about credit limit.

Any idea how to fill up this field at the OCRD DTW template?


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Mar 04, 2019 at 07:00 AM

    Hi Francis,
    I think there is a work around for this, you can fill up this field through DTW by following the steps:

    1. Once the DTW template is ready to import select the complete column "CreditLimit" and then right click.

    2. Select on Format Cells under the Numbers Tab select the Text.

    3. Now save it as .csv file format and then try to import.

    Hope it works for you.


    Vedanth M

    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.