Hello!
It seems there is no report in NetSuite that will provide depreciation expense by asset. NetSuite doesn't seem to have a depreciation expense field. NetSuite refers you to use the depreciation history log under each asset, so I created a report to pull in the FAM depreciation history for each asset for our FY 2020. However, the total FAM depreciation history for FY 2020 has a multimillion-dollar difference from FY 2020 depreciation expense on the P&L. These totals should tie. It seems depreciation expense is inaccurate in FAM so I need to write a formula to show the correct depreciation expense.
We use 4-4-5 Method and the formula is: 12*((CC-RV)/AL)*(DP/FY)
Where:
CC = Current Asset Cost
RV = Residual Value
AL = Asset Life
DP = # of Days in Period
FY = # of Days in Fiscal Year
Most of this formula I can write, except for the last two parameters (DP & FY). Could someone please provide a formula that will produce (# of days in a period / # of days in a fiscal year)?
I really need some help with this one!
Thank you!!
Mikail