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
-
Build custom commerce experiences with Dynamics 365 Commerce
Microsoft Dynamics 365 Commerce provides a composable, API-first architecture that separates the experience layer from the commerce engine. -
Accelerate your move to agentic business applications with Dynamics 365 Activate
Don’t let legacy applications hold back your adoption of innovation Organizations around the world are exploring how AI and agents could redesign and transform their critical business processes. -
Workforce management meets AI: WEM MCP tools for Dynamics 365 Service Agent
Workforce Engagement Management (WEM) MCP tools for Dynamics 365 Service Agent bring workforce actions into Copilot, Microsoft Teams, and Outlook.
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.
