kingdee/icInventory.go
@@ -25,7 +25,7 @@ ti.FName AS FUnit, CONVERT (FLOAT, i.FQty) AS FUnitQty, ti2.FName AS FSec, i.FQty AS FQty i.FQty AS FQty FROM ICInventory AS i LEFT OUTER JOIN t_ICItem AS item ON i.FItemID = item.FItemID @@ -34,10 +34,10 @@ LEFT OUTER JOIN t_Item AS ti2 ON item.FStoreUnitID = ti2.FItemID LEFT OUTER JOIN t_Item AS ti3 ON LEFT (item.FNumber, 5) = ti3.FNumber AND ti3.FItemClassID = 4 WHERE (i.FQty <> 0) --WHERE -- (i.FQty <> 0) ORDER BY item.FNumber item.FNumber ` var result []Inventory
