Is there an existing depency between the sales order and the related shipments for that sales order? I would like to pick the sales order number then pick the shipment number.
Or is this a custom table?
Solved
Dependent parameter between Sales Order and Shipment?
Best answer by bwhite49
SOOrderShipment has both the Order Nbr and the Shipment Nbr. You can also connect SOLine to SOShipLine though the order nbr and order type fields.
+12SOOrderShipment has both the Order Nbr and the Shipment Nbr. You can also connect SOLine to SOShipLine though the order nbr and order type fields.
Translate
+8
Translate
Acumatica provides a relational mapping through standard tables:
SOOrder → SOOrderShipment (OrderType + OrderNbr)
SOOrderShipment → SOShipment (ShipmentType + ShipmentNbr)
SOShipment → SOLine via SOShipLine (OrigOrderType + OrigOrderNbr + OrigLineNbr)
Translate
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.