For UPS WorldShip where do I grab the ShipMethod for a sales order?

Posted By ebcg over 5 years ago

Does anyone have a recommendation of where I can tell UPS to pull the ship method for a sales order?

UPS wanted to use the tsoSalesOrder.DfltShipMethKey, but we noticed that wasn't the correct ShipMethod imported from EDI. Once a shipment was generated there is a ShipMethKey in tsoShipment that was the accurate ship method. I can't use the table tsoShipment to get the ship method because we batch commit and no tsoShipment table exists at time of UPS scanning an order. I contacted sage and they couldn't help me figure out where this ShipMethKey is coming from. Any ideas?

0 Ramon M. over 5 years ago

I believe when a sales order is created, the default ship method comes from the customer class.

Also, if a shipment is in play at the time, did you check tsoPendShipment? tsoShipment contains posted shipments.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 ebcg over 5 years ago in reply to Ramon M.

We don't post our shipments until after they are scanned by UPS or Fedex for shipping. I checked tsoPendShipment but ShipMethKey was null. We use MAPADOC to import our EDI sales orders and I'm not sure where the correct ship method is going that is then fed into tsoShipment.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 JohnHanrahan over 5 years ago

Did you check the ShipMethKey in tsoSOLineDist? Sales Orders support multiple ship methods by line so this should be accurate as long as you don't change the ship method once the SO is imported.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 500

For UPS WorldShip where do I grab the ShipMethod for a sales order?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING