E1: 31A: R31802A Does Not Use UOM Conversion For X Cost
(Doc ID 2167629.1)
Last updated on JULY 07, 2020
Applies to:JD Edwards EnterpriseOne Shop Floor Control - Version 9.2 to 9.2 [Release 9.2]
Information in this document applies to any platform.
When a unit of measure exists between Primary and Production for an Actual Cost 02 parent item and the actual cost parent item has X Cost setup for it in the P30026 Enter Change Cost Components. After reporting issues, hours, completions and then running MFG Accounting R31802A. The R31802A ignores the Unit Of Measure Conversion setup and incorrectly write the X Cost IH journal entry in the F0911 at the per unit cost. It also incorrectly updates the P31022 / F3102 Actual Amounts and Units, which causes the R31804 Variance program to write incorrect / bogus IC Cost Adjustments journal entries for the difference between Actual and Completed Amounts.
Steps to Duplicate
1. In the Item Mater / Item Branch Plant create 02 Actual Cost Parent and one purchased Component. The parents primary UOM should be BT and Production UOM CS. Make the components P4105 Cost = $1.00, and make sure the parents P4105 record has Sales / Inventory Cost Method = 02 Purchased 08
2. Setup a UOM Conversion for the parent Item 1 CS = 12 BT = .0833333
3. Create a P3002 BOM for the parent item with the component on the BOM Qty = 1
4. Go to P30026 and enter X1 Cost Method 02 Actual Cost Parent Item. Make sure to populate both the Simulated and Frozen Net Added, and Total fields. Click OK to Save
5. Create a work order for the parent item for 10 CS / Cases, and attach the part list.
6. Take a look at the P31022 and make note that the Current Unit and Amounts are correctly populated, for A1 and X1 cost methods.
7. Go to P31113 and issue all the material and then complete P31114 the total WO Qty of 10 CS.
8. Go to R31802A MFG Accounting and run it in final mode. Make note of the IH JE for the X1 cost on the PDF as it’s incorrect at the per Unit Cost. i.e. .94 as the R31802A simply took .0942 X 10 = .94. When it should have used the UOM conversion to write the JE. i.e. .0942 Per BT X 12 BT = 1.1304 per Case X 10 cases = $11.30.
9. Now take a look at the P31022 and notice the R31802A correctly used the UOM conversion between BT and CS to calculate and populated Planned and Completed Amounts and Units, but it did not use the UOM conversion to populate Actual Amounts and Units. This will cause the R31804 to write bogus IC adjustments to the F0911 when run. In this test the R31804 when run will write a bogus / unwanted IC Adjustment journal entry for $10.36 the difference between Actual and Completed. i.e. 11.30 - .94 = 10.36.
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