My Oracle Support Banner

E1: 41: Potential Causes of a Sales Order Detail Line Producing a Zero Balance Adjustment Error (41010) (Doc ID 1931332.1)

Last updated on JULY 14, 2021

Applies to:

JD Edwards EnterpriseOne Inventory Management - Version 8.11 SP1 and later
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
Information in this document applies to any platform.

Purpose

Overview

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 prevents inaccurate zero balance adjustments from being calculated.

Scope

 

Details

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
Purpose
Scope
Details
 Why Does the Error Occur?
 Examples:
 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
 Potential Workaround
 Summary and Conclusions

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