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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Adding columns to Open...
Finance | Project Operations, Human Resources, ...
Answered

Adding columns to Open purchase order lines

(0) ShareShare
ReportReport
Posted on by AstridMalanka 8

Hello,

When I look at the page that has the Open purchase order lines I can add the vendor account column 

<$link>/?cmp=20CA&mi=PurchLineOpenOrder

pastedimage1661372296691v1.png

but when I try to do an export (the one that connects with odata and writes back to the system) 

pastedimage1661372357104v2.png

I cannot seem to add the vendor column. I tried adding tables on the excel, but I am not sure how to join them.

How can I do it?

thanks

I have the same question (0)
  • Verified answer
    huijij Profile Picture
    huijij 19,811 on at

    Hi AstridMalanka,

    You can export the data with clicking 'Purchase order lines',You will see that all the fields are retrieved.

  • Verified answer
    BillurSamdancioglu Profile Picture
    BillurSamdancioglu 19,698 Most Valuable Professional on at

    For to add a field to open in excel or export to excel, You have to use data management tool. And add to the entities. If you would like to export data, You can use export to excel button.

  • AstridMalanka Profile Picture
    AstridMalanka 8 on at

    Thanks for the answers, but I still don't understand how to add columns to the exported excel, or before I export.

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

    Hi AstridMalanka,

    We have data entities which has a set of predifined field that can only be modify by a developer, reason why you couldn't add an extra field after the Open in excel action. However, we the export to excel option, you can firstly personalize your grid to insert extra column.

    To personalize, you can right click on the grid then do, Insert colunms.

    PurchlineExport.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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
Martin Dráb Profile Picture

Martin Dráb 683 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 398 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans