E1: 41: Reversal of Reclassification uses Different Cost than Initial Reclassification (P4116) (Doc ID 2098029.1)

Last updated on JUNE 02, 2016

Applies to:

JD Edwards EnterpriseOne Inventory Management - Version 9.0 and later
Information in this document applies to any platform.

Symptoms

Customer performed an item reclassification, with unit cost 0, afterwards transactions which affected cost were made. Reversal Item Reclassification was performed but original cost of the item was not reversed as expected.
Different cost of item was obtained at reversal of the reclassification.

The issue can be reproduced at will with the following steps:

  1. Create 2 items ( LC12 , LC13 ) by application P4101-Item Master.
  2. Maintain cost 0 for the first item (LC12) OR do not define a cost for the second item defined.
  3. Perform quantity adjustment at initial cost (zero) for both items by P4114-Inventory adjustment.
  4. Change cost for second item (LC13) by performing quantity adjustment through P4114-Inventory adjustment, using a new unit cost=5.
  5. Perform inventory issue for the same item, thus the weighted average cost becomes 3.125.
  6. Perform Item Reclassification by P4116 from second item (LC13) (unit cost=3.125/ extended amount=4.69-) to first Item LC12 (unit cost=0.0000 / extended amount = BLANK).
  7. Perform inventory adjustment for the first Item (LC12), hence changing initial cost 0 to new cost=4.
  8. Perform inventory issue for the first item (LC12), thus the weighted average cost becomes 0.1250.
  9. Perform Reversal of Reclassification by P4116-Item Reclassification.
  10. After reversal is performed check output for P4116-Inventory Reclassification, columns ( "Unit Cost" - UNCS , "Extended Amount" - PAID ), correspondent to field "From / To" - FRTO for each item apart.
  11. When inventory reclassification is performed the output is that the first item has unit cost = 0.0000 and extended cost = BLANK. If changes are made to first item cost followed by reversal of the reclassification made, the new output for first item is ( unit cost = new value, for example 0.1250 ; extended amount = new value, for example 1.88- ).
  12. Customer desired to have the reversal of the reclassification for the second item be done at the original transaction cost, because although the average has already modified the system reversal should be as the original transaction was made. Issue is at reversal of inventory reclassification step, after the reversal system recalculated the average and the issue is that it reversed at a transaction to a different cost to the original transaction.
  13. This issue is appearing only when the cost of a line in reclassification for item is zero.

Cause

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