On Order Descrepancies
|
||
SELECT Inventory.LocalSKU, Inventory.ItemName, InventorySuppliers.SupplierSKU, InventorySuppliers.OnOrder, Sum(POHistory.Quantity) AS QtyOnOrder FROM Inventory INNER JOIN (InventorySuppliers INNER JOIN POHistory ON (InventorySuppliers.LocalSKU = POHistory.LocalSKU) AND (InventorySuppliers.SupplierSKU = POHistory.SuppliersSKU)) ON Inventory.LocalSKU = InventorySuppliers.LocalSKU WHERE (POHistory.Type = "E") GROUP BY Inventory.LocalSKU, Inventory.ItemName, InventorySuppliers.SupplierSKU, InventorySuppliers.OnOrder HAVING (Sum(POHistory.Quantity) <> [OnOrder])
|