Page 6059 Contract Statistics

Base Application, Microsoft.Service.Contract

src/Layers/W1/BaseApp/Service/Contract/ContractStatistics.Page.al477 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.Service.Contract;using Microsoft.Service.Ledger;page 6059 "Contract Statistics"{    Caption = 'Contract Statistics';    Editable = false;    LinksAllowed = false;    PageType = Card;    SourceTable = "Service Contract Header";    layout    {        area(content)        {            group(General)            {                Caption = 'General';                fixed(Control1903895201)                {                    ShowCaption = false;                    group(Resources)                    {                        Caption = 'Resources';                        field("Income[1]"; Income[1])                        {                            ApplicationArea = Service;                            AutoFormatType = 1;                            AutoFormatExpression = '';                            Caption = 'Invoiced Amount';                            ToolTip = 'Specifies the net amount of all invoiced service item lines in the service contract.';                        }                        field("TotalDiscount[1]"; TotalDiscount[1])                        {                            ApplicationArea = Service;                            AutoFormatType = 1;                            AutoFormatExpression = '';                            Caption = 'Discount Amount';                            ToolTip = 'Specifies the amount of discount being applied for the contract.';                        }                        field("TotalCost[1]"; TotalCost[1])                        {                            ApplicationArea = Service;                            AutoFormatType = 1;                            AutoFormatExpression = '';                            Caption = 'Cost Amount';                            ToolTip = 'Specifies the total amount of costs for all service item lines in the service contract.';                        }                        field("ProfitAmount[1]"; ProfitAmount[1])                        {                            ApplicationArea = Service;                            AutoFormatType = 1;                            AutoFormatExpression = '';                            Caption = 'Profit Amount';                            ToolTip = 'Specifies the amount of profit, after the cost amount has been subtracted from the total amount.';                        }                        field("ProfitAmountPercent[1]"; ProfitAmountPercent[1])                        {                            ApplicationArea = Service;                            AutoFormatType = 0;                            Caption = 'Profit %';                            DecimalPlaces = 1 : 1;                            ToolTip = 'Specifies the amount of profit as a percentage of the invoiced amount.';                        }                        field(Placeholder; '')                        {                            ApplicationArea = Prepayments;                            Caption = 'Prepaid Amount';                            ToolTip = 'Specifies the sum of all amounts that have been prepaid.';                        }                        field("Total Amount"; '')                        {                            ApplicationArea = Service;                            Caption = 'Total Amount';                            ToolTip = 'Specifies the sum of the invoiced amount and the prepaid amount.';                        }                        field("Profit Amount"; '')                        {                            ApplicationArea = Service;                            Caption = 'Profit Amount';                            ToolTip = 'Specifies the amount of profit, after the cost amount has been subtracted from the total amount.';                        }                        field("Profit %"; '')                        {                            ApplicationArea = Service;                            Caption = 'Profit %';                            ToolTip = 'Specifies the amount of profit as a percentage of the total amount.';                        }                    }                    group(Items)                    {                        Caption = 'Items';                        field("Income[2]"; Income[2])                        {                            ApplicationArea = Service;                            AutoFormatType = 1;                            AutoFormatExpression = '';                            Caption = 'Invoiced Amount';                            ToolTip = 'Specifies the net amount of all invoiced service item lines in the service contract.';                        }                        field("TotalDiscount[2]"; TotalDiscount[2])                        {                            ApplicationArea = Service;                            AutoFormatType = 1;                            AutoFormatExpression = '';                            Caption = 'Discount Amount';                            ToolTip = 'Specifies the amount of discount being applied for the contract.';                        }                        field("TotalCost[2]"; TotalCost[2])                        {                            ApplicationArea = Service;                            AutoFormatType = 1;                            AutoFormatExpression = '';                            Caption = 'Cost Amount';                            ToolTip = 'Specifies the total amount of costs for all service item lines in the service contract.';                        }                        field("ProfitAmount[2]"; ProfitAmount[2])                        {                            ApplicationArea = Service;                            AutoFormatType = 1;                            AutoFormatExpression = '';                            Caption = 'Profit Amount';                            ToolTip = 'Specifies the amount of profit, after the cost amount has been subtracted from the total amount.';                        }                        field("ProfitAmountPercent[2]"; ProfitAmountPercent[2])                        {                            ApplicationArea = Service;                            AutoFormatType = 0;                            Caption = 'Profit %';                            DecimalPlaces = 1 : 1;                            ToolTip = 'Specifies the amount of profit as a percentage of the invoiced amount.';                        }                        field(Placeholder2; Text000)                        {                            ApplicationArea = Service;                            Visible = false;                        }                        field(Placeholder3; Text000)                        {                            ApplicationArea = Service;                            Visible = false;                        }                        field(Placeholder4; Text000)                        {                            ApplicationArea = Service;                            Visible = false;                        }                        field(Placeholder5; Text000)                        {                            ApplicationArea = Service;                            Visible = false;                        }                    }                    group("Costs && G/L Accounts")                    {                        Caption = 'Costs && G/L Accounts';                        field("Income[3]"; Income[3])                        {                            ApplicationArea = Service;                            AutoFormatType = 1;                            AutoFormatExpression = '';                            Caption = 'Invoiced Amount';                            ToolTip = 'Specifies the net amount of all invoiced service item lines in the service contract.';                        }                        field("TotalDiscount[3]"; TotalDiscount[3])                        {                            ApplicationArea = Service;                            AutoFormatType = 1;                            AutoFormatExpression = '';                            Caption = 'Discount Amount';                            ToolTip = 'Specifies the amount of discount being applied for the contract.';                        }                        field("TotalCost[3]"; TotalCost[3])                        {                            ApplicationArea = Service;                            AutoFormatType = 1;                            AutoFormatExpression = '';                            Caption = 'Cost Amount';                            ToolTip = 'Specifies the total amount of costs for all service item lines in the service contract.';                        }                        field("ProfitAmount[3]"; ProfitAmount[3])                        {                            ApplicationArea = Service;                            AutoFormatType = 1;                            AutoFormatExpression = '';                            Caption = 'Profit Amount';                            ToolTip = 'Specifies the amount of profit, after the cost amount has been subtracted from the total amount.';                        }                        field("ProfitAmountPercent[3]"; ProfitAmountPercent[3])                        {                            ApplicationArea = Service;                            AutoFormatType = 0;                            Caption = 'Profit %';                            DecimalPlaces = 1 : 1;                            ToolTip = 'Specifies the amount of profit as a percentage of the invoiced amount.';                        }                        field(Placeholder6; Text000)                        {                            ApplicationArea = Service;                            Visible = false;                        }                        field(Placeholder7; Text000)                        {                            ApplicationArea = Service;                            Visible = false;                        }                        field(Placeholder8; Text000)                        {                            ApplicationArea = Service;                            Visible = false;                        }                        field(Placehoder9; Text000)                        {                            ApplicationArea = Service;                            Visible = false;                        }                    }                    group("Service Contracts")                    {                        Caption = 'Service Contracts';                        field("Income[4]"; Income[4])                        {                            ApplicationArea = Service;                            AutoFormatType = 1;                            Caption = 'Invoiced Amount';                            AutoFormatExpression = '';                            ToolTip = 'Specifies the net amount of all invoiced service item lines in the service contract.';                        }                        field("TotalDiscount[4]"; TotalDiscount[4])                        {                            ApplicationArea = Service;                            AutoFormatType = 1;                            AutoFormatExpression = '';                            Caption = 'Discount Amount';                            ToolTip = 'Specifies the amount of discount being applied for the contract.';                        }                        field("TotalCost[4]"; TotalCost[4])                        {                            ApplicationArea = Service;                            AutoFormatType = 1;                            AutoFormatExpression = '';                            Caption = 'Cost Amount';                            ToolTip = 'Specifies the total amount of costs for all service item lines in the service contract.';                        }                        field("ProfitAmount[4]"; ProfitAmount[4])                        {                            ApplicationArea = Service;                            AutoFormatType = 1;                            AutoFormatExpression = '';                            Caption = 'Profit Amount';                            ToolTip = 'Specifies the amount of profit, after the cost amount has been subtracted from the total amount.';                        }                        field("ProfitAmountPercent[4]"; ProfitAmountPercent[4])                        {                            ApplicationArea = Service;                            AutoFormatType = 0;                            Caption = 'Profit %';                            DecimalPlaces = 1 : 1;                            ToolTip = 'Specifies the amount of profit as percentage of the invoiced amount.';                        }                        field(PrepaidIncome; PrepaidIncome)                        {                            ApplicationArea = Prepayments;                            AutoFormatType = 1;                            AutoFormatExpression = '';                            Caption = 'Prepaid Amount';                            ToolTip = 'Specifies the sum of all amounts that have been prepaid.';                        }                        field(Placeholder10; Text000)                        {                            ApplicationArea = Service;                            Visible = false;                        }                        field(Placeholder11; Text000)                        {                            ApplicationArea = Service;                            Visible = false;                        }                        field(Placeholderr12; Text000)                        {                            ApplicationArea = Service;                            Visible = false;                        }                    }                    group(Total)                    {                        Caption = 'Total';                        field("Income[5]"; Income[5])                        {                            ApplicationArea = Service;                            AutoFormatType = 1;                            AutoFormatExpression = '';                            Caption = 'Total Invoiced Amount';                            ToolTip = 'Specifies the total amount of all invoiced service item lines in the service contract.';                        }                        field("TotalDiscount[5]"; TotalDiscount[5])                        {                            ApplicationArea = Service;                            AutoFormatType = 1;                            AutoFormatExpression = '';                            Caption = 'Total Discount Amount';                            ToolTip = 'Specifies the total amount of discounts for all service item lines in the service contract.';                        }                        field("TotalCost[5]"; TotalCost[5])                        {                            ApplicationArea = Service;                            AutoFormatType = 1;                            AutoFormatExpression = '';                            Caption = 'Total Cost Amount';                            ToolTip = 'Specifies the total amount of costs for all service item lines in the service contract.';                        }                        field("ProfitAmount[5]"; ProfitAmount[5])                        {                            ApplicationArea = Service;                            AutoFormatType = 1;                            AutoFormatExpression = '';                            Caption = 'Total Profit Amount';                            ToolTip = 'Specifies the total amount of profit for all service item lines in the service contract.';                        }                        field("ProfitAmountPercent[5]"; ProfitAmountPercent[5])                        {                            ApplicationArea = Service;                            AutoFormatType = 0;                            Caption = 'Profit %';                            DecimalPlaces = 1 : 1;                            ToolTip = 'Specifies the amount of profit as a percentage of the invoiced amount.';                        }                        field(PrepaidIncome2; PrepaidIncome)                        {                            ApplicationArea = Prepayments;                            AutoFormatType = 1;                            AutoFormatExpression = '';                            Caption = 'Total Prepaid Amount';                            ToolTip = 'Specifies the sum of all amounts that have been prepaid.';                        }                        field(TotalIncome; TotalIncome)                        {                            ApplicationArea = Service;                            AutoFormatType = 1;                            AutoFormatExpression = '';                            Caption = 'Total Amount';                            ToolTip = 'Specifies the sum of the invoiced amount and the prepaid amount.';                        }                        field(TotalProfit; TotalProfit)                        {                            ApplicationArea = Service;                            AutoFormatType = 1;                            AutoFormatExpression = '';                            Caption = 'Profit Amount';                            ToolTip = 'Specifies the amount of profit, after the cost amount has been subtracted from the total amount.';                        }                        field(TotalProfitPct; TotalProfitPct)                        {                            ApplicationArea = Service;                            AutoFormatType = 1;                            AutoFormatExpression = '';                            Caption = 'Profit %';                            DecimalPlaces = 1 : 1;                            ToolTip = 'Specifies the amount of profit as percentage of the invoiced amount.';                        }                    }                }            }        }    }    actions    {    }    trigger OnAfterGetRecord()    var        ServLedgerEntry: Record "Service Ledger Entry";    begin        ClearAll();        ServLedgerEntry.Reset();        ServLedgerEntry.SetRange("Service Contract No.", Rec."Contract No.");        ServLedgerEntry.SetRange("Entry Type", ServLedgerEntry."Entry Type"::Sale);        Rec.SetRange("Type Filter", Rec."Type Filter"::"Service Contract");        Rec.CalcFields(          "Contract Invoice Amount", "Contract Prepaid Amount", "Contract Cost Amount",          "Contract Discount Amount");        Income[4] := Rec."Contract Invoice Amount";        TotalDiscount[4] := Rec."Contract Discount Amount";        TotalCost[4] := Rec."Contract Cost Amount";        ProfitAmount[4] := Income[4] - TotalCost[4];        ProfitAmountPercent[4] := CalcPercentage(ProfitAmount[4], Income[4]);        Income[5] := Income[5] + Income[4];        PrepaidIncome := Rec."Contract Prepaid Amount";        TotalCost[5] := TotalCost[5] + TotalCost[4];        TotalDiscount[5] := TotalDiscount[5] + TotalDiscount[4];        for i := 1 to 3 do begin            if i = 3 then                Rec.SetFilter("Type Filter", '%1|%2', Rec."Type Filter"::"Service Cost", Rec."Type Filter"::"G/L Account")            else                Rec.SetRange("Type Filter", i);            ServLedgerEntry.SetRange(Type, i);            if ServLedgerEntry.FindSet() then                repeat                    OnAfterGetRecordOnBeforeCalcTotalDiscount(ServLedgerEntry);                    TotalDiscount[i] := TotalDiscount[i] - ServLedgerEntry."Discount Amount";                until ServLedgerEntry.Next() = 0;            Rec.CalcFields("Contract Invoice Amount", "Contract Discount Amount", "Contract Cost Amount");            Income[i] := Rec."Contract Invoice Amount";            Income[5] := Income[5] + Rec."Contract Invoice Amount";            TotalCost[i] := Rec."Contract Cost Amount";            TotalCost[5] := TotalCost[5] + TotalCost[i];            TotalDiscount[5] := TotalDiscount[5] + TotalDiscount[i];            ProfitAmount[i] := Income[i] - TotalCost[i];            ProfitAmount[i] := MakeNegativeZero(ProfitAmount[i]);            ProfitAmountPercent[i] := CalcPercentage(ProfitAmount[i], Income[i]);        end;        TotalIncome := Income[5] + PrepaidIncome;        ProfitAmount[5] := Income[5] - TotalCost[5];        ProfitAmountPercent[5] := CalcPercentage(ProfitAmount[5], Income[5]);        ProfitAmountPercent[5] := MakeNegativeZero(ProfitAmountPercent[5]);        ProfitAmount[5] := MakeNegativeZero(ProfitAmount[5]);        TotalProfit := TotalIncome - TotalCost[5];        TotalProfit := MakeNegativeZero(TotalProfit);        TotalProfitPct := CalcPercentage(TotalProfit, TotalIncome);        Rec.SetRange("Type Filter");    end;    var        i: Integer;        PrepaidIncome: Decimal;        TotalIncome: Decimal;        Income: array[5] of Decimal;        TotalCost: array[5] of Decimal;        TotalDiscount: array[5] of Decimal;        ProfitAmount: array[5] of Decimal;        ProfitAmountPercent: array[5] of Decimal;        TotalProfit: Decimal;        TotalProfitPct: Decimal;#pragma warning disable AA0074        Text000: Label 'Placeholder';#pragma warning restore AA0074    local procedure CalcPercentage(PartAmount: Decimal; Base: Decimal): Decimal    begin        if Base <> 0 then            exit(100 * PartAmount / Base);        exit(0);    end;    local procedure MakeNegativeZero(Amount: Decimal): Decimal    begin        if Amount < 0 then            exit(0);        exit(Amount);    end;    [IntegrationEvent(false, false)]    local procedure OnAfterGetRecordOnBeforeCalcTotalDiscount(var ServLedgerEntry: Record "Service Ledger Entry")    begin    end;}