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
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
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
[#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
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".
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.