help for fetch sales invoice value and tax value

Discussion in 'Requests' started by NainaSiraj, Apr 25, 2020.

    
  1. NainaSiraj

    NainaSiraj Member


    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:I:Display Collection:SJGroupColl00:NOT $$IsEmpty:$$SelectedCmps

    [Button:Returns]
    Title:"Returns"
    Key:ALT + I
    Action:Display 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
    Variable:DSPShowOpening, 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
    Button:print 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:mad:@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 Field:print 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 Field:print 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 Field:print 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 Field:print 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 Field:print 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 Field:print BG:Dark Green
    Local:Field:Name Field:Color:maroon
    Local:Field:Name Field:Style:Normal Bold
    Local:Field:Name Field:print 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 Field:print BG:Dark Green
    Local:Field:Name Field:Color:maroon
    Local:Field:Name Field:Style:Normal Bold
    Local:Field:Name Field:print 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 Field:print BG:Dark Green
    Local:Field:Short Name Field:Color:maroon
    Local:Field:Short Name Field:Style:Normal Bold
    Local:Field:Short Name Field:print 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
     

    Attached Files:






  2. Hi NainaSiraj,

    I checked your Coding, Let me know one thing....... You want to fetch total tax value (CGST & SGST) ???
     


Share This Page