ACTION: Set Field Value 1
CONDITION
Vendor = Vietnam Vendor
PARAMETERS
Field = VN - Expected Ship Date
Formula = to_date{trandate}+40
This is to automatically calculate the VN - Expected Ship Date of purchases made in Vietnam, i.e. 40 days from transaction date.
ACTION: Set Field Value 2
CONDITION
Vendor = Vietnam Vendor
PARAMETERS
Field = US - Expected Receipt Date
Formula = to_date{trandate}+65
This is to automatically calculate the US - Expected Receipt Date of purchases made in Vietnam, i.e. 65 days from transaction date.
YOU ARE READING
SQL
Non-Fictionworkflows - saved searches - custom fields - advanced pdf/html - and whatnot
