Ansicht
Dokumentation

FCLM_CR_TRIGGER_MMRD - Reconcile End-of-Day Memo Records

Fill RESBD Structure from EBP Component Structure   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by SAP AG.

Purpose

You can use this program to perform automatic reconciliations between open end-of-day memo records and open forecasted cash flows.

Integration

Prerequisites

Make the following settings before you perform automatic reconciliation:

• Define rules for determining end-of-day memo records that represent end-of-day bank statements in the Customizing activity Determine End-of-Day Memo Records.

• To include a bank account in cash flow reconciliation, in the Manage Bank Accounts app, open the bank account and select the Reconcile End-of-Day Memo Records checkbox.

• If you want to allow amount differences in cash flow reconciliation for certain bank accounts, define the following settings:

• Define tolerance groups in the Customizing activity Define Tolerance Groups for Cash Flow Reconciliation.

• In the Manage Bank Accounts app, assign tolerance groups to bank accounts in the Tolerance Group for Reconciliation field.

Features

Selection

Standard Variants

Output

Activities

With this activity, you can perform automatic reconciliation between intraday memo records and forecasted cash flows, including:

• Accounts receivable (certainty level REC_N)

• Accounts payable (certainty level PAY_N)

• Self-initiated cash in transit (certainty level SI_CIT)

• General memo records (certainty level MEMO)

The following run types are available:

• Reconcile with Bank Statement Information

You use this mode when the FEBCL table already contains the mapping relationship between intraday memo records and the corresponding FI documents. You can use this mode to retrieve the mapping relationship and update the reconciliation table. You can then see the matched memo records and forecasted cash flows with the status Reconciled in the Reconcile Cash Flows - Memo Records app.

• Reconcile with Bank Statement Info and Match by Amount

In this mode, the program first reads the FEBCL table for the existing mapping relationship between intraday memo records and the corresponding FI documents. Then it checks the One Exposure table (FQM_FlOW) and automatically matches the rest of the open intraday memo records with open forecasted cash flows. The matching process considers the company code, bank account, currency, value date, amount, as well as the tolerance group setting. The system then updates the result in the cash reconciliation table. You can then see the matched memo records and forecasted cash flows with the status Reconciledin the Reconcile Cash Flows - Memo Records app.

Matching Logic

The matching logic is as follows:

• The company code, currency, and bank account must be the same.

• The value date of the two parties must be the same.

• The amounts of the two parties have to be matched with the tolerance setting taken into consideration. The amounts are rounded to the nearest one.

Example

,,Memo record A and forecasted cash flow B are matched in every way except that the value date of the memo record is a day before the value date of the cash flow. In this case, the two parties are matched and reconciled because the value date difference is not larger than one day.

,,Memo record A and forecasted cash flow B are matched in every way except that the memo record is 5000 EUR while the cash flow is 4950 EUR. The program checks the tolerance group setting of the bank account and the result may vary depending on the setting:

o,,If the bank account is not assigned with a tolerance group or the tolerance amount is zero, the memo record and the cash flow are not reconciled.

o,,If the difference of 50 EUR is within the tolerance limit defined by the bank account's tolerance group, the memo record and the cash flow are reconciled.

CPI1466 during Backup   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by SAP AG.

Length: 5046 Date: 20240531 Time: 080134     sap01-206 ( 81 ms )