fwebb 12/18/2012 2:16:36 PM

Quantity sold negative value

I have an item that is showing -1 Sold on the Item inquiry window, the On hand = 3, Allocated =1, Available = 2, On order =250, and the rest are 0. I did an inventory reconcile on that Item number but it didn't help, is there any way to fix it in the tables?  I know that IV00102 has the Negative value but I doubt it would be as simple as just  totaling the Quantity Received and subtracting the Quantity Sold displayed on the Purchase Receipts Inquiry window then changing the QTYSOLD value on IV00102 to 158 (Quantity Received =161 - 3 Not sold = 158) 

Thanks in advance for any help

Version: GP 2010
Section: Dynamics GP


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3