Ledger Summary: Useful for Auditors

Discussion in 'Free Source Codes' started by Devendra_Rawat, Jul 23, 2019.

    
  1. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    Ha ha and you have deleted the count field from explode part all together . ha ha ( na rahega baans na bajegi baansuri)
     


  2. Bipin Damania

    Bipin Damania Active Member


    Yes...
    :)
     


  3. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    Point ye hai na Damania Ji
    Our Reported Ledger is suppose : Himanshu Electronics

    Consider Two Examples:
    1. Accounting Voucher

    Himashu A/c Dr 5000
    To Sales -I A/c Cr. 5000

    Here Count of Sales-I A/c is -1 (One)


    2. Inventory Voucher

    Himanshu A/c Dr 50000

    1. Item -I (allocated to Sales -I) Cr 10000
    2. Item-2(allocated to Sales -I) Cr 10000
    3. Item-3(Allocated to Sales-I) Cr 10000
    4. Item-4 (allocated to Sales-II) Cr 10000
    5. Item -5 (allocated to Sales-II) Cr 10000

    How would like to count Sales-I and Sales-II in second voucher ??

    Sales-I (count it 1 or count it 3) ??
    Sales-II (Count it 1 or count it 2) ??

    therefore as per TDL

    Sales-I is showing count -3
    Sales-II is showing count-2

    even in case of Accounting Voucher Like


    Himanshu A/c Dr 5000
    To Cash Rs. Cr. 4500
    To Discount Cr 500

    this voucher will come twice
    1st for Cash
    2nd again for Discount

    So count is anyway -2(though appearing one in each appearance)

    Amit sir is also right and he has given a fantastic idea of counting (appearances).. though we differ in how we count
     


  4. Bipin Damania

    Bipin Damania Active Member


    Perception differ from person to person.

    Thank you.
     


  5. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    $$KeyExplode
     
    Frz likes this.


  6. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    upload_2019-7-27_2-13-33.png


    Thanks, Bipin Ji, Devendra Sir & JayKumar Ji
    Very Good Tdl, Addition Ledger Group Also
     
    nasir and Frz like this.


  7. Bipin Damania

    Bipin Damania Active Member


    Thank you Pankajji for Adding Cheque Number & Group.
    :)
     


  8. MZMS

    MZMS New Member


    Superb File Thanks
     


  9. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    Quick Search : yes
     


  10. V Atal

    V Atal New Member


    Can we use this for one particular group only say for example only unsecured loans. Do we need to change only collection or anything else?
     


  11. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    Many things

    Ledger Collection

    Default Report

    Customized Reports

    Variable

    Voucher Collections ,


    Almost everything..... :oops::oops:
     


  12. V Atal

    V Atal New Member


    OK Shall try. If any help required will come back here. Thank you so much!!!
     



  13. DEAR ALL
    I done this same as part of audit pack, in this file it is taking TOTAL amount of voucher I final amount after netting is ok ) but i was done and i can get net amount which was affecting only reportobject ledger.

    unexpectedly i done few changes to do more better, and i loose my that perfect code.

    NOW AGAIN TRYING AND I WILL DO IT

    IF IT IS POSSIBLE PL TRY TO SHOW DEBIT OR CREDIT AMOUNT WHICH IS ONLY FOR SELECTED LEDGER AT REPORT LEVEL.

    FOR EG.
    PRINTING STATIONARY DR 100
    CGST DR 5
    SGST DR 5
    PARTY XYZ CR 105

    IT IS NOW SHOWING IN ABOVE , AS BOTH SIDE DEBIT 5 CREDIT 105
     


  14. ranabhilai

    ranabhilai New Member


     


Share This Page