Hello Angela,If you query an individual part from the IV00102 table you should see multiple rows for each of your locations, and another row which is the All Locations row (which has a RCRDTYPE = 1). This row contains the totals for all of your locations combined. The All Locations row is what shows in the Quantity On Hand field on the Item Master window.
So depending on if you have multiple locations or not will depend on how you proceed. The proper way to proceed would probably be to Sum for RCRDTYPE = 2 and then update the row with RCRDTYPE = 1. So if you have 2 locations, 1 with QTYONHND = 1 and the other with QTYONHND = 2 then you would update the All Locations row with QTYONHND = 3.If you only have the 1 location then you would want to use your update query and also do something like this:update IV00102set QTYONHND = 0where RCRDTYPE = 1 and LOCNCODE = '' and QTYONHND > 0You probably don't need the LOCNCODE = '' but I like my update queries to be very specific.
If you've found this thread useful, dive deeper into User Group community content by role