TDL for narration details display on outstanding receivable and payable report

Discussion in 'Tally Developer' started by Rupesh H, Jun 25, 2020.

         
  1. Rupesh H

    Rupesh H New Member


    NEED HELP FOR TDL CODE OF DISPLAY SALES LEDGER NARRATION IN BILLS RECEIVABLE AND PAYABLE REPORT
    PLS HELP
    THANKS
     
    Last edited: Jun 25, 2020


  2. gangstar

    gangstar Member


    [#Report:LEDBILL Configure]
    Local:Form:DSP Configure:Add:parts:At End:SLedNarration

    [#Report:BILL Configure]
    Local:Form:DSP Configure:Add:parts:At End:SLedNarration

    [Variable:ShowNarrVar]
    Type:Logical
    Persistent:Yes

    [System:Variables]
    ShowNarrVar:""

    [Part:SLedNarration]
    Add:Bottom Line:At End:ShowNarrVar
    Local:Line:Default:Space Top:0.5
    Local:Field:Default:color:Blue

    [Line:ShowNarrVar]
    Field:Medium Prompt, Logical Field
    Local:Field:Medium Prompt:Info:$$LocaleString:"Show Narration ?"
    Local:Field:Logical Field:Modifies:ShowNarrVar

    [#Field:BILLFixed]
    Add:Field:At End:BRBPNarration

    [Field:BRBPNarration]
    Use:Narration Field
    Set as:$BRPNarration
    Style:Tiny
    Invisible:Not ##ShowNarrVar

    [#Line:BILLCol1]
    Local:Field:BRBPNarration:Set as:"Narration"
    Local:Field:BRBPNarration:Color:Red
    Local:Field:BRBPNarration:Style:Normal Bold

    [#Line:BILLCol2]
    Local:Field:BRBPNarration:Set as:""

    [#Collection:Company Receivables]
    Compute:BRPNarration:$LedgerEntries.Narration

    [#Collection:Company Payables]
    Compute:BRPNarration:$LedgerEntries.Narration
     
    Rajsrisrimal and Rupesh H like this.


  3. Rupesh H

    Rupesh H New Member


    Hello Respected Sir
    I am very thankful for your Help for providing me this TDL
    Its working Great.
    Thanks a Lot.!!!!!!!
     


  4. Rupesh H

    Rupesh H New Member


    20200626_005550.jpg 20200626_005610.jpg
    Respected Sir
    Its Working perfectly in Bill Wise Option (F7 key)
    But When i checked in Bill Party Wise Option (F7 Key) it is not working
    Kindly could you please update it
    Thanks
     


  5. gangstar

    gangstar Member


    Sir
    Same thing u need to work in bill partywise. If u have any error means we will help u.

    Warm & Regards,

    Gangstar
     


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Above code is indicative and informative.... Now you must work on the same as per your needs.

    Experts will help, in case of errors or any hold-up.
     


  7. Rupesh H

    Rupesh H New Member


    Hello members and experts
    I want to learn TDL
    But I dont know coding
    So can you refere me any TDL basic books or PDF file with tally screenshot and example
    Thanks
     


  8. gangstar

    gangstar Member


    Sir Refer this Manual Book
    Install tally developer.exe file
    Open tally developer folder Sample data and Sample tdl will be available.
     

    Attached Files:



  9. Rupesh H

    Rupesh H New Member


    Thanks sir
    I have not knowledge of any programming language
    Could I learn this program
    Is it easy to learn and understand
     


  10. gangstar

    gangstar Member


    Ya Bro / Sir
    I'm B.Com Student but I'm working in this field very happy to program the Tdl.
    Be Happy Bro / Sir
     


  11. Rupesh H

    Rupesh H New Member


    Thanks sir
     


  12. gangstar

    gangstar Member


    ;copy this file in paste in exisiting file

    [#Collection:Company LedgerReceivables]
    Compute:BRPNarration:$LedgerEntries.Narration

    [#Collection:Company LedgerPayables]
    Compute:BRPNarration:$LedgerEntries.Narration
     


  13. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Just a suggestion to improve....
    it should work for all levels.....for groupwise also, for billwise report also... in all the reports the narration should be displayed. Also it should display narration when exploded. In exploded scene, the additional JV/DN/CN/Pymnt/Rcpt etc would have been shown against that bill... and these vouchers also has narration.

    So users can know why some entries have been passed or short pay/rcpt is there.

    Also make a button instead of going to F12 Configure... toggle button is easier for rapid on/off.

    This would make your program complete in all respects.
     


  14. gangstar

    gangstar Member


    I will try my best Sir
     


  15. Amit Kamdar

    Amit Kamdar Administrator Staff Member



  16. Rupesh H

    Rupesh H New Member


    Awesome !!!!
    Thanks sir
    Its Working Perfectly Now.

    Admin Amit Sir

    Please Develop some Mechanism in your site to Understanding the basic of TDL to Newcomers (as like me)
    Since the member will more interest to visit this site
    This is Small Suggestion at my end.
     


Share This Page