If you synchronize your customer DB from AOT to SQL server DB and you should receive the following message: cross-company “union all” query cannot contain both a company specific table and a global table unless the data area field is explicitly selected” when synchronizing view DirPartyView then check out this:
Open the view DirPartyView in AOT and check table properties for all corresponding tables. Have a specific eye on the table property: “Save data per company” if this might have been changed during customization. If that is the case then change it back to its original value and make sure that you do not have duplicate records in tables.
Related Content
-
Dynamics 365 sets the bar for agentic sales qualification on new benchmark
Announcing the Microsoft Sales Bench—a new collection of benchmarks designed to assess the performance of your AI-powered sales agents. -
Transforming how organizations run rental operations with Dynamics 365 ERP
Rental operations succeed when every handoff–from quoting to return–is coordinated and timely. -
Beyond Retrieval: How an Agentic Approach Transforms Microsoft Dataverse Search
Leveraging recent breakthroughs in agentic AI, the new system delivers answers that are more relevant, contextual, and accurate to your specific business data.
Get started with Dynamics 365
Drive more efficiency, reduce costs, and create a hyperconnected business that links people, data, and processes across your organization—enabling every team to quickly adapt and innovate.
