You define accounting defaults when you use the Table dependent accounting method or the Table value default accounting using Accounting matrix method to retrieve an account for an account part, in Financials. (See About setting up the accounting matrix for more information).
The other method is Fixed accounts, which is described in Set up fixed accounts in Distribution.
Prerequisites
Before you set up this program, you must have set up the pseudo accounts in Work with logistic pseudo accounts.
To exemplify, assume you want to define accounting defaults for account parts 2 and 3, belonging to a sales account in Financials. The sales account strings are defined as follows in the Account file in Financials:
| Main account | Account part 2 (customer group) |
Account part 3 (item group) |
|---|---|---|
| 101100 | C1 | CON |
| 101100 | C1 | OFF |
| 101100 | C1 | PRD |
| 101100 | C2 | CON |
| 101100 | C2 | OFF |
| 101100 | C2 | PRD |
| 101100 | C3 | CON |
| 101100 | C3 | OFF |
| 101100 | C3 | PRD |
The accounts C1, C2 and C3 are defined in the Account file for account part 2 in Financials. The accounts CON, OFF and PRD are defined for account part 3 in the Account file.
Account part 2 is used to separate sales, using the Customer/supplier group table, according to the following:
| Customer group | Description |
|---|---|
| C1 | Customers – Domestic |
| C2 | Customers – EU |
| C3 | Customers – Outside EU |
Account part 3 is used to separate the different item groups, using the Item group table, according to the following:
| Item group | Description |
|---|---|
| CON | Consumables & Accessories |
| OFF | Office equipment |
| SPP | Spare parts |
- Select the Work with accounting defaults menu item.
- On the initial panel, all tables that can be used in the table dependent accounting are displayed. For this example, select the Customer/Supplier group table to define accounting defauls for it.
- You access Work with accounting defaults.
- You return to the initial panel. Select the Item group table to define accounting defaults for account part 3.
- You access Work with accounting defaults. The codes displayed to the left on this panel are the item groups that you have defined in the Item group table. Enter the pseudo accounts in each account part for the table records. For this example, enter the corresponding pseudo accounts in the Acc.p. 3 column. Tip: Click F4 or the prompt icon to see a list of all valid pseudo account from Work with logistic pseudo accounts. Click OK. Exit the routine.
The codes displayed to the left on this panel are the customer/supplier groups that you have defined in the Customer/Supplier group table.
For this example, enter for each customer group record (C1, C2 and C3) which logistic pseudo account, in Work with logistic pseudo accounts, should be used to retrieve the actual account in Financials. Enter the corresponding pseudo accounts in the Acc.p 2 column.
Tip: Click F4 or the prompt icon to see a list of all valid pseudo accounts from Work with logistic pseudo accounts.
Click OK.
Related topics
- About setting up accounting parameters
- Set up the accounting environment in Financials
- Set up transfer groups
- Set up pseudo accounts in Distribution
- Set up fixed accounts in Distribution
- Connect accounting parameters to transaction types
- Define transaction type specific table dependent accounting
- Print accounting x-ref list
- About setting up the accounting matrix