Supply chain | Supply Chain Management, Commerce

Linking sales orders and purchase orders via data entity import

(2) Share

Report

Posted on by Mica

Hi all,

On a sales order header you have a button to create a new purchase order (see my screenshot) For datamigration purposes I need to replicate this behaviour via data management imports, but I don't know how to do that.

On the data entities for purchase orders and purchase order lines I can't find any fields that reference a sales order and vice versa.

Any thoughts on how to do this?

Categories:

Dynamics 365 Supply Chain Management

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

André Arnaud de Cal... 304,711 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Mica,

The data entities are not supporting the direct delivery feature out of the box. This will require a customization. You can e.g. think of an action that creates a PO from a created SO. You can read more about OData actions on my blog: Let your Operations Flow – Part 8 - Dynamicspedia

Was this reply helpful? Yes No
Suggested answer

Sagar Suman 6,775 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi

The relationship of the reference is stored in separate tables and are not exposed to sales and purchase export/import entity.

You can check in the back end and see if you can update this reference using custom logic. It is not possible to be updated from front end as its system updated data.

Was this reply helpful? Yes No
Suggested answer

Syed Haris Shah 1,666 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @Mica,

The “Create purchase order” button on the sales order header doesn’t just insert PO records, it triggers application logic in D365 that links sales orders and purchase orders.

Standard DMF entities for purchase orders and sales orders don’t expose these cross-reference fields, which is why you don’t see them.

For data migration, you have these options:

Import SOs and POs independently and use Customer Reference field to put PO number for tracking.

Or, if you need the exact same behavior, build a custom migration process that calls the same framework as the UI button.

If you find this answer helpful, please consider verifying the answer. 👍

Regards,

Syed Haris Shah

Was this reply helpful? Yes No