BeyondERP.Newsletter
Menu

Setup step on the Fixed assets journal page · Fixed assets

Post fixed asset transactions in the journal

Enter and post acquisitions, depreciation, adjustments and disposals for asset books.

Used by
Accounts payable clerk, Accounts payable manager, Budget manager and 11 more roles
Business process
Manage active assets
Menu item
LedgerJournalTableAssets
Main table
LedgerJournalTable
Data entity
AssetJournalV2Entity
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 journal where you enter and post fixed asset transactions such as acquisitions, depreciation, value adjustments and disposals.
What you do hereUse this journal to record fixed asset transactions by hand or to have proposals suggest the lines, then review and post them.
ExampleFor example, at month end an accountant can run an acquisition proposal in the journal and compare it with the Accounts payable records to check that every new computer was acquired correctly.
Fixed assets journal 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

Post fixed asset transactions in the journal

Enter and post acquisitions, depreciation, adjustments and disposals for asset books.

Steps from Microsoft

  1. Go to Fixed assets > Journal entries > Fixed assets journal.
  2. Select New.
  3. In the Name field, select a journal name.
  4. On the Action Pane, select Lines.
  5. Select Proposals, and then select Acquisition proposal.
  6. Select Filter, select Reset to clear earlier values, and enter the criteria for the assets to acquire.
  7. Select OK twice and check that the lines were created.
  8. Select the Books tab, and then select Post.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Debit in reporting currencyShows and lets you change the reporting currency amount of depreciation lines; a matching Credit in reporting currency column sits next to it.Microsoft Learn
Transaction typeThe kind of fixed asset transaction, such as Acquisition, Depreciation, Disposal - sale or Disposal - scrap; it picks the accounts from the posting profile.Microsoft Learn Acquisition
BookThe asset book the line posts to.Microsoft Learn
AccountThe fixed asset number.Microsoft Learn

Common errors and fixes

MessageWhat to do
Transfers or splits fail, or several lines share one voucherUse a journal name with Journal type Post fixed assets that doesn't have the One voucher number only setting; several automated processes, such as transfers and splits, need a unique voucher number. Microsoft Learn
Posting fails because no main account is found for the transaction typeAdd an account for the transaction type and book (or book and group) on Fixed asset posting profiles. Disposal sale and Disposal scrap need accounts for every transaction type you use. Microsoft Learn
A book that doesn't post to the general ledger can't be posted from the journalTransactions for such a book need a journal name whose posting layer is None. Microsoft Learn

Test checklist

  1. Create a journal with a Post fixed assets journal name.
  2. Add an Acquisition line for an asset and book.
  3. Post and open the voucher.
  4. Check the debit on the acquisition account from the posting profile and the asset book status Open.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Post fixed asset transactions in the journalUse separate Post fixed assets journal names for acquisitions, depreciation and disposals, none of them with One voucher number only; use a None-layer journal name for books that don't post to the ledger.Transfers and splits need a unique voucher number, and books that don't post to the ledger can only be posted with a journal name whose posting layer is None.How many fixed asset journal names?A journal name with One voucher number only, which breaks transfers and splits.Test: Scrap an asset

Feature management and licence

Licence or add-inFixed assets is part of Dynamics 365 Finance. Fixed asset accountants enter and post the journal. On this system the roles that open the page include Accountant, Accounting supervisor, Accounting manager, Chief financial officer. 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 undoneHard to reverse: Posted transactions are reversed rather than deleted.
If you change it laterEach voucher can hold transactions for only one fixed asset, even when the journal name uses one voucher number only. Microsoft Learn
Technical architect

6Technical

Menu itemLedgerJournalTableAssets Checked in Dynamics 365
FormLedgerJournalTable Checked in Dynamics 365
TableLedgerJournalTableShown as “Ledger journal table” in Record infoKey field: JournalNumChecked in Dynamics 365
Data entitiesAssetJournalV2EntityAssetJournalV2 Microsoft data model AssetJournalHeaderEntityAssetJournalHeader Microsoft data model AssetJournalLineEntityAssetJournalLine Microsoft data model AssetJournalEntityFixed asset journal Microsoft data model
Who can open itPrivilegesMaintain fixed asset journal transactions LedgerJournalTableAssetsMaintainView fixed asset journal transactions LedgerJournalTableAssetsViewDutiesMaintain fixed asset transactions AssetFixedAssetTransactionsMaintainInquire into fixed asset transaction status AssetFixedAssetTransactionStatusInquire
14 security rolesBudget manager BudgetBudgetManagerChief financial officer CompanyChiefFinancialOfficerAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerAccounts payable centralized payments clerk PaymAccountsPayableCentralPaymClerkAccounts payable payments clerk PaymAccountsPayablePaymentsClerkRental coordinator agent RentalCoordinatorAgentRental manager RentalManagerRental purchasing manager RentalPurchasingManagerRental sales manager RentalSalesManagerAccounts payable clerk VendInvoiceAccountsPayableClerkAccounts payable manager VendInvoiceAccountsPayableManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itAccountant LedgerAccountantAccounting supervisor LedgerAccountingSupervisorTo use itAccounting manager LedgerAccountingManagerChief financial officer CompanyChiefFinancialOfficerBudget manager BudgetBudgetManagerRental manager RentalManagerRental purchasing manager RentalPurchasingManagerGive people one of these roles. On this system, 14 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, Edit, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=LedgerJournalTableAssets
Integrate withAssetJournalV2Entity data entity Microsoft data model
Data migrationAssetJournalV2Entity (Fixed asset journal V2): journal headers and lines in one entity, for opening balances.AssetJournalHeaderEntity (Fixed asset journal header).AssetJournalLineEntity (Fixed asset journal line).Load order: Microsoft's default configuration templates load Fixed assets at level 150, after General ledger (25), Bank (100), Accounts payable (120), Tax (130) and Accounts receivable (140). Within Fixed assets, load depreciation profiles, books, posting profiles and groups first, then the fixed assets and their books, and post opening acquisitions and depreciation through the fixed asset journal so that the subledger and the ledger agree.Load first: Fixed assets, Fixed asset books, Journal namesMicrosoft Learn
Table definitionLedgerJournalTable columns and relations Microsoft data model
Everyone

8Sources