Skip to Content

Fixed Asset Reporting - How do you query OFDV

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?

fixedassetdep.jpg (35.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Jan 09 at 04:18 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded