pnjones
Posts: 42
|
| Posted: 09/06/2006, 4:37 PM |
|
I am currently working on an asp based asset register based on ccs and i am looking for report inspiration. Does anyone have any sample online asset register / reports which they can share or sell ?
Thanks
_________________
Regards
Pat |
 |
 |
Edd
Posts: 547
|
| Posted: 10/19/2006, 1:53 AM |
|
Start with
http://sourceforge.net/search/?type_of_search=soft&words=Asset+Register
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|
charles
Posts: 59
|
| Posted: 10/19/2006, 7:31 AM |
|
What do you mean by report inspiration?
I have a working Asset register in a system i designed with CCS.
If you have any specific question i will be glad to share the little i know.
Regards,
Charles
|
|
|
|
pnjones
Posts: 42
|
| Posted: 10/19/2006, 1:04 PM |
|
Thanks Edd
Charles - I suppose depreciation scheudles listing of assets by department with depreciated values user filtered reports on assets - do you have a demo of your system online ?
_________________
Regards
Pat |
|
|
|
charles
Posts: 59
|
| Posted: 10/19/2006, 9:11 PM |
|
Well it depends on the structure of your main asset table.Since i don't know how you have designed your asset and related tables, i can only give you an idea of how i went about it.
To calculate depreciation,i created two queries/views in the database.The first query looks like this
asset schedule query
SELECT asset.Asset_id, asset.AssetIDNumber, asset.AssetName, accounts.account_name, asset.Account_no, asset.AssetYear, asset.AssetCategory, asset.assetusedate, asset.AssetPurchaseValue, asset.AssetPurchaseDate, asset.company_id, DATEDIFF(mm, asset.AssetPurchaseDate, GETDATE()) AS age, (asset.AssetPurchaseValue-asset.AssetSelAmount)/asset.AssetYear AS dep_month
FROM asset INNER JOIN accounts ON asset.Account_no=accounts.account_no;
assetschedule2 query
SELECT Asset_id, AssetIDNumber, assetname, assetpurchasedate, assetpurchasevalue, age, account_name, dep_month, dep_month*age AS total_dep, AssetPurchaseValue-dep_month*age AS current_value
FROM asset_schedule;
I then used grid and report builders in CCS to generate my report.
I must tell you that the really issue is how well you designed theDB for the asset Register.
Once you get the DB design right, you generate almost any report you need using grid and especially report builders in CCS.
Pls feel free to ask any further questions.
Regards,
charles
|
|
|
|
|
