One of the following roles is required to access this query: FinanceGL Full, FinanceGL Read.

This DAT Query returns fixed assets that are fully depreciated (Book Value equals Residual Value) as of a chosen date, excluding disposed assets. Book Value is calculated as Acquisition Price minus all depreciation scheduled through the chosen date.

The Depreciate Date is set as a DAT Parameterized Condition, allowing you to change the cutoff date on the Results screen (for example, 06/30/2026 for June 2026).

Note: To see every asset with its current book value rather than only fully depreciated assets, remove the Book Value = Residual Value condition on the Fixed Assets table.