Kontakt

Ansicht
Dokumentation

Interest Calculation ( RELNFICAX_471_INTRST )

Interest Calculation ( RELNFICAX_471_INTRST )

ROGBILLS - Synchronize billing plans   ABAP Short Reference  
This documentation is copyright by SAP AG.
SAP E-Book

Short text

Interest Calculation

Use

Item Interest Calculation

Balance Interest Calculation

Balance Interest Calculation Run

In Non-Industry Solution Contract Accounts Receivable and Payable you can calculate interest on balances at contract account level in a mass activity (menu: Periodic Processing -> For Contract Accounts -> Balance Interest Calculation Run).

The balance on which interest is to be calculated is determined from all of the items relevant for the calculation from a combination of company code, currency, business partner, and contract account. Interest is then calculated on this balance as a total; this is in contrast to item interest calculations, where interest is calculated on each item individually.

The following restrictions apply:

  • The attributes of individual items cannot be taken into account for the interest calculation or when you attribute the interest items.
  • You cannot carry out account maintenance on contract accounts subject to balance interest calculation, since the due dates of the balance changes would be lost or incorrect. Open items can therefore only be cleared by payment.

If you want to use the balance interest calculation, the following prerequisites must be fulfilled:

  • Interest is only calculated on balances at contract account level for contract accounts you have specified for balance interest calculation by setting the indicator Balance Interest Calculation. You can only set this indicator when you create a contract account and you cannot change it afterwards.
  • If you want to carry out periodic balance interest calculation, you must have defined the base periods and days (offset for interest calculation, for example, key date on 5th of month) in the contract account.
  • You must have maintained an interest key for the contract account.
  • If you want to post withholding tax, the withholding tax code for outgoing payments must be set in the contract account.

Process Flow

The interest run selects all items from a contract account that exist for the combination of business partner and contract account. Only items for which one of the following conditions is fulfilled are excluded:

  • They belong to an installment plan.
Installment plan charges and interest are not always posted statistically.
  • The clearing document of the item has the origin 'Reversal' or 'Return'.
  • The item is statistical.

Interest Locks

Interest locks at business partner/contract account level are deemed to be 'Run locks' by the balance interest calculation. This means that if the issue date of the interest run is in a locked period, the contract account is excluded from the interest calculation. If you start the next interest run with an issue date that is after the validity of the interest lock, interest is calculated on the entire period since the last interest calculation run. The lock is then ignored.

Interest locks on items are not considered. However, if an item in a contract account is locked due to a workflow, the complete contract account is excluded from the interest calculation.

Interest Periods

You define the data for the interest period in the master data:

  • Interest calculation base period: Yearly, half-yearly, quarterly, or monthly
The periods determined each start on the usual dates - for example, a year on 01/01, a quarter on 01/01, 04/01, 07/01, and 10/01.
Interest is always calculated for a complete period. Interest is therefore always calculated only to the end of the last complete interest period before the issue date. If no period is specified, interest is calculated up to the issue date.
  • Interest calculation base days
You can use the number of base days to move the start of an interest period. For example, base period monthly, base days 14 means that interest is calculated from the 15th of a month to the 14th of the following month. The number of base days can also be a negative value.
Note that if the start of the interest period is moved to another month due to the base days, then you may not be able to understand the results due to the different number of days in each month. The base days are used to determine the first complete interest period in a calendar year. All other periods in the same calendar year are determined by adding the months.
  • You also need the following details to determine the interest periods:
  • Issue date in the selection criteria

Interest is calculated to the issue date as a maximum. If no base period is defined in the master data, the interest is calculated up to and including the issue date.
  • Indicator Interest Calculation to Issue Date in the selection criteria

If the indicator is set, the interest is calculated to the issue date even if no interest is due according to the frequency specified. However, this interest is only displayed in the log and there is no actual interest posting.
  • Indicator Interest Posting to Issue Date in the selection criteria

If the indicator is set, the last interest period is determined in the same way as for the indicator Interest Calculation to Issue Date. However, the interest is not only calculated from the last interest period, it is also posted.

Clarification Cases

For each item that is posted to a contract account subject to balance interest calculation, in event 0010, the system checks whether the net due date or the value date is in a period for which interest has already been calculated. If this is the case, the interest calculated is no longer correct and an entry is written in a table with clarification cases DFSCICLARIOB). As soon as you start the balance interest calculation run again, interest documents that are no longer valid are reversed as far as possible and interest is recalculated for the period in question. The same applies if you reverse a document or for a return (event 0020).

If you cannot reverse an interest document because it has already been cleared or partially cleared, an inverse posting is created for the interest document. Table DFSCIREV contains the information about which interest documents inverse postings have been created for. This table is available for evaluations. If the inverse posting has to be created in a different fiscal year, the inverse posting is created like a reversal in the following year. This means that posting area 0140 is read and the G/L accounts are also swapped.

If you want to create an installment plan - whose original items and their due dates are in a period for which interest has already been created - in a contract account subject to balance interest calculation, an entry is written in the clarification table DFSCICLARIOB (event 3026).

The same applies for deactivating installment plans. If the due dates of the reopened original items are in a period for which interest has already been calculated, an entry is written in the clarification table (event 3041).

If an interest document from the balance interest calculation is reversed, in event 0020 the related entries in the interest history are deleted.

Interest Calculation History

In the menu under Account -> More Information, you can display the balance interest calculation history for a business partner/contract account.

Archiving of Balance Interest Calculation Histories

You can use the archiving object SAP_FSC_BAINT01 to archive balance interest calculation histories.

Effects on Existing Data

Effects on Data Transfer

Effects on System Administration

Effects on Customizing

Balance Interest Calculation

In the Implementation Guide for Contract Accounts Receivable and Payable make the following settings under Business Transactions -> Interest Calculation -> Item Interest Calculation:

In the Implementation Guide for Contract Accounts Recevaible and Payable make the following settings under Business Transactions -> Interest Calculation -> Balance Interest Calculation:

In the Implementation Guide for Contract Accounts Receivable and Payable under Business Transactions -> Reversal, define Default Values for Reversals (posting area 1050).

Item Interest Calculation

Further Information






General Data in Customer Master   BAL_S_LOG - Application Log: Log header data  
This documentation is copyright by SAP AG.

Length: 10678 Date: 20240520 Time: 204012     sap01-206 ( 191 ms )