Change Table

Designer Administrator
This manual is in pilot operation.

What is a Change Table?

For different balance accounts, there may be a need to understand the breakdown of increases and decreases for the current period in different ways, as in the following examples:

Machinery, Fixtures & Fittings, and Vehicles

"Acquisition," "Disposal," "Transfer to Main Account," "Depreciation"

Long-term Loans & Short-term Loans

"Lending," "Recovery," "Reclassification to 1-Year Basis"

However, in fusion_place, only one change account dimension can be set up within a single application. Therefore, all items for the current period’s increases and decreases must be registered in that change account dimension, regardless of the target balance account.

On the other hand, a mechanism has been prepared to prohibit entries other than valid change accounts for each balance account. This is the "Change Table."

A Change Table can be assigned to each balance account (assignment is not mandatory). Also, for each Change Table, it is possible to limit the change accounts that can be entered. This allows only meaningful change accounts to be entered for each balance account.

How to Use a Change Table

Please follow the steps below to use a Change Table.

(1) Registering a Change Table

Change Tables are registered as "values" of the "Applicable Change Table" property in the account dimension. You can register as many as necessary for business needs.

For example, based on the examples mentioned above, register a "Fixed Assets" detailed change table for Machinery, Fixtures & Fittings, and Vehicles, and a "Financial Assets" detailed change table for Long-term and Short-term Loans. Each detailed change table will be labeled.

When registering Change Tables like this in the account dimension, a property with the same label and name as that Change Table is automatically registered in the change account dimension. This is called the "Change Table" property. Note that the label for the Change Table must start with #CT_ (This rule is established to avoid duplication between the labels of Change Tables and other properties in the change account dimension).

(2) Setting Properties for Change Accounts

In the change account dimension, specify which change table each member (change account) belongs to. By setting the Change Table property value of each member to "Target," that change account can belong to the change table indicated by the property.

For example, for the member "Disposal," the property for "Fixed Assets" would be "Target," and the property for "Financial Assets" would be "Not Applicable."

⚠ For system-defined members, all Change Table properties are automatically set to "Target."

(3) Setting Properties for Account Members

In the account dimension, specify which Change Table to apply to each member (account). Select the desired detailed change table for each member’s "Applicable Change Table" property. For accounts where no breakdown of increases and decreases is needed, leave the property value blank.

Returning to the examples mentioned above, the applicable account table for Machinery, Fixtures & Fittings, and Vehicles would be "Fixed Assets," and for Loans & Short-term Loans, it would be "Financial Assets."

With these settings, entries other than the change accounts designated as "Target" by the applied account table are not allowed for each balance account. For example, "Machinery & Equipment - Disposal" can be entered, but "Machinery & Equipment - Recovery" or "Long-term Loans - Disposal" are not allowed.