Accounts payable clerk, Accounts payable manager, Lease accountant and 13 more roles
Business process
Analyze fixed assets
Menu item
AssetTrans
Main table
AssetTrans
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 is
An inquiry page that lists fixed asset transactions by voucher, transaction date, fixed asset number, book, transaction type, amount and fixed asset group.
What you do here
Use this inquiry to see every posted transaction of an asset book, open its voucher, and reverse a transaction when it was posted in error.
Example
For example, the accountant filters on asset COMP-0042 and book CORP and sees the acquisition of 1,500.00 and twelve depreciation lines of 41.67, which add up to the net book value on the asset.
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.
Setup steps on this page
Trace an asset's transactions
Check what was posted to an asset book and open the vouchers.
Steps from Microsoft
Go to Fixed assets > Inquiries and reports > Fixed asset transactions.
On the Overview tab, read the Voucher, Transaction date, Fixed asset number, Book, Transaction type, Amount and Fixed asset group columns.
Select the General, Financial dimensions or History tab to see more detail.
Select a transaction, then select Details to open it.
Select Reverse transaction or Reversed tracing on the Action Pane when a transaction is selected.
Filter on the asset and book first, then on transaction type.An asset has transactions on every book; without the book filter, a tax book and the corporate book add up.
Fixed assets is part of Dynamics 365 Finance. Fixed asset accountants and auditors use the inquiry. On this system the roles that open the page include Accounting supervisor, Accountant, Accounting manager, Chief financial officer. No Feature management feature needs to be turned on for this page.
The inquiry shows posted transactions for all books, whatever kind; reversing a transaction from here posts a new reversing transaction. Microsoft Learn
Technical architect
6Technical
Menu item
AssetTransChecked in Dynamics 365
Form
AssetTransChecked in Dynamics 365
Table
AssetTransShown as “Fixed asset transactions” in Record infoKey field: AssetId, BookId, Voucher, TransDate, AssetGroupChecked in Dynamics 365
To use itAccounting supervisor LedgerAccountingSupervisorAccountant LedgerAccountantAccounting manager LedgerAccountingManagerChief financial officer CompanyChiefFinancialOfficerBudget manager BudgetBudgetManagerGive people one of these roles. On this system, 16 roles can open this page.Checked in Dynamics 365
Actions on the page
Options: Personalize, Page options, ShareChecked in Dynamics 365
Developer
7Developer
Open it by URL
https://<your-environment>/?mi=AssetTrans
Data migration
Load order: The fixed asset transactions table (AssetTrans) has no data entity in Data management: the Common Data Model lists no entity on it. Migrate opening values through the fixed asset journal instead.Load first: Fixed asset journalMicrosoft data model