Setting OrderHed/Rel ShipVIACode on EDI Import

,

This is my goto post for edi data fixing.

If you look at the chart there you can fix the shipvia before it gets to demand entry with a base directive on ImportEDIb4Val. I made one in widgets for this. Two variables, CustNum and ShipTo

image

expression for shipto


expression for custnum
image
image
expression for set field

Db.ShipTo.Where(w => w.CustNum == CustNum && w.ShipToNum == ShipTo).Select(s => s.ShipViaCode).FirstOrDefault()
1 Like