E1: 31A: Rounding Remaining In WIP After R31804
Last updated on DECEMBER 23, 2015
Applies to:JD Edwards EnterpriseOne Shop Floor Control - Version 9.1 to 9.1 [Release 9.1]
Information in this document applies to any platform.
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. On a BOM, enter 10 component items. Each component item has a cost of $.105
2. Simulate and freeze. The parent item F30026 will be $1.05
3. Enter a work order for QTY 1 and issue one each of all the component items. Complete the work order.
4. Run R31802A and review the 0911 transactions. There will be an IM
journal entry for each component rounded to currency decimal of $.11. The total IM journal entries will be a debit to WIP of $1.10. The IC will be written for 1 x the parent F30026, or a credit to WIP for $1.05.
5. Review the F3102 and see that the IC matches the journal entry, but each component was recorded in the actual column as $.105 totaling $1.05.
6. Run R31804. R31804 compares the $1.05 in the actual column to the $1.05 in the completed column, and sees no value to clear from WIP so no journal entry is written to the WIP account.
7. This leaves the difference between the IM and IC journal entries in the GL WIP account, which must be cleared by manual journal entries.
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