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