E1: 41: What can Cause of Line to Produce a Zero Balance Adjustment (41010) Error?
(Doc ID 1931332.1)
Last updated on MAY 02, 2019
Applies to:JD Edwards EnterpriseOne Sales Order Processing - Version 8.11 SP1 and later
JD Edwards EnterpriseOne Procurement and Subcontract Management - Version 8.11 SP1 and later
JD Edwards EnterpriseOne Inventory Management - Version 8.11 SP1 and later
Information in this document applies to any platform.
While performing Shipment Confirmation (P4205) or an Inventory Transaction (XT4111Z1) for an item with weighted average cost where the same item branch record is used on multiple lines and the quantity on-hand and amount in inventory will be reduced to zero, due to a zero balance adjustment, the following hard error is issued:
Line causes a zero balance adjustment (41010)
CAUSE.......This line causes a zero balance adjustment and there are other lines in this transaction for the item, branch plant, location or lot number (depending on the item's cost level).
RESOLUTION....Delete this line and accept the transaction then come back into it to add or reverse the line. Or change the quantity of the line to not cause a zero balance adjustment.
This error was introduced several years ago to prevent inaccurate zero balance adjustments from being calculated.
This was introduced in the following bugs:
The error “Line causes a zero balance adjustment” (Error ID 41010) was introduced several years ago to prevent inaccurate zero balance adjustments from being calculated. This has caused some confusion for clients upgrading from earlier releases that encounter this error for the first time. The purpose of this document is to explain why the error was introduced, and illustrate what clients can do to complete their transactions.
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
|Why does the error occur?|
|Sales Example 1 - Showing Error 41010 when more than one transaction line uses the same Item Cost record|
|Sales Example 2 - Showing no error when only one transaction line uses the Item Cost record.|
|Inventory Example 1 - Error 41010 when reversing a previously entered Adjustment with 2 lines 1 item cost|
|Inventory Example 2 - Error 41010 when different cost in multiple adjustment lines updates on-hand to zero|
|Summary and Conclusions|