E1: 12: Method Of Computation R / MOC R Not Updating the Header/IA and IU not getting created -BUG 23214515
(Doc ID 2617998.1)
Last updated on DECEMBER 11, 2019
Applies to:JD Edwards EnterpriseOne Project Costing - Version 9.2 and later
Information in this document applies to any platform.
9.2 version, Project Costing
MOC R Definition needs to be changed to the following based on the following KM document:
E1: 51: Working with Job Cost Methods of Computation ( Doc ID 1543899.1 )
R - Revenue: Unit Price Contracts
Method of computation R is used when a contractor is paid based on the quantities in place. This method of computation is designed to be used at the Header account level only.
The following information is used when calculating Projected Final values:
Assign to header accounts.
The system calculates the rate of change for the Budget Units (FU/HU) at the Header Level) multiplies it by the RBLU and RBLA for each detail and Header account, and updates the result to IA/IU ledger for all accounts that roll up to the Header Cost Code.
For example, if the HU ledger is 1000, and it is changed by entering a new projected final Units (HU) ledger of 1100, the system calculates the rate of change as 100 ÷1000 x 100 or 10 percent. The 100 units of the change are entered into the
FU Ledger Type. If the RBLA = 1,000, the system multiplies it by .10 and updates the IA ledger with the amount of the change (100). The 10% change is applied to all RBLA and RBLU rows in the Cost Code including the Cost Code Header.
With regards to the above definition the system is not doing the following:
1. Needs to apply the definition to the Header Records and not just the Detail Records.
2. The Header records are not updating the Revised Budget Amount, Revised Unit Amount. Once these are corrected the EAC and EACU should be correct.
3. The Header Records are missing the F0911 Records(IA/IU) ledger for the Headers.
4. The Header Records are not updating the F0902 file for the (IA/IU)ledger.
The system should apply the changed to the header account amounts for all the detail lines under the header.
Definitions of Job Cost and Accounting Ledgers:
AA/AU Actual amounts and units.
FA/FU Projected final amounts and units that are forced. The system adds the value in FA/FU ledger to the value for the revised budget ledger to calculate projected final values (HA and HU). The Job Progress Entry programs (see document ID 1528498.1) have separate fields for forcing units and amounts. Regardless of the computation method used to update the projected final values, the net change will be updated in the FA/FU ledger.
F% Percent complete value that is manually entered by the user. The system does not store the system calculated percent complete in the F% ledger. If the method of computation does not allow for the manual entry of a percent complete, the system will calculate a percent complete based on the method of computation used. Depending on the method of computation used, the system will display either the value from the F% ledger or the system calculated percent complete on the Job Status Inquiry forms (P512100/P512000).
HA/HU Projected final amounts and units.
JA/JU Revised budget amounts and units. Users can define additional revised budget ledgers in addition to the JA/JU ledgers. Additional revised budget ledgers must be designated as such in the P0025 – Job Cost Ledger Type Rules.
IA/IU System-generated revisions to the budget values.
PA/PU Open commitment (purchase orders) amounts and units.
RA Remaining units ledger. Because the system updates the RA ledger with unit rate values, the RU ledger does not exist. The system calculates remaining amounts using the formula: HA – AA.
RBLA The sum of JA ledger amounts and other user-defined revised budget ledger amounts.
RBLU The sum of JU and other user-defined revised budget ledger units.
RBLUR The revised budget ledger unit rate, which the system calculates using the formula RBLA / RBLU.
PC The percent complete that appears on the Job Status Inquiry form and reports. The system calculates this value for informational purposes. The system uses the percent complete for the job to calculate profit recognition.
AUR The actual unit rate, which the system calculates using the formula AA / AU.
ETCU The estimate-to-complete units. This is the estimated number of units that are required to complete the task.
ETCA The estimate-to-complete amount. This is the estimated amount that is required to complete the task.
EACU The estimate-at-completion units. This is the same as HU, except that it updates the BORG field instead of the net posting period field.
EACA The estimate-at-completion amount. This is the same as HA, except that it updates the BORG field instead of the net posting period field.
RMA The remaining amount, which the system calculates using the formula HA – AA.
RMU The remaining units, which the system calculates using the formula HU – AU.
Bug 29311703 - MOC R NOT UPDATING THE HEADER/IA & IU NOT GETTING CREATED -BUG 23214515
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document