Also need optional vouchers in Ledger vouchers

Discussion in 'Tally Developer' started by mutharasan, Sep 4, 2022.

    
  1. mutharasan

    mutharasan Member


    Dear Amith sir,

    can we also fetch the optional vouchers in ledger vouchers? if is it possible then please how to do it?

    thanks in advance sir
     


  2. S k singh

    S k singh New Member


    Try This
    [#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
     


  3. Maulik Patel

    Maulik Patel Active Member


    In default Tally you can do it but with a long process.
    • Create one scenario which contains optional and actual voucher types
    • Open Balance Sheet/Profit & Loss
    • Click on "New Column" button
    • In "Type of value to show" option select your scenario
    • Drill down to ledger vouchers
    upload_2022-9-29_20-42-7.png
     


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    [#Collection: Vouchers of Ledger]
    Source Collection : SRC Ledger Vouchers Coll, SRC Ledger Optional Vouchers Coll

    [Collection: SRC Ledger Optional Vouchers Coll]
    Type : Optional Vouchers
    Fetch : MasterID, Date, VoucherTypeName
    Fetch : AllLedgerEntries.LedgerName
    Filter : Is4thisLedger

    [System : Formula]
    Is4thisLedger : $LedgerName = #LedgerName
     


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Please note --- even though it is a Non-Accounting Vouchers -- it will affect the Balance of the Ledger.

    For Display only --- you need to change / modify the SET AS of the Dr/CR Column Field of "Ledger Vouchers".
     


  6. dipu369

    dipu369 Member


    Dear Amit sir,
    can we show optional vouchers (Proforma Invoice) in Balance Sheet->Sundry Debtors ?
    But it will not affect the Sundry Debtors amount.
    Only will Show after click the "Sundry Debtors"


    Thanks in advance.
     


  7. sivam

    sivam Active Member


    Not Possible at all.
     


Share This Page