Hi
I am trying fix the accuracy of the fixed asset saved search and reports in Netsuite. We are having problems with the net book value numbers. Maybe both SS and report are related to the same issue. So I first started with the SS with the below parameters
Focusing on one asset (all assets except the addition in April 21 have the same issue)
I confirmed that the original cost and depreciation is correct.
However the net book value is simply negative the April 21 depreciation.
The asset details are below:
And here is one month of depreciation history March 2021
When I looked at this initially, I noticed the account method field was blank, so I did a csv update of the depreciation histories today, populate all the history with depreciation method as accounting method, ensure the trigger workflows was ticked. I then did the precompute depreciation. Unfortunately this did not change the NBV in the SS at all. I am not even sure if this is needed?
So I am at a loss in how to fix this specific asset.
The questions I have:
Regarding the SS formula for NBV
This looks like its pointing to the transaction amount field which doesn’t seem right but I don’t understand as this is locked search, I thought it came from native netsuite bundle.
Shouldn’t the formula be referencing custrecord_deprhistbookvalue? And what is the correct formula?
This search showing it is locked. Although I appreciate I can create my own version, but I'd expect the bundle search to be correct.
Appreciate your help.
Thanks