Need help to fetch empty document link in daybook report

Discussion in 'Tally & TDL Learning HUB' started by Anthony dinakaran, Feb 26, 2025.

  1. Anthony dinakaran

    Anthony dinakaran New Member


    ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; DOCUMENT ATTACHMENT ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
    [#Part: VCH Narration]
    Add : Switch : BankDetRcpt : BankDet VCH Narration

    [!Part: BankDet VCH Narration]
    Add : Line : HyperlinkCompany

    [Line: HyperlinkCompany]
    Fields : Short Prompt, HyperlinkCompany
    Local : Field : Short Prompt : Info: $$LocaleString:"Linked Doc."

    [#Form: Sales Color]
    Add :Top Button :Open Attachment
    [#Form: Contra Color]
    Add :Button :Open Attachment
    [#Form: Payment Color]
    Add :Button :Open Attachment
    [#Form: Receipt Color]
    Add :Button :Open Attachment
    [#Form: Journal Color]
    Add :Button :Open Attachment
    [#Form: Payroll Color]
    Add :Button :Open Attachment
    [#Form: Debit Note Color]
    Add :Button :Open Attachment
    [#Form: Credit Note Color]
    Add :Button :Open Attachment
    [#Form: Purchase Color]
    Add :Button :Open Attachment
    [#Form: Memorandum Color]
    Add :Button :Open Attachment
    [#Form: Reversing Journal Color]
    Add :Button :Open Attachment
    [#Form: Stock Journal Color]
    Add :Button :Open Attachment
    [#Form: Delivery Note Color]
    Add :Button :Open Attachment
    [#Form: Receipt Note Color]
    Add :Button :Open Attachment
    [#Form: Rejection Inward Color]
    Add :Button :Open Attachment
    [#Form: Rejection Outward Color]
    Add :Button :Open Attachment
    [#Form: Physical Stock Color]
    Add :Button :Open Attachment
    [#Form: Sales Order Color]
    Add :Button :Open Attachment
    [#Form: Purc Order Color]
    Add :Button :Open Attachment
    [#Form: Attendance Color]
    Add :Button :Open Attachment
    [#Form: JobOrderIn Color]
    Add :Button :Open Attachment
    [#Form: JobOrderOut Color]
    Add :Button :Open Attachment

    [Button : Open Attachment]
    Title : $$LocaleString:"Open Attachment"
    Key : Ctrl + Q
    Action :Browse Url Ex : #HyperlinkCompany

    [Button : Edit Attachment]
    Title : $$LocaleString:"Edit Attachment"
    Key : Ctrl + Z
    Action : HyperlinkCompany


    [Field: HyperlinkCompany]
    Use : Name Field
    Color : Blue
    Key : Execute Hyperlink1
    Storage : hyper1
    Local : Key : Execute Hyperlink1 : Action :Browse Url Ex: "D:\ANTHONY\" + $VoucherTypeName +"\"+ ##hyper1
    Fullwidth : Yes

    [System: UDF]
    hyper1 : String : 1101


    ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; BUYER NAME_DOC LINK Y/N IN DAYBOOK ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

    [#Line: DBTitle1]
    Add : Left Field : After : DSP VchdateTitle : Dina, DocLogic
    Add : Left Field : Before : DSP VchdateTitle : karan

    [Field: Dina]
    Use : Name Field
    Set as: "BUYERS NAME"
    Width : 13
    Align : Left
    Border:Thin Left Right

    [Field: DocLogic]
    Use : Name Field
    Set as: "Doc YN"
    Width : 5
    Align : Left
    Border:Thin Left Right

    [Field: karan]
    Use : Name Field
    Set as: "Sr No"
    Style : thin
    Width : 4
    Align : Left
    Border:Thin Left Right

    [#Line: DSP VchDybkDetail] ;
    Add : Left Field:Before:DSP VchDate:Dinakaran
    Add : Left Field:After :DSP VchDate:Anthony,DocCheck
    Border: Thin Cover

    [Field: Dinakaran]
    Type : Number
    Set as: $$Line
    Style : Normal
    Width : 4
    Color : black
    Border:Thin Left Right

    [Field: Anthony]
    USE : Name Field
    Set As: If $$IsSysName:$PartyName Then $BasicBuyerName Else $PARTYNAME
    Style : Normal Bold
    Width : 13
    Color : Blue
    Border:Thin Left Right

    [Field: DocCheck]
    USE : Name Field
    Set As: If $$IsEmpty:$hyper1 Then "N" Else ""
    Align : Centre
    Style : Normal Bold
    Width : 5
    Color : Blue
    Border:Thin Left Right



    [Collection: Anthony]
    Fetch : Date, VoucherNumber, VoucherTypeName, PartyName
    Fetch : BasicBuyerName
     
    Last edited: Feb 26, 2025


Share This Page