1. Create a new Fixed Assets Query
2. Choose Asset as the type
3. For the Criteria:
> Expand Summary > Select Accumulated Depreciation - Greater than 0 and on the filters tab, enter the date for the beginning amount
> Expand Summary > Select Accumulated Depreciation - Greater than 0 and on the filters tab, enter the date for the ending amount
(Ensure the connecting operator is "AND"
4. For the Output:
- If Accumulated Depreciation populated, select any other desired output. If not - Add the following
> Expand Summary > Select Accumulated Depreciation - Enter the date for the beginning amount
> Expand Summary > Select Accumulated Depreciation - Enter the date for the ending amount
5. On the Sort tab:
- Sort by any desired field
6. If the amount overtime is also needed, export to excel to find the difference