1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

stock query :- item profit

Discussion in 'Tally Developer' started by murtuza shakir, May 16, 2018.

    
  1. murtuza shakir

    murtuza shakir Member


    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:$$Amountsubtract:mad:BaseVchOut:mad:BaseVchCons
    BaseVchOut : #DSPVchOutAmt:StockItem:##StockItemName
    BaseVchCons : #DSPVchConsAmt:StockItem:##StockItemName
    Format : "ShowZero"
     
    murtuza shakir, May 16, 2018
    #1


  2. murtuza shakir

    murtuza shakir Member


    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"
     
    murtuza shakir, May 16, 2018
    #2
    Shabbir likes this.


Share This Page