Define transaction type specific table dependent accounting

Related topics

The following describes the process of defining transaction type specific accounting information. This is another way of using the Table value dependent accounting method. The difference between using Transaction type specific accounting and Table value default accounting is that you define a specific pseudo account for each of the table values in the selected controlling table for the actual transaction type. This means that the system will not check the Work with accounting defaults program, if you enter a table number for the transaction type. Instead the system retrieves the pseudo account from the very transaction type.

Prerequisites
The pseudo accounts corresponding to the actual accounts, in DC1 Financials, have to be defined in Work with logistic pseudo accounts.

To exemplify the procedure, you will define the accounting of transaction type 930 – Reception from supplier. This transaction type is created when you receive goods from a supplier.

The account strings are defined as follows in the Account file in DC1 Financials:

For the purpose of this example, account part 1 (main account) is a table dependent account (like account parts 2 and 3). This account part uses the Supplier account group table to separate purchases from different suppliers.

Account part 2 is used to separate purchases made by different buyers within the company, using the Handler table (i.e. Work with signatures).

Account part 3 is used to separate the different item groups, using the Item group table, as described in Set up accounting defaults in DC1 Distribution.

Note: As you can see, this transaction type (930) accounts account part 3 according to the Item group. The transaction type 820 in Connect accounting parameters to transaction types step 3, also uses the Item group to account account part 3. But transaction type 820 accounts the three items groups to the accounts CON, OFF and PRD in DC1 Financials. This transaction type shall account the three item groups to the accounts 125, 225 and 325. That is the reason why you have to define transaction type specific accounting for this transaction type. Otherwise the system would have accounted transaction type 930, account part 3 like transaction type 820.

1. Select the Work with transaction types menu item.
2. On the initial panel, select the applicable transaction type and click Change to define information. (For this example, select transaction type 930).
3. On the detail panel, the same fields as described in Connect accounting parameters to transaction types have to be defined. For this example, set Account part 1 to 05, Account part 2 to 10 and Account part 3 to 02. Click OK to update.
4. You return to the initial panel. Select transaction type 930 once again and click Accounting information to define the transaction type specific accounting for account part 3.
5. You access Accounting information listing, per account part, the different account part codes you have defined for the transaction type. In account part 1 you see code 05 and the description Supplier account group, which means that account part 1 is controlled by which supplier account group the supplier you purchase from belongs to. For this example, select the third line, Acc.p 3 and click Change.
6. You access the next Accounting information panel displaying all the table records for the table you selected in the previous step.

Enter for each applicable item group defined in the Item group table which pseudo account, in Work with logistic pseudo accounts, should be used to retrieve the actual account in DC1 Financials (you may have to scroll to view all codes for the Account part for which you are defining pseudo accounts). See Work flow below.

Note: If you have not defined this transaction type specific accounting for this transaction type, the system would have retrieved the account numbers for account part 3 from the Work with accounting defaults, as defined in Set up accounting defaults in DC1 Distribution.

Tip: Click F4 to view a list of all valid pseudo account from the Work with logistic pseudo accounts.

Click OK twice. Exit the routine.

Work flow

Related topics

• About setting up accounting parameters
• Set up the accounting environment in DC1 Financials
• Set up transfer groups
• Set up pseudo accounts in DC1 Distribution
• Set up fixed accounts in DC1 Distribution
• Set up accounting defaults in DC1 Distribution
• Connect accounting parameters to transaction types
• Print accounting x-ref list