Does anyone know how I can get the calculation in a generic inquiry for a fixed asset? Currently, the calculation is only shown in the asset depreciation history, which you must look at each individual asset.
Generic Inquiry for Calculation only Fixed Asset Module
Hi
Try looking at this older post in the community, it may help:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/c079f0f0-4fc4-435c-8021-9e1f692dadb1.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/29c3ebc5-450a-4a45-949b-a93ea372ba49.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/9284febf-e99b-4b79-953b-fd611ef3b166.png)
Hi
The Asset Transaction History doesn’t seem to provide calculations as far as I can tell.
It is a built-in inquiry which means you can’t copy it or modify it, but the table it uses for the grid data is the Transact table and loading this into a GI will show all the same data which is seen in the grid of the inquiry screen.
Can you further clarify where these calculations are?
Thanks!
Hello
I think
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/723e8342-3768-4632-985b-e0390cd849f6.png)
Thank you
Calculating history could be tricky and may need to bring in either the FAHistoryByPeriod or FABookHistoryByPeriod, but it looks like our DAC Overview for Fixes Assets in help isn’t working (normally would be here: https://help-2022r1.acumatica.com/(W(4))/Help?ScreenId=ShowWiki&pageid=187bfcda-3612-6e4f-4c9f-aabd96a9da15).
In order to make use of these tables you can join them to the current FABook or FixedAsset table:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/13f2a381-a1b0-4072-93ac-eee87413d8bd.png)
These will store balances by period and may be necessary to calculate the depreciation
Hello
Thanks for all the comments
I am taking about the calculation of the depreciation only. It is on history. I need a GI to show just
calculated depreciation, but I can’t find the table that includes the calculated field
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/02028855-2880-45c3-80ae-9b4d1fed38f4.png)
This part of the Fixed Asset screen uses FASheetHistory but this table in itself is not usable and needs to be joined to another table and then calculated from there.
It looks like it is probably FATran or FARegister which is being linked to, but also FAHistoryByPeriod will have the period which can link to the transaction to pull the transaction amount showing there.
Thank you for your help. I will try it.
That sounds super great. Thank you for saving me a lot of time.
I tried the book history, but it looks like it duplicates. The balance history actually shows from the year it was receipted to the end of depreciation, so that is what it is doing. See screenshot
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/4788bf31-e4d6-4193-96c1-36bdc7ed3736.png)
I might try only PTD to see that helps.
I tried the book history, but it looks like it duplicates. The balance history actually shows from the year it was receipted to the end of depreciation, so that is what it is doing. See screenshot
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/4788bf31-e4d6-4193-96c1-36bdc7ed3736.png)
I might try only PTD to see that helps.
Thank you. I got it to work by using the book for filtering. Thanks
FABookHistory may show a different PtdCalculated value from what you see on the Asset profile for that period. If it is the first period Acumatica is calculating for an imported Asset, and the configurations/methods deployed come up with a different amount for Accumulated Depreciation through the period, Acumatica will +/- accordingly to get the Asset to the correct Accumulated Depreciation.
The FABookHistory does not store this adjusted calculation, it stores only the base calculation.
GI for Calculate-Depreciation
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.