# Fixed asset info in General Ledger custom reports **URL:** \ **Category:** Uncategorized\ **Created:** [July 3, 2019, 2:57am UTC](https://forum.manager.io/t/fixed-asset-info-in-general-ledger-custom-reports/22862 "2019-07-03T02:57:26Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![RoscoHead](https://avatars.discourse-cdn.com/v4/letter/r/43a26b/32.png) [@RoscoHead](https://forum.manager.io/u/RoscoHead)\ **Post date:** [July 3, 2019, 2:57am UTC](https://forum.manager.io/t/fixed-asset-info-in-general-ledger-custom-reports/22862/1 "2019-07-03T02:57:27Z")
Hi, I’m trying to create a custom report based on General Ledger, but there doesn’t seem to be any way to retrieve the Fixed Asset information from depreciation entries. Please help! ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [July 3, 2019, 3:08am UTC](https://forum.manager.io/t/fixed-asset-info-in-general-ledger-custom-reports/22862/2 "2019-07-03T03:08:34Z")
Apply a filter: ![36%20PM](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/9/9/99727a340365b2080325ba1c4b660195ff3c4a43.png) Note: the final field is case and spacing sensitive. ---
**Author:** ![RoscoHead](https://avatars.discourse-cdn.com/v4/letter/r/43a26b/32.png) [@RoscoHead](https://forum.manager.io/u/RoscoHead)\ **Post date:** [July 3, 2019, 12:27pm UTC](https://forum.manager.io/t/fixed-asset-info-in-general-ledger-custom-reports/22862/3 "2019-07-03T12:27:32Z")
Thanks Tut, but I was referring to adding a field to the report - for example I want to select all the depreciation entries \> given amount, and print the name of the associated fixed asset, can that be done? I couldn’t find any fields related to fixed assets in the drop down list? ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [July 3, 2019, 12:37pm UTC](https://forum.manager.io/t/fixed-asset-info-in-general-ledger-custom-reports/22862/4 "2019-07-03T12:37:36Z")
Add another filter for `Amount is greater than`. But names of individual fixed assets are not part of the general ledger transactions table. It sounds like you can obtain what you want by drilling down on the accumulated depreciation figure for a fixed asset in the Fixed Assets tab and exporting the result. ---
**Author:** ![RoscoHead](https://avatars.discourse-cdn.com/v4/letter/r/43a26b/32.png) [@RoscoHead](https://forum.manager.io/u/RoscoHead)\ **Post date:** [July 3, 2019, 12:48pm UTC](https://forum.manager.io/t/fixed-asset-info-in-general-ledger-custom-reports/22862/5 "2019-07-03T12:48:44Z")
Yes, but that means I have to drill down every asset to find the ones with matching depreciation amounts. I just thought there must be some way to do this in a report. What field in the General Ledger is the key back to the Fixed Asset table? ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [July 3, 2019, 2:01pm UTC](https://forum.manager.io/t/fixed-asset-info-in-general-ledger-custom-reports/22862/6 "2019-07-03T14:01:44Z")
Rather than trickle out information, such “ones with matching depreciation amounts,” why don’t you explain fully what you are trying to accomplish? Then someone can help. ---
**Author:** ![RoscoHead](https://avatars.discourse-cdn.com/v4/letter/r/43a26b/32.png) [@RoscoHead](https://forum.manager.io/u/RoscoHead)\ **Post date:** [July 4, 2019, 1:49am UTC](https://forum.manager.io/t/fixed-asset-info-in-general-ledger-custom-reports/22862/7 "2019-07-04T01:49:08Z")
That’s pretty much it - I want to list all the assets that have had a depreciation amount greater than a given value, to try to weed out erroneous entries. ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [July 4, 2019, 2:03am UTC](https://forum.manager.io/t/fixed-asset-info-in-general-ledger-custom-reports/22862/8 "2019-07-04T02:03:18Z")
Why not drill down on the depreciation account balance in the Summary? ---
**Author:** ![RoscoHead](https://avatars.discourse-cdn.com/v4/letter/r/43a26b/32.png) [@RoscoHead](https://forum.manager.io/u/RoscoHead)\ **Post date:** [July 4, 2019, 2:43am UTC](https://forum.manager.io/t/fixed-asset-info-in-general-ledger-custom-reports/22862/9 "2019-07-04T02:43:56Z")
Oh I see, and then sort by amount, yes that may be OK thanks. It would still be nice if it displayed the Asset Code or Name, to avoid the extra click, but I can live with that 😄 ---
**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\ **Post date:** [January 18, 2023, 3:00pm UTC](https://forum.manager.io/t/fixed-asset-info-in-general-ledger-custom-reports/22862/10 "2023-01-18T15:00:43Z")
Closed on January 18, 2023, 3:00pm UTC