Sundry Creditors Report (Amount Wise)

Discussion in 'Tally & TDL Learning HUB' started by Anadi Yagnik, Apr 1, 2022.

    
Tags:
  1. Anadi Yagnik

    Anadi Yagnik New Member


    Respected Sir,

    Thank You for helping me and guiding me earlier in my doubts.

    Recently i am making a tdl of Sundry creditors report Amount wise. I am somehow manage to reach some level for completing it but now i am facing some issues due to my lack of knowledge.

    1. Hide amount of Group Closing balance but don't want to hide amount of ledger in explode.
    2. Sub Total of Exploded Ledger Closing Balance
    3. Grand Total of Sub Total Mentioned in Exploded Ledger.

    Attaching Image and TDL File for your ready referance.

    I am still a learner, please forgive me if i disrespect you in any manner.

    Thank You
     

    Attached Files:



  2. Anadi Yagnik

    Anadi Yagnik New Member


    Amit Ji, request you to please guide.
     


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    altered code attached.... Hope this works.... in absence of DATA i am not able to check.....
     

    Attached Files:

    Anadi Yagnik likes this.


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    ;);) Learning is not a crime..... so no disrespect taken :cool::cool:
     
    Anadi Yagnik likes this.


  5. Anadi Yagnik

    Anadi Yagnik New Member


    Thank you sir for your kind reply. Will check and update you the same.
     


  6. Anadi Yagnik

    Anadi Yagnik New Member


    Good afternoon, Sir,

    Thanks again for your altered code, i have managed to get Amount by creating duplicate fields and creating subtotal line in explode part.
    now my only issue is grand total of that sub-totals.
    i have go thru every thread relating this but i haven't achieved the desired result.

    Attaching TDL and Screenshot

    Requesting to all seniors to help me.

    upload_2022-9-20_14-41-55.png
     

    Attached Files:



  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Imagine .... imagine.... you have a report without any subtotal ......... means you already have the Collection for all the Ledgers .... but in above you have broken them up Group-wise....

    So compute the Grand Total accordingly.

    Or Else make another Collection for all Ledgers only --- and compute your value and then use $$CollAmtTotal and then use this Total in your field for GRAND Total.
     
    Anadi Yagnik likes this.


  8. Anadi Yagnik

    Anadi Yagnik New Member


    Hello Sir,

    I have tried everything as per suggestion, i get total if i change main collection from group, but unable to get that total in group.
    I tried the collection too by creating collection ledger but unable to get success.

    Please guide me
     


  9. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Make a new collection to get total...... compute the value in that collection.... Leave your original collections as it is......... make a NEW one to compute total values.

    in system : formulae ---- use $$collamttotal to get the totals.......... fetch this formula in your field.
     


Share This Page