GST Rate wise Stock Summary

Discussion in 'Tally & TDL Learning HUB' started by nirankarsingh, Nov 18, 2020.

         
  1. nirankarsingh

    nirankarsingh New Member


    Is there any tdl which will enable me to see stock summary GST Rate wise, or maybe show GST rate in Stock Summary.
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Yes it is there...........Kindly search for it.
     


  3. nirankarsingh

    nirankarsingh New Member


    I did search for it but couldn't find it. Kindly share link.
     


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    I will be spending as much time as you in searching for it...........

    Since I am not being paid for my valuable time and efforts, One can look and search on their own. You certainly do not expect me to do the SEARCH ground work for you...do you??
     
    Jaydeep Shah likes this.


  5. nirankarsingh

    nirankarsingh New Member


    You are already wasting your "Valuable Time" typing that message which does no contribution this forum.
    No one is bound to Search this tdl for me, if anyone has that tdl and is willing to help, can share.
    Kindly refrain from posting any more messages which does not do any value addition.
     


  6. Jaydeep Shah

    Jaydeep Shah Member



  7. Jaydeep Shah

    Jaydeep Shah Member


    How to get the same before the opening Qty. not able... tried - it coms only when opening is enabled.
     


  8. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    You need to find the appropriate placements and induct your fields accordingly.

    Since this is a TEMPLATE Format and used by many other reports of Tally.... you will have to make changes in the Title, Body and Total parts.

    Capture.PNG

    Capture2.PNG
     
    Jaydeep Shah likes this.


  9. suyash

    suyash New Member


    Hii Amit Sir , Can u taking TDL Classes ?? Online , only concepets its very helpful for all
     


  10. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    No buddy........wish I could. :):)

    This is also an online learning forum............many people are learning and experts and seniors are also helping for guidance.
     
    Jaydeep Shah likes this.


  11. suyash

    suyash New Member


    Jaydeep shah this code for you and you gaet GstRate before qty in stockSummary


    [#Field: DSPQ ClTitle]
    Add : Fields : At Beginning : DspqgatRate

    [Field: DspqgatRate]
    Info : "GST Rate"
    Width : 10% Page
    Style : Normal Bold
    Align : Center
    Color : Blue

    [#Field: DSP StkCl]
    Add : Fields : At Beginning : DspqgatRateVal


    [Field: DspqgatRateVal]
    Use : Number Field
    Set as : ($$GetGSTRate:$Date:$GSTEntryLedgerName:$StockItemName:mad:@CGSTDutyHead:$GSTStockItemRate)*2;:StockItem:$Name;$(Stockitem,$Name).GSTDetails[Last].StatewiseDetails[1, @@IsAnyState].RateDetails[1, @@IsIGST].GSTRate
    ;Set as : $GSTIGSTRate:StockItem:$Name;
    Width : 10% Page
    Format : "No zero, Percentage"
    Set Always : Yes
    Color : Blue

     
    Jaydeep Shah likes this.


  12. anish

    anish Member


    I have also tried ..... It may help somone

    [#Collection: List of Stock Items]
    Add:Sub Title :"Item Name"

    [#Collection: List of Stock Items]
    Add:Sub Title :"GST"
    Add :Format :$GSTIGSTRate
    Fetch:GSTIGSTRate

    [#Collection: List of Stock Items]
    Add:Sub Title :"HSN/SAC"
    Add :Format :$GSTHSNCode
    Fetch:GSTHSNCode


    [#Collection: List of Stock Items]
    Add:Sub Title :"CL Qty"



    [#Field: DSP StkCl]
    Add : Fields : At Beginning :HSNCodeSS,GSTRATESS
    [Field: HSNCodeSS]
    Use : DSPDispName
    Set As : $GSTHSNCode
    Style : Small Italic
    Align:Center
    Inactive:##DSPShowInwards
    Invisible : ##DSPShowInwards
    Color:Blue

    [Field: GSTRATESS]
    Use : DSPDispName
    Set As : $GSTIGSTRATE
    Style : Small Italic
    Align:Center
    Inactive:##DSPShowInwards
    Invisible : ##DSPShowInwards
    Color:Blue

    [#Field: DSPQ ClTitle]
    Add : Fields : At Beginning :DSPQHSNTitle,DSPQGRateTitle


    [Field: DSPQHSNTitle]
    Use : DSP QtyTitleTemplate
    Info : $$LocaleString:"HSN"
    Style : Small
    Align : Centre
    Invisible : ##DSPShowInwards
    Inactive:##DSPShowInwards
    Color:Blue

    [Field: DSPQGRateTitle]
    Use : DSP QtyTitleTemplate
    Info : $$LocaleString:"GST Rate"
    Style : Small
    Align : Centre
    Invisible : ##DSPShowInwards
    Inactive : ##DSPShowInwards
    Color:Blue
     
    Vashisth and Jaydeep Shah like this.


  13. Jaydeep Shah

    Jaydeep Shah Member


    Thank you v much.....:)
     


  14. Mohan.S

    Mohan.S Member


    Dear Sir
    The below code Not working In Sales Voucher In Tally Prime



    [#Part: EI BaseInfo]
    Add: Line : At End: EI lnSalesman
    [Line: EI lnSalesman]
    Fields: Short Prompt, fldSalesman
    Local: Field: Short Prompt: Info: "Salesman Name: "
    [Field: fldSalesman]
    Use: Short Name Field
    Storage: EI SalesmanName
    Width: 20
    ;;Table: MySalesmanCollection
    ;;;ShowTable: Always
    [System: UDF]
    EI SalesmanName: String: 1000
     


  15. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    [#Part: EI Consignee]
    Add: Line : After : EI Consignee : EI lnSalesman
     
    Jaydeep Shah likes this.


  16. Mohan.S

    Mohan.S Member


    Thanking you Sir
     


  17. Ankur2904

    Ankur2904 New Member


    But it shown not found under HSN Code and blank in GST Rate column. How to solve this problem.
     


Share This Page