Codeunit 841 Cash Flow Management

Base Application, Microsoft.CashFlow.Forecast

src/Layers/W1/BaseApp/CashFlow/Forecast/CashFlowManagement.Codeunit.al843 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.CashFlow.Forecast;using Microsoft.CashFlow.Account;using Microsoft.CashFlow.Comment;using Microsoft.CashFlow.Setup;using Microsoft.CashFlow.Worksheet;using Microsoft.Finance.Analysis;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.Finance.GeneralLedger.Budget;using Microsoft.Finance.VAT.Ledger;using Microsoft.FixedAssets.FixedAsset;using Microsoft.Foundation.NoSeries;using Microsoft.Projects.Project.Planning;using Microsoft.Purchases.Document;using Microsoft.Purchases.Payables;using Microsoft.Purchases.Posting;using Microsoft.Sales.Document;using Microsoft.Sales.Posting;using Microsoft.Sales.Receivables;using System.Security.AccessControl;using System.Threading;codeunit 841 "Cash Flow Management"{    trigger OnRun()    begin    end;    var#pragma warning disable AA0470        SourceDataDoesNotExistErr: Label 'Source data does not exist for %1: %2.', Comment = 'Source data doesn''t exist for G/L Account: 8210.';        SourceDataDoesNotExistInfoErr: Label 'Source data does not exist in %1 for %2: %3.', Comment = 'Source data doesn''t exist in Vendor Ledger Entry for Document No.: PO000123.';#pragma warning restore AA0470        SourceTypeNotSupportedErr: Label 'Source type is not supported.';        DefaultTxt: Label 'Default';        DummyDate: Date;        CashFlowTxt: Label 'CashFlow';        CashFlowForecastTxt: Label 'Cash Flow Forecast';        CashFlowAbbreviationTxt: Label 'CF', Comment = 'Abbreviation of Cash Flow';        UpdatingMsg: Label 'Updating Cash Flow Forecast...';        JobQueueEntryDescTxt: Label 'Auto-created for updating of cash flow figures. Can be deleted if not used. Will be recreated when the feature is activated.';    [Scope('OnPrem')]    procedure ShowSourceDocument(CFVariant: Variant)    var        CFRecordRef: RecordRef;        Handled: Boolean;    begin        OnBeforeShowSourceDocument(CFVariant, Handled);        if Handled then            exit;        CFRecordRef.GetTable(CFVariant);        case CFRecordRef.Number of            DATABASE::"Cash Flow Worksheet Line":                ShowSourceLocalCFWorkSheetLine(true, CFVariant);            DATABASE::"Cash Flow Forecast Entry":                ShowSourceLocalCFEntry(true, CFVariant);        end;    end;    [Scope('OnPrem')]    procedure ShowSource(CFVariant: Variant)    var        CFRecordRef: RecordRef;        Handled: Boolean;    begin        OnBeforeShowSource(CFVariant, Handled);        if Handled then            exit;        CFRecordRef.GetTable(CFVariant);        case CFRecordRef.Number of            DATABASE::"Cash Flow Worksheet Line":                ShowSourceLocalCFWorkSheetLine(false, CFVariant);            DATABASE::"Cash Flow Forecast Entry":                ShowSourceLocalCFEntry(false, CFVariant);        end;    end;    local procedure ShowSourceLocalCFWorkSheetLine(ShowDocument: Boolean; CFVariant: Variant)    var        CashFlowWorksheetLine: Record "Cash Flow Worksheet Line";    begin        CashFlowWorksheetLine := CFVariant;        CashFlowWorksheetLine.TestField("Source Type");        if CashFlowWorksheetLine."Source Type" <> CashFlowWorksheetLine."Source Type"::Tax then            CashFlowWorksheetLine.TestField("Source No.");        if CashFlowWorksheetLine."Source Type" = CashFlowWorksheetLine."Source Type"::"G/L Budget" then            CashFlowWorksheetLine.TestField("G/L Budget Name");        ShowSourceLocal(ShowDocument,          CashFlowWorksheetLine."Source Type",          CashFlowWorksheetLine."Source No.",          CashFlowWorksheetLine."G/L Budget Name",          CashFlowWorksheetLine."Document Date",          CashFlowWorksheetLine."Document No.");    end;    local procedure ShowSourceLocalCFEntry(ShowDocument: Boolean; CFVariant: Variant)    var        CashFlowForecastEntry: Record "Cash Flow Forecast Entry";    begin        CashFlowForecastEntry := CFVariant;        CashFlowForecastEntry.TestField("Source Type");        if CashFlowForecastEntry."Source Type" <> CashFlowForecastEntry."Source Type"::Tax then            CashFlowForecastEntry.TestField("Source No.");        if CashFlowForecastEntry."Source Type" = CashFlowForecastEntry."Source Type"::"G/L Budget" then            CashFlowForecastEntry.TestField("G/L Budget Name");        ShowSourceLocal(ShowDocument,          CashFlowForecastEntry."Source Type",          CashFlowForecastEntry."Source No.",          CashFlowForecastEntry."G/L Budget Name",          CashFlowForecastEntry."Document Date",          CashFlowForecastEntry."Document No.");    end;    local procedure ShowSourceLocal(ShowDocument: Boolean; SourceType: Enum "Cash Flow Source Type"; SourceNo: Code[20]; BudgetName: Code[10]; DocumentDate: Date; DocumentNo: Code[20])    var        CFWorksheetLine: Record "Cash Flow Worksheet Line";        IsHandled: Boolean;    begin        case SourceType of            CFWorksheetLine."Source Type"::"Liquid Funds":                ShowLiquidFunds(SourceNo, ShowDocument);            CFWorksheetLine."Source Type"::Receivables:                ShowCustomer(SourceNo, ShowDocument);            CFWorksheetLine."Source Type"::Payables:                ShowVendor(SourceNo, ShowDocument);            CFWorksheetLine."Source Type"::"Sales Orders":                ShowSalesOrder(SourceNo);            CFWorksheetLine."Source Type"::"Purchase Orders":                ShowPurchaseOrder(SourceNo);            CFWorksheetLine."Source Type"::"Cash Flow Manual Revenue":                ShowManualRevenue(SourceNo);            CFWorksheetLine."Source Type"::"Cash Flow Manual Expense":                ShowManualExpense(SourceNo);            CFWorksheetLine."Source Type"::"Fixed Assets Budget",            CFWorksheetLine."Source Type"::"Fixed Assets Disposal":                ShowFixedAsset(SourceNo);            CFWorksheetLine."Source Type"::"G/L Budget":                ShowGLBudget(BudgetName, SourceNo);            CFWorksheetLine."Source Type"::Job:                ShowJob(SourceNo, DocumentDate, DocumentNo);            CFWorksheetLine."Source Type"::Tax:                ShowTax(SourceNo, DocumentDate);            CFWorksheetLine."Source Type"::"Azure AI":                ShowAzureAIForecast();            else begin                IsHandled := false;                OnShowSourceLocalSourceTypeCase(SourceType, SourceNo, ShowDocument, DocumentNo, DocumentDate, BudgetName, IsHandled);                if not IsHandled then                    Error(SourceTypeNotSupportedErr);            end;        end;    end;    local procedure ShowLiquidFunds(SourceNo: Code[20]; ShowDocument: Boolean)    var        GLAccount: Record "G/L Account";    begin        GLAccount.SetRange("No.", SourceNo);        if not GLAccount.FindFirst() then            Error(SourceDataDoesNotExistErr, GLAccount.TableCaption(), SourceNo);        if ShowDocument then            PAGE.Run(PAGE::"G/L Account Card", GLAccount)        else            PAGE.Run(PAGE::"Chart of Accounts", GLAccount);    end;    local procedure ShowCustomer(SourceNo: Code[20]; ShowDocument: Boolean)    var        CustLedgEntry: Record "Cust. Ledger Entry";    begin        CustLedgEntry.SetRange("Document No.", SourceNo);        if not CustLedgEntry.FindFirst() then            Error(SourceDataDoesNotExistInfoErr, CustLedgEntry.TableCaption(), CustLedgEntry.FieldCaption("Document No."), SourceNo);        if ShowDocument then            CustLedgEntry.ShowDoc()        else            PAGE.Run(0, CustLedgEntry);    end;    local procedure ShowVendor(SourceNo: Code[20]; ShowDocument: Boolean)    var        VendLedgEntry: Record "Vendor Ledger Entry";    begin        VendLedgEntry.SetRange("Document No.", SourceNo);        if not VendLedgEntry.FindFirst() then            Error(SourceDataDoesNotExistInfoErr, VendLedgEntry.TableCaption(), VendLedgEntry.FieldCaption("Document No."), SourceNo);        if ShowDocument then            VendLedgEntry.ShowDoc()        else            PAGE.Run(0, VendLedgEntry);    end;    local procedure ShowSalesOrder(SourceNo: Code[20])    var        SalesHeader: Record "Sales Header";        SalesOrder: Page "Sales Order";        SourceType: Enum "Cash Flow Source Type";    begin        SalesHeader.SetRange("Document Type", SalesHeader."Document Type"::Order);        SalesHeader.SetRange("No.", SourceNo);        if not SalesHeader.FindFirst() then            Error(SourceDataDoesNotExistErr, SourceType::"Sales Orders", SourceNo);        SalesOrder.SetTableView(SalesHeader);        SalesOrder.Run();    end;    local procedure ShowPurchaseOrder(SourceNo: Code[20])    var        PurchaseHeader: Record "Purchase Header";        PurchaseOrder: Page "Purchase Order";        SourceType: Enum "Cash Flow Source Type";    begin        PurchaseHeader.SetRange("Document Type", PurchaseHeader."Document Type"::Order);        PurchaseHeader.SetRange("No.", SourceNo);        if not PurchaseHeader.FindFirst() then            Error(SourceDataDoesNotExistErr, SourceType::"Purchase Orders", SourceNo);        PurchaseOrder.SetTableView(PurchaseHeader);        PurchaseOrder.Run();    end;    local procedure ShowManualRevenue(SourceNo: Code[20])    var        CFManualRevenue: Record "Cash Flow Manual Revenue";        CFManualRevenues: Page "Cash Flow Manual Revenues";    begin        CFManualRevenue.SetRange(Code, SourceNo);        if not CFManualRevenue.FindFirst() then            Error(SourceDataDoesNotExistErr, CFManualRevenues.Caption, SourceNo);        CFManualRevenues.SetTableView(CFManualRevenue);        CFManualRevenues.Run();    end;    local procedure ShowManualExpense(SourceNo: Code[20])    var        CFManualExpense: Record "Cash Flow Manual Expense";        CFManualExpenses: Page "Cash Flow Manual Expenses";    begin        CFManualExpense.SetRange(Code, SourceNo);        if not CFManualExpense.FindFirst() then            Error(SourceDataDoesNotExistErr, CFManualExpenses.Caption, SourceNo);        CFManualExpenses.SetTableView(CFManualExpense);        CFManualExpenses.Run();    end;    local procedure ShowFixedAsset(SourceNo: Code[20])    var        FixedAsset: Record "Fixed Asset";    begin        FixedAsset.SetRange("No.", SourceNo);        if not FixedAsset.FindFirst() then            Error(SourceDataDoesNotExistInfoErr, FixedAsset.TableCaption(), FixedAsset.FieldCaption("No."), SourceNo);        PAGE.Run(PAGE::"Fixed Asset Card", FixedAsset);    end;    local procedure ShowGLBudget(BudgetName: Code[10]; SourceNo: Code[20])    var        GLBudgetName: Record "G/L Budget Name";        GLAccount: Record "G/L Account";        Budget: Page Budget;    begin        if not GLAccount.Get(SourceNo) then            Error(SourceDataDoesNotExistErr, GLAccount.TableCaption(), SourceNo);        if not GLBudgetName.Get(BudgetName) then            Error(SourceDataDoesNotExistErr, GLBudgetName.TableCaption(), BudgetName);        Budget.SetBudgetName(BudgetName);        Budget.SetGLAccountFilter(SourceNo);        Budget.Run();    end;    local procedure ShowAzureAIForecast()    begin    end;    procedure CashFlowNameFullLength(CashFlowNo: Code[20]): Text[100]    var        CashFlowForecast: Record "Cash Flow Forecast";    begin        if CashFlowForecast.Get(CashFlowNo) then            exit(CashFlowForecast.Description);        exit('')    end;    procedure CashFlowAccountName(CashFlowAccountNo: Code[20]): Text[100]    var        CashFlowAccount: Record "Cash Flow Account";    begin        if CashFlowAccount.Get(CashFlowAccountNo) then            exit(CashFlowAccount.Name);        exit('')    end;    local procedure ShowJob(SourceNo: Code[20]; DocumentDate: Date; DocumentNo: Code[20])    var        JobPlanningLine: Record "Job Planning Line";        JobPlanningLines: Page "Job Planning Lines";    begin        JobPlanningLine.SetRange("Job No.", SourceNo);        JobPlanningLine.SetRange("Document Date", DocumentDate);        JobPlanningLine.SetRange("Document No.", DocumentNo);        JobPlanningLine.SetFilter("Line Type",          StrSubstNo('%1|%2',            JobPlanningLine."Line Type"::Billable,            JobPlanningLine."Line Type"::"Both Budget and Billable"));        if not JobPlanningLine.FindFirst() then            Error(SourceDataDoesNotExistErr, JobPlanningLines.Caption, SourceNo);        JobPlanningLines.SetTableView(JobPlanningLine);        JobPlanningLines.Run();    end;    local procedure ShowTax(SourceNo: Code[20]; TaxPayableDate: Date)    var        PurchaseHeader: Record "Purchase Header";        SalesHeader: Record "Sales Header";        VATEntry: Record "VAT Entry";        SalesOrderList: Page "Sales Order List";        PurchaseOrderList: Page "Purchase Order List";        SourceNum: Integer;    begin        Evaluate(SourceNum, SourceNo);        case SourceNum of            DATABASE::"Purchase Header":                begin                    SetViewOnPurchaseHeaderForTaxCalc(PurchaseHeader, TaxPayableDate);                    PurchaseOrderList.SkipShowingLinesWithoutVAT();                    PurchaseOrderList.SetTableView(PurchaseHeader);                    PurchaseOrderList.Run();                end;            DATABASE::"Sales Header":                begin                    SetViewOnSalesHeaderForTaxCalc(SalesHeader, TaxPayableDate);                    SalesOrderList.SkipShowingLinesWithoutVAT();                    SalesOrderList.SetTableView(SalesHeader);                    SalesOrderList.Run();                end;            DATABASE::"VAT Entry":                begin                    SetViewOnVATEntryForTaxCalc(VATEntry, TaxPayableDate);                    PAGE.Run(PAGE::"VAT Entries", VATEntry);                end;        end;    end;    procedure RecurrenceToRecurringFrequency(Recurrence: Option " ",Daily,Weekly,Monthly,Quarterly,Yearly) RecurringFrequency: Text    begin        case Recurrence of            Recurrence::Daily:                RecurringFrequency := '<1D>';            Recurrence::Weekly:                RecurringFrequency := '<1W>';            Recurrence::Monthly:                RecurringFrequency := '<1M>';            Recurrence::Quarterly:                RecurringFrequency := '<1Q>';            Recurrence::Yearly:                RecurringFrequency := '<1Y>';            else                RecurringFrequency := '';        end;    end;    procedure RecurringFrequencyToRecurrence(RecurringFrequency: DateFormula; var RecurrenceOut: Option " ",Daily,Weekly,Monthly,Quarterly,Yearly)    var        Daily: DateFormula;        Weekly: DateFormula;        Monthly: DateFormula;        Quarterly: DateFormula;        Yearly: DateFormula;    begin        Evaluate(Daily, '<1D>');        Evaluate(Weekly, '<1W>');        Evaluate(Monthly, '<1M>');        Evaluate(Quarterly, '<1Q>');        Evaluate(Yearly, '<1Y>');        case RecurringFrequency of            Daily:                RecurrenceOut := RecurrenceOut::Daily;            Weekly:                RecurrenceOut := RecurrenceOut::Weekly;            Monthly:                RecurrenceOut := RecurrenceOut::Monthly;            Quarterly:                RecurrenceOut := RecurrenceOut::Quarterly;            Yearly:                RecurrenceOut := RecurrenceOut::Yearly;            else                RecurrenceOut := RecurrenceOut::" ";        end;    end;    procedure CreateAndStartJobQueueEntry(UpdateFrequency: Option Never,Daily,Weekly)    var        JobQueueEntry: Record "Job Queue Entry";        JobQueueManagement: Codeunit "Job Queue Management";    begin        // Create a new job queue entry for Cash Flow Forecast        JobQueueEntry."No. of Minutes between Runs" := UpdateFrequencyToNoOfMinutes(UpdateFrequency);        JobQueueEntry."Object Type to Run" := JobQueueEntry."Object Type to Run"::Codeunit;        JobQueueEntry."Object ID to Run" := CODEUNIT::"Cash Flow Forecast Update";        JobQueueEntry.Description := CopyStr(JobQueueEntryDescTxt, 1, MaxStrLen(JobQueueEntry.Description));        JobQueueManagement.CreateJobQueueEntry(JobQueueEntry);        // Start it        CODEUNIT.Run(CODEUNIT::"Job Queue - Enqueue", JobQueueEntry);    end;    procedure DeleteJobQueueEntries()    var        JobQueueEntry: Record "Job Queue Entry";        JobQueueManagement: Codeunit "Job Queue Management";    begin        JobQueueManagement.DeleteJobQueueEntries(JobQueueEntry."Object Type to Run"::Codeunit, CODEUNIT::"Cash Flow Forecast Update");    end;    procedure GetCashAccountFilter() CashAccountFilter: Text    var        GLAccountCategory: Record "G/L Account Category";    begin        GLAccountCategory.SetRange("Additional Report Definition", GLAccountCategory."Additional Report Definition"::"Cash Accounts");        if not GLAccountCategory.FindSet() then            exit;        CashAccountFilter := GLAccountCategory.GetTotaling();        while GLAccountCategory.Next() <> 0 do            CashAccountFilter += '|' + GLAccountCategory.GetTotaling();        CashAccountFilter := CashAccountFilter.TrimStart('|').TrimEnd('|');    end;    procedure SetupCashFlow(LiquidFundsGLAccountFilter: Code[250])    var        CashFlowNoSeriesCode: Code[20];    begin        DeleteExistingSetup();        CreateCashFlowAccounts(LiquidFundsGLAccountFilter);        CashFlowNoSeriesCode := CreateCashFlowNoSeries();        CreateCashFlowSetup(CashFlowNoSeriesCode);        CreateCashFlowForecast();        CreateCashFlowChartSetup();        CreateCashFlowReportSelection();    end;    local procedure DeleteExistingSetup()    var        CashFlowForecast: Record "Cash Flow Forecast";        CashFlowAccount: Record "Cash Flow Account";        CashFlowAccountComment: Record "Cash Flow Account Comment";        CashFlowSetup: Record "Cash Flow Setup";        CashFlowWorksheetLine: Record "Cash Flow Worksheet Line";        CashFlowForecastEntry: Record "Cash Flow Forecast Entry";        CashFlowManualRevenue: Record "Cash Flow Manual Revenue";        CashFlowManualExpense: Record "Cash Flow Manual Expense";        CashFlowReportSelection: Record "Cash Flow Report Selection";        CashFlowChartSetup: Record "Cash Flow Chart Setup";        JobQueueEntry: Record "Job Queue Entry";        JobQueueManagement: Codeunit "Job Queue Management";    begin        CashFlowForecast.DeleteAll();        CashFlowAccount.DeleteAll();        CashFlowAccountComment.DeleteAll();        CashFlowSetup.DeleteAll();        CashFlowWorksheetLine.DeleteAll();        CashFlowForecastEntry.DeleteAll();        CashFlowManualRevenue.DeleteAll();        CashFlowManualExpense.DeleteAll();        CashFlowReportSelection.DeleteAll();        CashFlowChartSetup.DeleteAll();        JobQueueManagement.DeleteJobQueueEntries(JobQueueEntry."Object Type to Run"::Codeunit, CODEUNIT::"Cash Flow Forecast Update");    end;    local procedure CreateCashFlowAccounts(LiquidFundsGLAccountFilter: Code[250])    var        CashFlowAccount: Record "Cash Flow Account";    begin        CreateCashFlowAccount(CashFlowAccount."Source Type"::Receivables, '');        CreateCashFlowAccount(CashFlowAccount."Source Type"::Payables, '');        CreateCashFlowAccount(CashFlowAccount."Source Type"::"Sales Orders", '');        CreateCashFlowAccount(CashFlowAccount."Source Type"::"Purchase Orders", '');        CreateCashFlowAccount(CashFlowAccount."Source Type"::"Fixed Assets Budget", '');        CreateCashFlowAccount(CashFlowAccount."Source Type"::"Fixed Assets Disposal", '');        CreateCashFlowAccount(CashFlowAccount."Source Type"::"Liquid Funds", LiquidFundsGLAccountFilter);        CreateCashFlowAccount(CashFlowAccount."Source Type"::Job, '');        CreateCashFlowAccount(CashFlowAccount."Source Type"::"Cash Flow Manual Expense", '');        CreateCashFlowAccount(CashFlowAccount."Source Type"::"Cash Flow Manual Revenue", '');        CreateCashFlowAccount(CashFlowAccount."Source Type"::Tax, '');        OnAfterCreateCashFlowAccounts(LiquidFundsGLAccountFilter);    end;    procedure CreateCashFlowAccount(SourceType: Enum "Cash Flow Source Type"; LiquidFundsGLAccountFilter: Code[250])    var        CashFlowAccount: Record "Cash Flow Account";    begin        InitCashFlowAccount(CashFlowAccount, SourceType);        if SourceType = CashFlowAccount."Source Type"::"Liquid Funds" then begin            CashFlowAccount."G/L Integration" := CashFlowAccount."G/L Integration"::Balance;            CashFlowAccount."G/L Account Filter" := LiquidFundsGLAccountFilter;        end;        CashFlowAccount.Insert();    end;    procedure GetNoFromSourceType(SourceType: Option): Text    var        CashFlowAccount: Record "Cash Flow Account";    begin        CashFlowAccount."Source Type" := "Cash Flow Source Type".FromInteger(SourceType);        exit(CopyStr(StrSubstNo('%1-%2', SourceType, Format(CashFlowAccount."Source Type")), 1, MaxStrLen(CashFlowAccount."No.")));    end;    local procedure InitCashFlowAccount(var CashFlowAccount: Record "Cash Flow Account"; SourceType: Enum "Cash Flow Source Type")    begin        CashFlowAccount.Init();        CashFlowAccount.Validate("Source Type", SourceType);        CashFlowAccount.Validate("No.", GetNoFromSourceType(SourceType.AsInteger()));        CashFlowAccount.Validate(Name, Format(CashFlowAccount."Source Type", MaxStrLen(CashFlowAccount.Name)));    end;    local procedure CreateCashFlowForecast()    var        CashFlowForecast: Record "Cash Flow Forecast";    begin        CashFlowForecast.Init();        CashFlowForecast.Validate("No.", DefaultTxt);        CashFlowForecast.Validate(Description, DefaultTxt);        CashFlowForecast.ValidateShowInChart(true);        CashFlowForecast."Overdue CF Dates to Work Date" := true;        CashFlowForecast.Insert();    end;    local procedure CreateCashFlowNoSeries(): Code[20]    var        NoSeries: Record "No. Series";        NoSeriesLine: Record "No. Series Line";    begin        if NoSeries.Get(CashFlowTxt) then            exit(NoSeries.Code);        NoSeries.Init();        NoSeries.Code := CashFlowTxt;        NoSeries.Description := CashFlowForecastTxt;        NoSeries."Default Nos." := true;        NoSeries."Manual Nos." := true;        NoSeries.Insert();        NoSeriesLine.Init();        NoSeriesLine."Series Code" := NoSeries.Code;        NoSeriesLine."Line No." := 10000;        NoSeriesLine.Validate("Starting No.", CashFlowAbbreviationTxt + '000001');        NoSeriesLine.Insert(true);        exit(NoSeries.Code);    end;    local procedure CreateCashFlowSetup(CashFlowNoSeriesCode: Code[20])    var        CashFlowSetup: Record "Cash Flow Setup";        CashFlowAccount: Record "Cash Flow Account";    begin        CashFlowSetup.Init();        CashFlowSetup.Validate("Cash Flow Forecast No. Series", CashFlowNoSeriesCode);        CashFlowSetup.Validate("Receivables CF Account No.", GetNoFromSourceType(CashFlowAccount."Source Type"::Receivables.AsInteger()));        CashFlowSetup.Validate("Payables CF Account No.", GetNoFromSourceType(CashFlowAccount."Source Type"::Payables.AsInteger()));        CashFlowSetup.Validate("Sales Order CF Account No.", GetNoFromSourceType(CashFlowAccount."Source Type"::"Sales Orders".AsInteger()));        CashFlowSetup.Validate("Purch. Order CF Account No.", GetNoFromSourceType(CashFlowAccount."Source Type"::"Purchase Orders".AsInteger()));        CashFlowSetup.Validate("FA Budget CF Account No.", GetNoFromSourceType(CashFlowAccount."Source Type"::"Fixed Assets Budget".AsInteger()));        CashFlowSetup.Validate(            "FA Disposal CF Account No.", GetNoFromSourceType(CashFlowAccount."Source Type"::"Fixed Assets Disposal".AsInteger()));        CashFlowSetup.Validate("Job CF Account No.", GetNoFromSourceType(CashFlowAccount."Source Type"::Job.AsInteger()));        CashFlowSetup.Validate("Tax CF Account No.", GetNoFromSourceType(CashFlowAccount."Source Type"::Tax.AsInteger()));        OnBeforeInsertOnCreateCashFlowSetup(CashFlowSetup, CashFlowNoSeriesCode);        CashFlowSetup.Insert();    end;    local procedure CreateCashFlowChartSetup()    var        User: Record User;    begin        if not User.FindSet() then            CreateCashFlowChartSetupForUser(UserId)        else            repeat                CreateCashFlowChartSetupForUser(User."User Name");            until User.Next() = 0;    end;    local procedure CreateCashFlowChartSetupForUser(UserName: Code[50])    var        CashFlowChartSetup: Record "Cash Flow Chart Setup";    begin        CashFlowChartSetup.Init();        CashFlowChartSetup."User ID" := UserName;        CashFlowChartSetup.Show := CashFlowChartSetup.Show::Combined;        CashFlowChartSetup."Start Date" := CashFlowChartSetup."Start Date"::"Working Date";        CashFlowChartSetup."Period Length" := CashFlowChartSetup."Period Length"::Month;        CashFlowChartSetup."Group By" := CashFlowChartSetup."Group By"::"Source Type";        CashFlowChartSetup.Insert();    end;    local procedure CreateCashFlowReportSelection()    var        CashFlowReportSelection: Record "Cash Flow Report Selection";    begin        CashFlowReportSelection.NewRecord();        CashFlowReportSelection.Validate("Report ID", 846);        CashFlowReportSelection.Insert();    end;    procedure UpdateCashFlowForecast(AzureAIEnabled: Boolean)    var        CashFlowForecast: Record "Cash Flow Forecast";        CashFlowSetup: Record "Cash Flow Setup";        SuggestWorksheetLines: Report "Suggest Worksheet Lines";        Window: Dialog;        Sources: array[16] of Boolean;        Index: Integer;        SourceType: Enum "Cash Flow Source Type";        Handled: Boolean;    begin        OnBeforeUpdateCashFlowForecast(AzureAIEnabled, Handled);        if Handled then            exit;        Window.Open(UpdatingMsg);        if not CashFlowSetup.Get() then            exit;        if not CashFlowForecast.Get(CashFlowSetup."CF No. on Chart in Role Center") then            exit;        UpdateCashFlowForecastManualPaymentHorizon(CashFlowForecast);        for Index := 1 to ArrayLen(Sources) do            Sources[Index] := true;        Sources[SourceType::"Azure AI".AsInteger()] := AzureAIEnabled;        SuggestWorksheetLines.InitializeRequest(          Sources, CashFlowSetup."CF No. on Chart in Role Center", CashFlowForecast."Default G/L Budget Name", true);        SuggestWorksheetLines.UseRequestPage := false;        OnBeforeRunSuggestWorksheetLinesOnUpdateCashFlowForecast(SuggestWorksheetLines);        SuggestWorksheetLines.Run();        CODEUNIT.Run(CODEUNIT::"Cash Flow Wksh.-Register Batch");        Window.Close();    end;    local procedure UpdateCashFlowForecastManualPaymentHorizon(var CashFlowForecast: Record "Cash Flow Forecast")    begin        CashFlowForecast.Validate("Manual Payments From", WorkDate());        CashFlowForecast.Validate("Manual Payments To", CalcDate('<+1Y>', WorkDate()));        CashFlowForecast.Modify();    end;    local procedure UpdateFrequencyToNoOfMinutes(UpdateFrequency: Option Never,Daily,Weekly): Integer    begin        case UpdateFrequency of            UpdateFrequency::Never:                exit(0);            UpdateFrequency::Daily:                exit(60 * 24);            UpdateFrequency::Weekly:                exit(60 * 24 * 7);        end;    end;    procedure SetViewOnPurchaseHeaderForTaxCalc(var PurchaseHeader: Record "Purchase Header"; TaxPaymentDueDate: Date)    var        CashFlowSetup: Record "Cash Flow Setup";        StartDate: Date;        EndDate: Date;    begin        DummyDate := 0D;        PurchaseHeader.SetRange("Document Type", PurchaseHeader."Document Type"::Order);        PurchaseHeader.SetFilter("Document Date", '<>%1', DummyDate);        if TaxPaymentDueDate <> DummyDate then begin            CashFlowSetup.GetTaxPeriodStartEndDates(TaxPaymentDueDate, StartDate, EndDate);            PurchaseHeader.SetFilter("Document Date", StrSubstNo('%1..%2', StartDate, EndDate));        end;        PurchaseHeader.SetCurrentKey("Document Date");        PurchaseHeader.SetAscending("Document Date", true);    end;    procedure SetViewOnSalesHeaderForTaxCalc(var SalesHeader: Record "Sales Header"; TaxPaymentDueDate: Date)    var        CashFlowSetup: Record "Cash Flow Setup";        StartDate: Date;        EndDate: Date;    begin        SalesHeader.SetRange("Document Type", SalesHeader."Document Type"::Order);        SalesHeader.SetFilter("Document Date", '<>%1', DummyDate);        if TaxPaymentDueDate <> DummyDate then begin            CashFlowSetup.GetTaxPeriodStartEndDates(TaxPaymentDueDate, StartDate, EndDate);            SalesHeader.SetFilter("Document Date", StrSubstNo('%1..%2', StartDate, EndDate));        end;        SalesHeader.SetCurrentKey("Document Date");        SalesHeader.SetAscending("Document Date", true);    end;    procedure SetViewOnVATEntryForTaxCalc(var VATEntry: Record "VAT Entry"; TaxPaymentDueDate: Date)    var        CashFlowSetup: Record "Cash Flow Setup";        StartDate: Date;        EndDate: Date;    begin        VATEntry.SetFilter(Type, StrSubstNo('%1|%2', VATEntry.Type::Purchase, VATEntry.Type::Sale));        VATEntry.SetFilter("VAT Calculation Type", StrSubstNo('<>%1', VATEntry."VAT Calculation Type"::"Reverse Charge VAT"));        VATEntry.SetRange(Closed, false);        VATEntry.SetFilter(Amount, '<>%1', 0);        VATEntry.SetFilter("Document Date", '<>%1', DummyDate);        if TaxPaymentDueDate <> DummyDate then begin            CashFlowSetup.GetTaxPeriodStartEndDates(TaxPaymentDueDate, StartDate, EndDate);            VATEntry.SetFilter("Document Date", StrSubstNo('%1..%2', StartDate, EndDate));        end;        VATEntry.SetCurrentKey("Document Date");        VATEntry.SetAscending("Document Date", true);        OnAfterSetViewOnVATEntryForTaxCalc(VATEntry, TaxPaymentDueDate, DummyDate);    end;    procedure GetTaxAmountFromSalesOrder(SalesHeader: Record "Sales Header"): Decimal    var        NewSalesLine: Record "Sales Line";        NewSalesLineLCY: Record "Sales Line";        SalesPost: Codeunit "Sales-Post";        QtyType: Option General,Invoicing,Shipping;        VATAmount: Decimal;        VATAmountText: Text[30];        ProfitLCY: Decimal;        ProfitPct: Decimal;        TotalAdjCostLCY: Decimal;        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeGetTaxAmountFromSalesOrder(SalesHeader, VATAmount, IsHandled);        if IsHandled then            exit(VATAmount);        SalesPost.SumSalesLines(          SalesHeader, QtyType::Invoicing, NewSalesLine, NewSalesLineLCY,          VATAmount, VATAmountText, ProfitLCY, ProfitPct, TotalAdjCostLCY);        exit(-1 * VATAmount);    end;    procedure GetTaxAmountFromPurchaseOrder(PurchaseHeader: Record "Purchase Header"): Decimal    var        NewPurchLine: Record "Purchase Line";        NewPurchLineLCY: Record "Purchase Line";        PurchPost: Codeunit "Purch.-Post";        QtyType: Option General,Invoicing,Shipping;        VATAmount: Decimal;        VATAmountText: Text[30];        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeGetTaxAmountFromPurchaseOrder(PurchaseHeader, VATAmount, IsHandled);        if IsHandled then            exit(VATAmount);        PurchPost.SumPurchLines(          PurchaseHeader, QtyType::Invoicing, NewPurchLine, NewPurchLineLCY, VATAmount, VATAmountText);        exit(VATAmount);    end;    procedure GetTotalAmountFromSalesOrder(SalesHeader: Record "Sales Header") Result: Decimal    begin        SalesHeader.CalcFields("Amount Including VAT");        Result := SalesHeader."Amount Including VAT";        OnAfterGetTotalAmountFromSalesOrder(SalesHeader, Result);    end;    procedure GetTotalAmountFromPurchaseOrder(PurchaseHeader: Record "Purchase Header"): Decimal    begin        PurchaseHeader.CalcFields("Amount Including VAT");        exit(PurchaseHeader."Amount Including VAT");    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeGetTaxAmountFromPurchaseOrder(PurchaseHeader: Record "Purchase Header"; var VATAmount: Decimal; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeGetTaxAmountFromSalesOrder(SalesHeader: Record "Sales Header"; var VATAmount: Decimal; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeShowSource(CFVariant: Variant; var Handled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeShowSourceDocument(CFVariant: Variant; var Handled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeUpdateCashFlowForecast(AzureAIEnabled: Boolean; var Handled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnShowSourceLocalSourceTypeCase(SourceType: Enum "Cash Flow Source Type"; SourceNo: Code[20]; ShowDocument: Boolean; DocumentNo: Code[20]; DocumentDate: Date; BudgetName: Code[10]; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterSetViewOnVATEntryForTaxCalc(var VATEntry: Record "VAT Entry"; TaxPaymentDueDate: Date; DummyDate: Date)    begin    end;    [IntegrationEvent(true, false)]    local procedure OnAfterCreateCashFlowAccounts(LiquidFundsGLAccountFilter: Code[250])    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterGetTotalAmountFromSalesOrder(SalesHeader: Record "Sales Header"; var Result: Decimal)    begin    end;    [IntegrationEvent(true, false)]    local procedure OnBeforeInsertOnCreateCashFlowSetup(var CashFlowSetup: Record "Cash Flow Setup"; CashFlowNoSeriesCode: Code[20])    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeRunSuggestWorksheetLinesOnUpdateCashFlowForecast(var SuggestWorksheetLines: Report "Suggest Worksheet Lines")    begin    end;}