Hi Gurus!
I have a situation I am hoping you can help with! :)
(Btw, if we could use colors and more highlighting/underlying and text size, etc., it would be a great way to accentuate things here.)
Scenario:
I uploaded the asset and everything looks good.
I then uploaded the depreication history and used the following fields - showing here most relevant fields:
Internal ID = from above uploaded asset that NS created.
Cumulative depreciation
Last depreciation date (cutoff date when it was depreciated last)
Last depreciation period = this should be the sum of all periods in which depreciation took place. For example, if asset is depreciated for 1 year and 3 months, this number will be 15.
Problem:
FAM calculates monthly depreciation correctly for all month but the last depreciation date month (cutoff date month).
NS uses the cumulative amount and puts it in the last depreciation period (cutoff month) as the period's amount.
As a result, depreciation is more by the amount of cumulative depreciation. So, essentially, cumulative depreciation is doubled.
Screenshot:
In my screenshot below, 12/31/22 is the last depreciation date (cutoff month).
It puts the cumulative depreciation there.
All other months, from beginning depreciation till future end depreciation date are correct.
Any thoughts why this happens?
As a result, asset register is wrong, of course, and NBV at the end of entire depreciation span is negative and equals the cumulative depreciation. See below.