Planned Record Update

Use

The planned record update function regenerates the cash flow on the basis of the defined conditions and the postings that have been made, and writes the planned records to the database.

Note Note

Use the Update Planned Records from Worklist for loans from the product category Installment Loans (360).

End of the note.

Prerequisites

You must define the Cash Management update period ( CM period ) in Customizing for the product type and company code (IMG step: Company Code-Dependent Settings for Product Type ).

Scope of Functions

You use this function:

  • To update planned records:

    When you create a contract, the system only saves the (mainly condition-based) planned records to the database for a certain update period (CM period) and not beyond the end of the fixed period for the loan. This helps to improve performance. This is the period for which the cash flow is generated and displayed.

    To ensure than all loans have the same end date, the system automatically shifts the end of the CM period to the end of the next half-year. In other words, the CM period always ends on 06/30 or 12/31.

    In order to make the full CM period available for evaluations, you should run a planned record update for all loans every six months on 01/01 and 07/01. The system then automatically updates the existing planned records for all loans into the future on the basis of the CM period.

  • To update the planned records after changes:

    In order to generate the current values for foreign currency loans, loans based on reference interest rates or loans with incoming payments before you use certain application functions (such as Post Planned Records or Accrual/Deferral ), you must update the planned records for these loans. You should run the planned record update before each debit position run, possibly even on a daily basis.

    • Calculation of the cash flow: Changes to market data

      • In the case of foreign currency loans, the local currency amounts are updated on the basis of the current exchange rates in the currency table.

      • Amounts that depend on reference interest rates are adjusted on the basis of the current reference interest rates.

    • Calculation of the cash flow: Incoming payments

      • If the actual principle is applied to the loan, the system adjusts the relevant data when incoming payments are posted.

      • If the conditions for a loan are based on the effective capital, the system updates the amounts affected when incoming payments are posted.

        Note Note

        If you make changes to conditions, the system updates the planned records automatically when you save the changes.

        End of the note.

Activities

  1. Choose Start of the navigation path Accounting Next navigation step Execute Postings Next navigation step Mass Processing Next navigation step Preparation Next navigation step Update Planned Records.You can also access this function by choosingPosition Management Next navigation step Periodic Processing Next navigation step Update Planned Records. End of the navigation path

    The Update Planned Records for Loans screen appears.

  2. You can enter the following criteria to restrict your selections:

    1. Company code

    2. Product type

    3. Loan number

  3. Enter the selection criteria for updating the loans, such as:

    1. Only disbursed loans

    2. Local currency (LC) loans with reference interest rate

    3. Local currency loans with other interest calculation

    4. Foreign currency (FC) loans with reference interest rate

    5. Foreign currency loans with other interest calculation

    6. Loans according to plan principle

    7. Loans according to actual principle

      You can also opt to only display loans that have not been updated.

  4. Choose Execute.