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 :
Finance | Project Operations, Human Resources, ...
Suggested Answer

While importing purchase order lines in D365 fno out of 10 line only last line is coming in system

(0) ShareShare
ReportReport
Posted on by 100

Hello Everyone,

I am trying to upload purchase order lines(10 items), while uploading it was sucessfully uploaded and 10 lines showing in staging with 0 errors.

pastedimage1627903520858v1.png

But actually, it is  showing only one item(last line) in Purchase order:

pastedimage1627903339437v2.png

Please suggest if anyone of you has faced this type of issue before?

Kind regards,

PSoni

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    301,053 Super User 2025 Season 2 on at

    Hi PSoni,

    What columns and values do you have in your source file? Can you tell if the Line Number is different per order line in the source file?

  • PSoni Profile Picture
    100 on at

    Hi Andre,

    columns are :

    PURCHASEORDERNUMBER LINENUMBER DEFAULTLEDGERDIMENSIONDISPLAYVALUE DELIVERYADDRESSCOUNTRYREGIONID DELIVERYADDRESSCOUNTRYREGIONISOCODE DELIVERYADDRESSDESCRIPTION DELIVERYADDRESSLOCATIONID DELIVERYADDRESSNAME ITEMNUMBER LINEAMOUNT LINEDESCRIPTION ORDEREDPURCHASEQUANTITY PROCUREMENTPRODUCTCATEGORYNAME PURCHASEPRICE PURCHASEPRICEQUANTITY PURCHASEUNITSYMBOL RECEIVINGSITEID RECEIVINGWAREHOUSEID REQUESTEDDELIVERYDATE SKIPCREATEAUTOCHARGES VENDORINVOICEMATCHINGPOLICY

    And yes the line number is different: 1,2,3,4,5,6,7,8,9,10.

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    14,679 Super User 2025 Season 2 on at

    Hi PSoni

    Can you check staging table on DMF or 'Purchase orders' to see if one purchase order is created for each line? Ref. to your last screenshot, the purchase order just have line number 10 while it should have 10 lines.

    If you use "Excel" as 'Source data format' for import, you need to use the same Purchase order number for each line:

    pastedimage1628002679842v1.png

    I have used the following fields for import and it works fine. I have used the same Purchase order number for each line:

    PURCHASEORDERLINECREATIONMETHOD;PURCHASEORDERNUMBER;LINENUMBER;ITEMNUMBER;RECEIVINGSITEID;RECEIVINGWAREHOUSEID;PURCHASEPRICEQUANTITY;PURCHASEPRICE

    pastedimage1628002949692v2.png

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 559 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans