GOOD MORNING HERE I HAVE AN CODE AND NEED TO CHANGE AS PER MY REQUIREMENT I WANT TO FETCH SALES INVOICE VALUE MONTHLY AND TAX DEDUCTION VALUE MONTHLY I HAVE A FORMULA BUT ITS WORKS ONLY FOR OPENING AND CLOSING VALUE KINDLU SEE PLZ [#Menu:Gateway of Tally] Add:Button:Returns ;Add:Key Item:Tax Return:Iisplay Collection:SJGroupColl00:NOT $$IsEmpty:$$SelectedCmps [Button:Returns] Title:"Returns" Key:ALT + I Actionisplay Collection:SJGroupColl00 [Collection:SJGroupColl00] Use:Remote My Ledger Coll00 Delete:Report Add:Report:SJGroup00 [Collection:Remote My Ledger Coll00] Use:Alias Collection Type:Ledger Variable:LedgerName Trigger:Remote Triggered Led Report00 Report:Remote Final Led Report00 Fetch:Name [Report:Remote Triggered Led Report00] Title:"Select Ledger" Form:Remote Triggered Led Report00 Variable:SVFromDate, SVToDate VariableSPShowOpening, DSPShowClosing [Form:Remote Triggered Led Report00] Parts:Remote Triggered Led Report00 [Part:Remote Triggered Led Report00] Lines:Remote Triggered Led Report00 [Line:Remote Triggered Led Report00] Fields:Medium Prompt, Remote Triggered Led Report00 Local:Field:Medium Prompt:Set as:"Ledger :" [Field:Remote Triggered Led Report00] Use:Name Field Table:Remote My Ledger Coll00 Show Table:Always Modifies:LedgerName [System:Formulae] SundryDebtors00:$$IsBelongsTo:$$GroupSundryDebtors [Report:SJGroup00] Form:SJGroup00 Object:VOUCHER:##VOUCHERID Title:"" Print Set:REPORT TITLE:"," Fetch Object:Ledger:#LedgerName:Name, LedgerContact, LedgerPhone, OpeningBalance, LedOpeningBalance, TBalOpening [Form:SJGroup00] Top Part:SJGroupTop00 Space Top:0.4 INCH Space Left:0.5 INCH Space Right:0.3 INCH Space Bottom:0.10 INCH Buttonrint Button [Part:SJGroupTop00] Part:SJGroupTopCmp00,SJGroupTopCmpTit00 Vertical:yes [Part:SJGroupTopCmp00] Line:SJGroupTopCmp00,SJGroupTopCAdd00,SJGroupTopCEMN00,SJGroupTopCEMN100 [Line:SJGroupTopCmp00] Field:Name Field Local:Field:Name Field:Set as@CmpMailName Local:Field:Name Field:Full Width:Yes Local:Field:Name Field:Align:Center Local:Field:Name Field:Style:Normal Bold Local:Field:Name Field:Border:Thin Bottom Local:Field:Name Fieldrint FG:Blue Local:Field:Name Field:Color:Blue [Line:SJGroupTopCAdd00] Field:Name Field Local:Field:Name Field:Set as:$$FullList:SJCompanyaddress:$Address Local:Field:Name Field:Full Width:Yes Local:Field:Name Field:Align:Center Local:Field:Name Field:Style:Normal Bold Local:Field:Name Field:Color:Blue Local:Field:Name Fieldrint FG:Blue [Collection:SJCompanyaddress1] Type:Address:Company Child Of:##SVCurrentCompany Filter:IsNotBlankAddr [Line:SJGroupTopCEMN00] Space Top:2 Field:Name Field,Short Name Field Local:Field:Name Field:Set as:"Email:- " + $Email:Company:##SVCurrentCompany Local:Field:Name Field:Full Width:Yes Local:Field:Name Field:Align:Left Local:Field:Name Field:Style:Normal bold Local:Field:Name Field:Color:Maroon Local:Field:Name Fieldrint FG:Maroon Local:Field:Short Name Field:Set as:"Contact:-0302-666-5753 " + $MobileNumbers:Company:##SVCurrentCompany Local:Field:Short Name Field:Full Width:Yes Local:Field:Short Name Field:Align:Right Local:Field:Short Name Field:Style:Normal bold Local:Field:Short Name Field:Color:Maroon Local:Field:Short Name Fieldrint FG:Maroon [Line:SJGroupTopCEMN100] Space Top:1.5 Field:Name Field,Short Name Field Local:Field:Name Field:Set as:"" Local:Field:Name Field:Width:480 Local:Field:Name Field:Align:cENTER Local:Field:Name Field:Style:large Bold Local:Field:Name Fieldrint fg:Maroon Local:Field:Name Field:Color:Maroon Local:Field:Name Field:Set as:$UDFNPCMPRNTST:Ledger:#LedgerName [Part:SJGroupTopCmpTit00] Line:SJGroupTopCmpTit0010,SJGroupTopCmpTit2000,SJGroupTopCmpTFDet0010,SJGroupTopCmpTFDet00,SJGroupTopCmpTFDet10 [Line:SJGroupTopCmpTit0010] Field:Name Field Space top:1 Local:Field:Name Field:Set as:"YEARLY RENT & TAX DEDUCTION SCHEDULE." Local:Field:Name Field:full Width:yes Local:Field:Name Field:Align:Center Local:Field:Name Fieldrint BGark Green Local:Field:Name Field:Color:maroon Local:Field:Name Field:Style:Normal Bold Local:Field:Name Fieldrint fg:White Local:Field:Name Field:Background:Yellow [Line:SJGroupTopCmpTit2000] Field:Name Field,short name field Space top:1 Local:Field:Name Field:Set as:"Monthwise Rent." Local:Field:Name Field:full Width:yes Local:Field:Name Field:Align:Center Local:Field:Name Fieldrint BGark Green Local:Field:Name Field:Color:maroon Local:Field:Name Field:Style:Normal Bold Local:Field:Name Fieldrint fg:White Local:Field:Name Field:Background:Yellow Local:Field:Short Name Field:Set as:"Monthwise Tax(Rent)." Local:Field:Short Name Field:full Width:yes Local:Field:Short Name Field:Align:Center Local:Field:Short Name Fieldrint BGark Green Local:Field:Short Name Field:Color:maroon Local:Field:Short Name Field:Style:Normal Bold Local:Field:Short Name Fieldrint fg:White Local:Field:Short Name Field:Background:Yellow [Line:SJGroupTopCmpTFDet0010] Left Fields:Name Field,SJGroupStart010 Right Fields:Short Name Field,SJGroupShNo010 Border:Thin top Local:Field:Name Field:Set as:"July 2019:" Local:Field:Name Field:Full Width:yes Local:Field:Name Field:Align:Left Local:Field:Short Name Field:Set as:"July 2019:" Local:Field:Short Name Field:Full Width:yes Local:Field:Short Name Field:Align:left [Field:SJGroupStart010] Use:amount Field Set as:$$AsDrAmt:$$ToValue:$Date:$closingbalance:LEDGER:#LEDGERNAME Align:left Full Width:Yes Style:Normal Bold [Field:SJGroupShNo010] Use:Name Field Set as:$ledid4:Ledger:#LedgerName Align:left Full Width:Yes Style:Normal Bold [Line:SJGroupTopCmpTFDet00] Left Fields:Name Field, SJGroupStart033 Right Fields:Short Name Field, SJGroupShNo033 Local:Field:Name Field:Set as:"August 2019" Local:Field:Name Field:Full Width:YES Local:Field:Name Field:Align:Left Local:Field:Short Name Field:Set as:"August 2019" Local:Field:Short Name Field:fULL Width:YES Local:Field:Short Name Field:Align:left [Field:SJGroupStart033] Use:name Field Set as:$UDFNPCMPMONM:Ledger:#LedgerName Align:left FULL Width:YES Style:Normal Bold [Field:SJGroupShNo033] Use:name Field Set as:$UDFNPCMPOCFA:Ledger:#LedgerName Align:left fULL Width:YES Style:Normal Bold [Line:SJGroupTopCmpTFDet10] Left Fields:Name Field, SJGroupStart141 Right Fields:Short Name Field, SJGroupShNo0131 Local:Field:Name Field:Set as:"September 2019:" Local:Field:Name Field:full Width:yes Local:Field:Name Field:Align:Left Local:Field:Short Name Field:Set as:"September 2019:" Local:Field:Short Name Field:full Width:yes Local:Field:Short Name Field:Align:left [Field:SJGroupStart141] Use:Short Date Field Set as:$UDFNPCMPEQFA:Ledger:#LedgerName Align:left full Width:yes Style:Normal Bold [Field:SJGroupShNo0131] Use:Name Field Set as:$UDFNPCMPEQMO:Ledger:#LedgerName Align:left full width:yes Style:Normal Bold
Hi NainaSiraj, I checked your Coding, Let me know one thing....... You want to fetch total tax value (CGST & SGST) ???