Skip to main content

Notifications

Supply chain | Supply Chain Management, Commerce
Answered

Purchase Order Lines Import using Data Management Tool

Posted on by 55

Hi,

I am importing Purchase Order Lines using the Data Management tool. 

The import was able to run successfully without any errors as you can see on the screenshot below.

pastedimage1586263564555v1.png
When I check the PO to see if the lines were updated, only one line was updated on my PO and I am not sure what could be causing this. I am using procurement categories.

pastedimage1586263724702v2.png

  • Randz Profile Picture
    Randz 55 on at
    RE: Purchase Order Lines Import using Data Management Tool

    Hi Community,

    Thanks for your continuous assistance.

    After a lot of struggling, I managed to successfully import the PO lines.

    Resolution: I installed the hotfix from the quality update and do a full build and ensure correct column type and values for PO and line number and it worked.

  • Verified answer
    SouravDam Profile Picture
    SouravDam 11,721 on at
    RE: Purchase Order Lines Import using Data Management Tool

    Hello Randz KEV,

    Kindly find all the suggestions made on this thread and let us know if anything else is pending on this case or this is sorted out.

    Best regards,
    Sourav Dam

    Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

  • Verified answer
    Rahul Mohta Profile Picture
    Rahul Mohta 21,014 on at
    RE: Purchase Order Lines Import using Data Management Tool

    and as suggested earlier, pls install the hotfix from quality update and do a full build and ensure correct column type and values for PO and line number and it would work

  • Verified answer
    SouravDam Profile Picture
    SouravDam 11,721 on at
    RE: Purchase Order Lines Import using Data Management Tool

    Hello Randz KEV,

    Make sure that you have filled the LineNumber column in your "Purchase order line V2" data entity template.

    System will fetch all lines then and upload in the PO. Below is the screen shot taken from this template.

    1667.JPG

    Best regards,
    Sourav Dam

    Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

  • Verified answer
    Rahul Mohta Profile Picture
    Rahul Mohta 21,014 on at
    RE: Purchase Order Lines Import using Data Management Tool

    i had similar thread on forum and we found the answer lies something in Pu33 update,

    just build all, ensure MS packages and the error would go away

    if not then delete all staging data and do it again

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,188 Super User 2024 Season 2 on at
    RE: Purchase Order Lines Import using Data Management Tool

    Hi Randz,

    Can you go to the execution history and review the staging records? What values are in the staging table and what is the status per staging record?

  • Randz Profile Picture
    Randz 55 on at
    RE: Purchase Order Lines Import using Data Management Tool

    Hi Nikolaos,

    Please see a screenshot of the data imported. I have hidden all the fields with blank Data.

    pastedimage1586327939312v1.png

  • nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: Purchase Order Lines Import using Data Management Tool

    First of all, your screenshot shows that two purchase lines were created. No lines were updated.

    Second, could you share what data you imported? Perhaps you imported two purchase lines on different purchase orders?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,188 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans