Transaction to New Fact
Table of contents
- 1 Transition of Company Financial Statement to New Facts (NEWFCT)
- 1.1 Brief Description
- 1.2 What Will Happen to the Transition to a New Fact? General Procedure
- 1.3 Synchronize Transition to New Facts
- 1.4 Data Type Transfer to New Accounting Type
- 1.5 Data Type Transition of IC Balances
- 1.6 Data Type Reconciliation of Investment, Capital and Provision Movements, Share Ownership and Development Transactions
- 1.7 Data Type Transfer of Controlling Balances
- 1.8 BUDT Split
- 1.9 Data Types of Statistical Accounts
- 1.10 Country, Group, and Parallel currency
- 1.11 Validity
- 1.12 Tolerating Faulty Data
- 1.13 Origin List
1 Transition of Company Financial Statement to New Facts (NEWFCT)
1.1 Brief Description
The purpose of the NEWFCT application is to transfer balances and transactions from one fact to another for the same accounting period.
The NEWFCT application displays a line for the respective balances and Transaction developments, as well as a status display. The lines are used as a line action to initiate a single reconciliation. The rows for the Transaction developments are determined dynamically using the Transaction developments defined in the TRNDEVDFN application and activated in the PRDDEV and FCTDEV applications.
Figure: Selection of NEWFCT processing
A simultaneous data type reconciliation for several companies is started from the "Transfer to new facts" action in the individual financial statement monitor. Unlike the NEWFCT application, however, it is not possible in the CFSMNR monitor to limit the carry forward to individual areas, e.g. only to the account balances. The message windows issued by the data type reconciliation receive a summary message in the footer. A distinction is made here according to general errors and different warnings, which vary in the response options. Select of the 'Do not show this message again' check box can suppress the display of all message windows during quantity processing with the same summary message. The same user reaction (e.g. 'no processing and next') is assumed in each case. The contents of the message windows are collected and displayed at the exit of the quantity processing in a message window.
1.2 What Will Happen to the Transition to a New Fact? General Procedure
Values are summarized step by step. Each step uses the summarized values of the previous step, i.e. an account change is made with the summarized values of an account for aggregation, if available.
The summary is given in this order:
- Balance plus postings
- Account compression
- Account bill
- Transfer to group chart of accounts with account change at the group chart of accounts level before netting the values (only if there is a transition from the company level to the group chart of accounts or between two group charts of accounts.)
If there are no account balances and only postings are to be processed, at least one account balance with the value of zero must be recorded, otherwise the application will cancel with an error message.
The following branches and workflows are available in the Actions menu or right mouse button:
- Overview displays: Branched to the overview of the selected row, such as account balances, development transactions
- Make transition to new facts: If no data is available on the target data type, all balances and transaction (i.e. carries forward and running order) Transactions). If data is already available on the target data type, the following request is made: Receive carries forward: Existing machine carries forward and IC balances captured on the target data type are retained, other transactions are deleted and reclassified. Overwrite carries forward: All data in the target data type are deleted and recarried forward, except for IC balances that were collected on the target data type. Cancel: Processing stops. No processing and more: The processing of the currently selected data record is aborted and the data type carry forward is initiated for the next marked data record if necessary
- Delete the reconciliation without carries forward to new facts + complete: The target data type does not erase or redirect carry-forward data for development transactions, IC fixed asset transactions, IC account balances.
- Delete all data for new facts and execute: All balances and transactions are deleted on the target data type, except for IC account balances that were captured on the target data type.
Points 2-4 are also available as a "global" function (symbol of the globe), i.e. all data is processed independently of the marking of a row. The other menu items branch into the respective overview.
1. Balance plus postings
Each account balance of the area of origin is combined with all the associated postings.
DA | Konto-Nr. | Saldo | Soll-Buchung | Haben-Buchung |
---|---|---|---|---|
I3 | 20000 | 15.000,00 S | ||
I3 | 20000 | 17.500,00 | ||
I3 | 20000 | 500,00 | ||
I4 | 20000 | 2.000,00 H |
DA | Account No. | Balance | Debit Posting | Credit Posting |
---|---|---|---|---|
I3 | 20000 | 15.000,00 S | ||
I3 | 20000 | 17.500,00 | ||
I3 | 20000 | 500,00 | ||
I4 | 20000 | 2.000,00 H |
2. Account Compression
There is one account for aggregation for several accounts (here Kto. 20000), the account balances are summarized on this account if the summarization indicator is set in the target data type (FCT). If the chart of accounts is also changed during the transition, the compressed balance is first compacted in the background and then transferred to the account assigned to the account for aggregation.
DA | Konto-Nr. | Verdichtungs-Kto. | Saldo |
---|---|---|---|
I3 | 20000 | 20000 | 15.000,00 S |
I3 | 20001 | 20000 | 96.000,00 S |
I3 | 20002 | 20000 | 30.000,00 H |
I3 | 20003 | 20000 | 9.000,00 S |
I4 | 20000 | 90.000,00 S |
DA | Account No. | Summarized Account | Balance |
---|---|---|---|
I3 | 20000 | 20000 | 15.000,00 S |
I3 | 20001 | 20000 | 96.000,00 S |
I3 | 20002 | 20000 | 30.000,00 H |
I3 | 20003 | 20000 | 9.000,00 S |
I4 | 20000 | 90.000,00 S |
3. Account Bill
If there is an account if D/C changed for an account and the balance differs from the default value of the Bil/GuV identifier of the account, the account balance is combined with the balance of the account if D/C changed for the data types transfer.
DA | Konto-Nr. | Bil/GuV Knz. | Wechsel-Kto. | Saldo |
---|---|---|---|---|
I3 | 10000 | 1 (Aktiv) | 20000 | 30.000,00 S |
I3 | 20000 | 2 (Passiv) | 10000 | 90.000,00 S |
I4 | 20000 | 120.000,00 S |
DA | Account No. | Balance Sheet/Income Statement Group | Billing Account | Balance |
---|---|---|---|---|
I3 | 10000 | 1 (Aktiv) | 20000 | 30.000,00 S |
I3 | 20000 | 2 (Passiv) | 10000 | 90.000,00 S |
I4 | 20000 | 120.000,00 S |
4. Transition to group chart of accounts
When the chart of accounts is changed during the data types transfer, e.g. from shareholder to group chart of accounts, the balances of the home account plan are combined on the assigned accounts of the target account plan (here 2000).
DA | Ges.-Konto | Konzern Konto | Saldo |
---|---|---|---|
I3 | 20000 | 2000 | 1.000,00 H |
I3 | 20010 | 2000 | 25.000,00 H |
I3 | 20020 | 2000 | 1.000.000,00 H |
I4 | 2000 | 1.026.000,00 H |
DA | Genes. Account | Group Account | Balance |
---|---|---|---|
I3 | 20000 | 2000 | 1.000,00 H |
I3 | 20010 | 2000 | 25.000,00 H |
I3 | 20020 | 2000 | 1.000.000,00 H |
I4 | 2000 | 1.026.000,00 H |
1.3 Synchronize Transition to New Facts
When this application is invoked, the data type redirection is performed for simulation purposes, but the target data is not rewritten. The new transactions are compared with the existing transactions for this period and any differences are shown in a log. The application generates a set in the Processing control (CMPCNT) with the checkpoint 'SIMVOR' for the result of its check. The message entered there determines the associated status display in the CFSMNR monitor. If no data is available for the comparison data type at all, '-' is displayed as a state in the 'Synchronize data type carries forward' column.
A switch in the data type master data (FCT) can be used to control whether the state displayed in the company financial statements + monitor (CFSMNR) for reconciliation should refer to all data including statistical accounts 'S', only to the balance sheet 'B' or only to the P+L 'G'. However, this does not limit the minutes of the reconciliation.
1.4 Data Type Transfer to New Accounting Type
If the target data type is assigned an accounting type and the transition would result in data being generated on accounts that are assigned to another accounting type, the user is notified of this fact in a message window with a warning message. The following choices are available, and the answer is global for all of the following data with this constellation:
- Writing without reference to RelArt: Only records for source accounts whose accounting type is either blank or is consistent with the accounting type of the target data type are transferred.
- Write all data: As before, all data is transferred independent of the accounting type. The state of the account balances is set to red on the target data type and any corrections must be made.
- No Processing or Cancel: This cancels all processing.
1.5 Data Type Transition of IC Balances
The target account of an IC balance corresponds to the target account of the associated account balance, which is determined as described above. The IC balances are summarized for each target account, IC company, FXCDE of the transaction currency and Controlling object if the summarization indicator is set in the target data type. Otherwise, they will be forwarded in full detail. Transferred IC balances are assigned a flag (origin of data type transfer) so that only these IC balances are deleted in the event of a new transfer. IC balances already manually entered on the target data type are retained. When referring to a fact with the carry-forward switch set in the FCT, the IC account balances carried forward are only deleted if the switch is also set in the source data type and if 'Delete and rewrite carries forward' is transferred. Translated with 'carries forward received', both in the target and source facts, the IC account balances presented are excluded from processing.
If an account with IC company in the account master data (IC general account) is transferred to an account with IC details, an IC account balance is automatically generated for this target account.
If an IC company is specified on a posting on an IC account, this posting is not only summarized with the account balance, but an IC balance equal to the posting is also generated.
In the data types transfer of IC account balances, the digit indicator is transferred to the next fact by an IC balance reconciliation in addition to the attributes 'Reference document no.' and 'Reference document date'. This means that a manually or mechanically set number plate through an IC balance reconciliation in the company financial statement also acts on the Group level.
The status determination for the group financial statement checks, among other things, whether a consolidation voucher number has already been entered as evidence of consolidation in the IC account balances relevant for consolidation. This entry is retained when the individual financial statement data are transferred again from the previous fact, insofar as this data has not changed so that the state of the associated consolidation functions ('CD' and 'IE') remains 'green'. The report "After carry forward, the SC and alternative development measures have been carried out in full. Per. Necessary" only applies if the document numbers were already entered in the previous data and the new data does not fully match. Please note that when you repeat the debt or expense/income consolidation process, manual offsetting entries are made for the " delete+autom.schulkons. CD.'. Manual postings are detected based on the posting status '5'. In accordance with the transaction currency and/or business area combination, they may also be assigned to another accounting record number. Exception: Manual reconciliation postings (and any non-matching additional entries) from a previous clearing are then not inserted back into the CNSPST if a) amounts have been changed at the IC balances and now receivables and payables exactly match b) a consolidation voucher was not recreated for the CD clearing again because there are no IC balances available for the respective pair any more, c) the checkmark setting 'Manual' All postings' in the CNSPAR application is set to '0' (manual postings are deleted).
1.6 Data Type Reconciliation of Investment, Capital and Provision Movements, Share Ownership and Development Transactions`
For all transactions: The reconciliation only takes place if the appropriate indicators have been set in the applications data types/transaction development area FCTDEV For all transactions: The reconciliation only takes place if the appropriate indicators have been set in the applications data types/transaction development area PRDDEV.
In the event of a switch from shareholder to group chart of accounts in the event of a transfer, the transactions are reclassified to the target account of the associated account balances. Fixed asset transaction transfers to the assigned fixed asset objects for the group chart of accounts.
If posting keys are specified in postings for the corresponding details, these postings are not only summarized with the account balance, but also the corresponding transactions are generated in the amount of the postings.
The status determination for the group financial statement checks, among other things, whether a consolidation voucher number has already been entered as evidence of consolidation in the shareholding transactions relevant for consolidation. This entry is retained when transferring the individual financial statement data from the previous fact, provided that this data has not changed so that the state of the associated consolidation functions ('CC') remains 'green'. If an individual record is changed, the document number is only deleted for that single record. The report "Necessary for further carry forward in the case of section xx after completion of further execution of the Ledger!" only applies if an already consolidated shareholding rate has been completely excluded. However, the status is not changed (stays 'green'). The user must carry out the necessary consolidation steps or corrections himself.
1.7 Data Type Transfer of Controlling Balances
The carry forward of controlling balances only takes place when the controlling balance flag in the target data type has been set in the FCT application (the controlling balances need not be complete). If there is a summarization controlling object for several controlling objects, the balances are summarized on this controlling object. The compression is controlled using a compression indicator similar to the account balances. A summarization controlling object may not have an aggregation indicator.
If the carry forward involves a change from shareholder to group chart of accounts, the controlling balances are reclassified to the assigned group controlling objects. The target account corresponds to the target account of the related account balance, which is determined as described above.
If a controlling object is specified in a posting, this posting is not only summarized with the account balance, but a controlling balance equal to the posting is also generated.
1.8 BUDT Split
The splitting of account balances between business units, which is usually carried out based on the controlling balances, is also possible if the switch for the management of controlling balances is not set for the source fact. In this case, controlling balances are not taken into account and the transfer is only made to the business units specified in the account master data or chart of accounts. For this purpose, an assignment to one business unit is required in the master data of the home control objects (CNT).
The "BUDT split" takes into account the shareholder business unit assignments (COBUALC) as follows:
- If a business unit is uniquely assigned to a company, all transferred data is allocated to that business unit, regardless of the information provided by the controlling object, account or chart of accounts.
- If a business unit is uniquely assigned to a company for the balance sheet or the income statement (as per the Account group attribute in the CESU), all transferred data on balance sheet or income statement accounts are allocated to this business unit, regardless of the information provided by the controlling object, account or chart of accounts.
- If the business unit is uncertain according to previous conditions and a record is broken down to a business unit that is not permitted according to the CUSTOMER as per the information in controlling object, account or chart of accounts, then this is reported as an error and processing is aborted.
For accounts with controlling breakdown, the first thing to check is whether the details corresponds with the account balance. The controlling balances are then assigned to the business units and divided up according to the account balance. Since any parallel details of IC balances cannot be properly split, such a details is assigned to any business unit and a warning is output for the corresponding accounts.
In the case of the BUDT split, the net profit is generally not divided equally between the business units for balance sheet and P&L. To compensate for the difference, an account with the account number ="U" in the target account plan can be set up. This account may be an asset, liability, expense or income account. Balances are then automatically generated on this account during carry forward.
1.9 Data Types of Statistical Accounts
In the data type master data (FACE) there is an entry field "Account group for matching transition to fact". This contains the following characteristics: 'B' for comparison of balance sheet, 'G' of P+L and 'S' incl. statistical accounts. If 'S' is specified, there is no restriction in the case of the carry-forward reconciliation (SIMVORSAL) according to the Bil/GuV indicator.
1.10 Country, Group, and Parallel currency
The three values of the currencies are treated differently at the high - level event:
The local currency value is transferred without any changes.
When country and group currency are equal, the consolidated currency value is filled with the country currency value. For investment, capital and provision movements as well as in shareholdings, if country and group currency are different and the conversion rule is 'VKW', the consolidated currency value is transferred without any change. In all other cases, the Group currency value is set to zero.
The parallel currency value is always set to zero.
1.11 Validity
If the target account or one of the suspense accounts is not valid in the period, an error message is displayed when it is summarized. This contains the home account from which the invalid account can be searched.
1.12 Tolerating Faulty Data
Inconsistent account balances in the source area result in a back out of the transition. With regard to the drill-down data, an error in the source area only leads to a warning. The data is still uploaded. For IC balances, this warning is also suppressed if the business area processing indicator is set in the source data type and not in the target data type.
1.13 Origin List
Controlled by attributes of the target data type (entry in FCT), an origin list for the account and/or controlling balances can also be written during uppercut. This makes it possible to identify the source data that a balance is made up of in the target area.