Wednesday, June 26, 2024

How to use crosscompany in Query in D365 F&O | X++

Sometimes, we receive requirements to fetch data across all legal entities. In such cases, cross-company functionality can be utilized. Below is an example demonstrating this approach     

Query query = new Query();

QueryBuildDataSource queryBuildDataSource;

QueryBuildRange queryBuildRange;

queryBuildDataSource = query.addDataSource(tableNum(InventLocation));

query.allowCrossCompany(true);


This query will return all warehouses across legal entities. 


No comments:

Post a Comment