This is one way of using the Table dependent accounting method. The difference between using transaction type specific accounting and accounting matrix defaults is that you define a specific logistics pseudo account for each combination of values in the tables from the matrix code which is selected for and controlling the actual transaction type. This means that the system will not check the accounting matrix defaults, if you enter a matrix code for the transaction type. Instead, the system retrieves the logistics pseudo account from the very transaction type.
- Select the Work with transaction types menu item.
- On the initial panel, select the applicable transaction type and click Accounting information.
- You access Work with transaction types, Accounting information listing, per account part, the different account part codes and descriptions (i.e. fixed account part code, a number of a valid table or an accounting matrix code), entered on the preceding panel. For any account part containing table numbers or matrix codes, the connecting logistics pseudo account code can be defined. To do so, select the applicable account part and click Change.
- On the detail panel, you enter the logistic pseudo account codes that are to be connected to each table entry combination within the particular matrix code. All pseudo account codes that you plan to enter must have previously been defined in Work with logistic pseudo accounts.
- Sales order type
- Displays the name of the first table defined for the matrix code in the selected account part. This column lists the table entries of the first table.
- Area
- Displays the name of the second table defined for the matrix code in the selected account part. This column lists the table entries of the second table.
- Pseudo
- Enter the pseudo account code that is going to be accounted and referenced for each combination of entries within the tables. When an accounting transaction is created, for the transaction type, the relevant logistics pseudo account code will be referenced, depending on the table entries involved in the transaction. This in turn will retrieve the corresponding actual account number. The actual account number will then be stored, along with the transaction type, in the Bookkeeping transaction file.
In the panel header, the transaction type that you are working with is displayed together with its description and the selected account part.
In the sub-file, the number of columns and their headings will differ depending on the selected account part definition. For example, if the selected account part is connected to a matrix code containing two table references, as defined in Work with accounting matrix codes, then there will be two columns and the column headings will display the name of the tables. In the columns, the table entries are listed.
For the purpose of this example, assume the following columns/fields apply:
Click OK and exit the routine.