Respected Experts, I want to fetch/show TCS in my report also. I have tried a lot. Please help me to do so. [#Menu : Gateway of Tally] Add : Item : GST Report2 : Menu : GST Report [Menu : GST Report] Add : Item : All GST Sales : Display : GST Sales Add : Item :"" [Report : GST Sales] Title: GST Sales Variables : SV CurrentCompany Form :GST Sales Variable : SVFromDate,SVToDate Set : SVFromDate : $$MonthStart:##SVCurrentDate Set : SVToDate : $$MonthEnd:##SVCurrentDate Set : Is Day Book : Yes [Form :GST Sales] Space Right : 1.5 Space left : 1.5 ;Space tOP : 1.5 ;Space Bottom : 1.5 Part SP AccTitles, daybookheadbb2, GST Sales,daybookbottam2 ;;,daybookhead22 ;;;daybookhead2, Buttons : ExplodeFlag,ChangeDybkDate,ChangePeriod BottomButton: BlankButton, RelReports, InvReports, AcctReports, Report Operations, FilterButton, ValueButton Buttons : PrintButton, ExportButton, UploadButton, MailButton Bottom Toolbar Buttons : BottomToolBarBtn1, BottomToolBarBtn2_EditVch, BottomToolBarBtn3, BottomToolBarBtn4, BottomToolBarBtn5, BottomToolBarBtn6, BottomToolBarBtn7, BottomToolBarBtn8, BottomToolBarBtn9, BottomToolBarBtn10, BottomToolBarBtn11, BottomToolBarBtn12 Background : white Page Break : UsCs GI ClPgBrk2 , UsCs GI OpPgBrk2 [Part: UsCs GI ClPgBrk2] Lines : UsCs GI ClPgBrk2 [Line: UsCs GI ClPgBrk2] Fields : Simple Field Local : Field : Simple Field : Set As : "Continued..." Local : Field : Simple Field : FullWidth : Yes Local : Field : Simple Field : Align : Right Border : Full Thin Top [Part: UsCs GI OpPgBrk2] Parts : SD Title2, daybookheadbb2 ;;;;, UsCs GI Inventory Title Vertical : Yes [Part: SD Title2] Line: SD Title2, daybookheadB2 [Line: SD Title2] Fields : Simple Field Local : Field : Simple Field : Set As : @@CmpMailName Local : Field : Simple Field : Align : Center Local : Field : Simple Field : FullWidth : Yes Local : Field : Simple Field : WideSpaced: Yes SpaceBottom : 1 [Line :daybookheadB2] Field : Simple Field Local : Field : Simple Field : Info : "GST Sales from " + $$String:##SVFromDate +" to " + $$String:##SVToDate ;;==================GST Purchase============================== [Part : daybookheadbb2] Use : GST Sales Delete : Repeat Delete : Scroll Border : ColumnTitles Local : Field : Default : Type : string Local : Field : My Voucher Srl2 : Set As : "Sr.No" Local : Field : MyVoucherParty2: Set As : "Party Name" Local : Field : MyVchTIN2 : Set As : "GST No" Local : Field : MyVchNo2 : Set As : "Bill No" Local : Field : My Voucher Date2 : Set As : "Bill Date" Local : Field : Item : Set As : "Item Details" Local : Field : IE Qty : Set As : "Quantity" Local : Field : IGST PER:Set as:"%" Local : Field : HSNCodeSS : Set As : "HSN CODE" Local : Field : MyVchAmount2x : Set As : "Basic Amount" Local : Field : MyVchfNo2 : Set As : "CGST " Local : Field : MyVchfNo3 : Set As : "SGST " Local : Field : MyVchfNo4 : Set As : "IGST " Local : Field : MyVchfNo5 : Set As : "TCS " Local : Field : MyVchTotAmount2x : Set As : "Total Amount" Local :Field : Default : Style : Normal Local: Field: Default: Align: Center [Part :GST Sales] Line : GST Sales Repeat :GST Sales :My Voucher Rep Collection2 tOTAL : My Voucher Srl2,MyVchAmount2x,MyVchfNo4,MyVchfNo2,MyVchfNo3,MyVchfNo4, MyVchfNo5, MyVchTotAmount2x Common Border : Yes Scroll : Vertical [Line :GST Sales] Field :My Voucher Srl2,MyVoucherParty2,MyVchTIN2,MyVchNo2,My Voucher Date2, Item, IE Qty, IGST PER,HSNCodeSS, MyVchAmount2x,MyVchfNo4,MyVchfNo2,MyVchfNo3,MyVchfNo4, MyVchfNo5, MyVchTotAmount2x Option : Alter on enter Option : DisplayOnAltEnter Explode : My TB Inv Explosion : ##ExplodeFlag or $$KeyExplode Option:Colorfull display:$amount>10000 [!Line:Colorfull Display] Local:Field:MyVoucherParty2:ColorARK red Local:Field:MyVchAmount2x:Color:dark red [Part: My TB Inv Explosion] Lines : My TB Inv Explosion Repeat : My TB Inv Explosion : ledger Entries;Inventory Entries Scroll : Vertical [Line : My TB Inv Explosion] Field : My TB Inv ExplosionItem ; here add other fields Indent : 5 [Field: My TB Inv ExplosionItem] USe : Name field Set as : $LedgerName;$StockItemName ;Option : Alter On Enter [Field :My Voucher Srl2] Use : Number Field SET AS:$$LINE Width : 4% Screen Align: Right Border : Thin LEFT Right [Field :My Voucher Date2] Use : Short Date Field Set As : $Date Border : Thin Right Format:"Short Date" [Field : MyVoucherParty2] Use : NAme Field Set As : $LedgerName ;;;$BASICBUYERNAME Width : 35 Border : Thin Right Alter : Voucher Display : Ledger Vouchers:$$ISLedger Variable: Ledger Name [Field : MyVchTIN2] Use : Name Field Set As :$PartyGSTIN:Ledger:$PartyLedgerName Width : 11 Border : Thin Right [Field : MyVchNo2] Use : NAme Field Set As : $VoucherNumber;REFERENCE Width : 10 Border : Thin Right Align:Center [Field: Item] Use : NAme Field Set As : $StockItemName Style : Small Italic Border : Thin Right Display : Item Vouchers:$$ISItem Variable: Item Name Color : "Dark Red" Align:Center Width : 10 [Field: IE Qty] Use : Number Field Set as : $$CollQtyTotal:InventoryEntries:$BilledQty ;;;;$$Total:BilledQty Border : Thin Right Format : "NoSymbol" Align : Right Color : "Dark Red" Width : 10 [Field:IGST PER] Use: Number Field Set as:$GSTIGSTRate:Stockitem:$StockItemName ;Set as:$(Stockitem,$stockitem).GSTIGSTRate Format : "NoZero,Percentage" Set Always: Yes Border : Thin Right Color : "Blue" Align:Center Width:4 [Field: HSNCodeSS] Use : Number Field Set As : $GSTHSNCode:StockItem:$StockItemName Style : Small Italic Border : Thin Right Color : "Blue" Align:Center Width : 10 [Field : MyVchAmount2x] Use : Amount Field ;Set as:$$FilterAmtTotal:allLedgerEntries:2:$Amount ;Set as : $$NettAmount:$GSTExpTaxableAmt:$GSTIncTaxableAmt Set As: $$CollAmtTotal:allinventoryEntries:$Amount ; THIS SEA ALSO LEDGER ENTRY which this field Border : Thin Right ;*********************** [Field : MyVchfNo2] Use : Amount Forex Field Set as:$$FilterAmtTotal:LedgerEntries:CGST1:$Amount; $CGSTAmount is ok Border : Thin Right Width : 10 ;*********************** [Field : MyVchfNo3] Use : Amount Forex Field Set as : $$FilterAmtTotal:LedgerEntries:SGST1:$Amount;$SGSTAmount Border : Thin Right Width : 10 ;*********************** [Field : MyVchfNo4] Use : Amount Forex Field Set as : $$FilterAmtTotal:LedgerEntries:IGST1:$Amount;$IGSTAMOUNT ; this problems Border : Thin Right Width : 10 ;*********************** [Field : MyVchfNo5] Use : Amount Forex Field Set as : $$FilterAmtTotal:AllLedgerEntries:$TCSAmount Border : Thin Right Width : 10 ;*********************** [Field : MyVchTotAmount2x] Use : Amount Field Set As : $Amount Border : Thin Right ;*********************** [System: Formula] SGST :$$FilterAmtTotal:LedgerEntries:SGST1:$Amount SGST1 :$Name:Ledger:$LedgerName Contains $$LocaleString:"SGST" CGST :$$FilterAmtTotal:LedgerEntries:CGST1:$Amount CGST1 :$Name:Ledger:$LedgerName Contains $$LocaleString:"CGST" IGST :$$FilterAmtTotal:LedgerEntries:IGST1:$Amount IGST1 :$Name:Ledger:$LedgerName Contains $$LocaleString:"IGST" TCS :$$FilterAmtTotal:LedgerEntries:TCS:$Amount [Collection : My Voucher Rep Collection2] Type : Ledger ;Sort : Default : $BASICBUYERNAME Type : Vouchers Walk : allLedgerEntries Filter : IsSalesVT2 ;;;;,CSTFilter2 ;;,Recfiltee2 Fetch : Date,Amount,VoucherTypeName ,PArtyLedgerName,VoucherNumber,REFERENCE,ReferenceDate,Item,IE Qty,HSNCodeSS, GSTDutyAmount,BASICBUYERNAME,CGSTAmount,SGSTAmount,IGSTAmount, TCSAmount Fetch : *.* Compute:IGSTAmount:$$CollAmtTotal:InventoryEntries:$Amount * $(Stockitem,$stockitem).GSTIGSTRate / 100 ; ledger entries Compute:CGSTAmount :$$CollAmtTotal:InventoryEntries:$Amount * $(Stockitem,$stockitem).GSTIGSTRate / 100/2 Compute:SGSTAmount:$$CollAmtTotal:InventoryEntries:$Amount * $(Stockitem,$stockitem).GSTIGSTRate / 100/2 Compute:TCSAmount:$$CollAmtTotal:InventoryEntries:$Amount * $(Stockitem,$stockitem).TCSRate / 100 [Part: daybookbottam2] Lines : daybookTotalLine2 [Line: daybookTotalLine2] Use : GST Sales Local: Field: Default : Style : Small Bold ;Local: Field: Default: Type: String Local: Field: Default: Align: Right Local : Field : My Voucher Srl2 : Set as:$$NumItems:MyVoucherRepCollection2;$$PrevLine:#MyVoucherSrl2 Local : Field : MyVoucherParty2: Set As : "Total" Local : Field : MyVchNo2 : Set As : "" Local : Field : MyVchAmount2x : Set As : $$Total:MyVchAmount2x LOCAL : FIELD: MyVchfNo2:Set as:$$Total:MyVchfNo2 LOCAL : FIELD: MyVchfNo3:Set as:$$Total:MyVchfNo3 LOCAL : FIELD: MyVchfNo4:Set as:$$Total:MyVchfNo4 LOCAL : FIELD: MyVchfNo5:Set as:$$Total:MyVchfNo5 LOCAL : FIELD: MyVchTotAmount2x:Set as:$$Total:MyVchTotAmount2x Border : Totals [System: Formula] IsSalesVT2 : $$IsSales:$VoucherTypeName CSTFilter2 : not ##IsRevChargeAppl
[Field : MyVchfNo5] Use : Amount Forex Field Set as : $TCS Border : Thin Right Width : 10 ;*********************** [Field : MyVchTotAmount2x] Use : Amount Field Set As : $Amount Border : Thin Right ;*********************** [System: Formula] SGST :$$FilterAmtTotal:LedgerEntries:SGST1:$Amount SGST1 :$Name:Ledger:$LedgerName Contains $$LocaleString:"SGST" CGST :$$FilterAmtTotal:LedgerEntries:CGST1:$Amount CGST1 :$Name:Ledger:$LedgerName Contains $$LocaleString:"CGST" IGST :$$FilterAmtTotal:LedgerEntries:IGST1:$Amount IGST1 :$Name:Ledger:$LedgerName Contains $$LocaleString:"IGST" TCS :$$FilterAmtTotal:LedgerEntries:TCS1:$Amount TCS1:$Name:Ledger:$LedgerName Contains "TCS"