Delete data from SAP Business One with DTW (Data Transfer Workbench)

Just a quick note: to delete data use '/' (backslash) in your template instead of the data. It will delete the content of the field. Note: you can delete data, you can't delete entire record from the database with DTW.

For example to delete the name of the customer, the template would look like this:

CardCode,CardName

CardCode,CardName

C001,/

C002,/

Uploading PaymentTerms with DTW and setup the defaults

Step 1, create the payment methods
Step 2, prepare a DTW file for the payment methods: CRD2 - BPPaymentMethods

Structure:
ParentKey, LineNum, PaymentMethodCode
CardCode, LineNum, PymCode
S001, 0, LLOYDS_CHQ
S002, 0, LLOYDS_CHQ
S003, 0, LLOYDS_CHQ
S001, 1, LLOYDS_GBP_BACS
S002, 1, LLOYDS_GBP_BACS
S003, 1, LLOYDS_GBP_BACS

Step 3, prepare a DTW file for to set up the default payments methods: OCRD - BusinessPartners

Structure:
CardCode, PeymentMethodCode
CardCode, PymCode
S001, LLOYDS_CHQ
S002, LLOYDS_GBP_BACS
S003, LLOYDS_GBP_BACS

The default payment method for supplier one (S001) will be Cheque, for the others (S002, S003) will be BACS.