Executing Interest Calculations

Objective

After completing this lesson, you will be able to execute an interest calculation

Interest Calculation Processing

The image displays three sections of an Interest Run screen in a software application: General Selections, Posting Parameters, and Interest Parameters. Each section contains various fields and tabs for inputting and viewing details related to an interest run process.

You can use transaction FPINTM for interest calculation mass processing (interest run).

A software interface for calculating interest individually, displaying sections for posting parameters, document items, and interest parameters. Users can input details such as document date, posting date, reconciliation key, business partner, company code, currency, and specify interest categories and document types.

You can use transaction FPI1 for interest calculation individual processing.

You must specify whether you want to calculate interest on debit or credit items.

It's not possible to select Credit Items and indicate only open debit items at the same time.

The default document type and statistical key are defined in customizing and may be over written at the time of posting.

The Single Document indicator specifies whether the system creates a separate document in general ledger accounting for each line item for which interest is calculated. The number of the document posted in FI-CA is stored as the reference document number in the FI-GL document.

The Cleared Items Only indicator ensures interest calculation only takes place when the item is totally cleared in the event that any partial payments (resulting in two sub items) are made.

The Calculate Interest To field specifies the date up to which interest is to be calculated.

Interest calculations are usually posted using the interest run and not individually.

Illustration of an open padlock labeled Interest Lock with accompanying text explaining that items can be selected only if there's no interest lock, and that interest lock reasons can be configured in customizing.

You can use interest locks to prevent interest from being calculated on certain items.

You can also exclude certain business transactions (such as reversal postings or additional receivables) from interest calculation.

An item will not be selected in the following cases:

  • It's not due.

  • It does not meet selection criteria.

  • It's excluded from interest calculation in event 2010.

  • It's an additional receivable and interest calculation was excluded.

  • It cannot be processed due to transfer days, tolerance days, or frequency.

  • If interest has already been calculated for the item for the given period.

An image labeled Interest Processing contains four options: Print Interest Notification, Create Interest Supplement, Create Interest History, and Create Interest Document.

The interest document includes the structures of a document in FI-CA: document header, line items, and general ledger items. In addition to the usual data, an interest document also shows information about the basis of interest posting. This information is contained in the interest supplement.

The interest supplement indicates how the interest amount was determined, including original items, interest period, and interest rate. This allows you to reconstruct how interest was determined at a later date.

The interest history records the interest calculation period for each line item on which interest is to be calculated. During calculation, the selected items and the interest are considered jointly. This ensures that interest is calculated only once for items for a certain period.

If you later change the system settings for the interest calculation rule or interest rule, you'll no longer be able to retrace interest calculation using the interest supplement. If you change the interest rate for dates in the past, this has no impact. However, the system issues a warning when you try to do this.

Execute an Interest Calculation

ExerciseStart Exercise

Business Example

Your business partner has not yet paid his invoices.

You want to calculate interests for his overdue items.

Note

In this exercise, the value ## should be replaced with your group number.

Task 1: Execute a Manual Interest Calculation

Steps

  1. Start the SAP Fiori Display Account Balance app (transaction FPL9).

    1. Choose the Information tile group.

    2. Choose the Display Account Balance tile.

  2. Display the account of business partner ac240-##f using the following data:

    Initial Data

    FieldValue
    Business Partnerac240-##f
    List TypeALLES ALL Items
    Line Layout013 Line Item Display

    1. On the initial screen, enter the values from the Initial Data table.

    2. Choose Continue to check the basic list.

      There are three overdue items 6000/0010 displayed.

      There's one credit memo 6000/0020 displayed.

    3. Choose Back twice.

  3. Start the SAP Fiori Post Interest app (transaction FPI1).

    1. Choose the Processes tile group.

    2. Choose the Post Interest tile.

  4. Calculate the interest for the overdue items of business partner ac240-##f using the following data:

    Interest Parameters

    FieldValue
    Document Datecurrent date
    Posting Datecurrent date
    Reconciliation Keyproposed by the system
    Document TypeYO Interests
    Statistical KeyG Other Statistical Receivable
    Business Partnerac240-##f
    Company Code1010
    CurrencyEUR
    Debit Itemsselect
    All Itemsselect
    Calculate Interest Tocurrent date

    1. On the Calculate Interest screen, enter the values of the Interest Parameters table.

    2. Choose Line Items.

    3. In the Checking dialog box, choose Yes.

    4. In the Information dialog box, choose Continue.

    5. Press Enter to confirm the Account has open credit items warning message.

      You access the Select Line Items for Interest Calculation screen.

    6. Choose Select Items for Interest Calculation to select all items.

    7. Choose Display Interest.

      You access the Interest Calculation Overview screen.

    8. Check the interest calculation result.

    9. Choose Back.

    10. Choose Post.

    11. Note the interest document number.

    12. Choose Back.

  5. Start the SAP Fiori Display Account Balance app (transaction FPL9).

    1. Choose the Information tile group.

    2. Choose the Display Account Balance tile.

  6. Display the account of business partner ac240-##f using the following data:

    Initial Data

    FieldValue
    Business Partnerac240-##f
    List TypeALLES All Items
    Line Layout013 Line Item Display

    1. On the initial screen, enter the values from the Initial Data table.

    2. Choose Continue to check the basic list.

      The statistical interest request 0040/0010 is displayed.

    3. Choose Back twice.

Task 2: Execute an Interest Run

Steps

  1. Start the SAP Fiori Post Document app (transaction FPE1).

    1. Choose the Document tile group.

    2. Choose the Post Document tile.

  2. Post a receivable of EUR 800 to business partner ac240-##f using the following data:

    Initial Data

    FieldValue
    Document Datecurrent date minus 6 month
    Posting Datecurrent date minus 6 month
    Document TypeYM General
    Clearing Reason12 Debit Entry Creation

    BP Item Data

    FieldValue
    Contract Accountac240-##f
    Main Transaction6000 Other Receivables/Credit
    Sub Transaction0010 Other Receivables
    Amount800

    1. On the initial screen, enter the values from the Initial Data table.

    2. Choose BP Item.

    3. Confirm the daily new reconciliation key, if necessary.

    4. In the Business Partner Items table, enter the values from the BP Item Data table.

    5. Select Enter.

      The net due date is calculated equal to the current date minus six months.

    6. Choose Post.

    7. Note the document number.

    8. Choose Back.

  3. Start the SAP Fiori Interest Run app (transaction FPINTM1).

    1. Choose the Processes tile group.

    2. Choose the Interest Run tile.

  4. Execute an interest run only for business partner ac240-##f using the following data:

    Run Parameters

    FieldValue
    Date IDcurrent date
    Run IDINT##

    Posting Parameters

    FieldValue
    Date of Issuecurrent date
    Posting Datecurrent date
    Document TypeYO Interests
    Statistical KeyG Other statistical receivable
    Reconciliation Keyproposed by the system

    Interest Parameters

    FieldValue
    Debit Itemsselect
    All Itemsselect
    Create Correspondenceselect
    Calculate Interest Tocurrent date

    1. In the Run ID area, enter the values of the Run Parameters table.

    2. Select Enter.

    3. On the General Selections tab, enter only your own business partner ac240-##f.

    4. On the Posting Parameters tab, enter the values from the Posting Parameters table.

    5. On the Interest Parameters tab, enter the values from the Interest Parameters table.

    6. Choose Save.

    7. Choose Menu → Program Run → Schedule.

    8. In the dialog box, select Start Immediate, and choose OK.

    9. Choose Back.

  5. Start the SAP Fiori Display Account Balance app (transaction FPL9).

    1. Choose the Information tile group.

    2. Choose the Display Account Balance tile.

  6. Display the account of business partner ac240-##f using the following data:

    Initial Data

    FieldValue
    Business Partnerac240-##f
    List TypeALLES All Items
    Line Layout013 Line Item Display

    1. On the initial screen, enter the values from the Initial Data table.

    2. Choose Continue to check the basic list.

      There are now two statistical interest requests 0040/0010 displayed.

    3. Choose Back twice.

Log in to track your progress & complete quizzes

Learning

SAP FacebookSAP YoutubeSAP LinkedIn