BeyondERP.Newsletter
Menu

Setup step on the Fixed assets page · Fixed assets

Create a fixed asset

Create the asset in its group so it gets the group's books and defaults.

Used by
Accounts payable manager, Auditor, Business Performance Planning app role and 9 more roles
Business process
Maintain fixed assets
Menu item
AssetTable
Main table
AssetTable
Data entity
AssetFixedAssetEntity
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA list and details page where you record and manage each fixed asset, holding both its financial and non-financial information.
What you do hereUse this page to create fixed assets, keep details such as location, insurance and bar code up to date, and open each asset's books, transactions and valuations.
ExampleFor example, instead of tracking one conference room chair, you can record 50 chairs bought together as a single asset and use the Quantity, Unit of measure and Unit cost fields.
Fixed assets page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Setup steps on this page

Create a fixed asset

Create the asset in its group so it gets the group's books and defaults.

Steps from Microsoft

  1. Go to Fixed assets > Fixed assets > Fixed assets.
  2. On the Action Pane, select New.
  3. In the Fixed asset group field, select a group. The number fills in automatically if autonumbering is turned on; otherwise enter a unique number.
  4. In the Name field, enter a name and any other details your business needs.
  5. On the Action Pane, select Books.
  6. In the Acquisition date field, enter a date.
  7. In the Acquisition price field, enter an amount, and complete the other details for each book.
  8. Close the page.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Fixed asset groupThe only required field; it fills in default values and books for the new asset.Microsoft Learn AssetGroup
Property typeSays whether the record is a regular fixed asset, continuing property kept for inventory only, or other (intangible) assets.Microsoft Learn PropertyType
Major typeA high-level grouping such as equipment, buildings or land, used for reporting.Microsoft Learn MajorType
QuantityLets one asset record cover several similar low-cost items, together with Unit of measure and Unit cost.Microsoft Learn Quantity
StructureShows whether the asset is a main asset with components or a component of another asset.Microsoft Learn
Insured valueThe insured value of the asset, which you can edit here or update in bulk with the periodic update.Microsoft Learn InsuredValue
Last periodic value/cost updateThe date of the last successful bulk update of replacement cost or insured value; it is set automatically.Microsoft Learn LastFactorUpdateDate

Common errors and fixes

MessageWhat to do
An asset can't be deletedAn asset with posted transactions, or on an unposted journal line, can't be deleted; rename it or set Calculate depreciation to No on its books. Microsoft Learn
The depreciation proposal skips an assetCheck Calculate depreciation on the asset book. It is set to No when a purchase line is below the capitalization threshold, and the proposal skips books with No. Microsoft Learn

Test checklist

  1. Select New, pick a Fixed asset group and check that Number defaults when Autonumber fixed assets is on in both Fixed assets parameters and the group.
  2. Open Books and check that the books set up on the fixed asset group were added to the asset.
  3. Enter an Acquisition date and Acquisition price on each book.
  4. If you import assets with your own numbers in the template, check the number sequence afterwards; it isn't incremented automatically for Data management imports.
  5. Try to delete an asset that has a posted acquisition and check that the system blocks it.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Create a fixed assetCreate assets from the fixed asset group (or from the purchase order with Create asset during product receipt or invoice posting), and check the books before the first acquisition.The group sets the default books, service life and convention; the acquisition then posts through the posting profile of each book.How are fixed assets created?Creating an asset in the wrong group: its books and accounts come from the group, and changing it later needs Reclassification.Test: Asset created with group defaults

Feature management and licence

Licence or add-inFixed assets is part of Dynamics 365 Finance. Fixed asset accountants create and maintain assets; Fixed asset group is the only required field. On this system the roles that open the page include Accountant, Accounting supervisor, Information technology manager, Business Performance Planning app role. No Feature management feature needs to be turned on for this page.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneOne-way: After a transaction is posted the asset can't be deleted, only reclassified, disposed or closed.
If you change it laterA fixed asset record can't be deleted once transactions are posted to one of its books, or while it is on an unposted journal line. Microsoft Learn
Technical architect

6Technical

Menu itemAssetTable Checked in Dynamics 365
FormAssetTable Checked in Dynamics 365
TableAssetTableShown as “Fixed assets” in Record infoKey field: AssetGroup, AssetIdChecked in Dynamics 365
Data entitiesAssetFixedAssetEntityFixed assets Microsoft data model AssetFixedAssetV2EntityFixed assets V2 entity Microsoft data model DimAttributeAssetTableEntityFixed assets Microsoft data model DimAttributeRAssetTable_RUEntityFixed assets (Russia) Microsoft data model
Who can open itPrivilegesMaintain fixed asset records AssetTableMaintainView fixed asset records AssetTableViewDutiesInquire into fixed assets AssetFixedAssetsInquireMaintain fixed assets AssetFixedAssetsMaintainMaintain Master entity data for data management DataManagementApplicationMasterEntitiesMaintainView Master entity data for data management DataManagementApplicationMasterEntitiesView
12 security rolesAuditor AuditPolicyManagerBusiness Performance Planning app role BPPBudgetPlanningAppRoleBudget manager BudgetBudgetManagerChief financial officer CompanyChiefFinancialOfficerData management administrator DataManagementAdministratorData management migration user DataManagementMigrationUserAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorDemand planning app role ScpDemandPlanningAppRoleInformation technology manager SysServerITManagerAccounts payable manager VendInvoiceAccountsPayableManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itAccountant LedgerAccountantAccounting supervisor LedgerAccountingSupervisorInformation technology manager SysServerITManagerBusiness Performance Planning app role BPPBudgetPlanningAppRoleData management migration user DataManagementMigrationUserTo use itAccounting manager LedgerAccountingManagerAuditor AuditPolicyManagerChief financial officer CompanyChiefFinancialOfficerBudget manager BudgetBudgetManagerAccounts payable manager VendInvoiceAccountsPayableManagerGive people one of these roles. On this system, 12 roles can open this page.Checked in Dynamics 365
Actions on the pageFixed asset: New, Maintain, Lend, Transfers, Fixed asset additions, Projects, PropertiesAsset management: New, ViewOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=AssetTable
Integrate withAssetFixedAssetEntity data entity Microsoft data model
Data migrationAssetFixedAssetEntity (Fixed assets): loaded for each company, in Microsoft's default template 150 - Fixed assets.AssetFixedAssetV2Entity (Fixed assets V2 entity): loaded for each company.Load order: Microsoft's default template 150 - Fixed assets loads Fixed assets at execution unit 1, level 150, sequence 10. Lower levels load first, and entities at the same level load in sequence order.Load first: Fixed asset locations, Fixed asset groups, the default templates at lower levels (System setup to Accounts receivable)Microsoft Learn
Table definitionAssetTable columns and relations Microsoft data model
Everyone

8Sources