Scenario:
You are migrating the Mid-life Assets into the system. You performed the CSV import of the Asset itself as per our SuiteAnswers, nevertheless, the Net Book Value is showing the wrong information.
See below my example of the Mid-life Asset FAM000247 with the following information:
Asset Original Cost: 3000
Asset Current Cost: 3000
Net Book value: 2850
Last Depreciation Period: 3
Last Depreciation Amount: 50
As you can see, Asset Net Book Value is in the report wrong. Instead of 2850 is 3000 USD.
Solution:
Without other our interaction, the system cannot automatically recognize, that we have already depreciated 150 USD in a previous system. For the Report purposes the system is looking into the Depreciation History Record, as we do not have any Depreciation History for the Historical Data yet, the system is taking the information from the Acquisition. Because it is the only record available in the Depreciation History, at the moment.
In consequence of it, we need to perform one of the following steps:
- Best way and most common is CSV Import of Depreciation History Records. Perform the CSV import as per our SuiteAsnwers # 92523 - Fields Required for CSV Import for Fixed Asset Depreciation History
- Manually create Deprecation History record. It can be created for all historical cumulative depreciation amount in one record, or you can create more records for each month/period as per your needs.
To create Depreciation History record manually, please, follow the steps below:
- Open your Mid-life Asset
- Click on Depreciation History tab
- Click on Depreciation Histories link
- Edit Acquisition record and set all necessary fields:
- Transaction Type: Depreciation
- Date
- Transaction Amount
- Net Book Value
- Quantity
- Make sure to click on Save As!
Results:
Our generated Asset Register Report is now showing the correct information. System was updated with the historical data.
I hope, this is helpful. Please, share with us your own experience. We encourage you to post it here in the Community. :-)