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
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.
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
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
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.
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..........
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
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)
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]
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.
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.
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!
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.