What is the easiest way to populate a UD field in the ShipDtl table from the OrderMsc table without using custom code? I have tried a BPM using the Fill table by query but am having a hard time getting the two to bind. Any suggestions would be appricated.
Thanks!
The easiest way, DMT. (it’s not real time though)
The real question, is do you really have to? If you have to do the lookup to copy it, why not just look it up when needed? I’m sure some more context would help answer that question.
I can give you an example of when I’d like a copy of the data in a packer, instead of just a reference.
Our products get shipped to construction sites. Often not even a real postal address. Something like “Mile 124.8 of Rt 66…” Or “Logging Rd 102”. So sometimes the ShipTo for a customer will be “tweaked” between shipments. Since the Packer only knows the CustNum and the ShipToNum, reprinting a packer after the tweak, would result in something different.
Or if we run a report, we need to know the address the packer used, not current address the shipto references.
I came “this close” to having to implement a BPM to capture the address at the time of shipment.