Page 9107 Resource Statistics FactBox

Base Application, Microsoft.Projects.Resources.Resource

src/Layers/W1/BaseApp/Projects/Resources/Resource/ResourceStatisticsFactBox.Page.al176 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.Projects.Resources.Resource;using Microsoft.Foundation.Period;page 9107 "Resource Statistics FactBox"{    Caption = 'Resource Statistics';    PageType = CardPart;    SourceTable = Resource;    layout    {        area(content)        {            field("No."; Rec."No.")            {                ApplicationArea = Jobs;                Caption = 'Resource No.';                ToolTip = 'Specifies a number for the resource.';                trigger OnDrillDown()                begin                    ShowDetails();                end;            }            field(ResCapacity; ResCapacity)            {                ApplicationArea = Jobs;                AutoFormatType = 0;                Caption = 'Capacity';                DecimalPlaces = 0 : 5;                ToolTip = 'Specifies the scheduled capacity of the resource. The amount is the sum of values in the Quantity field on project planning lines for the resource.';            }            field(UnusedCapacity; UnusedCapacity)            {                ApplicationArea = Jobs;                AutoFormatType = 0;                Caption = 'Unused Capacity';                DecimalPlaces = 0 : 5;                ToolTip = 'Specifies the difference between the capacity and the capacity used. It is calculated as follows: Unused Capacity = Capacity - Charg. Usage + Not Charg. Usage.';            }            field(UnitPrice; UnitPrice)            {                ApplicationArea = Jobs;                AutoFormatType = 1;                AutoFormatExpression = '';                Caption = 'Invoiced';                ToolTip = 'Specifies the unit prices of postings of the type sale. Sales can be posted in the resource group journal and the sales lines.';            }            field(InvoicedPct; InvoicedPct)            {                ApplicationArea = Jobs;                AutoFormatType = 0;                Caption = 'Invoiced %';                DecimalPlaces = 1 : 1;                ToolTip = 'Specifies the percentage of invoiced amounts in unit prices. It is calculated as follows: Invoiced % = (Invoiced (LCY) / Usage(Unit Price)) x 100.';            }            field(ResUsageCost; ResUsageCost)            {                ApplicationArea = Jobs;                AutoFormatType = 1;                AutoFormatExpression = '';                Caption = 'Usage (Cost)';                ToolTip = 'Specifies values for project usage based on cost. Specifies, based on cost, how much the resources has been used.';            }            field(Profit; Profit)            {                ApplicationArea = Jobs;                AutoFormatType = 1;                AutoFormatExpression = '';                Caption = 'Profit';                ToolTip = 'Specifies the profit amounts.';            }            field(ResProfitPct; ResProfitPct)            {                ApplicationArea = Jobs;                AutoFormatType = 0;                Caption = 'Profit %';                DecimalPlaces = 1 : 1;                ToolTip = 'Specifies the profit percentages.';            }        }    }    actions    {    }    trigger OnAfterGetRecord()    begin        if CurrentDate <> WorkDate() then begin            CurrentDate := WorkDate();            DateFilterCalc.CreateFiscalYearFilter(ResDateFilter, ResDateName, CurrentDate, 0);        end;        Clear(TotalUsageUnits);        Rec.SetFilter("Date Filter", ResDateFilter);        Rec.SetRange("Chargeable Filter");        Rec.CalcFields(Capacity, "Usage (Cost)", "Sales (Price)");        ResCapacity := Rec.Capacity;        ResUsageCost := Rec."Usage (Cost)";        UnitPrice := Rec."Sales (Price)";        for j := 1 to 2 do begin            if j = 1 then                Chargeable := false            else                Chargeable := true;            Rec.SetRange("Chargeable Filter", Chargeable);            Rec.CalcFields("Usage (Qty.)", "Usage (Price)");            ResUsagePrice := Rec."Usage (Price)";            TotalUsageUnits := TotalUsageUnits + Rec."Usage (Qty.)";        end;        UnusedCapacity := ResCapacity - TotalUsageUnits;        InvoicedPct := CalcPercentage(UnitPrice, ResUsagePrice);        Profit := UnitPrice - ResUsageCost;        ResProfitPct := CalcPercentage(Profit, UnitPrice);        Rec.SetRange("Date Filter");        Rec.SetRange("Chargeable Filter");    end;    trigger OnFindRecord(Which: Text): Boolean    begin        ResCapacity := 0;        UnusedCapacity := 0;        UnitPrice := 0;        InvoicedPct := 0;        ResUsageCost := 0;        Profit := 0;        ResProfitPct := 0;        exit(Rec.Find(Which));    end;    var        DateFilterCalc: Codeunit "DateFilter-Calc";        CurrentDate: Date;        UnitPrice: Decimal;        InvoicedPct: Decimal;        ResUsageCost: Decimal;        Profit: Decimal;        ResProfitPct: Decimal;        ResDateFilter: Text[30];        ResDateName: Text[30];        Chargeable: Boolean;        TotalUsageUnits: Decimal;        ResUsagePrice: Decimal;        j: Integer;    protected var        ResCapacity: Decimal;        UnusedCapacity: Decimal;    local procedure ShowDetails()    begin        PAGE.Run(PAGE::"Resource Card", Rec);    end;    local procedure CalcPercentage(PartAmount: Decimal; Base: Decimal): Decimal    begin        if Base <> 0 then            exit(100 * PartAmount / Base);        exit(0);    end;}