Share
ReportHello everyone,
How can I get the LedgerDimensionField Values from GeneralJournalAccountEntry table ? I need individual values from that field. Please advice any example.
Thank you.
You’re offline. This is a read only version of the page.
1,879
Hello everyone,
How can I get the LedgerDimensionField Values from GeneralJournalAccountEntry table ? I need individual values from that field. Please advice any example.
Thank you.
Did you do an incremental CIL after changing your code?
In that case, try this statement -
DimensionStorage::GetMainAccountFromLedgerDimension(generalJournalAccountEntry.LedgerDimension).MainAccountId;
getMainAccountFromLedgerDimension method will return the the MainAccount record. getMainAccountNumFromLedgerDimension method should return the MainAccount Id. What values are you getting when you used these methods?
Could you query DimensionAttributeValueCombination table using the same LedgerDimension value and check the value of the MainAccount field?
All responses (
Answers (
DimensionAttributeValueCombination dimAttrValueCombo;
select firstonly MainAccount from dimAttrValueCombo where dimAttrValueCombo.RecId == generalJournalAccountEntry.LedgerDimension
Try this please. Really difficult to find all the methods used in AX 2012
display RecId displayMainAccountid()
{
return DimensionStorage::GetMainAccountNumFromLedgerDimension(this.LedgerDimension);
}
Its Ok to have mistakes . The above method is getting RecId value only not MainAccountNum.
display RecId displayMainAccountid()
{
return DimensionStorage::GetMainAccountIdFromLedgerDimension(this.LedgerDimension);
}
My mistake. This class is used in D365 only and not AX 2012. You can use this statement to get Main account
DimensionStorage::GetMainAccountIdFromLedgerDimension(generalJournalAccountEntry.LedgerDimension)
#1
André Arnaud de Cal...
292,494
Super User 2025 Season 1
#2
Martin Dráb
231,309
Most Valuable Professional
#3
nmaenpaa
101,156
