Skip to Content
avatar image
Rurangwa Schadrack

​Which table can I use to see the accumulated depreciation for new assets in SAP B1 query?

Apr 06, 2017 at 03:24 PM | 264 Views

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.

SAP Business One
SAP Business One SDK | sdk | sdk 3.0
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Gonzalo Gomez
    Apr 10, 2017 at 11:21 AM

    Details in DRN2 and accumulated in ODRN

    The table FIX1 also contains all the transactions

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Gonzalo Gomez
    Apr 11, 2017 at 03:42 PM

    Have you reviewed the data in the tables?

    DRN2 it´s your table.

    Add comment
    10|10000 characters needed characters exceeded