I need to add a depreciation module onto an existing Asset Database.
I have an asset table where I want all the data stored, so that I can run all reports etc from that one table.
This table will have 2forms, one for the input of asset details, and another for the accountants to enter the depreciation details.
As such I want to run the following calculations to return the required info for the stated fields
Calculations are:
Months Remaining = (depreciation period)-(months depreciated)
Depreciation to Date = (Purchase price)/(Depreciation period)x(Months depreciated)
Netbook Value = (Purchase Price)-(Depreciation to Date)
Obviously one or more of these calculations has a knock on affect to one or more of the other fields.
And I was wanting to return all the calculation results to the Asset table.
Also I need the depreciation to become automated after its intial input.
Therefore I need the database to know what the date is and to update figures every month.
i.e The computer realizes the date is 30-01-03 and that the (Depreciation Start) was 30-06-02 and so returns the (months depreciated) as 7
I know there is a lot involved in all this but it is the usual scenario, know what I want to do but very little time to get there.
Any assistance in all or any of these issues would be great!
I have an asset table where I want all the data stored, so that I can run all reports etc from that one table.
This table will have 2forms, one for the input of asset details, and another for the accountants to enter the depreciation details.
As such I want to run the following calculations to return the required info for the stated fields
Calculations are:
Months Remaining = (depreciation period)-(months depreciated)
Depreciation to Date = (Purchase price)/(Depreciation period)x(Months depreciated)
Netbook Value = (Purchase Price)-(Depreciation to Date)
Obviously one or more of these calculations has a knock on affect to one or more of the other fields.
And I was wanting to return all the calculation results to the Asset table.
Also I need the depreciation to become automated after its intial input.
Therefore I need the database to know what the date is and to update figures every month.
i.e The computer realizes the date is 30-01-03 and that the (Depreciation Start) was 30-06-02 and so returns the (months depreciated) as 7
I know there is a lot involved in all this but it is the usual scenario, know what I want to do but very little time to get there.
Any assistance in all or any of these issues would be great!
