Reconciliation improvements

Check Mapping Scheme (tfgld4573m000)

To prevent reconciliation problems, several new checks are executed in this session. A warning message is displayed in these situations:

Reconciliation elements have not been specified for reconciliation groups for which Write Reconciliation Data is selected and Basis for Final Acceptance is unequal to Reference Link between Business Objects.
Ledger mapping or dimension mapping is based on elements that have not been specified as reconciliation elements on reconciliation groups for which Write Reconciliation Data is selected and Basis for Final Acceptance is unequal to Reference Link between Business Objects.
Log All Reconciliation Elements is selected for reconciliation groups for which Write Reconciliation Data is selected.

Close Reconciliation Data (tfgld4295m900)

This new session generates reconciliation opening balances for reconciliation groups with a never ending balance, for example, inventory. This enables you to archive the data for which opening balances have been generated and to continue reconciling the data. The session creates the reconciliation opening balances in the next fiscal period by reconciliation element combination.

The value of the Fiscal Period field is retrieved from the last Finally Closed Period in the Period Status (tfgld0107m000) session. The session can be executed only for fiscal periods with the status Finally Closed. The status of the reconciliation data that is available before or in the selected Fiscal Period range, must be Finally Accepted.

Note:

PCS project-related postings have the Project field specified in the reconciliation transactions. Those postings have an ending balance at project closure. Consequently, PCS project-related postings for reconciliation groups with the Basis for Final Acceptance set to Not Applicable, are not closed. For example, Inventory/1-related postings on project items are skipped in this session.

Reconciliation and Archiving Period Status (tfgld0177m000)

The Period Closed and Period Opening Balance fields have been added to this session. These period fields are automatically populated by the Close Reconciliation Data (tfgld4295m900) session.

Change Reconciliation Elements (tcfin0220m000)

This session now considers the Period Reconciled in the Reconciliation and Archiving Period Status (tfgld0177m000) session and changes reconciliation elements only for later periods. For example, if the close reconciliation process is done for 2019\12, the Period Reconciled is set to 2019/12 for the reconciliation group and the reconciliation elements are changed only for the periods later than 2019\12.

We recommend to archive the closed reconciliation data before changing the elements.

A warning message is displayed if opening balances are available. Manual action is required to specify the reconciliation opening balances on the new elements.

Operations Management - Financial Reconciliation (tfgld4595m000)

This session now includes these modifications:

By default, only the open reconciliation data is displayed. If you deselect Show Only Open Reconciliation Data, the closed transactions are displayed and the created opening balances are not shown. In an archiving company, this filter is not available because this company includes only archived data up to and including the closing balance.
For analysis purposes, the Show All command has been added. If this command is selected and the close reconciliation data process was executed with unarchived transactions, duplications will be displayed.
Automatically created opening balances cannot be deleted unless the opening balance amount is zero.
You cannot change manual opening balances or create reconciliation corrections before or in the Period Reconciled.

Print Reconciliation Data (tfgld4495m000)

For reconciliation groups with a never ending balance, for example inventory, the From Automatic Created Opening Balance check box has been added to this session. This check box is applicable only if a Period Opening Balance is available in the Reconciliation and Archiving Period Status (tfgld0177m000) session for the selected reconciliation group.

If this check box is selected:

The From Fiscal Year/Period is defaulted based on the Period Opening Balance in the Reconciliation and Archiving Period Status (tfgld0177m000) session and made unavailable.
The Include Opening Balance Transactions check box is selected and disabled.

If the From Automatic Created Opening Balance check box is cleared, the automatically generated opening balances are skipped.

Note:

For PCS project-related postings, no opening balance is created. Consequently, if you do not change the period for reconciliation in this session, which is defaulted to the opening balance for the reconciliation group, PCS project transactions may be missing on the report.

For example, a PCS item is purchased in period 6 and sold in period 10, so the balance is zero. For reconciliation group Inventory/1, period 8 is closed and an opening balance is created in period 9. When the report is printed for Inventory/1, the From period is automatically set to 9, because that is the period of the opening balance for Inventory /1. However, a balance is shown for the PCS item because only the sales posting is within the period range. The purchase posting of period 6 is not considered. To avoid this and to include all PCS project postings, set the From period to the start of the PCS project and the To period to the closure of the project. In this example, from 6 to 10.

Accept Reconciliation Data (tfgld4295m000)

The Fiscal Period (From) field is now retrieved from the Opening Balance Period field in the Reconciliation and Archiving Period Status (tfgld0177m000) session.

Finally Accept Reconciliation Data (tfgld4295m100)

The Fiscal Period (From) field is now retrieved from the Period Reconciled field in the Reconciliation and Archiving Period Status (tfgld0177m000) session, plus a value of one.

Archive / Delete Reconciliation Data (tfgld4295m200)

For reconciliation groups with a never ending balance, this session now verifies whether the Close Reconciliation Data (tfgld4295m900) session has been run to make sure that opening balances are available for the period after the period range to be archived.

Calculate Currency Differences for Integration Accounts (tfgld4295m400)

Because the automatically generated opening balance for reconciliation is a sum of amounts not related to a rate date, currency differences are not recalculated for these amounts in this session.

Calculate Rounding Currency Differences for Integration Accounts (tfgld4295m500) / Create Reconciliation Corrections (tfgld4295m700)

These sessions now only consider unreconciled data, which is the data that is after the Period Reconciled in the Reconciliation and Archiving Period Status (tfgld0177m000) session.

Correct Project (PCS) in Reconciliation data (tfgld4295m650)

The PCS Project (tfgld495.proj) field, which is filled during logging of the reconciliation data, is not always filled correctly. This can lead to differences between the Print Reconciliation Data Project (PCS) Work in Process (tfgld4495m300) session and the Print Project Work in Process (tipcs3480m000) session.

The new Correct Project (PCS) in Reconciliation data (tfgld4295m650) session is used to correct this PCS Project (tfgld495.proj) field. The session provides a simulate option and process and error reports.