Codeunit 9059 Acc. Payable Performance

Base Application, Microsoft.Finance.RoleCenters

src/Layers/W1/BaseApp/Finance/RoleCenters/AccPayablePerformance.Codeunit.al351 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.Finance.RoleCenters;using Microsoft.Finance.FinancialReports;using Microsoft.Finance.ReceivablesPayables;using Microsoft.Purchases.Analysis;using Microsoft.Purchases.Vendor;using Microsoft.Utilities;using System.Visualization;codeunit 9059 "Acc. Payable Performance"{    EventSubscriberInstance = Manual;    InherentEntitlements = X;    InherentPermissions = X;    var        AccountSchedulesChartSetup: Record "Account Schedules Chart Setup";        PurchbyVendGrpChartSetup: Record "Purch. by Vend.Grp.Chart Setup";        TempEntryNoAmountBuf: Record "Entry No. Amount Buffer" temporary;        AgedAccPayable: Codeunit "Aged Acc. Payable";        TopFiveVendorsChart: Codeunit "Top Five Vendors Chart";        AccSchedChartManagement: Codeunit "Acc. Sched. Chart Management";        PurchByVendGrpChartMgt: Codeunit "Purch. by Vend.Grp. Chart Mgt.";        Period: Option " ",Next,Previous;        TopFiveVendorChartNameTxt: Label 'Top 5 Vendors Chart';        AgedAccPayableNameTxt: Label 'Aged Accounts Payable';        XIncomeAndExpenseChartNameTxt: Label 'Income & Expense';        PurchasesByVendorGroupNameTxt: Label 'Purchases Trends by Vendor Groups';        TopFiveVendorsChartDescriptionTxt: Label 'This Pie chart shows the five vendors with the highest purchases value.';        NoEnabledChartsFoundErr: Label 'There are no enabled charts. Choose Select Chart to see a list of charts that you can display.';        ChartDefinitionMissingErr: Label 'There are no charts defined.';        MediumStatusTxt: Label '%1 | View by %2', Comment = '%1 - Account Schedule Chart Setup Name, %2 - Period Length';    procedure AddinReady(var PayablePerformanceChart: Record "Acc. Payable Performance Chart"; var BusinessChartBuffer: Record "Business Chart Buffer")    var        LastUsedChart: Record "Last Used Chart";        LastChartRecorded: Boolean;        LastChartExists: Boolean;        LastChartEnabled: Boolean;    begin        LastChartRecorded := LastUsedChart.Get(UserId);        LastChartExists :=          LastChartRecorded and PayablePerformanceChart.Get(LastUsedChart."Code Unit ID", LastUsedChart."Chart Name");        LastChartEnabled := LastChartExists and PayablePerformanceChart.Enabled;        if PayablePerformanceChart.IsEmpty() then            exit;        if not LastChartEnabled then begin            PayablePerformanceChart.SetRange(Enabled, true);            if not PayablePerformanceChart.FindLast() then                Dialog.Error(NoEnabledChartsFoundErr);        end;        SetDefaultPeriodLength(PayablePerformanceChart, BusinessChartBuffer);        UpdateChart(PayablePerformanceChart, BusinessChartBuffer, Period::" ");    end;    internal procedure ChartDescription(PayablePerformanceChart: Record "Acc. Payable Performance Chart"): Text    begin        case PayablePerformanceChart."Code Unit ID" of            Codeunit::"Acc. Sched. Chart Management":                exit(AccountSchedulesChartSetup.Description);            Codeunit::"Aged Acc. Payable":                exit(AgedAccPayable.Description(false));            Codeunit::"Top Five Vendors Chart":                exit(TopFiveVendorsChartDescriptionTxt);        end;    end;    internal procedure DataPointClicked(var BusinessChartBuffer: Record "Business Chart Buffer"; var PayablePerformanceChart: Record "Acc. Payable Performance Chart")    begin        case PayablePerformanceChart."Code Unit ID" of            Codeunit::"Acc. Sched. Chart Management":                AccSchedChartManagement.DrillDown(BusinessChartBuffer, AccountSchedulesChartSetup);            Codeunit::"Top Five Vendors Chart":                TopFiveVendorsChart.DrillDown(BusinessChartBuffer);            Codeunit::"Aged Acc. Payable":                AgedAccPayable.DrillDownByGroup(BusinessChartBuffer, TempEntryNoAmountBuf);            Codeunit::"Purch. by Vend.Grp. Chart Mgt.":                PurchByVendGrpChartMgt.DrillDown(BusinessChartBuffer);        end;    end;    internal procedure PopulateChartDefinitionTable()    begin        InsertChartDefinition(Codeunit::"Top Five Vendors Chart", TopFiveVendorChartNameTxt);        InsertChartDefinition(Codeunit::"Aged Acc. Payable", AgedAccPayableNameTxt);        InsertChartDefinition(Codeunit::"Acc. Sched. Chart Management", XIncomeAndExpenseChartNameTxt);        InsertChartDefinition(Codeunit::"Purch. by Vend.Grp. Chart Mgt.", PurchasesByVendorGroupNameTxt);    end;    internal procedure SelectChart(var BusinessChartBuffer: Record "Business Chart Buffer"; var PayablePerformanceChart: Record "Acc. Payable Performance Chart")    var        PayablePerformanceCharts: Page "Acc. Payable Perf. Charts";    begin        if PayablePerformanceChart.IsEmpty() then            if PayablePerformanceChart.WritePermission then begin                PopulateChartDefinitionTable();                Commit(); // Commit needed to pevent transaction error when inserting chart definition            end else                Error(ChartDefinitionMissingErr);        PayablePerformanceCharts.LookupMode(true);        if PayablePerformanceCharts.RunModal() = ACTION::LookupOK then begin            PayablePerformanceCharts.GetRecord(PayablePerformanceChart);            SetDefaultPeriodLength(PayablePerformanceChart, BusinessChartBuffer);            UpdateChart(PayablePerformanceChart, BusinessChartBuffer, Period::" ");        end;    end;    internal procedure SetDefaultPeriodLength(PayablePerformanceChart: Record "Acc. Payable Performance Chart"; var BusChartBuf: Record "Business Chart Buffer")    var        BusChartUserSetup: Record "Business Chart User Setup";    begin        case PayablePerformanceChart."Code Unit ID" of            Codeunit::"Aged Acc. Payable":                begin                    BusChartUserSetup.InitSetupCU(Codeunit::"Aged Acc. Payable");                    SetPeriodLength(                        PayablePerformanceChart,                        BusChartBuf,                        BusChartUserSetup."Period Length",                        true                    );                end;            Codeunit::"Acc. Sched. Chart Management":                begin                    AccountSchedulesChartSetup.Get('', PayablePerformanceChart."Chart Name");                    SetPeriodLength(                        PayablePerformanceChart,                        BusChartBuf,                        AccountSchedulesChartSetup."Period Length",                        true                    );                end;        end;    end;    internal procedure SetPeriodLength(        PayablePerformanceChart: Record "Acc. Payable Performance Chart";        var BusChartBuf: Record "Business Chart Buffer";        PeriodLength: Option;        IsInitState: Boolean)    var        NewStartDate: Date;    begin        case PayablePerformanceChart."Code Unit ID" of            Codeunit::"Acc. Sched. Chart Management":                begin                    AccountSchedulesChartSetup.Get('', PayablePerformanceChart."Chart Name");                    AccountSchedulesChartSetup.SetPeriodLength(PeriodLength);                    BusChartBuf."Period Length" := PeriodLength;                    if AccountSchedulesChartSetup."Look Ahead" then                        NewStartDate := GetBaseDate(BusChartBuf, IsInitState)                    else                        NewStartDate :=                            CalcDate(                                StrSubstNo(                                    '<-%1%2>',                                    AccountSchedulesChartSetup."No. of Periods",                                    BusChartBuf.GetPeriodLength()),                                GetBaseDate(BusChartBuf, IsInitState)                            );                    if AccountSchedulesChartSetup."Start Date" <> NewStartDate then begin                        AccountSchedulesChartSetup.Validate("Start Date", NewStartDate);                        AccountSchedulesChartSetup.Modify(true);                    end;                end;            Codeunit::"Purch. by Vend.Grp. Chart Mgt.":                PurchbyVendGrpChartSetup.SetPeriodLength(PeriodLength);            else                BusChartBuf."Period Length" := PeriodLength;        end;    end;    internal procedure UpdateChartSafe(var PayablePerformanceChart: Record "Acc. Payable Performance Chart"; var BusinessChartBuffer: Record "Business Chart Buffer"; Period: Option; var ErrorMessage: Text): Boolean    begin        ClearLastError();        OnUpdateChartSafe(PayablePerformanceChart, BusinessChartBuffer, Period);        ErrorMessage := GetLastErrorText();        if ErrorMessage = '' then            exit(true);        ClearLastError();        exit(false);    end;    internal procedure UpdateChart(var PayablePerformanceChart: Record "Acc. Payable Performance Chart"; var BusinessChartBuffer: Record "Business Chart Buffer"; Period: Option)    begin        case PayablePerformanceChart."Code Unit ID" of            Codeunit::"Acc. Sched. Chart Management":                begin                    AccSchedChartManagement.GetSetupRecordset(                        AccountSchedulesChartSetup,                        PayablePerformanceChart."Chart Name",                        0                    );                    AccSchedChartManagement.UpdateData(BusinessChartBuffer, Period, AccountSchedulesChartSetup);                end;            Codeunit::"Aged Acc. Payable":                begin                    BusinessChartBuffer."Period Filter Start Date" := WorkDate();                    AgedAccPayable.UpdateData(BusinessChartBuffer, TempEntryNoAmountBuf);                    AgedAccPayable.SaveSettings(BusinessChartBuffer)                end;            Codeunit::"Purch. by Vend.Grp. Chart Mgt.":                begin                    PurchbyVendGrpChartSetup.SetPeriod(Period);                    PurchByVendGrpChartMgt.UpdateChart(BusinessChartBuffer);                end;            else                TopFiveVendorsChart.UpdateChart(BusinessChartBuffer);        end;        UpdateLastUsedChart(PayablePerformanceChart);    end;    internal procedure UpdateStatusText(var PayablePerformanceChart: Record "Acc. Payable Performance Chart"; var BusinessChartBuffer: Record "Business Chart Buffer"; var StatusText: Text)    begin        case PayablePerformanceChart."Code Unit ID" of            Codeunit::"Aged Acc. Payable":                StatusText := StrSubstNo(MediumStatusTxt, PayablePerformanceChart."Chart Name", BusinessChartBuffer."Period Length");            else                StatusText := PayablePerformanceChart."Chart Name";        end;    end;    local procedure UpdateLastUsedChart(PayablePerformanceChart: Record "Acc. Payable Performance Chart")    var        LastUsedChart: Record "Last Used Chart";    begin        if LastUsedChart.Get(UserId) then begin            if (LastUsedChart."Code Unit ID" <> PayablePerformanceChart."Code Unit ID") or (LastUsedChart."Chart Name" <> PayablePerformanceChart."Chart Name") then begin                LastUsedChart.Validate("Code Unit ID", PayablePerformanceChart."Code Unit ID");                LastUsedChart.Validate("Chart Name", PayablePerformanceChart."Chart Name");                LastUsedChart.Modify(false);            end;        end else begin            LastUsedChart.Validate(UID, UserId);            LastUsedChart.Validate("Code Unit ID", PayablePerformanceChart."Code Unit ID");            LastUsedChart.Validate("Chart Name", PayablePerformanceChart."Chart Name");            LastUsedChart.Insert(false);        end;    end;    local procedure InsertChartDefinition(ChartCodeunitId: Integer; ChartName: Text[60])    var        PayablePerformanceChart: Record "Acc. Payable Performance Chart";    begin        if PayablePerformanceChart.Get(ChartCodeunitId, ChartName) then            exit;        PayablePerformanceChart."Code Unit ID" := ChartCodeunitId;        PayablePerformanceChart."Chart Name" := ChartName;        EnableChart(PayablePerformanceChart);        PayablePerformanceChart.Insert(false);    end;    internal procedure EnableChart(var PayablePerformanceChart: Record "Acc. Payable Performance Chart")    begin        PayablePerformanceChart.Enabled := true;    end;    local procedure GetPeriodLength(): Text[1]    begin        case AccountSchedulesChartSetup."Period Length" of            AccountSchedulesChartSetup."Period Length"::Day:                exit('D');            AccountSchedulesChartSetup."Period Length"::Week:                exit('W');            AccountSchedulesChartSetup."Period Length"::Month:                exit('M');            AccountSchedulesChartSetup."Period Length"::Quarter:                exit('Q');            AccountSchedulesChartSetup."Period Length"::Year:                exit('Y');        end;    end;    local procedure GetBaseDate(var BusChartBuf: Record "Business Chart Buffer"; IsInitState: Boolean): Date    var        ColumnIndex: Integer;        StartDate: Date;        EndDate: Date;    begin        if AccountSchedulesChartSetup."Look Ahead" then            ColumnIndex := 0        else            ColumnIndex := AccountSchedulesChartSetup."No. of Periods" - 1;        if IsInitState then            exit(WorkDate());        BusChartBuf.GetPeriodFromMapColumn(ColumnIndex, StartDate, EndDate);        if AccountSchedulesChartSetup."Look Ahead" then            exit(StartDate);        exit(CalcDate(StrSubstNo('<1%1>', GetPeriodLength()), EndDate));    end;    internal procedure TopVendorListUpdatedRecently(var LastVendorLedgerEntryNo: Integer): Boolean    var        TopVendorsByPurch: Record "Top Vendors By Purchase";        LastBufferUpdateDateTime: DateTime;        TwelveHourDuration: Duration;        ZeroDayTime: DateTime;    begin        if TopVendorsByPurch.FindFirst() then begin            LastBufferUpdateDateTime := TopVendorsByPurch.DateTimeUpdated;            ZeroDayTime := 0DT;            TwelveHourDuration := 43200000;            LastVendorLedgerEntryNo := TopVendorsByPurch.LastVendLedgerEntryNo;            if LastBufferUpdateDateTime = ZeroDayTime then                exit(false);            if CurrentDateTime - LastBufferUpdateDateTime < TwelveHourDuration then                exit(true);        end;    end;    internal procedure ScheduleTopVendorListRefreshTask()    var        LastVendorLedgerEntryNo: Integer;    begin        if TopVendorListUpdatedRecently(LastVendorLedgerEntryNo) then            exit;        if TaskScheduler.CanCreateTask() then            TaskScheduler.CreateTask(Codeunit::"Top Vendors By Purchases Job", 0, true, CompanyName(), 0DT);    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Acc. Payable Performance", OnUpdateChartSafe, '', false, false)]    local procedure HandleUpdateChartSafe(var PayablePerformanceChart: Record "Acc. Payable Performance Chart"; var BusinessChartBuffer: Record "Business Chart Buffer"; Period: Option)    begin        UpdateChart(PayablePerformanceChart, BusinessChartBuffer, Period);    end;    [IntegrationEvent(false, false)]    local procedure OnUpdateChartSafe(var PayablePerformanceChart: Record "Acc. Payable Performance Chart"; var BusinessChartBuffer: Record "Business Chart Buffer"; Period: Option)    begin    end;}