Main account templates (form)

  • Article

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Click General ledger > Setup > Chart of accounts > Main account templates.

You can create templates that are based on the field entries for specific main accounts that you specify as template models. When you create a main account, you can select the template that contains the information that must be applied to the new main account. The field values of the template are copied to the fields of the new main account.

If you use Management Reporter to generate financial statements for your organization, you can display the amounts on those financial statements in the reporting currency.

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

Button

Button

Description

Translations

Enter language translation information for the original name of the main account. This information is used when main accounts are created.

Tabs

Tab

Description

General

Select information that is specific to the main account, such as the main account category, debit and credit controls, and administration and consolidation information.

Setup

Set up currency, user, and posting information for each main account.

Management Reporter

Set up currency translation and default rate types for financial reporting that uses Management Reporter.

Fields

Field

Description

Main account template

The unique identifier of the main account template.

Description

The description of the main account template.

Main account

Enter a number for the default main account. The main account that has this number is displayed as the default main account when you use the template in the Main accounts - chart of accounts: %1 form. You can leave this field blank.

Name

Enter a name for the main account.

Main account type

Select the type of main account. The main account type determines how the account is used as a main account. For more information, see About main account types.

Reporting type

If you selected Reporting in the Main account type field, select how the account is used for reporting:

  • Header – Print account information at the top of the financial statement.

  • Empty header – Print an empty row at the top of the financial statement.

  • Page header – Print account information at the top of each page of the financial statement.

Main account category

Select the main account category for the main account.

DB/CR proposal

Select whether a typical transaction that is posted to the selected main account is a debit or credit transaction. When you enter a transaction for the main account in a journal, the cursor moves automatically to the Debit or Credit field, based on the selection in this field.

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

  • When the value in the Main account type field is Expense or Asset, a transaction for the main account in a journal is automatically proposed as a debit transaction.

  • When the value in the Main account type field is Revenue or Liability, a transaction for the main account in a journal is automatically proposed as a credit transaction.

Note

You must select a value in this field if the account is used in Budgeting.

DB/CR requirement

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

Balance control

Select the balance control criteria for the transactions for the main account:

  • If you select Debit control, the total amount of journal transactions for this main account is prevented from making the balance of the main account a credit amount.

  • If you select Credit control, the total amount of journal transactions for this main account is prevented from making the balance of the main account a debit amount.

Do not allow manual entry

Select this check box to prevent users from manually entering a value for this main account in journals.

Foreign currency revaluation

Select this check box if the main account is included in the foreign currency revaluation of general ledger accounts. For more information, see Foreign currency revaluation check box in the Main accounts - chart of accounts form.

Monetary

Select this check box if the main account is a monetary account. Monetary accounts are revalued by using the exchange rate of the date that is entered in the Date field in the To field group in the Foreign currency revaluation form.

If this check box is cleared, the main account is revalued by using the exchange rate of the transaction date.

This field is available only for main accounts that have a type of Balance sheet, Asset, Liability, or Equity, and that have the Foreign currency revaluation check box selected.

Close

Select how balances are transferred to the Closing sheet form:

  • Blank – Leave this field blank to transfer the balance to the Difference field.

  • Result – Select this option to update operating accounts.

  • Balance sheet – Select this option for balance sheet accounts.

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

Mandatory reference

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

Consolidation account

Enter the consolidation legal entity account to which the transactions or balances of the selected ledger account are added during consolidation.

Note

The same consolidation legal entity account can be entered for multiple main accounts in a subsidiary legal entity.

Currency

Select the default currency that is displayed when this main account is selected for a line in the general journal. Depending on the selection in the Currency validation rule field, a user can change the default currency on the journal line, if a different currency is required.

Currency validation rule

Select how the value in the Currency field is validated when transactions are posted to the main account. For more information, see Validate currency codes (form).

User

Select the user or user group that is authorized to post to the main account. The User validation rule field determines how the user or user group that is selected in this field is validated when transactions are posted to the main account.

User validation rule

Select how the value in the User field is validated when transactions are posted to the main account. For more information, see Validate users (form).

Posting type

Select the posting type for the main account to help make sure that only transactions of the selected posting type are posted to the main account. The Posting validation rule field determines how the posting type is validated when transactions are posted to the main account.

Posting validation rule

Select how the posting type that is selected in the Posting type field is validated. For more information, see Validate posting types (form).

Select the system exchange rate type

Select the exchange rate type to use when you print financial statements in a currency other than the accounting currency.

This control is not available in versions of Microsoft Dynamics AX 2012 prior to cumulative update 6 for AX 2012 R2.

Currency translation type

Select the currency translation type to use to determine the exchange rate:

  • Average – Use the average of the exchange rates that were entered for the current month.

  • Weighted average – Use the average of the exchange rates that were entered for the current month, based on how long they were in effect. The following formula is used:
    (Exchange rate * Number of days in effect) + (Exchange rate * Number of days in effect) / Number of days in the month

    Example

    Exchange rate A is .76 and is in effect for 25 days of the current month. Exchange rate B is .74 and is in effect for six days of the current month, which has 31 days. The weighted average would be equal to ((.76 * 25) + (.74 * 6)) / 31, or .756129.

  • Current – Use the exchange rate that was in effect on the report date.

  • Transaction date – Use the exchange rate that was in effect on the date of the transaction.

This control is not available in versions of Microsoft Dynamics AX 2012 prior to cumulative update 6 for AX 2012 R2.

See also

Chart of accounts (form)

Main accounts - chart of accounts (form)

Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).