Codeunit 5626 FA General Report
src/Layers/W1/BaseApp/FixedAssets/FixedAsset/FAGeneralReport.Codeunit.al361 lines, Copyright (c) Microsoft Corporation. MIT
// ------------------------------------------------------------------------------------------------// 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.FixedAsset;using Microsoft.FixedAssets.Depreciation;using Microsoft.FixedAssets.Ledger;codeunit 5626 "FA General Report"{ Permissions = TableData "Fixed Asset" = rm; trigger OnRun() begin end; var FADeprBook: Record "FA Depreciation Book"; FALedgEntry: Record "FA Ledger Entry"; DepreciationCalc: Codeunit "Depreciation Calculation"; UseCreditAmounts: Boolean; UseDebitAmounts: Boolean;#pragma warning disable AA0074 Text000: Label 'Posting Date Filter'; Text001: Label 'You must specify the Starting Date and the Ending Date.'; Text002: Label 'The Starting Date is later than the Ending Date.'; Text003: Label 'You must not specify closing dates.'; Text004: Label 'You must specify the First Depreciation Date and the Last Depreciation Date.'; Text005: Label 'The First Depreciation Date is later than the Last Depreciation Date.'; Text006: Label 'Sorting fixed assets';#pragma warning restore AA0074 procedure GetLastDate(FANo: Code[20]; PostingType: Integer; EndingDate: Date; DeprBookCode: Code[10]; GLEntry: Boolean): Date var FirstLast: Text[1]; begin ClearAll(); if PostingType = 0 then exit(0D); if EndingDate = 0D then EndingDate := DMY2Date(31, 12, 9999); FALedgEntry.Reset(); if GLEntry then begin FALedgEntry.SetCurrentKey( "FA No.", "Depreciation Book Code", "FA Posting Category", "FA Posting Type", "Posting Date"); FALedgEntry.SetRange("Depreciation Book Code", DeprBookCode); FALedgEntry.SetRange("FA No.", FANo); FALedgEntry.SetRange("FA Posting Category", FALedgEntry."FA Posting Category"::" "); FALedgEntry.SetRange("Posting Date", 0D, EndingDate); end else begin DepreciationCalc.SetFAFilter(FALedgEntry, FANo, DeprBookCode, true); FALedgEntry.SetRange("FA Posting Date", 0D, EndingDate); end; FirstLast := '+'; case PostingType of FADeprBook.FieldNo("Last Acquisition Cost Date"): FALedgEntry.SetRange("FA Posting Type", FALedgEntry."FA Posting Type"::"Acquisition Cost"); FADeprBook.FieldNo("Last Depreciation Date"): FALedgEntry.SetFilter("FA Posting Type", '%1|%2', FALedgEntry."FA Posting Type"::Depreciation, FALedgEntry."FA Posting Type"::"Bonus Depreciation"); FADeprBook.FieldNo("Last Write-Down Date"): FALedgEntry.SetRange("FA Posting Type", FALedgEntry."FA Posting Type"::"Write-Down"); FADeprBook.FieldNo("Last Appreciation Date"): FALedgEntry.SetRange("FA Posting Type", FALedgEntry."FA Posting Type"::Appreciation); FADeprBook.FieldNo("Last Custom 1 Date"): FALedgEntry.SetRange("FA Posting Type", FALedgEntry."FA Posting Type"::"Custom 1"); FADeprBook.FieldNo("Last Derogatory"): FALedgEntry.SetRange("FA Posting Type", FALedgEntry."FA Posting Type"::Derogatory); FADeprBook.FieldNo("Last Custom 2 Date"): FALedgEntry.SetRange("FA Posting Type", FALedgEntry."FA Posting Type"::"Custom 2"); FADeprBook.FieldNo("Last Salvage Value Date"): FALedgEntry.SetRange("FA Posting Type", FALedgEntry."FA Posting Type"::"Salvage Value"); FADeprBook.FieldNo("Acquisition Date"), FADeprBook.FieldNo("G/L Acquisition Date"): begin FALedgEntry.SetRange("FA Posting Type", FALedgEntry."FA Posting Type"::"Acquisition Cost"); FirstLast := '-'; end; FADeprBook.FieldNo("Disposal Date"): begin FALedgEntry.SetRange("FA Posting Type", FALedgEntry."FA Posting Type"::"Proceeds on Disposal"); FirstLast := '-'; end; end; OnGetLastDateOnAfterFALedgEntrySetFilters(FALedgEntry, FADeprBook, PostingType, FirstLast); if FALedgEntry.Find(FirstLast) then begin if GLEntry then exit(FALedgEntry."Posting Date"); exit(FALedgEntry."FA Posting Date"); end; exit(0D); end; procedure CalcFAPostedAmount(FANo: Code[20]; PostingType: Integer; Period: Option "Before Starting Date","Net Change","at Ending Date"; StartingDate: Date; EndingDate: Date; DeprBookCode: Code[10]; BeforeAmount: Decimal; UntilAmount: Decimal; OnlyReclassified: Boolean; OnlyBookValue: Boolean) Result: Decimal begin case true of UseCreditAmounts: begin ClearAll(); UseCreditAmounts := true; end; UseDebitAmounts: begin ClearAll(); UseDebitAmounts := true end; else ClearAll(); end; if PostingType = 0 then exit(0); if EndingDate = 0D then EndingDate := DMY2Date(31, 12, 9999); case PostingType of FADeprBook.FieldNo("Book Value"): FALedgEntry.SetCurrentKey("FA No.", "Depreciation Book Code", "Part of Book Value"); FADeprBook.FieldNo("Depreciable Basis"): FALedgEntry.SetCurrentKey("FA No.", "Depreciation Book Code", "Part of Depreciable Basis"); else begin FALedgEntry.SetCurrentKey( "FA No.", "Depreciation Book Code", "FA Posting Category", "FA Posting Type", "FA Posting Date"); FALedgEntry.SetRange("FA Posting Category", FALedgEntry."FA Posting Category"::" "); end; end; FALedgEntry.SetRange("FA No.", FANo); FALedgEntry.SetRange("Depreciation Book Code", DeprBookCode); if OnlyReclassified then FALedgEntry.SetRange("Reclassification Entry", true); if OnlyBookValue then FALedgEntry.SetRange("Part of Book Value", true); case PostingType of FADeprBook.FieldNo("Acquisition Cost"): FALedgEntry.SetRange("FA Posting Type", FALedgEntry."FA Posting Type"::"Acquisition Cost"); FADeprBook.FieldNo(Depreciation): FALedgEntry.SetFilter("FA Posting Type", '%1|%2', FALedgEntry."FA Posting Type"::Depreciation, FALedgEntry."FA Posting Type"::"Bonus Depreciation"); FADeprBook.FieldNo("Write-Down"): FALedgEntry.SetRange("FA Posting Type", FALedgEntry."FA Posting Type"::"Write-Down"); FADeprBook.FieldNo(Appreciation): FALedgEntry.SetRange("FA Posting Type", FALedgEntry."FA Posting Type"::Appreciation); FADeprBook.FieldNo("Custom 1"): FALedgEntry.SetRange("FA Posting Type", FALedgEntry."FA Posting Type"::"Custom 1"); FADeprBook.FieldNo("Derogatory Amount"): FALedgEntry.SetRange("FA Posting Type", FALedgEntry."FA Posting Type"::Derogatory); FADeprBook.FieldNo("Custom 2"): FALedgEntry.SetRange("FA Posting Type", FALedgEntry."FA Posting Type"::"Custom 2"); FADeprBook.FieldNo("Proceeds on Disposal"): FALedgEntry.SetRange("FA Posting Type", FALedgEntry."FA Posting Type"::"Proceeds on Disposal"); FADeprBook.FieldNo("Gain/Loss"): FALedgEntry.SetRange("FA Posting Type", FALedgEntry."FA Posting Type"::"Gain/Loss"); FADeprBook.FieldNo("Salvage Value"): FALedgEntry.SetRange("FA Posting Type", FALedgEntry."FA Posting Type"::"Salvage Value"); FADeprBook.FieldNo("Book Value"): FALedgEntry.SetRange("Part of Book Value", true); FADeprBook.FieldNo("Depreciable Basis"): FALedgEntry.SetRange("Part of Depreciable Basis", true); end; OnBeforeCalcFAPostedAmount(FALedgEntry, PostingType); case Period of Period::"Before Starting Date": FALedgEntry.SetRange("FA Posting Date", 0D, StartingDate - 1); Period::"Net Change": FALedgEntry.SetRange("FA Posting Date", StartingDate, EndingDate); Period::"at Ending Date": FALedgEntry.SetRange("FA Posting Date", 0D, EndingDate); end; if (PostingType = FADeprBook.FieldNo("Derogatory Amount")) then FALedgEntry.CalcSums(Amount, "Debit Amount", "Credit Amount") else FALedgEntry.CalcSums(Amount); if (PostingType = FADeprBook.FieldNo("Book Value")) or (PostingType = FADeprBook.FieldNo(Depreciation)) then case Period of Period::"Before Starting Date": FALedgEntry.Amount := FALedgEntry.Amount + BeforeAmount; Period::"Net Change": FALedgEntry.Amount := FALedgEntry.Amount - BeforeAmount + UntilAmount; Period::"at Ending Date": FALedgEntry.Amount := FALedgEntry.Amount + UntilAmount; end; Result := FALedgEntry.Amount; if (PostingType = FADeprBook.FieldNo("Derogatory Amount")) then begin if UseCreditAmounts then begin Clear(UseCreditAmounts); Result := FALedgEntry."Credit Amount"; end; if UseDebitAmounts then begin Clear(UseDebitAmounts); Result := FALedgEntry."Debit Amount"; end; end; OnAfterCalcFAPostedAmount(FALedgEntry, PostingType, Period, BeforeAmount, UntilAmount, Result); end; procedure CalcGLPostedAmount(FANo: Code[20]; PostingType: Integer; Period: Option " ",Disposal,"Bal. Disposal"; StartingDate: Date; EndingDate: Date; DeprBookCode: Code[10]): Decimal begin ClearAll(); if PostingType = 0 then exit(0); if EndingDate = 0D then EndingDate := DMY2Date(31, 12, 9999); FALedgEntry.SetCurrentKey("FA No.", "Depreciation Book Code", "FA Posting Category", "FA Posting Type", "Posting Date"); FALedgEntry.SetRange("FA No.", FANo); FALedgEntry.SetRange("Depreciation Book Code", DeprBookCode); FALedgEntry.SetRange("FA Posting Category", Period); FALedgEntry.SetRange("Posting Date", StartingDate, EndingDate); case PostingType of FADeprBook.FieldNo("Acquisition Cost"): FALedgEntry.SetRange("FA Posting Type", FALedgEntry."FA Posting Type"::"Acquisition Cost"); FADeprBook.FieldNo(Depreciation): FALedgEntry.SetFilter("FA Posting Type", '%1|%2', FALedgEntry."FA Posting Type"::Depreciation, FALedgEntry."FA Posting Type"::"Bonus Depreciation"); FADeprBook.FieldNo("Write-Down"): FALedgEntry.SetRange("FA Posting Type", FALedgEntry."FA Posting Type"::"Write-Down"); FADeprBook.FieldNo(Appreciation): FALedgEntry.SetRange("FA Posting Type", FALedgEntry."FA Posting Type"::Appreciation); FADeprBook.FieldNo("Custom 1"): FALedgEntry.SetRange("FA Posting Type", FALedgEntry."FA Posting Type"::"Custom 1"); FADeprBook.FieldNo("Derogatory Amount"): FALedgEntry.SetRange("FA Posting Type", FALedgEntry."FA Posting Type"::Derogatory); FADeprBook.FieldNo("Custom 2"): FALedgEntry.SetRange("FA Posting Type", FALedgEntry."FA Posting Type"::"Custom 2"); FADeprBook.FieldNo("Proceeds on Disposal"): FALedgEntry.SetRange("FA Posting Type", FALedgEntry."FA Posting Type"::"Proceeds on Disposal"); FADeprBook.FieldNo("Gain/Loss"): FALedgEntry.SetRange("FA Posting Type", FALedgEntry."FA Posting Type"::"Gain/Loss"); FADeprBook.FieldNo("Book Value on Disposal"): FALedgEntry.SetRange("FA Posting Type", FALedgEntry."FA Posting Type"::"Book Value on Disposal"); end; OnCalcGLPostedAmountOnBeforeCalcAmount(FALedgEntry, PostingType); FALedgEntry.CalcSums(Amount); OnCalcGLPostedAmountOnAfterCalcAmount(FALedgEntry, PostingType, FALedgEntry.Amount); exit(FALedgEntry.Amount); end; procedure AppendFAPostingFilter(var FA: Record "Fixed Asset"; StartingDate: Date; EndingDate: Date) begin if (StartingDate = 0D) and (EndingDate = 0D) then exit; if StartingDate = 0D then FA.SetFilter("FA Posting Date Filter", '..%1', EndingDate) else if EndingDate = 0D then FA.SetFilter("FA Posting Date Filter", '%1..', StartingDate) else FA.SetFilter("FA Posting Date Filter", '%1..%2', StartingDate, EndingDate); end; procedure AppendPostingDateFilter(var FAFilter: Text; StartingDate: Date; EndingDate: Date) var PostingDateFilter: Text[50]; begin PostingDateFilter := StrSubstNo('%1: %2..%3', Text000, StartingDate, EndingDate); if FAFilter = '' then FAFilter := PostingDateFilter else FAFilter := FAFilter + StrSubstNo('%1 %2', ',', PostingDateFilter); end; procedure ValidateDates(StartingDate: Date; EndingDate: Date) begin if (EndingDate = 0D) or (StartingDate <= 00000101D) then Error(Text001); if StartingDate > EndingDate then Error(Text002); if (NormalDate(StartingDate) <> StartingDate) or (NormalDate(EndingDate) <> EndingDate) then Error(Text003); end; procedure ValidateDeprDates(StartingDate: Date; EndingDate: Date) begin if (EndingDate = 0D) or (StartingDate <= 00000101D) then Error(Text004); if StartingDate > EndingDate then Error(Text005); if (NormalDate(StartingDate) <> StartingDate) or (NormalDate(EndingDate) <> EndingDate) then Error(Text003); end; procedure SetFAPostingGroup(var FA2: Record "Fixed Asset"; DeprBookCode: Code[10]) var FA: Record "Fixed Asset"; FADeprBook: Record "FA Depreciation Book"; Window: Dialog; IsHandled: Boolean; begin IsHandled := false; OnBeforeSetFAPostingGroup(FA2, DeprBookCode, IsHandled); if IsHandled then exit; Window.Open(Text006); FA.LockTable(); FA.Copy(FA2); FA.SetRange("FA Posting Group"); if FA.Find('-') then repeat if FADeprBook.Get(FA."No.", DeprBookCode) then if (FA."FA Posting Group" <> FADeprBook."FA Posting Group") and (FADeprBook."FA Posting Group" <> '') then begin FA."FA Posting Group" := FADeprBook."FA Posting Group"; FA.Modify(); end; until FA.Next() = 0; Commit(); Window.Close(); end; procedure SetSign(Sign: Boolean) begin if Sign = true then begin UseCreditAmounts := true; UseDebitAmounts := false end else begin UseCreditAmounts := false; UseDebitAmounts := true; end; end; [IntegrationEvent(false, false)] local procedure OnAfterCalcFAPostedAmount(var FALedgerEntry: Record "FA Ledger Entry"; PostingType: Integer; Period: Option "Before Starting Date","Net Change","at Ending Date"; BeforeAmount: Decimal; UntilAmount: Decimal; var Result: Decimal) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeCalcFAPostedAmount(var FALedgerEntry: Record "FA Ledger Entry"; PostingType: Integer) begin end; [IntegrationEvent(false, false)] local procedure OnCalcGLPostedAmountOnBeforeCalcAmount(var FALedgerEntry: Record "FA Ledger Entry"; PostingType: Integer) begin end; [IntegrationEvent(false, false)] local procedure OnGetLastDateOnAfterFALedgEntrySetFilters(var FALedgerEntry: Record "FA Ledger Entry"; var FADeprBook: Record "FA Depreciation Book"; PostingType: Integer; FirstLast: Text) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeSetFAPostingGroup(var FixedAsset: Record "Fixed Asset"; DeprBookCode: Code[10]; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnCalcGLPostedAmountOnAfterCalcAmount(var FALedgerEntry: Record "FA Ledger Entry"; PostingType: Integer; var Amount: Decimal) begin end;}