Debit/Credit Sign Logic

The logic that you define when you create a data matrix determines the debit and credit signing used for entering data or for displaying data that is imported from the totals InfoCube.

The following table gives an overview of the sign logic that is supported.

Debit/credit sign logic	Description
Database values	In data entry, the system stores the values to the database with the same sign that you specify when entering the data on the user interface. In reporting, the system displays the values on the user interface with the same sign that is stored on the database. Example Assets items as positive (without a sign) and liabilities/stockholders’ equity items as negative (with a minus sign). End of the example.
Values as per item sign	In data entry, the system takes into account both the sign that you specify on the user interface and the debit/credit sign set in the master data of the item/subitem concerned. When storing the value to the database, the system stores the product of the user-specified sign and the signs in the master data of the item/subitem concerned. In reporting, the system takes into account both the sign that is stored on the database and the debit/credit sign set in the master data of the item/subitem concerned. When displaying the value on the user interface, the system displays the product of the sign on the database and the signs in the master data of the item/subitem concerned. Example The balance of a liabilities/stockholders’ equity item is usually a credit. The subitem for acquisition is a debit. Therefore, when you maintain acquisition data on a liabilities/stockholders’ equity item, you do not explicitly specify a sign on user interface. Nevertheless, the system stores the value with a minus sign to the database End of the example.
Inverse database values	In data entry, the system stores the values to the database with the opposite sign as compared to the sign that you specify when entering the data on the user interface. In reporting, the system displays the values on the user interface with the opposite sign as compared to the sign that is stored on the database. Example You can use this logic for an income statement item, if you want to show expenses as negative (with a minus sign) and revenue as positive (without a sign). This relationship between positive and negative values enables you to calculate financial results using standard Microsoft Excel formulas. End of the example.

Debit/credit sign logic

Description

Database values

In data entry, the system stores the values to the database with the same sign that you specify when entering the data on the user interface.

In reporting, the system displays the values on the user interface with the same sign that is stored on the database.

Example Example

Assets items as positive (without a sign) and liabilities/stockholders’ equity items as negative (with a minus sign).

End of the example.

Values as per item sign

In data entry, the system takes into account both the sign that you specify on the user interface and the debit/credit sign set in the master data of the item/subitem concerned. When storing the value to the database, the system stores the product of the user-specified sign and the signs in the master data of the item/subitem concerned.

In reporting, the system takes into account both the sign that is stored on the database and the debit/credit sign set in the master data of the item/subitem concerned. When displaying the value on the user interface, the system displays the product of the sign on the database and the signs in the master data of the item/subitem concerned.

Example Example

The balance of a liabilities/stockholders’ equity item is usually a credit. The subitem for acquisition is a debit. Therefore, when you maintain acquisition data on a liabilities/stockholders’ equity item, you do not explicitly specify a sign on user interface. Nevertheless, the system stores the value with a minus sign to the database

End of the example.

Inverse database values

In data entry, the system stores the values to the database with the opposite sign as compared to the sign that you specify when entering the data on the user interface.

In reporting, the system displays the values on the user interface with the opposite sign as compared to the sign that is stored on the database.

Example Example

You can use this logic for an income statement item, if you want to show expenses as negative (with a minus sign) and revenue as positive (without a sign). This relationship between positive and negative values enables you to calculate financial results using standard Microsoft Excel formulas.

End of the example.

More Information

Creation of a Data Matrix