Report 5607 Fixed Asset - Projected Value
src/Layers/W1/BaseApp/FixedAssets/Reports/FixedAssetProjectedValue.Report.al1,179 lines, Copyright (c) Microsoft Corporation. MIT
#if not CLEAN28// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.FixedAssets.Reports;using Microsoft.Finance.GeneralLedger.Budget;using Microsoft.FixedAssets.Depreciation;using Microsoft.FixedAssets.FixedAsset;using Microsoft.FixedAssets.Ledger;using Microsoft.FixedAssets.Setup;using Microsoft.Foundation.Period;using System.Utilities;report 5607 "Fixed Asset - Projected Value"{ ApplicationArea = FixedAssets; Caption = 'Fixed Asset Projected Value (Obsolete)'; UsageCategory = ReportsAndAnalysis; AllowScheduling = false; ObsoleteState = Pending; ObsoleteReason = 'This report has been replaced by the report Fixed Asset Projected Value (Excel). This report will be removed in a future release.'; ObsoleteTag = '28.0'; DefaultRenderingLayout = RDLCLayout; dataset { dataitem("Fixed Asset"; "Fixed Asset") { DataItemTableView = sorting("No."); RequestFilterFields = "No.", "FA Class Code", "FA Subclass Code", "Budgeted Asset"; column(CompanyName; COMPANYPROPERTY.DisplayName()) { } column(DeprBookText; DeprBookText) { } column(FixedAssetTabcaptFAFilter; TableCaption + ': ' + FAFilter) { } column(FAFilter; FAFilter) { } column(PrintDetails; PrintDetails) { } column(ProjectedDisposal; ProjectedDisposal) { } column(DeprBookUseCustom1Depr; DeprBook."Use Custom 1 Depreciation") { } column(DoProjectedDisposal; DoProjectedDisposal) { } column(GroupTotalsInt; GroupTotalsInt) { } column(IncludePostedFrom; Format(IncludePostedFrom)) { } column(GroupCodeName; GroupCodeName) { } column(FANo; FANo) { } column(FADescription; FADescription) { } column(GroupHeadLine; GroupHeadLine) { } column(FixedAssetNo; "No.") { } column(Description_FixedAsset; Description) { } column(DeprText2; DeprText2) { } column(Text002GroupHeadLine; GroupTotalTxt + ': ' + GroupHeadLine) { } column(Custom1Text; Custom1Text) { } column(DeprCustom1Text; DeprCustom1Text) { } column(SalesPriceFieldname; SalesPriceFieldname) { } column(GainLossFieldname; GainLossFieldname) { } column(GroupAmounts3; GroupAmounts[3]) { AutoFormatType = 1; } column(GroupAmounts4; GroupAmounts[4]) { AutoFormatType = 1; } column(FAClassCode_FixedAsset; "FA Class Code") { } column(FASubclassCode_FixedAsset; "FA Subclass Code") { } column(GlobalDim1Code_FixedAsset; "Global Dimension 1 Code") { } column(GlobalDim2Code_FixedAsset; "Global Dimension 2 Code") { } column(FALocationCode_FixedAsset; "FA Location Code") { } column(CompofMainAss_FixedAsset; "Component of Main Asset") { } column(FAPostingGroup_FixedAsset; "FA Posting Group") { } column(CurrReportPAGENOCaption; PageNoLbl) { } column(FixedAssetProjectedValueCaption; FAProjectedValueLbl) { } column(FALedgerEntryFAPostingDateCaption; FAPostingDateLbl) { } column(BookValueCaption; BookValueLbl) { } dataitem("FA Ledger Entry"; "FA Ledger Entry") { DataItemTableView = sorting("FA No.", "Depreciation Book Code", "FA Posting Date"); column(FAPostingDt_FALedgerEntry; Format("FA Posting Date")) { } column(PostingDt_FALedgerEntry; "FA Posting Type") { IncludeCaption = true; } column(Amount_FALedgerEntry; Amount) { IncludeCaption = true; } column(FANo_FALedgerEntry; "FA No.") { } column(BookValue; BookValue) { AutoFormatType = 1; } column(NoofDeprDays_FALedgEntry; "No. of Depreciation Days") { IncludeCaption = true; } column(FALedgerEntryEntryNo; "Entry No.") { } column(PostedEntryCaption; PostedEntryLbl) { } trigger OnAfterGetRecord() begin if "Part of Book Value" then BookValue := BookValue + Amount; if "FA Posting Date" < IncludePostedFrom then CurrReport.Skip(); EntryPrinted := true; end; trigger OnPreDataItem() begin SetRange("FA No.", "Fixed Asset"."No."); SetRange("Depreciation Book Code", DeprBookCode); BookValue := 0; if (IncludePostedFrom = 0D) or not PrintDetails then CurrReport.Break(); end; } dataitem(ProjectedDepreciation; "Integer") { DataItemTableView = sorting(Number) where(Number = filter(1 .. 1000000)); column(DeprAmount; DeprAmount) { AutoFormatType = 1; } column(EntryAmt1Custom1Amt; EntryAmounts[1] - Custom1Amount) { AutoFormatType = 1; } column(FormatUntilDate; Format(UntilDate)) { } column(DeprText; DeprText) { } column(NumberOfDays; NumberOfDays) { } column(No1_FixedAsset; "Fixed Asset"."No.") { } column(Custom1Text_ProjectedDepr; Custom1Text) { } column(Custom1NumberOfDays; Custom1NumberOfDays) { } column(Custom1Amount; Custom1Amount) { AutoFormatType = 1; } column(EntryAmounts1; EntryAmounts[1]) { AutoFormatType = 1; } column(AssetAmounts1; AssetAmounts[1]) { AutoFormatType = 1; } column(Description1_FixedAsset; "Fixed Asset".Description) { } column(AssetAmounts2; AssetAmounts[2]) { AutoFormatType = 1; } column(AssetAmt1AssetAmt2; AssetAmounts[1] + AssetAmounts[2]) { AutoFormatType = 1; } column(DeprCustom1Text_ProjectedDepr; DeprCustom1Text) { } column(AssetAmounts3; AssetAmounts[3]) { AutoFormatType = 1; } column(AssetAmounts4; AssetAmounts[4]) { AutoFormatType = 1; } column(SalesPriceFieldname_ProjectedDepr; SalesPriceFieldname) { } column(GainLossFieldname_ProjectedDepr; GainLossFieldname) { } column(GroupAmounts_1; GroupAmounts[1]) { } column(GroupTotalBookValue; GroupTotalBookValue) { } column(TotalBookValue_1; TotalBookValue[1]) { } trigger OnAfterGetRecord() begin if UntilDate >= EndingDate then CurrReport.Break(); if Number = 1 then begin CalculateFirstDeprAmount(Done); if FADeprBook."Book Value" <> 0 then Done := Done or not EntryPrinted; end else CalculateSecondDeprAmount(Done); if Done then UpdateTotals() else UpdateGroupTotals(); if Done then if DoProjectedDisposal then CalculateGainLoss(); end; trigger OnPostDataItem() begin if DoProjectedDisposal then begin TotalAmounts[3] += AssetAmounts[3]; TotalAmounts[4] += AssetAmounts[4]; end; end; } trigger OnAfterGetRecord() begin case GroupTotals of GroupTotals::"FA Class": NewValue := "FA Class Code"; GroupTotals::"FA Subclass": NewValue := "FA Subclass Code"; GroupTotals::"FA Location": NewValue := "FA Location Code"; GroupTotals::"Main Asset": NewValue := "Component of Main Asset"; GroupTotals::"Global Dimension 1": NewValue := "Global Dimension 1 Code"; GroupTotals::"Global Dimension 2": NewValue := "Global Dimension 2 Code"; GroupTotals::"FA Posting Group": NewValue := "FA Posting Group"; end; if NewValue <> OldValue then begin MakeGroupHeadLine(); InitGroupTotals(); OldValue := NewValue; end; if not FADeprBook.Get("No.", DeprBookCode) then CurrReport.Skip(); if SkipRecord() then CurrReport.Skip(); if GroupTotals = GroupTotals::"FA Posting Group" then if "FA Posting Group" <> FADeprBook."FA Posting Group" then Error(HasBeenModifiedInFAErr, FieldCaption("FA Posting Group"), "No."); StartingDate := StartingDate2; EndingDate := EndingDate2; DoProjectedDisposal := false; EntryPrinted := false; if ProjectedDisposal and (FADeprBook."Projected Disposal Date" > 0D) and (FADeprBook."Projected Disposal Date" <= EndingDate) then begin EndingDate := FADeprBook."Projected Disposal Date"; if StartingDate > EndingDate then StartingDate := EndingDate; DoProjectedDisposal := true; end; TransferValues(); OnAfterTransferValues(GroupAmounts, TotalBookValue); end; trigger OnPreDataItem() begin case GroupTotals of GroupTotals::"FA Class": SetCurrentKey("FA Class Code"); GroupTotals::"FA Subclass": SetCurrentKey("FA Subclass Code"); GroupTotals::"FA Location": SetCurrentKey("FA Location Code"); GroupTotals::"Main Asset": SetCurrentKey("Component of Main Asset"); GroupTotals::"Global Dimension 1": SetCurrentKey("Global Dimension 1 Code"); GroupTotals::"Global Dimension 2": SetCurrentKey("Global Dimension 2 Code"); GroupTotals::"FA Posting Group": SetCurrentKey("FA Posting Group"); end; GroupTotalsInt := GroupTotals; MakeGroupHeadLine(); InitGroupTotals(); end; } dataitem(ProjectionTotal; "Integer") { DataItemTableView = sorting(Number) where(Number = const(1)); column(TotalBookValue2; TotalBookValue[2]) { AutoFormatType = 1; } column(TotalAmounts1; TotalAmounts[1]) { AutoFormatType = 1; } column(DeprText2_ProjectionTotal; DeprText2) { } column(ProjectedDisposal_ProjectionTotal; ProjectedDisposal) { } column(DeprBookUseCustDepr_ProjectionTotal; DeprBook."Use Custom 1 Depreciation") { } column(Custom1Text_ProjectionTotal; Custom1Text) { } column(TotalAmounts2; TotalAmounts[2]) { AutoFormatType = 1; } column(DeprCustom1Text_ProjectionTotal; DeprCustom1Text) { } column(TotalAmt1TotalAmt2; TotalAmounts[1] + TotalAmounts[2]) { AutoFormatType = 1; } column(SalesPriceFieldname_ProjectionTotal; SalesPriceFieldname) { } column(GainLossFieldname_ProjectionTotal; GainLossFieldname) { } column(TotalAmounts3; TotalAmounts[3]) { AutoFormatType = 1; } column(TotalAmounts4; TotalAmounts[4]) { AutoFormatType = 1; } column(TotalCaption; TotalLbl) { } } dataitem(Buffer; "Integer") { DataItemTableView = sorting(Number) where(Number = filter(1 ..)); column(DeprBookText_Buffer; DeprBookText) { } column(Custom1TextText_Buffer; Custom1Text) { } column(GroupCodeName2; GroupCodeName2) { } column(FAPostingDate_FABufferProjection; Format(TempFABufferProjection."FA Posting Date")) { } column(Desc_FABufferProjection; TempFABufferProjection.Depreciation) { } column(Cust1_FABufferProjection; TempFABufferProjection."Custom 1") { } column(CodeName_FABufferProj; TempFABufferProjection."Code Name") { } column(ProjectedAmountsperDateCaption; ProjectedAmountsPerDateLbl) { } column(FABufferProjectionFAPostingDateCaption; FABufferProjectionFAPostingDateLbl) { } column(FABufferProjectionDepreciationCaption; FABufferProjectionDepreciationLbl) { } column(FixedAssetProjectedValueCaption_Buffer; FABufferProjectedValueLbl) { } trigger OnAfterGetRecord() begin if Number = 1 then begin if not TempFABufferProjection.Find('-') then CurrReport.Break(); end else if TempFABufferProjection.Next() = 0 then CurrReport.Break(); end; trigger OnPreDataItem() begin if not PrintAmountsPerDate then CurrReport.Break(); TempFABufferProjection.Reset(); end; } } requestpage { SaveValues = true; AboutTitle = 'About Fixed Asset Projected Value (Obsolete)'; AboutText = '**Fixed Asset Projected Value** Report is a detailed analysis that forecasts the future value of an organization''s fixed assets over a specified period. This is specially useful where there are multiple depreciation methods and there is need to review the projected values of depreciation.** This report is obsolete and will be removed in a future release.** Please refer to the report documentation for alternative ways to retrieve this information.'; layout { area(content) { group(Options) { Caption = 'Options'; field(DepreciationBook; DeprBookCode) { ApplicationArea = FixedAssets; Caption = 'Depreciation Book'; TableRelation = "Depreciation Book"; AboutTitle = 'Select Depreciation Book'; AboutText = 'Choose the Depreciation Book and specify the First Depreciation Date, Last Depreciation Date for which details are to be seen and group the total with applicable option.'; ToolTip = 'Specifies the code for the depreciation book to be included in the report or batch job.'; trigger OnValidate() begin UpdateReqForm(); end; } field(FirstDeprDate; StartingDate) { ApplicationArea = FixedAssets; Caption = 'First Depreciation Date'; ToolTip = 'Specifies the date to be used as the first date in the period for which you want to calculate projected depreciation.'; } field(LastDeprDate; EndingDate) { ApplicationArea = FixedAssets; Caption = 'Last Depreciation Date'; ToolTip = 'Specifies the Fixed Asset posting date of the last posted depreciation.'; } field(NumberOfDays; PeriodLength) { ApplicationArea = FixedAssets; BlankZero = true; Caption = 'Number of Days'; Editable = NumberOfDaysCtrlEditable; MinValue = 0; ToolTip = 'Specifies the length of the periods between the first depreciation date and the last depreciation date. The program then calculates depreciation for each period. If you leave this field blank, the program automatically sets the contents of this field to equal the number of days in a fiscal year, normally 360.'; trigger OnValidate() begin if PeriodLength > 0 then UseAccountingPeriod := false; end; } field(DaysInFirstPeriod; DaysInFirstPeriod) { ApplicationArea = FixedAssets; BlankZero = true; Caption = 'No. of Days in First Period'; MinValue = 0; ToolTip = 'Specifies the number of days that must be used for calculating the depreciation as of the first depreciation date, regardless of the actual number of days from the last depreciation entry. The number you enter in this field does not affect the total number of days from the starting date to the ending date.'; } field(IncludePostedFrom; IncludePostedFrom) { ApplicationArea = FixedAssets; Caption = 'Posted Entries From'; ToolTip = 'Specifies the fixed asset posting date from which the report includes all types of posted entries.'; } field(GroupTotals; GroupTotals) { ApplicationArea = FixedAssets; Caption = 'Group Totals'; OptionCaption = ' ,FA Class,FA Subclass,FA Location,Main Asset,Global Dimension 1,Global Dimension 2,FA Posting Group'; ToolTip = 'Specifies if you want the report to group fixed assets and print totals using the category defined in this field. For example, maintenance expenses for fixed assets can be shown for each fixed asset class.'; } field(CopyToGLBudgetName; BudgetNameCode) { ApplicationArea = Suite; Caption = 'Copy to G/L Budget Name'; TableRelation = "G/L Budget Name"; ToolTip = 'Specifies the name of the budget you want to copy projected values to.'; trigger OnValidate() begin if BudgetNameCode = '' then BalAccount := false; end; } field(InsertBalAccount; BalAccount) { ApplicationArea = FixedAssets; Caption = 'Insert Bal. Account'; AboutTitle = 'Insert Balancing Account'; AboutText = 'Enable the applicable options to view the report details as required.'; ToolTip = 'Specifies if you want the batch job to automatically insert fixed asset entries with balancing accounts.'; trigger OnValidate() begin if BalAccount then if BudgetNameCode = '' then Error(YouMustSpecifyErr, GLBudgetName.TableCaption()); end; } field(PrintPerFixedAsset; PrintDetails) { ApplicationArea = FixedAssets; Caption = 'Print per Fixed Asset'; ToolTip = 'Specifies if you want the report to print information separately for each fixed asset.'; } field(ProjectedDisposal; ProjectedDisposal) { ApplicationArea = FixedAssets; Caption = 'Projected Disposal'; ToolTip = 'Specifies if you want the report to include projected disposals: the contents of the Projected Proceeds on Disposal field and the Projected Disposal Date field on the FA depreciation book.'; } field(PrintAmountsPerDate; PrintAmountsPerDate) { ApplicationArea = FixedAssets; Caption = 'Print Amounts per Date'; ToolTip = 'Specifies if you want the program to include on the last page of the report a summary of the calculated depreciation for all assets.'; } field(UseAccountingPeriod; UseAccountingPeriod) { ApplicationArea = FixedAssets; Caption = 'Use Accounting Period'; ToolTip = 'Specifies if you want the periods between the starting date and the ending date to correspond to the accounting periods you have specified in the Accounting Period table. When you select this field, the Number of Days field is cleared.'; trigger OnValidate() begin if UseAccountingPeriod then PeriodLength := 0; UpdateReqForm(); end; } } } } actions { } trigger OnInit() begin NumberOfDaysCtrlEditable := true; end; trigger OnOpenPage() begin GetFASetup(); end; } rendering { layout(RDLCLayout) { Type = RDLC; LayoutFile = './FixedAssets/Reports/FixedAssetProjectedValue.rdlc'; Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.'; } } labels { } trigger OnPreReport() begin DeprBook.Get(DeprBookCode); Year365Days := DeprBook."Fiscal Year 365 Days"; if GroupTotals = GroupTotals::"FA Posting Group" then FAGenReport.SetFAPostingGroup("Fixed Asset", DeprBook.Code); FAGenReport.AppendFAPostingFilter("Fixed Asset", StartingDate, EndingDate); FAFilter := "Fixed Asset".GetFilters(); DeprBookText := StrSubstNo('%1%2 %3', DeprBook.TableCaption(), ':', DeprBookCode); MakeGroupTotalText(); ValidateDates(); if PrintDetails then begin FANo := "Fixed Asset".FieldCaption("No."); FADescription := "Fixed Asset".FieldCaption(Description); end; if DeprBook."No. of Days in Fiscal Year" > 0 then DaysInFiscalYear := DeprBook."No. of Days in Fiscal Year" else DaysInFiscalYear := 360; if Year365Days then DaysInFiscalYear := 365; if PeriodLength = 0 then PeriodLength := DaysInFiscalYear; if (PeriodLength <= 5) or (PeriodLength > DaysInFiscalYear) then Error(NumberOfDaysMustNotBeGreaterThanErr, DaysInFiscalYear); FALedgEntry2."FA Posting Type" := FALedgEntry2."FA Posting Type"::Depreciation; DeprText := StrSubstNo('%1', FALedgEntry2."FA Posting Type"); if DeprBook."Use Custom 1 Depreciation" then begin DeprText2 := DeprText; FALedgEntry2."FA Posting Type" := FALedgEntry2."FA Posting Type"::"Custom 1"; Custom1Text := StrSubstNo('%1', FALedgEntry2."FA Posting Type"); DeprCustom1Text := StrSubstNo('%1 %2 %3', DeprText, '+', Custom1Text); end; SalesPriceFieldname := FADeprBook.FieldCaption("Projected Proceeds on Disposal"); GainLossFieldname := ProjectedGainLossTxt; end; var GLBudgetName: Record "G/L Budget Name"; FASetup: Record "FA Setup"; DeprBook: Record "Depreciation Book"; FADeprBook: Record "FA Depreciation Book"; FA: Record "Fixed Asset"; FALedgEntry2: Record "FA Ledger Entry"; TempFABufferProjection: Record "FA Buffer Projection" temporary; FAGenReport: Codeunit "FA General Report"; CalculateDepr: Codeunit "Calculate Depreciation"; FADateCalculation: Codeunit "FA Date Calculation"; DepreciationCalculation: Codeunit "Depreciation Calculation"; FAFilter: Text; DeprBookText: Text[50]; GroupCodeName: Text[50]; GroupCodeName2: Text[50]; GroupHeadLine: Text[50]; DeprText: Text[50]; DeprText2: Text[50]; Custom1Text: Text[50]; DeprCustom1Text: Text[50]; IncludePostedFrom: Date; FANo: Text[50]; FADescription: Text[100]; GroupTotals: Option " ","FA Class","FA Subclass","FA Location","Main Asset","Global Dimension 1","Global Dimension 2","FA Posting Group"; BookValue: Decimal; NewFiscalYear: Date; EndFiscalYear: Date; DaysInFiscalYear: Integer; Custom1DeprUntil: Date; PeriodLength: Integer; UseAccountingPeriod: Boolean; StartingDate2: Date; EndingDate2: Date; PrintAmountsPerDate: Boolean; UntilDate: Date; PrintDetails: Boolean; EntryAmounts: array[4] of Decimal; AssetAmounts: array[4] of Decimal; GroupAmounts: array[4] of Decimal; TotalAmounts: array[4] of Decimal; TotalBookValue: array[2] of Decimal; GroupTotalBookValue: Decimal; DateFromProjection: Date; DeprAmount: Decimal; Custom1Amount: Decimal; NumberOfDays: Integer; Custom1NumberOfDays: Integer; DaysInFirstPeriod: Integer; Done: Boolean; NotFirstGroupTotal: Boolean; SalesPriceFieldname: Text[80]; GainLossFieldname: Text[50]; ProjectedDisposal: Boolean; DoProjectedDisposal: Boolean; EntryPrinted: Boolean; GroupCodeNameTxt: Label ' ,FA Class,FA Subclass,FA Location,Main Asset,Global Dimension 1,Global Dimension 2,FA Posting Group'; BudgetNameCode: Code[10]; OldValue: Code[20]; NewValue: Code[20]; BalAccount: Boolean; TempDeprDate: Date; GroupTotalsInt: Integer; Year365Days: Boolean; NumberOfDaysCtrlEditable: Boolean;#pragma warning disable AA0470 NumberOfDaysMustNotBeGreaterThanErr: Label 'Number of Days must not be greater than %1 or less than 5.', Comment = '1 - Number of days in fiscal year';#pragma warning restore AA0470 ProjectedGainLossTxt: Label 'Projected Gain/Loss'; GroupTotalTxt: Label 'Group Total'; GroupTotalsTxt: Label 'Group Totals';#pragma warning disable AA0470 HasBeenModifiedInFAErr: Label '%1 has been modified in fixed asset %2.', Comment = '1 - FA Posting Group caption; 2- FA No.'; YouMustSpecifyErr: Label 'You must specify %1.', Comment = '1 - G/L Budget Name caption'; YouMustCreateAccPeriodsErr: Label 'You must create accounting periods until %1 to use 365 days depreciation and ''Use Accounting Periods''.', Comment = '1 - Date';#pragma warning restore AA0470 PageNoLbl: Label 'Page'; FAProjectedValueLbl: Label 'Fixed Asset - Projected Value'; FAPostingDateLbl: Label 'FA Posting Date'; BookValueLbl: Label 'Book Value'; PostedEntryLbl: Label 'Posted Entry'; TotalLbl: Label 'Total'; ProjectedAmountsPerDateLbl: Label 'Projected Amounts per Date'; FABufferProjectionFAPostingDateLbl: Label 'FA Posting Date'; FABufferProjectionDepreciationLbl: Label 'Depreciation'; FABufferProjectedValueLbl: Label 'Fixed Asset - Projected Value'; protected var DeprBookCode: Code[10]; StartingDate: Date; EndingDate: Date; local procedure SkipRecord(): Boolean begin exit( "Fixed Asset".Inactive or (FADeprBook."Acquisition Date" = 0D) or (FADeprBook."Acquisition Date" > EndingDate) or (FADeprBook."Last Depreciation Date" > EndingDate) or (FADeprBook."Disposal Date" > 0D)); end; local procedure TransferValues() begin FADeprBook.CalcFields("Book Value", "Custom 1"); DateFromProjection := 0D; EntryAmounts[1] := FADeprBook."Book Value"; EntryAmounts[2] := FADeprBook."Custom 1"; EntryAmounts[3] := DepreciationCalculation.DeprInFiscalYear("Fixed Asset"."No.", DeprBookCode, StartingDate); TotalBookValue[1] := TotalBookValue[1] + FADeprBook."Book Value"; TotalBookValue[2] := TotalBookValue[2] + FADeprBook."Book Value"; GroupTotalBookValue += FADeprBook."Book Value"; NewFiscalYear := FADateCalculation.GetFiscalYear(DeprBookCode, StartingDate); EndFiscalYear := FADateCalculation.CalculateDate( DepreciationCalculation.Yesterday(NewFiscalYear, Year365Days, DeprBook."Use Accounting Period"), DaysInFiscalYear, Year365Days); TempDeprDate := FADeprBook."Temp. Ending Date"; if DeprBook."Use Custom 1 Depreciation" then Custom1DeprUntil := FADeprBook."Depr. Ending Date (Custom 1)" else Custom1DeprUntil := 0D; if Custom1DeprUntil > 0D then EntryAmounts[4] := GetDeprBasis(); UntilDate := 0D; AssetAmounts[1] := 0; AssetAmounts[2] := 0; AssetAmounts[3] := 0; AssetAmounts[4] := 0; end; local procedure CalculateFirstDeprAmount(var Done: Boolean) var FirstTime: Boolean; IsHandled: Boolean; begin FirstTime := true; UntilDate := StartingDate; IsHandled := false; OnBeforeCalculateFirstDeprAmount("Fixed Asset", CalculateDepr, DepreciationCalculation, FirstTime, Done, UntilDate, StartingDate, DeprAmount, Custom1Amount, NumberOfDays, Custom1NumberOfDays, DeprBookCode, EntryAmounts, DaysInFirstPeriod, EndingDate, IsHandled); if IsHandled then exit; repeat if not FirstTime then GetNextDate(); FirstTime := false; CalculateDepr.Calculate( DeprAmount, Custom1Amount, NumberOfDays, Custom1NumberOfDays, "Fixed Asset"."No.", DeprBookCode, UntilDate, EntryAmounts, 0D, DaysInFirstPeriod); Done := (DeprAmount <> 0) or (Custom1Amount <> 0); until (UntilDate >= EndingDate) or Done; EntryAmounts[3] := DepreciationCalculation.DeprInFiscalYear("Fixed Asset"."No.", DeprBookCode, UntilDate); end; local procedure CalculateSecondDeprAmount(var Done: Boolean) begin GetNextDate(); CalculateDepr.Calculate( DeprAmount, Custom1Amount, NumberOfDays, Custom1NumberOfDays, "Fixed Asset"."No.", DeprBookCode, UntilDate, EntryAmounts, DateFromProjection, 0); Done := CalculationDone( (DeprAmount <> 0) or (Custom1Amount <> 0), DateFromProjection); end; local procedure GetNextDate() var UntilDate2: Date; begin UntilDate2 := GetPeriodEndingDate(UseAccountingPeriod, UntilDate, PeriodLength); if Custom1DeprUntil > 0D then if (UntilDate < Custom1DeprUntil) and (UntilDate2 > Custom1DeprUntil) then UntilDate2 := Custom1DeprUntil; if TempDeprDate > 0D then if (UntilDate < TempDeprDate) and (UntilDate2 > TempDeprDate) then UntilDate2 := TempDeprDate; if (UntilDate < EndFiscalYear) and (UntilDate2 > EndFiscalYear) then UntilDate2 := EndFiscalYear; if UntilDate = EndFiscalYear then begin EntryAmounts[3] := 0; NewFiscalYear := DepreciationCalculation.ToMorrow(EndFiscalYear, Year365Days, DeprBook."Use Accounting Period"); EndFiscalYear := FADateCalculation.CalculateDate(EndFiscalYear, DaysInFiscalYear, Year365Days); end; DateFromProjection := DepreciationCalculation.ToMorrow(UntilDate, Year365Days, DeprBook."Use Accounting Period"); UntilDate := UntilDate2; if UntilDate >= EndingDate then UntilDate := EndingDate; end; local procedure GetPeriodEndingDate(UseAccountingPeriod: Boolean; PeriodEndingDate: Date; var PeriodLength: Integer): Date var AccountingPeriod: Record "Accounting Period"; UntilDate2: Date; begin if not UseAccountingPeriod or AccountingPeriod.IsEmpty() then exit(FADateCalculation.CalculateDate(PeriodEndingDate, PeriodLength, Year365Days)); AccountingPeriod.SetFilter( "Starting Date", '>=%1', DepreciationCalculation.ToMorrow(PeriodEndingDate, Year365Days) + 1); OnAfterAccountingPeriodSetFilter(PeriodEndingDate, Year365Days, DeprBook."Use Accounting Period", AccountingPeriod); if AccountingPeriod.FindFirst() then begin if Date2DMY(AccountingPeriod."Starting Date", 1) <> 31 then UntilDate2 := DepreciationCalculation.Yesterday(AccountingPeriod."Starting Date", Year365Days, DeprBook."Use Accounting Period") else UntilDate2 := AccountingPeriod."Starting Date" - 1; PeriodLength := DepreciationCalculation.DeprDays( DepreciationCalculation.ToMorrow(PeriodEndingDate, Year365Days, DeprBook."Use Accounting Period"), UntilDate2, Year365Days, DeprBook."Use Accounting Period"); if (PeriodLength <= 5) or (PeriodLength > DaysInFiscalYear) then PeriodLength := DaysInFiscalYear; exit(UntilDate2); end; if Year365Days then Error(YouMustCreateAccPeriodsErr, DepreciationCalculation.ToMorrow(EndingDate, Year365Days, DeprBook."Use Accounting Period") + 1); exit(FADateCalculation.CalculateDate(PeriodEndingDate, PeriodLength, Year365Days)); end; local procedure MakeGroupTotalText() begin case GroupTotals of GroupTotals::"FA Class": GroupCodeName := "Fixed Asset".FieldCaption("FA Class Code"); GroupTotals::"FA Subclass": GroupCodeName := "Fixed Asset".FieldCaption("FA Subclass Code"); GroupTotals::"FA Location": GroupCodeName := "Fixed Asset".FieldCaption("FA Location Code"); GroupTotals::"Main Asset": GroupCodeName := "Fixed Asset".FieldCaption("Main Asset/Component"); GroupTotals::"Global Dimension 1": GroupCodeName := "Fixed Asset".FieldCaption("Global Dimension 1 Code"); GroupTotals::"Global Dimension 2": GroupCodeName := "Fixed Asset".FieldCaption("Global Dimension 2 Code"); GroupTotals::"FA Posting Group": GroupCodeName := "Fixed Asset".FieldCaption("FA Posting Group"); end; if GroupCodeName <> '' then begin GroupCodeName2 := GroupCodeName; if GroupTotals = GroupTotals::"Main Asset" then GroupCodeName2 := StrSubstNo('%1', SelectStr(GroupTotals + 1, GroupCodeNameTxt)); GroupCodeName := StrSubstNo('%1%2 %3', GroupTotalsTxt, ':', GroupCodeName2); end; end; local procedure ValidateDates() begin FAGenReport.ValidateDeprDates(StartingDate, EndingDate); EndingDate2 := EndingDate; StartingDate2 := StartingDate; end; local procedure MakeGroupHeadLine() begin case GroupTotals of GroupTotals::"FA Class": GroupHeadLine := "Fixed Asset"."FA Class Code"; GroupTotals::"FA Subclass": GroupHeadLine := "Fixed Asset"."FA Subclass Code"; GroupTotals::"FA Location": GroupHeadLine := "Fixed Asset"."FA Location Code"; GroupTotals::"Main Asset": begin FA."Main Asset/Component" := FA."Main Asset/Component"::"Main Asset"; GroupHeadLine := StrSubstNo('%1 %2', FA."Main Asset/Component", "Fixed Asset"."Component of Main Asset"); if "Fixed Asset"."Component of Main Asset" = '' then GroupHeadLine := StrSubstNo('%1%2', GroupHeadLine, '*****'); end; GroupTotals::"Global Dimension 1": GroupHeadLine := "Fixed Asset"."Global Dimension 1 Code"; GroupTotals::"Global Dimension 2": GroupHeadLine := "Fixed Asset"."Global Dimension 2 Code"; GroupTotals::"FA Posting Group": GroupHeadLine := "Fixed Asset"."FA Posting Group"; end; if GroupHeadLine = '' then GroupHeadLine := '*****'; end; local procedure UpdateTotals() var BudgetDepreciation: Codeunit "Budget Depreciation"; EntryNo: Integer; CodeName: Code[20]; begin EntryAmounts[1] := EntryAmounts[1] + DeprAmount + Custom1Amount; if Custom1DeprUntil > 0D then if UntilDate <= Custom1DeprUntil then EntryAmounts[4] := EntryAmounts[4] + DeprAmount + Custom1Amount; EntryAmounts[2] := EntryAmounts[2] + Custom1Amount; EntryAmounts[3] := EntryAmounts[3] + DeprAmount + Custom1Amount; AssetAmounts[1] := AssetAmounts[1] + DeprAmount; AssetAmounts[2] := AssetAmounts[2] + Custom1Amount; GroupAmounts[1] := GroupAmounts[1] + DeprAmount; GroupAmounts[2] := GroupAmounts[2] + Custom1Amount; TotalAmounts[1] := TotalAmounts[1] + DeprAmount; TotalAmounts[2] := TotalAmounts[2] + Custom1Amount; TotalBookValue[1] := TotalBookValue[1] + DeprAmount + Custom1Amount; TotalBookValue[2] := TotalBookValue[2] + DeprAmount + Custom1Amount; GroupTotalBookValue += DeprAmount + Custom1Amount; if BudgetNameCode <> '' then BudgetDepreciation.CopyProjectedValueToBudget( FADeprBook, BudgetNameCode, UntilDate, DeprAmount, Custom1Amount, BalAccount); if (UntilDate > 0D) or PrintAmountsPerDate then begin TempFABufferProjection.Reset(); if TempFABufferProjection.Find('+') then EntryNo := TempFABufferProjection."Entry No." + 1 else EntryNo := 1; TempFABufferProjection.SetRange("FA Posting Date", UntilDate); if GroupTotals <> GroupTotals::" " then begin case GroupTotals of GroupTotals::"FA Class": CodeName := "Fixed Asset"."FA Class Code"; GroupTotals::"FA Subclass": CodeName := "Fixed Asset"."FA Subclass Code"; GroupTotals::"FA Location": CodeName := "Fixed Asset"."FA Location Code"; GroupTotals::"Main Asset": CodeName := "Fixed Asset"."Component of Main Asset"; GroupTotals::"Global Dimension 1": CodeName := "Fixed Asset"."Global Dimension 1 Code"; GroupTotals::"Global Dimension 2": CodeName := "Fixed Asset"."Global Dimension 2 Code"; GroupTotals::"FA Posting Group": CodeName := "Fixed Asset"."FA Posting Group"; end; TempFABufferProjection.SetRange("Code Name", CodeName); end; if not TempFABufferProjection.Find('=><') then begin TempFABufferProjection.Init(); TempFABufferProjection."Code Name" := CodeName; TempFABufferProjection."FA Posting Date" := UntilDate; TempFABufferProjection."Entry No." := EntryNo; TempFABufferProjection.Depreciation := DeprAmount; TempFABufferProjection."Custom 1" := Custom1Amount; TempFABufferProjection.Insert(); end else begin TempFABufferProjection.Depreciation := TempFABufferProjection.Depreciation + DeprAmount; TempFABufferProjection."Custom 1" := TempFABufferProjection."Custom 1" + Custom1Amount; TempFABufferProjection.Modify(); end; end; end; local procedure InitGroupTotals() begin GroupAmounts[1] := 0; GroupAmounts[2] := 0; GroupAmounts[3] := 0; GroupAmounts[4] := 0; GroupTotalBookValue := 0; if NotFirstGroupTotal then TotalBookValue[1] := 0 else TotalBookValue[1] := EntryAmounts[1]; NotFirstGroupTotal := true; end; local procedure GetDeprBasis(): Decimal var FALedgEntry: Record "FA Ledger Entry"; begin FALedgEntry.SetCurrentKey("FA No.", "Depreciation Book Code", "Part of Book Value", "FA Posting Date"); FALedgEntry.SetRange("FA No.", "Fixed Asset"."No."); FALedgEntry.SetRange("Depreciation Book Code", DeprBookCode); FALedgEntry.SetRange("Part of Book Value", true); FALedgEntry.SetRange("FA Posting Date", 0D, Custom1DeprUntil); FALedgEntry.CalcSums(Amount); exit(FALedgEntry.Amount); end; local procedure CalculateGainLoss() var CalculateDisposal: Codeunit "Calculate Disposal"; EntryAmounts: array[15] of Decimal; PrevAmount: array[2] of Decimal; begin PrevAmount[1] := AssetAmounts[3]; PrevAmount[2] := AssetAmounts[4]; CalculateDisposal.CalcGainLoss("Fixed Asset"."No.", DeprBookCode, EntryAmounts, true); AssetAmounts[3] := FADeprBook."Projected Proceeds on Disposal"; if EntryAmounts[1] <> 0 then AssetAmounts[4] := EntryAmounts[1] else AssetAmounts[4] := EntryAmounts[2]; AssetAmounts[4] := AssetAmounts[4] + AssetAmounts[1] + AssetAmounts[2] - FADeprBook."Projected Proceeds on Disposal"; GroupAmounts[3] += AssetAmounts[3] - PrevAmount[1]; GroupAmounts[4] += AssetAmounts[4] - PrevAmount[2]; end; local procedure CalculationDone(Done: Boolean; FirstDeprDate: Date): Boolean var TableDeprCalculation: Codeunit "Table Depr. Calculation"; begin if Done or (FADeprBook."Depreciation Method" <> FADeprBook."Depreciation Method"::"User-Defined") then exit(Done); exit( TableDeprCalculation.GetTablePercent( DeprBookCode, FADeprBook."Depreciation Table Code", FADeprBook."First User-Defined Depr. Date", FirstDeprDate, UntilDate) = 0); end; local procedure UpdateReqForm() begin PageUpdateReqForm(); end; local procedure PageUpdateReqForm() var DeprBook: Record "Depreciation Book"; begin if DeprBookCode <> '' then DeprBook.Get(DeprBookCode); PeriodLength := 0; if DeprBook."Fiscal Year 365 Days" and not UseAccountingPeriod then PeriodLength := 365; end; procedure SetMandatoryFields(DepreciationBookCodeFrom: Code[10]; StartingDateFrom: Date; EndingDateFrom: Date) begin DeprBookCode := DepreciationBookCodeFrom; StartingDate := StartingDateFrom; EndingDate := EndingDateFrom; end; procedure SetPeriodFields(PeriodLengthFrom: Integer; DaysInFirstPeriodFrom: Integer; IncludePostedFromFrom: Date; UseAccountingPeriodFrom: Boolean) begin PeriodLength := PeriodLengthFrom; DaysInFirstPeriod := DaysInFirstPeriodFrom; IncludePostedFrom := IncludePostedFromFrom; UseAccountingPeriod := UseAccountingPeriodFrom; end; procedure SetTotalFields(GroupTotalsFrom: Option; PrintDetailsFrom: Boolean) begin GroupTotals := GroupTotalsFrom; PrintDetails := PrintDetailsFrom; end; procedure SetBudgetField(BudgetNameCodeFrom: Code[10]; BalAccountFrom: Boolean; ProjectedDisposalFrom: Boolean; PrintAmountsPerDateFrom: Boolean) begin BudgetNameCode := BudgetNameCodeFrom; BalAccount := BalAccountFrom; ProjectedDisposal := ProjectedDisposalFrom; PrintAmountsPerDate := PrintAmountsPerDateFrom; end; procedure GetFASetup() begin if DeprBookCode = '' then begin FASetup.Get(); DeprBookCode := FASetup."Default Depr. Book"; end; UpdateReqForm(); end; local procedure UpdateGroupTotals() begin GroupAmounts[1] := GroupAmounts[1] + DeprAmount; TotalAmounts[1] := TotalAmounts[1] + DeprAmount; end; [IntegrationEvent(true, false)] local procedure OnBeforeCalculateFirstDeprAmount(var FixedAsset: Record "Fixed Asset"; var CalculateDepr: Codeunit "Calculate Depreciation"; var DepreciationCalculation: Codeunit "Depreciation Calculation"; var FirstTime: Boolean; var Done: Boolean; var UntilDate: Date; var StartingDate: Date; var DeprAmount: Decimal; var Custom1Amount: Decimal; var NumberOfDays: Integer; var Custom1NumberOfDays: Integer; var DeprBookCode: Code[10]; var EntryAmounts: array[4] of Decimal; var DaysInFirstPeriod: Integer; var EndingDate: Date; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnAfterAccountingPeriodSetFilter(var PeriodEndingDate: Date; var Year365Days: Boolean; UseAccountingPeriod: Boolean; var AccountingPeriod: Record "Accounting Period") begin end; [IntegrationEvent(true, false)] local procedure OnAfterTransferValues(GroupAmounts: array[4] of Decimal; TotalBookValue: array[2] of Decimal) begin end;}#endif