DEAR ALL,
I M CREATING FA ADDITION REPORT
The following values required
1)major category
2) Minor category
3) asset number
4)Description
5)addition date
6) Depreciation Rate
7)net book value
I am using these table
and joins:-
fa_books b,
fa_categories cat,
fa_distribution_history his,
fa_locations l,
fa_deprn_summary summ,
fa_additions adv
WHERE b.asset_id=adv.asset_id
AND ADV.asset_category_id=cat.category_id
AND his.location_id=l.location_id
AND his.asset_id=adv.asset_id
AND summ.asset_id=adv.asset_id
AND summ.deprn_run_date=(select max(deprn_run_date) from fa_deprn_summary summ1
where summ1.asset_id=summ.asset_id)
AND b.cost>0
but I found some duplicate records as well as net_book_value and cost are wrong as they shown in application
what is net book value formula and actual addtion cost.
pl reply me
Thanks
AND cat.segment1 = :asset_type
AND summ.deprn_run_date BETWEEN :start_date and :end_date
ADDITION REPORT
Who is online
Users browsing this forum: No registered users and 0 guests