Which table can I use to see the accumulated depreciation for new assets? I run my report for fixed assets but I don't see the accumulated depreciation for assets which were sold in current fiscal year. I only see accumulated depreciation for previous fiscal year.
The following is my query
select distinct OITM.ItemCode,OITM.ItemName,case when ITM8.APC=0 then ACQ1.LineTotal else ITM8.APC end as APC,ACQ1.LineTotal,OLCT.Location,OITM.AssetClass,OITM.CapDate, ITM8.OrDpAcc,ITM7.UsefulLife,ITM7.PeriodCat,ITM8.PeriodCat from ITM7,ITM8,ACQ1 right join OITM on ACQ1.ItemCode=OITM.ItemCode left join OLCT on OLCT.Code=OITM.Location where OITM.ItemCode=ITM7.ItemCode and OITM.ItemCode=ITM8.ItemCode and NOT EXISTS (select ItemCode from RTI1 WHERE OITM.ItemCode=RTI1.ItemCode) and ITM7.PeriodCat='2017'
ITM7.PeriodCat='2017' is parameter but the problem found in 2017 or current year.
Please anyone can help me.
Details in DRN2 and accumulated in ODRN
The table FIX1 also contains all the transactions
Thank you for replying,
But we want to see the value of posted depreciation.which table can we use?
Have you reviewed the data in the tables?
DRN2 it´s your table.