Table of Contents

Table "FA Depreciation Book"

ID 5612
Namespace: Microsoft.FixedAssets.Depreciation

Properties

Name Value
Caption FA Depreciation Book
Permissions TableData "FA Ledger Entry" = r, TableData "Maintenance Ledger Entry" = r
DataClassification CustomerContent

Fields

Name Type Description
"FA No." Code[20]

Specifies the number of the related fixed asset.
"Depreciation Book Code" Code[10]

Specifies the code for the depreciation book to which the line will be posted if you have selected Fixed Asset in the Type field for this line.
"Depreciation Method" Enum Microsoft.FixedAssets.Depreciation."FA Depreciation Method"

Specifies how depreciation is calculated for the depreciation book.
"Depreciation Starting Date" Date

Specifies the date on which depreciation of the fixed asset starts.
"Straight-Line %" Decimal

Specifies the percentage to depreciate the fixed asset by the straight-line principle, but with a fixed yearly percentage.
"No. of Depreciation Years" Decimal

Specifies the length of the depreciation period, expressed in years.
"No. of Depreciation Months" Decimal

Specifies the length of the depreciation period, expressed in months.
"Fixed Depr. Amount" Decimal

Specifies an amount to depreciate the fixed asset, by a fixed yearly amount.
"Declining-Balance %" Decimal

Specifies the percentage to depreciate the fixed asset by the declining-balance principle, but with a fixed yearly percentage.
"Depreciation Table Code" Code[10]

Specifies the code of the depreciation table to use if you have selected the User-Defined option in the Depreciation Method field.
"Final Rounding Amount" Decimal

Specifies the final rounding amount to use.
"Ending Book Value" Decimal

Specifies the amount to use as the ending book value.
"FA Posting Group" Code[20]

Specifies which posting group is used for the depreciation book when posting fixed asset transactions.
"Depreciation Ending Date" Date

Specifies the date on which depreciation of the fixed asset ends.
"Acquisition Cost" Decimal

Specifies the total acquisition cost for the fixed asset.
Depreciation Decimal

Specifies the total depreciation for the fixed asset.
"Book Value" Decimal

Specifies the book value for the fixed asset.
"Proceeds on Disposal" Decimal

Specifies the total proceeds on disposal for the fixed asset.
"Gain/Loss" Decimal

Specifies the total gain (credit) or loss (debit) for the fixed asset.
"Write-Down" Decimal

Specifies the total LCY amount of write-down entries for the fixed asset.
Appreciation Decimal

Specifies the total appreciation for the fixed asset.
"Custom 1" Decimal

Specifies the total LCY amount for custom 1 entries for the fixed asset.
"Custom 2" Decimal

Specifies the total LCY amount for custom 2 entries for the fixed asset.
"Depreciable Basis" Decimal

Specifies the depreciable basis amount for the fixed asset.
"Salvage Value" Decimal

Specifies the estimated residual value of a fixed asset when it can no longer be used.
"Book Value on Disposal" Decimal

Specifies the total LCY amount of entries posted with the Book Value on Disposal posting type. Entries of this kind are created when you post disposal of a fixed asset to a depreciation book where the Gross method has been selected in the Disposal Calculation Method field.
Maintenance Decimal

Specifies the total maintenance cost for the fixed asset.
"Maintenance Code Filter" Code[10]
"FA Posting Date Filter" Date
"Acquisition Date" Date

Specifies the FA posting date of the first posted acquisition cost.
"G/L Acquisition Date" Date

Specifies the G/L posting date of the first posted acquisition cost.
"Disposal Date" Date

Specifies the FA posting date of the first posted disposal amount.
"Last Acquisition Cost Date" Date

Specifies the total percentage of acquisition cost that can be allocated when acquisition cost is posted.
"Last Depreciation Date" Date

Specifies the FA posting date of the last posted depreciation.
"Last Write-Down Date" Date

Specifies the FA posting date of the last posted write-down.
"Last Appreciation Date" Date

Specifies the sum that applies to appreciations.
"Last Custom 1 Date" Date

Specifies the FA posting date of the last posted custom 1 entry.
"Last Custom 2 Date" Date

Specifies the FA posting date of the last posted custom 2 entry.
"Last Salvage Value Date" Date

Specifies if related salvage value entries are included in the batch job .
"FA Exchange Rate" Decimal

Specifies a decimal number, which will be used as an exchange rate when duplicating journal lines to this depreciation book.
"Fixed Depr. Amount below Zero" Decimal

Specifies a positive amount if you have selected the Allow Depr. below Zero field in the depreciation book.
"Last Date Modified" Date
"First User-Defined Depr. Date" Date

Specifies the starting date for the user-defined depreciation table if you have entered a code in the Depreciation Table Code field.
"Use FA Ledger Check" Boolean

Specifies which checks to perform before posting a journal line.
"Last Maintenance Date" Date
"Depr. below Zero %" Decimal

Specifies a percentage if you have selected the Allow Depr. below Zero field in the depreciation book.
"Projected Disposal Date" Date

Specifies the date on which you want to dispose of the fixed asset.
"Projected Proceeds on Disposal" Decimal

Specifies the expected proceeds from disposal of the fixed asset.
"Depr. Starting Date (Custom 1)" Date
"Depr. Ending Date (Custom 1)" Date
"Accum. Depr. % (Custom 1)" Decimal
"Depr. This Year % (Custom 1)" Decimal
"Property Class (Custom 1)" Option
Description Text[100]

Specifies the value in the Description field on the fixed asset card.
"Main Asset/Component" Enum Microsoft.FixedAssets.FixedAsset."FA Component Type"
"Component of Main Asset" Code[20]
"FA Add.-Currency Factor" Decimal
"Use Half-Year Convention" Boolean

Specifies that the Half-Year Convention is to be applied to the selected depreciation method.
"Use DB% First Fiscal Year" Boolean

Specifies that the depreciation methods DB1/SL and DB2/SL use the declining balance depreciation amount in the first fiscal year.
"Temp. Ending Date" Date

Specifies the ending date of the period during which a temporary fixed depreciation amount will be used.
"Temp. Fixed Depr. Amount" Decimal

Specifies a temporary fixed depreciation amount.
"Ignore Def. Ending Book Value" Boolean

Specifies that the default ending book value is ignored, and the value in the Ending Book Value is used.
"Use Bonus Depreciation" Boolean

Specifies if the bonus depreciation should be used in this book.
"Bonus Depr. Applied Amount" Decimal

Specifies the amount of bonus depreciation that has been applied to the fixed asset.
"Bonus Depreciation %" Decimal

Specifies the bonus depreciation percentage for this fixed asset.
"Default FA Depreciation Book" Boolean

Specifies the depreciation book that is used by default on documents and journals when a fixed asset has more than one depreciation book. A fixed asset can have only one default depreciation book. If a depreciation book is not specified for a fixed asset, the default depreciation book from the fixed asset setup is used.
SystemId Guid
SystemCreatedAt DateTime
SystemCreatedBy Guid
SystemModifiedAt DateTime
SystemModifiedBy Guid
SystemCreatedByUserName Text[50]
SystemCreatedByFullName Text[80]
SystemModifiedByUserName Text[50]
SystemModifiedByFullName Text[80]
SystemRowVersion BigInteger

Methods

EligibleForBonusDepreciation

procedure EligibleForBonusDepreciation(FASetup: Record "FA Setup"): Boolean

Parameters

Name Type Description
FASetup Table Microsoft.FixedAssets.Setup."FA Setup"

Returns

Type Description
Boolean

CalcDeprPeriod

procedure CalcDeprPeriod()

CalcEndingDate

procedure CalcEndingDate(): Date

Returns

Type Description
Date

GetExchangeRate

procedure GetExchangeRate(): Decimal

Returns

Type Description
Decimal

Caption

procedure Caption(): Text

Returns

Type Description
Text

DrillDownOnBookValue

procedure DrillDownOnBookValue()

ShowBookValueAfterDisposal

procedure ShowBookValueAfterDisposal()

CalcBookValue

procedure CalcBookValue()

SetBookValueFiltersOnFALedgerEntry

procedure SetBookValueFiltersOnFALedgerEntry(var FALedgerEntry: Record "FA Ledger Entry")

Parameters

Name Type Description
FALedgerEntry Table Microsoft.FixedAssets.Ledger."FA Ledger Entry"

LineIsReadyForAcquisition

procedure LineIsReadyForAcquisition(FANo: Code[20]): Boolean

Parameters

Name Type Description
FANo Code[20]

Returns

Type Description
Boolean

RecIsReadyForAcquisition

procedure RecIsReadyForAcquisition(): Boolean

Returns

Type Description
Boolean

UpdateBookValue

procedure UpdateBookValue()

Events

OnAfterCalcDeprPeriod

[IntegrationEvent(False,False)]
local procedure OnAfterCalcDeprPeriod(var FADepreciationBook: Record "FA Depreciation Book")

Parameters

Name Type Description
FADepreciationBook Table Microsoft.FixedAssets.Depreciation."FA Depreciation Book"

OnAfterLinearMethod

[IntegrationEvent(False,False)]
local procedure OnAfterLinearMethod(var FADepreciationBook: Record "FA Depreciation Book"; var Result: Boolean)

Parameters

Name Type Description
FADepreciationBook Table Microsoft.FixedAssets.Depreciation."FA Depreciation Book"
Result Boolean

OnAfterCalcEndingDate

[IntegrationEvent(False,False)]
local procedure OnAfterCalcEndingDate(FADepreciationBook: Record "FA Depreciation Book"; var EndingDate: Date)

Parameters

Name Type Description
FADepreciationBook Table Microsoft.FixedAssets.Depreciation."FA Depreciation Book"
EndingDate Date

OnAfterUserDefinedMethod

[IntegrationEvent(False,False)]
local procedure OnAfterUserDefinedMethod(FADepreciationBook: Record "FA Depreciation Book"; var Result: Boolean)

Parameters

Name Type Description
FADepreciationBook Table Microsoft.FixedAssets.Depreciation."FA Depreciation Book"
Result Boolean

OnBeforeOnDelete

[IntegrationEvent(False,False)]
local procedure OnBeforeOnDelete(var FADeprecBook: Record "FA Depreciation Book"; xFADeprecBook: Record "FA Depreciation Book"; var IsHandled: Boolean)

Parameters

Name Type Description
FADeprecBook Table Microsoft.FixedAssets.Depreciation."FA Depreciation Book"
xFADeprecBook Table Microsoft.FixedAssets.Depreciation."FA Depreciation Book"
IsHandled Boolean

OnBeforeAdjustLinearMethod

[IntegrationEvent(False,False)]
local procedure OnBeforeAdjustLinearMethod(var FADepreciationBook: Record "FA Depreciation Book"; var Amount1: Decimal; var Amount2: Decimal; var IsHandled: Boolean)

Parameters

Name Type Description
FADepreciationBook Table Microsoft.FixedAssets.Depreciation."FA Depreciation Book"
Amount1 Decimal
Amount2 Decimal
IsHandled Boolean

OnAfterSetBookValueFiltersOnFALedgerEntry

[IntegrationEvent(False,False)]
local procedure OnAfterSetBookValueFiltersOnFALedgerEntry(var FALedgerEntry: Record "FA Ledger Entry")

Parameters

Name Type Description
FALedgerEntry Table Microsoft.FixedAssets.Ledger."FA Ledger Entry"

OnBeforeShowBookValueAfterDisposal

[IntegrationEvent(False,False)]
local procedure OnBeforeShowBookValueAfterDisposal(var FADepreciationBook: Record "FA Depreciation Book"; var IsHandled: Boolean)

Parameters

Name Type Description
FADepreciationBook Table Microsoft.FixedAssets.Depreciation."FA Depreciation Book"
IsHandled Boolean

OnBeforeCalcDeprPeriod

[IntegrationEvent(False,False)]
local procedure OnBeforeCalcDeprPeriod(var FADepreciationBook: Record "FA Depreciation Book"; var IsHandled: Boolean)

Parameters

Name Type Description
FADepreciationBook Table Microsoft.FixedAssets.Depreciation."FA Depreciation Book"
IsHandled Boolean

OnBeforeCalcBookValue

[IntegrationEvent(False,False)]
local procedure OnBeforeCalcBookValue(var FADepreciationBook: Record "FA Depreciation Book"; var IsHandled: Boolean)

Parameters

Name Type Description
FADepreciationBook Table Microsoft.FixedAssets.Depreciation."FA Depreciation Book"
IsHandled Boolean

OnBeforeUpdateBookValue

[IntegrationEvent(False,False)]
local procedure OnBeforeUpdateBookValue(var FADepreciationBook: Record "FA Depreciation Book"; var IsHandled: Boolean)

Parameters

Name Type Description
FADepreciationBook Table Microsoft.FixedAssets.Depreciation."FA Depreciation Book"
IsHandled Boolean

OnBeforeModifyDeprFields

[IntegrationEvent(False,False)]
local procedure OnBeforeModifyDeprFields(FADepreciationBook: Record "FA Depreciation Book"; var IsHandled: Boolean)

Parameters

Name Type Description
FADepreciationBook Table Microsoft.FixedAssets.Depreciation."FA Depreciation Book"
IsHandled Boolean

OnBeforeDrillDownOnBookValue

[IntegrationEvent(False,False)]
local procedure OnBeforeDrillDownOnBookValue(var FADepreciationBook: Record "FA Depreciation Book"; var IsHandled: Boolean)

Parameters

Name Type Description
FADepreciationBook Table Microsoft.FixedAssets.Depreciation."FA Depreciation Book"
IsHandled Boolean

OnBeforeValidateNoOfDepreYears

[IntegrationEvent(False,False)]
local procedure OnBeforeValidateNoOfDepreYears(FANo: Code[20]; DeprecBook: Record "Depreciation Book"; var IsHandled: Boolean)

Parameters

Name Type Description
FANo Code[20]
DeprecBook Table Microsoft.FixedAssets.Depreciation."Depreciation Book"
IsHandled Boolean

OnBeforeValidateNoOfDeprMonths

[IntegrationEvent(False,False)]
local procedure OnBeforeValidateNoOfDeprMonths(FANo: Code[20]; DeprecBook: Record "Depreciation Book"; var IsHandled: Boolean)

Parameters

Name Type Description
FANo Code[20]
DeprecBook Table Microsoft.FixedAssets.Depreciation."Depreciation Book"
IsHandled Boolean

OnBeforeCalculateDepreEndingDate

[IntegrationEvent(False,False)]
local procedure OnBeforeCalculateDepreEndingDate(var FADeprBook: Record "FA Depreciation Book"; DeprEndDate: Date; var IsHandled: Boolean)

Parameters

Name Type Description
FADeprBook Table Microsoft.FixedAssets.Depreciation."FA Depreciation Book"
DeprEndDate Date
IsHandled Boolean

OnBeforeModifyFADeprBook

[IntegrationEvent(False,False)]
local procedure OnBeforeModifyFADeprBook(FADepreBook: Record "FA Depreciation Book"; var IsHandled: Boolean)

Parameters

Name Type Description
FADepreBook Table Microsoft.FixedAssets.Depreciation."FA Depreciation Book"
IsHandled Boolean

OnValidateNoofDepreciationYearsOnAfterCalcShowDeprMethodError

[IntegrationEvent(False,False)]
local procedure OnValidateNoofDepreciationYearsOnAfterCalcShowDeprMethodError(var FADepreciationBook: Record "FA Depreciation Book"; var ShowDeprMethodError: Boolean)

Parameters

Name Type Description
FADepreciationBook Table Microsoft.FixedAssets.Depreciation."FA Depreciation Book"
ShowDeprMethodError Boolean

OnValidateDepreciationEndingDateOnAfterCalcShowDeprMethodError

[IntegrationEvent(False,False)]
local procedure OnValidateDepreciationEndingDateOnAfterCalcShowDeprMethodError(var FADepreciationBook: Record "FA Depreciation Book"; var ShowDeprMethodError: Boolean)

Parameters

Name Type Description
FADepreciationBook Table Microsoft.FixedAssets.Depreciation."FA Depreciation Book"
ShowDeprMethodError Boolean

OnValidateNoofDepreciationMonthsOnAfterCalcShowDeprMethodError

[IntegrationEvent(False,False)]
local procedure OnValidateNoofDepreciationMonthsOnAfterCalcShowDeprMethodError(var FADepreciationBook: Record "FA Depreciation Book"; var ShowDeprMethodError: Boolean)

Parameters

Name Type Description
FADepreciationBook Table Microsoft.FixedAssets.Depreciation."FA Depreciation Book"
ShowDeprMethodError Boolean

OnBeforeInsertFADeprBook

[IntegrationEvent(False,False)]
local procedure OnBeforeInsertFADeprBook(FADepreciationBook: Record "FA Depreciation Book"; var IsHandled: Boolean)

Parameters

Name Type Description
FADepreciationBook Table Microsoft.FixedAssets.Depreciation."FA Depreciation Book"
IsHandled Boolean

OnBeforeCheckApplyDeprBookDefaults

[IntegrationEvent(False,False)]
local procedure OnBeforeCheckApplyDeprBookDefaults(var FADepreciationBook: Record "FA Depreciation Book"; var IsHandled: Boolean)

Parameters

Name Type Description
FADepreciationBook Table Microsoft.FixedAssets.Depreciation."FA Depreciation Book"
IsHandled Boolean

OnValidateDepreciationEndingDateOnBeforeTestFieldDeprStartingDate

[IntegrationEvent(False,False)]
local procedure OnValidateDepreciationEndingDateOnBeforeTestFieldDeprStartingDate(var FADepreciationBook: Record "FA Depreciation Book"; var IsHandled: Boolean)

Parameters

Name Type Description
FADepreciationBook Table Microsoft.FixedAssets.Depreciation."FA Depreciation Book"
IsHandled Boolean

OnValidateNoofDepreciationYearsOnBeforeTestFieldDeprStartingDate

[IntegrationEvent(False,False)]
local procedure OnValidateNoofDepreciationYearsOnBeforeTestFieldDeprStartingDate(var FADepreciationBook: Record "FA Depreciation Book"; var IsHandled: Boolean)

Parameters

Name Type Description
FADepreciationBook Table Microsoft.FixedAssets.Depreciation."FA Depreciation Book"
IsHandled Boolean

OnValidateNoofDepreciationMonthsOnBeforeTestFieldDeprStartingDate

[IntegrationEvent(False,False)]
local procedure OnValidateNoofDepreciationMonthsOnBeforeTestFieldDeprStartingDate(var FADepreciationBook: Record "FA Depreciation Book"; var IsHandled: Boolean)

Parameters

Name Type Description
FADepreciationBook Table Microsoft.FixedAssets.Depreciation."FA Depreciation Book"
IsHandled Boolean

OnAfterModifyDeprFields

[IntegrationEvent(True,False)]
local procedure OnAfterModifyDeprFields(var FADepreciationBook: Record "FA Depreciation Book")

Parameters

Name Type Description
FADepreciationBook Table Microsoft.FixedAssets.Depreciation."FA Depreciation Book"

See also