Codeunit 1008 Job Calculate Statistics

Base Application, Microsoft.Projects.Project.Job

src/Layers/W1/BaseApp/Projects/Project/Job/JobCalculateStatistics.Codeunit.al371 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.Project.Job;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Projects.Project.Journal;using Microsoft.Projects.Project.Ledger;using Microsoft.Projects.Project.Planning;codeunit 1008 "Job Calculate Statistics"{    trigger OnRun()    begin    end;    var        JobLedgEntry: Record "Job Ledger Entry";        JobLedgEntry2: Record "Job Ledger Entry";        JobPlanningLine: Record "Job Planning Line";        JobPlanningLine2: Record "Job Planning Line";        AmountType: Option TotalCostLCY,LineAmountLCY,TotalCost,LineAmount;        PlanLineType: Option Schedule,Contract;        JobLedgAmounts: array[10, 4, 4] of Decimal;        JobPlanAmounts: array[10, 4, 4] of Decimal;        HeadlineTxt: Label 'Budget Price,Usage Price,Billable Price,Invoiced Price,Budget Cost,Usage Cost,Billable Cost,Invoiced Cost,Budget Profit,Usage Profit,Billable Profit,Invoiced Profit';    procedure ReportAnalysis(var Job2: Record Job; var JT: Record "Job Task"; var Amt: array[8] of Decimal; AmountField: array[8] of Option " ",SchPrice,UsagePrice,ContractPrice,InvoicedPrice,SchCost,UsageCost,ContractCost,InvoicedCost,SchProfit,UsageProfit,ContractProfit,InvoicedProfit; CurrencyField: array[8] of Option LCY,FCY; JobLevel: Boolean)    var        PL: array[16] of Decimal;        CL: array[16] of Decimal;        P: array[16] of Decimal;        C: array[16] of Decimal;        I: Integer;    begin        if JobLevel then            JobCalculateCommonFilters(Job2)        else            JTCalculateCommonFilters(JT, Job2, true);        CalculateAmounts();        GetLCYCostAmounts(CL);        GetCostAmounts(C);        GetLCYPriceAmounts(PL);        GetPriceAmounts(P);        OnReportAnalysisOnAfterGetAmounts(PL, CL, P, C, I);        Clear(Amt);        for I := 1 to 8 do begin            if AmountField[I] = AmountField[I] ::SchPrice then                if CurrencyField[I] = CurrencyField[I] ::LCY then                    Amt[I] := PL[4]                else                    Amt[I] := P[4];            if AmountField[I] = AmountField[I] ::UsagePrice then                if CurrencyField[I] = CurrencyField[I] ::LCY then                    Amt[I] := PL[8]                else                    Amt[I] := P[8];            if AmountField[I] = AmountField[I] ::ContractPrice then                if CurrencyField[I] = CurrencyField[I] ::LCY then                    Amt[I] := PL[12]                else                    Amt[I] := P[12];            if AmountField[I] = AmountField[I] ::InvoicedPrice then                if CurrencyField[I] = CurrencyField[I] ::LCY then                    Amt[I] := PL[16]                else                    Amt[I] := P[16];            if AmountField[I] = AmountField[I] ::SchCost then                if CurrencyField[I] = CurrencyField[I] ::LCY then                    Amt[I] := CL[4]                else                    Amt[I] := C[4];            if AmountField[I] = AmountField[I] ::UsageCost then                if CurrencyField[I] = CurrencyField[I] ::LCY then                    Amt[I] := CL[8]                else                    Amt[I] := C[8];            if AmountField[I] = AmountField[I] ::ContractCost then                if CurrencyField[I] = CurrencyField[I] ::LCY then                    Amt[I] := CL[12]                else                    Amt[I] := C[12];            if AmountField[I] = AmountField[I] ::InvoicedCost then                if CurrencyField[I] = CurrencyField[I] ::LCY then                    Amt[I] := CL[16]                else                    Amt[I] := C[16];            if AmountField[I] = AmountField[I] ::SchProfit then                if CurrencyField[I] = CurrencyField[I] ::LCY then                    Amt[I] := PL[4] - CL[4]                else                    Amt[I] := P[4] - C[4];            if AmountField[I] = AmountField[I] ::UsageProfit then                if CurrencyField[I] = CurrencyField[I] ::LCY then                    Amt[I] := PL[8] - CL[8]                else                    Amt[I] := P[8] - C[8];            if AmountField[I] = AmountField[I] ::ContractProfit then                if CurrencyField[I] = CurrencyField[I] ::LCY then                    Amt[I] := PL[12] - CL[12]                else                    Amt[I] := P[12] - C[12];            if AmountField[I] = AmountField[I] ::InvoicedProfit then                if CurrencyField[I] = CurrencyField[I] ::LCY then                    Amt[I] := PL[16] - CL[16]                else                    Amt[I] := P[16] - C[16];        end;        OnAfterReportAnalysis(AmountField, CurrencyField, Amt);    end;    procedure ReportSuggBilling(var Job2: Record Job; var JT: Record "Job Task"; var Amt: array[8] of Decimal; CurrencyField: array[8] of Option LCY,FCY)    var        AmountField: array[8] of Option " ",SchPrice,UsagePrice,ContractPrice,InvoicedPrice,SchCost,UsageCost,ContractCost,InvoicedCost,SchProfit,UsageProfit,ContractProfit,InvoicedProfit;    begin        AmountField[1] := AmountField[1] ::ContractCost;        AmountField[2] := AmountField[2] ::ContractPrice;        AmountField[3] := AmountField[3] ::InvoicedCost;        AmountField[4] := AmountField[4] ::InvoicedPrice;        ReportAnalysis(Job2, JT, Amt, AmountField, CurrencyField, false);        Amt[5] := Amt[1] - Amt[3];        Amt[6] := Amt[2] - Amt[4];    end;    procedure RepJobCustomer(var Job2: Record Job; var Amt: array[8] of Decimal)    var        JT: Record "Job Task";        AmountField: array[8] of Option " ",SchPrice,UsagePrice,ContractPrice,InvoicedPrice,SchCost,UsageCost,ContractCost,InvoicedCost,SchProfit,UsageProfit,ContractProfit,InvoicedProfit;        CurrencyField: array[8] of Option LCY,FCY;    begin        Clear(Amt);        if Job2."No." = '' then            exit;        AmountField[1] := AmountField[1] ::SchPrice;        AmountField[2] := AmountField[2] ::UsagePrice;        AmountField[3] := AmountField[3] ::InvoicedPrice;        AmountField[4] := AmountField[4] ::ContractPrice;        ReportAnalysis(Job2, JT, Amt, AmountField, CurrencyField, true);        Amt[5] := 0;        Amt[6] := 0;        if Amt[1] <> 0 then            Amt[5] := Round(Amt[2] / Amt[1] * 100);        if Amt[4] <> 0 then            Amt[6] := Round(Amt[3] / Amt[4] * 100);    end;    procedure JobCalculateCommonFilters(var Job: Record Job)    begin        ClearAll();        JobPlanningLine.SetCurrentKey("Job No.", "Job Task No.");        JobLedgEntry.SetCurrentKey("Job No.", "Job Task No.", "Entry Type");        JobPlanningLine.FilterGroup(2);        JobLedgEntry.SetRange("Job No.", Job."No.");        JobPlanningLine.SetRange("Job No.", Job."No.");        JobPlanningLine.FilterGroup(0);        JobLedgEntry.SetFilter("Posting Date", Job.GetFilter("Posting Date Filter"));        JobPlanningLine.SetFilter("Planning Date", Job.GetFilter("Planning Date Filter"));        OnAfterJobCalculateCommonFilters(Job, JobLedgEntry, JobPlanningLine);    end;    procedure JTCalculateCommonFilters(var JT2: Record "Job Task"; var Job2: Record Job; UseJobFilter: Boolean)    var        JT: Record "Job Task";    begin        ClearAll();        JT := JT2;        JobPlanningLine.FilterGroup(2);        JobPlanningLine.SetCurrentKey("Job No.", "Job Task No.");        JobLedgEntry.SetCurrentKey("Job No.", "Job Task No.", "Entry Type");        JobLedgEntry.SetRange("Job No.", JT."Job No.");        JobPlanningLine.SetRange("Job No.", JT."Job No.");        JobPlanningLine.FilterGroup(0);        if JT."Job Task No." <> '' then            if JT.Totaling <> '' then begin                JobLedgEntry.SetFilter("Job Task No.", JT.Totaling);                JobPlanningLine.SetFilter("Job Task No.", JT.Totaling);            end else begin                JobLedgEntry.SetRange("Job Task No.", JT."Job Task No.");                JobPlanningLine.SetRange("Job Task No.", JT."Job Task No.");            end;        if not UseJobFilter then begin            JobLedgEntry.SetFilter("Posting Date", JT2.GetFilter("Posting Date Filter"));            JobPlanningLine.SetFilter("Planning Date", JT2.GetFilter("Planning Date Filter"));        end else begin            JobLedgEntry.SetFilter("Posting Date", Job2.GetFilter("Posting Date Filter"));            JobPlanningLine.SetFilter("Planning Date", Job2.GetFilter("Planning Date Filter"));        end;        OnAfterJTCalculateCommonFilters(JT, JT2, Job2, UseJobFilter, JobLedgEntry, JobPlanningLine);    end;    procedure CalculateAmounts()    begin        CalcJobLedgAmounts(JobLedgEntry."Entry Type"::Usage, JobLedgEntry.Type::Resource);        CalcJobLedgAmounts(JobLedgEntry."Entry Type"::Usage, JobLedgEntry.Type::Item);        CalcJobLedgAmounts(JobLedgEntry."Entry Type"::Usage, JobLedgEntry.Type::"G/L Account");        CalcJobLedgAmounts(JobLedgEntry."Entry Type"::Sale, JobLedgEntry.Type::Resource);        CalcJobLedgAmounts(JobLedgEntry."Entry Type"::Sale, JobLedgEntry.Type::Item);        CalcJobLedgAmounts(JobLedgEntry."Entry Type"::Sale, JobLedgEntry.Type::"G/L Account");        CalcJobPlanAmounts(PlanLineType::Contract, JobPlanningLine.Type::Resource);        CalcJobPlanAmounts(PlanLineType::Contract, JobPlanningLine.Type::Item);        CalcJobPlanAmounts(PlanLineType::Contract, JobPlanningLine.Type::"G/L Account");        CalcJobPlanAmounts(PlanLineType::Schedule, JobPlanningLine.Type::Resource);        CalcJobPlanAmounts(PlanLineType::Schedule, JobPlanningLine.Type::Item);        CalcJobPlanAmounts(PlanLineType::Schedule, JobPlanningLine.Type::"G/L Account");    end;    local procedure CalcJobLedgAmounts(EntryType: Enum "Job Journal Line Entry Type"; TypeParm: Enum "Job Planning Line Type")    begin        JobLedgEntry2.Copy(JobLedgEntry);        JobLedgEntry2.SetRange("Entry Type", EntryType);        JobLedgEntry2.SetRange(Type, TypeParm);        JobLedgEntry2.CalcSums("Total Cost (LCY)", "Line Amount (LCY)", "Total Cost", "Line Amount");        JobLedgAmounts[1 + EntryType.AsInteger(), 1 + TypeParm.AsInteger(), 1 + AmountType::TotalCostLCY] := JobLedgEntry2."Total Cost (LCY)";        JobLedgAmounts[1 + EntryType.AsInteger(), 1 + TypeParm.AsInteger(), 1 + AmountType::LineAmountLCY] := JobLedgEntry2."Line Amount (LCY)";        JobLedgAmounts[1 + EntryType.AsInteger(), 1 + TypeParm.AsInteger(), 1 + AmountType::TotalCost] := JobLedgEntry2."Total Cost";        JobLedgAmounts[1 + EntryType.AsInteger(), 1 + TypeParm.AsInteger(), 1 + AmountType::LineAmount] := JobLedgEntry2."Line Amount";    end;    local procedure CalcJobPlanAmounts(PlanLineTypeParm: Option; TypeParm: Enum "Job Planning Line Type")    begin        JobPlanningLine2.Copy(JobPlanningLine);        JobPlanningLine2.SetRange("Schedule Line");        JobPlanningLine2.SetRange("Contract Line");        if PlanLineTypeParm = PlanLineType::Schedule then            JobPlanningLine2.SetRange("Schedule Line", true)        else            JobPlanningLine2.SetRange("Contract Line", true);        JobPlanningLine2.SetRange(Type, TypeParm);        OnCalcJobPlanAmountsOnAfterJobPlanningLineSetFilters(JobPlanningLine2);        JobPlanningLine2.CalcSums("Total Cost (LCY)", "Line Amount (LCY)", "Total Cost", "Line Amount");        JobPlanAmounts[1 + PlanLineTypeParm, 1 + TypeParm.AsInteger(), 1 + AmountType::TotalCostLCY] := JobPlanningLine2."Total Cost (LCY)";        JobPlanAmounts[1 + PlanLineTypeParm, 1 + TypeParm.AsInteger(), 1 + AmountType::LineAmountLCY] := JobPlanningLine2."Line Amount (LCY)";        JobPlanAmounts[1 + PlanLineTypeParm, 1 + TypeParm.AsInteger(), 1 + AmountType::TotalCost] := JobPlanningLine2."Total Cost";        JobPlanAmounts[1 + PlanLineTypeParm, 1 + TypeParm.AsInteger(), 1 + AmountType::LineAmount] := JobPlanningLine2."Line Amount";    end;    procedure GetLCYCostAmounts(var Amt: array[16] of Decimal)    begin        GetArrayAmounts(Amt, AmountType::TotalCostLCY);    end;    procedure GetCostAmounts(var Amt: array[16] of Decimal)    begin        GetArrayAmounts(Amt, AmountType::TotalCost);    end;    procedure GetLCYPriceAmounts(var Amt: array[16] of Decimal)    begin        GetArrayAmounts(Amt, AmountType::LineAmountLCY);    end;    procedure GetPriceAmounts(var Amt: array[16] of Decimal)    begin        GetArrayAmounts(Amt, AmountType::LineAmount);    end;    local procedure GetArrayAmounts(var Amt: array[16] of Decimal; AmountTypeParm: Option)    begin        Amt[1] := JobPlanAmounts[1 + PlanLineType::Schedule, 1 + JobPlanningLine.Type::Resource.AsInteger(), 1 + AmountTypeParm];        Amt[2] := JobPlanAmounts[1 + PlanLineType::Schedule, 1 + JobPlanningLine.Type::Item.AsInteger(), 1 + AmountTypeParm];        Amt[3] := JobPlanAmounts[1 + PlanLineType::Schedule, 1 + JobPlanningLine.Type::"G/L Account".AsInteger(), 1 + AmountTypeParm];        Amt[4] := Amt[1] + Amt[2] + Amt[3];        Amt[5] := JobLedgAmounts[1 + JobLedgEntry."Entry Type"::Usage.AsInteger(), 1 + JobLedgEntry.Type::Resource.AsInteger(), 1 + AmountTypeParm];        Amt[6] := JobLedgAmounts[1 + JobLedgEntry."Entry Type"::Usage.AsInteger(), 1 + JobLedgEntry.Type::Item.AsInteger(), 1 + AmountTypeParm];        Amt[7] := JobLedgAmounts[1 + JobLedgEntry."Entry Type"::Usage.AsInteger(), 1 + JobLedgEntry.Type::"G/L Account".AsInteger(), 1 + AmountTypeParm];        Amt[8] := Amt[5] + Amt[6] + Amt[7];        Amt[9] := JobPlanAmounts[1 + PlanLineType::Contract, 1 + JobPlanningLine.Type::Resource.AsInteger(), 1 + AmountTypeParm];        Amt[10] := JobPlanAmounts[1 + PlanLineType::Contract, 1 + JobPlanningLine.Type::Item.AsInteger(), 1 + AmountTypeParm];        Amt[11] := JobPlanAmounts[1 + PlanLineType::Contract, 1 + JobPlanningLine.Type::"G/L Account".AsInteger(), 1 + AmountTypeParm];        Amt[12] := Amt[9] + Amt[10] + Amt[11];        Amt[13] := -JobLedgAmounts[1 + JobLedgEntry."Entry Type"::Sale.AsInteger(), 1 + JobLedgEntry.Type::Resource.AsInteger(), 1 + AmountTypeParm];        Amt[14] := -JobLedgAmounts[1 + JobLedgEntry."Entry Type"::Sale.AsInteger(), 1 + JobLedgEntry.Type::Item.AsInteger(), 1 + AmountTypeParm];        Amt[15] := -JobLedgAmounts[1 + JobLedgEntry."Entry Type"::Sale.AsInteger(), 1 + JobLedgEntry.Type::"G/L Account".AsInteger(), 1 + AmountTypeParm];        Amt[16] := Amt[13] + Amt[14] + Amt[15];    end;    procedure ShowPlanningLine(JobType: Option " ",Resource,Item,GL; Schedule: Boolean)    begin        JobPlanningLine.SetRange("Contract Line");        JobPlanningLine.SetRange("Schedule Line");        JobPlanningLine.SetRange(Type);        if JobType > 0 then            JobPlanningLine.SetRange(Type, JobType - 1);        if Schedule then            JobPlanningLine.SetRange("Schedule Line", true)        else            JobPlanningLine.SetRange("Contract Line", true);        OnShowPlanningLineOnAfterJobPlanningLineSetFilters(JobPlanningLine);        PAGE.Run(PAGE::"Job Planning Lines", JobPlanningLine);    end;    procedure ShowLedgEntry(JobType: Option " ",Resource,Item,GL; Usage: Boolean)    var        JobLedgerEntries: Page "Job Ledger Entries";    begin        JobLedgEntry.SetRange(Type);        if Usage then            JobLedgEntry.SetRange("Entry Type", JobLedgEntry."Entry Type"::Usage)        else            JobLedgEntry.SetRange("Entry Type", JobLedgEntry."Entry Type"::Sale);        if JobType > 0 then            JobLedgEntry.SetRange(Type, JobType - 1);        Clear(JobLedgerEntries);        JobLedgerEntries.SetTableView(JobLedgEntry);        JobLedgerEntries.Run();    end;    procedure GetHeadLineText(AmountField: array[8] of Option " ",SchPrice,UsagePrice,BillablePrice,InvoicedPrice,SchCost,UsageCost,BillableCost,InvoicedCost,SchProfit,UsageProfit,BillableProfit,InvoicedProfit; CurrencyField: array[8] of Option LCY,FCY; var HeadLineText: array[8] of Text[50]; Job: Record Job)    var        GLSetup: Record "General Ledger Setup";        I: Integer;        Txt: Text[30];    begin        Clear(HeadLineText);        GLSetup.Get();        for I := 1 to 8 do begin            Txt := '';            if CurrencyField[I] > 0 then                Txt := Job."Currency Code";            if Txt = '' then                Txt := GLSetup."LCY Code";            if AmountField[I] > 0 then                HeadLineText[I] := SelectStr(AmountField[I], HeadlineTxt) + '\' + Txt;        end;    end;    [IntegrationEvent(false, false)]    local procedure OnAfterJobCalculateCommonFilters(var Job: Record Job; var JobLedgerEntry: Record "Job Ledger Entry"; var JobPlanningLine: Record "Job Planning Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterJTCalculateCommonFilters(JobTask: Record "Job Task"; var JobTask2: Record "Job Task"; var Job2: Record Job; UseJobFilter: Boolean; var JobLedgerEntry: Record "Job Ledger Entry"; var JobPlanningLine: Record "Job Planning Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterReportAnalysis(AmountField: array[8] of Option " ",SchPrice,UsagePrice,ContractPrice,InvoicedPrice,SchCost,UsageCost,ContractCost,InvoicedCost,SchProfit,UsageProfit,ContractProfit,InvoicedProfit; CurrencyField: array[8] of Option LCY,FCY; var Amt: array[8] of Decimal)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCalcJobPlanAmountsOnAfterJobPlanningLineSetFilters(var JobPlanningLine: Record "Job Planning Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnReportAnalysisOnAfterGetAmounts(var PL: array[16] of Decimal; var CL: array[16] of Decimal; var P: array[16] of Decimal; var C: array[16] of Decimal; var I: Integer)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnShowPlanningLineOnAfterJobPlanningLineSetFilters(var JobPlanningLine: Record "Job Planning Line")    begin    end;}