My Oracle Support Banner

E1: 41: Item Reclassification (P4116) Displays Transaction Quantities Do Not Balance (Error ID 039F) When Attempting to Combine Two Lots/Locations in New Lot/Location (Doc ID 2575364.1)

Last updated on MAY 18, 2021

Applies to:

JD Edwards EnterpriseOne Inventory Foundation - Version 9.1 to 9.2 [Release 9.1 to 9.2]
Information in this document applies to any platform.

Symptoms

P4116 - Item Reclassification

When user tries to do item reclassification, combining two Lot/Locations of same item into a third lot/location where UoM used in the transaction is different from primary UoM, following error is displayed.

ERROR
-----------------------
ID 039F - Transaction Quantities Do Not Balance
ISSUE :      The sum of the quantities of the From transactions is not equal to the sum of the quantities related To transactions.
RESOLUTION:  Enter the correct quantities to balance all FROM and TO lines for the same Transaction Line Number or set up the processing
                     options to allow unbalanced quantities to be entered.

STEPS
-----------------------
1. Have Stock Item setup with lot process type set to force lot assignment.
2. UoM Setup
- Primary = KG
- Secondary = EA
- Purchasing = KG
- Pricing = KG
- Shipping = EA
- Production = KG
- Component = KG
- Weight = KG
- Volume = KG
3. P41003 - Standard Unit Of Measure
4. P41202 - Have availability in B/P "A" for Loc/Lot "X" and Loc/Lot "Y"
5. P4116 – Reclassification using UoM pounds (LB) in B/P "A"
    a.) 1st Line (From)- Qty = 27777 - UoM = LB - Loc 1.A.1 and lot "X"
    b.) 2nd Line (From)- Qty = 11904 - Uom = LB - Loc 1.A.2 and lot "Y"
    c.) 3rd Line (To)  - Qty = 39681 - UoM = LB - Loc 1.A.3 and lot "Z"
6. Click Ok to save and see the following error:
ID 039F - Transaction Quantities Do Not Balance
ISSUE :      The sum of the quantities of the From transactions is not equal
                to the sum of the quantities related To transactions.
RESOLUTION:  Enter the correct quantities to balance all FROM and TO lines
             for the same Transaction Line Number or set up the processing
             options to allow unbalanced quantities to be entered.

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.