Updating CreditLine on SAP Business One HANA using DTW

[former_member596410]

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?

Cheers!

[former_member261836]

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.

Regrads,

Vedanth M