Need Help to retrieve the udf value in ledger vouchers report

Discussion in 'Requests' started by mutharasan, Apr 30, 2014.

    
  1. mutharasan

    mutharasan Member


    Dear All TDL Experts,

    Greetings,

    I have created one UDF in Voucher Narration Part. I want to retrieve this UDF in Ledger Vouchers Report (Ledger Report). I tried with following code, but it is not working. I have attached the screen shot also. please help me.

    Thanking You,

    [#part : VchNarration]
    Line : testline

    [Line : testline]
    Field : test Field

    [Field : test Field]
    use : Name Field
    storage : Monthyear
    width : 20 MMs

    [system : UDF]
    Monthyear:string:1222

    [#Line: DSP VchAccTitles]
    Add:LeftField:After:DSP VchAcctTitle:myledgerfldd

    [Field : myledgerfldd]
    set As : "Rent Month And Year"
    Width : 30% Page
    Align : Center


    [#Line: DSP VchDetail]
    Add:Right Field : Before : DSP VchType:myledvchyear

    [Field : myledvchyear]
    Use : Name Field
    Width : 30% Page
    Set As :$Monthyear
    Align : Center

    [#Collection: Ledger Vouchers Coll]
    fetch : Monthyear
     

    Attached Files:



  2. D Lokesh

    D Lokesh Member




    hi ..


    try this Collection instead of your collection

    [#Collection: Vouchers of Ledger]
    fetch : Monthyear
     
    mutharasan and Raju Das like this.


  3. mutharasan

    mutharasan Member


    Dear D Lokesh,

    Greetings,

    It is working and my problem solved, thank you for your immediate and valuable help.

    Have a nice Day.

    Thanking You.
     


  4. NSA

    NSA Member


    [#Line : DSP VchAccTitles]
    Add :Option : RCPLedReportDSPVchAccTitles : $$IsGroupSundryDebtors:$Parent:##LedgerName
    [!Line: RCPLedReportDSPVchAccTitles]
    Add :Right Fields : Before : DSP VchTypeTitle : RCPLedLocationTitle, RCPLedDriverTitle, RCPLedTruckNoTitle, RCPTruckTypeTittle

    this option is not showing in the ledger report. can anyone please correct me?
     


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    $$IsLedOfGrp:##LedgerName:$$GroupSundryDebtors
     


  6. NSA

    NSA Member


    T
    Thank you so much Sir.
     


Share This Page