Display gst rate of Products,

Discussion in 'Tally Developer' started by Manoj Anandan, Feb 13, 2020.

    
  1. Manoj Anandan

    Manoj Anandan Member


    Can Someone Help Me with how to display Gst rate of products in the below mentioned code,




    [#Menu: Inventory Books]

    Key Item : @@prcchk : K : Display : Stock price : $$IsInventoryOn:$$CurrentCompany
    [System: Formula]

    prcchk:$$LocaleString:"Stock Item Price List"

    [Report:Stock price]

    Form:Stock price
    [Form: stock price]
    Use:Dsp Template
    Part:Form title,subtit, list of products

    [Part:Form Title]
    Lines:form title
    [Line:form title]
    Field:title
    Space Bottom: 1
    Border: thin bottom
    [Field: title]
    Info:"Price List of Products"
    Align:Center
    Full Width:Yes
    Style: Normal Bold
    [Part:subtit]
    Line:subt
    [Line:subt]
    Field:tpname,tpcstock,tprate,tgst
    Border : column titles
    [Field: tpname]
    Info:"Products"
    Full Width:Yes
    ;;Border:Thick box
    Align:Left
    [Field: tpcstock]
    Info:"Qty"
    Width:20
    ;;Border:Thick box
    Align:Center

    [Field: tprate]
    Info:"Sales rate"
    Width:20
    Align:Center
    ;;Border:Thick box
    [Field: tgst]
    Info:"GST"
    Width:20
    Align:Center

    [Part:List Of Products]
    Lines:lst
    Repeat:lst:Stockitem
    Vertical : Yes
    Scroll : Vertical
    CommonBorder: Yes

    [Line:lst]
    Field:pname,pcstock,prate,pgst

    [Field: pname]
    Use : Name Field
    Set as : $NAME
    fullWIdth : Yes

    [Field: pcstock]
    Use : Qty Primary Field
    ;; Invisible : @@QtyInvisible
    Width : 20

    Format : "NoZero"

    Align:Center
    Set as : $ClosingBalance

    [Field: prate]
    Use : simple field
    Width : 20
    Align:Center
    SET AS: $STANDARDPRICE
    ;;Set as: @@krgst

    [Field: pgst]
    Use : simple field
    Width : 20
    Align:Center

    Set as:$IGSTRate

    [ Collection : lst]
    Type : stockitem
     


  2. Varun Reddy

    Varun Reddy New Member


    [Field: pgst]
    Use : simple field
    Width : 20
    Align:Center
    Set as:$(StockItem, $Name).GstDetails[Last].STATEWISEDETAILS[1].RateDetails[1, @@IsIGST].GSTRate

    ;; But here you will get only the Last GST Rate of the item i mean Latest GST Rate.
     


  3. Manoj Anandan

    Manoj Anandan Member


    Thank u Mr.Varun.How do I remove stock items with zero Closing Balance
     


  4. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    Option Available in F12
     


  5. ANANDH-laxmi

    ANANDH-laxmi New Member



Share This Page