Temp Projects

Rijas P wrote:

Please see the attached sheet items with Stock but Cost and total Cost is Showing Zero. Please update the Cost value.

I have set tax exclusive purchase price as cost for all items under category "Repack" where the cost was 0 before

euro=# update m_cost mc set currentcostprice=aa.cprice from (select mp.m_product_id,mp.name,productcost(mp.m_product_id,NULL),round(bompricestd(mp.m_product_id,1000002,0,0,NULL)/1.05,4) cprice,tqty,rqty from m_product mp left join lateral (select coalesce(sum(movementqty),0) tqty,m_product_id,sum(case when movementtype in ('V+') then movementqty else 0 end) rqty from m_transaction where m_product_id=mp.m_product_id group by 2) as aa on 1=1 where mp.m_product_category_id=1015302 and productcost(mp.m_product_id,NULL)=0 and round(bompricestd(mp.m_product_id,1000002,0,0,NULL)/1.05,4) is not null) as aa where aa.m_product_id=mc.m_product_id and mc.currentcostprice=0 and mc.m_costelement_id in (1010018,1000000,1000001);
UPDATE 393

Found updated