Auto Narration for Payment

Discussion in 'Tally Developer' started by Taufeeq Shaikh, Mar 10, 2014.

    
  1. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    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
     
    kamalpatel likes this.


  2. sivam

    sivam Active Member


    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
     
    naren1234 likes this.


  3. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    No its not working Mr. Knsivam
     


  4. JObimon Arackal JOhn

    JObimon Arackal JOhn Active Member


    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
     



  5. 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
     


  6. JObimon Arackal JOhn

    JObimon Arackal JOhn Active Member




    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
     


  7. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    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.
     
    kamalpatel likes this.


  8. R. VIJAY

    R. VIJAY Member


    it not working can you upload full code
     


  9. sivam

    sivam Active Member


    Can u try ur Own...?
     
    JObimon Arackal JOhn likes this.


  10. R. VIJAY

    R. VIJAY Member


    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
     


  11. JObimon Arackal JOhn

    JObimon Arackal JOhn Active Member



    :mad::mad::mad::mad::mad::mad:
     
    sivam likes this.


  12. sivam

    sivam Active Member


    The all experts give Idea only. u only try ur own. If they give full code mean wt is ur work.?
     


  13. JObimon Arackal JOhn

    JObimon Arackal JOhn Active Member



    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.
     
    Taufeeq Shaikh likes this.


  14. JObimon Arackal JOhn

    JObimon Arackal JOhn Active Member





    Dear knsivam89 We have already tried to make him understand in a lot of ways. But no fruit
     
    Maulik Patel likes this.


  15. JObimon Arackal JOhn

    JObimon Arackal JOhn Active Member



    But This full list function will not work collection inside collection.( I think)
     


  16. JObimon Arackal JOhn

    JObimon Arackal JOhn Active Member




    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.
     


  17. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    Am trying but not yet succeeded. I will look after at your point for Bill Wise Report.
     


  18. Maulik Patel

    Maulik Patel Active Member


    Dear Experts,

    Finally get Full List

    For Multiple Cheques
    $$FullList:AllLedgerEntries:$BankAllocations.InstrumentNumber

    For Multiple Bill References
    $$FullList:AllLedgerEntries:$BillAllocations.Name
     


  19. Maulik Patel

    Maulik Patel Active Member


    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.
     


  20. Maulik Patel

    Maulik Patel Active Member


    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
     


  21. HVPatel

    HVPatel Active Member


    Great, its working, Thanks Mr. Maulik Patel
     


  22. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    Superb...... Thanks Lot Maulik Bhai.

    Truly Genius Boss...
     
    kamalpatel likes this.


  23. JObimon Arackal JOhn

    JObimon Arackal JOhn Active Member






    Great Effort.
    Keep this spirit throughout life.
     


  24. JObimon Arackal JOhn

    JObimon Arackal JOhn Active Member



    This is really a team work.

    Congrats Taufeeq Shaikh, HVPatel , Maulik Patel
     
    Vashisth likes this.


  25. ramesh

    ramesh New Member


    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
     

    Attached Files:

    • 1.txt
      File size:
      808 bytes
      Views:
      209
    dce2150404336 likes this.


Share This Page