1 CREATE OR REPLACE FUNCTION itemCost(pItemid INTEGER,
10 pSiteid INTEGER) RETURNS NUMERIC STABLE AS $$
11 -- Copyright (c) 1999-2014 by OpenMFG LLC, d/b/a xTuple.
12 -- See www.xtuple.com/CPAL for the full text of the software license.
14 -- Overload for future costing enhancements
19 IF (fetchMetricBool('WholesalePriceCosting')) THEN
20 SELECT item_listcost INTO _cost
22 WHERE (item_id=pItemid);
24 SELECT itemcost(itemsite_id) INTO _cost
26 WHERE (itemsite_item_id=pItemid)
27 AND (itemsite_warehous_id=pSiteid);
32 $$ LANGUAGE 'plpgsql';
34 CREATE OR REPLACE FUNCTION itemCost(pItemsiteid INTEGER) RETURNS NUMERIC STABLE AS $$
35 -- Copyright (c) 1999-2014 by OpenMFG LLC, d/b/a xTuple.
36 -- See www.xtuple.com/CPAL for the full text of the software license.
40 SELECT CASE WHEN (itemsite_costmethod='A' AND itemsite_qtyonhand != 0.0) THEN (itemsite_value / itemsite_qtyonhand)
41 WHEN (itemsite_costmethod='A' AND itemsite_qtyonhand = 0.0) THEN 0.0
42 WHEN (itemsite_costmethod='N') THEN 0.0
43 ELSE stdCost(itemsite_item_id)
46 WHERE(itemsite_id=pItemsiteid);
49 $$ LANGUAGE 'plpgsql';