How to get periodwise depreciation on transactions
I am working on one consolidated Asset report where there is a requirement to get the opening balance, additions, deletion and closing balance period wise of gross block as well as depreciation.
I have given the logic for rest of the item, but I am badly stuck at one point to give the period wise depreciation on transactions happened during the given period( i.e. addition/retirements/write-ups etc.). Can anyone please help me in this.
I am attaching the format of the depreciation part of the report for the reference.
This is bit urgent. Looking forward to have your views.