Show TOC

Process documentationReconciling Group Receivables/Payables (Cross-System) Locate this document in the navigation structure

 

This program supports you in the reconciliation of open items of associated companies within the group. It reads the open items of selected companies for the key date specified, thereby helping you to identify documents that cause a difference.

This graphic is explained in the accompanying text.

Overview of Process Steps

Intercompany reconciliation distinguishes between the following processes:

  • Process 001

    Reconciliation of Open Items in General Ledger

  • Process 002

    Reconciliation of G/L Account Line Items

  • Process 003

    Reconciliation of Open Items in Accounts Receivable and Accounts Payable

Processes 001 and 003 usually relate to the reconciliation of payables and receivables within the group. Depending on your business processes, it may be useful to use processes 001 and 003 separately or to integrate the open items of one process into the other process. Both variants are supported.

You can use process 002 to reconcile accounts that are not managed on an open-item basis. Usually, postings to revenue and expense accounts are reconciled in this process. For more information, see the documentation on the Customizing activities.

Prerequisites

  • In the Customizing settings for the group structure, you have assigned the company codes to the corresponding companies.

  • You have defined the number of the trading partner in the customer and vendor master data.

  • With the integration of G/L open items, a trading partner was assigned for relevant G/L items during posting, or the number of the trading partner is stored in the G/L accounts.

  • In Customizing, you have made the relevant settings:

    To make the Customizing settings for Accounts Receivable and Accounts Payable, use the following menu path:

    • If you use classic Financial Accounting:

        Financial Accounting   Accounts Receivable and Accounts Payable   Business Transactions   Closing   Count   Cross-System Intercompany Reconciliation  

    • If you use new Financial Accounting:

        Financial Accounting (New)   Accounts Receivable and Accounts Payable   Business Transactions   Closing   Count   Cross-System Intercompany Reconciliation  

Business Add-Ins

You can implement the following Business Add-Ins (BAdIs) to tailor the functions in the process to your needs:

  • FB_ICRC_003(Intercompany Reconciliation: Exits Customer/Vendor Open Items)

    You find this BAdI in Customizing under the following paths:

    • If you use classic Financial Accounting:

        Financial Accounting   Accounts Receivable and Accounts Payable   Business Transactions   Closing   Check/Count   Cross-System Intercompany Reconciliation   Preparations in the Sender System   Open Item Reconciliation   Define Enhancements  .

    • If you use new Financial Accounting:

        Financial Accounting (New)   Accounts Receivable and Accounts Payable   Periodic Processing   Check/Count   Cross-System Intercompany Reconciliation   Preparations in the Sender System   Open Item Reconciliation   Define Enhancements  .

  • FB_RC_ASSIGNMENT (Reconciliation: Exits Processed During Document Assignment)

    You find this BAdI in Customizing for Accounts Receivable and Accounts Payable under the following paths:

    • If you use classic Financial Accounting:

        Financial Accounting   Accounts Receivable and Accounts Payable   Business Transactions   Closing   Check/Count   Cross-System Intercompany Reconciliation   Preparations in the Reconciliation System   Data Assignment   Define Enhancements  .

    • If you use new Financial Accounting:

        Financial Accounting (New)   Accounts Receivable and Accounts Payable   Periodic Processing   Check/Count   Cross-System Intercompany Reconciliation   Preparations in the Reconciliation System   Data Assignment   Define Enhancements  .

  • FB_RC_PRESENTATION (User Interface for Reconciliation: Exits)

    You find this BAdI in Customizing for Accounts Receivable and Accounts Payable under the following paths:

    • If you use classic Financial Accounting:

        Financial Accounting   Accounts Receivable and Accounts Payable   Business Transactions   Closing   Check/Count   Cross-System Intercompany Reconciliation   Preparations in the Reconciliation System   Data Reconciliation   Define Enhancements  .

    • If you use new Financial Accounting:

        Financial Accounting (New)   Accounts Receivable and Accounts Payable   Periodic Processing   Check/Count   Cross-System Intercompany Reconciliation   Preparations in the Reconciliation System   Data Reconciliation   Define Enhancements  .

Process

  1. Start the data selection.

  2. Where applicable, check the status of the data selection.

  3. Start the automatic assignment.

  4. Check the status of the reconciliation run.

  5. Reconcile the remaining items interactively.

  6. You make any necessary adjustment postings.

  7. Repeat steps 1 to 6 until no further differences are found or the differences are within the tolerances dictated by your group guidelines.

Note Note

Typically, you schedule the data selection and the automatic assignment to occur in jobs at regular intervals. In the case of large volumes of data, the automatic assignment can take a relatively long time because the open items of all business relationships need to be processed. Alternatively, you can integrate the automatic assignment of items into interactive reconciliation. With interactive reconciliation, the system checks when selecting a business relationship whether data selection has been performed for one of the trading partners involved since the last automatic assignment. If this is the case, the program performs automatic assignment, but only for the data relating to the select business relationship. Consequently, the response time for selecting a business relationship the first time after data selection is slightly greater. However, you do not need to wait for a long-running process before the data can be analyzed. In most cases, the program perform the automatic assignment of the data of a single business relationship sufficiently quickly for this to be the better solution. This holds particularly true when you only want to analyze business relationships with a relatively low volume of data. You make the Customizing setting for this in the activity Define Reconciliation Process Attributes (using the Assignment Mode field).

End of the note.

Result

The intercompany transactions of the group are reconciled.