Skip to Content

SAP B1, to delete 0.00 in credit limit under BP master data through DTW?

is it possible to delete '0.00' credit limit under BP master data via DTW?

we set up the system and the default value was '0.00' for thousands of customers.

now we need to apply credit limit.

or is it possible to delete '0.00' value via a query?

Thank you.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Feb 14, 2019 at 09:40 AM

    Dear Stephen,

    Try Uploading your BP master credit limit with this '\' (forward slash), So whatever the values in this field will be clear out.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Dinesh. I use SAP B1 9.3 version.

      I tried but DTW said:

      1 Update Failed C10001 CServiceData::SetPropertyValue failed; Value must be numeric in property 'CreditLimit' of 'BusinessPartner'oBusinessPartners.

      This is what I uploaded.

      CardCode CreditLimit MaxCommitment CardCode CreditLine DebtLine C101 \ \

  • Posted on Feb 18, 2019 at 02:25 PM

    Dear

    you can update some value here like 100,1000 but if you are talking about to remove 0.00 and keep this field as blank you cannot do this because its numeric field and 0.00 is default value

    Add a comment
    10|10000 characters needed characters exceeded