You’re offline. This is a read only version of the page.
Announcements
18
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,
Yes, it's correct and ledgerDimension should be removed by method VendLedgerAccounts.summaryLedgerDimension.
Hi @rp@n,
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.
Share
Report
All responses (
Answers (
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
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?
#1
André Arnaud de Cal...
294,255
Super User 2025 Season 1
#2
Martin Dráb
232,984
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
