1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Ledger Display with Voucher-wise in columnar.

Discussion in 'Tally Developer' started by Amit Kamdar, Oct 1, 2018.

    
Tags:
Page 1 of 2
  1. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    LC1 Capture.PNG

    LC2 Capture.PNG

    LC3 Capture.PNG
     
    Amit Kamdar, Oct 1, 2018
    #1
    MarutiKalekar, Rohit Khedar, Bipin Damania and 1 other person like this.


  2. Gopal solanki

    Gopal solanki New Member

    Gopal solanki, Oct 1, 2018
    #2


  3. nasir

    nasir Member

    nasir, Oct 1, 2018
    #3


  4. Jay kumar tailor

    Jay kumar tailor Well-Known Member

    Jay kumar tailor, Oct 1, 2018
    #4


  5. Mudassar

    Mudassar New Member

    Mudassar, Oct 1, 2018
    #5


  6. madhu.vukyam

    madhu.vukyam New Member


    what is the cost of tdl
     
    madhu.vukyam, Nov 23, 2018
    #6


  7. Bipin Damania

    Bipin Damania Active Member


    Amitji
    We have to add field after Cr Amt ?
    If Yes, then please guide with sintex.
    Please reply.
     
    Bipin Damania, Dec 3, 2018
    #7


  8. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Kindly rephrase your question. Cannot understand if you want to do something or are you asking me something else.
     
    Amit Kamdar, Dec 3, 2018
    #8


  9. Bipin Damania

    Bipin Damania Active Member


    Amitji

    Yes, I am asking you how to add field after Cr Amt. Please guide with sample code. rest i will try at my own.
    Thanks
     
    Bipin Damania, Dec 3, 2018
    #9


  10. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    In Line: DSP VchAccTitles ;;;;;;; for TITLES
    Add right Field After DSP VchLedBalTitle

    Refer LV Body in TDE....

    In Line Line: DSP VchAccDetail
    Add field after your desired position/field. i.e After DSP VchCrRecAmt

    Format to add is as under:
    Add : Right Fields : After : DSP VchCrRecAmt : field1, field2............
     
    Amit Kamdar, Dec 4, 2018
    #10


  11. Bipin Damania

    Bipin Damania Active Member



    Thank you Amitji
    I will try and reply
     
    Bipin Damania, Dec 6, 2018
    #11


  12. haresh1123

    haresh1123 New Member

    haresh1123, Dec 14, 2018
    #12


  13. Rais Ahmed

    Rais Ahmed Member


    Dear Sir,
    I have edited sales report TDL, But I could not Add the Amount of Tax Nor Total amount of Net sale, any suggestion PL.
    Thanks and regards
     
    Rais Ahmed, Dec 14, 2018
    #13


  14. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    considering the data provided by you.....i can suggest........try harder, look elsewhere...........
     
    Amit Kamdar, Dec 14, 2018
    #14


  15. Rais Ahmed

    Rais Ahmed Member


    Dear Sir,
    I have added net sale, but I think though I succeeded but it is not correct formula so when I tried $$Total to net sale total and quantity it is not coming. Please Help. Thanks
     
    Rais Ahmed, Dec 15, 2018
    #15


  16. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    have u defined TOTAL in the body part............../?
     
    Amit Kamdar, Dec 16, 2018
    #16


  17. Rais Ahmed

    Rais Ahmed Member


    Yes Sir,
    Local : Field : TAmount : Set as : $$Total:TAmount
    Local : Field : Billqty : Set as : $$Total:Billqty
    Local : Field : Amount : Set as : $$Total:Amount
    Only Amount total (Gross) is coming
     
    Rais Ahmed, Dec 17, 2018
    #17


  18. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    In your Body Part.......

    Totals : TAmount, BillQty
     
    Amit Kamdar, Dec 17, 2018
    #18


  19. Bipin Damania

    Bipin Damania Active Member


    Thank you Amitji.
    I have tried and get as per image below, but how to get total.
    Please reply

    Unable to upload screen shot.
    ‪
     
    Bipin Damania, Dec 17, 2018
    #19


  20. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    $$Total:<fieldname>
     
    Amit Kamdar, Dec 17, 2018
    #20


  21. Rais Ahmed

    Rais Ahmed Member


    Yes Sir,

    [Part :My Voucher Report]

    Line : My Voucher Title,My Voucher Report
    Bottom lines : Sale Report Title
    Repeat :My Voucher Report :My Voucher Rep Collection
    Scroll : Vertical
    CommonBorder : Yes
    Total : IGST,CGST,SGST,TAmount,Billqty,AvgRate,Amount
    Option : Alter On Enter
    Nett Amount formula used $$CollAmtTotal:AccountingAllocations:$Amount / Qty $BilledQty /Amount $Amount
    Could not fetch IGST,CGST,SGST value. Could not upload image
    Regards
     
    Rais Ahmed, Dec 17, 2018
    #21


  22. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Cannot understand your formula....maybe you should slow down, think properly and write logically and use proper punctuations, so others can understand...........

    Collectedamount divided by Qty... again divided by amount and then $Amount........... what does this mean??

    If this is the actual formula used by you, then obviously it won't work as Tally also cannot compute what it does not understand either.
     
    Amit Kamdar, Dec 17, 2018
    #22


  23. Bipin Damania

    Bipin Damania Active Member


    AMITJI

    GOT THE TOTAL

    THANK YOU
     
    Bipin Damania, Dec 17, 2018
    #23


  24. Rais Ahmed

    Rais Ahmed Member


    Sir Only For information I mention Function Means for Net Amount I used Set As : $$CollAmtTotal:AccountingAllocations. For Gross Amount I used Set As : $Amount. For Bill Qty Set As : $BilledQty like that. So if function mistake is there U can suggest.Sorry for short clarification. I could not find or know any formula for retrieving IGST,CGST,SGST Value.
    Regards
     
    Rais Ahmed, Dec 17, 2018
    #24


  25. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Very good Bipinbhai.........you are progressing nicely and fast. Keep it up.
     
    Amit Kamdar, Dec 17, 2018
    #25


Page 1 of 2

Share This Page