Show TOC

Function documentationUtility Programs Locate this document in the navigation structure

 

The selection screens offer the following utility programs that you can use to assist you with your reporting:

  • List of Totals Records

    You use this utility program to obtain an overview of the balances between affiliated companies. Furthermore, you can use this program to send balance confirmations or to communicate any large differences to those responsible for reconciliation.

  • List of Documents

    You can use this utility program to display documents (for example, to check whether specific documents were included in a data selection).

  • Delete Transaction Data

    You can use this utility program to delete from the reconciliation system any transaction data that you no longer require and to set balances to zero. You do not need to have created any special purpose ledger for this.

  • Delete Transaction Data and Index Tables

    You can use this utility program to delete from a reconciliation system any transaction data - including index tables - that you no longer require for a special purpose ledger or for an entire table group of ledgers. For this utility program, you need to have created a special purpose ledger. For more information, see the program documentation.

  • Recalculate Totals

    You can use this utility program to recalculate totals when inconsistencies arise between totals records and documents. This program is executed automatically after data selection. You can also use this program if differences between the totals data and the document data occur, for example, as a result of transaction data having been deleted.

  • Development of Differences

    You can use this utility program to check how differences have developed over time.

Features

Development of Differences

You can use this utility program to create snapshots of the current differences and then compare those snapshots against those created previously.

Creation of Snapshots

To create a snapshot of current differences, proceed as follows:

  1. In all screen areas, enter the data for which you want to create a snapshot.

  2. Select the Calculate Current Differences checkbox.

  3. Choose Execute (Execute).

Recommendation Recommendation

Create snapshots on a regular basis. You could, for example, add the creation of snapshots as a step in the job chain for performing data selection and automatic assignment.

End of the recommendation.

Note Note

The amounts for snapshots are translated, using the current exchange rate, from the transaction currency to the default display currency defined in Customizing. The translated amount is entered into the snapshot. On the selection screen of this program for analyzing the development of differences, you can specify a display currency for the current program run. The program uses the current exchange rate to translate the snapshot amounts into the specified display currency.

End of the note.
Analysis of Snapshots

Once you have created one or more snapshots, you can analyze them in detail. For this, proceed as follows:

  1. In all screen areas, specify the snapshots that you want to analyze.

  2. Do not select the Calculate Current Differences checkbox.

  3. Choose Execute (Execute).

Example Example

You would like to analyze the development of differences for a specific business relationship within a given period. On the selection screen, you specify the company, the trading partner, the year, and the period, and you then choose Execute (Execute).

End of the example.

The program shows you all existing snapshots corresponding to the criteria specified. The different columns show the development of the differences. Alongside each amount column, there is a column containing a symbol denoting how the difference has changed. For more information, see the field documentation.

Note Note

In the Navigate column, there is an arrow for the last relevant entry of a business relationship. When you select this arrow, the program calls up interactive reconciliation for the selected business relationship with the corresponding parameters (year, period, and display currency).

End of the note.

You can use the standard functions for the ALV Grid to adapt the layout to your requirements. Note that the changes calculated for the differences are based on the original sequence of the data records and are not adapted to the current display.

Furthermore, you can use the following functions:

  • If you have the relevant authorization, you can delete individual snapshots.

  • You can navigate to the display of the current status of the selected companies. From there, you can navigate to the log display screen.

  • With Send Message to Default Contact Person (Send Message to Default Contact Person), you can use a message template to send the selected data records to the default contact person of the relevant companies or trading partners.

  • With Send Message with Dialog (Send Message with Dialog), you can use a stored message template to send the selected data records to any recipient.

Activities

To call these programs, choose the Utility Programs pushbutton in the selection screen of one of the programs for intercompany reconciliation.