Skip to main content

Notifications

Supply chain | Supply Chain Management, Commerce
Answered

Purchase Order Lines

Posted on by 55

Hi Community,

I am attempting to import purchase order lines using the Data Management Tool and I am receiving the below error.

Results. Project fields cannot be updated for lines which are delivery note updated, invoice updated or invoice matched.
Results. validateWrite failed on data source 'PurchLine'

I am not sure what the above error means. I successfully imported the purchase order headers using the data management tool, however, the purchase order lines are giving me an error.

Kind Regards,

  • RE: Purchase Order Lines

    Hi Randsz,

    How is the importing going? What else we can help?

  • Verified answer
    Rahul Mohta Profile Picture
    Rahul Mohta 21,014 on at
    RE: Purchase Order Lines

    pls remove all category values in your import

    the error msg is suggesting unmatched values for category

  • Randz Profile Picture
    Randz 55 on at
    RE: Purchase Order Lines

    Hi,

    Thanks for your continuous assistance.

    After I have suppressed the business validations on entity structure, I managed to import the purchase order lines. However, when I check from the front-end, the POL lines are not updated on the PO.

    pastedimage1585812683873v1.png


  • Randz Profile Picture
    Randz 55 on at
    RE: Purchase Order Lines

    Hi,

    I tried to suppress business validations on entity structure and now getting a different error. See visuals below;

    pastedimage1585731720226v1.png

  • Randz Profile Picture
    Randz 55 on at
    RE: Purchase Order Lines

    Hi

    The number sequence is set up to allow manual. See the visuals below and I am still getting the same error even when the number sequence is set to manual

    pastedimage1585729147354v1.png

  • Suggested answer
    Rahul Mohta Profile Picture
    Rahul Mohta 21,014 on at
    RE: Purchase Order Lines

    you may have published your entity in a BYOD project, first remove entity 'purchase order lines V2'

    delete the data entity and then add if back

    also try to suppress business validation on entity structure and suggest

  • RE: Purchase Order Lines

    Hi Randz,

    for the new error, is it because you have number sequence setup for purchase order? and the number sequence is set as 'not allow manual'?

  • Randz Profile Picture
    Randz 55 on at
    RE: Purchase Order Lines

    Hi Andre,

    I am using the latest version - purchase order lines V2.

    I also tried to regenerate the field mapping for this entity and I am still getting the error below when I try to import purchase order lines.

    pastedimage1585682938491v1.png

  • Randz Profile Picture
    Randz 55 on at
    RE: Purchase Order Lines

    Hi Rahul

    I was not able to delete the data entity, see the error on the screenshot below:

    pastedimage1585682256811v2.png

    I followed your instructions without deleting the entity and after refreshing the entity list I got the below error when trying to import purchase order lines:

    pastedimage1585682194272v1.png

    Thanks for your continuous help

  • Suggested answer
    Rahul Mohta Profile Picture
    Rahul Mohta 21,014 on at
    RE: Purchase Order Lines

    suggest if our responses helped and on using latest entity with regenerating target mappings problem could resolve

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