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
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.
Thanks for the answers, but I still don't understand how to add columns to the exported excel, or before I export.
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.
Hi AstridMalanka,
You can export the data with clicking 'Purchase order lines',You will see that all the fields are retrieved.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,802 Super User 2024 Season 2
Martin Dráb 229,129 Most Valuable Professional
nmaenpaa 101,154