BeyondERP.Newsletter
Menu

Report page · Fixed assets

Fixed asset physical inventory worksheet report

A report that works as a checklist for finding and checking assets during a physical inventory count.

Business process
Manage active assets
Menu item
output:AssetInventoryWorksheet
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA report that works as a checklist for finding and checking assets during a physical inventory count.
What you do hereUse this report as a checklist when you identify assets during a physical inventory, grouped by dimension, responsible organization unit, responsible person or physical location.
ExampleFor example, for the count at the head office the manager prints the worksheet grouped by physical location, and the counters tick off each asset room by room.
Fixed asset physical inventory worksheet report 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

Business processManage active assets
Menu pathFixed assets › Inquiries and reports › Fixed asset physical inventory worksheet report
Set up firstFixed assets locations Microsoft Learn
Used next byFixed asset conditions Microsoft Learn
Related pagesFixed asset bar codes report Microsoft Learn Fixed asset management workspace (Related information) Microsoft Learn
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.

When to run it

When to run itBefore a physical count of fixed assets, so each counter gets a checklist for their area.
How oftenAt each physical inventory count, often once a year.
What the output showsA checklist of assets grouped by the chosen dimension, organization unit, person or location, with subtotals if selected. An asset listed under the wrong location usually has an outdated location or responsible person on the asset.

Source: Microsoft Learn

Setup steps on this page

Run Fixed asset physical inventory worksheet report

Choose the parameters that make the report answer the question it is run for.

Steps from Microsoft

  1. Go to Fixed assets > Inquiries and reports > Fixed asset physical inventory worksheet report.
  2. Check the Posting layer; only assets that belong to that posting layer are included.
  3. In Group by, choose Dimension, Responsible organization unit, Responsible person or Physical location. If you pick Dimension, also choose the Dimension.
  4. Set Subtotal to Yes for counts per group, then print the worksheet and tick each asset you find during the count.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Posting layerIncludes the assets that belong to the selected posting layer.Microsoft Learn
Group byGroups the worksheet by financial dimension, responsible organization unit, responsible person or physical location.Microsoft Learn Physical location
DimensionThe financial dimension to group by when you group by dimension.Microsoft Learn

Common errors and fixes

MessageWhat to do
The report is emptyCheck the filters under Records to include and that the assets have posted transactions in the books you selected. Checked in Dynamics 365
Assets appear under the wrong locationUpdate the location on the asset; the worksheet uses the asset's location. Microsoft Learn
Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Run Fixed asset physical inventory worksheet reportGroup the worksheet by the way the count is organized, such as physical location or responsible person, and pick the posting layer of the main book.The worksheet is a checklist to identify assets during a physical inventory; Group by decides the order counters walk through.How is the count organized?Grouping by a dimension when the count is done by location.Test: Fixed asset physical inventory worksheet report matches the books

Feature management and licence

Licence or add-inFixed assets is part of Dynamics 365 Finance. Fixed asset managers run it for counts. On this system the roles that open the page include Accounting supervisor, Accountant, Accounting manager, Auditor. 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: the report reads the fixed assets and books of the current legal entity. Microsoft Learn
Can it be undoneNothing to undo: The worksheet only reads data; it changes nothing. Microsoft Learn
If you change it laterThe report only reads posted fixed asset data; it changes nothing. Its figures change when transactions are posted, reversed or deleted on the books it covers. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:AssetInventoryWorksheet Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itAccounting supervisor LedgerAccountingSupervisorAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAuditor AuditPolicyManagerChief financial officer CompanyChiefFinancialOfficerGive people one of these roles. On this system, 9 roles can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=output:AssetInventoryWorksheet
Data migrationLoad order: Fixed asset physical inventory worksheet report has no data entity in Data management, so it can't be loaded from a file or a configuration template. The report stores nothing of its own: it reads the posted fixed asset data, so migrate the assets, books and transactions and run it again in the new environment.Microsoft Learn
Everyone

8Sources

KEEP EXPLORING

More in Fixed assets.

Open the other pages and setup steps in this module, or go back to the Atlas Hub to search every page.