Load initial inventory cost data

Sterling™ Order Management System Software provides an API to load the initial inventory value of an item at a ship node for a given quantity. The loadInventoryNodeCost API supports multiple items to be given in the input with inventory cost data for each ship node under that.

The loadInventoryNodeCost API validates the Quantity passed with the actual inventory supply information available for that item/ship node. This API only considers the supply types which are specified as on-hand and cost maintained. .

This API is called for the initial load of cost data at system start up time. This API should not be used after going into production with the Inventory Costing Management feature implemented.

The following query can be run to get the initial onhand supply quantity:

SELECT B.ORGANIZATION_CODE, B.ITEM_ID, B.UOM, B.PRODUCT_CLASS, A.SHIPNODE_KEY 
SHIP_NODE, SUM(QUANTITY) QUANTITY 
FROM YFS_INVENTORY_SUPPLY A,YFS_INVENTORY_ITEM B
WHERE A.INVENTORY_ITEM_KEY = B.INVENTORY_ITEM_KEY
AND SUPPLY_TYPE IN (
SELECT SUPPLY_TYPE FROM YFS_INVENTORY_SUPPLY_TYPE
WHERE ONHAND_SUPPLY = 'Y' AND COSTING_REQUIRED = 'Y')
GROUP BY B.ORGANIZATION_CODE, B.ITEM_ID, B.UOM, B.PRODUCT_CLASS, A.SHIPNODE_KEY