My Oracle Support Banner

WS: 41: Reclassifications - P4116 Quantity Truncation Creates Transaction with Incorrect TRQT * UNCS = ECST After Error 0252 -Extended Price Invalid and Manual Re-entry of Original Quantity (Doc ID 2868671.1)

Last updated on MAY 10, 2022

Applies to:

JD Edwards World Inventory Management - Version A9.4 and later
Information in this document applies to any platform.

Symptoms

In a multi-decimal environment with 4 display decimals where a Reclassification P4116 transaction is created with quantity greater than 100,000.0000, the leading digit of the quantity is truncated but the Extended Cost value has the correct value for the full/original quantity resulting in error 0252 - Extended Price Invalid which should prevent the transaction from completing. However, if the user manually reenters the original Quantity in the Quantity field, the transaction will be created.  However, the transaction record created as seen in the Cardex has the truncated quantity and the correct/original unit cost along with the original Extended Cost.  The average cost of the item can also be corrupted due to this transaction.

(truncated Quantity * Unit Cost <> Extended Cost ) (non-truncated Quantity * Unit Cost = Extended Cost).

Steps:
1. In Multi-Decimal A9.4 with 4 decimal places, create a Reclassification, P4116.
2. In the From & To Quantity fields, enter quantity 130000. Upon pressing Enter this changes to 30,000.0000- on the From line and 30,000.0000 on the To line.  However, the Extended Price on both lines is 133,000.00, the extension of 130,000.0000 * 1.0000 = 130,000.00.
3. Error 0252 is generated, normally preventing the transaction from continuing or completing.  The error is correct because after the quantity truncates, the calculation TRQT * UNCS = ECST is no longer valid.
4. If you then manually reenter the original quantity 130000 in both the From and To Quantity fields and press Enter, the transaction is created.
5. The Unit Cost and Extended Cost of the transaction seen in the Cardex are correct, but the quantity is the truncated quantity so instead of qty = 130,000.0000, it shows 30,000.0000.
6. The P4111 Cardex shows how the transaction was created with the truncated quantity and so with the extended cost still being the original ext cost, this leads to incorrect changes to the Average Cost of the item. 
7.  The item Quantity and Average Cost are now corrupted/ incorrect.
  

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.