> Common Forms>

Use this form to create, manage, and view the company's general ledger accounts in a structured list. The general ledger accounts contain the financial data about the company's activities.

For information about factors to consider when structuring the chart of accounts, see Chart of accounts.

To expedite the creation of ledger accounts, you can create templates (for use by all users or a single user) that are based on the field entries on specific ledger accounts that you specify as template models. If a template is available when you begin to create a new ledger account, a form appears that displays the available ledger account templates. You select the template that contains the information that applies to the new ledger account. The field values of the template are copied to the fields of the new ledger account. You can then make changes to the fields and enter more information as appropriate. For more information, see Using record templates.

You can also use automatic account type selection when you create a ledger account: In the form, link the first character of the account ID ( field) to a value in the field. Then enable automatic account type selection in the form by selecting the check box in the form. When you enter the first character in the field, the account type is entered automatically.

Tip Tip

To export the company chart of accounts, dimension values, or exchange rates directly into the databases of subsidiaries or other companies that run on external databases, see Using AIF to integrate with external systems.


Tasks that use this form

Navigating the form

The following tables provide descriptions for the controls in this form.

Tabs

Tab

Description

Overview tab

Create and view the ledger accounts.

General tab

View information for the account that is selected on the tab.

Enter additional information for accounts that are not headers or totals. For example:

  • Set up debit/credit control, related accounts, allocation accounts, and exchange adjustment accounts.

  • Lock the account for manual posting.

  • Completely close the account for postings.

Setup tab

Set up sales tax, currency, user ID, and posting type information for the account that is selected on the tab.

Set up the layout of the selected account as it will appear on financial statements.

Set up dimension values and dimension validation for the selected account.

Buttons

Button

Description

View ledger transactions that are posted to the selected account.

Set up balance criteria and view balances of the selected account.

To set up the general criteria that governs the field on the tab, click .

To view the balance by dimension for the selected account, click .

View the balance by currency, transactions on the balance, or as a graph.

View the balance of the selected account by period.

Set up and manage totals, allocation terms, and cash flow forecast.

Run inquiries about the ledger account.

For example, click to run an inquiry to list the tables in which a reference to the selected ledger account is stored. Update the tables to be inspected in the form, select the ledger account in the form, and run the inquiry.

Example

Select for the CustLedgerAccountsvalue in the field in the form. Then run a inquiry for a customer summary account.

Print an account statement for the selected account.

Create, revise, or view budget information for the selected account or for other accounts that you select individually.

Set up validations for currency code, posting, user, and dimension.

Set up the relationship, if any, of the selected account to cost categories.

Create and view cost categories in the form.

Send the original or copy of the chart of accounts to a defined endpoint as an XML document.

Fields

Field

Description

Enter or view an account number for posting in the ledger.

For more information, see Ledger account in Chart of accounts form.

Enter or view an account name. To search for an account by name, press CTRL+F.

Enter a short name that can be used in a fast search for an account. The default value in this field is the name in the field.

Select the ledger account type, which determines how the account is used as a ledger account.

For more information, see Account type.

The description of the account category for the ledger account.

This field is available only for ledger accounts with the following account types:

The balance of the selected ledger account, according to the criteria that you set up for viewing balances for the entire chart of accounts. For more information, see Display the balance on a ledger account.

Select this check box to prevent posting on the ledger account in journals.

Select whether a typical transaction that is posted to the selected account is a debit or credit transaction. When you enter a transaction to the account in a journal, the cursor moves automatically to the or field, according to your selection in this field.

If you leave this field blank, the following rules apply:

  • When the value in the field is or , a transaction to the account in a journal is automatically proposed as a debit transaction.

  • When the value in the field is or , a transaction to the account in a journal is automatically proposed as a credit transaction.

Indicate whether the selected account is used only for debit transactions or for credit transactions. If an account is limited to debit or credit transactions, this requirement is verified when journal lines are validated and posted.

Select the balance control criteria for the transactions on the selected account.

For example, if you select control, the total amount of journal transactions to this account is always prevented from making the balance of the account become a credit amount.

Select this check box to prevent all postings to the selected account.

Select this check box if the selected account is included in the exchange adjustment of general ledger accounts. To run the exchange adjustment, click > > .

Note Note

This field must be selected on ledger accounts whose transactions or balances are to be exported or transferred to the consolidation company.


For more information, see Exchange adjustment check box in the Chart of accounts form.

Select this check box if the account is a monetary account. Monetary accounts are translated using the exchange rate of the date that is entered in the field in the form.

If the check box is cleared, the account is translated using the exchange rate of the transaction date.

Note Note

This field is available only for accounts with a type of , , and , and only if you have selected the check box.


Displays a check mark if the allocation amount will be calculated during the transaction posting process.

This field is available only if the field is selected and the configuration key is selected.

Select this check box to require users to enter a payment reference for ledger journal transactions before the transactions can be posted.

Note Note

(ISL) This field is available only if the configuration key for Iceland is selected.


Select the consolidation conversion principle that applies to the selected ledger account in the consolidated company. Any balances or transactions from subsidiaries that need to be converted to the consolidation company currency are converted according to the conversion principle that is selected in this field. The conversion principle corresponds to the translation method for each type of account in the country/region of the consolidated company.

  • – The subsidiary amounts are converted by the exchange rate that is entered for each foreign currency in the field on the tab of the form. This is the default value for this field if you create a new account in a consolidated company.

    Accounts with a type of , , or are sometimes converted using an average rate; otherwise, the historical rate of the transaction date is used. An average rate must be chosen with care, especially if there are large variations in the exchange rate during the period.

  • – The subsidiary amounts are converted by the exchange rate that is entered for each foreign currency in the field on the tab of the form. The closing rate is the rate that applies to the last date in the period.

    Accounts with a type of , , or are typically converted using a closing rate.

  • – The subsidiary amounts are converted by the historical exchange rate for the foreign currency as defined for periods of the year by the date field on the tab of the form.

    Accounts with a type of , , or are often converted using the historical rate for each transaction date. In addition, stocks that are issued on a particular date and that are still owned by the subsidiary, as well as capital that is paid in on a particular date, are usually converted using the historical exchange rate.

Note Note

This field is available only if the configuration key is selected.


Indicate how balances should be transferred to the form:

  • – Leave the field blank to transfer the balance to the field.

  • – Select this option to update operating accounts.

  • – Select this option for balance accounts.

  • – Select this option for accounts related to cash flow forecasts and revaluation.

If this check box is selected, the selected ledger account should perform an allocation in connection with transaction posting from other parts of the application and from the journals.

An allocation is automatically performed as defined in the form. To open this form, click > .

The default offset account for the selected account in the general journal. By creating a default offset account, you can more easily post to the selected ledger account without having to enter the offset account every time.

Enter the account number to which the opening balance should be transferred.

For more information, see Opening account in Chart of accounts form.

The identifier of the consolidated company account to which the transactions or balances of the selected ledger account are added during consolidation.

Note Note

The same consolidated company account can be entered on several ledger accounts in a subsidiary company.


A three-digit code that corresponds to the standardized accounting statement number that is assigned by the Swedish tax authority.

Note Note

(SWE) This field is available only if the configuration key for Sweden is selected.


Select the sales tax group that is suggested for the account in the general journal.

Select the item sales tax group that is suggested for the account in the general journal.

Select if the sales tax that is calculated on normal transactions to the selected ledger account is sales tax payable or sales tax receivable.

For more information about sales tax payable and sales tax receivable, see Account group - Ledger posting group (form).

Select this check box if transactions on the selected account are typically tax exempt. If selected, lines in the general journal that are assigned the selected ledger account are not automatically assigned the default item sales tax group for this account.

Enter or select the sales tax code to be associated with the selected ledger account.

Select how the value in the lookup field is validated in connection with posting.

For more information, see Validate tax code field.

Select the default currency that is filled in when a line in the general journal is assigned the selected ledger account. Depending on your selection in the drop-down list, a user can change the default currency on the journal line, if appropriate.

Select how the value in the lookup field is validated in connection with the posting of transactions to the selected account.

Select the user or user group that is authorized to post to the selected ledger account. The drop-down list determines how the user or user group that is selected in this field is validated during posting to the selected ledger account.

Select how the value in the lookup field is validated in connection with posting.

For more information, see Validate user field.

Select the posting type for the selected ledger account to help ensure that only transactions of the selected posting type are posted to the ledger account. The drop-down list determines how the posting type is validated in connection with posting to the selected ledger account.

For more information, see Posting type.

Select how the posting type that is selected in the drop-down list is validated.

For more information, see Validate posting

Select this check box to hide the minus sign on the financial statement report when this ledger account is represented. Typically, revenue and expenses are displayed in both credit and debit balances so that credit balances have a minus sign and debit balances have no sign. When this check box is selected, the minus sign in front of revenue on the report is not displayed.

Select the column number that the account is printed to when the financial statement is printed.

For more information, see Column.

Enter a level for a dimension or for a header in the financial statement when this ledger account is represented. This field makes it possible for you to specify that not all accounts should be listed by dimension on the financial statement.

Select if the selected account should be printed in bold type on the financial statement.

Select if the selected account should be printed in italic type in the financial statement.

Select if the selected account should be preceded by a blank line on the printout of the financial statement.

Select if the selected account should be followed by a blank line on the printout of the financial statement.

Select if the text should be underlined when the selected account is printed on the financial statement.

Select if amounts should be underlined when printed on the financial statement.

Select if the report should contain totals by period for the selected account, if the field is selected in the report form.

Note Note

(FRA) This field is available only if the configuration key for France is selected.


Select the dimension, if any, which is proposed in journal lines if the selected account is selected on a journal line.

The dimension fields are disabled if there is a dimension set rule for the account, and the check box is selected in the form.

Select the dimension, if any, which is proposed in journal lines if the selected account is selected on a journal line.

The dimension fields are not available if there is a dimension set rule for the account, and the check box is selected in form.

Select the dimension, if any, which is proposed in journal lines if the selected account is selected on a journal line.

The dimension fields are not available if there is a dimension set rule for the account, and the check box is selected in form.

Select how the field is validated in connection with posting.

Note Note

If the company is using dimension set hierarchies and dimension set rules, and a mandatory/fixed dimension is set up in that context, this field is usually set to to prevent rule conflicts during posting.


Select how the field is validated in connection with posting.

Note Note

If the company is using dimension set hierarchies and dimension set rules, and a mandatory/fixed dimension is set up in that context, this field is usually set to to prevent rule conflicts during posting.


Select how the field is validated in connection with posting.

Note Note

If the company is using dimension set hierarchies and dimension set rules, and a mandatory/fixed dimension is set up in that context, this field is usually set to to prevent rule conflicts during posting.