HSN-wise & Rate-wise Stock Details

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 ----

 

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