Missing Account Values
This one is for all you Encyclopedia Brown fans out there. Like many companies, we have a cash flow cube view. We've recently added two balance sheet accounts to one of the lines in it, but the values in those accounts do not show up. Here is the code for the member formula for the Debt Payments cash flow line:
If (Not api.Entity.HasChildren()) Then
api.data.calculate("A#CF_DebtPymts:F#CF_ACTIVITY:I#None:O#Import = A#DebtCur:F#RF_Debt_ACTIVITY:I#Top:O#Top
+ A#Debt_LT:F#RF_Debt_ACTIVITY:I#Top:O#Top
+ A#Cur_equip_fin_liabs:F#RF_Debt_ACTIVITY:I#Top:O#Top
+ A#LT_equip_fin_liabs:F#RF_Debt_ACTIVITY:I#Top:O#Top")
End If
The last two accounts, Cur_equip_fin_liabs and LT_equip_fin_liabs are not pulling into the value for Debt Payments even though I've proven via a QuickView that there are data in the intersections specified in the above formula.
I've compared the new accounts to the existing accounts in this formula, and all the settings are the same. These accounts were added before month end close, so everything has been through the entire process of consolidation and calculation.
Why do the values not pull into this cash flow account?