Time Balance
|
Set the method for calculating the value of summary time periods: None, Flow, First, Balance, Average, Fill, Weighted Average - Actual Actual, Weighted Average - Actual 365, Last.
Default Value: N/A
|
TimeBalance |
Skip Value
|
If the time balance property is First, Balance, or Average, specify how database calculations treat zeros and missing values when calculating parent values:
-
None: Zeros and #MISSING values are considered
-
Missing: Excludes #MISSING values
-
Zeroes: Excludes zero values
-
Missing and Zeroes: Excludes #MISSING and zero values
When you define the value for this property at the parent level, all descendants automatically inherit the value. If the value is overridden for a descendant member of the original parent, its own descendants inherit the new value.
Default Value: None
|
SkipValue |
Expense Reporting
|
Set whether the account is treated as an expense for variance reporting:
When you define the value for this property at the parent level, all descendants automatically inherit the value. If the value is overridden for a descendant member of the original parent, its own descendants inherit the new value.
Default Value: Non-Expense
|
VarianceReporting |
Account Type
|
Define account time balance (how values flow over time) and sign behavior for variance reporting: Expense, Revenue, Asset, Liability, Equity, and Saved Assumption.
When you define the value for this property at the parent level, all descendants automatically inherit the value. If the value is overridden for a descendant member of the original parent, its own descendants inherit the new value.
Default Value: Revenue if a new member is created at root level. Otherwise it inherits the value from the parent.
|
AccountType |
Exchange Rate Type
|
Set how numeric values are stored in Account members and used to calculate values. This setting determines which exchange rate is used during calculations to calculate reporting currency values. For accounts with Currency data type, these options are valid for any time period:
-
None
-
Average: Average exchange rate
-
Ending: Ending exchange rate
-
Historical: Exchange rate in effect at some point
For accounts, if Data Type is set to any value except Currency, Exchange Rate Type must be set to None.
When you define the value for this property at the parent level, all descendants automatically inherit the value. If the value is overridden for a descendant member of the original parent, its own descendants inherit the new value.
Default Value: Average (or None if Data Type is not set to Currency)
|
ExchangeRateType |
Source Plan Type
|
If an account is used in multiple plan types, the plan type database that stores the account value. When an Account member is moved, valid plan types are determined by what is common to the member and its new parents. If the new parent has a different source plan type, the source plan type of the member is set to the first new valid plan type of that member.
When you define the value for this property at the parent level, all descendants automatically inherit the value. If the value is overridden for a descendant member of the original parent, its own descendants inherit the new value. If the new parent of an Account member has another source plan type, the source plan type is set to the first new valid plan type of that member.
Default Value: Plan1
|
SourcePlanType |