TRM: Joining several identical flows within a period into one flow

Let’s take a look at Nominal interests flow. When you use other capital changes possibilities, for example, credit repayment (flow 1110 “Decrease”), Nominal interest flow is doubled.

When an interest rate of a credit changes, Nominal interest flow also doubles.

This is how it looks

And from accounting standpoint it means that we need to clear both open items for each Nominal interest flow with one position in bank statement.

So recently I’ve got a requirement from accounting department. They need only one accounting document for Nominal interests flows per reporting period.

So let’s start.

1. SPRO → Financial Supply Chain Management → Treasury and Risk Management → Transaction Manager → Money Market → Transaction Management → Flow Types → Define Flow Types:

Let’s define flow 1299 “Nominal interest (total)” with all parameters depicted on the screenshot. Critical is parameter “Relevant to posting ” – set it.

For standard flow 1200 “Nominal interest” clear “Relevant to posting”

2. SPRO → Financial Supply Chain Management → Treasury and Risk Management → Transaction Manager → Money Market → Transaction Management → Flow Types → Assign Flow Types to Transaction Types

Assign flow types to product type and transaction types.

3. SPRO → Financial Supply Chain Management → Treasury and Risk Management → Transaction Manager → Money Market → Transaction Management → Flow Types → Derived Flows → Define Derivation Procedures and Rules

Let’s define “KREDI” derivation procedure. And then go to “Derivation Rule”.

Let’s create a rule. Original flow is inflow of 1200 “Nominal interest”. Derived flow will be inflow of 1299 “Nominal interest (total). Choose “Sum of incoming flows” in “Calculation by” and 100 in “Percentage rate” – all our 1200 flows will be 100% summed up into 1299 flow. The rest of parameters is up to your need.

Repeat the same for outflow direction.

The result will look like this.

4. SPRO → Financial Supply Chain Management → Treasury and Risk Management → Transaction Manager → Money Market → Transaction Management → Update Types → Define Update Types and Assign Usage

Create update Types for our flow 1299.

And assign usage.

5. SPRO → Financial Supply Chain Management → Treasury and Risk Management → Transaction Manager → Money Market → Transaction Management → Update Types → Assign Flow Types to Update Types

Don’t forget to enter update types into a view: tr. SM30 => TRACV_DFT_REL. And then set it as relevant for posting.

Assign Flow Types to Update Types

6. SPRO → Financial Supply Chain Management → Treasury and Risk Management → Transaction Manager → General Settings → Accounting → Link to Other Accounting Components

Adjust posting schemes to new Update Types.

7. SAP Menu → Accounting → Financial Supply Chain Management → Treasury and Risk Management → Business Partners → Special Functions → Standing Instructions → Derived Flows (tr. TBI7)

Assign derivation procedure to business partner to product type credit, transaction type – borrowing.

Results:

Create a new deal or resave the active deal.

As the result we have several 1200 flows which is not relevant to postings.

And only one flow 1299 with amount of all percents per period relevant to posting.

The task is done. Accounting department is happy.