web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Adding columns to Open...

Finance | Project Operations, Human Resources, ...

Answered

Adding columns to Open purchase order lines

(0) Share

Report

Report

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

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

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)

All responses Img

All responses (4)

Answers Img

Answers (2)

Suggested answer

Komi Siabi 13,019 Most Valuable Professional on at

Like (0)

Report

RE: Adding columns to Open purchase order lines

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.

Was this reply helpful? Yes No
AstridMalanka 8 on at

Like (0)

Report

RE: Adding columns to Open purchase order lines

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

Was this reply helpful? Yes No
Verified answer

BillurSamdancioglu 18,192 Most Valuable Professional on at

Like (0)

Report

RE: Adding columns to Open purchase order lines

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.

Was this reply helpful? Yes No
Verified answer

huijij 19,811 on at

Like (0)

Report

RE: Adding columns to Open purchase order lines

Hi AstridMalanka,

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

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Responsible AI policies for the Community

Quick Links

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

#1

Sohaib Cheema 665 User Group Leader

#2

Martin Dráb 595 Most Valuable Professional

#3

Yng Lih 558

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans