3,352
Hello,
please let me know if we can design a report which can fetch data from two legal entities and display. Like we have posted general journals in two legal entities and now in a custom report I want to fetch the amount and voucher in two columns respectively, is it possible
*This post is locked for comments
Hello Blue Wang, thank you, will try this
Hello Dr. Ludwig, I want to get the monthly expenses posted in two entities using general journals. the two legal entities have the same COA and the report should show the expense. But these cannot be treated as operating units or using dimension, they have to be separate entities
Hello Satish, thank you I will try this
Hello Dr. Ludwig, thank you, I will try in MR
Hi Naveen,
You can refer : https://docs.microsoft.com/en-us/dynamicsax-2012/developer/cross-company-reports-in-the-aot
Such as cross Legal Entites to run vendor ageing reports, you should use ChangeCompany in the VendAgingReportDP class method processReport.
Share
Report
All responses (
Answers (
CompanyName nameOfCompany;
TableName contractCompany;
;
while select contractCompany
{
if (contractCompany.dataAreaId == 'xxx')
{
changecompany(contractCompany.LegalEntity)
{
nameOfCompany = curext();
info(strFmt("Name : %1",nameOfCompany));
}
}
}
I hope it will help you.
Hi Naveen,
Can you specify what kind of data you want to have analyzed together across companies?
Are these accounting related data or some other data?
Would be great if you could clarify.
Many thanks and best regards,
Ludwig
Valid scenario. You can take a look at report below that shows how to fetch data from multiple companies..
InterCompanyGoodsInTransitTotals
You just need to use the keyword "changecompany(... dataAreaId)" to get data from other company.
Hi Naveen,
You can combine data from two or even all of your companies in a Management reporter report.
There are a couple of default reports available in the MR. Please check them to get an impression of how your report can be designed.
Please let us know if this answered your question resp solved your issue.
Best regards
Ludwig
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
