My Oracle Support Banner

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.

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 was introduced several years ago to prevent inaccurate zero balance adjustments from being calculated.

This was introduced in the following bugs:

8.11 SP1 - Bug 10937847 : ZBA AFTER FULL REVERSAL - SAR: 8236245
8.12 - Bug 10938219 : ZBA AFTER FULL REVERSAL - SAR: 8241319

Scope

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.

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.