it is best to try inventory reconcile tools first , go to support.microsoft.com/.../850365 for a guide. another answer I found was to update the inventory quantity master table. I would suggest trying it on only one item at first,if you see no issues then try it on the rest.
There is some SQL involved in this soultion , backup your database before attempting
first log into your GP data base and run this Query
SELECT [ITEMNMBR]
,[LOCNCODE]
,[BINNMBR]
,[RCRDTYPE]
,[BGNGQTY]
,[QTYRQSTN]
,[QTYONORD]
,[QTYINUSE]
,[QTYINSVC]
,[QTYRTRND]
,[QTYDMGED]
,[QTYONHND]
,[ATYALLOC]
,[QTYCOMTD]
,[QTYSOLD]
,[FXDORDRQTY]
,[ORDRPNTQTY]
,[DEX_ROW_ID]
FROM [dbo].[IV00102]
where[ATYALLOC] like '-%'
this will give you a list of all the items with negative allocation
then go into GP > inquiry > inventory> Item allocation .
in items put in the item number that you want to fix , one at a time, to get the correct allocation information.
go back to GP database and run this select statement
SELECT [ITEMNMBR]
,[LOCNCODE]
,[BINNMBR]
,[RCRDTYPE]
,[BGNGQTY]
,[QTYRQSTN]
,[QTYONORD]
,[QTYINUSE]
,[QTYINSVC]
,[QTYRTRND]
,[QTYDMGED]
,[QTYONHND]
,[ATYALLOC]
,[QTYCOMTD]
,[QTYSOLD]
,[FXDORDRQTY]
,[ORDRPNTQTY]
,[DEX_ROW_ID]
FROM [dbo].[IV00102]
where [ITEMNMBR] = 'fas11515'
this will show you which locations need to be changed
then run a update for any site that needs to be corrected , I have only ever updated sites or Rcrdtype 2 , I have never tried to update the overall record , or rcrdtype 1.
UPDATE [dbo].[IV00102]
set ATYALLOC = 'correct allocation'
where LOCNCODE = '**' and ITEMNMBR = '*****'
people more talented than me with SQL could probably create a single solid script for this.
