1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Found And Correct the Code

Discussion in 'Free Source Codes' started by udaya, Apr 23, 2020.

    
Tags:
  1. udaya

    udaya Active Member


    [#Line: DBTitle1]
    Add: Right Field: At Beginning: DSP VCHTypeTitle: DSP VCHNarrTitle

    [Field:DSP VCHNarrTitle]
    Set as: "NARRATION'S"

    [#Line: DSP VchDetail]
    Add: Right field: At Beginning: DSP Narration

    [Field: DSP Narration]
    Use: name field
    Set As:$Narration
    width:50
    Border: thin leftright
    Color: Blue
    Style: Normal

    [#Collection : Vouchers of Ledger]
    Fetch:Narration
     
    udaya, Apr 23, 2020
    #1


  2. udaya

    udaya Active Member


    upload_2020-4-23_8-5-51.png
     
    udaya, Apr 23, 2020
    #2


  3. udaya

    udaya Active Member


    Sorry i made Mistake......i Correct the Code and below....
    its working Fine:p:p:p:p:p:p:p:p

    [#Line: DBTitle1]
    Add: Right Field: At Beginning: DSP VCHNarrTitle

    [Field:DSP VCHNarrTitle]
    Set as: "NARRATION'S"
    width:50
    Align: Center
    Border: thin leftright
    Color: Blue
    Style: Bold

    [#Line: DSP VchDetail]
    Add: Right field: At Beginning: DSP Narration

    [Field: DSP Narration]
    Use: name field
    Set As:$Narration
    width:50
    Border: thin leftright
    Color: Blue
    Style: Normal

    [#Collection : Vouchers of Ledger]
    Fetch:Narration
     
    udaya, Apr 23, 2020
    #3


  4. udaya

    udaya Active Member


    The Updated (Added Ref/Date) ..... Enjoy... Friends.....:cool::cool::cool::cool::cool::cool::cool:

    [#Line: DBTitle1]
    Add: Right Field: At Beginning: DSP VCHNarrTitle, BILLCol20

    [Field:DSP VCHNarrTitle]
    Set as: "NARRATION'S"
    width:35
    Align: Center
    Border: thin leftright
    Color: Blue
    Style: Normal Bold

    [#Line: DSP VchDetail]
    Add: Right field: At Beginning: DSP Narration, Refnobb

    [Field: DSP Narration]
    Use: name field
    Set As:$Narration
    width:35
    Border: thin leftright
    Color: Blue
    Style: Normal
    Line : 0

    [#Collection : Vouchers of Ledger]
    Fetch:Narration

    [Field:BILLCol20]

    Set As : "Ref / Date"
    Width : 25
    color : uk1
    Align : center
    Style : Normal Bold
    border : thin right



    [Field:Refnobb]
    Use : Name Field
    Set As : $Reference + " @ " + $$String:$ReferenceDate:ShortDate
    Width : 25
    Align : Center
    Color : uk1
    border : thin right
    Style : Normal
    Border : Thin right

    [#Collection: NRM Vouchers of Company]
    Fetch : Reference, ReferenceDate

    [#Collection : Vouchers of Ledger]
    Fetch : Reference, ReferenceDate

    [Color: uk1]
    RGB : 164, 0, 164
     
    udaya, Apr 23, 2020
    #4


  5. imranlhr

    imranlhr Member


    Sir Data of reference and date not fetch please resolve
     
    imranlhr, Apr 23, 2020
    #5


  6. jgkumar1976

    jgkumar1976 Member


    For reference date. Inaref
     
    jgkumar1976, Apr 23, 2020
    #6


  7. udaya

    udaya Active Member


    Pls.. Goto Display---->Accounts Books------->Sales Register/Purchase register, i will solve sortly on day book.
     
    udaya, Apr 24, 2020
    #7


  8. udaya

    udaya Active Member


    Mr. jgkumar1976 I try the "ref. Date" in Collection it not show purchase voucher display. Can U explain how to get....
    Also I nead fetch MRPrate for Voucher column.... Help Any... pls
     
    udaya, Apr 26, 2020
    #8


  9. udaya

    udaya Active Member


    New Code : Its Working Fine in DB, SalesBook, Purchase Book...... Please Look and help me to get Ref. Date from Purchase voucher..... please Any One.....
    ;; Temporarily i disable the Ref. Date

    [#Line: DBTitle1]
    Add: Right Field: At Beginning: DSP VCHNarrTitle, BILLCol20

    [Field:DSP VCHNarrTitle]
    Set as: "Narration's"
    width:35
    Align: Center
    Border: thin leftright
    Color: Blue
    Style: Normal Bold

    [#Line: DSP VchDetail]
    Add: Right field: At Beginning: DSP Narration, Refnobb

    [Field: DSP Narration]
    Use: name field
    Set As:$Narration
    width:35
    Border: thin leftright
    Color: Blue
    Style: Normal
    Line : 0

    [#Collection : Vouchers of Ledger]
    Fetch:Narration

    [Field:BILLCol20]
    Set As : "Reference"
    Width : 25
    color : uk1
    Align : center
    Style : Normal Bold
    border : thin right

    [Field:Refnobb]
    Use : Name Field
    Set As : $Reference ;+ " // " + $$String:$ReferenceDate:ShortDate
    Width : 25
    Align : Left
    Color : uk1
    border : thin right
    Style : Normal
    Border : Thin right
    Line : 0

    [#Collection: Vouchers of Ledger]
    Fetch : AllLedgerEntries.BankAllocations.INSTRUMENTNUMBER
    Fetch : Reference, ReferenceDate

    [#Collection: Daybook Vouchers of Company]
    Fetch : AllLedgerEntries.BankAllocations.INSTRUMENTNUMBER
    Fetch : Reference, ReferenceDate

    [#Collection : Specific Vouchers of Company]
    Fetch : AllledgerEntries.BankAllocations.INSTRUMENTNUMBER
    Fetch : Reference, ReferenceDate

    [#Collection: Vouchers of Group]
    Fetch : AllLedgerEntries.BankAllocations.INSTRUMENTNUMBER
    Fetch : Reference, ReferenceDate

    [Color: uk1]
    RGB : 164, 0, 164
     
    udaya, Apr 26, 2020
    #9


  10. jgkumar1976

    jgkumar1976 Member


    it is working


    remove Line:0



    [Field:Refnobb]
    Use : Name Field
    Set As : $Reference + " // " + $$String:$ReferenceDate:ShortDate
    Width : 25
    Align : Left
    Color : uk1
    border : thin right
    Style : Normal
    Border : Thin right


    ;Line : 0

    upload_2020-4-26_23-36-23.png
     
    Last edited: Apr 26, 2020
    jgkumar1976, Apr 26, 2020
    #10


  11. jgkumar1976

    jgkumar1976 Member


    Have you tried the above
     
    jgkumar1976, Apr 27, 2020
    #11


  12. dinesh2005

    dinesh2005 New Member


    Can we see report from date to date based on reference date
     
    dinesh2005, Sep 29, 2021
    #12


Share This Page