Skip to main content

Notifications

Supply chain | Supply Chain Management, Commerce
Answered

Import PO confirmation (header and lines) using data management

(0) ShareShare
ReportReport
Posted on by 21,014

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

  • Suggested answer
    Navneeth Nagrajan Profile Picture
    Navneeth Nagrajan 1,407 Super User 2025 Season 1 on at
    RE: Import PO confirmation (header and lines) using data management

    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

  • Rahul Mohta Profile Picture
    Rahul Mohta 21,014 on at
    RE: Import PO confirmation (header and lines) using data management

    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

  • Verified answer
    AhmedHafez Profile Picture
    AhmedHafez on at
    RE: Import PO confirmation (header and lines) using data management

    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

  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 230,817 Most Valuable Professional on at
    RE: Import PO confirmation (header and lines) using data management

    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.

  • Verified answer
    RE: Import PO confirmation (header and lines) using data management

    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. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,817 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans