How to apply cross company in joins in ax ?

(0) Share

Report

Posted on by Harshal Jain

162

Hi,

I am trying to get the data across all the legal entities but it's working only for the current legal entities. For other legal entity it doesn't give result.

GeneralJournalAccountEntry generalJournalAccountEntry;        LedgerEntry ledgerEntry;        LedgerEntryJournal ledgerEntryJournal;        GeneralJournalEntry generalJournalEntry;        if (_generalJournalAccountEntryRecId != 0)        {            select firstonly crosscompany generalJournalAccountEntry                where generalJournalAccountEntry.RecId == _generalJournalAccountEntryRecId            join  generalJournalEntry                where generalJournalEntry.RecId == generalJournalAccountEntry.GeneralJournalEntry &&                      generalJournalEntry.Ledger == Ledger::current()            outer join  ledgerEntry                where ledgerEntry.GeneralJournalAccountEntry == generalJournalAccountEntry.RecId            outer join  ledgerEntryJournal                where ledgerEntryJournal.RecId == generalJournalEntry.LedgerEntryJournal;        }

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Martin Dráb 237,878 Most Valuable Professional on at

Like (0)

Report
Let me format your code a bit:

GeneralJournalAccountEntry generalJournalAccountEntry; GeneralJournalEntry generalJournalEntry; LedgerEntry ledgerEntry; LedgerEntryJournal ledgerEntryJournal; if (_generalJournalAccountEntryRecId != 0) { select firstonly crosscompany generalJournalAccountEntry where generalJournalAccountEntry.RecId == _generalJournalAccountEntryRecId join generalJournalEntry where generalJournalEntry.RecId == generalJournalAccountEntry.GeneralJournalEntry && generalJournalEntry.Ledger == Ledger::current() outer join ledgerEntryJournal where ledgerEntryJournal.RecId == generalJournalEntry.LedgerEntryJournal outer join ledgerEntry where ledgerEntry.GeneralJournalAccountEntry == generalJournalAccountEntry.RecId; }

I see you're filtering the data by Ledger::current(), which is the ledger of the current company (CompanyInfo::find()). I think this is the cause of your problem.

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

Hi Harshal,

I think there is no need of cross company keyword here as all the table you are using is global.

So as Martin mentioned, it may be due to the Ledger:;Current().

Thanks,

Girish S.

Was this reply helpful? Yes No
Harshal Jain 162 on at

Like (0)

Report

Hi Martin, got my mistake. Thanks for the solution.

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to apply cross company in joins in ax ?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

How to apply cross company in joins in ax ?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates