MS Dynamics 365 Cross company reporting

Ayuushi Varma
Dec 8, 2020

In order to see data across all companies, in reporting, one assumes the below property in AOT query behind the report logic will do the trick:

Allow cross company Property

There’s more to what displaying the cross-company data in reports would take.

When one enables the above ‘Allow cross company’ property in AOT query and rebuilds it, it adds the company range in report query. The ‘allowCrossCompany’ method allows you to query in more than one company, but the query does not know in which companies to do so.
This can be achieved by adding ‘addCompanyRange()’ for each eligible company whose data you want to see.

addCompanyRange()

--

--

Ayuushi Varma

Working as Microsoft Dynamics AX technical consultant since 2018, Foodie and quirky Art person. Exploring the writing bug.