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.
     


  10. Anadi Yagnik

    Anadi Yagnik New Member


    Still Stuck Sir. I don't know what i am missing, i have done the changes as per your guidance.
    Attaching tdl for your reference.
     

    Attached Files:



  11. Anadi Yagnik

    Anadi Yagnik New Member


    Hello Sir,

    I hope you are doing well.

    I have somehow reached to the point where i can get total by new collection.
    now i am stuck to how can i filter the amount based of condition.

    Attached screenshot and TDL for reference.

    Hope to get help in this regard.

    upload_2022-10-4_15-37-18.png
     

    Attached Files:

    Hems likes this.


  12. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    As a learner you must READ carefully any instructions given....... and follow it properly..........;):cool::confused:

    Make the following changes.......

    Code:
    [Line: NBPMTotals]
    Local : Field : Under15K: Set as : @@Total15E
    
    [Collection : SundryCreditorsLedgerTotal]
    Type : Ledger
    Child Of : $$GroupSundryCreditors
    Belongs to : Yes
    Fetch : ClosingBalance
    Filter : ZeroClosing
    Filter : CreditOnly
    
    [System:formula]
    Cond15E : ($ClosingBalance:Ledger:$Name > 0 AND $ClosingBalance:Ledger:$Name <= 15000)
    Total15E   : $$FilterAmtTotal:SundryCreditorsLedgerTotal:Cond15E:$ClosingBalance
    
    follow the SAME for the balance columns..............
     


  13. Anadi Yagnik

    Anadi Yagnik New Member


    Good morning sir,
    Thank you once again to teach me how it's done. I am really grateful for your teaching.

    I have one doubt. As we are fetching the total from new collection if I hide any creditors group the total amount will not change. Example if the total amount of new collection is 100 and if I hide any group it will still show 100.

    I know I am making it really long thread. I am really sorry.
     


  14. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    First -- the Totals will not change, because you are computing from a dis-associated Collection NOT forming part of your main report.

    Second - your structure is wrong ..... the sub-totals should be at the GroupLine level rather than at the bottom........ Refer TB and other default reports of Tally.........
     


Share This Page