Import shipments with order that has multiple lines

You're working on an Acumatica Import Scenario to create shipments and add multiple lines using the "Add Sales Order" dialog, but it's not selecting all the lines or saving the shipment correctly.

From your screenshots and description, it seems the issue lies in the order of execution and the use of dialog field actions when importing multiple lines.

✅ Key Fix Areas

1. Ensure “Selected” Checkbox is Toggled for Each Line
   • In your import scenario, you must repeat the Selected = true action for each line.
   • If you're importing multiple lines from a source file, ensure your data source has one row per shipment line and map the Selected field with a value of 'true'.
2. Line Navigation Logic
   • You may need a field (like Line Number = -1) to move to the next line for each row.
   • Make sure this is done before setting Selected = true.
3. Commit and Execute Action Properly
   • The Dialog Answer = OK must be set to commit after selecting lines, triggering the dialog to add them.
4. Insert Order of Steps
   Double-check this sequence in your import scenario:

pgsql CopyEdit

- Shipment Summary -> Key: ShipmentNbr

- Shipment Summary -> Action: Add Order

- Add Sales Order -> OrderNbr (set order number)

- Add Sales Order -> <Line Number> = -1 (navigate line)

- Add Sales Order -> Selected = true (for each row)

- Add Sales Order -> Dialog Answer = OK (trigger add)

- Shipment Summary -> Action: Save

✅ Sample Field Mapping Order (One Line Per Row in Excel/CSV):

If you have multiple lines per order, ensure each one is in a separate row in your source data with the same shipment number and order number, so Acumatica loops through them.

Additional Tips:

• Use the “Show All Commands” view to see if any required fields are missing.
• If you still have issues, enable tracing (Tools > Trace) and try the manual process again to see what actions are executed by Acumatica and mirror those in your import scenario.

Would you like a sample Excel template and import scenario XML file for this use case?

Hi ​@iqraharrison were you able to find a solution? Thank you!