E1: 31A: Planned Variance Rounding Remaining In WIP After R31804 (Doc ID 2183282.1)

Last updated on MARCH 01, 2017

Applies to:

JD Edwards EnterpriseOne Shop Floor Control - Version 9.1 and later
Information in this document applies to any platform.


On : 9.1 version, Mfg Accounting and Costing

When Manufacturing Accounting (R31802A) is run for issued components with F30026 records extending four decimals, the R31802A writes IM journal entries rounded to two currency decimals, but writes to the Variance Inquiry P31022 / F3102 Actual Amounts fields in four decimals. When the Variances Accounting (R31804) is run, the calculation for the balance in the WIP account is based on four decimals. This causes a difference between the calculated balance for the WIP variance journal entry, and the difference between the actual and completed journal entries remaining in the WIP account to be cleared. When R31802A is run with the work order number populated as the subledger, the difference in calculation leaves pennies behind in each subledger in the WIP GL account.

Steps To Duplicate:

1. Create M Stocking Type Parent Item 9916, and two Stocking Type P purchased components 9916C1 and 9916C2.
2. Create P4105 records for each item 07 Sales/Inv and 08 Purchased. For the purchased components give item 9916C1 and 08 cost of 19.20 and 9916C2 08 cost of 15.15.
3. Create a P3002 BOM for the parent Item with only component 9916C1 on the BOM QTY Per of 5.83.
4. Simulate R30812 and Freeze R30835 07 standard cost for Parent Item 9916 blowing through the BOM to insure component 9916C1 is also simulated and frozen. Then simulate and Freeze component 9916C2.
5. Create a P48013 MFG Work Order for a Qty of 1 and attach the part list. Notice item 9916C1 is on the part list for a Qty of 5.83.
6. Re-inquire on the work order just created and Row Exit to the P3111 part list, and change component 9916C1 to 9916C2 for a Qty of 5.83 and Click OK to Save.
7. Go to the P31113 issues program and issue 5.83 of component 9916C2.
8. Go to P31114 Completions and complete the WO for QTY of 1.
9. Make note of the Standard and Current amounts in the P31022 / F3102.
10. Run the R31802A MFG Accounting in final mode and insure there are no errors. Notice the IM and IM JE’s are correct and rounded to two decimals
11. Go back to P31022 / F3102 and make note of the Planned, Actual, and Completed Amounts. Notice the Planned Variance (Current VS Planned) of 23.6115, and the Actual Variance (Planned VS Actual) of .0045.
12. Run R31804 Variance Accounting in final mode and notice that only the Planned Variance has an IV JE written to the F0911 and its correctly rounded to two decimals at 23.61. However also notice that due to the R31802A rounding functionality for the P31022/F3102 Actual Column, where it rounds Actual to two decimals the Actual Variance of .0045 is to small and no Actual Variance is written to the F0911 by the R31804.
13. This causes pennies to be left in the F0911 WIP account. This can be seen in the P09200 or P09201 when inquiring on the WIP Account.




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