66 | UPDATEMANUALCOST (Custom Report)
This article demonstrates an example of a Custom Update Manual Cost Report. Disclaimer: This report may need modifications or alterations base on each system setup and configuration.
This article demonstrates an example of a Custom Update Manual Cost Report.
Disclaimer:
This report may need modifications or alterations base on each system setup and configuration.
Report Query:
<?xml version="1.0" encoding="utf-8"?>
<cViews xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<iListType>25</iListType>
<dtDateUpdated>2012-07-10T14:30:29</dtDateUpdated>
<iOperatorID>0</iOperatorID>
<sName>UPDCOST</sName>
<sViewXML><?xml version="1.0" encoding="utf-16"?><cCustomReport xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><sReportName>Update Manual Cost Non Stocked</sReportName><sSQL>select * from store
update prodstore
set CostLastEx = newdata.CostLastEx,
CostLastInc = newdata.CostLastInc,
CostAvgCurrEx = newdata.CostAvgCurrEx,
CostAvgCurrInc = newdata.CostAvgCurrInc
from (Select productid, CostLastEx, CostLastInc, CostAvgCurrEx, CostAvgCurrInc from ProdStore where StoreID = 4) newdata
where StoreID &lt;&gt; 4 and ProdStore.productid = newdata.ProductID and prodstore.productid in (Select productid from product where NonStocked = 1)</sSQL><oColumnDefs><dictionary /></oColumnDefs></cCustomReport></sViewXML>
</cViews>