Skip to Content
0

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

Apr 06, 2017 at 03:24 PM

141

avatar image
Rurangwa Schadrack

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
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Sort by:
avatar image
Gonzalo Gomez Answered Apr 10, 2017 at 11:21 AM
0

Details in DRN2 and accumulated in ODRN

The table FIX1 also contains all the transactions

Show 1 Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
Rurangwa Schadrack
Apr 10, 2017 at 03:03 PM

Thank you for replying,

But we want to see the value of posted depreciation.which table can we use?

0
Comment
avatar image
Gonzalo Gomez Answered Apr 11, 2017 at 03:42 PM
0

Have you reviewed the data in the tables?

DRN2 it´s your table.

Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users