A negative amount in the Qty defective field is carried in the Qty Available field. These (2) two fields prove confusing to End Users (Sales & C.S.) when verifying inventory quantities before a sale. How can the Qty Defective field be cleared? Or is it even possible?
The Qty. Defective field?? What is that?
Are you working in the distribution database? If so, you should be able to create a journal entry in the item journal that adjusts the Qty Defective field. Create the journal entry (i.e. postive, negative,etc) with the appropriate amount and change the inventory status field to defective. This should clear out the Qty defective field.