Finance | Project Operations, Human Resources, ...

Add Legal entity (company) to Vendor Grid

(0) Share

Report

Posted on by MohammadBB

325

Hi Community,

Is there anyway to add Legal Entity to Vendor Page grid (Or any other grid that is Legal Entity aware) by the "Add column" Feature, and without development?

Thanks

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

André Arnaud de Cal... 301,171 Super User 2025 Season 2 on at

Like (0)

Report

Hi Pop,

This is not possible. The system field 'DataArea' is not available for selection. This probably because the current active legal entity is already visible on the top bar in the application.

Was this reply helpful? Yes No
Sukrut Parab 71,710 Moderator on at

Like (0)

Report

As Andre mentioned its available at the top right corner , so whats the reason behind adding it in the grid ?

Was this reply helpful? Yes No
MohammadBB 325 on at

Like (0)

Report

Well the users want to export the grid and want to have the legal entity also as a column in the exported excel. I mean of course we can develop something to do it but it seems to me we should be able to do it without coding.

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

what's your purpose, one always open vendor master from a legal entity which is in the URL and in the top right corner

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Pop,

Is this really needed?

If your users export data through the grid, they should know what company they are in, right?

Or did I overlook/miss something?

Best regards,

Ludwig

Was this reply helpful? Yes No
MohammadBB 325 on at

Like (0)

Report

Well, My users want to add the legal entity to any grid and then export the custom grid for some legal entities but I guess given adding a system field like 'DataArea' to grids is not possible they have to manually add it in the exported excel file.

Was this reply helpful? Yes No
Sergei Minozhenko 23,093 on at

Like (1)

Report

Hi Pop,

If it helps you, you can open vendors in Excel and add company column there.

Was this reply helpful? Yes No
Suggested answer

SouravDam 11,730 on at

Like (0)

Report

Hello Pop,

Simply use Open in excel feature in 'All vendors' form.

Once the excel is generated the data, click on Design and edit the Vendors V2 entity table. Double click on "dataAreaId - Company" to make this available from "Available fields" to "Selected fields" section.

Then click on Update > Yes > Done > Refresh > Yes.

You will find the Company column is added in the excel.

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

Was this reply helpful? Yes No