(JPN) Configure and calculate fixed asset depreciation [AX 2012]

Updated: December 2, 2014

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.

NoteNote

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.

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 设置查看固定资产参数.

Define a fixed asset group by using the Fixed asset groups form. For more information, see 固定资产组(窗体).

Create a fixed asset record. For more information, see 创建固定资产.

Depreciation

Set up the following prerequisites:

  • Enable the catch-up rule for depreciation

  • Allow manual changes to the depreciation method

  • Assign the fiscal calendar to a value model

  • Set up the depreciation rate schedule

  • Set up rounding parameters for fixed asset depreciation

  • Set up a depreciation profile

  • Set up allowable limits for accumulated depreciation

For more information, see (JPN) Set up depreciation and depreciation methods.

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:

  1. Click Fixed assets > Journals > Fixed assets.

  2. In the Fixed assets form, select the fixed asset journal, and then click Lines.

  3. In the Journal voucher form, enter the required details for the voucher. For more information, see 日志凭证的固定资产 (窗体).

  4. Click Proposals > Depreciation proposal.

  5. In the Depreciation proposal form, in the To date field, enter the ending date of the period to create the depreciation profile for.

    NoteNote

    If required, you can select the Summarize depreciation check box to summarize the details of monthly depreciation amounts in one journal line.

  6. 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 固定资产余额(窗体).

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 固定资产模板(窗体), 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.

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:

  1. Click Fixed assets > Setup > Value models.

  2. Select a value model that is assigned to the fixed asset, and then click Fixed asset groups.

  3. In the Fixed asset group/value model form, click Change the fixed asset depreciation profile.

  4. 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.

  5. In the Start date field, enter the date from which the depreciation profile is effective.

  6. Select the Use equally-divided formula check box to divide depreciation amounts equally.

    NoteNote

    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.

  7. 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.

  8. Select the Update service life check box to automatically update the service life of the fixed asset.

    NoteNote

    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

  9. 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.

  10. 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.

NoteNote
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.

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:

  1. Click Fixed assets > Setup > Schedules > Undepreciated balance schedules.

  2. Click New to create a record to import the depreciation rate schedule.

  3. In the Name field, enter a name for the imported depreciation schedule.

  4. 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.

  5. 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.

  6. 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.

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:

  1. Click Fixed assets > Common > Fixed assets > Fixed assets.

  2. Select the fixed asset to view or update.

  3. Click Value models or Depreciation books and then expand the Depreciation tab.

  4. View or update the Start date off the 5 year equally divided method field.

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.


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

社区附加资源

添加
显示: