« Managing Change Data   |   List of Built-in Properties »

Input Availability and Calculation Conditions for Changes by Data Type

This manual is in pilot operation.

The Input Availability and Calculation Conditions for Changes by Data Type are as follows.

Input Availability and Calculation Conditions for Changes

Basic Rules

  1. For Balance Items, Changes can be tracked.

  2. The Input Availability of Non-Numeric Data into Numeric Accounts is aligned with the Numeric Input Availability for the corresponding Accounts (with some exceptions).

  3. Even when Input is allowed in the table below, Input may be prohibited due to other conditions.

Upper: Input Availability ( ✓: Available, —: Not Available)
Lower: If it’s a Data Holding Item: "Held", if it’s a Calculated Item: Calculation Method

Change Account Type

Account Data Type

Balance Value

Flow Value

Non-Numeric

Cell Data Type

Numeric

Non-Numeric

Numeric

Non-Numeric

Non-Numeric

Previous Period Balance

#PREV

—

—

—

—

—

Previous Period #END Value

(Same as left)

Previous Period #END Value [1]

(Same as left)

Previous Period #END Value

Difference in Beginning Balance

#BDIFF

—

Not Used [2]

—

Not Used [2]

Not Used [2]

#BEG Value - #PREV Value

- #PREV Value

Beginning Balance

#BEG

✓

Not Used [2] [3]

Not Used [2]

#CBAL Value + #CHG Value [4]

Detail of Changes

DTL (Optional)

✓ (only for the Lowest Member)

✓

Held at the Lowest Level, Aggregated at Higher Levels

—

Change in Current Period

#CHG

—

✓ [5]

Total of Child Member Values (DTL)

—

Cumulative Balance

#CBAL

—

✓ [5]

Held [4]

—

Difference in Ending Balance

#EDIFF

—

✓ [5]

—

#END Value - #CBAL Value

—

#END Value

Ending Balance

#END

✓

✓

— / ✓ [6]

—

✓

Held

Held

Held

Held

Held

Net Change

#NET

— / ✓ [6]

—

✓ [7]

✓ [7]

—

#END Value - #PREV Value

#END Value

#END Value - #PREV Value

#END Value

#END Value

None

#NONE

✓ [7]

✓ [7]

✓ [7]

✓ [7]

✓ [7]

#END Value

#END Value

#END Value - #PREV Value

#END Value

#END Value
1. If the Previous Period is the end of the Previous Year, it will be zero or blank.
2. Not Available for Input, Numeric Items will display as zero, others as blank.
3. Since the period to which the Beginning Balance applies depends on the display format, appropriate note entry is considered difficult and therefore Input is not allowed.
4. When Inputting, the Cumulative Balance (#CBAL) is calculated from the Beginning Balance (#BEG) and the Change in the Current Period (#CHG), but the Beginning Balance (#BEG) is not stored in the database. When the stored data is queried, the Beginning Balance is displayed by back-calculating from the Cumulative Balance and the Change in the Current Period.
5. This is a Calculated Item in the Basic Ledger, but it is allowed for Input in the Note Ledger (as notes may be required even for Calculated Items).
6. Normally, Input is not allowed, but if "Make Ending Balance of Flow Accounts and Net Change of Balance Accounts Writable" is turned ON in the "Default Setting Value" of the full-featured Form, Input will be allowed in the relevant Form.
7. It is a Calculated Item, but it can also be Input. If Input, the "Ending Balance (#END)" Value will be adjusted accordingly.