Depriciation Chart for Tally FREE

Discussion in 'Free Source Codes' started by Shamsher Singh, Sep 8, 2015.

    
?

Are you need Depreciation chart in Tally?

  1. Yes

  2. No

  3. Not Sure

Multiple votes are allowed.
Results are only viewable after voting.
  1. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    Nice

    File not rcd.

    use filter in sub collection
    Also note that, we have to take Purchase and sales figures from your udfs, right now they are not coming from udf,

    and also need to develop a function to get value of Purchase and Sales transaction during a particular period.

    Example: FromDate to ToDate of $PurchaseofFAAmount




    Filter : Name in Group collection = Parent Name of Ledger in Exploded Collection
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Duly noted..... Sales and Depreciation are coming from UDF.........not purchase.
    I checked and double checked.....when during entry if you don't specify that it is SALES then it won't show....but upon specifying...it shows.....same with depreciation.............. only Purchase UDF needs to be worked over.....am onto it.

    About function.....Purchase is already broken as per period...1st half and 2nd half...... for Sale it is not required as per Income Tax Act for Depreciation. Because as per IT rules....depreciation is applicable only on BLOCK of ASSETS existing as on beginning of year. and for Purchases it is necessary to split for half-dep or full-dep.

    Am I right or am I missing your point about the requirement of a function??? Kindly clarify if I am wrong.
     


  3. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    Nice

    File not rcd.

    use filter in sub collection
    Also note that, we have to take Purchase and sales figures from your udfs, right now they are not coming from udf,

    and also need to develop a function to get value of Purchase and Sales transaction during a particular period.

    Example: FromDate to ToDate of $PurchaseofFAAmount




    Filter : Name in Group collection = Parent Name of Ledger in Exploded Collection


    You are right.. but we should have the functionality to do it.. if we want to take purchase figures from UDF, we need to build this function
     



  4. Dear Amit Kamdar, its really looking great but while i am trying field value for Depreciation entry passed (in the books) getting blank. Values are not getting in the report.

    Thank You
     


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Duly noted....Work in progress.......will apprise on the revision.......
     
    zakirhossain_diu likes this.




  6. good work sir,

    but i found an issue by checking this images

    amount of depreciation is shown in sale colum

    please correct me if i m wrong.
     


  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Not possible in the TDL associated with the image you are referring to........

    Also subsequently there has been upgrade to the TDL..........in later posts..........
     


  8. ITs Gen X

    ITs Gen X New Member


    Good Job
     


  9. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Enable it from F11
     


  10. Frz

    Frz Member


    Amitji
    Great work!!

    if we don't pass the financial year end entry, balance still shows [figure: capture]
    also, it takes into account all assets [figure: capture1]
    inducing differed tax
    even if it is set as no in Ledger creation [figure: capture2]
    Regards
    Frz
     

    Attached Files:



  11. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Explain to me how it is working ????

    Refer Capture1.jpg....for FY 18-19 (CCTV camera) 2nd item..... 15769/- is opening balance, addition is 7500/- = total is 23269/-... and estimated Depreciation is 4358/- and so IF depreciation is passed then opening of next year should be 18911/-

    Refer Capture.jpg..... for 1st April, 19 onwards......... opening balance is 23269/- (without DEP effect)
     


  12. Frz

    Frz Member


    the depriciation entries are not yet passed
    the capture.jpeg & capture1.jpeg is to show, that even if we have not passed any depriciation entry for fy18-19 [capture.jpeg], it is still showing in fy19-20 [capture.jpeg]
     


  13. Frz

    Frz Member


    A
    Amitji
    have you been able to look at capture3.jpeg?
    Rgds
    Frz
     


  14. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Where is Capture3.jpeg ?????

    And it is working, so there is no need to see further............This is a Depreciation Table..... will show you details of DEP?

    But If entry is not passed in the books, then it will carry forward the gross figure of assets, which it is doing. You should check my previous explanations.

    And this is an old TDL.........just basic...... I've enhanced it substantially and it will pass entry at year end automatically.
     


  15. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    My Final product is here.........

    I have 2 variants...........preview attached
     

    Attached Files:

    Philip Fernandes likes this.


  16. madhu.vukyam

    madhu.vukyam New Member


    What is the cost sir
     


  17. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    Share your final code with me.. :);):(:mad::confused::cool::oops::rolleyes:..


    Nice Work.. great .. and Beautiful Reports..
     


  18. Rabiya Ahmed

    Rabiya Ahmed New Member


    De
    Amit Sir,

    Pls mail me mum8415@gmail.com
     


  19. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Sorry.....but it is not for sale .......

    Free version is available ..... I've modified the same extensively for my Client's purposes. You too can try to do the same.
     
    Rabiya Ahmed likes this.


  20. YRRao

    YRRao New Member


    Wonderful work Mr.Anil Kamdar. It seems, you put a very tough time to this Coding work that's why successful coding result is seen at the end. GREAT!
     


  21. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Yes...very true words ..... The feeling is great after you achieve what you need and wholeheartedly do it on your own.

    Of course, this was my first big code and experts from here helped me when in trouble. Would not have been possible without them.
     



  22. WHERE I CAN GET THIS TDL?
     


  23. mpal2311

    mpal2311 Active Member


    Good Job
     


  24. Philip Fernandes

    Philip Fernandes New Member


    Can you please help to get a ODBC compliant depreciation chart
     

    Attached Files:



  25. vishnu joshi

    vishnu joshi Member


    what help you want ?
     


Share This Page