Showing posts with label Data update. Show all posts
Showing posts with label Data update. Show all posts

Wednesday, 30 September 2015

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.