Announcements
No record found.
hi all,
in Vendor posting profile , i need to display main account and name in report. kindly let me know the exact table relation with vendor account.
So, that i can get the main account and name.
please give me more shed on this.
thanks!
Hi @rp@n,
There is a method VendLedgerAccounts.summaryLedgerDimension which can return your ledger dimension id and you can fetch the main account from it. The method already handles search by account code (All, Group, Table).
What is your requirement by the way?
I wnats to display the above main account and name in report.
select vendLedgerAccounts where vendLedgerAccounts.AccountCode == TableGroupAll::GroupId && vendLedgerAccounts.Num == vendGroup; if(vendLedgerAccounts) { ledgerDimension = vendLedgerAccounts.SummaryLedgerDimension; }
here i got the ledger dimension. Now i need the main account and name to display in report.
Kindly let me know the exact relation, so that i can get the value of main account
In this case use method mentioned above.
Main account can be fetched by methods mentioned in community.dynamics.com/.../how-to-get-mainaccount-name-from-ledger-dimension-ax-2012
Main account name can be fetched from MainAccount table by MainAccount value.
mainAccount = MainAccount::findByLedgerDimension(ledgerDimension).MainAccountId; mainAccountName = MainAccount::findByLedgerDimension(ledgerDimension).Name;
is it correct?
Yes, it's correct and ledgerDimension should be removed by method VendLedgerAccounts.summaryLedgerDimension.
yes, thanks
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 608
André Arnaud de Cal... 591 Super User 2026 Season 1
CP04-islander 430
