NOT FETCHING BANK DETAILS VALUE

Discussion in 'Requests' started by PANKAJ BHONDLE, Feb 9, 2019.

    
  1. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member



  2. mukeshb

    mukeshb Member


    Dear Pankaj,

    Can u send this code to my mail id on mukesh@benir.in

    Thanks,
    Mukesh
     


  3. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member



  4. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    FINALY DONE
     


  5. mukeshb

    mukeshb Member


    Dear Pankaj,

    Can u send this TDL on my mail id mukesh@benir.in

    Thanks,
    Mukesh
     


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Let me know, if you can, what is the formula to pick up the Ledger's Bank A/c details (Default tally).....
     


  7. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    amit sir & Mukesh hb above code formula send on your mail id
     
    Amit Kamdar likes this.


  8. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    upload_2019-3-27_22-29-32.png


    Party Bank Account Details in voucher Entry
     


  9. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    upload_2019-3-27_22-30-27.png

    ledger Master Bank Details
     


  10. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    Amit Sir, Sample Code send in Your mail id
     


  11. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Thanks a lot Pankaj for your valuable efforts..... but still you are missing the point...........

    So I explain my point of view here below:

    What you have done is getting the Data from the Vouchers and it is easy to get. Either by way of formula (as per your code) or computing it in collection by walking through all Ledger entries, Bank allocations etc., one can get it easily.

    But consider this, if a Ledger does not have a Payment voucher till date....then from which voucher will this data be collected. The code you have sent will give me blank details as there are no vouchers to extract information from.

    Also consider the case when a party has multiple Bank Accounts.....and some payments are made to Bank1 and some to Bank2, and hence this method is not wanted.

    Therefore I am trying to extract the information from the Ledger Master. The screenshot i have sent to you, vide earlier mail.
     


  12. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Anyway....I've got the idea now............ will have to tap the collection and include it in the report..........

    I am trying to get the value in another report.............. and in your case you have the collection built-in in the Voucher entry mode....

    Thanks a ton....buds.
     


  13. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Got it now..........thanks

    Capture.PNG
     


  14. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    Amit sir, send on your code my mail id
     


  15. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member



  16. Rajiv Prabhakar

    Rajiv Prabhakar New Member



  17. R Vaishnav

    R Vaishnav New Member


    Amit Sir

    Could you help me out to fetch the bank details from ledger master to payment voucher.

    upload_2019-9-28_15-29-23.png
     


  18. R Vaishnav

    R Vaishnav New Member


    I am writing as below, but it is not working
    Set as: $AccountNumber:paymentDetails:$LedgerName
     


  19. teja varma

    teja varma Active Member


    we can modify the ledger object to compute bank details without making much complex:
    Code:
    [#Object:Ledger]
    Sledbankname:$PAYMENTDETAILS.BANKNAME
    Sledbankaccount:$PAYMENTDETAILS.ACCOUNTNUMBER
    Sledbankifsc:$PAYMENTDETAILS.IFSCODE
    then use these methods to get bankname,account number, ifsc code:
    Code:
    $Sledbankname:Ledger:$LedgerNAme
    $Sledbankaccount:Ledger:$LedgerName
    $Sledbankifsc:Ledger:LedgerName
     
    gangstar, Mahesh Sethi and Frz like this.


  20. R Vaishnav

    R Vaishnav New Member


    Thanks, Tejas
    You made it so easy :)
     


  21. Srinugudapati

    Srinugudapati New Member



  22. kiranrajabhai

    kiranrajabhai New Member


    plz provide code
     


  23. Mukesh Garg

    Mukesh Garg Member



  24. Mukesh Garg

    Mukesh Garg Member



  25. Mukesh Garg

    Mukesh Garg Member



Share This Page