Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Forms IC-Account Balances


Table of Contents


1 General Information

This application allows you to enter IC subaccount balances with the help of forms. All of the existing IC subaccount balances that may be changed will be displayed for each account in the selected chart of accounts. In addition, an input line will be made available for each account number so that the next balance can be entered. As long as the account balance does not match the sum of the respective IC account balances, the sum line will be shown in red.

Image: Overview I-ICKTOSAL

You can find the application in the menu trees (resource tree and quick starter) below the menu <Master files>, below the submenu <Company financial statements / Entry>.

2 Selection Possibilities

Image 2:Selection possibilities in form entry of IC balances

The keys 'Company', 'Period' and 'Type of Data' as well as 'Business Unit' must be entered clearly to start with. In order to be able to enter data, however, you will need to or be able to make additional entries:

Column option: A distinction is made between the following versions:

  • Column option ‘K‘ (is also the default value when called up directly) corresponds to the entry view. In addition, a comparative period and/or comparative type of data may be listed. A column that contains the comparative data will then be displayed next to the entry column that shows the existing data, but does not allow for any entries to be made. This makes it possible to preset the entry lines with the IC companies that were also addressed in the comparative environment.
  • Column option 'P': This column option allows for IC account balances to be entered simultaneously for multiple periods. In this case, the 'From Period' and duration between periods must also be specified in the selection area. Furthermore, a comparative period can also be displayed on an optional basis. As in the form entry for account balances (I-KTOSAL) section, an entry column is included for each period specified. With this version, only one line will be provided per IC company. If multiple sets of data already exist for one IC company, the respective sum will be shown, however this value cannot be changed. If a comparative type of data is also listed under the column option 'P' (this can be the same type of data as the one contained in the previous entry field), the two possibilities mentioned before will be combined. The first column for the previous period becomes a display column for comparative data that does not allow for any entries to be made. This can be used, for instance, to record plan data for 4 quarters of the new year and display the current data from the previous year as comparative values. If you branch from this list via object menu (right mouse key) into the forms entry application for detail data or another subsequent application with reference to a period, then now the column of the selected line is evaluated so that the subsequent application is provided with the respective period or business unit, respectively, as a parameter.

Image 3: Documentation of multiple periods using the column option ‘P‘ and intervals between periods ‘03‘

[Account group]: If a business unit in the company and business unit allocation <GESUBR> is attributed to an account group (P for P+L accounts, for example), only the accounts from this account group will be displayed in the form entry area.

[From period]: With multiple recording of periods, the entry from the first entry period is displayed here

[Period Dist]: If more than one periods have been entered, the interval between periods should be entered here: 01 for monthly, 03 for quarterly and 12 for annual entries.

[Account number]: Via 'account number' that can be entered optionally, yet another limit can be applied to the display.

[Language]: By entering a language, you can control whether the accounts are to be displayed in a different language than that of the user.

3 Operation

Entry of data Operation takes place as in entering account balances: The buttons <TAB> and <ENTER>move the cursor into the respective next cell that is capable of accepting entries. A new input line for the same account will be automatically added to the table after the last entry cell by pressing <ENTER>. It is possible to change the entry line of another account by pressing <TAB> or by using the mouse. Analogous to form entry of account balances (I-KTOSAL), you will not be able to enter a debit/credit code. This will be considered to be a default value in accordance with the balance / P+L code of the account. Deviating debit/credit codes can be achieved by entering negative values.

Accounts that are invalid for the current period or type of data or are not authorized to accept entries will not even be offered in the form entry area to start with. If values already exist for the current period, these will be displayed with a grey background and cannot be changed (see

If the option <Feld select“> is selected under <Display > shown in the option dialog (Menu bar), the cell contents can be copied over to the clipboard using the key combination <Strg>C.

Table lines: There are 3 types of table lines:

  • Data lines: The data lines show all of the existing IC subaccount balances, sorted by account number. In addition, the account designation, the balance/P+L code and the account codes 1 and 2 will be shown. Changes in the balances can be made in these lines.
  • Input line: The input line is the line for entering new balances. The input line consists of the output field for the account number and visible entry fields for IC company and value in local currency. In addition, there are columns for the additional optional attributes of the IC subaccount balance.
  • Sum lines: The sums of the acquired values will be displayed automatically in the local currency in the sum lines for each account. Parallel to this, the respective values taken from the account balances (KTOSAL) will be displayed. After they've been saved, if there are differences, the amount of the difference will be shown in local currency in the entry line. In this case, the account flag will be coloured red. No audits will be performed while data is being entered.

Saving data: By pressing the <Save> button, all of the existing and perhaps modified and recorded data will be forwarded to the importing application TXTICSALD , where it will be checked and entered into the database. Existing data will be updated, if necessary. Once it has been saved, a plausibility check will be performed on the data and the results will be shown in a message window if an error has been found. In addition, the attribute that contains the error will be highlighted by marking it with a colour code. This can also apply to the cell of the additional data if one of the attributes here is defective.

Additional data (Additional data) stands for the additional attributes that possibly need to be added to an IC balance: remark text, controlling object, reference voucher number and date, clearing code and value and the currency code of the transaction currency. If additional information exists on a column, this will be shown by a small flag (small red triangle) displayed inside the cell. If the mouse remains on one of these cells for a moment, the existing additional attributes or those that have been stored will be displayed in the tool tip. Double-clicking onto one of these cells opens up a dialog box inside which the respective additional attributes may be entered or changed. As an alternative, the cursor may stop on <Tab> on this cell to open the additional dialogue by pressing the key <F5>. Furthermore, the important information fields from the additional entries will also be displayed in the overview.

Image 4: Entry of additional data

Image 5: Displaying additional data (Additional data)

Transaction currency: If the selection for the maintenance of transaction currency amounts in the consolidation function master data <KVA> is switched to "X" (Transaction Currency <TW> entry is obligatory) or "L" (Transaction Currency <TW> entry is obligatory, otherwise local currency <LW>), additional columns for entering a Transaction currency value and a Transaction currency code will appear automatically so that no longer need to be taken care of under additional information.

Image: Setting in KVA AE

Image: Columns for the transaction currency

If the flag for the maintenance of transaction currency amounts in the consolidation function master data <KVA> is switched to <L> (transaction currency is required, but local currency is alternatively used if local currency equals group currency) then the forms application for intercompany account balances always offers an entry column for the amount in transaction currency even if local currency equals group currency and the local currency amount is used as a default. The multi-period form is excluded from this, here transaction currency amounts have to be entered in the additional dialogue.

4 Actions

The following actions can be started from the action menu for form entry of IC balances:

  • Save: The action <Save> results in a check being performed on the data that has been recorded and it being transferred to the database. Data will be entered or modified. Nevertheless, no data will be deleted, therefore values that have been changed to zero will be retained as zero values in the database and can only be completely deleted with the application <ICKTOSAL>.
  • Company financial statements + monitor: By calling up this menu, you'll be able to switch between the company that needs to be worked on and the overview contained in the company financial statements + monitor.
  • IC subaccount balances: With this function, you'll be able to branch off into the IC subaccount balances overview (ICKTOSAL) of the company you are currently working on in order to view the data that has already been entered.
  • Form.Entry Postings: This function allows you to branch off into the form entry section for company financial statement postings (I-BUCH) so that the data that has already been entered can be displayed and changed, if necessary.
  • Form.Completion Account Balances: This function allows you to branch off into form entry of account balances (I-KTOSAL) in order to be able to display the data that has been entered thus far and change it, if necessary.
  • Additional data (Additional data) This function allows for the dialogue on entering additional data to be opened for an IC balance. The prerequisite is that the line that contains the data to be maintained has to be marked.

The following applications that are marked with a globe refer to the whole of the selected data, half a globe refers only to the lines marked for these actions. If multiple lines have been marked, the following applications can be called up one after another line by line by pressing the button <Continue>.

5 Access rights

Due to the fact that the application can be used to obtain an overview and not only to make entries, this application can also be used by users who only have display access rights. If the user does not have the right to change or enter data, the entry line will be shown, but cannot be filled.

Accounts that are invalid for the current period or type of data or not entitled to make entries (for instance, if the respective period code Y, Q or M has not been placed in the account master, will not be offered for entries in the form entry area. If values already exist for the current period, these will be displayed with a grey background and cannot be changed. This might result in a situation in which values can only be entered in some of the columns if the period code in KTO has been issued in a differentiated manner for entering multiple periods.

Published:

Forms IC-Account Balances


Table of Contents


1 General Information

This application allows you to enter IC subaccount balances with the help of forms. All of the existing IC subaccount balances that may be changed will be displayed for each account in the selected chart of accounts. In addition, an input line will be made available for each account number so that the next balance can be entered. As long as the account balance does not match the sum of the respective IC account balances, the sum line will be shown in red.

Image: Overview I-ICKTOSAL

You can find the application in the menu trees (resource tree and quick starter) below the menu <Master files>, below the submenu <Company financial statements / Entry>.

2 Selection Possibilities

Image 2:Selection possibilities in form entry of IC balances

The keys 'Company', 'Period' and 'Type of Data' as well as 'Business Unit' must be entered clearly to start with. In order to be able to enter data, however, you will need to or be able to make additional entries:

Column option: A distinction is made between the following versions:

  • Column option ‘K‘ (is also the default value when called up directly) corresponds to the entry view. In addition, a comparative period and/or comparative type of data may be listed. A column that contains the comparative data will then be displayed next to the entry column that shows the existing data, but does not allow for any entries to be made. This makes it possible to preset the entry lines with the IC companies that were also addressed in the comparative environment.
  • Column option 'P': This column option allows for IC account balances to be entered simultaneously for multiple periods. In this case, the 'From Period' and duration between periods must also be specified in the selection area. Furthermore, a comparative period can also be displayed on an optional basis. As in the form entry for account balances (I-KTOSAL) section, an entry column is included for each period specified. With this version, only one line will be provided per IC company. If multiple sets of data already exist for one IC company, the respective sum will be shown, however this value cannot be changed. If a comparative type of data is also listed under the column option 'P' (this can be the same type of data as the one contained in the previous entry field), the two possibilities mentioned before will be combined. The first column for the previous period becomes a display column for comparative data that does not allow for any entries to be made. This can be used, for instance, to record plan data for 4 quarters of the new year and display the current data from the previous year as comparative values. If you branch from this list via object menu (right mouse key) into the forms entry application for detail data or another subsequent application with reference to a period, then now the column of the selected line is evaluated so that the subsequent application is provided with the respective period or business unit, respectively, as a parameter.

Image 3: Documentation of multiple periods using the column option ‘P‘ and intervals between periods ‘03‘

[Account group]: If a business unit in the company and business unit allocation <GESUBR> is attributed to an account group (P for P+L accounts, for example), only the accounts from this account group will be displayed in the form entry area.

[From period]: With multiple recording of periods, the entry from the first entry period is displayed here

[Period Dist]: If more than one periods have been entered, the interval between periods should be entered here: 01 for monthly, 03 for quarterly and 12 for annual entries.

[Account number]: Via 'account number' that can be entered optionally, yet another limit can be applied to the display.

[Language]: By entering a language, you can control whether the accounts are to be displayed in a different language than that of the user.

3 Operation

Entry of data Operation takes place as in entering account balances: The buttons <TAB> and <ENTER>move the cursor into the respective next cell that is capable of accepting entries. A new input line for the same account will be automatically added to the table after the last entry cell by pressing <ENTER>. It is possible to change the entry line of another account by pressing <TAB> or by using the mouse. Analogous to form entry of account balances (I-KTOSAL), you will not be able to enter a debit/credit code. This will be considered to be a default value in accordance with the balance / P+L code of the account. Deviating debit/credit codes can be achieved by entering negative values.

Accounts that are invalid for the current period or type of data or are not authorized to accept entries will not even be offered in the form entry area to start with. If values already exist for the current period, these will be displayed with a grey background and cannot be changed (see

If the option <Feld select“> is selected under <Display > shown in the option dialog (Menu bar), the cell contents can be copied over to the clipboard using the key combination <Strg>C.

Table lines: There are 3 types of table lines:

  • Data lines: The data lines show all of the existing IC subaccount balances, sorted by account number. In addition, the account designation, the balance/P+L code and the account codes 1 and 2 will be shown. Changes in the balances can be made in these lines.
  • Input line: The input line is the line for entering new balances. The input line consists of the output field for the account number and visible entry fields for IC company and value in local currency. In addition, there are columns for the additional optional attributes of the IC subaccount balance.
  • Sum lines: The sums of the acquired values will be displayed automatically in the local currency in the sum lines for each account. Parallel to this, the respective values taken from the account balances (KTOSAL) will be displayed. After they've been saved, if there are differences, the amount of the difference will be shown in local currency in the entry line. In this case, the account flag will be coloured red. No audits will be performed while data is being entered.

Saving data: By pressing the <Save> button, all of the existing and perhaps modified and recorded data will be forwarded to the importing application TXTICSALD , where it will be checked and entered into the database. Existing data will be updated, if necessary. Once it has been saved, a plausibility check will be performed on the data and the results will be shown in a message window if an error has been found. In addition, the attribute that contains the error will be highlighted by marking it with a colour code. This can also apply to the cell of the additional data if one of the attributes here is defective.

Additional data (Additional data) stands for the additional attributes that possibly need to be added to an IC balance: remark text, controlling object, reference voucher number and date, clearing code and value and the currency code of the transaction currency. If additional information exists on a column, this will be shown by a small flag (small red triangle) displayed inside the cell. If the mouse remains on one of these cells for a moment, the existing additional attributes or those that have been stored will be displayed in the tool tip. Double-clicking onto one of these cells opens up a dialog box inside which the respective additional attributes may be entered or changed. As an alternative, the cursor may stop on <Tab> on this cell to open the additional dialogue by pressing the key <F5>. Furthermore, the important information fields from the additional entries will also be displayed in the overview.

Image 4: Entry of additional data

Image 5: Displaying additional data (Additional data)

Transaction currency: If the selection for the maintenance of transaction currency amounts in the consolidation function master data <KVA> is switched to "X" (Transaction Currency <TW> entry is obligatory) or "L" (Transaction Currency <TW> entry is obligatory, otherwise local currency <LW>), additional columns for entering a Transaction currency value and a Transaction currency code will appear automatically so that no longer need to be taken care of under additional information.

Image: Setting in KVA AE

Image: Columns for the transaction currency

If the flag for the maintenance of transaction currency amounts in the consolidation function master data <KVA> is switched to <L> (transaction currency is required, but local currency is alternatively used if local currency equals group currency) then the forms application for intercompany account balances always offers an entry column for the amount in transaction currency even if local currency equals group currency and the local currency amount is used as a default. The multi-period form is excluded from this, here transaction currency amounts have to be entered in the additional dialogue.

4 Actions

The following actions can be started from the action menu for form entry of IC balances:

  • Save: The action <Save> results in a check being performed on the data that has been recorded and it being transferred to the database. Data will be entered or modified. Nevertheless, no data will be deleted, therefore values that have been changed to zero will be retained as zero values in the database and can only be completely deleted with the application <ICKTOSAL>.
  • Company financial statements + monitor: By calling up this menu, you'll be able to switch between the company that needs to be worked on and the overview contained in the company financial statements + monitor.
  • IC subaccount balances: With this function, you'll be able to branch off into the IC subaccount balances overview (ICKTOSAL) of the company you are currently working on in order to view the data that has already been entered.
  • Form.Entry Postings: This function allows you to branch off into the form entry section for company financial statement postings (I-BUCH) so that the data that has already been entered can be displayed and changed, if necessary.
  • Form.Completion Account Balances: This function allows you to branch off into form entry of account balances (I-KTOSAL) in order to be able to display the data that has been entered thus far and change it, if necessary.
  • Additional data (Additional data) This function allows for the dialogue on entering additional data to be opened for an IC balance. The prerequisite is that the line that contains the data to be maintained has to be marked.

The following applications that are marked with a globe refer to the whole of the selected data, half a globe refers only to the lines marked for these actions. If multiple lines have been marked, the following applications can be called up one after another line by line by pressing the button <Continue>.

5 Access rights

Due to the fact that the application can be used to obtain an overview and not only to make entries, this application can also be used by users who only have display access rights. If the user does not have the right to change or enter data, the entry line will be shown, but cannot be filled.

Accounts that are invalid for the current period or type of data or not entitled to make entries (for instance, if the respective period code Y, Q or M has not been placed in the account master, will not be offered for entries in the form entry area. If values already exist for the current period, these will be displayed with a grey background and cannot be changed. This might result in a situation in which values can only be entered in some of the columns if the period code in KTO has been issued in a differentiated manner for entering multiple periods.

For an optimal Community experience, Please view on Desktop
Powered by Zendesk