Need Help For Generating Agreement form

Discussion in 'Requests' started by nasir, Jan 5, 2020.

         
  1. nasir

    nasir Member


    hi respected
    how r u
    i am working in a shopping mall
    here i need to maintain shop agreement in My system
    i am keeping manually now
    can i create a form in tally where i put the detail in fields and from here i can get copy of agreement individually for every shop plzzzz

    kindly help em regarding this


    see the sample file plzzzzzzzzz
     

    Attached Files:



  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Yes you can....

    there is a document linking system tdl available here...you can use that.

    alternatively, you can first make some effort in making the code, experts will help if there is any problems.
     


  3. nasir

    nasir Member


    thanks for reply
    amit bahi i have that code document linking system but i want to explain you i need that type of code where i have a form i put the data in that form and by every party individually crate agreement for each party
     


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    In short you need WORD / NOTEPAD inside tally...is it??
     


  5. love

    love New Member


    try this
    create two reports one to save the required data in udf , next create an agreement report where only the variable data from the previous report is
    fetched thru system formula for eg
    Lluvlymsg : "we the 1st part of this agreement %20"+$$String:mad:@CmpMailName+"%20 and M/s%20"+"+$$String:#Ledgername+%20the second part , get into and agreement 20as%20on%20"+ $$String:$$Machinedate
    you can add as much data as you want

    make the second report printable.

    and connect the two thru a button.
     


  6. nasir

    nasir Member


    actuall y i am not verry well in TDL making ifi have a sample then i can create kindly can u help m,e plzzz
     


  7. nasir

    nasir Member


    Hi love bahi I create a report using udf fields now I want to print all that fields individually for all parties. Can u guide me plzzzzzz
     


  8. nasir

    nasir Member


    I shall be very thankful to all of you plzzz
     


  9. nasir

    nasir Member


    hi respected i got a code and i create as per my requirement now i want to fetch all data on a single sheet like agreement kindly guide me how can i modify this plzzzzzzzzz



    [#Menu: Gateway of Tally]

    Add : Key Item : Agreement : D : Display Collection : LearnWell


    [Collection: LearnWell00]

    Title : "List of Group"
    Type : Group

    Belongs To : Yes
    Variable : GroupName
    Report : Party Details
    Trigger : GSTIN Grp Trigger Rep
    Align : Centre


    [Report : GSTIN Grp Trigger Rep00]

    Use : Collection Variable
    Local : Line : Collection Variable : Add : Field : GSTINCGrpListFld
    Local : Field: MV Title : Info : "GROUPS"

    [Field: GSTINCGrpListFld00]

    Use : Name Field
    Variable : GroupName
    Modifies : GroupName
    Table : LearnWell
    Show Table : Always






    [Report : Party Details00]
    Variable : SVFromDate, SVToDate
    Set : SVfromDate : ##SVToDate


    Set : GroupName : ##GroupName
    Variable : IsMultiPage, InNewPages
    Set : IsMultiPage : yes
    Set : InNewPages : yes
    Set : SVToDate : ##SVCurrentdate
    Form : LearnWellWT

    ;;....www.com...,,

    [Form : LearnWellWT00]
    Page Break : Cl Page Break1, Op Page Break1
    Height : 100% Screen
    Width : 100% Screen
    BackGround : Lily White

    Space Top : If $$InPrintMode Then 0.5 Else 0 inches
    Button : PrintButton, ExportButton,F2 ChangePeriod
    Parts : ONC TitGSTIN,ONCinfoReportGSTIN,Develedbyname
    [Part : ONC TitGSTIN00]

    Space Bottom : 0.2 inch
    Line : ONC Tit LineGSTIN,ONC Tit LineGSTIN1,ONCDateGSTIN,SDOBCNCToDatedLinGSTIN


    [Line : ONC Tit LineGSTIN00]

    Field : ONC Tit FieldGSTIN

    [Field : ONC Tit FieldGSTIN00]

    Use : Name Field
    Set as : $Name:Company:##SVCurrentCompany
    Align : Center
    Full Width : Yes
    Style: TextStyleGSTIN

    [Style: TextStyleGSTIN00]

    Font : Cambria
    Height : 16
    [Line : ONC Tit LineGSTIN11]

    Field : ONC Tit FieldGSTIN11
    [Field : ONC Tit FieldGSTIN11]

    Use : Name Field
    Set as : $Address:Company:##SvCurrentcompany
    Align : Center
    Full Width : Yes
    Border : Thin Box
    Style : TextStyleGSTIN
    Line:2

    [Line : ONCDateGSTIN11]
    Field:Group SDOBNCGSTIN,Group SDOBNCansGSTIN

    Space Bottom :2 mms

    [Field:Group SDOBNCGSTIN00]
    Use:Name Field
    SetAs:"Group Name:"
    Width:25 mms
    Style:Tiny Bold
    Align : Center

    [Field:Group SDOBNCansGSTIN00]
    Use:Name Field
    SetAs:##GroupName
    Width:200 mms
    Style:Tiny Bold




    [Line :SDOBCNCToDatedLinGSTIN00]
    Field : SDOBCNCfrmdateFldGSTIN
    [Field :SDOBCNCfrmdateFldGSTIN00]
    Use:Medium prompt
    Setas :"Detailed Report"
    Width :40 mms
    Style :Tiny Bold
    Align : Center

    Border : Thin Box

    [Part : ONCInfoReportGSTIN00]

    Line : ONCcolumnTitlesGSTIN,ONCInfoGSTIN
    Repeat : ONCInfoGSTIN : MycollectionGSTIN
    Scroll : Both
    Common Border : Yes
    Float : NO
    Border : Thin Box



    [Line : ONCColumnTitlesGSTIN00]

    Border : Column Titles

    Fields :SR,ParticularsGSTIN1,sq1,Pan1,SDGroupNameGSTIN1,Op.Bal.GSTIN1,SDGroupNameGSTIN1,Regtypevaibh1,AA11,Mobile1,AA21,AA41,Outstanding1
    Local : Field : ParticularsGSTIN : Set as : "Particulars"
    Local : Field : ParticularsGSTIN : Line : 0
    Local : Field : Op.Bal.GSTIN : Set as : "Agr Date"
    Local : Field : SDGroupNameGSTIN : Set as : "Opp Date."
    Local : Field : SDGroupNameGSTIN1 : Set as : "Agr Status"
    Local : Field : Regtypevaibh : Set as : "Incrmt Date"
    Local : Field : Pan : Set as : "Br Code."
    Local : Field : Mobile : Set as : "Mobile No"
    Local : Field : AA1 : Set as : "Manager"
    Local : Field : AA2 : Set as : "PTCL"
    Local : Field : AA4 : Set as : "Email"
    Local : Field : sq : Set as : "Sq.Ft"
    Local : Field : Outstanding : Set as : "Outstanding"
    Local : Field : Default : Type : String
    Local : Field : Default : Style : tINY
    Local : Field : Default : Align : Center
    Local : Field : Default : Background : @@SV_UNYELLOW

    [Line : ONCInfoGSTIN00]
    Fields :SR1, ParticularsGSTIN1,sq1,Pan1,SDGroupNameGSTIN11,Op.Bal.GSTIN1,SDGroupNameGSTIN1,Regtypevaibh1,AA11,Mobile1,AA21,AA41,Outstanding1
    Option : AlterOnEnter


    [Field : SR1]
    Use : Short Name Field
    Set as : $$Line
    Width : 02% Screen
    Border : Thin Bottom
    Alter : Ledger
    Style:Tiny
    PRINT bg:lILY wHITE

    [Field : SQ1]
    Use : Short Name Field
    Set as :$LEDID4
    Width : 04% Screen
    Border : Thin Bottom
    Alter : Ledger
    Style: Tiny
    PRINT bg:lILY wHITE





    [Field : ParticularsGSTIN1]
    Use : Name Field
    Set as : $MailingName
    Width : 15% Screen
    Border : Thin Bottom
    Alter : Ledger
    Style:Tiny Bold

    [Field : AA11]
    Use : Name Field
    Set as : $LedgerContact
    Width : 10% Screen
    Border : Thin Bottom
    Alter : Ledger
    Style:Tiny

    [Field : AA211]
    Use : Name Field
    Set as : $Ledgerphone
    Width : 09% Screen
    Border : Thin Bottom
    Alter : Ledger
    Style:Tiny
    [Field : AA411]
    Use : Name Field
    Set as : $Email
    Width : 15% Screen
    Border : Thin Bottom
    Alter : Ledger
    Style:Tiny




    [Field : Op.Bal.GSTIN11]

    Use : Name Field
    Set as :$pincode
    Width : 6% Screen
    Border : Thin Bottom
    Style:Tiny


    [Field : SDGroupNameGSTIN11]
    Set as : $Incometaxnumber
    Width : 6% Screen
    Border : Thin Left
    Border : Thin Bottom
    Style:Tiny





    [Field : SDGroupNameGSTIN111]
    Set as : $DueDateOfPymt
    Width : 05% Screen
    Border : Thin Bottom
    Style:Tiny


    [Field : Regtypevaibh1]

    Set as : $salestaxnumber
    Width : 6% Screen
    Border : Thin Bottom
    Style:Tiny


    [Field : Pan1]
    Set as :$ShipDocumentNo
    Width : 3.50% Screen
    Border : Thin Bottom
    Style:Tiny

    [Field : Mobile1]

    Set as :$LedgerFAX

    Width : 9% Screen
    Style:Tiny
    Border : Thin Bottom

    [Field : Outstanding1]
    Use:Amount Field
    Set as :$ClosingBalance
    Format : "DrCr"
    Style: if $$InPrintMode then "Normal" else "Tiny Bold"
    Color:if $$isDr:$$Value then "Dark Green" Else "Maroon"
    Print fg:if $$isDr:$$Value then "Dark Green" Else "Maroon"
    Width : 8% Screen
    Border : Thin Bottom




    [Part: Develedbyname0]
    Space Bottom : 0.1 inch
    Line: COlTotalsGSTIN
    [Line: COlTotalsGSTIN00]

    Field : ONC Tit FieldGSTIN0
    [Field : ONC Tit FieldGSTIN001]

    Use : Name Field
    Set as : "Nassir"
    Align : Center
    Full Width : Yes
    Border : Thin Box
    Style:Tiny Bold




    [Part: Cl Page Break11]
    Lines : Cont Line1
    [Line: Cont Line11]
    Field: Cont Field1
    Border: Full Thin Top
    [Field: Cont Field11]
    Set As : "Continued........"
    Full width : Yes
    Align : Right



    [Part: Op Page Break11]
    Parts : DSP OpCompanyName, DSP OpReportTitle
    Vertical: Yes


    [Collection : MycollectionGSTIN0]
    Type: Ledger
    Child Of:##GroupName
    Belongs To: Yes



    [Button : Remove LinE0]
    Key : Alt+R
    Action : Remove Line
    Mode : Display




    kindly see screen shot
     

    Attached Files:



  10. nasir

    nasir Member


    kindly see
     


  11. nasir

    nasir Member


    amit bahi
    i have created all udf fiields kindly guide me how i can start sinfle sheet report for every customer individually plzzzzzi want to fetch all these fields thanks
     


  12. nasir

    nasir Member


    how can i make a trigger form
     


  13. love

    love New Member


    make another report where the text part is constant and the variable data is fetched from the udf you created

    we the 1st part of this agreement %20"+$$String:mad:@CmpMailName+"%20 and M/s%20"+"+$$String:#Ledgername+%20the second part , get into and agreement 20as%20on%20"+ $$String:$$Machinedate
     


  14. nasir

    nasir Member


    Bro thnx for reply
    But I gave no knowledfe can u plz start writing then I
    Will get and get
     


Share This Page