Notifications
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Abhilash Warrier 669 Super User 2025 Season 2
André Arnaud de Cal... 471 Super User 2025 Season 2
Martin Dráb 423 Most Valuable Professional
