Create a view on a virtualized table AX 2012

(0) Share

Report

Posted on by sreenig

Hi,

VendTable is virtualized and when I try to create a view joining the dirpartytable, logisticspostaladdress I am getting records for all the legal entities in the result set. How can I get the view to display only one record?

Thanks,
Sreeni

I have the same question (0)

All responses (2)

Answers (0)

Blue Wang on at

Like (0)

Report

Hi Sreenig,

Views in Microsoft Dynamics AX 2012 are basically virtual tables.

So, You can create a view instead of a VendTable and then create a second view nesting.

[View:https://docs.microsoft.com/en-us/dynamicsax-2012/developer/how-to-create-a-view-based-on-tables-or-other-views:750:50]

Was this reply helpful? Yes No
André Arnaud de Cal... 300,915 Super User 2025 Season 2 on at

Like (0)

Report

Hi Sreeni,

I do assume you mean to say that the VendTable has been shared via a virtual company? If so, there should be only one record per vendor. If the sharing was created after go-live and data did exist in the VendTable per company, this might not be cleaned up properly.

Can you provide some more information where and how you created the view?

Was this reply helpful? Yes No