Sage 100

2014 Premium. Created a UDF in the SO_ShipToAddress table. The first option is to map this udf to the sales order header. The second option is to join SO_ShipToAddress to SO_PickingSheetWrk. I don't see the ShipToCode as an available field in SO_PickingSheetWrk. The goal is to print this UDF on the picking sheet and then on the packing list. How can this be accomplished?

I would pull the UDF from the SO Header for the picking sheet..

And you can create a UDF in PickingSheetWrk that pulls from that SO Header UDF so you still don't have to link files.

The UDF originates in the SO_ShipToAddress table. How do I get the SO_ShipToAdress UDF to SO_SalesOrderHeader?

Here is a sample....

The SO_ShipToAddress UDF is ""Need Liftgate"" checkbox. They want this checkbox to pass through to the pick ticket and the packing list. It is a fixed value tied to the ship to location so they never change the value. They don't want to have to modify it during sales order entry. They just want it to display so it can be printed and passed to the invoice / shipping data entry / packing list.

@JeffSchwenk In what table does the UDF_Shipper originate?

I have a udf shipper field in both the Customer master and the ship to table which pull into the SO Header table. From there it goes to the Pickingsheet WRK table.

@JeffSchwenk What if there are 10 ship to locations for the customer and the value of the UDF is different for each ship to location?

The data is a MANUAL entry in the ship to table. It doesn't pull from anywhere. It is keyed. In my example, each ship to has a separate UPS shippers account number as does the customer master. The data will populate the SO based on which Ship to is selected. Field can also be overridden in data entry.

Got it working... I kept printing existing sales orders and the UDF values were not displaying. Created a new sales order and wholah it works. WTF... Thanks for your help.

@DougHiggs - if you change the Shipto on an old order and then change it back, it will start printing on those, too.

Great idea if you only have a few. If you have many, then a quick import will do the trick for you.