Prerequisites

You have created at least one data slice and at least one reconciliation rule as described in Customizing Reconciliation .

Procedure

Reconciliation processing in Grants Management consists of two programs, which you can run in any order you like. To access them, go to the Easy Access menu and choose Accounting ® Public Sector Management ® Grants Management ® Grantee Management ® Information System ® Reconciliation . Then proceed as described below.

Reconciliation Analysis Report

In the selection screen, specify the ID of the reconciliation rule you want to use and choose Execute .

If you have already run the program for this rule and you saved the results of the previous run, you can call them up again. To do so, choose Select Saved Results and enter the date and time data requested by the system. When you press Execute , the desired saved results appear.

The Specify Reconciliation Selection Criteria screen appears. It contains a number of tabs; the number varies depending on how the rule in question is configured. The first one is always the General Data tab, which contains the following selection fields:

Fiscal Year

Posting Period, with from and to options so that you can specify a range

Selection Fields for this Rule

These were specified in customizing for the rule.

When you have made all your selections, choose Execute .

The resulting analysis shows the balances that do not match (indicated by) and those that do (indicated by =) unless you configured the rule so that only the unmatched data is displayed.

The list offers the following features:

Breakdown button

When the report is initially displayed, the subtotals are further broken down by the fields specified in customizing as First and Second Level Breakdown, if any. Use this button to change the fields used for the breakdown, if desired.

Match items

Highlight a line in the analysis and choose this button. The system asks you whether you want to have the resulting display show items that do match and/or items with zero balances, in addition to items that do not match. Make your selection and choose Enter .

The next screen shows the items relating to the line you highlighted. Items that do not match have a symbol in the result status icon column, explaining why. For example, an arrow pointing left indicates that there was information for the left side of the equation only, none for the right side. Use the F1 help to display a full list of the icons.

Double click the document number to display the original document, such as a purchase order, whose data is displayed.

Use the Definition button to display the rule or data slice being applied here. If the cursor is in a particular data slice column, the data slice definition is displayed; otherwise, the rule is displayed. There is also a Display Report Criteria option you can use to display the selection criteria used for this report run.

With the Save Overview Results button, you can save the results of this reconciliation run to view them at a later point.

With the Background Load option, you can select lines in the overview report to have item-level data matching loaded in a background job. You can retrieve and analyze the results when the background job is complete.

Reconciliation Rules Check

Specify the following in the selection screen:

The rule(s) whose data you want to analyze

If you want to save out of balance results for later analysis, check the relevant box. You also need to specify how long the results should be stored before they are purged and the maximum number of nodes to be saved. (Out of balance results are saved for the lowest level detail lines in the report, called “nodes”.) You should keep the number of nodes to be saved as low as possible, to avoid saving excessive amounts of data.

The data selection section of the screen allows you to select single funds, FM areas, and company codes, or ranges of them. You also need to enter a time selection, which you can configure as follows:

Up to last closed period

We recommend that you use this approach so that the analysis does not include data from periods that are still open and data is still being entered.

If you choose this option, you need to maintain the Basis for Closed Period determination section too. Specify the relevant company code, account type (“+ “selects all account types, otherwise choose F4 for a list of the available options).

Specified Period

If you choose this option, you need to go to the Specified Periods section and stipulate the fiscal year and posting periods whose data you want to check.

When you have made your selections, choose Execute .

The resulting analysis is similar to that arrived at in the reconciliation analysis described above. However, the functions in the analysis are more limited. No drilldown or breakdown are available, and matching is possible only at the lowest level.