Skip navigation

Lease Management Create Amortization Schedule (R15170) is designed to use an R date pattern to calculate lease liability and right of use asset schedules.

 

If you are not on an R date pattern there are a couple of scenarios to view in Lease Accounting – Creating Amortization Schedules (R15170) If Not Using an ‘R’ Date Pattern (Doc ID 2542169.1) that may be of assistance to you.

 

The following Enhancement Bugs have been entered to address the issue:

Enhancement Bug 28328411 - Allow Create Amort Sched to Process for Company Date Pattern and Enhancement Bug 29548972 - Allow Date Pattern Other than R to be Used for Amortization Schedule Creation have been entered to requesting to allow the Amortization Schedule (R15170) to be created with a date pattern other than R.

 

If you are a member of Quest User group please refer to Enhancement Requests via Quest User Groups (Doc ID 1192883.1) for escalating enhancement requests.

There are times when batches do not complete in Service Billing or Contract billing and it is necessary to troubleshoot the options on how to correct the issue.  Frequently Asked Questions Active Batch Status /Interrupted Invoice Batch (Doc ID 633116.1) has recommendations on what the base tables are that are required to be reviewed and some recommendations on how to resolve the issue.

 

If you are interested in exactly which fields are updated as a contract billing record is processed see How the F4812 Table is Updated by the Contract Billing Process (Doc ID 1679292.1) gives an explanation of the fields and values that are updated in the F4812/F4812H as a record is processed through contract billing.  This is very helpful, when it is necessary to reset a record that does not exist in the F4812 or one that cannot be void in the normal process.

JD Edwards will only be implementing enhancements for the new IFRS 16/ FASB 842 requirements on EnterpriseOne 9.1 and 9.2 releases.  However, it is realized that there are customers that are not on these releases.

 

Lease Accounting Prior to 9.1 (Doc ID 2420929.1) is intended to outline our general product direction. Please note that is intended for informational purposes only.  The workarounds are only suggestions and may or may not be a solution for all customers.

 

This document will outline how JD Edwards’ customers might leverage JD Edwards Fixed Assets, General Accounting and Accounts Payable modules to meet the change in Lease Accounting Standards (for Finance and Operating Leases).

 

It is recommended that you seek professional advice to follow accounting entries through from a local certification, compliance and verification perspective before implementing.

We are really excited about all the new functionality that JD Edwards has to offer for new FASB ASC 842 / IASB IFRS 16 requirements.  Revenue Recognition, Straight-line Rent, and Lessor Balance Sheet for Property and Non-Property are currently available for 9.1 and 9.2 software releases, along with new batch processing functionality.

 

There are a number of new UX roles that have also been incorporated in the 9.2 release. 

 

We are currently working on the next Lease Management functionality that will allow changes to be made to existing leases and creating the necessary updates to the appropriate tables.  This will be available at a future date, yet to be determined.

 

Information on these changes can be accessed from JD Edwards Real Estate Management (FASB ASC 842 / IASB IFRS 16) (Doc ID 2356624.1 ). This document provides links to ESUs via bugs listed in the document. There are also links to view Advisor Webcasts and LearnJDE, which is a great tool to use to learn all the new functionality, from webcasts to how to videos.

JD Edwards is currently working on the functionality required by the Financial Accounting Standards Board (FASB) and the International Accounting Standards Board (IASB) joint standard for releases 9.1 and 9.2.

 

The Balance Sheet Lessee Accounting functionality for Real Estate Management is available in JD Edwards release 9.2 by applying Bug 26380011.

The Lease Management Accounting functionality for Non-Property is available in JD Edwards release 9.2 by applying Bug 27444588

 

Lease Management does not require a license for Real Estate but will be handled in accordance to the following statement:

Entitled Products and Restricted Use Licenses

A license for Financials includes a restricted-use of Oracle JD Edwards EnterpriseOne Real Estate Management, limited to lessee lease management features.

Any usage of sales overage, expense participation or lessor lease management requires a full use license of Real Estate Management.

 

Please see FASB/IASB Functionality for JD Edwards Real Estate Management (FASB ASC 842 / IASB IFRS 16 ) (Doc ID 2356624.1) for further information on all FASB 842/ IFRS 16 functionality. Please Bookmark this document as it will be updated as additional functionality is completed for 9.1 and 9.2 software releases.

JD Edwards is currently working on the functionality required by the Financial Accounting Standards Board (FASB) and the International Accounting Standards Board (IASB) joint standard.

 

JD Edwards has completed the Revenue Recognition and Lessor-(Straight-line Rent) functionality. Announcements will be made, as more functionality is available.

 

Below are listed a number of documents available for these processes.

Revenue Recognition:

  • New Enhancement for FASB - Revenue Recognition in Real Estate Management for Release 9.1 and 9.2.(Doc ID 2260000.1)
  • JD Edwards EnterpriseOne Revenue Recognition Enhancement for Real Estate Management (FASB) (Doc ID 2304930.2)

 

The Revenue Recognition functionality for Real Estate Management is available for JD Edwards release 9.2 by applying Bug 25786546.

 

Lessor Accounting (Straight-line rent)

  • New Enhancement for FASB – Lessor Accounting in Real Estate Management for Release 9.1 and 9.2 (Doc ID 2324776.1)
  • New Functionality in Straight-Line Rent (FASB 13) for 9.2 (Doc ID 2334284.1)

 

The Straight-line rent functionality for Real Estate Management is available as of JD Edwards EnterpriseOne release 9.2 by applying BUG 25413509, Bug 25774375 and Bug 25796088.

 

Advisor Webcasts

These can be accessed from Advisor Webcast JD Edwards EnterpriseOne Schedule and Archived Recordings (Doc ID 1450327.1)

 

  • Financial Management - The New Lease Accounting Standard - What This Means to JD Edwards Customers, February 15, 2017
  • JD Edwards EnterpriseOne Financials FASB - Revenue Recognition in Real Estate Management, which was originally available for viewing on September 20, 2017.
  • JD Edwards E1 Financials Management - Enhanced FASB 13 (Straight Line Rent Accounting) for JD Edwards Real Estate Management, September 19, 2017
  • JD Edwards EnterpriseOne - The New Lease Accounting Standard - The First Enhancement in a Series for Lessees December 18, 2017

The Financial Accounting Standards Board (FASB) and the International Accounting Standards Board (IASB) created a joint standard regarding the recognition of revenue.

 

Business processes and financial standards outline when you can recognize revenue for the amounts you bill to customers. You cannot recognize revenue for billed amounts or Cost of Goods Sold (COGS) amounts associated with the billing amount until the performance obligation to the customer is satisfied.

 

This functionality is available for software releases 9.1 and 9.2.  See the below documentation for information on the ESUs required. This will also give you information on the Setup, Processing, Integrities and Audit reports.

 

Please see the following documents for further information:

  • ADVISOR WEBCAST: JD Edwards EnterpriseOne Financials FASB - Revenue Recognition in Contract Service Billing (Doc ID 2286798.1) for links to the Advisor Webcast on this topic as well and link to the  Oracle Community page.
  • E1: 48S: JD Edwards EnterpriseOne Revenue Recognition Enhancement for Service Billing (FASB) (Doc ID 2297257.2)
  • E1: 52: JD Edwards EnterpriseOne Revenue Recognition Enhancement for Contract Billing (FASB) (Doc ID 2299666.2)

The Financial Accounting Standards Board (FASB) and the International Accounting Standards Board (IASB) created a joint standard regarding the recognition of revenue.

 

Business processes and financial standards outline when you can recognize revenue for the amounts you bill to customers. You cannot recognize revenue for billed amounts or Cost of Goods Sold (COGS) amounts associated with the billing amount until the performance obligation to the customer is satisfied.

 

This functionality is not required for Real Estate Management until December 2018; however, JD Edwards has completed the Revenue Recognition enhancement for software release 9.2.

 

Much of the setup for Real Estate will use the same basic functionality that has previously been rolled out for Accounts Receivable, Contract and Service Billing and Sales Orders.

 

Please see New Enhancement for FASB - Revenue Recognition in Real Estate Management for Release 9.2 (Doc ID 2260000.1) for further information on installation and documentation.

Do you understand the differences between Contract Billing and Service Billing and which may be most appropriate to use in your company?

 

First you need to determine some business requirements.

 

Here are a few questions that you may ask yourself.

  • Are you only processing T&M (Time and Materials) or do you need a more complex set up such as Lump sum, Milestone or Progress billing?
  • Is Not –to-Exceed functionality desired?
  • Do you have components that need to be applied?

 

Both applications have Invoice Generation and Revenue Recognition, however, they use different programs to process the records.

 

The major functionality difference is that Service Billing is designed to only process T&M billings, where Contract Billing can process T&M billings and non-T&M billings such as Lump sum, Milestone and Progress Billing.

 

These are a few of the questions that are included in How to Understand the Differences between Service Billing and Contract Billing (Doc ID 626871.1). This document contains other questions to consider as well as the Advantages and Disadvantages for each application

Have you heard about the new Revenue Recognition requirements that the Financial Accounting Standards Board (FASB) and the International Accounting Standards Board (IASB) jointly created?

 

The effective date for public entities is expected to start with reporting periods beginning on or after December 15, 2017. The effective date for nonpublic entities will be deferred for one year to annual reporting periods beginning after December 15, 2018 and interims beginning after December 15, 2019. Early adoption is permitted one year earlier than these dates.

 

If you haven’t heard of this, you may want to look into the solution that JD Edwards has introduced in releases 9.1 and 9.2. This functionality it included in JD Edwards EnterpriseOne Accounts Receivable, JD Edwards EnterpriseOne Contract and Service Billing, JD Edwards EnterpriseOne Advanced Contract Billing, and JD Edwards EnterpriseOne Sales Order Management.

 

This includes new Automatic Accounting Instructions (AAIs), User Defined Codes (UDCs) and new set up for triggers to include or exclude companies.

 

New Revenue Recognition Solution for Financial Accounting Standards Board (FASB) and International Accounting Standards Board (IASB) For Contract Billing (Doc ID 2177615.1) discusses the setup and processing for EnterpriseOne Contract Billing.

 

An additional document will be created for Service Billing as part of the set up is specific to the module.

JD Edwards continues to release new features to support the new joint standard created by the International and US Accounting Standards boards for the recognition of revenue. These enhancements provide a simple yet comprehensive solution for managing the recognition of revenue in a complex business environment. Learn more about this solution by watching this series of tutorials for JD Edwards EnterpriseOne. As new features are released, new tutorials are being added as well.

Do you have an invoice or voucher batch that should have posted, but it did not complete?  Posting issues could be caused by many reasons but there are several things to look for when determining if you can use the built in functionality to assist you in being able to finish posting your batch.

After entering a Manual Billing (P1511) batch or running Recurring Billing Generation (R15100) and processing the batch, you may find that the  Post Invoice/Voucher (R15199) did not fully post the batch.  At this point it is necessary to determine the issue.  Check to see if there is a message in the Employee Workcenter or a message on the Post (R09801E) report. Verify which records in the batch may have posted, Real Estate  (F1511B) will have a D in the posted field if the records are posted, the F03B11 will also have a D and the F0911 will have a P. At this time, if the F1511B is posted and the F03B11 and F0911 are not posted, there are two built-in functionalities in JDE EnterpriseOne that may help you resolve the issue and either delete or post the batch.

The available built-in functionality to you assist this situation includes:

  1. Running  RE Post Invoice or RE Post Vouchers (R15199) with setting Processing Option 2 set to include posted records.
  2. Batch Delete (R15806) to start over with the batch

If the F1511B is posted and the F03B11 and/or the F0911 are partially posted, it is necessary for more advanced troubleshooting. At this point please refer to the following KM article:

  • How to Correct a Partially Posted Batch in Real Estate Management (Doc ID 636580.1)

You use JD Edwards EnterpriseOne Contract and Service Billing from Oracle to bill customers for services and goods rendered. JD Edwards Contract and Service Billing offers a suite of features to accommodate the intricacies of both interdivisional and customer billing.  Have you wondered which may be more suited for your billing needs? 

How To Understand the Difference Between Service Billing (48S) and Contract Billing (52) In EnterpriseOne (Doc ID 626871.1) may help you decide which application or a combination of applications would work best for your billing needs.  

This document gives you a comparison of the major billing processes such as Workfile Generation, Revenue Generation, Invoice Generation and Creating AR and GL Entries.  It also shows the major functionality differences in setup and Invoice Generation, as well as an outline of the advantages and disadvantages of Service Billing and Contract Billing. 

Filter Blog

By date: By tag:

Welcome to the My Oracle Support Community! We highly encourage you to personalize your community display name to make your activity more memorable. Please see https://community.oracle.com/docs/DOC-1022508 for instructions.