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