Skip to Content
author's profile photo Victor Ehmann
0
Victor Ehmann
Mar 27 at 07:54 AM

ICMR: handling / process approach for data from non-SAP companies

172 Views

Hello experts,

currently I’m setting up ICMR for local financial close and I’d like to know whether my process approach for handling data from non-SAP companies is correct.

Basic information on ICMR settings:

  • The matching method and reconciliation case include only balance sheet accounts.
  • Reconciliation case attribute ‘with balance carryforward’ is set to ‘yes’
  • IC Reconciliation & Matching is processed monthly for SAP and non-SAP companies.

Posting / reconciliation example:

Period 010.20X1

  • SAP company A: posts IC transaction (item) on receivable account with partner B
  • Non-SAP Company B: provides IC transaction (item) on payable account with partner A via ICMR upload file for period 010.20X1 (csv)

Period 000.20X2

  • SAP company: Performed carry forward for balance sheet items (accounts)
  • Non-SAP Company: provides IC transaction (item) on payable account with partner A via ICMR upload file for period 000.20X2 (csv) (tbd, see questions down below)

Period 005.20X2

  • SAP company: clears open item on receivable account with partner B
  • Non-SAP Company: provides cleared item on payable account with partner A via ICMR upload file for period 005.20X2 (csv) (tbd, see questions down below)

Am I correct on the following:

  1. There is no carry forward functionality for non-SAP companies’ data in ICMR. Therefore, to have the reconciliation overview balanced for transaction (items) with SAP companies’ that have been carried forward in SAP Finance, it is necessary to upload open items from previous year in period 000 into ICMR for non-SAP companies.

  2. There is no functionality to clear open items from non-SAP companies that have been uploaded into ICMR in a previous period. Therefore, to have the reconciliation overview balanced for transaction (items) with SAP companies’ that have been cleared in SAP Finance, it is necessary to upload cleared items in respective period into ICMR for non-SAP companies.

-

In summary, for the example outlined above a non-SAP company needs to provide three different upload files: 1. Initial posting of IC transaction 2. Carry Forward in period 000 since IC items has not been cleared by year end. 3. Clearing of IC item in respective period.

Thanks in advance.