_invhistid, itemsite_id, pTransType, _timestamp,
pQty, itemsite_qtyonhand,
(itemsite_qtyonhand + (_sense * pQty)),
- itemsite_costmethod, itemsite_value, itemsite_value + (_r.cost * _sense * pQty),
+ itemsite_costmethod, itemsite_value,
+ -- sanity check to ensure that value = 0 when qtyonhand = 0
+ CASE WHEN ((itemsite_qtyonhand + (_sense * pQty)) + itemsite_nnqoh) = 0.0 THEN 0.0
+ ELSE itemsite_value + (_r.cost * _sense * pQty)
+ END,
pOrderType, pOrderNumber, pDocNumber, pComments,
uom_name, _r.cost, _xferwhsid, FALSE, pItemlocSeries
FROM itemsite, item, uom