Microsoft Dynamics GP throw SQL : Find differences between Bin QTY & all site QTYs
To be sure that your quantity is correct. You need to check from time to time if there are any differences between quantities for the same item in multiple tables. Item Quantity Master (IV00102) Item Site Bin Master (IV00112) This case applies only if you are using (Enable Multiple Bins) By using a SQL query --------------------------------------------- SELECT * , ( All_Available - BIN_All_Available ) [Diff] FROM ( SELECT RTRIM(ITEMNMBR) ITEMNMBR, SUM (QTYONHND) QTYONHND, SUM (ATYALLOC) ATYALLOC, SUM (QTYONHND - ATYALLOC) SUM_Available, ( SELECT (QTYONHND - ATYALLOC) FROM IV00102 A WHERE A.ITEMNMBR = IV00102.ITEMNMBR AND LOCNCODE = '' ) [All_Available], ISNULL(( SELECT SUM (QUANTITY - ATYALLOC) FROM IV00112 B WHERE