How to Fetch reference number in ledger report

Discussion in 'Free Source Codes' started by KAUSHIK GALATHIYA, Mar 6, 2023.

    


  1. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    How did you get the CostCentre?? In same manner you can obtain the Reference No.
     




  2. [Field : Col_FLD_VchCMPCC_ForVch3]
    Use : Name Field
    SetAs : $Name
    Width : 15 ;;% Page
    Style : Small Bold

    [#Collection: Vouchers of Ledger]
    Fetch: Name

    sir same add but not get data
     


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    The cost centre has been extracted with a function definition........... where is your code for that??
     




  4. [#Line: DSP VchAccTitles]

    Add : Right Fields : Before : DSP VchTypeTitle :Col_FLD_VchCMPCC_ForVch,Col_FLD_VchCMPCC_ForVch1,Col_FLD_VchCMPCC_ForVch2;;,Col_FLD_VchCMPCC_ForVch3
    Local : Field : Col_FLD_VchCMPCC_ForVch : Set As : "Cost Center"

    [Field : Col_FLD_VchCMPCC_ForVch]
    Use : Name Field
    SetAs : $CostCentreName ;;$Brk_PartyVchCMPStates
    Width : 15 ;;% Page
    Style : Small Bold

    [#Collection: Vouchers of Ledger]
    Fetch: CostCentreName
     


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Does the above code works ???
     


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    In the screenshot the value of CostCentre appears......... but in no way it will appear based on your above code.
     



  7. Yes sir
     


  8. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Well good.... then the reference should also come........... use $Reference
     



  9. Good morning sir,
    voucher reference not required, muje adjustment wala like new ref/against ref/advance vo possible he kya ???
     


  10. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    In your Collection
    Fetch : LedgerEntries.BillAllocations.Name

    In your Field
    Set As : $LedgerEntries[].BillAllocations[].Name
     
    Last edited: Mar 7, 2023



  11. Thank you Sir...
     


Share This Page