Notifications
Announcements
No record found.
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
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]
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?
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 664 Most Valuable Professional
André Arnaud de Cal... 522 Super User 2025 Season 2
Sohaib Cheema 303 User Group Leader