HSN-wise & Rate-wise Stock Details

Discussion in 'Tally Developer' started by PHOENIX HELIOS, Jul 13, 2019.

         
  1. PHOENIX HELIOS

    PHOENIX HELIOS New Member


    Hello Experts

    This is HSN-wise and Rate-wise stock details with amount. As always many thanks to TDLexpert.com. Learning a lot of things about TDL.

    Here the problem is that it shows only the latest rates. For example, (only assumptions for the clarity purpose) HSN 85446020 till 30/09/2017 was 28% and after that it is 18%. This TDL shows only 18% the latest one. How can I show here both 18% and 28% separately i.e. showing purchase qty and sales qty separately for 18% and 28%?

    here is the code

    ;---- START ----

    [Line: Ashta Stock Itemwise HSN Report Title]

    Fields : SnField, ReportItemName, ItemTaxRate, ItemHSNCode, ItemOpQty, ItemOpValue, ItemPurcQty, ItemPurValue, ItemSaleQty, ItemSaleValue, ItemClQty, ItemClValue


    Local : Field : Snfield : Set as: $$LocaleString:"S.No"
    Local : Field : ReportItemName : Set as: $$LocaleString:"Item Name"
    Local : Field : ItemTaxRate : Set as: $$LocaleString:"GST%"
    Local : Field : ItemHSNCode : Set as: $$LocaleString:"HSN"
    Local : Field : ItemOpQty : Set as: $$LocaleString:"Opening"
    Local : Field : ItemOpValue : Set as: $$LocaleString:"Opening"
    Local : Field : ItemPurcQty : Set as: $$LocaleString:"Purchase"
    Local : Field : ItemPurValue : Set as: $$LocaleString:"Purchase"
    Local : Field : ItemSaleQty : Set as: $$LocaleString:"Sale"
    Local : Field : ItemSaleValue : Set as: $$LocaleString:"Sale"
    Local : Field : ItemClQty : Set as: $$LocaleString:"Closing"
    Local : Field : ItemClValue : Set as: $$LocaleString:"Closing"
    Border : Thick Top


    [Line: Ashta Stock Itemwise HSN Report Title1]

    Fields : SnField, ReportItemName, ItemTaxRate, ItemHSNCode, ItemOpQty, ItemOpValue, ItemPurcQty, ItemPurValue, ItemSaleQty, ItemSaleValue, ItemClQty, ItemClValue

    Local : Field : Snfield : Set as: $$LocaleString:""
    Local : Field : ReportItemName : Set as: $$LocaleString:""
    Local : Field : ItemTaxRate : Set as: $$LocaleString:""
    Local : Field : ItemHSNCode : Set as: $$LocaleString:""
    Local : Field : ItemOpQty : Set as: $$LocaleString:"Qty"
    Local : Field : ItemOpValue : Set as: $$LocaleString:"Value"
    Local : Field : ItemPurcQty : Set as: $$LocaleString:"Qty"
    Local : Field : ItemPurValue : Set as: $$LocaleString:"Amount"
    Local : Field : ItemSaleQty : Set as: $$LocaleString:"Qty"
    Local : Field : ItemSaleValue : Set as: $$LocaleString:"Amount"
    Local : Field : ItemClQty : Set as: $$LocaleString:"Qty"
    Local : Field : ItemClValue : Set as: $$LocaleString:"Amount"
    Border : Thin Bottom



    [Part:Ashta Stock Itemwise HSN Report Det]

    Line : Ashta Stock Itemwise HSN Report Det
    Repeat : Ashta Stock Itemwise HSN Report Det:Item Rate Coll
    Scroll : Vertical
    Common Border:Yes
    Float : No
    Border : Double Bottom


    [Line:Ashta Stock Itemwise HSN Report Det]

    Fields : SnField, ReportItemName, ItemTaxRate, ItemHSNCode, ItemOpQty, ItemOpValue, ItemPurcQty, ItemPurValue, ItemSaleQty, ItemSaleValue, ItemClQty, ItemClValue

    Local : Field : Default : Style : Small Bold
    Option : AlterOnEnter


    [Field:SnField]
    Use : Name field
    Set as : $$Line
    Border : Thin Right
    Width : 5
    Align : Center


    [Field:ReportItemName]
    Use : Name field
    Set as : $StockItemName
    Border : Thin Right
    ;Full Width:Yes
    Width : @@NameWidth * 1.5
    Alter : StockItem

    [Field:ItemTaxRate]
    Use : DSPDispName
    Set as : $GSTIGSTRate:StockItem:$StockItemName
    Format : "NoZero, Percentage"
    Border : Thin Right
    Align : Center
    ; Set Always:Yes
    Width : 10

    [Field:ItemHSNCode]
    Use : DSPDispName
    Set as : $GSTHSNCode:StockItem:$StockItemName
    ;Format : "NoZero, Percentage"
    Border : Thin Right
    Align : Center
    ; Set Always:Yes
    Width : 10

    [Field:ItemOpQty]
    Use : Name field
    Set as : $OpeningBalance:StockItem:$StockItemName
    Border : Thin Right
    Width : 15

    [Field:ItemOpValue]
    Use : Name field
    Set as : $OpeningValue:StockItem:$StockItemName
    Border : Thin Right
    Width : 15

    [Field:ItemPurcQty]
    Use : Name field
    Set as : $Purcqty:StockItem:$StockItemName
    Border : Thin Right
    Width : 15

    [Field:ItemPurValue]
    Use : Name field
    Set as : $Purcvalue:StockItem:$StockItemName
    Border : Thin Right
    Width : 15

    [Field:ItemSaleQty]
    Use : Name field
    Set as : $Saleqty:StockItem:$StockItemName
    Border : Thin Right
    ;Format : "NoZero, NoPercentage"
    ;Set Always: Yes
    Width : 15

    [Field:ItemSaleValue]
    Use : Name field
    Set as : $Salevalue:StockItem:$StockItemName
    Border : Thin Right
    ;Format : "NoZero, NoPercentage"
    ;Set Always: Yes
    Width : 15

    [Field:ItemClQty]
    Use : Name field
    Set as : $ClosingBalance:StockItem:$StockItemName
    Border : Thin Right
    Width : 15

    [Field:ItemClValue]
    Use : Name field
    Set as : $ClosingValue:StockItem:$StockItemName
    Border : Thin Right
    Width : 15

    [Collection:Item Rate Coll]

    Type : Stock Item
    Fetch : StockItemName, GSTIGSTRate, GSTHSNCode *.*

    ;---- END ----
     

    Attached Files:



  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Study.... $$GetGSTTransTaxInfo in TDE..........
     


  3. Ashok Chordia

    Ashok Chordia New Member


    If I use this tdl where it will be shown in tally
     


Share This Page