Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
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