Fixed Asset Reporting - How do you query OFDV

[gfeldman]

Customers often want depreciation reports and other fixed asset reports such as a disposal for period which ties to the gain/loss account in the financial statements. When looking at the Fixed Asset Values Tab on the Item Master and look at system information, you can see that the values in this tab are stored in a table OFDV

OFDV, AcqCost, DprVal and NBV would be the fields required for this type of reporting, but they do not appear available in the Query Window.

Are these tables available? How do you create a report against them?

[narayanis]

Hi,

Please check for FIX1 table

[Abdul]

I did a report tin past and used below tables

OITM (Master data)

ITM7 (Dep Info)

ITM8 (Dep and Periods)

ODRN (Dep Run Info)

DRN2 (Dep Run Info)

OACS (Asset Class)

[gfeldman]

FYI - I have found the following through SDN

There are multiple tables with depreciation information ITM7 – Depreciation class information ITM8 – Depreciation total information ODPV – Depreciation posting information.

ITM8 and ODPV appear to be equivalent (or the same), but neither have acquisition value.

[gfeldman]

ODPV appears better for getting monthly posting where ITM8 appears better for getting accumulated values as of a period.

[zal_parchem2]

Thanks for the information, Gary - that is some good stuff!!!

I LIKE it - Zal

&;-D

[former_member794521]

did you get the values for APC, Deprecation, NBV?