1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

NEED TO HELP FOR CREATE UDF BASE REPORT

Discussion in 'Free Source Codes' started by brijesh thacker, Aug 16, 2023.

    
  1. brijesh thacker

    brijesh thacker New Member


    I am create 1 udf field in ledger master and open verious ledger under this udf filed i want to create report for balance report base on udf base field value my code is below
    [#Menu : GateWay Of Tally]

    Add : Item : Before : @@locDisplay : Account Balance:Display: Account Balance

    [Report: Account Balance]
    Use : DSP Template
    Title : "Account Balance"
    Form : Account Balance
    Set : SVFromDate : $$MonthStart:##SVFromDate
    Set : SVToDate : $$MonthEnd:##SVCurrentDate
    Variable : SVFromDate, SVToDate
    [Form: Account Balance]

    Parts : Bal Main Tital,Bal Main Tital1,Account Report,New Account Report Details
    Button : PrintButton, ExportButton,ChangePeriod
    Space Left : 4 mms
    Space Right : 4 mms
    Height : 100% Page
    Width : 100% Page
    Set Always : SV Print Orientation : "Portrait"
    Bottom Toolbar Buttons : BottomToolBarBtn8,BottomToolBarBtn9,BottomToolBarBtn10
    Page Break : AC ClPageBreak, AC OpPageBreak

    [Part : AC ClPageBreak]
    Line : DSP ContLine
    order : Full Thin Top

    [Part : AC OpPageBreak]
    Parts : Bal Main Tital, Bal Main Tital1, Account Report
    Vertical : Yes
    Space Top : 1 ;;3
    [Part: Bal Main Tital]
    Line : BlTital
    [Line : BlTital]
    Field : BlTital1
    Space Top : 1 mms
    Space Bottom: 1 mms
    [Field :BlTital1]
    Use : Name Field
    Info : ##SVCurrentCompany
    Align : Center
    Width : 100% Screen
    Style : Large
    Align : Center

    [Part: Bal Main Tital1]
    Line : BlTital1
    [Line : BlTital1]
    Field : BlTital2
    Space Top : 3 mms
    Space Bottom: 3 mms

    [Field :BlTital2]
    Use : Name Field
    Set as : "Member Wise Balance Report For The Period "+@@DSPDateStr
    Width : 100% Screen
    Align : Center

    [Part: Account Report]
    Line : Balhead
    Common Borders : Yes
    [Line : Balhead]
    Field : SrNo,memid,memacty,memname,mcds,mshr,mln,mfdr,mrd
    Space Bottom: 0.5 mms
    Space Top : 0.5 mms
    Border : Column Titles
    Space Top : 1.5 mms
    Space Bottom: 1.5 mms

    [Field: SrNo]
    Use : Name Field
    Set as : "Sr.No"
    Border : Thin Left
    Width : 7
    Type : String
    Align : Center
    [Field: memacty]
    Use : Name Field
    Set as : "AcTy"
    Border : Thin Left
    Width : 7
    Type : String
    Align : Center

    [Field: memid]
    Use : Name Field
    Set as : "Memid"
    Border : Thin Left
    Width : 7
    Type : String
    Align : Center

    [Field: memname] ;COST CENTER NAME
    Use : Name Field
    Type : String
    Width : 80
    Border : Thin Left Right
    Align : Center
    Set as : "Member Name"
    [Field: mcds]
    Use : Name Field
    Type : String
    Width : 20
    Border : Thin Left Right
    Align : Center
    Set as : "CDS"

    [Field: mshr]
    Use : Name Field
    Type : String
    Width : 20
    Border : Thin Left Right
    Align : Center
    Set as : "SHARE"
    [Field: mln]
    Use : Name Field
    Type : String
    Width : 20
    Border : Thin Left Right
    Align : Center
    Set as : "LOAN"

    [Field: mfdr]
    Use : Name Field
    Type : String
    Width : 20
    Border : Thin Left Right
    Align : Center
    Set as : "FDR"
    [Field: mrd]
    Use : Name Field
    Type : String
    Width : 20
    Border : Thin Left Right
    Align : Center
    Set as : "RD"
    [Part: New Account Report Details]
    Part: Account Report Details
    Break On : $$IsEmpty:$Memcdx
    [Part: Account Report Details]
    Line : BalDetails,Account Report Total
    Break On : $$IsEmpty:$Memcdx
    Repeat : BalDetails : balbrij
    Common Borders : Yes
    Scroll : Vertical
    Total : Dmcds,Dmshr,Dmln,Dmfdr,Dmrd



    [Line : BalDetails]
    Field : DSrNo,Dmemid,Dmemacty,Dmemname,Dmcds,Dmshr,Dmln,Dmfdr,Dmrd
    Space Bottom: 0.5 mms
    Space Top : 0.5 mms
    Border : Thin Top


    [Field: DSrNo]
    Use : Amount Base Field
    Set as : if $Memcdx=" " then " " else $$Line
    Border : Thin Left Right
    Width : 7
    Type : Number
    Align : Center
    Format : "NoZero"

    [Field: Dmemacty]
    Use : Name Field
    Set as : if $Memcdx=" " then " " else $Mactyx
    Border : Thin Left Right
    Width : 7
    Type : String
    Align : Center

    [Field: Dmemid]
    Use : Name Field
    Set as : if $Memcdx=" " then " " else $Memcdx
    Border : Thin Left Right
    Width : 7
    Type : String
    Align : Center

    [Field: Dmemname] ;COST CENTER NAME
    Use : Name Field
    Type : String
    Width : 80
    Border : Thin Right
    Align : Left
    Set as : if $Memcdx=" " then " " else $Memnmx

    ;---------------------------------------------------------
    [Collection: ALedCC]
    Source Collection : balbrij
    Fetch : LedgerName,Name,ClosingBalance,Dmcds,Dmshr,Dmln,Memcdx,Memnmx,Mactyx
    By : Ledger Name : $Memcdx
    Aggr Compute : Dmcds : sum: if $Mactyx="CDS" then $ClosingBalance else 0
    Aggr Compute : Dmshr : sum: if $Mactyx="SHR" then $ClosingBalance else 0
    Aggr Compute : Dmln : sum: if $Mactyx="LN" then $ClosingBalance else 0
    Aggr Compute : Dmfdr : sum: if $Mactyx="FDR" then $ClosingBalance else 0
    Aggr Compute : Dmrd : sum: if $Mactyx="RD" then $ClosingBalance else 0
    Search Key : $Memcdx+$Memnmx
    ;--------------------------------------------------------------------------
    [Field: Dmcds]
    Use : Amount Base Field
    Type : Amount
    Width : 20
    Border : Thin Right
    Align : Right
    Set as : $$CollectionFieldByKey:$Dmcds:mad:MySearchKey:ALedCC
    MySearchKey : #Dmemid+#Dmemname
    Format : "NoZero,CrDr,Decimal:2,"
    [Field: Dmshr]
    Use : Amount Base Field
    Type : Amount
    Width : 20
    Border : Thin Right
    Align : Right
    Set as : $$CollectionFieldByKey:$Dmshr:mad:MySearchKey:aLedCC
    MySearchKey : #Dmemid+#Dmemname
    Format : "NoZero,CrDr,Decimal:2"

    [Field: Dmln]
    Use : Amount Field
    Type : Amount
    Width : 20
    Border : Thin Right
    Align : Right
    Set as : $$CollectionFieldByKey:$Dmln:mad:MySearchKey:ALedCC
    MySearchKey : #Dmemid+#Dmemname
    Format : "NoZero,Cr,Dr,Decimal:2"
    [Field: Dmfdr]
    Use : Amount Base Field
    Type : Amount
    Width : 20
    Border : Thin Right
    Align : Right
    Set as : $$CollectionFieldByKey:$Dmfdr:mad:MySearchKey:aLedCC
    MySearchKey : #Dmemid+#Dmemname
    Format : "NoZero,CrDr,Decimal:2"

    [Field: Dmrd]
    Use : Amount Base Field
    Type : Amount
    Width : 20
    Border : Thin Right
    Align : Right
    Set as : $$CollectionFieldByKey:$Dmrd:mad:MySearchKey:aLedCC
    MySearchKey : #Dmemid+#Dmemname
    Format : "NoZero,CrDr,Decimal:2"
    ;Format : "Decimal:2"

    ;-------------------------------
    [Line: Account Report Total]
    Field : TDSrNo,TDmemacty,TDmemid,TDmemname,TDmcds,TDmshr,TDmln,TDmfdr,TDmrd
    Space Bottom: 0.5 mms
    Space Top : 0.5 mms
    Border : Totals
    [Field: TDSrNo]
    Use : Amount Base Field
    Set as : " "
    Border : Thin Left Right
    Width : 7
    Type : Amount
    Align : Center
    Format : "NoZero,CrDr"

    [Field: TDmemacty]
    Use : Name Field
    Set as : " "
    Border : Thin Left Right
    Width : 7
    Type : String
    Align : Center

    [Field: TDmemid]
    Use : Name Field
    Set as : " "
    Border : Thin Left Right
    Width : 7
    Type : String
    Align : Center
    [Field: TDmemname]
    Use : Name Field
    Type : String
    Width : 80
    Border : Thin Right
    Align : Center
    Set as : "Total"
    [Field: TDmcds]
    Use : Amount Base Field
    Type : Amount
    Width : 20
    Border : Thin Right
    Align : Right
    Set as : $$Total:Dmcds
    Format : "NoZero,CrDr,Decimal:2"
    [Field: TDmshr]
    Use : Amount Base Field
    Type : Amount
    Width : 20
    Border : Thin Right
    Align : Right
    Set as : $$Total:Dmshr
    Format : "NoZero,CrDr,Decimal:2"
    [Field: TDmln]
    Use : Amount Base Field
    Type : Amount
    Width : 20
    Border : Thin Right
    Align : Right
    Set as : $$Total:Dmln
    Format : "NoZero,CrDr,Decimal:2"
    [Field: TDmfdr]
    Use : Amount Base Field
    Type : Amount
    Width : 20
    Border : Thin Right
    Align : Right
    Set as : $$Total:Dmfdr
    Format : "NoZero,CrDr,Decimal:2"
    [Field: TDmrd]
    Use : Amount Base Field
    Type : Amount
    Width : 20
    Border : Thin Right
    Align : Right
    Set as : $$Total:Dmrd
    Format : "NoZero,CrDr,Decimal:2"
    [Collection: balbrij]
    Type : Ledger
    Fetch : Memcdx,Mactyx,ClossingBalance,Memnmx
    Filter : acbal
    [System:Formula]
    acbal : Not $$IsEmpty:$Memcdx

    ; issamefmrid: $$TgtObject:##Dmemid:$Memcdx
     

    Attached Files:

    brijesh thacker, Aug 16, 2023
    #1


  2. Bipin Damania

    Bipin Damania Active Member


    Check spelling of Closing Balance in collection
     
    Bipin Damania, Aug 17, 2023
    #2


  3. brijesh thacker

    brijesh thacker New Member


    thank u sir
    i am change the spelling but my problem is my report show name in 3 time and balance showing in 3 time
     
    brijesh thacker, Aug 17, 2023
    #3


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    The report is showing 3 times based on the value of 2nd Column named AC TY -- whatever it means ----
     
    Amit Kamdar, Aug 17, 2023
    #4


  5. brijesh thacker

    brijesh thacker New Member


    thank u sir
    acty means account type i was create ledger for member in society like deposit account,share deposit account and loan account etc
     
    brijesh thacker, Aug 17, 2023
    #5


  6. brijesh thacker

    brijesh thacker New Member


    sir
    i want create report base on memid (create by udf in ledger master), i was create verious ledger like deposit acoount ledger, share deposit account ledger and loand account ledger under same member id but all account parent was diffrendt i want create report like srno,memberid,name,show all account balance in one row
     
    brijesh thacker, Aug 17, 2023
    #6


  7. Bipin Damania

    Bipin Damania Active Member


    From your code not possible to check. Only Report is opening but no Data showing as you have added UDF in Ledger.
     
    Last edited: Aug 22, 2023
    Bipin Damania, Aug 19, 2023
    #7


  8. brijesh thacker

    brijesh thacker New Member


    ok sir
     
    brijesh thacker, Aug 22, 2023
    #8


Share This Page