web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Answered

Purchase Order Lines import error

(0) ShareShare
ReportReport
Posted on by 57
I have the same question (0)
  • Suggested answer
    Christoph Thaler Profile Picture
    5,442 on at

    Hi Randz.

    In the purchase order line you will find some project related fields. Based on the error msg. I assume you have filled these fields in your Excel file. May you please check it?

  • André Arnaud de Calavon Profile Picture
    300,911 Super User 2025 Season 2 on at

    Hi Randz,

    Can you indicate what information you provided for the purchase order lines? What columns with what values?

    Did you also import the purchase order header?

  • Suggested answer
    Rahul Mohta Profile Picture
    21,032 on at

    project ID and project category and activity number are some fields on PO lines

    since your PO is linked to a project, need to provide them

    easiest way is to to export one of the PO line with project and note project related fields and then use the same in next import

  • Randz Profile Picture
    57 on at

    Hi,

    The information I have populated on the purchase order lines import template is only on the below columns. The rest of the columns I left blank.

    PURCHASEORDERNUMBER

    LINENUMBER

    DEFAULTLEDGERDIMENSIONDISPLAYVALUE

    LINEAMOUNT

    LINEDESCRIPTION

    ORDEREDPURCHASEQUANTITY

    PROCUREMENTPRODUCTCATEGORYNAME

    PURCHASEPRICE

    PURCHASEPRICEQUANTITY

    PURCHASEUNITSYMBOL

    RECEIVINGSITEID

    RECEIVINGWAREHOUSEID

  • Randz Profile Picture
    57 on at

    Hi Rahul,

    My PO is not linked to project. That is why I am suprised I am getting this errors.

  • Randz Profile Picture
    57 on at

    Hi Christoph.

    I did not populate any project related field. See my reply on this post for the fields I populated on the file.

    Thank ypu,

  • Randz Profile Picture
    57 on at

    Hi Andre,

    Please see my reply to this post for the fields I populated on the file.

    Thank you,

  • Suggested answer
    Rahul Mohta Profile Picture
    21,032 on at

    could you share the exact error message and visual?

    even though PO lines are being imported, quite possible PO header might be linked to a project

    could you confirm with visual of PO header

  • Randz Profile Picture
    57 on at

    Hi Raul,

    Please see below screenshots of PO Header.

    pastedimage1585309377604v1.png

    pastedimage1585309397021v2.png

  • Suggested answer
    Rahul Mohta Profile Picture
    21,032 on at

    i think it is to do with change management, could you pls disable and try and suggest

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Siv Sagar Profile Picture

Siv Sagar 283 Super User 2025 Season 2

#2
Laurens vd Tang Profile Picture

Laurens vd Tang 213 Super User 2025 Season 2

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 152 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans