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 is
A report that works as a checklist for finding and checking assets during a physical inventory count.
What you do here
Use this report as a checklist when you identify assets during a physical inventory, grouped by dimension, responsible organization unit, responsible person or physical location.
Example
For 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.
The page in Dynamics 365. page title tab to open what to set or check
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 it
Before a physical count of fixed assets, so each counter gets a checklist for their area.
How often
At each physical inventory count, often once a year.
What the output shows
A 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.
Run Fixed asset physical inventory worksheet report
Choose the parameters that make the report answer the question it is run for.
Steps from Microsoft
Go to Fixed assets > Inquiries and reports > Fixed asset physical inventory worksheet report.
Check the Posting layer; only assets that belong to that posting layer are included.
In Group by, choose Dimension, Responsible organization unit, Responsible person or Physical location. If you pick Dimension, also choose the Dimension.
Set Subtotal to Yes for counts per group, then print the worksheet and tick each asset you find during the count.
Group 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.
Fixed 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 company
Per company: the report reads the fixed assets and books of the current legal entity. Microsoft Learn
Can it be undone
Nothing to undo: The worksheet only reads data; it changes nothing. Microsoft Learn
If you change it later
The 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 item
output:AssetInventoryWorksheetChecked in Dynamics 365
Form
SysOperationTemplateFormChecked in Dynamics 365
Roles to set it up and use it
To 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
Load 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
Fixed asset physical inventory worksheet report (Dynamics AX 2012 documentation, an earlier version) (archived Dynamics AX 2012 article for the same report; the menu item name is the same)