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
[Field:ItemTaxRate] Use : Number Field Set As : @IGSTRate:StockItem:#ReportItemName IGSTRate : $$GetInfoFromHierarchy:#ReportItemName:"StockItem":"GSTRate":##SVToDate:"GST":0@IGSTDutyHead Format : "NoZero, Percentage" Border : Thin Right Align : Center ; Set Always:Yes Width : 10
Code: Set As : @IGSTRate:StockItem:#ReportItemName IGSTRate : $$GetInfoFromHierarchy:#ReportItemName:"StockItem":"GSTRate":##SVToDate:"GST":0:@@IGSTDutyHead
Code: [Field:Costwithtax] Use : Name field Set as : (100+ #ItemTaxRate)/100*($StandardCost) Border : Thin Right