cancel
Showing results for 
Search instead for 
Did you mean: 

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

v_23
Explorer
0 Kudos

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.

vincezk
Advisor
Advisor
0 Kudos

Hello Vector,

For S4 internal entities, the clearing status can be synced from the source directly. However, for external entities, ICAFU cannot provide any changes on the existing items.

A possible solutoin is like this: you create a z-table in S4, then you upload your extenal entities to your z-table with additional functions like changing clearing date when you upload clearing items. You then create a data source which is based on the union of z-table and bseg.

B.R.

Vince.

v_23
Explorer
0 Kudos

Thanks, Vincent.

I'm totally aware that für S/4 entities the clearing status and also carry forward is perfectly synchronized.

I just need a confirmation on the approach für non-S/4 entities. It would be great to know about a best practice process without using z-tables.

KR,

Victor

Accepted Solutions (0)

Answers (0)