Changing the reconciliation setup

When reconciliation setup is completed and operational, it should not be changed. Should, however, in an initial period the need for adaptations arise, LN provides a number of features that allow you to change the reconciliation setup and preserve the reconciliation options.

Note

If reconciliation data has already been archived and deleted, changing the reconciliation setup will always affect the reconciliation options for these reconciliation areas:

  • Inventory
  • Consigned/Customer Owned Inventory
  • Assembly Line WIP

This is because the credit and debit entries in these reconciliation groups belong to different business objects.

Changing the reconciliation elements

If the Log All Reconciliation Elements check box is selected in the Reconciliation Groups (tcfin0120m000) session, for every integration transaction the values of all available reconciliation elements are logged in a separate table (tfgld498). For each reconciliation group, up to five reconciliation elements can be set up. For some reconciliation groups, for example, Inventory, WIP and Accrual, we recommend that you set up reconciliation elements in order to do proper analysis afterwards.

First reconciliation element at the top level

The first reconciliation element should be the top level, in order to view or print data from high level to detailed level. For example, for Inventory you could specify ‘Warehouse’ as first element, followed by ‘Item Group’, followed by ‘Item’.

If you set up reconciliation for the first time, we recommend that you select this check box for the reconciliation groups. To improve performance, you must clear this check box once you are satisfied that the reconciliation group setup is correct. LN then only logs the reconciliation elements that you have assigned to the reconciliation group.

If reconciliation elements are not selected before reconciliation transactions are logged or if reconciliation elements must be changed, you can change the reconciliation elements afterwards using the Change Reconciliation Elements command. This starts the Change Reconciliation Elements (tcfin0220m000) session, which allows you to assign new reconciliation elements to the reconciliation group. If you need to change reconciliation elements, you can specify the target reconciliation elements in the Target Reconciliation Elements section.

After you have specified the correct reconciliation elements, you must perform these tasks:

  1. Verify the new reconciliation element setup
  2. Accept the new reconciliation element setup
  3. Process reconciliation element changes
Verify the new reconciliation element setup

To check the reconciliation elements, use the Check button. LN then checks for the following:

  • Reconciliation transactions that do not have all reconciliation elements logged.
  • Accepted opening balances for the reconciliation group.
  • Currency differences for the reconciliation group.
  • Posted corrections for the reconciliation group.
  • Rounding differences for the reconciliation group.

If a check fails you will be prompted to continue. If reconciliation is performed based on reconciliation elements, for example, if reconciliation elements are used to create corrections, you might have to change those corrections after the update is completed.

Note

This check is not a mandatory step before you accept the changes in the reconciliation elements. It only indicates which actions or calculations need to be repeated to have the correct data available again.

If, after the check process is completed, you close the session without accepting the change, the Element changes Checked check box is cleared. This is because new transactions can be specified or parameters on the reconciliation group might be reset, which may cause different results the next time the reconciliation group is checked.

Accept the new reconciliation element setup

Once the new reconciliation element setup is correct, this new setup must be accepted. After you have accepted the new setup, new reconciliation transactions are logged with the new elements. The Element changes in process check box will then be selected as well. You can then no longer undo the accepted changes in the reconciliation elements.

Various sessions will show warnings that element changes are in process and that first the elements must be updated for the reconciliation transactions that were already logged.

SessionComments
Print Reconciliation Data (tfgld4495m000)A warning is displayed if for a reconciliation group elements are in the process of being changed.
Operations Management - Financial Reconciliation (tfgld4595m000)A warning is displayed if for a reconciliation group elements are in the process of being changed. As a result, you cannot create corrections or opening balance transactions.
Opening Balances for Reconciliation (tfgld4195m000)If a record is added and elements are in the process of being changed, the new reconciliation element descriptions are displayed.
Checklist Reconciliation Goods Received Not Invoiced (tfgld4495m200)A warning is displayed that tells you that elements are in the process of being changed.
Post Reconciliation Corrections (tfgld4295m300)An error message is displayed that tells you cannot post the corrections.
Accept Reconciliation Data (tfgld4295m000)An error message is displayed that tells you cannot accept data for that reconciliation group.
Finally Accept Reconciliation Data (tfgld4295m100)An error message is displayed that tells you cannot finally accept data for that reconciliation group.
Calculate Currency Differences for Integration Accounts (tfgld4295m400)An error message is displayed that tells you cannot calculate currency differences for that reconciliation group.
Calculate Rounding Currency Differences for Integration Accounts (tfgld4295m500)An error message is displayed that tells you cannot calculate currency rounding differences for that reconciliation group.

 

Process reconciliation element changes

A separate session is available in order to process the element changes for the already logged reconciliation transactions. If possible, the elements are selected from the reconciliation elements table (tfgld498). If that information is not present, the reconciliation element code will be specified, but the reconciliation element value will remain empty.

Note

If only the position of the reconciliation element changes, the information is not read from the reconciliation elements (tfgld498) table, but from the reconciliation data (tfgld495) table. In that case, therefore, not all reconciliation elements required.

You can run the Process Reconciliation Element Changes (tcfin0220m100) session for the reconciliation groups that must be updated. All financial companies that use the same reconciliation group data, are updated. Because this process may take a long time, the following applies:

  • The session can be stopped and restarted at a later point in time.
  • Multiple bshells can be used for this session.

To set up multiple bshells, use the Parallel Processing Configuration (ttaad7520m000) session. This session lists the sessions that can be run in “Parallel Processing Mode”. This list should only include sessions that are specifically designed to run in “Parallel Processing Mode”. A session designed for “Parallel Processing Mode”, is automatically added to the list when it is run for the first time in the current company.

You can create a copy of this record (or change the current record, in which case it is changed for all users), and specify a particular user.

You can specify the number of servers that will be started for this process. We recommend that you specify a number not higher than the number of available CPUs of the server. Additionally, you must set Mode to Manual, Job Process, or Manual and Job Process.

After the process using multiple bshells is started, the update is performed much faster because the workload is divided across several bshells.

Once the process is completed for a reconciliation group, the old reconciliation elements are overwritten by the new reconciliation elements. The Element changes Checked, Accept Element Changes, and Element changes in process check boxes are cleared. If required, you can then once again change the reconciliation elements.

If the Log All Reconciliation Elements check box is selected, all possible elements are logged for the transactions. As a result, for the transactions already logged, the new reconciliation elements are also available.

If the Log All Reconciliation Elements check box is cleared, the values of the new reconciliation elements are not available for the transactions already logged. Reconciliation of these transactions based on the reconciliation elements will not be possible.

Note

Although the Relog and Replace Logged Elements (tfgld4253m000) session allows you to relog the integration and reconciliation elements for integration or reconciliation transactions that were already logged, this session is not designed for relogging elements for large numbers of transactions.

Changing the logging of reconciliation data

If the Write Reconciliation Data check box is selected in the Reconciliation Groups (tcfin0120m000) session, every integration transaction is logged in the Reconciliation Transactions (tfgld495) table.

If this check box is cleared, the transactions of the integration document types belonging to the reconciliation group are only logged in the Integration Transactions (tfgld482) table for mapping and posting to Financials, but the data is not available for reconciliation.

When you first set up reconciliation, we recommend that you select this check box for all reconciliation groups. To improve performance, you can later clear the Write Reconciliation Data check box for reconciliation groups that you do not use, for example, for some of the end accounts.

Also, based on your integration mapping scheme setup, you may decide which reconciliation groups you do not use at all, and for these groups, clear the check boxes.