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
-
The next frontier of workforce planning: from forecasting to AI usage and Credit Estimation
AI is transforming workforce planning in Dynamics 365, where intelligent agents now execute core service tasks and contribute directly to business outcomes. -
Copilot Cowork: From conversation to action across skills, integrations, and devices
Today, we’re announcing additional capabilities in Cowork to expand on what it can make possible for you. -
Driving empathetic customer conversations with Email Sentiment
Email Sentiment in Dynamics 365 Customer Service brings emotional context into the email workflow, helping representatives understand customer tone, respond with empathy, and reduce escalations from the first reply.
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.
