16.3 Fixed Asset Books, Derived Books & Posting Profiles
Key Takeaways
- A book links an asset to a depreciation profile, a service life, a posting layer, and a calendar, and holds its own status and balances.
- Books posting to the Current layer affect the statutory ledger; tax and custom layers keep parallel valuations out of the statutory result.
- A derived book posts its own transaction automatically whenever the primary book posts, which is how tax depreciation is kept in step with book depreciation.
- Fixed asset posting profiles map acquisition, depreciation, and disposal accounts and are resolved by group, by individual asset, or for all assets.
16.3 Fixed Asset Books, Derived Books & Posting Profiles
Quick Summary: Books apply a depreciation profile to an asset on a chosen posting layer, derived books keep a parallel tax valuation in step automatically, and posting profiles determine which general ledger accounts each fixed asset transaction hits.
1. Unified Fixed Asset Books & Posting Layers
In modern Dynamics 365 Finance, legacy Value Models and Tax Books are merged into a single consolidated concept: Books (Fixed assets > Setup > Books).
+---------------------------------------------------------------------------------------------------------+
| Fixed Asset Book Anatomy & Setup |
+---------------------------------------------------------------------------------------------------------+
| Book ID: [ CORP_GAAP ] Description: Commercial Statutory Financial Book (IFRS/US GAAP) |
+---------------------------------------------------------------------------------------------------------+
| GENERAL CONFIGURATION: |
| - Post to General Ledger: [ Yes ] - Posting Layer: [ Current ] |
| - Depreciation Profile: [ SL_SL_5YR ] - Alternative Depr Profile: [ NONE ] |
| - Depreciation Convention: [ Full month ] - Calendar: [ Fiscal - Standard_FY ] |
| - Service Life (Years): [ 5.00 ] - Life Periods: [ 60 ] |
| - Calculate Depreciation: [ Yes ] - Create Acquisition Prior: [ Yes ] |
+---------------------------------------------------------------------------------------------------------+
| DERIVED BOOKS FASTTAB: |
| Derived Book ID | Transaction Type | Direct Posting? | Split / Factor % |
| :---------------- | :--------------- | :-------------- | :--------------------------------------------- |
| `TAX_MACRS` | Acquisition | Yes | 100.00 % |
| `TAX_MACRS` | Disposal | Yes | 100.00 % |
+---------------------------------------------------------------------------------------------------------+
Key Book Parameters & Posting Layer Separation
- Post to General Ledger:
- Yes: Every subledger transaction (Acquisition, Depreciation, Disposal, Split) automatically generates a General Ledger voucher in the
GeneralJournalAccountEntrytable based on the active Fixed Asset Posting Profile. - No: Transactions are tracked purely within the Fixed Assets subledger tables (
AssetTrans,AssetBook) without creating general ledger journal vouchers. Frequently used for standalone tax books when tax depreciation is calculated off-ledger.
- Yes: Every subledger transaction (Acquisition, Depreciation, Disposal, Split) automatically generates a General Ledger voucher in the
- Posting Layers:
- Current: The primary operational and commercial statutory ledger (GAAP / IFRS). Feeds standard corporate financial statements.
- Operations: Management accounting or internal cost allocation adjustments.
- Tax: Statutory tax depreciation (e.g., US MACRS, Section 179 bonus depreciation). Allows generating dual balance sheets and tax return reconciliations without polluting the Current commercial ledger.
- Calendar Assignment:
- Books can link to the standard Fiscal Calendar (e.g., 4-4-5 retail or 12-period standard) or a dedicated Asset Calendar.
2. Derived Books Setup & Synchronization
Derived books automate secondary book transaction posting whenever a transaction is recorded on the primary book. This guarantees synchronized asset records across commercial, tax, and reporting layers without redundant manual data entry.
+---------------------------------------------------------------------------------------------------------+
| Derived Book Automated Synchronization Flow |
+---------------------------------------------------------------------------------------------------------+
| |
| [ User / System Action ] |
| | |
| v |
| +--------------------------------------------------------------------+ |
| | Post Acquisition on Primary Commercial Book: [ CORP_GAAP ] | |
| | - Amount: $120,000.00 | |
| | - Posting Layer: Current | |
| +--------------------------------------------------------------------+ |
| | |
| +-----------------------+ |
| | | (Automated Trigger via Derived Setup) |
| v v |
| +-----------------------+ +--------------------------------------------------------------------+ |
| | CORP_GAAP Subledger | | Automated Derived Transaction Generated: | |
| | Voucher Created: | | - Target Book: [ TAX_MACRS ] | |
| | Dr 180100 (Vehicles) | | - Transaction Type: Acquisition | |
| | Cr 200100 (AP Clear) | | - Amount: $120,000.00 | |
| +-----------------------+ | - Posting Layer: Tax (or Subledger Only if Post to GL = No) | |
| +--------------------------------------------------------------------+ |
| |
+---------------------------------------------------------------------------------------------------------+
Derived Book Rules
- Supported Derived Transaction Types: Acquisition, Acquisition adjustment, Depreciation, Depreciation adjustment, Disposal sale, Disposal scrap, Extraordinary depreciation, Write-up adjustment, Write-down adjustment.
- Direct Posting vs. Journal Inclusion: If configured for direct posting, derived transactions post automatically in the same ledger transaction bundle. If unselected, derived transactions land in a draft journal for review.
- Exam Rule: Depreciation is rarely configured as a derived transaction because commercial depreciation (e.g., Straight line 5 years) uses completely different calculation math and timing from tax depreciation (e.g., MACRS 200% declining balance). Acquisition and Disposal, however, are standard derived candidates.
3. Fixed Asset Posting Profiles & Account Determination
Fixed asset posting profiles (Fixed assets > Setup > Fixed asset posting profiles) bridge the Fixed Assets subledger to the General Ledger Chart of Accounts.
+---------------------------------------------------------------------------------------------------------+
| Fixed Asset Posting Profile Configuration Matrix |
+---------------------------------------------------------------------------------------------------------+
| Transaction Type | Valid Account Types / Main Account Role | Typical Offset Account Role |
| :------------------------- | :------------------------------------------ | :--------------------------- |
| **Acquisition** | Balance Sheet: Fixed Asset Cost Basis | Balance Sheet: AP Clearing / |
| | (e.g., `180100 - Vehicles Cost`) | Vendor / Bank (`200100`) |
| **Acquisition adjustment** | Balance Sheet: Fixed Asset Cost Basis | Balance Sheet: AP / Clearing |
| **Depreciation** | P&L Expense: Depreciation Expense | Balance Sheet: Accumulated |
| | (e.g., `650100 - Depr Expense Vehicles`) | Depreciation (`180150`) |
| **Depreciation adjustment**| P&L Expense / Adjustments | Balance Sheet: Acc Depr |
| **Disposal - sale** | Balance Sheet & P&L Gain/Loss Matrix | Subledger Customer / Clearing|
| **Disposal - scrap** | Balance Sheet & P&L Loss on Scrap Matrix | Balance Sheet: Asset / AccDep|
| **Capital reserve** | Equity / Balance Sheet Reserve Account | P&L / Reserve Transfer |
| **Extraordinary depr** | P&L: Impairment Loss Account | Balance Sheet: Acc Impairment|
+---------------------------------------------------------------------------------------------------------+
Account Precedence Hierarchy
When Dynamics 365 Finance evaluates which Ledger Account to debit or credit during a fixed asset transaction, it searches the active Posting Profile following strict precedence rules:
+---------------------------------------------------------------------------------------------------+
| Account Precedence Evaluation Engine |
+---------------------------------------------------------------------------------------------------+
| Precedence Level | Setting | Description & Search Matching Behavior |
| :--------------- | :-------- | :---------------------------------------------------------------- |
| **Priority 1** | **Table** | Exact match on a specific Asset Number (e.g., `VEH-00042`). |
| **Priority 2** | **Group** | Match on the asset's assigned Fixed Asset Group (e.g., `VEHICLES`).|
| **Priority 3** | **All** | Global fallback default applied when neither Table nor Group match|
+---------------------------------------------------------------------------------------------------+
[!IMPORTANT] Consultant Pro-Tip: Ledger Account vs. Book Specificity Posting profiles are configured per Book. If an enterprise utilizes two books (
CORP_GAAPandTAX_MACRS), you must define posting account lines for both books. IfTAX_MACRShas Post to General Ledger set to Yes, its posting profile lines must point to dedicated Tax Layer accounts or utilize the Tax posting layer to prevent ledger balance distortion.
4. Exam Traps & Practical Best Practices
[!WARNING] Exam Trap: Unified Books vs. Legacy Value Models Historical Dynamics AX materials referenced separate forms for Value models (GL-integrated) and Tax books (non-GL). On the MB-310 exam, remember that Dynamics 365 Finance unifies both into Books. The distinction between GL-integrated and non-GL books is now controlled entirely by the Post to general ledger boolean toggle on the Book record.
[!WARNING] Exam Trap: Half-Year Convention Mid-Year Additions Under the Half year depreciation convention, an asset placed in service on December 31st will receive exactly six months of depreciation in that fiscal year, identically to an asset acquired on January 2nd. Do not calculate daily or monthly pro-rata when the Half Year convention is active!
[!TIP] Consultant Pro-Tip: Allow Multiple Acquisitions If an organization constructs custom machinery where vendor invoices arrive over several months, ensure the Allow multiple acquisitions parameter is enabled in Fixed assets parameters. Without this toggle, posting a second acquisition journal against an already acquired asset triggers an immediate validation error.
A multinational enterprise configures a primary commercial Book (CORP_GAAP) with a 5-year straight-line depreciation profile and a secondary tax Book (TAX_FED) with a 3-year accelerated MACRS profile. When an asset acquisition is posted to CORP_GAAP, the acquisition must automatically record on TAX_FED. However, monthly depreciation must be calculated independently using each book's specific mathematical rules without automatic mirroring. How should the functional consultant configure the books?
An implementation consultant is configuring Fixed Asset Posting Profiles. The Chart of Accounts specifies that all computer hardware assets in group 'IT_EQUIP' must post acquisition costs to Main Account 180200, except for a specialized enterprise server (Asset ID 'SRV-0099') which must post acquisition cost to Main Account 180290. All other general fixed assets in the company must post to Main Account 180000. How should the consultant configure the posting profile lines for the Acquisition transaction type?