E1: 17: Contract Amortization And Cancellation Not Writing F1794 Entries Correctly (Doc ID 1642656.1)

Last updated on OCTOBER 23, 2015

Applies to:

JD Edwards EnterpriseOne Service Management - Version 9.0 and later
Information in this document applies to any platform.

Symptoms

When the contract spans across calendar years and is billed up to a period in the next year without amortizing, followed by amortizing for period 1 generates incorrect values in F1794. Further, cancelling this contract populates the amounts the wrong accounts. Many other issues apart from this particular scenario as well. A spreadsheet has been attached showing a few of these issues.

STEPS TO REPRODUCE
==================
1) Create a service contract via the P1720/P1721 for a contract that is billed as follows.  
a) Contract dates 10/01/2013 – 09/30/2014
b) Bill Frequency set as M, Monthly basis
c) Bill for six periods i.e October 2013 till March 2014
d) Amortize for 1st period - october.

2) Results of above transaction is:  
Oct – 300 short term to long term  and 101.92 Recognized. This is incorrect.  

Nov – 98.63 Recognized
Dec – 99.45 Recognized
Jan – 100 short term to long term. 100 Recognized . This is incorrect.
Feb – 100.00 Billed not amortized
Mar – 100.00 Billed not amortized.
3) Now cancel the contract on the 3rd day of Jan and then view the workfile. The amount that get credited are created with Generation Type “G – Domestic Cancel Recognition” for an amount of 287.67

Issue also duplicates with different bill frequencies, namely, bi-monthly, quarterly, annual etc. Issues exist with regular and irregular date patterns. 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms