Communique

On Order Descrepancies

Hide Navigation Pane

On Order Descrepancies

 Previous topic Next topic No directory for this topic Expand/collapse all hidden text  

On Order Descrepancies

 Previous topic Next topic Topic directory requires JavaScript JavaScript is required for expanding text JavaScript is required for the print function Mail us feedback on this topic!  

Comments (...)

 

 

 

 

hmtoggle_plus1Sample SQL

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])

 

 

 

 

Comments (...)