1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Tenant profile

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

    
Page 2 of 2
  1. NainaSiraj

    NainaSiraj Member


    dear mr gangste i have make soem changes as per i need but i cant fetch data from UDF fields From Tally Ledger Master
    kindly see






    [#Menu:Gateway of Tally]
    Add:Button:Rent Aggr
    ;Add:Key Item:Rent Agreement:R:Display Collection:SJGroupColl:NOT $$IsEmpty:$$SelectedCmps

    [Button:Rent Aggr]
    Title:"Rent Aggrement"
    Key:ALT + V
    Action:Display Collection:SJGroupColl

    [Collection:SJGroupColl]
    Use:Remote My Ledger Coll
    Delete:Report
    Add:Report:SJGroup

    [Collection:Remote My Ledger Coll]
    Use:Alias Collection
    Type:Ledger
    Variable:LedgerName
    Trigger:Remote Triggered Led Report
    Report:Remote Final Led Report
    Fetch:Name
    Filter:SundryDebrs

    [Report:Remote Triggered Led Report]
    Title:"Select Ledger"
    Form:Remote Triggered Led Report
    Variable:SVFromDate, SVToDate
    Variable:DSPShowOpening, DSPShowClosing

    [Form:Remote Triggered Led Report]
    Parts:Remote Triggered Led Report

    [Part:Remote Triggered Led Report]
    Lines:Remote Triggered Led Report

    [Line:Remote Triggered Led Report]
    Fields:Medium Prompt, Remote Triggered Led Report
    Local:Field:Medium Prompt:Set as:"Ledger :"

    [Field:Remote Triggered Led Report]
    Use:Name Field
    Table:Remote My Ledger Coll
    Show Table:Always
    Modifies:LedgerName
    ;Inactive:NOT $$IsBelongsTo:$$GroupSundryDebtors

    [System:Formulae]
    SundryDebrs:$$IsBelongsTo:$$GroupSundryDebtors

    [Report:SJGroup]
    Form:SJGroup
    Object:vOUCHER:##vOUCHERID
    Title:"SJ Group of Company"
    Print Set:REPORT TITLE:"SJ Group of Co.,"
    Fetch Object:Ledger:#LedgerName:Name, LedgerContact, LedgerPhone, OpeningBalance, LedOpeningBalance, TBalOpening,LEDID4

    [Form:SJGroup]
    Top Part:SJGroupTop
    Space Top:0.35 INCH
    Space Left:0.55 INCH
    Space Right:0.45 INCH
    Space Bottom:0.10 INCH

    [Part:SJGroupTop]
    Part:SJGroupTopCmp,SJGroupTopCmpTit;,SJGroupTopAggTit,SJGroupTopCaFTit,SJGroupTopSignTit
    Vertical:Yes

    [Part:SJGroupTopCmp]
    Line:SJGroupTopCmp,SJGroupTopCAdd,SJGroupTopCEMN

    [Line:SJGroupTopCmp]
    Field:Name Field
    Local:Field:Name Field:Set as:SJ GRoup (Naina)
    Local:Field:Name Field:Full Width:Yes
    Local:Field:Name Field:Align:Center
    Local:Field:Name Field:Style:Large Bold
    Local:Field:Name Field:Border:Thin Bottom
    Local:Field:Name Field:print FG:Blue

    [Line:SJGroupTopCAdd]
    Field:Name Field
    Local:Field:Name Field:Set as:$$FullList:SJCompanyaddress:$Address
    Local:Field:Name Field:Full Width:Yes
    Local:Field:Name Field:Align:lEFT
    Local:Field:Name Field:sTYLE:nORMAL




    [Collection:SJCompanyaddress]
    Type:Address:Company
    Child Of:##SVCurrentCompany
    Filter:IsNotBlankAddr

    [Line:SJGroupTopCEMN]
    Space Top:0.25
    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



    [Part:SJGroupTopCmpTit]
    Line:SJGroupTopCmpTit,SJGroupTopCmpTFDet,SJGroupTopCmpTFDet00,SJGroupTopCmpTFDet01

    [Line:SJGroupTopCmpTit]
    Field:Name Field
    Border:Thin Box
    Local:Field:Name Field:Set as:"Shop & other Detail"
    Local:Field:Name Field:Full Width:Yes
    Local:Field:Name Field:Align:Center
    Local:Field:Name Field:print BG:Green

    [Line:SJGroupTopCmpTFDet]
    Left Fields:Name Field, SJGroupStart
    Right Fields:Short Name Field, SJGroupShNo
    Border:Thin Box
    Local:Field:Name Field:Set as:"Rent Start"
    Local:Field:Name Field:Full Width:no
    Local:Field:Name Field:Align:Left
    Local:Field:Name Field:Border:Thin Box

    Local:Field:Short Name Field:Set as:"Shop No"
    Local:Field:Short Name Field:Full Width:no
    Local:Field:Short Name Field:Align:Left
    Local:Field:Short Name Field:Border:Thin Box

    [Field:SJGroupStart]
    Use:Name Field
    Set as:$LEDID4
    Align:Right
    Full Width:Yes

    [Field:SJGroupShNo]
    Use:Name Field
    Set as:$LedgerPhone:Ledger:#LedgerName
    Align:Right
    Full Width:Yes






    [Line:SJGroupTopCmpTFDet00]
    Left Fields:Name Field, SJGroupStart
    Right Fields:Short Name Field, SJGroupShNo
    Border:Thin Box
    Local:Field:Name Field:Set as:"Markeet nom"
    Local:Field:Name Field:Full Width:no
    Local:Field:Name Field:Align:Left
    Local:Field:Name Field:Border:Thin Box

    Local:Field:Short Name Field:Set as:"agreement Date"
    Local:Field:Short Name Field:Full Width:no
    Local:Field:Short Name Field:Align:Left
    Local:Field:Short Name Field:Border:Thin Box

    [Field:SJGroupStart00]
    Use:Name Field
    Set as:$LedgerMobile:Ledger:#LedgerName
    Align:Right
    Full Width:Yes

    [Field:SJGroupShNo00]
    Use:Name Field
    Set as :$LEDID4:Ledger:$PartyLedgername
    Align:Right
    Full Width:Yes




    [Line:SJGroupTopCmpTFDet01]
    Left Fields:Name Field, SJGroupStart
    Right Fields:Short Name Field, SJGroupShNo
    Border:Thin Box
    Local:Field:Name Field:Set as:"Are Sqft"
    Local:Field:Name Field:Full Width:no
    Local:Field:Name Field:Align:Left
    Local:Field:Name Field:Border:Thin Box

    Local:Field:Short Name Field:Set as:"Mk Area"
    Local:Field:Short Name Field:Full Width:no
    Local:Field:Short Name Field:Align:Left
    Local:Field:Short Name Field:Border:Thin Box

    [Field:SJGroupStart01]
    Use:Name Field
    Set as:$LedgerFax:Ledger:##LedgerName
    Align:Right
    Full Width:Yes

    [Field:SJGroupShNo01]
    Use:Name Field
    Set as :$LEDID4:Ledger:$PartyLedgername see this fields UDF not fetching
    Align:Right
    Full Width:Yes
     
    NainaSiraj, Apr 14, 2020
    #26


  2. NainaSiraj

    NainaSiraj Member


    i try this also but not geeting


    Set as :$LEDID4:Ledger:##Ledgername
     
    NainaSiraj, Apr 14, 2020
    #27


  3. NainaSiraj

    NainaSiraj Member


    this fields a add kindly see need udf deta fetch
     

    Attached Files:

    NainaSiraj, Apr 14, 2020
    #28


  4. NainaSiraj

    NainaSiraj Member


    also need to change form style

    i want to add fields in front of fields
    suppose
    rent start 1 1 20 , rent start 20000, opp date 1 1 20
    like this
    currently i am able to show 2 fields i need four fields and data thanks
     
    NainaSiraj, Apr 14, 2020
    #29


  5. NainaSiraj

    NainaSiraj Member


    and i wan to add print option in this kindly please
     
    NainaSiraj, Apr 15, 2020
    #30


  6. NainaSiraj

    NainaSiraj Member


    i am doing with the help of mr gangster i dont know where is he from last 2 days
    thank u
    in this code i have to get data from udf fields
    kindly see the red syntax

    and in front of tenant ledger i want to add a title "Agreement detail"
    kindly help and know i am able to create 2 fields in 1 row i need 5 fields in a row
    and this form should be printable thanks
    kindly see screen shoot





    [#Menu:Gateway of Tally]
    Add:Button:Rent Aggr
    ;Add:Key Item:Rent Agreement:R:Display Collection:SJGroupColl:NOT $$IsEmpty:$$SelectedCmps

    [Button:Rent Aggr]
    Title:"Aggrement"
    Key:ALT + V
    Action:Display Collection:SJGroupColl

    [Collection:SJGroupColl]
    Use:Remote My Ledger Coll
    Delete:Report
    Add:Report:SJGroup

    [Collection:Remote My Ledger Coll]
    Use:Alias Collection
    Type:Ledger
    Variable:LedgerName
    Trigger:Remote Triggered Led Report
    Report:Remote Final Led Report
    Fetch:Name
    Filter:SundryDebrs

    [Report:Remote Triggered Led Report]
    Title:"Select Ledger"
    Form:Remote Triggered Led Report
    Variable:SVFromDate, SVToDate
    Variable:DSPShowOpening, DSPShowClosing

    [Form:Remote Triggered Led Report]
    Parts:Remote Triggered Led Report

    [Part:Remote Triggered Led Report]
    Lines:Remote Triggered Led Report

    [Line:Remote Triggered Led Report]
    Fields:Medium Prompt, Remote Triggered Led Report
    Local:Field:Medium Prompt:Set as:"Ledger :"

    [Field:Remote Triggered Led Report]
    Use:Name Field
    Table:Remote My Ledger Coll
    Show Table:Always
    Modifies:LedgerName
    ;Inactive:NOT $$IsBelongsTo:$$GroupSundryDebtors

    [System:Formulae]
    SundryDebrs:$$IsBelongsTo:$$GroupSundryDebtors

    [Report:SJGroup]
    Form:SJGroup
    Object:vOUCHER:##vOUCHERID
    Title:"SJ Group of Company"
    Print Set:REPORT TITLE:"SJ Group of Co.,"
    Fetch Object:Ledger:#LedgerName:Name, LedgerContact, LedgerPhone, Ledgerfax,LedgerNotes, LedOpeningBalance, TBalOpening,UDF

    [Form:SJGroup]
    Top Part:SJGroupTop
    Space Top:0.2 INCH
    Space Left:0.55 INCH
    Space Right:0.45 INCH
    Space Bottom:0.10 INCH

    [Part:SJGroupTop]
    Part:SJGroupTopCmp,SJGroupTopCmpTit;SJGroupTopCmpTit02,SJGroupTopAggTit,SJGroupTopCaFTit,SJGroupTopSignTit
    Vertical:Yes

    [Part:SJGroupTopCmp]
    Line:SJGroupTopCmp,SJGroupTopCAdd,SJGroupTopCEMN,SJGroupTopCEMN1,SJGroupTopCEMN2

    [Line:SJGroupTopCmp]
    Field:Name Field
    Local:Field:Name Field:Set as:SJ GRoup (Naina)
    Local:Field:Name Field:Full Width:Yes
    Local:Field:Name Field:Align:Center
    Local:Field:Name Field:Style:Large Bold
    Local:Field:Name Field:Border:Thin Bottom
    Local:Field:Name Field:print FG:Blue

    [Line:SJGroupTopCAdd]
    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



    [Collection:SJCompanyaddress]
    Type:Address:Company
    Child Of:##SVCurrentCompany
    Filter:IsNotBlankAddr

    [Line:SJGroupTopCEMN]
    Space Top:0.25
    Field:Name Field,Short Name Field
    Local:Field:Name Field:Set as:"Email:-" + $Email:Company:##SVCurrentCompany
    Local:Field:Name Field:Full Width:no
    Local:Field:Name Field:Align:cENTER
    Local:Field:Name Field:sTYLE:nORMAL
    local:Field:Name Field:cOLOR:blue
    local:Field:Name Field:Space Left:57

    [Line:SJGroupTopCEMN1]
    Space Bottom:0.20
    Field:Name Field,Short Name Field
    Local:Field:Name Field:Set as:$MailingName:Ledger:#LedgerName
    Local:Field:Name Field:Full Width:yes
    Local:Field:Name Field:Align:LEFT
    Local:Field:Name Field:sTYLE:nORMAL Bold
    local:Field:Name Field:print FG:blue


    [Line:SJGroupTopCEMN2]
    Space Bottom:3
    Field:Name Field,Short Name Field
    Local:Field:Name Field:Set as:$nARRATION:Ledger:#LedgerName
    Local:Field:Name Field:Full Width:yes
    Local:Field:Name Field:Align:LEFT
    Local:Field:Name Field:sTYLE:nORMAL
    local:Field:Name Field:print FG:blue
    local:Field:Name Field:LINES:3








    [Part:SJGroupTopCmpTit]
    Line:SJGroupTopCmpTit,SJGroupTopCmpTFDet,SJGroupTopCmpTFDet0,SJGroupTopCmpTFDet1,SJGroupTopCmpTit2,SJGroupTopCmpTFDet2,SJGroupTopCmpTFDet3,SJGroupTopCmpTFDet4,SJGroupTopCmpTFDet5,SJGroupTopCmpTFDet6

    [Line:SJGroupTopCmpTit]
    Field:Name Field
    Border:Thin Box
    Local:Field:Name Field:Set as:"Shop & other Detail"
    Local:Field:Name Field:Full Width:Yes
    Local:Field:Name Field:Align:Center
    Local:Field:Name Field:Color:REd

    [Line:SJGroupTopCmpTFDet]
    Left Fields:Name Field, SJGroupStart
    Right Fields:Short Name Field, SJGroupShNo
    Border:Thin Box
    Local:Field:Name Field:Set as:"Rent Start"
    Local:Field:Name Field:Full Width:YES
    Local:Field:Name Field:Align:Left
    Local:Field:Name Field:Border:Thin Box
    ocal:Field:Name Field:print BG:Black


    Local:Field:Short Name Field:Set as:"Shop No"
    Local:Field:Short Name Field:Full Width:YES
    Local:Field:Short Name Field:Align:Left
    Local:Field:Short Name Field:Border:Thin Box

    [Field:SJGroupStart]
    Use:Name Field
    Set as:$ledgerfax:Ledger:#LedgerName
    Align:Right
    Full Width:Yes

    [Field:SJGroupShNo]
    Use:Name Field
    Set as:$Ledgerphone:Ledger:#LedgerName
    Align:Right
    Full Width:Yes


    [Line:SJGroupTopCmpTFDet0]
    Left Fields:Name Field, SJGroupStart0
    Right Fields:Short Name Field, SJGroupShNo0
    Border:Thin Box
    Local:Field:Name Field:Set as:"Rent Start"
    Local:Field:Name Field:Full Width:YES
    Local:Field:Name Field:Align:Left
    Local:Field:Name Field:Border:Thin Box

    Local:Field:Short Name Field:Set as:"Shop No"
    Local:Field:Short Name Field:Full Width:YES
    Local:Field:Short Name Field:Align:Left
    Local:Field:Short Name Field:Border:Thin Box

    [Field:SJGroupStart0]
    Use:short Name Field
    Set as :
    Align:Right
    Full Width:Yes

    [Field:SJGroupShNo0]
    Use:Name Field
    Set as:
    Align:Right
    Full Width:Yes




    [Line:SJGroupTopCmpTFDet1]
    Left Fields:Name Field, SJGroupStart1
    Right Fields:Short Name Field, SJGroupShNo1
    Border:Thin Box
    Local:Field:Name Field:Set as:"Rent Start"
    Local:Field:Name Field:Full Width:YES
    Local:Field:Name Field:Align:Left
    Local:Field:Name Field:Border:Thin Box

    Local:Field:Short Name Field:Set as:"Shop No"
    Local:Field:Short Name Field:Full Width:YES
    Local:Field:Short Name Field:Align:Left
    Local:Field:Short Name Field:Border:Thin Box

    [Field:SJGroupStart1]
    Use:Name Field
    Set as:
    Align:Right
    Full Width:Yes

    [Field:SJGroupShNo1]
    Use:Name Field
    Set as:
    Align:Right
    Full Width:Yes



    [Line:SJGroupTopCmpTit2]
    Field:Name Field
    Border:Thin Box
    Local:Field:Name Field:Set as:"Electricity Detail"
    Local:Field:Name Field:Full Width:Yes
    Local:Field:Name Field:Align:Center
    Local:Field:Name Field:print BG:Green

    [Line:SJGroupTopCmpTFDet2]
    Left Fields:Name Field, SJGroupStart2
    Right Fields:Short Name Field, SJGroupShNo2
    Border:Thin Box
    Local:Field:Name Field:Set as:"Rent Start"
    Local:Field:Name Field:Full Width:YES
    Local:Field:Name Field:Align:Left
    Local:Field:Name Field:Border:Thin Box

    Local:Field:Short Name Field:Set as:"Shop No"
    Local:Field:Short Name Field:Full Width:YES
    Local:Field:Short Name Field:Align:Left
    Local:Field:Short Name Field:Border:Thin Box

    [Field:SJGroupStart2]
    Use:Name Field
    Set as:
    Align:Right
    Full Width:Yes

    [Field:SJGroupShNo2]
    Use:Name Field
    Set as:
    Align:Right
    Full Width:Yes




    [Line:SJGroupTopCmpTFDet3]
    Left Fields:Name Field, SJGroupStart3
    Right Fields:Short Name Field, SJGroupShNo3

    Border:Thin Box
    Local:Field:Name Field:Set as:"Rent Start"
    Local:Field:Name Field:Full Width:YES
    Local:Field:Name Field:Align:Left
    Local:Field:Name Field:Border:Thin Box

    Local:Field:Short Name Field:Set as:"Shop No"
    Local:Field:Short Name Field:Full Width:YES
    Local:Field:Short Name Field:Align:Left
    Local:Field:Short Name Field:Border:Thin Box

    [Field:SJGroupStart3]
    Use:Name Field
    Set as:
    Align:Right
    Full Width:Yes

    [Field:SJGroupShNo3]
    Use:Name Field
    Set as:
    Align:Right
    Full Width:Yes

    [Line:SJGroupTopCmpTFDet4]
    Left Fields:Name Field, SJGroupStart4
    Right Fields:Short Name Field, SJGroupShNo4

    Border:Thin Box
    Local:Field:Name Field:Set as:"Rent Start"
    Local:Field:Name Field:Full Width:YES
    Local:Field:Name Field:Align:Left
    Local:Field:Name Field:Border:Thin Box

    Local:Field:Short Name Field:Set as:"Shop No"
    Local:Field:Short Name Field:Full Width:YES
    Local:Field:Short Name Field:Align:Left
    Local:Field:Short Name Field:Border:Thin Box

    [Field:SJGroupStart4]
    Use:Name Field
    Set as:
    Align:Right
    Full Width:Yes

    [Field:SJGroupShNo4]
    Use:Name Field
    Set as:
    Align:Right
    Full Width:Yes




    [Line:SJGroupTopCmpTFDet5]
    Left Fields:Name Field, SJGroupStart5
    Right Fields:Short Name Field, SJGroupShNo5

    Border:Thin Box
    Local:Field:Name Field:Set as:"Rent Start"
    Local:Field:Name Field:Full Width:YES
    Local:Field:Name Field:Align:Left
    Local:Field:Name Field:Border:Thin Box

    Local:Field:Short Name Field:Set as:"Shop No"
    Local:Field:Short Name Field:Full Width:YES
    Local:Field:Short Name Field:Align:Left
    Local:Field:Short Name Field:Border:Thin Box

    [Field:SJGroupStart5]
    Use:Name Field
    Set as:
    Align:Right
    Full Width:Yes

    [Field:SJGroupShNo5]
    Use:Name Field
    Set as:
    Align:Right
    Full Width:Yes


    [Line:SJGroupTopCmpTFDet6]
    Left Fields:Name Field, SJGroupStart6
    Right Fields:Short Name Field, SJGroupShNo5
    Left Fields:Name Field,SJJJ6
    Right Fields:Short Name Field,SJJ6

    Border:Thin Box
    Local:Field:Name Field:Set as:"Rent Start"
    Local:Field:Name Field:Full Width:YES
    Local:Field:Name Field:Align:Left
    Local:Field:Name Field:Border:Thin Box

    Local:Field:Short Name Field:Set as:"Shop No"
    Local:Field:Short Name Field:Full Width:YES
    Local:Field:Short Name Field:Align:Left
    Local:Field:Short Name Field:Border:Thin Box

    [Field:SJGroupStart6]
    Use:Name Field
    Set as:
    Align:Right
    Full Width:Yes

    [Field:SJGroupShNo6]
    Use:Name Field
    Set as:
    Align:Right
    Full Width:Yes

    [Field:SJJJ6]
    Use:Name Field
    Set as:
    Align:Right
    Full Width:Yes

    [Field:SJJ6]
    Use:Name Field
    Set as:
    Align:Right
    Full Width:Yes
     

    Attached Files:

    NainaSiraj, Apr 15, 2020
    #31


  7. gangstar

    gangstar Member


    If u have any other changes in this tdl means kindly alter or upgrade in high level.

    Thanking You,

    Gangstar
     

    Attached Files:

    gangstar, Apr 15, 2020
    #32
    NainaSiraj likes this.


  8. NainaSiraj

    NainaSiraj Member


    grate mr Gangster thanks dear thanks u very much i will change as per my request adn will inform you
    God Bless u
     
    NainaSiraj, Apr 16, 2020
    #33
    nasir likes this.


  9. nasir

    nasir Member


    Pleas help me for this

    Total invoice 100000
    +vat 10%. 10000
    Net invoice. 110000
     
    nasir, Apr 16, 2020
    #34


  10. NainaSiraj

    NainaSiraj Member


    not have idea
    i will request my best sir mr gangster to help this
    just wait shortly thanks
     
    NainaSiraj, Apr 17, 2020
    #35


  11. NainaSiraj

    NainaSiraj Member


    good morning mr gangster
     
    NainaSiraj, Apr 18, 2020
    #36


  12. Bipin Damania

    Bipin Damania Active Member


    Hello,

    From where this Report is to Open in Tally ?

    Please reply
     
    Bipin Damania, Apr 18, 2020
    #37


  13. NainaSiraj

    NainaSiraj Member


    hi
    reapcted sir u can find BUTTON ON Gateway of Tally "AGREEMENT"
    just click and see
    thanks
     
    NainaSiraj, Apr 18, 2020
    #38


  14. Bipin Damania

    Bipin Damania Active Member


    But from where to get UDF & their Value ?
     
    Bipin Damania, Apr 18, 2020
    #39


  15. Bipin Damania

    Bipin Damania Active Member


    Yes
    Got it
    But there is no Value ?
     
    Bipin Damania, Apr 21, 2020
    #40


  16. NainaSiraj

    NainaSiraj Member


    sorry sir
    my code is working why your not?
     
    NainaSiraj, Apr 21, 2020
    #41


Page 2 of 2

Share This Page