To change the reconciliation setup

If reconciliation setup is completed and operational, it should not be changed. However as during the initial period the need for adaptations can occur, LN contains a number of features that allow you to change the reconciliation setup and preserve the reconciliation possibilities.

Note

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

  • Inventory.
  • Consignment Inventory.
  • Assembly Line WIP.

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

To change 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 the available reconciliation elements are logged in the Reconciliation Transactions (tfgld495) table.

If you first set up reconciliation, it is recommended that you select this check box for the reconciliation groups. To improve performance, you can later clear this check box if you are satisfied that the reconciliation group setup is correct. LN then only logs the reconciliation elements that you assign to the reconciliation group.

In the Reconciliation Groups (tcfin0120m000) session, on the appropriate menu you can click Change Reconciliation Elements. This starts the Change Reconciliation Elements (tcfin0220m000) session, in which you can assign new reconciliation elements to the reconciliation group.

If the Log All Reconciliation Elements check box is selected, all the possible elements are logged for the transactions. This means that for the transactions already logged, the new reconciliation elements are also available. However, 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 is not possible.

To change 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 the 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, it is recommended that you select this check box for all the 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.

In addition, based on your integration mapping scheme setup you can decide which reconciliation groups you don’t use at all and for these groups, clear this check box.