Itemwise Cost Rate Report

I try to getting the report of itemwise Cost price inclusive tax rate. Values not fetch for GST% Column and Cost Rate (Incl.of Tax) Column. Please correct my code.





;;--------------------------Stock Itemwise Cost Rate Report---------------------------------;;



[#Menu:Gateway of Tally]

Add : Item : Itemwise Cost Rate Report : Display : Item Sell and Cost Rate Report

[Report:Item Sell and Cost Rate Report]

Title : "Itemwise Cost Rate Report"
Add : Form : Item Sell and Cost Rate Report

[Form: Item Sell and Cost Rate Report]


Buttons : PrintButton, ExportButton, UploadButton, MailButton
Space Top : if $$InPrintMode then ##SVSpaceTop else 0.05 inches
Space Bottom: if $$InPrintMode then 0.5 else 0 inches
Space Left : if $$InPrintMode AND $$InPixelMode then 0.5 else 0 inches
Space Right : if $$InPrintMode AND $$InPixelMode then 0.25 else 0 inches
Part : Item Sell and Cost Report Title, Item Sell and Cost Report Det
Background : @@SV_RELEASEDORANGE

[Part:Item Sell and Cost Report Title]

Line : Item Sell and Cost Report Title, Item Sell and Cost Report Title1
Local : Field : Default : Align : Center
Local : Field : Default : Style : Small Bold
Local : Field : Default : Type : String


[Line: Item Sell and Cost Report Title]

Fields : SnField, ReportItemName, ItemTaxRate, CostwithoutTax, Costwithtax


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 : CostwithoutTax : Set as: $$LocaleString:"Cost Rate"
Local : Field : CostwithTax : Set as: $$LocaleString:"Cost Rate"
Border : Thick Top


[Line: Item Sell and Cost Report Title1]

Fields : SnField, ReportItemName, ItemTaxRate, CostwithoutTax, Costwithtax

Local : Field : Snfield : Set as: $$LocaleString:""
Local : Field : ReportItemName : Set as: $$LocaleString:""
Local : Field : ItemTaxRate : Set as: $$LocaleString:""
Local : Field : CostwithoutTax : Set as: $$LocaleString:""
Local : Field : CostwithTax : Set as: $$LocaleString:"(Incl.of Tax)"
Border : Thin Bottom



[Part:Item Sell and Cost Report Det]

Line : Item Sell and Cost Report Det
Repeat : Item Sell and Cost Report Det:Item Rate Coll
Scroll : Vertical
Common Border:Yes
Float : No
Border : Double Bottom


[Line:Item Sell and Cost Report Det]

Fields : SnField, ReportItemName, ItemTaxRate, CostwithoutTax, Costwithtax

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 * 3
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:CostwithoutTax]
Use : Name field
Set as : $StandardCost:StockItem:$StockItemName
Border : Thin Right

[Field:Costwithtax]
Use : Name field
Set as : (100+ $GSTIGSTRate)/100*($StandardCost)
Border : Thin Right
;Format : "NoZero, NoPercentage"
;Set Always: Yes




[Collection:Item Rate Coll]

Type : Stock Item
Fetch : StockItemName, GSTIGSTRate, StandardCost


;;End-of-File

 

Sir, it's working....Thank you very much