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

This DAT Query returns fixed assets that are fully depreciated as of a chosen date, meaning their Book Value equals their Residual Value. Book Value is calculated as Acquisition Price minus all depreciation scheduled through the chosen date. Assets with a disposal date are excluded.

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 the book value of every asset as of the chosen date, rather than only fully depreciated assets, remove the Book Value = Residual Value condition on the Fixed Assets table. Assets with no depreciation scheduled on or before the chosen date do not appear in either case.