Skip to main content

Notifications

Announcements

No record found.

Supply chain | Supply Chain Management, Commerce
Answered

Purchase Order Lines

(0) ShareShare
ReportReport
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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans