E1: 31A: Planned Variance Rounding Remaining In WIP After R31804
Last updated on NOVEMBER 30, 2017
Applies to:JD Edwards EnterpriseOne Shop Floor Control - Version 9.1 and later
Information in this document applies to any platform.
E1 9.1 / R31804 Manufacturing Variance Accounting
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 (i.e ItemA), and two Stocking Type P purchased components (i.e. ItemB and ItemC).
2. Create P4105 records for each item 07 Sales/Inv and 08 Purchased. For the purchased components give item ITEMB 08 cost of 19.20 and ItemC 08 cost of 15.15.
3. Create a P3002 Bill of Material (BOM) for the parent item (ITEMA) with only component ITEMB, Quantity (QNTY) = 5.83.
4. Simulate R30812 and Freeze R30835 07 standard cost for item ITEMA (simulate and freeze all items/levels of BOM). Simulate and Freeze component ITEMC.
5. Create a work order (P48013) for ITEMA for a quantity of 1 and attach the part list. Notice item ITEMB is on the part list for a quantity of 5.83.
6. Re-inquire on the work order just created and Row Exit to the P3111 part list, and change component ITEMB to ITEMC for a quantity of 5.83 and Click OK to Save.
7. P31113- Issue 5.83 of component ITEMC.
8. P31114- Complete the work order, quantity of 1.
9. Make note of the Standard and Current amounts in the P31022 / F3102.
10. Run the R31802A (Manufacturing 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. Review 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. Notice that only the Planned Variance has an IV JE written to the F0911 and it is 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
so small that 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
Million Knowledge Articles and hundreds of Community platforms