Search
Image Pexels.com
Secure your acquisitions and automate your depreciation allowances in Business Central!
Secure your acquisitions and automate your depreciation allowances in Business Central!

Acquisition, historical data import, and depreciation processing under Dynamics 365 Business Central

Published on 11/20/2026  |  Project management  |  Post read 186 times  |  Read in 4,68 Mn  | Article 4 of 4  | Fixed Assets

Index toggle


Following the configuration of depreciation rules and the setting up of accounting rules, the operational deployment of the Fixed Assets module begins with the recording of incoming flows. The entry of an asset into the company's balance sheet marks the starting point of the fixed asset lifecycle in Microsoft Dynamics 365 Business Central. This process encompasses the initial financial allocation, the import of historical data during the go-live phases, and the automatic execution of recurring depreciation processes.

1. Methods of Accounting for Acquisition Cost

Recording the acquisition cost of a fixed asset is done via two separate channels depending on the nature of the transaction and the company's purchasing workflow.

A. Direct accounting via purchase document (Purchase Orders & Invoices)

When an asset is acquired from a third party, the transaction is recorded directly on a line item in the purchase document:

  • The “Type” field is set to “Fixed Asset”.
  • The number of the asset in question is entered in the “No.” field.
  • On the line, the allocation of the amount feeds the debit of the balance sheet account (Class 2) associated with the accounting group of the asset as soon as the document is validated.
  • In the event of multiple acquisitions of identical equipment, the “Fixed asset record number” field allows for the automatic generation of duplicate asset records during validation.
Image Pexels.com
Fixed Asset Purchase Invoice
Fixed Asset Purchase Invoice

B. Entry via Fixed Asset Accounting Sheet (FA G/L Journal)

When the acquisition results from an internal contribution, capitalization of work, or a direct adjustment without a supplier document, the transaction is validated via the "Fixed Asset Accounting Sheet". The "Fixed Asset Accounting Type" field is then set to "Acquisition Cost".

The choice of the offsetting account is adapted to the economic nature of the transaction. The allocation is made directly on the entry line using the “Opposing Account Type” field:

  • Cash Purchase: Selection of a bank or treasury account (Class 5).
  • History resumption or start-up: Use of a suspense account or contribution resumption account to settle opening entries.
  • Capitalized production: Allocation to an asset production revenue account (Class 72) when the asset is produced internally by the company.
Image Pexels.com
Real estate acquisition accounting sheet
Real estate acquisition accounting sheet

2. Resumption of historical data and opening transactions

When the module is put into service on an existing environment, the transfer of net book value (NBV), initial acquisition costs and accumulated depreciation is orchestrated using import configuration packages.

Preparation of the import matrix

A configuration package targeting the fixed asset sheet lines table (Table 5621) is exported to Excel.

Integration of opening values

For each asset in the portfolio, two lines are entered in the file:

  • A line of type “Acquisition cost”bringing the historical gross amount.
  • A line of type “Depreciation”bearing the cumulative total of previous allocations (expressed as a negative amount).

Application of the package and validation

Once the file has been re-imported and the data applied to the auxiliary sheets, validation is performed to generate the opening entries.

3. Execution of the batch process "Calculate Depreciation"

The calculation of periodic (monthly or annual) depreciation allowances is fully automated by the application engine via the “Calculate depreciation” batch processing.

Batch processing settings

When the process is launched, the following options are configured:

  • Depreciation Law: Selection of the accounting book relevant to the calculation.
  • Depreciation end date: Stop date up to which depreciation is calculated.
  • Fixed asset accounting date & Accounting date: Dates assigned to the generated sheet lines (must be identical if equality control is enabled on the law).
  • Document No. & Entry Description: References assigned to future entries in the General Ledger.
Image Pexels.com
Depreciation calculation
Depreciation calculation

Generating and validating the sheets

Following the calculation, proposal lines are automatically created in the “Fixed Asset Accounting Sheet” (for integrated accounting systems) or in the “Fixed Asset Sheet” (for non-integrated accounting systems). The amounts calculated “pro rata temporis” according to the method defined on each sheet are presented there for review before final validation in the accounting system.

Image Pexels.com
Fixed Asset Sheet “Depreciation”
Fixed Asset Sheet “Depreciation”

Impacts of validation on journals and the general ledger

Once the proposal lines have been verified and the sheet validated, the system automatically generates the corresponding accounting entries:

  • Fixed asset accounting entries (FA Ledger Entries): Regardless of the depreciation law settings, auxiliary entries are systematically created to update the net book value, accumulated depreciation, and financial history of each asset record.
  • General Ledger Entries (G/L Entries): If the depreciation method is configured in integrated mode for the relevant entry type, the validation simultaneously generates entries in the General Ledger. The depreciation expense (Class 6) and accumulated depreciation (Class 28) accounts are then debited and credited directly in the income statement and balance sheet.
Image Pexels.com
Accounting entries Fixed assets.
Accounting entries Fixed assets.

4. Conversion of a Budgeted Fixed Asset into an Actual Acquisition

When a previously planned investment project materializes, the budgeted fixed asset is transformed into a real asset.

  • When entering the purchase invoice or the actual acquisition sheet for the new fixed asset, the number of the planned asset is indicated in the “Budgeted fixed asset no.” field.
  • Once the actual acquisition cost has been validated on the final asset, the original budgeted fixed asset record (on which the “Budgeted Fixed Asset” switch was activated) is manually deleted or closed to avoid any duplication in the financial projection statements (Fixed Asset - Projected Value).

Conclusion

Mastering asset acquisition, historical data migration, and automated depreciation calculations ensures a smooth transition to Microsoft Dynamics 365 Business Central and guarantees the continued reliability of financial statements. Automated batch processing minimizes manual intervention and ensures accurate pro rata calculations across the entire asset portfolio.

In the next article in this series on fixed asset management in Business Central, adjustment and end-of-cycle operations will be discussed in detail: the treatment of exceptional impairments, asset revaluation, disposal management, and the accounting for scrapping.

Virgile Petrantoni
Help the blogger by rating this post:
vote 1 vote 2 vote 3 vote 4 vote 5
Comments

No comments yet.

Feel like commenting on this article? sign up, it's free!


Other posts
From the V-model to agility

V-model and ERP projects: when milestones are passed on paper

The V-model did not fail because it planned. Its milestones were passed on signed documents, with no proof that anything worked. A fresh reading of Royce, the tunnel effect, shared responsibilities and what agility changes in the nature of proof, with a box on the requirements document approved before anyone has seen Business Central.

Calendar Icon  Published on 11/12/2026 | 
Project management | 
Views Icon  Views 0 times | 
Time Icon  Read in 0 min | 
Off Off Off Off Off
Business Central: enabling the Payment Management FR extension for French bills of exchange

French bills of exchange (LCR) in Business Central, moving from report 10880 to report 10840

In Business Central, French payment management moves to the Payment Management FR extension. Enabling it in Feature Management, migrating data company by company, checking the steps of French bill of exchange (LCR) payment slips: ETEBAC report 10880 becomes 10840 and LCR printing report 10865 becomes 10834.

Calendar Icon  Published on 11/19/2026 | 
Project management | 
Views Icon  Views 0 times | 
Time Icon  Read in 0 min | 
Off Off Off Off Off
Master your depreciation rules and secure the accounting impact of your assets in Business Central!

Depreciation laws and accounting integration in Business Central

Asset management in Microsoft Dynamics 365 Business Central relies on the configuration of depreciation rules. This article details their role, rounding rules, and integration into general ledger accounting. It presents the duplication of entries, multi-rule calculations, depreciation methods, and the configuration of fixed asset accounting types.

Calendar Icon  Published on 11/18/2026 | 
Project management | 
Views Icon  Views 0 times | 
Time Icon  Read in 0 min | 
Off Off Off Off Off
A schedule that is too short is always paid for later

ERP projects: when the initial estimate becomes an untenable promise

A Business Central project priced too tightly creates, from the day the contract is signed, a pressure that sacrifices testing, data migration and training. This article describes how the overrun shows up, what it really costs, why it repeats from one project to the next and how to build a budget and a schedule that hold up in the field.

Calendar Icon  Published on 11/15/2026 | 
Project management | 
Views Icon  Views 0 times | 
Time Icon  Read in 0 min | 
Off Off Off Off Off
0%