dear experts i am trying to add a line to display profit in stock query but am unable to do so need your expert advice [line : stqprofit] fieldS : medium prompt,STQgp LOCAL : FIELD : Medium Prompt : Info : $$LocaleString:"Item Profit:" invisible : Not $$IsOwner [field : stqgp] Use : Amount Field Set as : $$AsCrAmt:$$AmountsubtractBaseVchOutBaseVchCons BaseVchOut : #DSPVchOutAmt:StockItem:##StockItemName BaseVchCons : #DSPVchConsAmt:StockItem:##StockItemName Format : "ShowZero"
done it cheers [line : stqprofit] fieldS : medium prompt,STQgp LOCAL : FIELD : Medium Prompt : Info : $$LocaleString:"Item Profit:" invisible : Not $$IsOwner [field : stqgp] Use : Amount Field set as : ($outwardvalue:StockItem:##StockItemName + $ClosingValue:StockItem:##StockItemName) - ($InwardValue:StockItem:##StockItemName + $OpeningValue:StockItem:##StockItemName) Width : @@DSPVchAmtWidth Format : "ShowZero"