You can configure the Entry field for a request type on this screen. The field allows the user to link a financial journal entry to a request. This field is presented as a Search icon and if there is a journal entry linked to the request, a code of five numbers separated by dots is presented as a hyperlink next to the icon.
The first number is the division code. The second and third numbers are the year and period the transaction is entered. The fourth number is the journal entry number while the last number is the journal number.
For example, the code is "002.2007.4.3000068.99". This means that the entry is entered to the division with division code "002" in the fourth period of the year 2007. The journal entry number is "3000068" and it is recorded in the journal with journal code "99".
The following describes only the settings specific for the Entry field. For more information on the menu path, roles and rights, buttons, and other settings available in most request fields, see Customizing Request Type Fields (Main Document).
Select this check box to make this field dependent on the Account field of the request type. In a request of this type, the user can select only a financial journal entry linked to the account selected in the Account field. For more information on the Account field, see Customizing Request Type Fields - Account.
Note: The Account field should be included in the request type definition for this dependency to be effective.
Select this check box to make this field dependent on the Item 1 field of the request type. In a request of this type, the user can select only a financial journal entry linked to the item selected in the Item 1 field. For more information on the Item 1 field, see Customizing Request Type Fields - Item 1 & Item 2.
Note: The Item 1 field should be included in the request type definition for this dependency to be effective.
Select this check box to make this field dependent on the Item 2 field of the request type. In a request of this type, the user can select only a financial journal entry linked to the item selected in the Item 2 field. For more information on the Item 2 field, see Customizing Request Type Fields - Item 1 & Item 2.
Note: The Item 2 field should be included in the request type definition for this dependency to be effective.
Select this check box to make this field dependent on the Project field of the request type. In a request of this type, the user can select only a financial journal entry linked to the project selected in the Project field. For more information on the Project field, see Customizing Request Type Fields - Project.
Note: The Project field should be included in the request type definition for this dependency to be effective.
Select this check box to make this field dependent on the Person field of the request type. In a request of this type, the user can select only a financial journal entry linked to the person selected in the Person field. For more information on the Person field, see Customizing Request Type Fields - Person.
Note: The Person field should be included in the request type definition for this dependency to be effective.
Select this check box to make this field dependent on the Serial number 1 field of the request type. In a request of this type, the user can select only a financial journal entry linked to the serial number selected in the Serial number 1 field. For more information on the Serial number 1 field, see Customizing Request Type Fields - Serial Number 1 & Serial Number 2.
Note: The Serial number 1 field should be included in the request type definition for this dependency to be effective.
Select this check box to make this field dependent on the Serial number 2 field of the request type. In a request of this type, the user can select only a financial journal entry linked to the serial number selected in the Serial number 2 field. For more information on the Serial number 2 field, see Customizing Request Type Fields - Item 1 & Item 2.
Note: The Serial number 2 field should be included in the request type definition for this dependency to be effective.
Type a partial SQL statement, which is used as part of an SQL 'where' clause by the system, to list only journal entries matching this statement. Since the SELECT statement queries the main transaction table "gbkmut" (aliased as "g"), you can use the table alias in your partial SQL statement for the 'where' clause where applicable.
For example, you want to list only journal entries for a division with division code "002" that was entered in the first period of the year 2007 for an account payable with the account number "60008". In this case, type g.CompanyCode = '002' AND g.bkjrcode= 2007 AND g.periode = 1 AND g.crdnr = 60008. The following is a truncated sample SQL selection statement to illustrate where the partial SQL statement you typed into this box is inserted in the 'where' clause:
SELECT ... FROM ... WHERE ... IN ... AND (g.CompanyCode = '002' AND g.bkjrcode= 2007 AND g.periode = 1 AND g.crdnr = 60008) ORDER BY ...
Click Show to preview the selection page and the effect of your SQL statement on the selection list.
Note: The preview list displayed when you click Show takes into account only your partial SQL statement regardless of other settings. The selection page may present a different list in an actual request during run-time when other settings, which may include settings in other request fields, are taken into account.