Oracle by Example brandingProcessing Early Termination

section 0Before You Begin

This 30-minute OBE shows you how to process the early termination for the copier. The early termination process sets the early termination flag from the starting termination month through the end of the schedule and creates journal entries for terminating a lease early. You will review the changes to the schedules and the journal entries that are create. After reviewing the journal entries, you we will post the early termination batch.

Background

Many businesses lease office space and equipment from different suppliers. According to the new lease accounting standards, businesses must account for these leases and the leased asset on them on their balance sheets. The Lease Accounting functionality in JD Edwards provides the ability to comply with these standards.

Scenario Guidelines

In this series of OBEs, you will learn how to set up the system and perform the required actions for following lease scenario:

  • You are leasing a copier from Electronics R Us.
  • The lease is for two years and you expect to return the copier at the end of the lease.
  • You will pay $2,500 quarterly in advance.
  • You have to pay an up-front installation charge of $1,000 to secure the lease.
  • At the beginning of the second quarter, you renegotiate the price of this lease based on an agreement to lease other equipment from the vendor and they agree to a price break on the existing lease. Your new quarterly payment will be $2,250 starting from the second quarter.
  • At the end of the second quarter, the copier breaks down and the cost of repairs is greater than the replacement cost, so you negotiate with the vendor to terminate this lease and create a new one for a newer copier model.

What Do You Need?

  • Changed the recurring billing and the borrowing rate (See the OBE “Update Recurring Billing for Early Termination”.)

section 1 Terminating the Lease Early

  1. Navigate to EnterpriseOne Menus, Financials (G1), Lessee Accounting (G15202), Periodic Processing (G1520220), Amortization Schedules (P15171).
  2. On the Work with Amortization Schedules form, enter the lease number 20491 to find the lessee lease you created in the OBE “Creating a Lessee Lease”.
  3. Click Find.
    • Verify that the Recalculate Lease Liability flag has the value of 2 (Terminate or Remeasure)
  4. Select Terminate Early from the Row menu.
  5. In the Early Termination Options dialog box, enter 06/30/19 as the Early Termination G/L Date.
  6. The Early Termination Options dialog box should look like this:

    Early Termination Options Dialog Window
    Early Termination Options Dialog Window

    Note: A warning message is displayed after you click OK the first time because the current period is set to 11 and the beginning of the fiscal year is set to 01/01/19 in the company constants for this scenario.

    Early Termination Options Dialog Window with Warnings
    Early Termination Options Dialog Window
  7. Click OK to terminate the lease and create early termination journal entries.
  8. On the Work With form, you can see that:
    • The Recalculate Lease Liability flag is now set to 0 (No Action Required)
    • The Lease Liability Status has been updated to 55 (Schedules Terminated)
    • Note that the Early Termination option is no longer available in the Row menu.

section 1 Reviewing Amortization Schedules

  1. Navigate to EnterpriseOne Menus, Financials (G1), Lessee Accounting (G15202), Periodic Processing (G1520220), Amortization Schedules (P15171).
  2. On the Work with Amortization Schedules form, enter the lease number 20491 to find the lessee lease you created in the OBE “Creating a Lessee Lease.”
  3. Click Find.
  4. From the Row menu, select Amortization Sched and then select Lease Liability to review the schedule changes that occurred as a result of the early termination at the end of the second quarter.
    • Review the Lease Liability Amortization Schedule form.
      • The Early Termination check boxes are selected from the starting termination month (06/01/19) through the end of the schedule.
      • A red square is displayed to indicate the months included in the early termination.
    • This is how the Lease Liability Amortization Schedule should look after early termination:

      Lease Liability Amortization Schedule
      Lease Liability Amortization Schedule
    • Change the Schedule Type to Right of Use Asset to review the ROUA schedule.
      • The Early Termination checkboxes are selected from the starting termination month (06/01/19) through the end of the schedule.
      • A red square is displayed to indicate the months included in the early termination.
      • This is how the Right of Use Asset Amortization Schedule should look after early termination:

        ROUA Amortization Schedule
        ROUA Amortization Schedule

section 1 Reviewing Early Termination Journal Entries

  1. Navigate to EnterpriseOne Menus, Financials (G1), Lessee Accounting (G15202), Periodic Processing (G1520220), Balance Sheet Lessee Accounting Batch Review (P150911).
  2. From the Work with Lessee Accounting Batch Review form, find the batch and select the grid row for the early termination batch. Complete these fields
    • Remark: Lessee Termination Journals
    • Batch Status: A (Approved)
  3. From the Row menu, select JE Review.
  4. Review the journal entries created for a Finance type lease:
    • JE termination amount = lease liability beginning balance for the start termination month – (minus) lease liability prior month ending balance
    • Debit to Lease Liability
      • AAI = LL
      • Lease liability ending balance – start termination month/year (6/19)
    • Credit to LL Termination Adj Offset
      • AAI = L7
      • Lease liability ending balance – start termination month/year (6/19)
    • Credit to Accumulated Amortization
      • AAI = LC
      • ROUA Ending Balance – start termination month/year (6/19)
    • Debit to ROUA Termination Adj Offset
      • AAI = L8
      • ROUA Ending Balance – start termination month/year (6/19)
  5. This is how the early termination journal entries should look:

    Journal Entry
    Journal Entry
  6. Click Cancel to exit the Journal Entry form and return to the Work with Lessee Accounting Batch Review form.

section 1 Post Early Termination Journal Entries

  1. Navigate to EnterpriseOne Menus, Financials (G1), Lessee Accounting (G15202), Periodic Processing (G1520220), Balance Sheet Lessee Accounting Batch Review (P150911).
  2. From the Work with Lessee Accounting Batch Review form, find the batch and select the grid row for the early termination batch. Complete these fields
    • Remark: Lessee Termination Journals
    • Batch Status: A (Approved)
  3. From the Row menu, select Post by Batch.
    • From the Printer Selection form, click OK to return to the Work With Lessee Accounting Batches form.
    • From the Work with Lessee Accounting Batchesform, select Submitted Jobs from the Form menu.
    • Find the batch job you just submitted: General Ledger Post – Lessee Accounting
    • Click the View Output grid column and click Open when prompted.
    • Review the report.
  4. This is how the General Ledger Post report should look:

    General Ledger Post Report
    General Ledger Post Report
  5. Click Close to return to the Work with Lease Accounting Batches form.
  6. Make sure that the option to display All Batches is selected and click Find.
  7. Note the Batch Status is D (Posted) for the early termination batch you just posted.
  8. This is how your early termination batch record should look:

    Work with Balance Sheet Lessee Accounting Batches form
    Work with Balance Sheet Lessee Accounting Batches Form