Jiwa

Hi,

We need to determine "Available stock on hand" and (with prior assistance from these forums) now have a JiwaInventory.Inventory object for an item.

This object exposes a SOHCollection class, which supports a Read(bool, logical-warehouse) method. Our testing shows this method populates the TotalSOH and Backorders properties of the SOHCollection.

How do we determine "available" from this?

Is available:

* TotalSOH
* TotalSOH - Backorders
* Something else

Many thanks!

SOH- BO

The following SQL will also do it, if the object is too slow.

Code: Select all

         SET @CurrentSOH = 0

         SELECT  @CurrentSOH = coalesce( SUM(QuantityLeft),0)
         FROM     dbo.IN_SOH
         WHERE   (InventoryID = @CurrentInventoryID) AND (IN_LogicalID =  @WarehouseID)
         GROUP BY InventoryID, IN_LogicalID

         set @CurrentBO  = 0

         SELECT  @CurrentBO = coalesce( SUM(Quantity) ,0)
         FROM     dbo.IN_OnBackOrder
         WHERE   (InventoryID = @CurrentInventoryID) AND (IN_LogicalID =  @WarehouseID)
         GROUP BY IN_LogicalID, InventoryID


TotalSOH - Backorders