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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Error when importing Purchase order lines

(0) ShareShare
ReportReport
Posted on by 346

Hi All,

When importing purchase order lines using the data entity Purchase order lines V2,  i am facing this error:

Results. Field 'Currency' must be filled in.
Results. Field 'Group' must be filled in.
Results. validateWrite failed on data source 'PurchLine (PurchLine)'

pastedimage1662381414545v2.png

I created the Purchase order header manually and it has all the other detail. How can i make the lines to default the Group and currency fields from the PO header?.

Please assist

Kind regards,

Alexio

I have the same question (0)
  • Suggested answer
    BillurSamdancioglu Profile Picture
    21,018 Most Valuable Professional on at

    Entity purpose is, you only upload data.

    You may need to change the entity. Komi Siabi  have any idea how to change?

  • Alexio Pfumai Profile Picture
    346 on at

    Thank you Billur for your response,

    do you know the data entity that i should use to import the purchase order lines?

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    15,001 Super User 2026 Season 1 on at

    Hi Alexio,

    Do you want to import PO line related to project?

  • Suggested answer
    BillurSamdancioglu Profile Picture
    21,018 Most Valuable Professional on at

    Hi,

    Purchase Order lines V2 is the correct one for OOB.

  • Suggested answer
    Komi Siabi Profile Picture
    13,218 Most Valuable Professional on at

    Hello,

    Try CDS purchase order line entity

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    15,001 Super User 2026 Season 1 on at

    Does the vendor have required setup? How about the PO?

    Please check the PO header if it has valid information for "Currency".

  • Suggested answer
    RSK - Raheel Shakeel Khan Profile Picture
    55 on at

    Vendor group is not valid as per vendor account check this, and currency should be filled in template the one which is in purchase order header

  • André Arnaud de Calavon Profile Picture
    305,301 Super User 2026 Season 1 on at

    Hi Alexio,

    What exact columns and field values do you have in the source file?

  • Community Member Profile Picture
    on at

    Hi ALEXIO PFUMAI,

    Did you export the purchase order lines v2 entity successfully from Data management, did you export it through excel add-on or did you created the data entity sheet manually?

    Regards,

    Ammad Jawed

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 587

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 552 Super User 2026 Season 1

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 542 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans