Skip to Content
0
Former Member
May 12, 2010 at 12:10 PM

Using DTW to delete data from a field

1524 Views

Hi Experts,

I would like to know if it is possible to use DTW to delete data from a field in SAP B1? I would like to blank the VAT Code and Name field from the Tax tab of the Business Partner Master Data.

I have been trying to delete the data by changing the VAT Liable field to 'Liable' (or 'Y' on the DTW text file) and leaving the VatGroup field blank, but I am getting an error message in DTW.

[OCRD.ECVatGroup], Invalid tax group '100072'Application defined or object-defined erroroBuysinessPartners

This is following an import looking like this:

RecordKey CardCode VatLiable VatGroup

RecordKey CardCode VatLiable VatGroup

1 100072 Y

2 100073 Y

I require the VatGroup to be blank so that Sales Order follow the default behaviour of picking up the tax code of the item so that we can sell non vatable items like childrens clothing.

Regards

Jon