Add a field from Ledger Master fields like Address in DayBook

Discussion in 'Free Source Codes' started by Murari Bajaj, Nov 24, 2020.

    
  1. Murari Bajaj

    Murari Bajaj Member


    Dear Experts
    As we have Ledger name available in Daybook can we have some field like address or other field in DayBook.
    I tried a lot but could not.
    Thanks
     
    Last edited: Nov 24, 2020


  2. Himanshu-2002

    Himanshu-2002 Active Member


    Share Your Code We will correct it
     


  3. Murari Bajaj

    Murari Bajaj Member


    DayBook1.jpg
     


  4. Murari Bajaj

    Murari Bajaj Member


    Himanshuji I want some field from Ledger Master in DayBook. I mean like something from ledger address or City or Pincode...etc.
    Thanks
     


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Type "DayBook" in search box........

    you will find many variants of Column addition to Daybook. Select one and modify the same as per your desired requirement.
     


  6. Murari Bajaj

    Murari Bajaj Member


    Namskar Amitji
    I did this and tried many ways. but could not fetch Ledger Master field in it
    the problem is this only. Other information i can take here.
    Thanks
     


  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    All reports with DATA has a collection..........

    You need to compute the values in the collection of your report.......and then reference the same in your "added" field(s).
     


  8. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Please clarify............what "Ledger Master" field is that you need ??
     


  9. Murari Bajaj

    Murari Bajaj Member


    Amitji
    I need information from Address and Mobile Number.
    Thanks
     


  10. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Yes you can directly get it, as the same has already been defined in [Object : ledger]

    Add your fields in the DayBook and simply reference it ... using the Field : DSP VchAccount
     


  11. Amit Kamdar

    Amit Kamdar Administrator Staff Member



  12. Murari Bajaj

    Murari Bajaj Member


    Okay. I will try and let you know sir. Thank you.
     


  13. Himanshu-2002

    Himanshu-2002 Active Member


    Sir Search How to add cheque number in daybook So, You can understand how to add a column in day book later you can think about values
     


  14. Murari Bajaj

    Murari Bajaj Member


    Himashuji perhaps you misunderstood the question. Its not about how to add a column in DayBook its about how to fetch
    some of Ledger Master fields in DayBook. And i am trying to do it as Amitji has suggested. Thanks.
     


  15. Murari Bajaj

    Murari Bajaj Member


    [Field : MyNewRefNoTitleFld]
    Use : Short Name Field
    Set as : $AllLedgerEntries[1].Address ;($$FullList:Address:$Address)
    ;Background:BLUE
    Lines:4
    Skip : Yes
    Align : Left
    Width : 8

    Using this but only Address from Sales and Purchase Vouchers is coming as they have address at the time of creating vouchers.

    Please suggest how to bring the address as you have done. Thanks
     
    Last edited: Nov 25, 2020


  16. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Address are meant only for Debtors & Creditors i.e. sales n purchases ...........

    Do you keep address even for Duties & Taxes and Revenue groups ???
     


  17. Murari Bajaj

    Murari Bajaj Member


    Yes sir I agree Address is for Both Type of parties only but as the address is coming in Image sent by you in Receipt or Payment voucher also. That is what i mean. Thanks

    In my case its not happening.
     


  18. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Mine is coming because I am not referring to the collection ---- AllledgerEntries ......... you are getting it from that collection. ALSO, you would not be getting the FULL address. Check it.

    Instead as I said earlier..... you need to use the Field :DSP VchAccount

    Am giving you the answer to this, but you need to work for the rest......... $STPartyFullAdd:Ledger:#DSPVchAccount
     


  19. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    In my case, I have referenced the FIELD : DSP VchAccount ... and also made IF condition to check if it is Drs/Crs Ledger and ignore the rest.
    In my TDL it also works for EXPLODED view i.e. Internal Ledgers belonging to Drs/Crs.
     


  20. Amit Kamdar

    Amit Kamdar Administrator Staff Member



  21. Murari Bajaj

    Murari Bajaj Member


    Okay. I got your point. Now i will try in that direction. Thanks
     


  22. Murari Bajaj

    Murari Bajaj Member


    Untitled5.png

    Yes sir it is done with your valuable guidence. Thanks
     
    Amit Kamdar likes this.


  23. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Well Done........;)
     


  24. conquer

    conquer New Member


    Amit sir ji muje Tally Prime in Mailing Address me 5 UDF add karana hai or o address book me display hona chaieye like ( Dealership From=yes/no, Deposite Amt=yes/no) or Compression Address Book me error T0027 aa raha hai sir please reply
     


  25. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Mailing Address......"Aggregate" UDF use karta hai.....usme additional Fields dallne se maamla bigad jaayega.
    Aapka 5 additional Field address ke baad daal do....jaise ki State aur Pincode hai......aasan rahega

    Error code ka maloom nahi.........konsa program mei error aa raha hai?
     


Share This Page