How to display optional vouchers in ledger report

Discussion in 'Requests' started by S k singh, Mar 11, 2022.

    
  1. S k singh

    S k singh New Member


    How to display optional vouchers in ledger report

    Help please !
     
    Last edited: Mar 11, 2022
    mahbu likes this.


  2. mahbu

    mahbu Member


    Please check this

    [#Collection: Vouchers of Ledger]
    Add: Collection:Optional Led Vch
    [Collection:Optional Led Vch]

    Type : Optional Vouchers
    Child of : ##LedgerName
    Belongs To:Yes
    Filter:IsOptional
     


  3. S k singh

    S k singh New Member



    Thanks for sharing the code :)
     
    Last edited: Mar 13, 2022


  4. S k singh

    S k singh New Member




    It's fetching all optional vouchers, Belongs to other ledgers too . Also unable to display amount in ledger report screen .

    Please help
     



  5. Optional vouchers need to filter with ledger name.
    childof will not work.
     


  6. S k singh

    S k singh New Member


    Will you please elaborate how to write a code for this ?
     


  7. mahbu

    mahbu Member


    Try this

    [#Collection: Vouchers of Ledger]
    Add: Collection:Optional Led Vch
    [Collection:Optional Led Vch]

    Type : Optional Vouchers
    Filter:IsOptional,IsselectedLed
    [System:Formula]
    IsselectedLed : $AllLedgerEntries.LedgerEntries.LedgerName=##LedgerName
     
    S k singh likes this.


  8. S k singh

    S k singh New Member



    Thanks a lot :)
     


  9. ananddanacial

    ananddanacial New Member


    The narration of the optional voucher is not showing while for the regular voucher it's showing.
     


  10. mahbu

    mahbu Member


    add Compute Narration collection

    [#Collection: Vouchers of Ledger]
    Add: Collection:Optional Led Vch
    [Collection:Optional Led Vch]
    Type : Optional Vouchers
    Filter:IsOptional,IsselectedLed
    Compute:Narration : $Narration
    [System:Formula]
    IsselectedLed : $AllLedgerEntries.LedgerEntries.LedgerName=##LedgerName
     


  11. ananddanacial

    ananddanacial New Member


    Thank you so much !!
     
    mahbu likes this.


Share This Page