Some of our Sales Orders qualify for a Promotion. I need to record data in the Sales Order table to keep track of this. This data does not relate to a Customer, Vendor or Item.
I tried to use CustomField3 (I use CustomField1 & 2 to track some Customer info on the Sales Order) but after OpenSync runs, CustomField3 becomes NULL again.
Is there any way to persist data in a column in the Sales Order table? I have already ‘hi-jacked’ any unused fields available such as FOB and Other to store other information.