Account Category - Details Window

When you create financial report templates, the account hierarchy display is limited to 4 levels only, while in the chart of accounts there may be up to 8 levels depending on your localization.

To display the child accounts located under a specific account, double-click this account in the Financial Report Templates window. The Account Category – Details window appears.

Account Category – Details

G/L Account, Account Name
The code and name of the accounts located under the selected account in chart of accounts.

Linked/Sign

The fields define whether the overall balance, the debit side of the account, or the credit side of the account is included in this account category of the balance sheet, and how the value being positive or negative influences the result.

Example Example

You want the VAT account to be part of an assets account group if the closing balance is positive and part of a liabilities account group if the closing balance is negative. You therefore link the account as a debit with a + sign under assets and also as a credit with a - sign under liabilities.

End of the example.

The default is Balance in the Linked field with the Sign field empty. If you overwrite the default value in the Linked field and the checkbox Allow Multiple Linking to Financial Templates has not been selected in the G/L Account Details window, the application issues a warning message but you are not prevented from saving the change.

After an upgrade from a previous release version of SAP Business One, the results for accounts linked using the checkbox Transfer Accounts with Negative Sign are as follows:

The Linked field value is Balance.
If the account balance is a positive value, the Sign field value is +.
If the account balance is a negative value, the Sign field value is –.

Note Note

Values are included differently in the asset accounts and the liabilities accounts, according to the following logic:

Asset Accounts
Linked	Sign	Included in this account group if the following applies:
Balance (Balance = Debit – Credit)	+	Debit > Credit
Balance (Balance = Debit – Credit)	-	Debit < Credit
Balance (Balance = Debit – Credit)		Included regardless of whether the value is positive or the value is negative Note If the checkbox Accounts with Balance of Zero is selected in the Balance Sheet – Selection Criteria window, G/L accounts with a balance of 0 (zero) are also included. End of the note.
Debit	+	Debit > 0
Debit	-	Debit < 0
Debit		Included regardless of whether the value is positive or the value is negative Note If the checkbox Accounts with Balance of Zero is selected in the Balance Sheet – Selection Criteria window, G/L accounts with a balance of 0 (zero) are also included. End of the note.
Credit	+	0 > Credit
Credit	-	0 < Credit
Credit		Included regardless of whether the value is positive or the value is negative Note If the checkbox Accounts with Balance of Zero is selected in the Balance Sheet – Selection Criteria window, G/L accounts with a balance of 0 (zero) are also included. End of the note.

Liability Accounts
Linked	Sign	Included in this account group if the following applies:
Balance (Balance = Credit – Debit)	+	Debit < Credit
Balance (Balance = Credit – Debit)	-	Debit > Credit
Balance (Balance = Credit – Debit)		Included regardless of whether the value is positive or the value is negative Note If the checkbox Accounts with Balance of Zero is selected in the Balance Sheet – Selection Criteria window, G/L accounts with a balance of 0 (zero) are also included. End of the note.
Debit	+	Debit < 0
Debit	-	Debit > 0
Balance (Balance = Credit – Debit)		Included regardless of whether the value is positive or the value is negative Note If the checkbox Accounts with Balance of Zero is selected in the Balance Sheet – Selection Criteria window, G/L accounts with a balance of 0 (zero) are also included. End of the note.
Credit	+	0 < Credit
Credit	-	0 > Credit
Credit		Included regardless of whether the value is positive or the value is negative Note If the checkbox Accounts with Balance of Zero is selected in the Balance Sheet – Selection Criteria window, G/L accounts with a balance of 0 (zero) are also included. End of the note.

End of the note.

Delete Rows
Deletes accounts that are currently located under the selected account in the financial report template. Your action in this window applies only to the financial report template. It does not influence the chart of accounts, even if the financial report template is based on the chart of accounts.

More Information

Creating Financial Report Templates