ADDITION REPORT

[alamaijaz]

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

[Atif]

Hi
for duplication, check if the assets are assigned to employees or not,if Yes then u need to join fa_distribution_history a with per_all_people_f b
a.assigned_to = b.person_id
Also check for date_ineffective field
Atif