Report 5611 FA Posting Group - Net Change
src/Layers/W1/BaseApp/FixedAssets/Reports/FAPostingGroupNetChange.Report.al557 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.Reports;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.FixedAssets.Depreciation;using Microsoft.FixedAssets.FixedAsset;using Microsoft.FixedAssets.Ledger;using Microsoft.FixedAssets.Maintenance;using System.Utilities;report 5611 "FA Posting Group - Net Change"{ AdditionalSearchTerms = 'fixed asset posting group net change'; ApplicationArea = FixedAssets; Caption = 'FA Posting Group - Net Change'; UsageCategory = ReportsAndAnalysis; DefaultRenderingLayout = RDLCLayout; dataset { dataitem("FA Depreciation Book"; "FA Depreciation Book") { DataItemTableView = sorting("FA No.", "Depreciation Book Code"); RequestFilterFields = "FA No.", "Depreciation Book Code", "FA Posting Group"; column(TodayFormatted; Format(Today, 0, 4)) { } column(CompanyName; COMPANYPROPERTY.DisplayName()) { } column(FADeprBookBookFilter; TableCaption + ': ' + FADeprBookFilter) { } column(FAPostingGroupNetChangeCaption; FAPostingGroupNetChangeCaptionLbl) { } column(CurrReportPageNoCaption; CurrReportPageNoCaptionLbl) { } trigger OnAfterGetRecord() begin if not FAPostingGr.Get("FA Posting Group") then CurrReport.Skip(); FANo := "FA No."; DeprBookCode := "Depreciation Book Code"; if "Disposal Date" > 0D then begin Counter := Type::BalC2; CalcFields("Gain/Loss"); SoldWithGain := ("Gain/Loss" <= 0); NetDisposalMethod := CalcNetDisposalMethod(); end else Counter := Type::Maint; I := 0; while I <= Counter do begin Type := I; CalculateAccount("FA Posting Group", FieldCaptionText, AccNo, PostAmount); InsertAmount("FA Posting Group", FieldCaptionText, AccNo, PostAmount); I := I + 1; end; end; } dataitem("Integer"; "Integer") { DataItemTableView = sorting(Number) where(Number = filter(1 ..)); column(OnlyTotals; OnlyTotals) { } column(FAPostGrp_FAPostGrBuffer1; TempFAPostGroupBuffer[1]."FA Posting Group") { } column(FAFieldCapt_FAPostGrpBuff; TempFAPostGroupBuffer[1]."FA FieldCaption") { } column(AccNo_FAPostGrpBuffer1; TempFAPostGroupBuffer[1]."Account No.") { } column(Amt_FAPostGroupBuffer1; TempFAPostGroupBuffer[1].Amount) { } column(AccName_FAPostGrpBuff1; TempFAPostGroupBuffer[1]."Account Name") { } column(IntBody2Cond; not OnlyTotals and (TempFAPostGroupBuffer[1].Amount <> 0)) { } column(AccountNoCaption; AccountNoCaptionLbl) { } column(FieldNameCaption; FieldNameCaptionLbl) { } column(FAPostingGroupCaption; FAPostingGroupCaptionLbl) { } trigger OnAfterGetRecord() begin if Number = 1 then begin if not TempFAPostGroupBuffer[1].Find('-') then CurrReport.Break(); end else if TempFAPostGroupBuffer[1].Next() = 0 then CurrReport.Break(); end; } dataitem(Headline; "Integer") { DataItemTableView = sorting(Number) where(Number = const(1)); trigger OnAfterGetRecord() begin TempFAPostGroupBuffer[1].SetCurrentKey("Account No."); TempFAPostGroupBuffer2.SetCurrentKey("Account No."); OldAccNo := ''; while TempFAPostGroupBuffer[1].Find('-') do begin TempFAPostGroupBuffer2 := TempFAPostGroupBuffer[1]; if OldAccNo <> TempFAPostGroupBuffer2."Account No." then begin TempFAPostGroupBuffer[1].SetRange("Account No.", TempFAPostGroupBuffer2."Account No."); TempFAPostGroupBuffer[1].CalcSums(Amount); TempFAPostGroupBuffer2.Amount := TempFAPostGroupBuffer[1].Amount; TempFAPostGroupBuffer2.Insert(); TempFAPostGroupBuffer[1].DeleteAll(); TempFAPostGroupBuffer[1].SetRange("Account No."); end; OldAccNo := TempFAPostGroupBuffer2."Account No."; end; end; } dataitem(Total; "Integer") { DataItemTableView = sorting(Number) where(Number = filter(1 ..)); column(FirstTotalHeader; FirstTotalHeader) { } column(AccNo_FAPostGrpBuffer2; TempFAPostGroupBuffer2."Account No.") { } column(AccName_FAPostGrpBuff2; TempFAPostGroupBuffer2."Account Name") { } column(Amt_FAPostGrpBuffer2; TempFAPostGroupBuffer2.Amount) { } column(GLAccNetChange; GLAcc."Net Change") { } column(GLAccChngFAPostBuffAmt; GLAcc."Net Change" - TempFAPostGroupBuffer2.Amount) { } column(TotalBody3Cond; (GLAcc."Net Change" <> 0) or (TempFAPostGroupBuffer2.Amount <> 0)) { } column(TotalperGLAccountCaption; TotalperGLAccountCaptionLbl) { } column(NetChangeCaption; NetChangeCaptionLbl) { } column(AccNoCaption; AccNoCaptionLbl) { } column(DifferenceCaption; DifferenceCaptionLbl) { } trigger OnAfterGetRecord() begin if Number = 1 then begin if not TempFAPostGroupBuffer2.Find('-') then CurrReport.Break(); end else if TempFAPostGroupBuffer2.Next() = 0 then CurrReport.Break(); Clear(GLAcc); if GLAcc.Get(TempFAPostGroupBuffer2."Account No.") then begin GLAcc.SetRange("Date Filter", StartingDate, EndingDate); GLAcc.CalcFields("Net Change"); end; end; } } requestpage { AboutTitle = 'About FA Posting Group - Net Change'; AboutText = 'Review the net change posted in the fixed asset ledger entries for a fixed asset (FA) posting group. If general ledger integration is active for a depreciation book, the amounts in the report should be the same as the net change in the general ledger accounts assigned to the fixed asset posting groups. You can use the report when you reconcile the fixed asset ledger and general ledger.'; SaveValues = true; layout { area(content) { group(Options) { Caption = 'Options'; field(StartingDate; StartingDate) { ApplicationArea = FixedAssets; Caption = 'Starting Date'; ToolTip = 'Specifies the date from which you want the report to show the net change posted in the fixed asset ledger entries for the fixed asset posting group.'; } field(EndingDate; EndingDate) { ApplicationArea = FixedAssets; Caption = 'Ending Date'; ToolTip = 'Specifies the date to which you want the report to show the net change posted in the fixed asset ledger entries for the fixed asset posting group.'; } field(OnlyTotals; OnlyTotals) { ApplicationArea = FixedAssets; Caption = 'Only Totals per G/L Account'; ToolTip = 'Specifies if you want the report to only show the total change in each general ledger account for all fixed asset posting groups.'; } } } } actions { } } rendering { layout(RDLCLayout) { Type = RDLC; LayoutFile = './FixedAssets/Reports/FAPostingGroupNetChange.rdlc'; Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.'; } } labels { FANetChangeCaption = 'FA Net Change'; AccountNameCaption = 'Account Name'; } trigger OnPreReport() begin TempFAPostGroupBuffer[1].DeleteAll(); TempFAPostGroupBuffer2.DeleteAll(); FAGenReport.ValidateDates(StartingDate, EndingDate); FADeprBookFilter := "FA Depreciation Book".GetFilters(); FAGenReport.AppendPostingDateFilter(FADeprBookFilter, StartingDate, EndingDate); FirstTotalHeader := true; end; var GLAcc: Record "G/L Account"; FAPostingGr: Record "FA Posting Group"; TempFAPostGroupBuffer: array[2] of Record "FA Posting Group Buffer" temporary; TempFAPostGroupBuffer2: Record "FA Posting Group Buffer" temporary; MaintenanceLedgEntry: Record "Maintenance Ledger Entry"; FAGenReport: Codeunit "FA General Report"; DeprCalc: Codeunit "Depreciation Calculation"; Type: Option Acq,Depr,WD,Appr,C1,C2,DeprExp,Maint,Disp,GL,BV,DispAcq,DispDepr,DispWD,DispAppr,DispC1,DispC2,BalWD,BalAppr,BalC1,BalC2; FANo: Code[20]; DeprBookCode: Code[20]; StartingDate: Date; EndingDate: Date; FADeprBookFilter: Text; OnlyTotals: Boolean; FieldCaptionText: Text[80]; AccNo: Code[20]; OldAccNo: Code[20]; PostAmount: Decimal; I: Integer; Counter: Integer; FirstTotalHeader: Boolean; SoldWithGain: Boolean; NetDisposalMethod: Boolean; FAPostingGroupNetChangeCaptionLbl: Label 'FA Posting Group - Net Change'; CurrReportPageNoCaptionLbl: Label 'Page'; AccountNoCaptionLbl: Label 'Account No.'; FieldNameCaptionLbl: Label 'Field Name'; FAPostingGroupCaptionLbl: Label 'FA Posting Group'; TotalperGLAccountCaptionLbl: Label 'Total per G/L Account'; NetChangeCaptionLbl: Label 'Net Change'; AccNoCaptionLbl: Label 'Account No.'; DifferenceCaptionLbl: Label 'Difference'; local procedure InsertAmount(FAPostingGrCode: Code[20]; FieldCaptionText: Text[80]; AccNo: Code[20]; PostAmount: Decimal) begin if SkipInsertAmount(FAPostingGrCode, AccNo, PostAmount) then exit; Clear(TempFAPostGroupBuffer[1]); TempFAPostGroupBuffer[1]."FA Posting Group" := FAPostingGrCode; TempFAPostGroupBuffer[1]."Posting Type" := Type; TempFAPostGroupBuffer[1]."FA FieldCaption" := CopyStr(FieldCaptionText, 1, MaxStrLen(TempFAPostGroupBuffer[1]."FA FieldCaption")); TempFAPostGroupBuffer[1]."Account No." := AccNo; TempFAPostGroupBuffer[1].Amount := PostAmount; if GLAcc.Get(AccNo) then TempFAPostGroupBuffer[1]."Account Name" := GLAcc.Name; TempFAPostGroupBuffer[2] := TempFAPostGroupBuffer[1]; if TempFAPostGroupBuffer[2].Find() then begin TempFAPostGroupBuffer[2].Amount := TempFAPostGroupBuffer[2].Amount + TempFAPostGroupBuffer[1].Amount; TempFAPostGroupBuffer[2].Modify(); end else TempFAPostGroupBuffer[1].Insert(); end; local procedure CalculateAccount(FAPostingGrCode: Code[20]; var FieldCaptionText: Text[50]; var AccNo: Code[20]; var PostAmount: Decimal) begin case Type of Type::Acq: begin FieldCaptionText := FAPostingGr.FieldCaption("Acquisition Cost Account"); AccNo := FAPostingGr."Acquisition Cost Account"; PostAmount := GetAmount(0); end; Type::Depr: begin FieldCaptionText := FAPostingGr.FieldCaption("Accum. Depreciation Account"); AccNo := FAPostingGr."Accum. Depreciation Account"; PostAmount := GetAmount(0); end; Type::WD: begin FieldCaptionText := FAPostingGr.FieldCaption("Write-Down Account"); AccNo := FAPostingGr."Write-Down Account"; PostAmount := GetAmount(0); end; Type::Appr: begin FieldCaptionText := FAPostingGr.FieldCaption("Appreciation Account"); AccNo := FAPostingGr."Appreciation Account"; PostAmount := GetAmount(0); end; Type::C1: begin FieldCaptionText := FAPostingGr.FieldCaption("Custom 1 Account"); AccNo := FAPostingGr."Custom 1 Account"; PostAmount := GetAmount(0); end; Type::C2: begin FieldCaptionText := FAPostingGr.FieldCaption("Custom 2 Account"); AccNo := FAPostingGr."Custom 2 Account"; PostAmount := GetAmount(0); end; Type::DeprExp: begin FieldCaptionText := FAPostingGr.FieldCaption("Depreciation Expense Acc."); AccNo := FAPostingGr."Depreciation Expense Acc."; PostAmount := -GetAmount(0); end; Type::Maint: begin FieldCaptionText := FAPostingGr.FieldCaption("Maintenance Expense Account"); AccNo := FAPostingGr."Maintenance Expense Account"; PostAmount := CalculateMaintenance(); end; Type::Disp: begin if NetDisposalMethod then PostAmount := 0 else PostAmount := GetAmount(0); if SoldWithGain then begin FieldCaptionText := FAPostingGr.FieldCaption("Sales Acc. on Disp. (Gain)"); AccNo := FAPostingGr."Sales Acc. on Disp. (Gain)"; InsertAmount( FAPostingGrCode, FAPostingGr.FieldCaption("Sales Acc. on Disp. (Loss)"), FAPostingGr."Sales Acc. on Disp. (Loss)", 0); end else begin FieldCaptionText := FAPostingGr.FieldCaption("Sales Acc. on Disp. (Loss)"); AccNo := FAPostingGr."Sales Acc. on Disp. (Loss)"; InsertAmount( FAPostingGrCode, FAPostingGr.FieldCaption("Sales Acc. on Disp. (Gain)"), FAPostingGr."Sales Acc. on Disp. (Gain)", 0); end; end; Type::GL: begin if NetDisposalMethod then PostAmount := GetAmount(0) else PostAmount := 0; if SoldWithGain then begin FieldCaptionText := FAPostingGr.FieldCaption("Gains Acc. on Disposal"); AccNo := FAPostingGr."Gains Acc. on Disposal"; InsertAmount( FAPostingGrCode, FAPostingGr.FieldCaption("Losses Acc. on Disposal"), FAPostingGr."Losses Acc. on Disposal", 0); end else begin FieldCaptionText := FAPostingGr.FieldCaption("Losses Acc. on Disposal"); AccNo := FAPostingGr."Losses Acc. on Disposal"; InsertAmount( FAPostingGrCode, FAPostingGr.FieldCaption("Gains Acc. on Disposal"), FAPostingGr."Gains Acc. on Disposal", 0); end; end; Type::BV: begin if SoldWithGain then begin FieldCaptionText := FAPostingGr.FieldCaption("Book Val. Acc. on Disp. (Gain)"); AccNo := FAPostingGr."Book Val. Acc. on Disp. (Gain)"; InsertAmount( FAPostingGrCode, FAPostingGr.FieldCaption("Book Val. Acc. on Disp. (Loss)"), FAPostingGr."Book Val. Acc. on Disp. (Loss)", 0); end else begin FieldCaptionText := FAPostingGr.FieldCaption("Book Val. Acc. on Disp. (Loss)"); AccNo := FAPostingGr."Book Val. Acc. on Disp. (Loss)"; InsertAmount( FAPostingGrCode, FAPostingGr.FieldCaption("Book Val. Acc. on Disp. (Gain)"), FAPostingGr."Book Val. Acc. on Disp. (Gain)", 0); end; PostAmount := GetAmount(1); end; Type::DispAcq: begin FieldCaptionText := FAPostingGr.FieldCaption("Acq. Cost Acc. on Disposal"); AccNo := FAPostingGr."Acq. Cost Acc. on Disposal"; PostAmount := GetAmount(1); end; Type::DispDepr: begin FieldCaptionText := FAPostingGr.FieldCaption("Accum. Depr. Acc. on Disposal"); AccNo := FAPostingGr."Accum. Depr. Acc. on Disposal"; PostAmount := GetAmount(1); end; Type::DispWD: begin FieldCaptionText := FAPostingGr.FieldCaption("Write-Down Acc. on Disposal"); AccNo := FAPostingGr."Write-Down Acc. on Disposal"; PostAmount := GetAmount(1); end; Type::DispAppr: begin FieldCaptionText := FAPostingGr.FieldCaption("Appreciation Acc. on Disposal"); AccNo := FAPostingGr."Appreciation Acc. on Disposal"; PostAmount := GetAmount(1); end; Type::DispC1: begin FieldCaptionText := FAPostingGr.FieldCaption("Custom 1 Account on Disposal"); AccNo := FAPostingGr."Custom 1 Account on Disposal"; PostAmount := GetAmount(1); end; Type::DispC2: begin FieldCaptionText := FAPostingGr.FieldCaption("Custom 2 Account on Disposal"); AccNo := FAPostingGr."Custom 2 Account on Disposal"; PostAmount := GetAmount(1); end; Type::BalWD: begin FieldCaptionText := FAPostingGr.FieldCaption("Write-Down Bal. Acc. on Disp."); AccNo := FAPostingGr."Write-Down Bal. Acc. on Disp."; PostAmount := GetAmount(2); end; Type::BalAppr: begin FieldCaptionText := FAPostingGr.FieldCaption("Apprec. Bal. Acc. on Disp."); AccNo := FAPostingGr."Apprec. Bal. Acc. on Disp."; PostAmount := GetAmount(2); end; Type::BalC1: begin FieldCaptionText := FAPostingGr.FieldCaption("Custom 1 Bal. Acc. on Disposal"); AccNo := FAPostingGr."Custom 1 Bal. Acc. on Disposal"; PostAmount := GetAmount(2); end; Type::BalC2: begin FieldCaptionText := FAPostingGr.FieldCaption("Custom 2 Bal. Acc. on Disposal"); AccNo := FAPostingGr."Custom 2 Bal. Acc. on Disposal"; PostAmount := GetAmount(2); end; end; end; local procedure GetAmount(Period: Option " ",Disposal,"Bal. Disposal"): Decimal begin exit( FAGenReport.CalcGLPostedAmount( FANo, GetFieldNo(), Period, StartingDate, EndingDate, DeprBookCode)); end; local procedure GetFieldNo(): Integer var FADeprBook: Record "FA Depreciation Book"; begin case Type of Type::Acq, Type::DispAcq: exit(FADeprBook.FieldNo("Acquisition Cost")); Type::Depr, Type::DeprExp, Type::DispDepr: exit(FADeprBook.FieldNo(Depreciation)); Type::WD, Type::DispWD, Type::BalWD: exit(FADeprBook.FieldNo("Write-Down")); Type::Appr, Type::DispAppr, Type::BalAppr: exit(FADeprBook.FieldNo(Appreciation)); Type::C1, Type::DispC1, Type::BalC1: exit(FADeprBook.FieldNo("Custom 1")); Type::C2, Type::DispC2, Type::BalC2: exit(FADeprBook.FieldNo("Custom 2")); Type::Disp: exit(FADeprBook.FieldNo("Proceeds on Disposal")); Type::GL: exit(FADeprBook.FieldNo("Gain/Loss")); Type::BV: exit(FADeprBook.FieldNo("Book Value on Disposal")); end; end; local procedure CalculateMaintenance(): Decimal begin MaintenanceLedgEntry.SetCurrentKey("FA No.", "Depreciation Book Code", "Posting Date"); MaintenanceLedgEntry.SetRange("FA No.", FANo); MaintenanceLedgEntry.SetRange("Depreciation Book Code", DeprBookCode); MaintenanceLedgEntry.SetRange("Posting Date", StartingDate, EndingDate); MaintenanceLedgEntry.CalcSums(Amount); exit(MaintenanceLedgEntry.Amount); end; procedure CalcNetDisposalMethod(): Boolean var FALedgEntry: Record "FA Ledger Entry"; begin DeprCalc.SetFAFilter(FALedgEntry, FANo, DeprBookCode, true); FALedgEntry.SetRange( "FA Posting Type", FALedgEntry."FA Posting Type"::"Proceeds on Disposal"); if not FALedgEntry.FindFirst() then exit(true); exit(FALedgEntry."Disposal Calculation Method" <> FALedgEntry."Disposal Calculation Method"::Gross); end; procedure SkipInsertAmount(FAPostingGrCode: Code[20]; AccNo: Code[20]; PostAmount: Decimal): Boolean begin if (FAPostingGrCode = '') or (AccNo = '') then exit(true); if ((Type = Type::BV) or (Type = Type::Disp)) and (not NetDisposalMethod) then exit(false); if (Type = Type::GL) and NetDisposalMethod then exit(false); exit(PostAmount = 0); end;}