570
Hello ..
Please help me to find the relation between DimensionAttributeValueTotallingCriteria and MainAccount
DimensionAttributeValueTotallingCriteria the form you can find in chart of account in button Total
thanks
*This post is locked for comments
You can see it from the existsForMainAccountReference() method where you have next select statement:
elect firstonly RecId from totallingCrit
where totallingCrit.FromValue <= _referenceMainAccountId
&& totallingCrit.ToValue >= _referenceMainAccountId
exists join dimAttrValue
where dimAttrValue.RecId == totallingCrit.DimensionAttributeValue
&& dimAttrValue.DimensionAttribute == DimensionAttribute::getMainAccountDimensionAttribute()
exists join mainAcct
where mainAcct.RecId == dimAttrValue.EntityInstance
&& mainAcct.LedgerChartOfAccounts == _chartOfAccounts;
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
