Codeunit 5605 Calculate Disposal
src/Layers/W1/BaseApp/FixedAssets/FixedAsset/CalculateDisposal.Codeunit.al374 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;using Microsoft.FixedAssets.Maintenance;using Microsoft.FixedAssets.Posting;codeunit 5605 "Calculate Disposal"{ Permissions = TableData "FA Ledger Entry" = r, TableData "Maintenance Ledger Entry" = r; trigger OnRun() begin end; var FA: Record "Fixed Asset"; DeprBook: Record "Depreciation Book"; FADeprBook: Record "FA Depreciation Book"; DepreciationCalc: Codeunit "Depreciation Calculation"; procedure CalcGainLoss(FANo: Code[20]; DeprBookCode: Code[10]; var EntryAmounts: array[14] of Decimal) var ExtendedEntryAmounts: array[15] of Decimal; i: Integer; begin for i := 1 to ArrayLen(EntryAmounts) do ExtendedEntryAmounts[i] := EntryAmounts[i]; CalcGainLoss(FANo, DeprBookCode, ExtendedEntryAmounts, false); CopyArray(EntryAmounts, ExtendedEntryAmounts, 1, 14); end; procedure CalcGainLoss(FANo: Code[20]; DeprBookCode: Code[10]; var EntryAmounts: array[15] of Decimal; IncludeAdditionalPostingTypes: Boolean) var EntryAmounts2: array[4] of Decimal; GainLoss: Decimal; I: Integer; IsHandled: Boolean; begin OnBeforeCalcGainLoss(FANo, DeprBookCode, EntryAmounts); ClearAll(); Clear(EntryAmounts); DeprBook.Get(DeprBookCode); FA.Get(FANo); DepreciationCalc.CalcEntryAmounts(FANo, DeprBookCode, 0D, 0D, EntryAmounts2); for I := 1 to 4 do EntryAmounts[I + 4] := -EntryAmounts2[I]; FADeprBook.Get(FANo, DeprBookCode); FADeprBook.CalcFields( "Book Value", "Proceeds on Disposal", "Acquisition Cost", "Salvage Value", Depreciation, "Derogatory Amount"); EntryAmounts[3] := -FADeprBook."Acquisition Cost"; EntryAmounts[4] := -FADeprBook.Depreciation; EntryAmounts[9] := -FADeprBook."Salvage Value"; if IncludeAdditionalPostingTypes then EntryAmounts[15] := -FADeprBook."Derogatory Amount"; OnCalcGainLossOnAfterSetEntryAmounts(FANo, DeprBookCode, EntryAmounts); if DeprBook."Disposal Calculation Method" = DeprBook."Disposal Calculation Method"::Gross then EntryAmounts[10] := FADeprBook."Book Value"; IsHandled := false; OnAfterSetEntryAmountsOnBeforeGainLoss(FANo, FADeprBook, DeprBookCode, EntryAmounts, GainLoss, IsHandled); if not IsHandled then GainLoss := FADeprBook."Book Value" + FADeprBook."Proceeds on Disposal"; for I := 0 to 3 do if not DepreciationCalc.GetPartOfCalculation(1, I, DeprBookCode) then begin // 5..8 are disposal. 11..14 are bal. disposal GainLoss := GainLoss + EntryAmounts[I + 5]; if DeprBook."Disposal Calculation Method" = DeprBook."Disposal Calculation Method"::Net then EntryAmounts[I + 11] := -EntryAmounts[I + 5]; end; if GainLoss <= 0 then EntryAmounts[1] := GainLoss else EntryAmounts[2] := GainLoss; end; procedure CalcSecondGainLoss(FANo: Code[20]; DeprBookCode: Code[10]; LastDisposalPrice: Decimal; var EntryAmounts: array[14] of Decimal) var NewGainLoss: Decimal; begin ClearAll(); Clear(EntryAmounts); FADeprBook.Get(FANo, DeprBookCode); FADeprBook.CalcFields("Gain/Loss"); OnCalcSecondGainLossAfterCalcFieldGainLoss(FADeprBook); NewGainLoss := LastDisposalPrice + FADeprBook."Gain/Loss"; if IdenticalSign(NewGainLoss, FADeprBook."Gain/Loss") then begin if FADeprBook."Gain/Loss" <= 0 then EntryAmounts[1] := LastDisposalPrice else EntryAmounts[2] := LastDisposalPrice end else if FADeprBook."Gain/Loss" <= 0 then begin EntryAmounts[1] := -FADeprBook."Gain/Loss"; EntryAmounts[2] := NewGainLoss; end else begin EntryAmounts[2] := -FADeprBook."Gain/Loss"; EntryAmounts[1] := NewGainLoss; end; end; procedure CalcReverseAmounts(FANo: Code[20]; DeprBookCode: Code[10]; var EntryAmounts: array[4] of Decimal) var ExtendedEntryAmounts: array[5] of Decimal; i: Integer; begin for i := 1 to ArrayLen(EntryAmounts) do ExtendedEntryAmounts[i] := EntryAmounts[i]; CalcReverseAmounts(FANo, DeprBookCode, ExtendedEntryAmounts, false); CopyArray(EntryAmounts, ExtendedEntryAmounts, 1, 4); end; procedure CalcReverseAmounts(FANo: Code[20]; DeprBookCode: Code[10]; var EntryAmounts: array[5] of Decimal; IncludeAdditionalPostingTypes: Boolean) var FAPostingTypeSetup: Record "FA Posting Type Setup"; BookValueAmounts: array[4] of Decimal; i: Integer; IsHandled: Boolean; begin Clear(EntryAmounts); FADeprBook.Get(FANo, DeprBookCode); DepreciationCalc.CalcEntryAmounts(FANo, DeprBookCode, 0D, 0D, BookValueAmounts); IsHandled := false; OnCalcReverseAmountsBeforeSetEntryAmounts(FANo, DeprBookCode, EntryAmounts, BookValueAmounts, IsHandled); if IsHandled then exit; for i := 1 to 4 do begin FAPostingTypeSetup.Get(DeprBookCode, i - 1); if FAPostingTypeSetup."Part of Book Value" and FAPostingTypeSetup."Reverse before Disposal" then begin if i = 1 then begin FADeprBook.CalcFields("Write-Down"); EntryAmounts[i] := -FADeprBook."Write-Down"; end; if i = 2 then begin FADeprBook.CalcFields(Appreciation); EntryAmounts[i] := -FADeprBook.Appreciation; end; if i = 3 then begin FADeprBook.CalcFields("Custom 1"); EntryAmounts[i] := -FADeprBook."Custom 1"; end; if i = 4 then begin FADeprBook.CalcFields("Custom 2"); EntryAmounts[i] := -FADeprBook."Custom 2"; end; if EntryAmounts[i] + BookValueAmounts[i] <> 0 then FAPostingTypeSetup.TestField("Reverse before Disposal", false); end; end; if IncludeAdditionalPostingTypes then EntryAmounts[5] := -CalcDerogatoryReverseAmount(FADeprBook); end; procedure GetDisposalType(FANo: Code[20]; DeprBookCode: Code[10]; ErrorNo: Integer; var DisposalType: Option FirstDisposal,SecondDisposal,ErrorDisposal,LastErrorDisposal; var DisposalMethod: Option " ",Net,Gross; var MaxDisposalNo: Integer; var SalesEntryNo: Integer) var FALedgEntry: Record "FA Ledger Entry"; DeprBook: Record "Depreciation Book"; begin ClearAll(); MaxDisposalNo := 0; SalesEntryNo := 0; DisposalType := DisposalType::FirstDisposal; DepreciationCalc.SetFAFilter(FALedgEntry, FANo, DeprBookCode, true); FALedgEntry.SetRange("FA Posting Type", FALedgEntry."FA Posting Type"::"Proceeds on Disposal"); OnGetDisposalTypeSetOnAfterSetFilterFALedgEntry(FALedgEntry); if FALedgEntry.Find('-') then begin repeat DisposalMethod := GetDisposalMethod(FALedgEntry); if FALedgEntry."Disposal Entry No." > MaxDisposalNo then begin MaxDisposalNo := FALedgEntry."Disposal Entry No."; SalesEntryNo := FALedgEntry."Entry No."; end; until FALedgEntry.Next() = 0; if ErrorNo = 0 then begin DeprBook.Get(DeprBookCode); DeprBook.TestField("Allow Correction of Disposal"); DisposalType := DisposalType::SecondDisposal; end else if MaxDisposalNo = 1 then DisposalType := DisposalType::LastErrorDisposal else DisposalType := DisposalType::ErrorDisposal; end; end; local procedure GetDisposalMethod(FALedgEntry: Record "FA Ledger Entry") DisposalMethod: Option " ",Net,Gross begin DisposalMethod := FALedgEntry."Disposal Calculation Method"; OnAfterGetDisposalMethod(DisposalMethod); end; procedure GetErrorDisposal(FANo: Code[20]; DeprBookCode: Code[10]; OnlyGainLoss: Boolean; MaxDisposalNo: Integer; var EntryAmounts: array[14] of Decimal; var EntryNumbers: array[14] of Integer) var FALedgEntry: Record "FA Ledger Entry"; i: Integer; begin ClearAll(); Clear(EntryNumbers); DepreciationCalc.SetFAFilter(FALedgEntry, FANo, DeprBookCode, true); FALedgEntry.SetRange("FA Posting Type", FALedgEntry."FA Posting Type"::"Gain/Loss"); OnGetErrorDisposalOnAfterSetFilterFALedgEntry(FALedgEntry); if FALedgEntry.Find('-') then repeat if FALedgEntry."Disposal Entry No." = MaxDisposalNo then begin if FALedgEntry."Result on Disposal" = FALedgEntry."Result on Disposal"::Gain then begin EntryAmounts[1] := -FALedgEntry.Amount; EntryNumbers[1] := FALedgEntry."Entry No."; end; if FALedgEntry."Result on Disposal" = FALedgEntry."Result on Disposal"::Loss then begin EntryAmounts[2] := -FALedgEntry.Amount; EntryNumbers[2] := FALedgEntry."Entry No."; end; end; until FALedgEntry.Next() = 0; if not OnlyGainLoss then for i := 3 to 14 do begin FALedgEntry.SetRange("FA Posting Category", SetFALedgerPostingCategory(i)); FALedgEntry.SetRange("FA Posting Type", SetFAPostingType(i)); if FALedgEntry.FindFirst() then begin EntryNumbers[i] := FALedgEntry."Entry No."; EntryAmounts[i] := -FALedgEntry.Amount; end; end; end; local procedure IdenticalSign(A: Decimal; B: Decimal): Boolean begin exit(((A <= 0) and (B <= 0)) or ((A >= 0) and (B >= 0))); end; procedure SetFAPostingType(i: Integer): Integer var FALedgEntry: Record "FA Ledger Entry"; begin case i of 1, 2: FALedgEntry."FA Posting Type" := FALedgEntry."FA Posting Type"::"Gain/Loss"; 3: FALedgEntry."FA Posting Type" := FALedgEntry."FA Posting Type"::"Acquisition Cost"; 4: FALedgEntry."FA Posting Type" := FALedgEntry."FA Posting Type"::Depreciation; 5, 11: FALedgEntry."FA Posting Type" := FALedgEntry."FA Posting Type"::"Write-Down"; 6, 12: FALedgEntry."FA Posting Type" := FALedgEntry."FA Posting Type"::Appreciation; 7, 13: FALedgEntry."FA Posting Type" := FALedgEntry."FA Posting Type"::"Custom 1"; 8, 14: FALedgEntry."FA Posting Type" := FALedgEntry."FA Posting Type"::"Custom 2"; 9: FALedgEntry."FA Posting Type" := FALedgEntry."FA Posting Type"::"Salvage Value"; 10: FALedgEntry."FA Posting Type" := FALedgEntry."FA Posting Type"::"Book Value on Disposal"; 15: FALedgEntry."FA Posting Type" := FALedgEntry."FA Posting Type"::Derogatory; end; OnAfterSetFAPostingType(i, FALedgEntry); exit(FALedgEntry."FA Posting Type".AsInteger()); end; procedure SetFALedgerPostingCategory(i: Integer): Enum "FA Ledger Posting Category" var FALedgEntry: Record "FA Ledger Entry"; begin case i of 1 .. 2: FALedgEntry."FA Posting Category" := FALedgEntry."FA Posting Category"::" "; 3 .. 10: FALedgEntry."FA Posting Category" := FALedgEntry."FA Posting Category"::Disposal; 11 .. 14: FALedgEntry."FA Posting Category" := FALedgEntry."FA Posting Category"::"Bal. Disposal"; end; OnAfterSetFAPostingCategory(i, FALedgEntry); exit(FALedgEntry."FA Posting Category"); end; procedure SetReverseType(i: Integer): Integer var FALedgEntry: Record "FA Ledger Entry"; begin case i of 1: FALedgEntry."FA Posting Type" := FALedgEntry."FA Posting Type"::"Write-Down"; 2: FALedgEntry."FA Posting Type" := FALedgEntry."FA Posting Type"::Appreciation; 3: FALedgEntry."FA Posting Type" := FALedgEntry."FA Posting Type"::"Custom 1"; 4: FALedgEntry."FA Posting Type" := FALedgEntry."FA Posting Type"::"Custom 2"; 5: FALedgEntry."FA Posting Type" := FALedgEntry."FA Posting Type"::Derogatory; end; exit(FALedgEntry."FA Posting Type".AsInteger()); end; local procedure CalcDerogatoryReverseAmount(FADepreciationBook: Record "FA Depreciation Book"): Decimal var FALedgEntry: Record "FA Ledger Entry"; begin FALedgEntry.SetRange("FA No.", FADepreciationBook."FA No."); FALedgEntry.SetRange("Depreciation Book Code", FADepreciationBook."Depreciation Book Code"); FALedgEntry.SetRange("FA Posting Category", FALedgEntry."FA Posting Category"::" "); FALedgEntry.SetRange("FA Posting Type", FALedgEntry."FA Posting Type"::Derogatory); FALedgEntry.SetFilter("FA Posting Date", FADepreciationBook.GetFilter("FA Posting Date Filter")); FALedgEntry.CalcSums(Amount); exit(FALedgEntry.Amount); end; [IntegrationEvent(false, false)] local procedure OnCalcGainLossOnAfterSetEntryAmounts(FANo: Code[20]; DeprBookCode: Code[10]; var EntryAmounts: array[14] of Decimal) begin end; [IntegrationEvent(false, false)] local procedure OnAfterSetEntryAmountsOnBeforeGainLoss( FANo: Code[20]; FADeprBook: Record "FA Depreciation Book"; DeprBookCode: Code[10]; var EntryAmounts: array[14] of Decimal; var GainLoss: Decimal; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnAfterGetDisposalMethod(var DisposalMethod: Option " ",Net,Gross) begin end; [IntegrationEvent(false, false)] local procedure OnCalcSecondGainLossAfterCalcFieldGainLoss(var FADeprBook: Record "FA Depreciation Book") begin end; [IntegrationEvent(false, false)] local procedure OnCalcReverseAmountsBeforeSetEntryAmounts(FANo: Code[20]; DeprBookCode: Code[10]; var EntryAmounts: array[4] of Decimal; BookValueAmounts: array[4] of Decimal; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeCalcGainLoss(FANo: Code[20]; DeprBookCode: Code[10]; var EntryAmounts: array[14] of Decimal) begin end; [IntegrationEvent(false, false)] local procedure OnAfterSetFAPostingType(i: Integer; var FALedgerEntry: Record "FA Ledger Entry") begin end; [IntegrationEvent(false, false)] local procedure OnAfterSetFAPostingCategory(i: Integer; var FALedgerEntry: Record "FA Ledger Entry") begin end; [IntegrationEvent(false, false)] local procedure OnGetDisposalTypeSetOnAfterSetFilterFALedgEntry(var FALedgerEntry: Record "FA Ledger Entry") begin end; [IntegrationEvent(false, false)] local procedure OnGetErrorDisposalOnAfterSetFilterFALedgEntry(var FALedgerEntry: Record "FA Ledger Entry") begin end;}