(JPN) Generate Fixed assets reports

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2

This topic explains how to generate detailed reports about depreciated fixed assets. The details that are displayed in the report depend on the depreciation method that you use to depreciate the fixed asset, and whether the fixed asset has increased or decreased in net value.

Note

This topic does not apply to versions of Microsoft Dynamics AX 2012 prior to cumulative update 7 for AX 2012 R2.

You can generate the following reports for fixed assets annually.

Name of the report

Classification of assets

Appended Table No.16 (1)

This report contains information about the amortization calculation of depreciable assets using the new straight line method or the old straight line method.

Appended Table No. 16 (2)

This report contains information about the amortization calculation of depreciable assets using the 200% or 250% declining balance method or the old declining balance method.

Appended Table No. 16 (6)

In AX 2012 R3: This report contains information about the amortization calculation of deferred, assets using the equally divided depreciation method or by specifying depreciation amounts manually for each fiscal period.

Appended Table No. 16 (7)

In AX 2012 R3: This report contains information about the amortization calculation of low value assets using the equally divided depreciation method or by specifying depreciation amounts manually for each fiscal period.

Appended Table No. 16 (8)

In AX 2012 R3: This report contains information about the amortization calculation of lump-sum value assets using the equally divided depreciation method or by specifying depreciation amounts manually for each fiscal period.

No. 26 Form depreciable asset

This report contains details about all of the transactions for depreciable fixed assets with an increased or decreased net value.

No. 26 Form Appended Table 1

This report contains details about the transactions that increase the value of depreciable fixed assets. These transactions can be acquisitions, acquisition adjustments, revaluations that increase the value of fixed assets, or write-up adjustments.

No. 26 Form Appended Table 2

This report contains details about the transactions that decrease the value of depreciable fixed assets. These transactions can be fixed asset disposals, revaluations that decrease the value of fixed assets, or write-down adjustments.

Prerequisites

The following table shows the prerequisites that must be in place before you start.

Category

Prerequisite

Version

Microsoft Dynamics AX 2012 R3 or cumulative update 7 or later for AX 2012 R2

Country/region

The primary address for the legal entity must be in the following countries/regions: Japan

Related setup tasks

1. Generate the Appended Table No. 16 reports

Depending on the version that you are using, you can use the following forms to generate the Appended Table No.16 reports.

  • In AX 2012 R3 and cumulative update 7 or later for AX 2012 R2: Appended table 1 – Generate the Appended Table No. 16 (1) report.

  • In AX 2012 R3 and cumulative update 7 or later for AX 2012 R2: Appended table 2 – Generate the Appended Table No. 16 (2) report.

  • In AX 2012 R3: Appended table 6 – Generate the Appended Table No. 16 (6) report.

  • In AX 2012 R3: Appended table 7 – Generate the Appended Table No. 16 (7) report.

  • In AX 2012 R3: Appended table 8 – Generate the Appended Table No. 16 (8) report.

To generate the Appended Table No. 16 reports, follow these steps.

  1. Click Fixed assets > Reports > External > Corporate tax return for report series 16 > Appended table 1.

    –or–

    Click Fixed assets > Reports > External > Corporate tax return for report series 16 > Appended table 2.

    –or–

    In AX 2012 R3: Click Fixed assets > Reports > External > Corporate tax return for report series 16 > Appended table 6.

    –or–

    In AX 2012 R3: Click Fixed assets > Reports > External > Corporate tax return for report series 16 > Appended table 7.

    –or–

    In AX 2012 R3: Click Fixed assets > Reports > External > Corporate tax return for report series 16 > Appended table 8.

  2. In the Fiscal year field, select the tax declaration year to generate the report for.

  3. Click Select, and then specify the following additional criteria to select fixed asset transactions for the report.

    Field

    Description

    Major type

    The top-level classification of the asset, such as equipment, buildings, land, infrastructure, or utilities.

    Fixed asset number

    The identification number of the fixed asset.

    Value model

    The value model of the fixed asset.

    Property group

    The property group of the fixed asset.

  4. Click OK to close the form, and then click OK to generate the report.

2. Generate the No. 26 Form depreciable asset report

You can use the Form 26 - Depreciable assets form to generate the No. 26 Form depreciable asset report. This report contains details about the fixed assets that have increased or decreased in net value for a calendar year that you specify.

To generate the No. 26 Form depreciable asset report, follow these steps.

  1. Click Fixed assets > Reports > External > Form 26 - Depreciable assets.

  2. In the Calendar year field, select the calendar year to generate the report for.

  3. In the Prefecture field, select the prefecture or state where the fixed asset is located.

  4. In the City field, select the city or ward where the fixed asset is located.

  5. Select the Blue tax return check box to indicate that your legal entity files blue form tax returns.

  6. Select the Nontaxable check box to include fixed assets for which depreciation tax is not applicable.

  7. In the Office building asset number field, select the identification number of your legal entity’s office building.

  8. Click Select, and then specify the following additional criteria to select fixed asset transactions for the report.

    Field

    Description

    Fixed asset group

    The fixed asset group.

    Major type

    The top-level classification of the asset, such as equipment, buildings, land, infrastructure, or utilities.

    Fixed asset number

    The identification number of the fixed asset.

    Value model

    The value model of the fixed asset.

    Posting layer

    The posting layer that the fixed asset transactions are posted to.

  9. Click OK to close the form, and then click OK to generate the report.

3. Generate the No. 26 Form Appended Table 1 and No. 26 Form Appended Table 2 reports

You can use the Form 26 - Depreciable assets - Appended table 1 and Form 26 - Depreciable assets - Appended table 2 forms to generate the No. 26 Form Appended Table 1 and No. 26 Form Appended Table 2 reports.

Note

You can also select the Print appended table 1 and table 2 check box in the Form 26 - Depreciable assets form to generate the reports along with the No. 26 Form depreciable asset report.

To generate the No. 26 Form Appended Table 1 and No. 26 Form Appended Table 2 reports, follow these steps.

  1. Click Fixed assets > Reports > External > Form 26 - Depreciable assets - Appended table 1.

    –or–

    Click Fixed assets > Reports > External > Form 26 - Depreciable assets - Appended table 2.

  2. In the Calendar year field, select the calendar year to generate the report for.

  3. In the Prefecture field, select the prefecture or state where the fixed asset is located.

  4. In the City field, select the city or ward where the fixed asset is located.

  5. Click Select, and then specify the following additional criteria to select the fixed asset transactions for the report.

    Field

    Description

    Fixed asset group

    The fixed asset group.

    Major type

    The top-level classification of the asset, such as equipment, buildings, land, infrastructure, or utilities.

    Fixed asset number

    The identification number of the fixed asset.

    Value model

    The value model of the fixed asset.

    Posting layer

    The posting layer that the fixed asset transactions are posted to.

  6. Click OK to close the form, and then click OK to generate the report.

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 and duties

To perform this task, you must be a member of a security role that includes the following duties:

  • Inquire into fixed assets (AssetFixedAssetsInquire)

  • Review fixed assets process performance (AssetFixedAssetsProcessPerfReview)

  • Inquire into fixed asset transaction status (AssetFixedAssetTransactionStatusInquire)

Security roles and privileges

To perform this task, you must be a member of a security role that includes the Generate fixed asset reports for Japan (AssetReportsGenerate_JP) privilege.