Import PO confirmation (header and lines) using data management

(0) Share

Report

Posted on by Rahul Mohta

21,032

Any suggestion on Importing PO confirmation (header and lines) using data management

when using to import error is thrown about ReadOnly=Yes for data entity

Also explored entity Confirming PO however no luck

I have the same question (0)

All responses (5)

Answers (3)

Verified answer

jannawangD365 on at

Like (0)

Report

Hi Rahul,

I would suggest you can submit a support ticket to Microsoft and request product team to make the two entities can be written.

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,734 Most Valuable Professional on at

Like (1)

Report

The data in these tables is a result of posting. If you imported data there, you would miss the whole posting. Is it really what you want?

You should rather import an order and post a confirmation in F&O.

Was this reply helpful? Yes No
Verified answer

AhmedHafez on at

Like (0)

Report

Hi Rahul,

"Purchase order confirmation Header" and "Purchase order confirmation lines" data entities support the view only "Export" . Insert / update / delete are not allowed . And there is no plan to change this behavior as confirmed with the PG because it does not make sense that you can modify such data, It is "historic" data generated by AX of the PO at the time of confirmation and you do not modify historic data.

Hope this covered your question

Was this reply helpful? Yes No
Rahul Mohta 21,032 on at

Like (0)

Report

Thank you Ahmed, Martin, Jananwang for your suggestions.

The business need is to import open PO from another system and while doing so only confirm select PO's which were confirmed in other system and capture additional details and leave other migrated PO's as it is

As there is volume involved, confirming PO one by one or using batch is not exactly fitting

custom confirmation is always an option however looking for all possible OOB

Was this reply helpful? Yes No
Suggested answer

Navneeth Nagrajan 2,373 Super User 2025 Season 2 on at

Like (0)

Report

Hello Rahul,

Just to add to what Martin and Ahmed said, in addition to the Purchase order header and line tables, you will have to consider the other tables like PurchParmTable and PurchParmLine. In addition to this, the Inventory tables too.

Question: Are you considering a cross company scenario here while importing the Purchase order tables.

Thanks,
Navneeth Nagrajan | Dynamics 365 Technical Consultant

Was this reply helpful? Yes No