DOCUMENT LINKING SYSTEM - DLS

Discussion in 'Free Source Codes' started by SANTHOSH C KURIAN, Jun 25, 2015.

    
  1. Nishant Agrawal

    Nishant Agrawal New Member


    Hello Mr. Kurian

    Its a really helpful TDL, you contribution towards this forum is really creative and new. I just wanted to know whether this TDL could be extended to link the specific files instead file location paths. I mean if we fetch the doument like pdf file or some image, etc should directly be opened through it.

    Awaiting your reply, must not be big challenge for a person of your intelligence.
     


  2. SANTHOSH C KURIAN

    SANTHOSH C KURIAN Active Member


    It is already there, you can open the files attached. Kindly go through the descriptions and screen captures before making a comment.
     



  3. dear sir, its very nice. congrates for your hard success. may be it has my error but thing is DLC.txt allows me to attach file in ledger, purchase & sales voucher creation but it not allow me to attach in receipt, journal or payment creation...can you explain whats wrong i'm doing

    thank you
     


  4. priya

    priya Member


    Mr. Santhosh,

    This year come to a close with your highly innovative TDL. I wonder at your imagination and your determination to make it a reality. Your contributions in this forum is astounding. You have helped many, with your selfless contributions. MAY THE NEW YEAR BRING YOU MORE LAURELS AND HAPPINESS TO YOU AND TO THOSE ALL AROUND YOU. BYE BYE
     


  5. SANTHOSH C KURIAN

    SANTHOSH C KURIAN Active Member


    Thanks a lot and wishing you a very happy new year.
     


  6. SANTHOSH C KURIAN

    SANTHOSH C KURIAN Active Member


    It is working fine in all vouchers, since you never disclosed your scenario in detail I cannot make any comments there on...............
     


  7. Md Hanief Shaik

    Md Hanief Shaik New Member


    Dear Expert,
    Great work, can we send those document attached with invoice by mail then it look much better
     


  8. priyaEaswar

    priyaEaswar Member


    Dear Sir,

    You have to create for ledger master and same am create for voucher master and set the button to view this.

    I have to attach some files in voucher but not view the attached document please guide me.

    ;; ======================= Voucher Type creation entry ===============;;

    [# Part: VTYP BehaviourMain]

    Add: Lines : After : VTYPPrintSave : vtyp amount

    [Line: vtyp amount]

    Field : Long Prompt, amount

    Local : Field : Long Prompt : Info : $$LocaleString:"Set the Amount :"
    Local : Field : Long Prompt : Width : @@LongWidth - 1

    [Field: amount]

    Use : Amount Field
    Storage : Amnt
    Set always : Yes

    [#Field: VCH NrmlRate]

    Control : MyRateControl : $Amnt > $Rate

    [System : Formula]

    MyRateControl : "Rate Control"
    attc : $$ReqObject:Skip:Yes


    ;;================================Color=========================;;

    [Color:DMSPlum]

    RGB:221,160,221

    [Color:DMSLavender]

    RGB:230,230,250

    [Color:DMSAlmond]

    RGB:205,133,63

    ;;================================Vocuher Entry =======================;;

    [#Part: VCH Narration]

    Add : Line : Attc

    [Button : Open File]

    Key : Ctrl + O
    Action : Exec Command: $Fullpath

    [Line: Attc]

    Field: Medium Prompt, Attinfo
    Local: Field: Medium Prompt: Info: "Want to Attach File ? "
    Space Top: 1

    [Field: Attinfo]

    Use :Logical Field
    ;Storage : Enableprenarration
    Set as : If $$IsEmpty:$$Value then "No" else $$Value
    ;Sub Form: Attchdet Rep : $$Value = "Yes"
    Sub Form :DMSLedSF :$$Value = "Yes"
    Storage :DMSLedSF
    ;Set as :No

    [Report : DMSLedSF]

    Form : Attchdet Form

    [Form : Attchdet Form]


    Part : DMSLedPrt
    Height : 55% Page
    Width : 60% Page
    ;;On : Form Accept : CALL : TSPLSmpRefreshFile
    Add : Button : Upload File
    Add : Button : Open File
    Background :DMSPlum

    [Button : Upload File]

    Key : Ctrl + S
    Action : CopyFile : " " : ##Fullpath
    ;; Action : CopyFile : ##MyDstFilePath : ##Fullpath

    [System: UDF]

    Fullpath : String : 11103

    [Field: openfile]

    Use : Name Field
    Set As : "Open"
    Key : Open File
    ;; Skip : Yes
    Color : Black
    Print FG : Pale Leaf Green

    Border : TQ
    Width : 5

    [Border: TQ]

    Top : Thick, Double
    Bottom : Thick, Double
    Left : Thick, Double
    Right : Thick, Double


    [Part : DMSLedPrt]

    Line:DMSLedSFLine
    Repeat:DMSLedSFLine:DMSLedSFAggregate
    Scroll:Vertical
    Break On:$$IsEnd:$DMSLedDescription

    [Line:DMSLedSFLine]
    Fields:DMSLedDescription, DMSLedPath

    [Field:DMSLedDescription]

    Use:Name Field
    Align:Left
    Table:DMSLedTable, End of List
    Show Table:Always
    Storage:DMSLedDescription

    [Field:DMSLedPath]

    Use:Name Field
    Align:Left
    Storage:DMSLedPath
    Inactive:$$IsEnd:$DMSLedDescription

    [System:UDF]

    DMSLedSFAggregate :Aggregate :41021
    DMSLedDescription :String :41022
    DMSLedPath :String :41023
    amnt :Amount :41024

    [Table:DMSLedTable]
    Title:"Documents"
    List: Agreement, Affidavit, Registration Certificate, Circular, Notification, Appeal Letter, PAN, +
    FD Certificate, Other Documents, TAN, IT Docs, Bank Certificates,Logo

    ;; ================= Adding Button in voucher =====================;;

    [# Form: Accounting voucher]

    Add:Button:after : Change Voucher Company: DMSVchButton


    [Button:DMSVchButton]

    Key :Alt + F3
    Title :"View Documents"
    Action :Display :DMSVchReport

    [Report:DMSVchReport]

    ;;Object : Voucher : #SVoucherType
    Form :DMSVchReportForm


    [Form:DMSVchReportForm]

    Part :DMSVchMainTit,DMSVchSubTit, DMSVchHd, DMSVchBdy, DMSVchUser
    Width : 200 MMS
    Height : 100 MMS
    Background : DMSLavender


    [Part:DMSVchMainTit]

    Line :DMSVchMainTitLine
    Background :Leaf Green

    [Line:DMSVchMainTitLine]

    Field :DMSVchMainTitFld
    Space Bottom:1
    Border :Thick Bottom

    [Field:DMSVchMainTitFld]

    Use :Name Field
    Set as :"List of Documents pertaining to Voucher Master"
    Align :Center
    Full Width :Yes
    Color :"Yellow"
    Style :Large Bold

    [Part:DMSVchSubTit]

    ;;ObjectEx :Voucher : #SVoucherType
    Space Top :1
    Line :DMSVchSubTitLn

    [Line:DMSVchSubtitLn]

    Fields :DMSVchSubTitFld
    Space Bottom:1

    [Field:DMSVchSubTitFld]

    Use:Name Field
    Set as:$Name
    Full Width:Yes
    Align:Centre
    Color:"Red"
    Style:Large Bold


    [Part:DMSVchHD]

    Line :DMSVchHdLn, DMSVchTipLine

    [Line:DMSVchHdLn]

    Field :DMSVchHDFld
    Space Top :1

    [Field:DMSVchHdFld]

    Use :Name Field
    Set as :"Documents:-"
    Full Width :No
    Border :Thick Bottom

    [Line:DMSVchTipLine]

    Field :DMSVchTipFld
    Space Bottom:1

    [Field:DMSVchTipFld]

    Use :Name Field
    Set as :"(Press Enter to browse the documents)"
    Full Width :Yes
    Style :DMSVchTipStyle


    [Style:DMSVchTipStyle]

    Font :"Bookman Old Style"
    Italic :Yes
    Height :11

    [Part:DMSVchBdy]

    ; ObjectEx : Voucher : #SVoucherType
    Line :DMSVchBodyLine, DMSVchQuoteLine
    Repeat :DMSVchBodyLine:test;DMSVchCollection
    Scroll :Both
    Background :If $$IsEmpty:#DVchDescription Then "White" Else "DMSAlmond"

    [Collection:test]

    Type :DMSLedSFAggregate :voucherType
    Child Of :##SVVoucherType
    Compute :DMSLedDescription1 :$DMSLedDescription
    Compute :DMSLedPath1 :$DMSLedPath
    Compute :amnt1 :$amnt


    [Collection:DMSLedCollection]

    Type:DMSLedSFAggregate: Voucher
    Format:$DMSLedDescription, 30
    Format:$DMSLedPath, 30

    [Line:DMSVchBodyLine]

    Fields:DMSVchNo, DVchDescription, DVchPath



    [Field:DMSVchNo]
    Use : Number Field
    Set as : $$Line
    Align:Center
    Key:DMSVchEnter
    Invisible: $$IsEmpty:#DVchDescription

    [Field:DVchDescription]
    Use:Name Field
    Set as:$DMSLedDescription1
    Key:DMSVchEnter


    [Field:DVchPath]
    Use:Name Field
    Set as:$DMSLedPath1
    Invisible:Yes

    [Key:DMSVchEnter]

    Key:Enter
    Action:Browse Url:$DMSLedPath1

    [Collection:DMSVchCollection]

    Type:DMSVchSFAggregate:Vouchertype ; : #SVoucherType
    Format:$DMSVchDescription, 30
    Format:$DMSVchPath, 30

    [Line:DMSVchQuoteLine]
    Invisible:Not $$IsEmpty:#DVchDescription
    Field:DMSVchQtFld

    [Field:DMSVchQtFld]
    Use:Name Field
    Set as:"NO DOCUMENTS IN SUPPORT"
    Width:90
    Align:Centre
    Style:Large Bold
    Color:"Blue"

    [Part:DMSVchUser]
    ObjectEx : Voucher : #SVoucherType
    Line:DMSVchUserLn
    Space Top:1
    Background:Red

    [Line:DMSVchUserLn]
    Field:DMSVchUserFld

    [Field:DMSVchUserFld]
    Use:Name Field
    Set as:"This Ledger is created by: " + $CrDtTm1
    Full Width:Yes
    Align: Center
    Color:"Yellow"
    Style:DMSVchTipStyle
     


  9. priyaEaswar

    priyaEaswar Member


    Dear Experts,

    Please help me.
     


  10. priyaEaswar

    priyaEaswar Member


    Dear Admin

    Please help me i need immediately.
     


  11. priyaEaswar

    priyaEaswar Member


    Dear Experts,

    Can anybody help me i need immediately.
     


  12. praveenkumarsaxena

    praveenkumarsaxena New Member


    how to merge two ledger in tally erp 9 (4.9)

    9039205150
     


  13. sohel

    sohel New Member


    I appreciate your effort. Really its very amazing code and very helpful. Currently it is working to attached file in Contra, Journal, Payment and Receipt Voucher. if I want to do the same for sales, purchase, debit note, credit note what procedure have to be made? Let me know pls to : Sohel@ebit-group.com
     


  14. saif

    saif New Member


    Thanks a lot SANTHOSH C KURIAN Sir for DLC TDL.
     


  15. kmuralica

    kmuralica New Member



    Dear Santhosh Sir,

    In your attachments there is no TDL Code!!!???

    Can you please share it?
     


  16. Chirag Shah

    Chirag Shah New Member



    Dear Mr. Santosh,

    I could not find TXT file.

    Please share.

    Thanks in anticipation.

    regards
    Chirag
     





  17. FILE IS ATTACHED SANTOSH JI BUT CAN'T ACCESS OR DISPLAYED ATTACHED DOCUMENTS.
     
    Jay kumar tailor likes this.


  18. sayed

    sayed Member


    i hope to help me i want code to hide rate and amount to user in voucher and report
    and i want tacking number in dilvery note without not applicable
    plss help me
     


  19. Ajay Babbar

    Ajay Babbar New Member


    Sirji
    I am new to this community and want this tdl file of urs.
    Can anyone plz tell me
    Which file i have to download
    Where is that attachment
    How to link to tally erp9
     


  20. Ajay Babbar

    Ajay Babbar New Member


    Thnx in advance
     


  21. neel

    neel New Member


    Where Is Source Code File?
     


  22. Manzer Masood

    Manzer Masood New Member


    Sir,
    Great work ... i am just new and want to work on this assignment for document linking; currently i have seen all attachments which are .jpg ...
    can you please attache TDL file? or manzermasood@gmail.com
     


  23. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    File attached
     

    Attached Files:

    Manzer Masood likes this.


  24. Manzer Masood

    Manzer Masood New Member


    Bundle of thanks for source code file ....
    i have made some changes and made according to my understanding ....
    Once again many many thanks Sr.Taufeeq Shaikh
     

    Attached Files:

    • 0.jpg
      0.jpg
      File size:
      187.1 KB
      Views:
      450
    • 1.jpg
      1.jpg
      File size:
      203.2 KB
      Views:
      447
    • 2.jpg
      2.jpg
      File size:
      184.9 KB
      Views:
      430
    • 3.jpg
      3.jpg
      File size:
      258.7 KB
      Views:
      441
    • filatt.txt
      File size:
      2.1 KB
      Views:
      454
    Taufeeq Shaikh likes this.


Share This Page