Dear All, I was trying to make an Auto Narration for Payments with the help of Maulik Bhai. But am facing problem in fetching all the Invoices that are paid in the payment voucher. Kindly help how to fetch all the Invoice No. that are paid in the narration. [#Field: VCH Narration] Use : Voucher Narration Field Lines : 4 Storage : Narration Set as: If $$InCreateMode And $$IsPayment:##SVVoucherType then "Ch. No. : " + $LedgerEntries[1].BankAllocations.InstrumentNumber + " " + "Ch. Dt. : " + $$String:$LedgerEntries[1].BankAllocations.InstrumentDate + " " + "Agnst Inv No." + $LedgerEntries[2].BillAllocations.Name else " " Key : PrevVchNarration, PrevLedNarration Set Always : Yes
Dear Taufeeq Shaikh, Try This Code..... [#Field: VCH Narration] Set as: If $$InCreateMode And $$IsPayment:##SVVoucherType then "Ch. No. : " + $LedgerEntries [1].BankAllocations.InstrumentNumber + " " + "Ch. Dt. : " + $$String:$LedgerEntries [1].BankAllocations.InstrumentDate + " " + "Agnst Inv No." + $LedgerEntries [2].BillAllocations.Name else " " Set Always : Yes
There must be a period after first collection. For Eg $AllLedgerEntries[1].BankAllocations[1].InstrumentNumber $AllLedgerEntries[1].BankAllocations[1].InstrumentDate $AllLedgerEntries[1].BankAllocations[1].BankName $AllLedgerEntries[1].BankAllocations[1].BranchName You have to write balance code
Hi, 1) Are you able to capture the Bank Details alone ? [#Field: VCH Narration] Option : My Pymt VCH Narration : $$InCreateMode And $$IsPayment:##SVVoucherType [!Field: My Pymt VCH Narration] Set as : @@MyPymtFor [System: Formula] MyPymtFor : $AllLedgerEntries[1].BankAllocations[1].InstrumentNumber + ... and as John said for other fields. Let us know if u succeed on this. We will next try to pick Bill details of Party by using $PartyLedgerName
I doubt If there is more than one cheque, It will take only first Cheque. We must use Full List. But I do not know how to give full list Since there is more than one collection
Exactly Mr. Jobimon. We need to work on Full List. That is Ok we need it for the one cheque only. Now requiremnt is only for fetching all the invoices against which the cheque has been issued.
Thank you for your advice. The above code is working in your tally. But in my tally the code not working so i post quarry
Who said this code is working! Taufeeq Shaikh is trying to get a solution for his problem and he is trying to make full solution. Even before completing code you need full code Wonder full............................ Have you read what is written in this thread.
For Fetching bill You can refer in Tally default tdl Bill wise report. It will give you some idea.Since I am my computer is under repair ; I am not able to tell you excatly right now.
Dear Experts, Finally get Full List For Multiple Cheques $$FullList:AllLedgerEntries:$BankAllocations.InstrumentNumber For Multiple Bill References $$FullList:AllLedgerEntries:$BillAllocations.Name
Sorry Experts, Above code is not working in one case, let me try on that case, will give corrected code soon. Thanks to Taufeeq Shaikh and HVPatel for notifying me that case.
Dear Experts, Find corrected code for Bill Allocations [#Field: VCH Narration] Set As : $$FullList:LedgerEntries:$MLKBillList Set Always : Yes [#Object : Ledger Entry] MLKBillList : $$FullList:BillAllocations:$Name
Hello sir, i am add some code according to your code but i am not getting success what is wrong in code, how to edit code working in voucher creation mode and voucher alteration mode also My code is: [#Field: VCH Narration] Set as: If $$InCreateMode And $$IsPayment:##SVVoucherType then "Ch. No. : " + $LedgerEntries[1].BankAllocations.InstrumentNumber + " " + "Ch. Dt. : " + $$String:$LedgerEntries[1].BankAllocations.InstrumentDate else + If $$InCreateMode And $$IsReceipt:##SVVoucherType then "Ch. No. : " + $LedgerEntries[1].BankAllocations.InstrumentNumber + " " + "Ch. Dt. : " + $$String:$LedgerEntries[1].BankAllocations.InstrumentDate + "Drawn on " +$LedgerEntries[1].BankAllocations.BankName + $LedgerEntries[1].BankAllocations.BranchName else + If $$InCreateMode And $$IsContra:##SVVoucherType then "Ch. No. : " + $LedgerEntries[1].BankAllocations.InstrumentNumber + " " + "Ch. Dt. : " + $$String:$LedgerEntries[1].BankAllocations.InstrumentDate else " " Set Always : Yes