(JPN) Configure and calculate fixed asset depreciation
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2
After you set up depreciation methods and allowable limits for depreciation, you can create a depreciation proposal that depreciates the asset and calculates the monthly depreciation expenses.
Nota
This topic does not apply to versions of Microsoft Dynamics AX 2012 prior to cumulative update 6 for AX 2012.
To depreciate a fixed asset, you can change the fixed asset depreciation profile to one that uses a different depreciation method. You can then import a depreciation rate schedule to calculate the undepreciated balances and update the service life of the fixed asset.
Prerequisites
The following table shows the prerequisites that must be in place before you start.
Category |
Prerequisite |
|---|---|
Related setup tasks |
Set up basic fixed asset parameters, such as a default value model, reason codes, and number sequences, by using the Fixed assets parameters form. For more information, see Configuración de parámetros de activos fijos. Define a fixed asset group by using the Fixed asset groups form. For more information, see Grupos de activos fijos (formulario). Create a fixed asset record. For more information, see Crear un activo fijo. |
Depreciation |
Set up the following prerequisites:
For more information, see (JPN) Set up depreciation and depreciation methods. |
1. Depreciate a fixed asset
Use the Depreciation proposal form to create a depreciation proposal to depreciate a fixed asset. After you run the depreciation proposal, you can view the posted depreciation amounts and the planned depreciation amounts for the fixed asset.
To depreciate the fixed asset, follow these steps:
Click Fixed assets > Journals > Fixed assets.
In the Fixed assets form, select the fixed asset journal, and then click Lines.
In the Journal voucher form, enter the required details for the voucher. For more information, see Asiento del diario - Activos fijos (formulario).
Click Proposals > Depreciation proposal.
In the Depreciation proposal form, in the To date field, enter the ending date of the period to create the depreciation profile for.
Nota
If required, you can select the Summarize depreciation check box to summarize the details of monthly depreciation amounts in one journal line.
Click OK to generate the depreciation proposal and close the form.
You can use the Fixed asset balances form to view the depreciation amounts that are posted. For more information, see Saldos de activo fijo (formulario).
If you want to view the planned depreciation amounts for the fixed asset value model, you can do so in the Profile form. You can also view a timetable for planned depreciation if you specified the number of years to use to equally divide depreciation amounts in the Number of years to equally divide depreciation amounts field in the Depreciation profiles form.
For more information about the fields that are available in the Profile form, see Perfil de activos fijos (formulario), and the following table:
Field |
Description |
|---|---|
Beginning balance of accumulated depreciation |
The beginning balance of the accumulated depreciation from the start of the fiscal period for the selected date. |
YTD value of accumulated depreciation |
The sum of the depreciation expenses that are incurred from the beginning of the year for the selected date. |
Period |
The name of the fiscal period. |
From date |
The starting date of the period. |
To date |
The ending date of the period. |
Number of months |
The number of months in the selected period. |
Number of remaining months |
The number of months that remain for depreciation in the selected period. |
2. Change the depreciation profile for a fixed asset
Use the Change fixed asset depreciation profile form to change a fixed asset depreciation profile. You can change the depreciation profile to one that uses a different depreciation method to depreciate the asset.
If necessary, you can also use this form to specify whether to update the service life of the fixed asset. The service life of the asset is updated depending on the change of depreciation method that is applied to the fixed asset.
The following table shows the depreciation method changes that are allowed:
Starting depreciation method |
Allowed depreciation method change |
|---|---|
Old straight line |
Old declining balance |
Old declining balance |
Old straight line |
New straight line |
250% declining balance –or– 200% declining balance |
250% declining balance |
200% declining balance –or– New straight line |
200% declining balance |
250% declining balance –or– New straight line |
To change the depreciation profile for a fixed asset, follow these steps:
Click Fixed assets > Setup > Value models.
Select a value model that is assigned to the fixed asset, and then click Fixed asset groups.
In the Fixed asset group/value model form, click Change the fixed asset depreciation profile.
In the Change fixed asset depreciation profile form, in the To depreciation profile field, select the depreciation profile that uses the depreciation method that you want to change to.
In the Start date field, enter the date from which the depreciation profile is effective.
Select the Use equally-divided formula check box to divide depreciation amounts equally.
Nota
This field is available only if you are changing from a depreciation profile that uses the Old declining balance depreciation method to a depreciation profile that uses the Old straight line depreciation method.
In the Number of years for equally-divided formula field, enter the number of years that the remaining depreciation amounts should be equally spread across.
Select the Update service life check box to automatically update the service life of the fixed asset.
Nota
This check box is available only if the Use equally-divided formula check box is not selected and if you are performing the following changes to depreciation methods:
-
Old declining balance to Old straight line
-
250% declining balance to New straight line
-
200% declining balance to New straight line
-
250% declining balance to 200% declining balance
-
Select the Always allow the depreciation method to be changed check box to allow a depreciation method change even when the accumulated depreciation is more than 95 percent of the acquisition cost and the equally divided formula is used to recalculate the depreciation amounts when you run the depreciation proposal.
Click Apply to recalculate the depreciation amounts and service life by using the depreciation method from the depreciation profile that you selected in the To depreciation profile field.
For more information about the fields on the Change fixed asset depreciation profile form, refer to the following table:
Field |
Description |
|---|---|
From depreciation profile |
The depreciation profile that is currently used to depreciate the fixed asset. |
Selected depreciation profile |
The depreciation profile that is displayed in the From depreciation profile field. |
End date |
The ending date of the period during which the depreciation profile is effective. |
Net book value |
The net book value of the fixed asset as of the depreciation profile switch date. Nota When this field was stored, it does not change automatically any more. Under unusual use cases when a transaction is posted on a date before the Start date, this field will still not change. The workaround is to calculate the new correct net book value and update the field manually. For this scenario, regardless of whether the user has updated this field on the form, future calculations will always consider the newly posted transaction. |
3. Import a depreciation rate schedule to recalculate depreciation balances and update the service life
After you change the depreciation method for the fixed asset, you can use the Undepreciated balance schedule for fixed assets form and the Years passed schedule for fixed assets form to import depreciation rate schedules. This depreciation rate schedule is used to recalculate depreciation balances and to update the service life of the fixed asset. You can import a Microsoft Excel file that contains the calculation rates for depreciation balances and the updated service life of the fixed asset. You can determine which of these forms to use depending on the depreciation method change that you apply to the fixed asset.
The following table provides details about the forms and the scenarios in which they can be used to import the depreciation rate schedule:
|
Form name |
Change of depreciation method |
|---|---|
|
Undepreciated balance schedule for fixed assets |
Old declining balance to Old straight line |
|
250% declining balance to New straight line |
|
|
200% declining balance to New straight line |
|
|
Years passed schedule for fixed assets |
250% declining balance to 200% declining balance |
To import a depreciation rate schedule by using the Undepreciated balance schedule for fixed assets form, follow these steps:
Click Fixed assets > Setup > Schedules > Undepreciated balance schedules.
Click New to create a record to import the depreciation rate schedule.
In the Name field, enter a name for the imported depreciation schedule.
In the From method field and To method field, select the starting and ending depreciation methods that are applied to the fixed asset. The undepreciated balances and service life of the fixed assets to which this change of depreciation profile is assigned are updated based on the depreciation rate schedule that you import.
Click Import from Microsoft Excel to open the Excel file that contains the depreciation rates for the fixed assets. You must publish the Excel file to Microsoft Dynamics AX to import the depreciation rates into the Undepreciated balance schedule for fixed assets form.
On the Overview FastTab, you can view the details about the depreciation rate schedule in the following fields:
Service life – The service life of the fixed asset in years.
Upper limit – The maximum depreciation rate for the fixed asset.
Lower limit – The minimum depreciation rate for the fixed asset.
Years passed – The number of years that have passed before the depreciation method is changed.
You can follow steps 2 through 6 in this procedure to import the depreciation rate schedule by using the Years passed schedule for fixed assets form. Click Fixed assets > Setup > Schedules > Years passed schedules to open the Years passed schedule for fixed assets form.
4. View or change the start date of 5 year equally divided depreciation
In the fiscal years after 2008, when the accumulated depreciation for a fixed asset with old straight line or old declining balance methods reaches 95% of the acquisition cost, the net book value of the fixed asset is permitted to be depreciated to 1 Yen in 5 years with equal amount for each of the 5 years. The 5 years of equal amount depreciation is referred to as the 5 year mode. The entering of the 5 year mode has been built-in to the depreciation logic of Microsoft Dynamics AX. When you migrate fixed assets into Microsoft Dynamics AX, you must manually enter the start date for any fixed assets that are already in the 5 year mode.
To view or update the start date of the 5 year mode, follow these steps:
Click Fixed assets > Common > Fixed assets > Fixed assets.
Select the fixed asset to view or update.
Click Value models or Depreciation books and then expand the Depreciation tab.
View or update the Start date off the 5 year equally divided method field.
Related tasks
Tipos de transacción de activos fijos
Configuración básica de Activos fijos
Registro y diarios de activos fijos
(JPN) Fixed asset depreciation
Technical information for system administrators
If you don't have access to the pages that are used to complete this task, contact your system administrator and provide the information that is shown in the following table.
Category |
Prerequisite |
|---|---|
Configuration keys |
Ensure that the Asset configuration key is available under the Data Dictionary > Configuration Keys node in the Application Object Tree. |
Security roles |
To perform this task, you must be a member of the SYSADMIN security role. |