Skip to main content
Question

Dependent parameter between Sales Order and Shipment?

  • November 20, 2025
  • 3 replies
  • 61 views

Forum|alt.badge.img

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?

3 replies

bwhite49
Captain II
Forum|alt.badge.img+10
  • Captain II
  • November 20, 2025

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.


mohammadnawaz51
Jr Varsity I
Forum|alt.badge.img+4

@jamest62 Can you explain about the issue?


Acumatica provides a relational mapping through standard tables:
 

SOOrder → SOOrderShipment (OrderType + OrderNbr)

SOOrderShipment → SOShipment (ShipmentType + ShipmentNbr)
 

SOShipment → SOLine via SOShipLine (OrigOrderType + OrigOrderNbr + OrigLineNbr)