Global Account Mapping:
For transactions that enable the user to select the account on the transaction form, use global account mapping to configure secondary accounting books to post to accounts different from the primary book.
- Go to Setup > Accounting > Multi-Book Accounting > Global Account Mappings.
- In the General field group, complete the required and optional fields as follows:
Effective Date – (Required) The mapping rule is not effective until this date is reached. Dates in the past are permitted.
End Date – When this date is reached, the mapping ends. If no date is entered, the rule remains in effect.
Accounting Book – (Required) Select the secondary accounting book to which the rule applies. Subsidiary – (Required) The list of available subsidiaries depends on the accounting book selected.
- In the Source field group, select an account from the Source Account list. This list filters accounts based on those restricted to the selected accounting book
- Select the appropriate dimensions from the Class, Department, and Location lists and any custom dimension list. Each account mapping must have unique dimension values. Dimensions with the default value – Any – are permitted. Any dimensions with specific values selected have a higher priority in determining the account than those with the default.
- In the Target field group, select an account from the Destination Account list. This list filters accounts based on those restricted to the selected accounting book.
- Click Save
Item Account Mapping:
The posting accounts for many transactions are determined by the items in the transaction. Use item account mapping to configure secondary accounting books to post to accounts different from the primary book for these transactions.
- Go to Setup > Accounting > Multi-Book Accounting > Item Account Mappings.
- In the General field group, complete the required and optional fields as follows:
Effective Date – (Required) The mapping rule is not effective until this date is reached. Dates in the past are permitted. End Date – When this date is reached, the mapping ends. If no date is entered, the rule remains in effect. Accounting Book – (Required) Select the secondary accounting book to which the rule applies. Subsidiary – (Required) The list of available subsidiaries depends on the accounting book selected.
- In the Source field group, select an account type from the Item Account Type list. This selection determines the accounts that are available in the Source Account list. Some items support multiple accounts on their Accounting subtab. Select an account from the Source Account list. If you have restricted accounts to this accounting book, this list displays only those restricted accounts.
- Select the appropriate dimensions from the Class, Department, and Location lists and any custom dimension list. Each account mapping must have unique dimension values.
- In the Target field group, select an account from the Destination Account list. If you have restricted accounts to this accounting book, this list displays only those restricted accounts.
- Click Save