DynamicCalc Account roll-up
Hi All,
Is there any option/setting for DynamicCalc account data rolled up to its parent (account type is expense)
Forum Discussion
Hi rhankey, thanks for your prompt response. Yeah, I changed parent attribute to dynamic then children's data rolled up to its parent. unfortunately, this account under P&L hierarchy and some of parent members are referring in member formula.
If this dynamically computed account rolls into let's say NetIncome, then you have a problem, as NetIncome usually needs to be copied to the Balance Sheet as a stored calculation. Stored calculations do not include dynamically computed data without a fair bit of clumsy coding.
In another comment, you mentioned the formula includes division, which seems odd (to me as a non-trained accountant) for something that would roll into NetIncome. Formulas requiring division are commonly KPI's that reside outside the trial balance, where dynamic calcs make most sense. if this formula does require division and needs to be included in NetIncome, then you either compute it as a stored calc that is correct at base levels only, or else you are going to find this dynamic calc will lead to a cascade of additional dynamic calcs which will be very difficult to pull off if they reside within the trial balance.