Related topics
On this panel you define your setup of the account parts, which includes the number of parts to be used, and how they are related to each other. You also define which account part is the main one, and which one will be used for cost centre accounting. The information must be completed at the time of installation and cannot or should not be changed once the system is in use.
You can also link another statistic key to any account part but the main account part. This allows you to combine G/L base levels with other base levels, thereby being able to retrieve and compare balances from different base levels in one report or enquiry.
Function keys
- Account part 1-8
- You can use up to eight account parts, and together they must not be longer than 30 positions. If you do not want to use all of them, you must use them in sequence. That is, if you want five account parts, you must use account part 1, 2, 3, 4, and 5. This cannot be changed once the system is in use.
- Length
- Enter the number of positions for each account part you intend to use. The total length for all account parts must not exceed 30 positions, and no single account part must be longer than 20 positions. This cannot be changed once the system is in use. The length you enter here will be displayed for the account in the Account file.
- Description
- Enter the names or titles for each account part you intend to use. The length of the name must not be greater than the number of positions of the account part. The account part names can be changed once the system is in use. The description you enter here will be displayed for the account in the Account file.
- Trailing blanks
- For each account part, indicate whether or not trailing blanks are allowed for the account numbers that do not fill the entire account field. For a numerical account part you will normally set it NO, and let the system complete the remaining positions of the account number with zeros whenever used. For alphanumerical accounts, it is more common to allow trailing blanks. The difference is that you must complete the entire account number field when you add an account without trailing blanks to the Account file in order to define it as an entry account.
Account 1 is set up in a four position long numerical account part for which trailing blanks is not allowed. When the account is created, you must complete the remaining positions with zeros, (1000), to be able to define it as an entry account. However, when you use it, however, all you have to enter is 1. The system will add the three extra zeros.
Account A is set up in a four position alphanumerical account part for which trailing blanks is allowed. When the account is created, you need only enter A to be able to define it as an entry account. When you use it, you enter A, and the system will leave the three last positions blank.
- Statistic key linked to
- If you want to combine G/L base levels with other base levels, thereby being able to retrieve and compare balances from different base levels in one report or enquiry, enter the applicable statistic key that is to be linked to the account part. Note: A statistic key can be linked to any account part BUT the main account part. This feature allows you to, e.g., connect G/L balances with Sales balances.
The following stipulations must be true:
- The statistic key number must exist. (See System statistic keys table).
- The length of the account part must not be shorter than the length of the statistic key. (See the Work with field reference file for the length of the FRF field name for the statistic key).
- The Mapped to field value for the linked statistic key number must not already be occupied on base levels A11 and A12 (i.e. G/L Balances). (See System statistic keys table).
- Corporate snd/rcv
- This field, valid only for DC1 Corporate Data Maintenance, contains two parts. The entries in these parts are used in the equivalent fields in the Account file, for each account part, and in the Summary identity file for each connected summary id. The Corporate Data Maintenance (CDM) tool allows your company to transfer data from “supported” DC1 files between DC1 companies within the same release and iSeries.
Note: You are only allowed to maintain these fields if you have DC1 System Administrator Authority.
- If you are in the Sending company and the Corporate snd flag is defined as OPTIONAL here, this indicates that you want to activate/inactivate future sending of ACCOUNT and SUMMARY ID data. The equivalent fields in the Account file and in the Summary id file, for the connected summary id, will be set to YES by default but you can change it at will.
If you define this field as MANDATORY (the account part data and any connected summary id data must be sent), this flag will automatically be set to YES in the Account file and in the Summary id file, for the connected summary id.
If you enter the code for NOT ALLOWED, this snd flag will be set to NO in the Account file and the Summary id file, for the connected summary id, and cannot be changed.
- If you are in the Receiving company and the Corporate rcv flag is defined as OPTIONAL here, this indicates that you want to activate/suspend future reception of ACCOUNT and SUMMARY ID data. The equivalent fields in the Account file and in the Summary id file for the connected summary id, will be set to YES by default but you can change it at will.
If you define this field as MANDATORY (the account part data and any connected summary id data are allowed to be received), this flag will automatically be set to YES in the Account file and in the Summary id file, for the connected summary id.
If you enter the code for NOT ALLOWED, this rcv flag will be set to NO in the Account file and the Summary id file, for the connected summary id, and cannot be changed.
- If you are in the Sending company and the Corporate snd flag is defined as OPTIONAL here, this indicates that you want to activate/inactivate future sending of ACCOUNT and SUMMARY ID data. The equivalent fields in the Account file and in the Summary id file, for the connected summary id, will be set to YES by default but you can change it at will.
- Main account part
- Enter the number of the account part which is the main one. This is the account part used for external accounting. This cannot be changed once the system is in use.
- Cost centre acc part
- Enter the number of the account part which is to be the cost centre part of your accounting. This cannot be the same as the main account part. The accounts in this part can then be controlled on customer/supplier level and accounting on cost centre can be done via the pseudo accounting with cost centre substitution. If you leave this field blank, no cost centre accounting will be demanded in the entry programs. This cannot be changed once the system is in use. Note that the cost centre account part must not be more than 7 positions long.
- Mgmt acc prefix
- Only used for internal purposes. Enter the management accounting prefix 9.
- Prim segm acc part
- This field is optional and it is only displayed if the IFRS function is activated. Enter the number of the account part that is to be used as a primary segment. This information is used in the IFRS segmentation routine, and defines what account part should be a base for the split of the open items. Note: If an account part has been specified in the Sec segm acc part field, you may not enter the same account part in this field. Moreover, you cannot enter the main account part in this field.
- Sec segm acc part
- This field is optional and it is only displayed if the IFRS function is activated. Enter the number of the account part that is to be used as a secondary segment. This information is used in the IFRS segmentation routine, and defines what account part should be a base for the split of the open items. Note: If an account part has been specified in the Prim segm acc part field, you may not enter the same account part in this field. Moreover, you cannot enter the main account part in this field.
G/L control file maintenance (GDMD0922)
On this panel you define your setup of the summary id parts, which includes the number of parts to be used, and how they are related to each other. The information should be completed at the time of installation but you may activate the summary id parts at any time. If you activate the summary id parts after the installation is completed, you must create balances from already existing transactions by running the G/L summary identity rebuild routine.
Function keys
- Summary id part 1-16
- The summary id parts are used to create summary levels for different account combinations that cannot be combined because of the structure of the Account file. The summary id is defined in the same way as the Account file, with up to sixteen different parts, each containing a number of summary id’s that you define in the Summary identity file.
Several account numbers in an account part can then be connected to a summary id in the related summary id part, and a balance is kept on the summary id level. More than one summary id part can be related to the same account part, and as long as balances have not been created, you can change the relation between the summary id parts and the account parts. Summary id’s consist of up to ten characters, and the names of the summary id parts consist of up to twenty characters.
- Related to account part
- Enter the number of the account part to which each summary id part will be related. More than one summary id part can be related to the same account part.
- Changed
- This field is automatically updated if you change a summary id for an account in the Account file. If a field is set to YES, this summary id part will be rebuilt when you run the Rebuild summary identities routine or the Rebuild balances from transactions routine.
- Period
- This field displays the period from which the rebuild will be performed for this summary id part. When the rebuild has been carried out this field will become blank and the Changed field will be reset to NO.