SAP Knowledge Base Article - Public

2928178 - Lease Contract - Valuation Cash Flow Report Shows Two Due Dates Per Month

Symptom

  • You view the Cash Flow report for Lease Contract XYZ and notice that the report displays two Due Dates every month, one for the due Clearing amount and one for the due Depreciation and Interest Expense amount (XYZ represents a Lease Contract ID). 
  • You expect to see only one Due date for all transactions per month. 

Environment

SAP Business ByDesign

Reproducing the Issue

  1. In the Lease Contract Management work center go to the Lease Contract view. 
  2. Find and select Lease Contract ABC.
  3. Press Reports and select Cash Flows to open the Lease Contract Valuation Cash Flow report.
  4. You notice two dates per month; For example, 01.MM.YYYY for the Clearing Amount and 31.MM.YYYY for the due Depreciation and the Interest Expense amount. 

(In the Lease Posting Run, in the Processed Successfully - Clearing subtab you also notice two Due Dates for each month.)

Cause

For the monthly Lease Installment payment you choose the In Advance Payment form. With the In Advance payment form interest expense and depreciation amount are applied on the ending balance and are therefore due on the last day of the month (as specified in the lease contract conditions).

However, irrespective of the payment form all clearings are due according to the conditions specified in the contract.

To verify the Payment set up in the contract

  1. access the Lease Object tab of Lease Contract ABC.
  2. Navigate to the Conditions tab.
  3. Notice Condition Type Lease Installment and Payment Form in Advance.

Resolution

When applying the advance payment form interest expense and depreciation amounts are due at the end of the condition's specified period, whereas the clearing amount is due at the start of the period.

When applying the Arrear Payment form Interest Expense, Depreciation as well as Clearing Amount are all applied on the Opening Balance. They are therefore due on the same date, as specified in the Contract's conditions. In this case the report will display only one date per month.

See Also

Lease Contract Valuation Cash Flow

Keywords

Lease Contract Cash Flow, two dates, Lease Posting Run Clearing tab , KBA , AP-ACC-LM , Accounting Lease Management , Problem

Product

SAP Business ByDesign all versions