Fixed assets roll forward report

The Fixed assets roll forward report provides, in an easy-to-read Microsoft Excel format, the detailed fixed asset data that you require for period closing, financial statements, and tax reporting. The report includes start and end balances for fixed assets, together with valuation movements for the period, and any new asset acquisitions and disposals that occurred during the period. Data is reported for individual fixed assets, and values are also summarized for fixed asset groups and the legal entity.

The Fixed assets roll forward report uses the Electronic reporting (ER) framework. Before you can run the report, you must import the Fixed assets model and Fixed asset roll-forward configurations from Microsoft Dynamics Lifecycle Services (LCS). For instructions, see Download Electronic reporting configurations from Lifecycle Services.

The following table describes the fields that are available on the report.

Field	Description
Balances: Opening	The fixed asset net book value as of the "from" date that you specify on the report.
Balances: Closing	The fixed asset net book value as of the "to" date that you specify on the report.
Acquisitions: Opening value	The sum of all transactions of the Acquisition and Acquisition adjustment types up to the "from" date that you specify on the report.
Acquisitions: Period acquisitions	The sum of all transactions of the Acquisition and Acquisition adjustment types that you posted during the date range for the report.
Acquisitions: Period disposals	The sum of all acquisition reversals that you posted that had a disposal transaction during the date range for the report.
Acquisitions: Closing value	The sum of all transactions of the Acquisition and Acquisition adjustment types up to the "to" date that you specify on the report.
Depreciations: Opening value	The sum of all transactions of the Depreciation, Depreciation adjustment, Special depreciation allowance, and Extraordinary depreciation types up to the "from" date that you specify on the report.
Depreciations: Period depreciations	The sum of all transactions of the Depreciation, Depreciation adjustment, and Extraordinary depreciation types that you posted during the date range for the report.
Depreciations: Period special depreciations	The sum of all transactions of the Special depreciation allowance type that you posted during the date range for the report.
Depreciations: Period disposals	The sum of all depreciation reversals that you posted that had a disposal transaction during the date range for the report.
Depreciations: Closing value	The sum of all transactions of the Depreciation, Depreciation adjustment, Special depreciation allowance, and Extraordinary depreciation types up to the "to" date that you specify on the report.
Write-ups/Write downs: Opening value	The sum of all transactions of the Write up adjustment, Write down adjustment, and Revaluation types up to the "from" date that you specify on the report.
Write-ups/Write downs: Period write ups	The sum of all transactions of the Write up adjustment type that you posted during the date range for the report.
Write-ups/Write downs: Period write downs	The sum of all transactions of the Write down adjustment type that you posted during the date range for the report.
Write-ups/Write downs: Period revaluations	The sum of all transactions of the Revaluation type that you posted during the date range for the report.
Write-ups/Write downs: Period disposals	The sum of all write-up, write-down, and revaluation reversals that you posted that had a disposal transaction during the date range for the report.
Write-ups/Write downs: Closing value	The sum of all transactions of the Write up adjustment, Write down adjustment, and Revaluation types up to the "to" date that you specify on the report.
Disposals: Disposal date	The disposal date for the fixed asset book.
Disposals: Net book value at disposal	The net book value of the fixed asset book at the time of disposal.
Disposals: Sale value	The sales value for the fixed asset book with a disposal – sale transaction.
Disposals: Scrap value	The scrap value for the fixed asset book with a disposal – scrap transaction.
Disposals: Profit/Loss	The profit or loss value that is calculated as part of the disposal transaction for the fixed asset book.