Help Centre Forum

TOTECS Forums

When using the Micronet Data.Connect Sales - Header import routine, can you set conditional switches for field mappings such as payment type so that a credit card payment can be allocated as a credit against the debtor account?
Author
Thread
Author Glenn Drew
30th June 2015
Micronet have customised the Data.Connect Micronet Sales - Header routine for our client in version 2.7 so that a credit card payment can have the credit applied to the order. Micronet advised that we can set the DIL_PAYMENTTYPE to a payment type (Ie. 5) setup in the company settings -> Payment Types. The TOTECS Connector Micronet Adapter creates a CSV file where one of the fields is the payment type with values 'credit', 'account' etc. If the field value is set to 'credit' we need to switch to a value of 5 when imported into the DIL_PAYMENTTYPE field and a empty string for all other values. Is there a way to set a conditional check of the incoming field data and switch it? Ie, If 'credit' then set DIL_PAYMENTTYPE=5 else empty string
TOTECS CEO