Report 840 Suggest Worksheet Lines
src/Layers/W1/BaseApp/CashFlow/Worksheet/SuggestWorksheetLines.Report.al1,863 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.Worksheet;using Microsoft.Bank.Ledger;using Microsoft.CashFlow.Account;using Microsoft.CashFlow.Forecast;using Microsoft.CashFlow.Setup;using Microsoft.Finance.Currency;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.Finance.GeneralLedger.Budget;using Microsoft.Finance.GeneralLedger.Journal;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Finance.VAT.Ledger;using Microsoft.FixedAssets.Depreciation;using Microsoft.FixedAssets.FixedAsset;using Microsoft.FixedAssets.Ledger;using Microsoft.FixedAssets.Setup;using Microsoft.Projects.Project.Job;using Microsoft.Projects.Project.Planning;using Microsoft.Purchases.Document;using Microsoft.Purchases.Payables;using Microsoft.Purchases.Vendor;using Microsoft.Sales.Customer;using Microsoft.Sales.Document;using Microsoft.Sales.History;using Microsoft.Sales.Receivables;using System.AI;using System.Environment.Configuration;report 840 "Suggest Worksheet Lines"{ Caption = 'Suggest Worksheet Lines'; Permissions = TableData "Dimension Set ID Filter Line" = rimd, TableData "Cash Flow Forecast Entry" = rimd; ProcessingOnly = true; dataset { dataitem("Cash Flow Forecast"; "Cash Flow Forecast") { DataItemTableView = sorting("No.") order(ascending); dataitem("Cash Flow Account"; "Cash Flow Account") { DataItemTableView = sorting("No.") order(ascending) where("G/L Integration" = filter(Balance | Both), "G/L Account Filter" = filter(<> '')); trigger OnAfterGetRecord() var GLAcc: Record "G/L Account"; TempGLAccount: Record "G/L Account" temporary; begin GLAcc.SetFilter("No.", "G/L Account Filter"); ClearCircularRefData(); GetSubPostingGLAccounts(GLAcc, TempGLAccount); if TempGLAccount.FindSet() then repeat TempGLAccount.CalcFields(Balance); Window.Update(2, LiquidFundsTxt); Window.Update(3, TempGLAccount."No."); InsertCFLineForGLAccount(TempGLAccount); until TempGLAccount.Next() = 0; end; trigger OnPreDataItem() begin if not ConsiderSource["Cash Flow Source Type"::"Liquid Funds".AsInteger()] then CurrReport.Break(); if not ReadPermission then CurrReport.Break(); end; } dataitem("Cust. Ledger Entry"; "Cust. Ledger Entry") { DataItemTableView = sorting(Open, "Due Date") order(ascending) where(Open = const(true), "Remaining Amount" = filter(<> 0)); trigger OnAfterGetRecord() begin Window.Update(2, ReceivablesTxt); Window.Update(3, "Entry No."); if "Customer No." <> '' then Customer.Get("Customer No.") else Customer.Init(); CalcFields("Remaining Amt. (LCY)", "Remaining Amount"); InsertCFLineForCustLedgerEntry(); end; trigger OnPreDataItem() begin if not ConsiderSource["Cash Flow Source Type"::Receivables.AsInteger()] then CurrReport.Break(); if not ReadPermission then CurrReport.Break(); end; } dataitem("Vendor Ledger Entry"; "Vendor Ledger Entry") { DataItemTableView = sorting(Open, "Due Date") order(ascending) where(Open = const(true), "Remaining Amount" = filter(<> 0)); trigger OnAfterGetRecord() begin Window.Update(2, PayablesTxt); Window.Update(3, "Entry No."); if "Vendor No." <> '' then Vendor.Get("Vendor No.") else Vendor.Init(); CalcFields("Remaining Amt. (LCY)", "Remaining Amount"); InsertCFLineForVendorLedgEntry(); end; trigger OnPreDataItem() begin if not ConsiderSource["Cash Flow Source Type"::Payables.AsInteger()] then CurrReport.Break(); if not ReadPermission then CurrReport.Break(); end; } dataitem("Purchase Line"; "Purchase Line") { DataItemTableView = sorting("Document Type", "Document No.", "Line No.") order(ascending) where("Document Type" = const(Order)); trigger OnAfterGetRecord() begin Window.Update(2, PurchaseOrdersTxt); Window.Update(3, "Document No."); PurchHeader.Get("Document Type", "Document No."); if PurchHeader."Buy-from Vendor No." <> '' then Vendor.Get(PurchHeader."Pay-to Vendor No.") else Vendor.Init(); InsertCFLineForPurchaseLine(); end; trigger OnPreDataItem() begin if not ConsiderSource["Cash Flow Source Type"::"Purchase Orders".AsInteger()] then CurrReport.Break(); if not ReadPermission then CurrReport.Break(); if not ApplicationAreaMgmtFacade.IsSuiteEnabled() and not ApplicationAreaMgmtFacade.IsAllDisabled() then CurrReport.Break(); end; } dataitem("Sales Line"; "Sales Line") { DataItemTableView = sorting("Document Type", "Document No.", "Line No.") order(ascending) where("Document Type" = const(Order)); trigger OnAfterGetRecord() begin Window.Update(2, SalesOrdersTxt); Window.Update(3, "Document No."); SalesHeader.Get("Document Type", "Document No."); if SalesHeader."Sell-to Customer No." <> '' then Customer.Get(SalesHeader."Bill-to Customer No.") else Customer.Init(); InsertCFLineForSalesLine(); end; trigger OnPreDataItem() begin if not ConsiderSource["Cash Flow Source Type"::"Sales Orders".AsInteger()] then CurrReport.Break(); if not ReadPermission then CurrReport.Break(); end; } dataitem(InvestmentFixedAsset; "Fixed Asset") { DataItemTableView = sorting("No.") where("Budgeted Asset" = const(true)); trigger OnAfterGetRecord() begin if FADeprBook.Get("No.", FASetup."Default Depr. Book") then begin FADeprBook.CalcFields("Acquisition Cost"); Window.Update(2, FixedAssetsBudgetTxt); Window.Update(3, "No."); InsertCFLineForFixedAssetsBudget(); end; end; trigger OnPreDataItem() begin if not ConsiderSource["Cash Flow Source Type"::"Fixed Assets Budget".AsInteger()] then CurrReport.Break(); if not ReadPermission then CurrReport.Break(); FASetup.Get(); end; } dataitem(SaleFixedAsset; "Fixed Asset") { DataItemTableView = sorting("No.") where("Budgeted Asset" = const(false)); trigger OnAfterGetRecord() begin if FADeprBook.Get("No.", FASetup."Default Depr. Book") then if (FADeprBook."Disposal Date" = 0D) and (FADeprBook."Projected Disposal Date" <> 0D) and (FADeprBook."Projected Proceeds on Disposal" <> 0) then begin Window.Update(2, FixedAssetsDisposalTxt); Window.Update(3, "No."); InsertCFLineForFixedAssetsDisposal(); end; end; trigger OnPreDataItem() begin if not ConsiderSource["Cash Flow Source Type"::"Fixed Assets Disposal".AsInteger()] then CurrReport.Break(); if not ReadPermission then CurrReport.Break(); FASetup.Get(); end; } dataitem("Cash Flow Manual Expense"; "Cash Flow Manual Expense") { DataItemTableView = sorting(Code) order(ascending); trigger OnAfterGetRecord() begin Window.Update(2, CashFlowManualExpensesTxt); Window.Update(3, Code); InsertCFLineForManualExpense(); end; trigger OnPreDataItem() begin if not ConsiderSource["Cash Flow Source Type"::"Cash Flow Manual Expense".AsInteger()] then CurrReport.Break(); if not ReadPermission then CurrReport.Break(); end; } dataitem("Cash Flow Manual Revenue"; "Cash Flow Manual Revenue") { DataItemTableView = sorting(Code) order(ascending); trigger OnAfterGetRecord() begin Window.Update(2, CashFlowManualRevenuesTxt); Window.Update(3, Code); InsertCFLineForManualRevenue(); end; trigger OnPreDataItem() begin if not ConsiderSource["Cash Flow Source Type"::"Cash Flow Manual Revenue".AsInteger()] then CurrReport.Break(); if not ReadPermission then CurrReport.Break(); end; } dataitem(CFAccountForBudget; "Cash Flow Account") { DataItemTableView = sorting("No.") order(ascending) where("G/L Integration" = filter(Budget | Both), "G/L Account Filter" = filter(<> '')); trigger OnAfterGetRecord() var GLAcc: Record "G/L Account"; begin GLAcc.SetFilter("No.", "G/L Account Filter"); if GLAcc.FindSet() then repeat Window.Update(2, GLBudgetTxt); Window.Update(3, GLAcc."No."); GLBudgEntry.SetRange("Budget Name", GLBudgName); GLBudgEntry.SetRange("G/L Account No.", GLAcc."No."); GLBudgEntry.SetRange(Date, "Cash Flow Forecast"."G/L Budget From", "Cash Flow Forecast"."G/L Budget To"); OnCFAccountForBudgetOnAfterGetRecordOnAfterGLBudgEntrySetFilters(GLBudgEntry); if GLBudgEntry.FindSet() then repeat InsertCFLineForGLBudget(GLAcc); until GLBudgEntry.Next() = 0; until GLAcc.Next() = 0; end; trigger OnPreDataItem() begin if not ConsiderSource["Cash Flow Source Type"::"G/L Budget".AsInteger()] then CurrReport.Break(); if not ReadPermission then CurrReport.Break(); end; } dataitem("Job Planning Line"; "Job Planning Line") { DataItemTableView = sorting("Job No.", "Planning Date", "Document No."); trigger OnAfterGetRecord() begin Window.Update(2, JobsMsg); Window.Update(3, "Job No."); if not ("Line Type" in ["Line Type"::Billable, "Line Type"::"Both Budget and Billable"]) then exit; OnJobPlanningLineOnAfterGetRecordOnBeforeInsertCFLineForJobPlanningLine("Job Planning Line"); InsertCFLineForJobPlanningLine(); end; trigger OnPreDataItem() begin if not ConsiderSource["Cash Flow Source Type"::Job.AsInteger()] then CurrReport.Break(); if not ReadPermission then CurrReport.Break(); if not ApplicationAreaMgmtFacade.IsJobsEnabled() and not ApplicationAreaMgmtFacade.IsAllDisabled() then CurrReport.Break(); end; } dataitem("Purchase Header"; "Purchase Header") { DataItemTableView = sorting("Document Type", "No.") where("Document Type" = const(Order)); trigger OnAfterGetRecord() var PurchaseOrder: Page "Purchase Order"; begin Window.Update(2, PurchaseOrder.Caption); Window.Update(3, "No."); InsertCFLineForTax(DATABASE::"Purchase Header"); end; trigger OnPreDataItem() begin if not ConsiderSource["Cash Flow Source Type"::Tax.AsInteger()] then CurrReport.Break(); if not ReadPermission then CurrReport.Break(); if not ApplicationAreaMgmtFacade.IsSuiteEnabled() and not ApplicationAreaMgmtFacade.IsAllDisabled() then CurrReport.Break(); CashFlowManagement.SetViewOnPurchaseHeaderForTaxCalc("Purchase Header", DummyDate); end; } dataitem("Sales Header"; "Sales Header") { DataItemTableView = sorting("Document Type", "No.") where("Document Type" = const(Order)); trigger OnAfterGetRecord() var SalesOrder: Page "Sales Order"; begin Window.Update(2, SalesOrder.Caption); Window.Update(3, "No."); InsertCFLineForTax(DATABASE::"Sales Header"); end; trigger OnPreDataItem() begin if not ConsiderSource["Cash Flow Source Type"::Tax.AsInteger()] then CurrReport.Break(); if not ReadPermission then CurrReport.Break(); CashFlowManagement.SetViewOnSalesHeaderForTaxCalc("Sales Header", DummyDate); end; } dataitem("VAT Entry"; "VAT Entry") { trigger OnAfterGetRecord() var VATEntries: Page "VAT Entries"; begin Window.Update(2, VATEntries.Caption); Window.Update(3, "Entry No."); InsertCFLineForTax(DATABASE::"VAT Entry"); end; trigger OnPreDataItem() begin if not ConsiderSource["Cash Flow Source Type"::Tax.AsInteger()] then CurrReport.Break(); if not ReadPermission then CurrReport.Break(); CashFlowManagement.SetViewOnVATEntryForTaxCalc("VAT Entry", DummyDate); end; } dataitem("Cash Flow Azure AI Buffer"; "Cash Flow Azure AI Buffer") { trigger OnAfterGetRecord() begin InsertCFLineForAzureAIForecast(DATABASE::"Cash Flow Azure AI Buffer"); end; trigger OnPreDataItem() var CashFlowForecastHandler: Codeunit "Cash Flow Forecast Handler"; begin if not ConsiderSource["Cash Flow Source Type"::"Azure AI".AsInteger()] then CurrReport.Break(); if not ReadPermission then CurrReport.Break(); if not CashFlowForecastHandler.CalculateForecast() then CurrReport.Break(); SetRange(Type, Type::Forecast, Type::Correction); if FindSet() then; end; } trigger OnAfterGetRecord() begin Window.Update(1, "No."); end; trigger OnPostDataItem() var TempCashFlowForecast: Record "Cash Flow Forecast" temporary; begin InsertWorksheetLines(TempCashFlowForecast); DeleteEntries(TempCashFlowForecast); if NeedsManualPmtUpdate then Message(ManualPmtRevExpNeedsUpdateMsg, TempCashFlowForecast."No."); end; trigger OnPreDataItem() begin SetRange("No.", CashFlowNo); LineNo := 0; NeedsManualPmtUpdate := false; end; } } requestpage { SaveValues = true; layout { area(content) { group(Options) { Caption = 'Options'; field(CashFlowNo; CashFlowNo) { ApplicationArea = Basic, Suite; Caption = 'Cash Flow Forecast'; TableRelation = "Cash Flow Forecast"; ToolTip = 'Specifies the cash flow forecast for which you want to make the calculation.'; } group("Source Types to Include:") { Caption = 'Source Types to Include:';#pragma warning disable AA0100 field("ConsiderSource[SourceType::""Liquid Funds""]"; ConsiderSource["Cash Flow Source Type"::"Liquid Funds".AsInteger()])#pragma warning restore AA0100 { ApplicationArea = Basic, Suite; Caption = 'Liquid Funds'; ToolTip = 'Specifies if you want to transfer the balances of the general ledger accounts that are defined as liquid funds.'; } field("ConsiderSource[SourceType::Receivables]"; ConsiderSource["Cash Flow Source Type"::Receivables.AsInteger()]) { ApplicationArea = Basic, Suite; Caption = 'Receivables'; ToolTip = 'Specifies if you want to include open customer ledger entries in the cash flow forecast.'; }#pragma warning disable AA0100 field("ConsiderSource[SourceType::""Sales Order""]"; ConsiderSource["Cash Flow Source Type"::"Sales Orders".AsInteger()])#pragma warning restore AA0100 { ApplicationArea = Basic, Suite; Caption = 'Sales Orders'; ToolTip = 'Specifies if you want to include sales orders in the cash flow forecast.'; }#pragma warning disable AA0100 field("ConsiderSource[SourceType::""Sale of Fixed Asset""]"; ConsiderSource["Cash Flow Source Type"::"Fixed Assets Disposal".AsInteger()])#pragma warning restore AA0100 { ApplicationArea = FixedAssets; Caption = 'Fixed Assets Disposal'; ToolTip = 'Specifies if planned sales of fixed assets as revenues are included in the cash flow forecast.'; }#pragma warning disable AA0100 field("ConsiderSource[SourceType::""Cash Flow Manual Revenue""]"; ConsiderSource["Cash Flow Source Type"::"Cash Flow Manual Revenue".AsInteger()])#pragma warning restore AA0100 { ApplicationArea = Basic, Suite; Caption = 'Cash Flow Manual Revenues'; ToolTip = 'Specifies if manual revenues in the cash flow forecast are included.'; } field("ConsiderSource[SourceType::Payables]"; ConsiderSource["Cash Flow Source Type"::Payables.AsInteger()]) { ApplicationArea = Basic, Suite; Caption = 'Payables'; ToolTip = 'Specifies if you want to include open vendor ledger entries in the cash flow forecast.'; }#pragma warning disable AA0100 field("ConsiderSource[SourceType::""Purchase Order""]"; ConsiderSource["Cash Flow Source Type"::"Purchase Orders".AsInteger()])#pragma warning restore AA0100 { ApplicationArea = Suite; Caption = 'Purchase Orders'; ToolTip = 'Specifies if you want to include purchase orders in the cash flow forecast.'; }#pragma warning disable AA0100 field("ConsiderSource[SourceType::""Budgeted Fixed Asset""]"; ConsiderSource["Cash Flow Source Type"::"Fixed Assets Budget".AsInteger()])#pragma warning restore AA0100 { ApplicationArea = FixedAssets; Caption = 'Fixed Assets Budget'; ToolTip = 'Specifies if planned investments of fixed assets are included in the cash flow forecast.'; }#pragma warning disable AA0100 field("ConsiderSource[SourceType::""Cash Flow Manual Expense""]"; ConsiderSource["Cash Flow Source Type"::"Cash Flow Manual Expense".AsInteger()])#pragma warning restore AA0100 { ApplicationArea = Basic, Suite; Caption = 'Cash Flow Manual Expenses'; ToolTip = 'Specifies if manual expenses in the cash flow forecast are included.'; }#pragma warning disable AA0100 field("ConsiderSource[SourceType::""G/L Budget""]"; ConsiderSource["Cash Flow Source Type"::"G/L Budget".AsInteger()])#pragma warning restore AA0100 { ApplicationArea = Basic, Suite; Caption = 'G/L Budget'; ToolTip = 'Specifies if the budget entries of the marked general ledger accounts in the cash flow forecast are included.'; } field(GLBudgName; GLBudgName) { ApplicationArea = Basic, Suite; Caption = 'G/L Budget Name'; TableRelation = "G/L Budget Name"; ToolTip = 'Specifies the name of the general ledger budget if you have selected G/L budget.'; } field("ConsiderSource[SourceType::Job]"; ConsiderSource["Cash Flow Source Type"::Job.AsInteger()]) { ApplicationArea = Jobs; Caption = 'Projects'; ToolTip = 'Specifies if you want to include projects in the cash flow forecast.'; } field("ConsiderSource[SourceType::Tax]"; ConsiderSource["Cash Flow Source Type"::Tax.AsInteger()]) { ApplicationArea = Basic, Suite; Caption = 'Taxes'; ToolTip = 'Specifies if you want to include tax information in the cash flow forecast.'; }#pragma warning disable AA0100 field("ConsiderSource[SourceType::""Azure AI""]"; ConsiderSource["Cash Flow Source Type"::"Azure AI".AsInteger()])#pragma warning restore AA0100 { ApplicationArea = Basic, Suite; Caption = 'Azure AI Forecast'; ToolTip = 'Specifies whether to include Azure AI in the cash flow forecast.'; } } field(Summarized; Summarized) { ApplicationArea = Basic, Suite; Caption = 'Group by Document Type'; ToolTip = 'Specifies if the information is grouped by sales orders, purchase orders, and service orders.'; } } } } actions { } trigger OnInit() var CFManualExpense: Record "Cash Flow Manual Expense"; CFManualRevenue: Record "Cash Flow Manual Revenue"; GLBudgetEntry: Record "G/L Budget Entry"; GLAcc: Record "G/L Account"; begin if ConsiderSource["Cash Flow Source Type"::"Liquid Funds".AsInteger()] then ConsiderSource["Cash Flow Source Type"::"Liquid Funds".AsInteger()] := GLAcc.ReadPermission; if ConsiderSource["Cash Flow Source Type"::Receivables.AsInteger()] then ConsiderSource["Cash Flow Source Type"::Receivables.AsInteger()] := "Cust. Ledger Entry".ReadPermission; if ConsiderSource["Cash Flow Source Type"::Payables.AsInteger()] then ConsiderSource["Cash Flow Source Type"::Payables.AsInteger()] := "Vendor Ledger Entry".ReadPermission; if ConsiderSource["Cash Flow Source Type"::"Purchase Orders".AsInteger()] then ConsiderSource["Cash Flow Source Type"::"Purchase Orders".AsInteger()] := "Purchase Line".ReadPermission; if ConsiderSource["Cash Flow Source Type"::"Sales Orders".AsInteger()] then ConsiderSource["Cash Flow Source Type"::"Sales Orders".AsInteger()] := "Sales Line".ReadPermission; if ConsiderSource["Cash Flow Source Type"::"Cash Flow Manual Expense".AsInteger()] then ConsiderSource["Cash Flow Source Type"::"Cash Flow Manual Expense".AsInteger()] := CFManualExpense.ReadPermission; if ConsiderSource["Cash Flow Source Type"::"Cash Flow Manual Revenue".AsInteger()] then ConsiderSource["Cash Flow Source Type"::"Cash Flow Manual Revenue".AsInteger()] := CFManualRevenue.ReadPermission; if ConsiderSource["Cash Flow Source Type"::"Fixed Assets Budget".AsInteger()] then ConsiderSource["Cash Flow Source Type"::"Fixed Assets Budget".AsInteger()] := InvestmentFixedAsset.ReadPermission; if ConsiderSource["Cash Flow Source Type"::"Fixed Assets Disposal".AsInteger()] then ConsiderSource["Cash Flow Source Type"::"Fixed Assets Disposal".AsInteger()] := SaleFixedAsset.ReadPermission; if ConsiderSource["Cash Flow Source Type"::"G/L Budget".AsInteger()] then ConsiderSource["Cash Flow Source Type"::"G/L Budget".AsInteger()] := GLBudgetEntry.ReadPermission; if ConsiderSource["Cash Flow Source Type"::Job.AsInteger()] then ConsiderSource["Cash Flow Source Type"::Job.AsInteger()] := "Job Planning Line".ReadPermission; if ConsiderSource["Cash Flow Source Type"::Tax.AsInteger()] then ConsiderSource["Cash Flow Source Type"::Tax.AsInteger()] := "Sales Header".ReadPermission and "Purchase Header".ReadPermission and "VAT Entry".ReadPermission; if ConsiderSource["Cash Flow Source Type"::"Azure AI".AsInteger()] then ConsiderSource["Cash Flow Source Type"::"Azure AI".AsInteger()] := "Cash Flow Azure AI Buffer".ReadPermission; end; } labels { } trigger OnPreReport() begin if CashFlowNo = '' then Error(Text000); if not SelectionCashFlowForecast.Get(CashFlowNo) then Error(Text001); if NoOptionsChosen() then Error(Text002, CashFlowNo); CFSetup.Get(); GLSetup.Get(); Window.Open( Text003 + Text033 + Text034); Window.Update(1, "Cash Flow Forecast"."No."); end; var FASetup: Record "FA Setup"; FADeprBook: Record "FA Depreciation Book"; GLBudgEntry: Record "G/L Budget Entry"; GLSetup: Record "General Ledger Setup"; FALedgerEntry: Record "FA Ledger Entry"; ApplicationAreaMgmtFacade: Codeunit "Application Area Mgmt. Facade"; CashFlowManagement: Codeunit "Cash Flow Management"; TotalAccounts: List of [Code[20]]; TotalAccountPairs: List of [Code[50]]; LastTotalAccount: Code[20]; CashFlowNo: Code[20]; LineNo: Integer; DateLastExecution: Date; ExecutionDate: Date; GLBudgName: Code[10]; NeedsManualPmtUpdate: Boolean; DummyDate: Date; TaxLastSourceTableNumProcessed: Integer; TaxLastPayableDateProcessed: Date;#pragma warning disable AA0074 Text000: Label 'You must choose a cash flow forecast.'; Text001: Label 'Choose a valid cash flow forecast.';#pragma warning disable AA0470 Text002: Label 'Choose one option for filling the cash flow forecast no. %1.'; Text003: Label 'Cash Flow Forecast No. #1##########\\';#pragma warning restore AA0470 GLBudgetTxt: Label 'G/L Budget'; LiquidFundsTxt: Label 'Liquid Funds'; ReceivablesTxt: Label 'Receivables'; PayablesTxt: Label 'Payables'; PurchaseOrdersTxt: Label 'Purchase Orders'; SalesOrdersTxt: Label 'Sales Orders'; FixedAssetsBudgetTxt: Label 'Fixed Assets Budget'; FixedAssetsDisposalTxt: Label 'Fixed Assets Disposal'; CashFlowManualExpensesTxt: Label 'Cash Flow Manual Expenses'; CashFlowManualRevenuesTxt: Label 'Cash Flow Manual Revenues';#pragma warning disable AA0470 Text013: Label '%1 Balance=%2'; Text025: Label '%1 %2 %3'; Text027: Label '%1 AC= %2'; Text028: Label 'Cash Flow Manual Expenses %1'; Text029: Label 'Cash Flow Manual Revenues %1'; Text030: Label '%1 Budget %2 '; Text033: Label 'Search for #2####################\'; Text034: Label 'Record found #3####################';#pragma warning restore AA0470#pragma warning restore AA0074#pragma warning disable AA0470 ManualPmtRevExpNeedsUpdateMsg: Label 'There are one or more Cash Flow Manual Revenues/Expenses with a Recurring Frequency.\But the Recurring Frequency cannot be applied because the Manual Payments To date in Cash Flow Forecast %1 is empty.\Fill in this date in order to get multiple lines.';#pragma warning restore AA0470 JobsMsg: Label 'Projects'; PostedSalesDocumentDescriptionTxt: Label 'Posted Sales %1 - %2 %3', Comment = '%1 = Source Document Type (e.g. Invoice), %2 = Due Date, %3 = Source Name (e.g. Customer Name). Example: Posted Sales Invoice - 04-05-18 The Cannon Group PLC'; PostedPurchaseDocumentDescriptionTxt: Label 'Posted Purchase %1 - %2 %3', Comment = '%1 = Source Document Type (e.g. Invoice), %2 = Due Date, %3 = Source Name (e.g. Vendor Name). Example: Posted Purchase Invoice - 04-05-18 The Cannon Group PLC'; SalesDocumentDescriptionTxt: Label 'Sales %1 - %2 %3', Comment = '%1 = Source Document Type (e.g. Invoice), %2 = Due Date, %3 = Source Name (e.g. Customer Name). Example: Sales Invoice - 04-05-18 The Cannon Group PLC'; PurchaseDocumentDescriptionTxt: Label 'Purchase %1 - %2 %3', Comment = '%1 = Source Document Type (e.g. Invoice), %2 = Due Date, %3 = Source Name (e.g. Vendor Name). Example: Purchase Invoice - 04-05-18 The Cannon Group PLC'; TaxForMsg: Label 'Taxes from %1', Comment = '%1 = The description of the source tyoe based on which taxes are calculated.'; AzureAIForecastDescriptionTxt: Label 'Predicted %1 in the period starting on %2 with precision of +/- %3.', Comment = '%1 =RECEIVABLES or PAYABLES or PAYABLES TAX or RECEIVABLES TAX, %2 = Date; %3 Percentage'; AzureAIForecastTaxDescriptionTxt: Label 'Predicted tax on %1 in the period starting on %2 with precision of +/- %3.', Comment = '%1 =RECEIVABLES or PAYABLES, %2 = Date; %3 Percentage'; AzureAICorrectionDescriptionTxt: Label 'Correction due to posted %1', Comment = '%1 = SALES ORDERS or PURCHASE ORDERS'; AzureAICorrectionTaxDescriptionTxt: Label 'Correction of tax amount due to posted %1', Comment = '%1 = RECEIVABLES or PAYABLES'; AzureAIOrdersCorrectionDescriptionTxt: Label 'Correction due to %1', Comment = '%1 = SALES or PURCHASE'; AzureAIOrdersTaxCorrectionDescriptionTxt: Label 'Correction of tax amount due to %1', Comment = '%1 = SALES ORDERS or PURCHASE ORDERS'; XRECEIVABLESTxt: Label 'RECEIVABLES', Locked = true; XPAYABLESTxt: Label 'PAYABLES', Locked = true; XPAYABLESCORRECTIONTxt: Label 'Payables Correction'; XRECEIVABLESCORRECTIONTxt: Label 'Receivables Correction'; XSALESORDERSTxt: Label 'Sales Orders'; XPURCHORDERSTxt: Label 'Purchase Orders'; XTAXPAYABLESTxt: Label 'TAX TO RETURN', Locked = true; XTAXRECEIVABLESTxt: Label 'TAX TO PAY', Locked = true; XTAXPAYABLESCORRECTIONTxt: Label 'Tax from Purchase entries'; XTAXRECEIVABLESCORRECTIONTxt: Label 'Tax from Sales entries'; XTAXSALESORDERSTxt: Label 'Tax from Sales Orders'; XTAXPURCHORDERSTxt: Label 'Tax from Purchase Orders'; CircularRefsErr: Label 'There are one or more circular references where the following G/L accounts reference to each other either directly or indirectly:\ %1.\Change the value of the Totaling field in one of these accounts.', Comment = '%1 - list of accounts.'; ThreePlaceHoldersLbl: Label '%1%2%3', Locked = true, Comment = '%1%2%3 are placeholders'; protected var CFSetup: Record "Cash Flow Setup"; SelectionCashFlowForecast: Record "Cash Flow Forecast"; CFWorksheetLine2: Record "Cash Flow Worksheet Line"; TempCFWorksheetLine: Record "Cash Flow Worksheet Line" temporary; Currency: Record Currency; CurrExchRate: Record "Currency Exchange Rate"; Customer: Record Customer; Vendor: Record Vendor; PurchHeader: Record "Purchase Header"; SalesHeader: Record "Sales Header"; Window: Dialog; ConsiderSource: array[16] of Boolean; TotalAmt: Decimal; MultiSalesLines: Boolean; Summarized: Boolean; local procedure InsertConditionMet(): Boolean begin exit(TempCFWorksheetLine."Amount (LCY)" <> 0); end; procedure InsertTempCFWorksheetLine(CashFlowWorksheetLine: Record "Cash Flow Worksheet Line"; MaxPmtTolerance: Decimal) var IsHandled: Boolean; begin LineNo := LineNo + 100; TempCFWorksheetLine.TransferFields(CashFlowWorksheetLine); TempCFWorksheetLine."Cash Flow Forecast No." := "Cash Flow Forecast"."No."; TempCFWorksheetLine."Line No." := LineNo; IsHandled := false; OnInsertTempCFWorksheetLineOnBeforeCalculateCFAmountAndCFDate(TempCFWorksheetLine, IsHandled); if not IsHandled then TempCFWorksheetLine.CalculateCFAmountAndCFDate(); SetCashFlowDate(TempCFWorksheetLine, TempCFWorksheetLine."Cash Flow Date"); if Abs(TempCFWorksheetLine."Amount (LCY)") < Abs(MaxPmtTolerance) then TempCFWorksheetLine."Amount (LCY)" := 0 else TempCFWorksheetLine."Amount (LCY)" := TempCFWorksheetLine."Amount (LCY)" - MaxPmtTolerance; if InsertConditionMet() then TempCFWorksheetLine.Insert(); end; local procedure InsertWorksheetLines(var TempCashFlowForecast: Record "Cash Flow Forecast" temporary) var CFWorksheetLine: Record "Cash Flow Worksheet Line"; LastCFForecastNo: Code[20]; begin CFWorksheetLine.LockTable(); CFWorksheetLine.Reset(); CFWorksheetLine.DeleteAll(); LastCFForecastNo := ''; TempCFWorksheetLine.Reset(); TempCFWorksheetLine.SetCurrentKey("Cash Flow Forecast No."); if TempCFWorksheetLine.FindSet() then repeat CFWorksheetLine := TempCFWorksheetLine; CFWorksheetLine.Insert(true); if LastCFForecastNo <> CFWorksheetLine."Cash Flow Forecast No." then begin TempCashFlowForecast."No." := CFWorksheetLine."Cash Flow Forecast No."; TempCashFlowForecast.Insert(); LastCFForecastNo := CFWorksheetLine."Cash Flow Forecast No."; end; until TempCFWorksheetLine.Next() = 0; TempCFWorksheetLine.DeleteAll(); end; local procedure DeleteEntries(var TempCashFlowForecast: Record "Cash Flow Forecast" temporary) var CFForecastEntry: Record "Cash Flow Forecast Entry"; begin TempCashFlowForecast.Reset(); if TempCashFlowForecast.FindSet() then begin CFForecastEntry.LockTable(); CFForecastEntry.Reset(); repeat CFForecastEntry.SetRange("Cash Flow Forecast No.", TempCashFlowForecast."No."); OnDeleteEntriesOnBeforeDeleteAllCashFlowForecastEntry(CFForecastEntry, TempCashFlowForecast); CFForecastEntry.DeleteAll(); until TempCashFlowForecast.Next() = 0; end; TempCashFlowForecast.DeleteAll(); end; local procedure InsertCFLineForGLAccount(GLAcc: Record "G/L Account") begin CFWorksheetLine2.Init(); CFWorksheetLine2."Source Type" := CFWorksheetLine2."Source Type"::"Liquid Funds"; CFWorksheetLine2."Source No." := GLAcc."No."; CFWorksheetLine2."Document No." := GLAcc."No."; CFWorksheetLine2."Cash Flow Account No." := "Cash Flow Account"."No."; CFWorksheetLine2.Description := CopyStr( StrSubstNo(Text013, GLAcc.Name, Format(GLAcc.Balance)), 1, MaxStrLen(CFWorksheetLine2.Description)); SetCashFlowDate(CFWorksheetLine2, WorkDate()); CFWorksheetLine2."Amount (LCY)" := GLAcc.Balance; CFWorksheetLine2."Shortcut Dimension 2 Code" := GLAcc."Global Dimension 2 Code"; CFWorksheetLine2."Shortcut Dimension 1 Code" := GLAcc."Global Dimension 1 Code"; CFWorksheetLine2.MoveDefualtDimToJnlLineDim(DATABASE::"G/L Account", GLAcc."No.", CFWorksheetLine2."Dimension Set ID"); OnInsertCFLineForGLAccountOnBeforeInsertTempCFWorksheetLine(CFWorksheetLine2, "Cash Flow Forecast", "Cash Flow Account"); InsertTempCFWorksheetLine(CFWorksheetLine2, 0); end; local procedure InsertCFLineForCustLedgerEntry() var MaxPmtTolerance: Decimal; begin CFWorksheetLine2.Init(); CFWorksheetLine2."Source Type" := CFWorksheetLine2."Source Type"::Receivables; CFWorksheetLine2."Source No." := "Cust. Ledger Entry"."Document No."; CFWorksheetLine2."Document Type" := "Cust. Ledger Entry"."Document Type"; CFWorksheetLine2."Document Date" := "Cust. Ledger Entry"."Document Date"; CFWorksheetLine2."Shortcut Dimension 2 Code" := "Cust. Ledger Entry"."Global Dimension 2 Code"; CFWorksheetLine2."Shortcut Dimension 1 Code" := "Cust. Ledger Entry"."Global Dimension 1 Code"; CFWorksheetLine2."Dimension Set ID" := "Cust. Ledger Entry"."Dimension Set ID"; CFWorksheetLine2."Cash Flow Account No." := CFSetup."Receivables CF Account No."; CFWorksheetLine2.Description := CopyStr( StrSubstNo(PostedSalesDocumentDescriptionTxt, Format(CFWorksheetLine2."Document Type"), Format("Cust. Ledger Entry"."Due Date"), Customer.Name), 1, MaxStrLen(CFWorksheetLine2.Description)); CFWorksheetLine2."Document No." := "Cust. Ledger Entry"."Document No."; SetCashFlowDate(CFWorksheetLine2, "Cust. Ledger Entry"."Due Date"); CFWorksheetLine2."Amount (LCY)" := "Cust. Ledger Entry"."Remaining Amt. (LCY)"; CFWorksheetLine2."Pmt. Discount Date" := "Cust. Ledger Entry"."Pmt. Discount Date"; CFWorksheetLine2."Pmt. Disc. Tolerance Date" := "Cust. Ledger Entry"."Pmt. Disc. Tolerance Date"; if "Cust. Ledger Entry"."Currency Code" <> '' then Currency.Get("Cust. Ledger Entry"."Currency Code") else Currency.InitRoundingPrecision(); CFWorksheetLine2."Payment Discount" := Round("Cust. Ledger Entry"."Remaining Pmt. Disc. Possible" / "Cust. Ledger Entry"."Adjusted Currency Factor", Currency."Amount Rounding Precision"); if "Cash Flow Forecast"."Consider Pmt. Tol. Amount" then MaxPmtTolerance := Round("Cust. Ledger Entry"."Max. Payment Tolerance" / "Cust. Ledger Entry"."Adjusted Currency Factor", Currency."Amount Rounding Precision") else MaxPmtTolerance := 0; if "Cash Flow Forecast"."Consider CF Payment Terms" and (Customer."Cash Flow Payment Terms Code" <> '') then CFWorksheetLine2."Payment Terms Code" := Customer."Cash Flow Payment Terms Code" else CFWorksheetLine2."Payment Terms Code" := ''; OnInsertCFLineForCustLedgerEntryOnBeforeInsertTempCFWorksheetLine(CFWorksheetLine2, "Cash Flow Forecast", "Cust. Ledger Entry"); InsertTempCFWorksheetLine(CFWorksheetLine2, MaxPmtTolerance); end; local procedure InsertCFLineForVendorLedgEntry() var MaxPmtTolerance: Decimal; begin CFWorksheetLine2.Init(); CFWorksheetLine2."Source Type" := CFWorksheetLine2."Source Type"::Payables; CFWorksheetLine2."Source No." := "Vendor Ledger Entry"."Document No."; CFWorksheetLine2."Document Type" := "Vendor Ledger Entry"."Document Type"; CFWorksheetLine2."Document Date" := "Vendor Ledger Entry"."Document Date"; CFWorksheetLine2."Shortcut Dimension 2 Code" := "Vendor Ledger Entry"."Global Dimension 2 Code"; CFWorksheetLine2."Shortcut Dimension 1 Code" := "Vendor Ledger Entry"."Global Dimension 1 Code"; CFWorksheetLine2."Dimension Set ID" := "Vendor Ledger Entry"."Dimension Set ID"; CFWorksheetLine2."Cash Flow Account No." := CFSetup."Payables CF Account No."; CFWorksheetLine2.Description := CopyStr( StrSubstNo(PostedPurchaseDocumentDescriptionTxt, Format(CFWorksheetLine2."Document Type"), Format("Vendor Ledger Entry"."Due Date"), Vendor.Name), 1, MaxStrLen(CFWorksheetLine2.Description)); SetCashFlowDate(CFWorksheetLine2, "Vendor Ledger Entry"."Due Date"); CFWorksheetLine2."Document No." := "Vendor Ledger Entry"."Document No."; CFWorksheetLine2."Amount (LCY)" := "Vendor Ledger Entry"."Remaining Amt. (LCY)"; CFWorksheetLine2."Pmt. Discount Date" := "Vendor Ledger Entry"."Pmt. Discount Date"; CFWorksheetLine2."Pmt. Disc. Tolerance Date" := "Vendor Ledger Entry"."Pmt. Disc. Tolerance Date"; if "Vendor Ledger Entry"."Currency Code" <> '' then Currency.Get("Vendor Ledger Entry"."Currency Code") else Currency.InitRoundingPrecision(); CFWorksheetLine2."Payment Discount" := Round("Vendor Ledger Entry"."Remaining Pmt. Disc. Possible" / "Vendor Ledger Entry"."Adjusted Currency Factor", Currency."Amount Rounding Precision"); if "Cash Flow Forecast"."Consider Pmt. Tol. Amount" then MaxPmtTolerance := Round("Vendor Ledger Entry"."Max. Payment Tolerance" / "Vendor Ledger Entry"."Adjusted Currency Factor", Currency."Amount Rounding Precision") else MaxPmtTolerance := 0; if "Cash Flow Forecast"."Consider CF Payment Terms" and (Vendor."Cash Flow Payment Terms Code" <> '') then CFWorksheetLine2."Payment Terms Code" := Vendor."Cash Flow Payment Terms Code" else CFWorksheetLine2."Payment Terms Code" := ''; OnInsertCFLineForVendorLedgEntryOnBeforeInsertTempCFWorksheetLine(CFWorksheetLine2, "Cash Flow Forecast", "Vendor Ledger Entry"); InsertTempCFWorksheetLine(CFWorksheetLine2, MaxPmtTolerance); end; local procedure InsertCFLineForPurchaseLine() var PurchLine2: Record "Purchase Line"; begin PurchLine2 := "Purchase Line"; if Summarized and (PurchLine2.Next() <> 0) and (PurchLine2."Buy-from Vendor No." <> '') and (PurchLine2."Document No." = "Purchase Line"."Document No.") then begin TotalAmt += CalculateLineAmountForPurchaseLine(PurchHeader, "Purchase Line"); MultiSalesLines := true; end else begin CFWorksheetLine2.Init(); CFWorksheetLine2."Source Type" := CFWorksheetLine2."Source Type"::"Purchase Orders"; CFWorksheetLine2."Source No." := "Purchase Line"."Document No."; CFWorksheetLine2."Source Line No." := "Purchase Line"."Line No."; CFWorksheetLine2."Document Type" := CFWorksheetLine2."Document Type"::Invoice; CFWorksheetLine2."Document Date" := PurchHeader."Document Date"; CFWorksheetLine2."Shortcut Dimension 1 Code" := PurchHeader."Shortcut Dimension 1 Code"; CFWorksheetLine2."Shortcut Dimension 2 Code" := PurchHeader."Shortcut Dimension 2 Code"; CFWorksheetLine2."Dimension Set ID" := PurchHeader."Dimension Set ID"; CFWorksheetLine2."Cash Flow Account No." := CFSetup."Purch. Order CF Account No."; CFWorksheetLine2.Description := CopyStr( StrSubstNo( PurchaseDocumentDescriptionTxt, PurchHeader."Document Type", Format(PurchHeader."Order Date"), PurchHeader."Buy-from Vendor Name"), 1, MaxStrLen(CFWorksheetLine2.Description)); SetCashFlowDate(CFWorksheetLine2, PurchHeader."Due Date"); CFWorksheetLine2."Document No." := "Purchase Line"."Document No."; CFWorksheetLine2."Amount (LCY)" := CalculateLineAmountForPurchaseLine(PurchHeader, "Purchase Line"); if Summarized and MultiSalesLines then begin CFWorksheetLine2."Amount (LCY)" := CFWorksheetLine2."Amount (LCY)" + TotalAmt; MultiSalesLines := false; TotalAmt := 0; end; if "Cash Flow Forecast"."Consider CF Payment Terms" and (Vendor."Cash Flow Payment Terms Code" <> '') then CFWorksheetLine2."Payment Terms Code" := Vendor."Cash Flow Payment Terms Code" else CFWorksheetLine2."Payment Terms Code" := PurchHeader."Payment Terms Code"; OnInsertCFLineForPurchaseLineOnBeforeInsertTempCFWorksheetLine(CFWorksheetLine2, PurchHeader, "Purchase Line"); InsertTempCFWorksheetLine(CFWorksheetLine2, 0); end; end; local procedure InsertCFLineForSalesLine() var SalesLine2: Record "Sales Line"; begin SalesLine2 := "Sales Line"; if Summarized and (SalesLine2.Next() <> 0) and (SalesLine2."Sell-to Customer No." <> '') and (SalesLine2."Document No." = "Sales Line"."Document No.") then begin TotalAmt += CalculateLineAmountForSalesLine(SalesHeader, "Sales Line"); MultiSalesLines := true; end else begin CFWorksheetLine2.Init(); CFWorksheetLine2."Document Type" := CFWorksheetLine2."Document Type"::Invoice; CFWorksheetLine2."Document Date" := SalesHeader."Document Date"; CFWorksheetLine2."Source Type" := CFWorksheetLine2."Source Type"::"Sales Orders"; CFWorksheetLine2."Source No." := "Sales Line"."Document No."; CFWorksheetLine2."Source Line No." := "Sales Line"."Line No."; CFWorksheetLine2."Shortcut Dimension 1 Code" := SalesHeader."Shortcut Dimension 1 Code"; CFWorksheetLine2."Shortcut Dimension 2 Code" := SalesHeader."Shortcut Dimension 2 Code"; CFWorksheetLine2."Dimension Set ID" := SalesHeader."Dimension Set ID"; CFWorksheetLine2."Cash Flow Account No." := CFSetup."Sales Order CF Account No."; CFWorksheetLine2.Description := CopyStr( StrSubstNo( SalesDocumentDescriptionTxt, SalesHeader."Document Type", Format(SalesHeader."Order Date"), SalesHeader."Sell-to Customer Name"), 1, MaxStrLen(CFWorksheetLine2.Description)); SetCashFlowDate(CFWorksheetLine2, SalesHeader."Due Date"); CFWorksheetLine2."Document No." := "Sales Line"."Document No."; if SalesHeader."Prepayment %" = 100 then CFWorksheetLine2."Amount (LCY)" := GetSalesOrderPrepaymentAmt("Sales Line") else CFWorksheetLine2."Amount (LCY)" := CalculateLineAmountForSalesLine(SalesHeader, "Sales Line"); if Summarized and MultiSalesLines then begin CFWorksheetLine2."Amount (LCY)" := CFWorksheetLine2."Amount (LCY)" + TotalAmt; MultiSalesLines := false; TotalAmt := 0; end; if "Cash Flow Forecast"."Consider CF Payment Terms" and (Customer."Cash Flow Payment Terms Code" <> '') then CFWorksheetLine2."Payment Terms Code" := Customer."Cash Flow Payment Terms Code" else CFWorksheetLine2."Payment Terms Code" := SalesHeader."Payment Terms Code"; OnInsertCFLineForSalesLineOnBeforeInsertTempCFWorksheetLine(CFWorksheetLine2, "Cash Flow Forecast", "Sales Line"); InsertTempCFWorksheetLine(CFWorksheetLine2, 0); end; end; local procedure InsertCFLineForFixedAssetsBudget() begin SetFALedgerEntryFilters(); if FALedgerEntry.FindSet() then repeat InitCFLineForFixedAssetsBudget(); CFWorksheetLine2.MoveDefualtDimToJnlLineDim(DATABASE::"Fixed Asset", InvestmentFixedAsset."No.", CFWorksheetLine2."Dimension Set ID"); InsertTempCFWorksheetLine(CFWorksheetLine2, 0); until FALedgerEntry.Next() = 0; end; local procedure SetFALedgerEntryFilters() begin FALedgerEntry.Reset(); FALedgerEntry.SetRange("FA No.", FADeprBook."FA No."); FALedgerEntry.SetRange("Depreciation Book Code", FADeprBook."Depreciation Book Code"); FALedgerEntry.SetRange("FA Posting Category", FALedgerEntry."FA Posting Category"::" "); FALedgerEntry.SetRange("FA Posting Type", FALedgerEntry."FA Posting Type"::"Acquisition Cost"); end; local procedure InitCFLineForFixedAssetsBudget() begin CFWorksheetLine2.Init(); CFWorksheetLine2."Source Type" := CFWorksheetLine2."Source Type"::"Fixed Assets Budget"; CFWorksheetLine2."Source No." := InvestmentFixedAsset."No."; CFWorksheetLine2."Document No." := InvestmentFixedAsset."No."; CFWorksheetLine2."Cash Flow Account No." := CFSetup."FA Budget CF Account No."; CFWorksheetLine2.Description := CopyStr( StrSubstNo( Text027, InvestmentFixedAsset."No.", Format(-FALedgerEntry.Amount)), 1, MaxStrLen(CFWorksheetLine2.Description)); SetCashFlowDate(CFWorksheetLine2, FALedgerEntry."Posting Date"); CFWorksheetLine2."Amount (LCY)" := -FALedgerEntry.Amount; CFWorksheetLine2."Shortcut Dimension 2 Code" := InvestmentFixedAsset."Global Dimension 2 Code"; CFWorksheetLine2."Shortcut Dimension 1 Code" := InvestmentFixedAsset."Global Dimension 1 Code"; OnAfterInitCFLineForFixedAssetsBudget(CFWorksheetLine2, FADeprBook, InvestmentFixedAsset); end; local procedure InsertCFLineForFixedAssetsDisposal() begin CFWorksheetLine2.Init(); CFWorksheetLine2."Source Type" := CFWorksheetLine2."Source Type"::"Fixed Assets Disposal"; CFWorksheetLine2."Source No." := SaleFixedAsset."No."; CFWorksheetLine2."Document No." := SaleFixedAsset."No."; CFWorksheetLine2."Cash Flow Account No." := CFSetup."FA Disposal CF Account No."; CFWorksheetLine2.Description := CopyStr( StrSubstNo( Text027, SaleFixedAsset."No.", Format(FADeprBook."Projected Proceeds on Disposal")), 1, MaxStrLen(CFWorksheetLine2.Description)); SetCashFlowDate(CFWorksheetLine2, FADeprBook."Projected Disposal Date"); CFWorksheetLine2."Amount (LCY)" := FADeprBook."Projected Proceeds on Disposal"; CFWorksheetLine2."Shortcut Dimension 2 Code" := SaleFixedAsset."Global Dimension 2 Code"; CFWorksheetLine2."Shortcut Dimension 1 Code" := SaleFixedAsset."Global Dimension 1 Code"; CFWorksheetLine2.MoveDefualtDimToJnlLineDim(DATABASE::"Fixed Asset", SaleFixedAsset."No.", CFWorksheetLine2."Dimension Set ID"); OnInsertCFLineForFixedAssetsDisposalOnBeforeInsertTempCFWorksheetLine(CFWorksheetLine2, "Cash Flow Forecast", SaleFixedAsset); InsertTempCFWorksheetLine(CFWorksheetLine2, 0); end; local procedure InsertCFLineForManualExpense() begin "Cash Flow Manual Expense".TestField("Starting Date"); CFWorksheetLine2.Init(); CFWorksheetLine2."Source Type" := CFWorksheetLine2."Source Type"::"Cash Flow Manual Expense"; CFWorksheetLine2."Source No." := "Cash Flow Manual Expense".Code; CFWorksheetLine2."Document No." := "Cash Flow Manual Expense".Code; CFWorksheetLine2."Cash Flow Account No." := "Cash Flow Manual Expense"."Cash Flow Account No."; CFWorksheetLine2."Shortcut Dimension 1 Code" := "Cash Flow Manual Expense"."Global Dimension 1 Code"; CFWorksheetLine2."Shortcut Dimension 2 Code" := "Cash Flow Manual Expense"."Global Dimension 2 Code"; CFWorksheetLine2.MoveDefualtDimToJnlLineDim(DATABASE::"Cash Flow Manual Expense", "Cash Flow Manual Expense".Code, CFWorksheetLine2."Dimension Set ID"); CFWorksheetLine2.Description := CopyStr(StrSubstNo(Text028, "Cash Flow Manual Expense".Description), 1, MaxStrLen(CFWorksheetLine2.Description)); DateLastExecution := "Cash Flow Forecast"."Manual Payments To"; if ("Cash Flow Manual Expense"."Ending Date" <> 0D) and ("Cash Flow Manual Expense"."Ending Date" < "Cash Flow Forecast"."Manual Payments To") then DateLastExecution := "Cash Flow Manual Expense"."Ending Date"; ExecutionDate := "Cash Flow Manual Expense"."Starting Date"; OnInsertCFLineForManualExpenseOnBeforeInsertManualData(CFWorksheetLine2, "Cash Flow Forecast", "Cash Flow Manual Expense"); if Format("Cash Flow Manual Expense"."Recurring Frequency") <> '' then begin if DateLastExecution = 0D then begin NeedsManualPmtUpdate := true; InsertManualData( ExecutionDate, "Cash Flow Forecast", -"Cash Flow Manual Expense".Amount); end else while ExecutionDate <= DateLastExecution do begin InsertManualData( ExecutionDate, "Cash Flow Forecast", -"Cash Flow Manual Expense".Amount); ExecutionDate := CalcDate("Cash Flow Manual Expense"."Recurring Frequency", ExecutionDate); end; end else InsertManualData(ExecutionDate, "Cash Flow Forecast", -"Cash Flow Manual Expense".Amount); end; local procedure InsertCFLineForManualRevenue() begin "Cash Flow Manual Revenue".TestField("Starting Date"); CFWorksheetLine2.Init(); CFWorksheetLine2."Source Type" := CFWorksheetLine2."Source Type"::"Cash Flow Manual Revenue"; CFWorksheetLine2."Source No." := "Cash Flow Manual Revenue".Code; CFWorksheetLine2."Document No." := "Cash Flow Manual Revenue".Code; CFWorksheetLine2."Cash Flow Account No." := "Cash Flow Manual Revenue"."Cash Flow Account No."; CFWorksheetLine2."Shortcut Dimension 1 Code" := "Cash Flow Manual Revenue"."Global Dimension 1 Code"; CFWorksheetLine2."Shortcut Dimension 2 Code" := "Cash Flow Manual Revenue"."Global Dimension 2 Code"; CFWorksheetLine2.MoveDefualtDimToJnlLineDim(DATABASE::"Cash Flow Manual Revenue", "Cash Flow Manual Revenue".Code, CFWorksheetLine2."Dimension Set ID"); CFWorksheetLine2.Description := CopyStr(StrSubstNo(Text029, "Cash Flow Manual Revenue".Description), 1, MaxStrLen(CFWorksheetLine2.Description)); DateLastExecution := "Cash Flow Forecast"."Manual Payments To"; if ("Cash Flow Manual Revenue"."Ending Date" <> 0D) and ("Cash Flow Manual Revenue"."Ending Date" < "Cash Flow Forecast"."Manual Payments To") then DateLastExecution := "Cash Flow Manual Revenue"."Ending Date"; ExecutionDate := "Cash Flow Manual Revenue"."Starting Date"; OnInsertCFLineForManualRevenueOnBeforeInsertManualData(CFWorksheetLine2, "Cash Flow Forecast", "Cash Flow Manual Revenue"); if Format("Cash Flow Manual Revenue"."Recurring Frequency") <> '' then begin if DateLastExecution = 0D then begin NeedsManualPmtUpdate := true; InsertManualData( ExecutionDate, "Cash Flow Forecast", "Cash Flow Manual Revenue".Amount); end else while ExecutionDate <= DateLastExecution do begin InsertManualData( ExecutionDate, "Cash Flow Forecast", "Cash Flow Manual Revenue".Amount); ExecutionDate := CalcDate("Cash Flow Manual Revenue"."Recurring Frequency", ExecutionDate); end; end else InsertManualData(ExecutionDate, "Cash Flow Forecast", "Cash Flow Manual Revenue".Amount); end; local procedure InsertCFLineForGLBudget(GLAcc: Record "G/L Account") begin CFWorksheetLine2.Init(); CFWorksheetLine2."Source Type" := CFWorksheetLine2."Source Type"::"G/L Budget"; CFWorksheetLine2."Source No." := GLAcc."No."; CFWorksheetLine2."G/L Budget Name" := GLBudgEntry."Budget Name"; CFWorksheetLine2."Document No." := Format(GLBudgEntry."Entry No."); CFWorksheetLine2."Cash Flow Account No." := CFAccountForBudget."No."; CFWorksheetLine2.Description := CopyStr( StrSubstNo( Text030, GLAcc.Name, Format(GLBudgEntry.Description)), 1, MaxStrLen(CFWorksheetLine2.Description)); SetCashFlowDate(CFWorksheetLine2, GLBudgEntry.Date); CFWorksheetLine2."Amount (LCY)" := -GLBudgEntry.Amount; CFWorksheetLine2."Shortcut Dimension 1 Code" := GLBudgEntry."Global Dimension 1 Code"; CFWorksheetLine2."Shortcut Dimension 2 Code" := GLBudgEntry."Global Dimension 2 Code"; CFWorksheetLine2."Dimension Set ID" := GLBudgEntry."Dimension Set ID"; InsertTempCFWorksheetLine(CFWorksheetLine2, 0); end; local procedure InsertCFLineForJobPlanningLine() var Job: Record Job; InsertConditionHasBeenMetAlready: Boolean; begin if (TempCFWorksheetLine."Source Type" = TempCFWorksheetLine."Source Type"::Job) and ("Job Planning Line"."Job No." = TempCFWorksheetLine."Source No.") and ("Job Planning Line"."Planning Date" = TempCFWorksheetLine."Document Date") and ("Job Planning Line"."Document No." = TempCFWorksheetLine."Document No.") then begin InsertConditionHasBeenMetAlready := InsertConditionMet(); TempCFWorksheetLine."Amount (LCY)" += GetJobPlanningAmountForCFLine("Job Planning Line"); InsertOrModifyCFLine(InsertConditionHasBeenMetAlready); end else begin CFWorksheetLine2.Init(); CFWorksheetLine2."Source Type" := CFWorksheetLine2."Source Type"::Job; CFWorksheetLine2."Source No." := "Job Planning Line"."Job No."; CFWorksheetLine2."Document Type" := CFWorksheetLine2."Document Type"::Invoice; CFWorksheetLine2."Document Date" := "Job Planning Line"."Planning Date"; Job.Get("Job Planning Line"."Job No."); CFWorksheetLine2."Shortcut Dimension 1 Code" := Job."Global Dimension 1 Code"; CFWorksheetLine2."Shortcut Dimension 2 Code" := Job."Global Dimension 2 Code"; CheckCashFlowAccountNo(CFSetup."Job CF Account No."); CFWorksheetLine2."Cash Flow Account No." := CFSetup."Job CF Account No."; CFWorksheetLine2.Description := CopyStr( StrSubstNo( Text025, Job.TableCaption(), Job.Description, Format("Job Planning Line"."Document Date")), 1, MaxStrLen(CFWorksheetLine2.Description)); if "Job Planning Line"."Planning Due Date" = 0D then if "Job Planning Line".UpdatePlannedDueDate() then "Job Planning Line".Modify(); SetCashFlowDate(CFWorksheetLine2, "Job Planning Line"."Planning Due Date"); CFWorksheetLine2."Document No." := "Job Planning Line"."Document No."; CFWorksheetLine2."Amount (LCY)" := GetJobPlanningAmountForCFLine("Job Planning Line"); OnInsertCFLineForJobPlanningLineOnBeforeInsertTempCFWorksheetLine(CFWorksheetLine2, Job, "Cash Flow Forecast", "Job Planning Line"); InsertTempCFWorksheetLine(CFWorksheetLine2, 0); end; end; procedure InsertCFLineForTax(SourceTableNum: Integer) var TaxPayableDate: Date; SourceNo: Code[20]; InsertConditionHasBeenMetAlready: Boolean; begin TaxPayableDate := GetTaxPayableDateFromSource(SourceTableNum); if IsDateBeforeStartOfCurrentPeriod(TaxPayableDate) or HasTaxBeenPaidOn(TaxPayableDate) then exit; SourceNo := Format(SourceTableNum); if Summarized and (TaxLastSourceTableNumProcessed <> SourceTableNum) and (TaxLastPayableDateProcessed <> TaxPayableDate) then begin TotalAmt += GetTaxAmountFromSource(SourceTableNum); MultiSalesLines := true; end else if (TempCFWorksheetLine."Source Type" = TempCFWorksheetLine."Source Type"::Tax) and (TempCFWorksheetLine."Source No." = SourceNo) and (TempCFWorksheetLine."Document Date" = TaxPayableDate) then begin InsertConditionHasBeenMetAlready := InsertConditionMet(); TempCFWorksheetLine."Amount (LCY)" += GetTaxAmountFromSource(SourceTableNum); InsertOrModifyCFLine(InsertConditionHasBeenMetAlready); end else begin CFWorksheetLine2.Init(); CFWorksheetLine2."Source Type" := CFWorksheetLine2."Source Type"::Tax; CFWorksheetLine2."Source No." := SourceNo; CFWorksheetLine2."Document Type" := CFWorksheetLine2."Document Type"::" "; CFWorksheetLine2."Document Date" := TaxPayableDate; CFWorksheetLine2."Shortcut Dimension 1 Code" := ''; CFWorksheetLine2."Shortcut Dimension 2 Code" := ''; CFWorksheetLine2."Cash Flow Account No." := CFSetup."Tax CF Account No."; CFWorksheetLine2.Description := GetDescriptionForTaxCashFlowLine(SourceTableNum); SetCashFlowDate(CFWorksheetLine2, CFWorksheetLine2."Document Date"); CFWorksheetLine2."Document No." := ''; CFWorksheetLine2."Amount (LCY)" := GetTaxAmountFromSource(SourceTableNum); if Summarized and MultiSalesLines and (TaxLastSourceTableNumProcessed = SourceTableNum) then begin CFWorksheetLine2."Amount (LCY)" := CFWorksheetLine2."Amount (LCY)" + TotalAmt; MultiSalesLines := false; TotalAmt := 0; end; InsertTempCFWorksheetLine(CFWorksheetLine2, 0); end; TaxLastSourceTableNumProcessed := SourceTableNum; TaxLastPayableDateProcessed := TaxPayableDate; end; local procedure InsertCFLineForAzureAIForecast(SourceTableNum: Integer) begin if "Cash Flow Azure AI Buffer"."Delta %" > CFSetup."Variance %" then exit; CFWorksheetLine2.Init(); CFWorksheetLine2."Source Type" := CFWorksheetLine2."Source Type"::"Azure AI"; CFWorksheetLine2."Source No." := Format(SourceTableNum); CFWorksheetLine2."Document Type" := CFWorksheetLine2."Document Type"::" "; CFWorksheetLine2."Document Date" := "Cash Flow Azure AI Buffer"."Period Start"; SetCashFlowDate(CFWorksheetLine2, CFWorksheetLine2."Document Date"); CFWorksheetLine2."Amount (LCY)" := "Cash Flow Azure AI Buffer".Amount; case "Cash Flow Azure AI Buffer"."Group Id" of XRECEIVABLESTxt: begin CFWorksheetLine2."Cash Flow Account No." := CFSetup."Receivables CF Account No."; CFWorksheetLine2.Description := StrSubstNo( AzureAIForecastDescriptionTxt, LowerCase(XRECEIVABLESTxt), "Cash Flow Azure AI Buffer"."Period Start", Round("Cash Flow Azure AI Buffer".Delta)); end; XPAYABLESTxt: begin CFWorksheetLine2."Cash Flow Account No." := CFSetup."Payables CF Account No."; CFWorksheetLine2.Description := StrSubstNo( AzureAIForecastDescriptionTxt, LowerCase(XPAYABLESTxt), "Cash Flow Azure AI Buffer"."Period Start", Round("Cash Flow Azure AI Buffer".Delta)); end; XPAYABLESCORRECTIONTxt: if ConsiderSource[CFWorksheetLine2."Source Type"::Payables.AsInteger()] then begin CFWorksheetLine2."Cash Flow Account No." := CFSetup."Payables CF Account No."; CFWorksheetLine2.Description := StrSubstNo(AzureAICorrectionDescriptionTxt, LowerCase(XPAYABLESTxt)); end else exit; XRECEIVABLESCORRECTIONTxt: if ConsiderSource[CFWorksheetLine2."Source Type"::Receivables.AsInteger()] then begin CFWorksheetLine2."Cash Flow Account No." := CFSetup."Receivables CF Account No."; CFWorksheetLine2.Description := StrSubstNo(AzureAICorrectionDescriptionTxt, LowerCase(XRECEIVABLESTxt)) end else exit; XPURCHORDERSTxt: if ConsiderSource[CFWorksheetLine2."Source Type"::"Purchase Orders".AsInteger()] then begin CFWorksheetLine2."Cash Flow Account No." := CFSetup."Purch. Order CF Account No."; CFWorksheetLine2.Description := StrSubstNo(AzureAIOrdersCorrectionDescriptionTxt, LowerCase(XPURCHORDERSTxt)) end else exit; XSALESORDERSTxt: if ConsiderSource[CFWorksheetLine2."Source Type"::"Sales Orders".AsInteger()] then begin CFWorksheetLine2."Cash Flow Account No." := CFSetup."Sales Order CF Account No."; CFWorksheetLine2.Description := StrSubstNo(AzureAIOrdersCorrectionDescriptionTxt, LowerCase(XSALESORDERSTxt)) end else exit; XTAXRECEIVABLESTxt: if ConsiderSource[CFWorksheetLine2."Source Type"::Tax.AsInteger()] then begin CFWorksheetLine2."Cash Flow Account No." := CFSetup."Tax CF Account No."; CFWorksheetLine2.Description := StrSubstNo( AzureAIForecastTaxDescriptionTxt, LowerCase(XRECEIVABLESTxt), "Cash Flow Azure AI Buffer"."Period Start", Round("Cash Flow Azure AI Buffer".Delta)) end else exit; XTAXPAYABLESTxt: if ConsiderSource[CFWorksheetLine2."Source Type"::Tax.AsInteger()] then begin CFWorksheetLine2."Cash Flow Account No." := CFSetup."Tax CF Account No."; CFWorksheetLine2.Description := StrSubstNo( AzureAIForecastTaxDescriptionTxt, LowerCase(XPAYABLESTxt), "Cash Flow Azure AI Buffer"."Period Start", Round("Cash Flow Azure AI Buffer".Delta)); end else exit; XTAXPAYABLESCORRECTIONTxt: if ConsiderSource[CFWorksheetLine2."Source Type"::Tax.AsInteger()] then begin CFWorksheetLine2."Cash Flow Account No." := CFSetup."Tax CF Account No."; CFWorksheetLine2.Description := StrSubstNo(AzureAICorrectionTaxDescriptionTxt, LowerCase(XPAYABLESTxt)); end else exit; XTAXRECEIVABLESCORRECTIONTxt: if ConsiderSource[CFWorksheetLine2."Source Type"::Tax.AsInteger()] then begin CFWorksheetLine2."Cash Flow Account No." := CFSetup."Tax CF Account No."; CFWorksheetLine2.Description := StrSubstNo(AzureAICorrectionTaxDescriptionTxt, LowerCase(XRECEIVABLESTxt)) end else exit; XTAXPURCHORDERSTxt: if ConsiderSource[CFWorksheetLine2."Source Type"::Tax.AsInteger()] then begin CFWorksheetLine2."Cash Flow Account No." := CFSetup."Tax CF Account No."; CFWorksheetLine2.Description := StrSubstNo(AzureAIOrdersTaxCorrectionDescriptionTxt, LowerCase(XPURCHORDERSTxt)) end else exit; XTAXSALESORDERSTxt: if ConsiderSource[CFWorksheetLine2."Source Type"::Tax.AsInteger()] then begin CFWorksheetLine2."Cash Flow Account No." := CFSetup."Tax CF Account No."; CFWorksheetLine2.Description := StrSubstNo(AzureAIOrdersTaxCorrectionDescriptionTxt, LowerCase(XSALESORDERSTxt)) end else exit; end; InsertTempCFWorksheetLine(CFWorksheetLine2, 0); end; local procedure InsertOrModifyCFLine(InsertConditionHasBeenMetAlready: Boolean) begin CFWorksheetLine2."Amount (LCY)" := TempCFWorksheetLine."Amount (LCY)"; if InsertConditionHasBeenMetAlready then TempCFWorksheetLine.Modify() else InsertTempCFWorksheetLine(CFWorksheetLine2, 0); end; procedure GetSubPostingGLAccounts(var GLAccount: Record "G/L Account"; var TempGLAccount: Record "G/L Account" temporary) var SubGLAccount: Record "G/L Account"; begin if not GLAccount.FindSet() then exit; repeat case GLAccount."Account Type" of GLAccount."Account Type"::Posting: begin TempGLAccount.Init(); TempGLAccount.TransferFields(GLAccount); if TempGLAccount.Insert() then; end; GLAccount."Account Type"::"End-Total", GLAccount."Account Type"::Total: begin CheckCircularRefs(GLAccount); SubGLAccount.SetFilter("No.", GLAccount.Totaling); SubGLAccount.FilterGroup := 2; SubGLAccount.SetFilter("No.", '<>%1', GLAccount."No."); SubGLAccount.FilterGroup := 0; GetSubPostingGLAccounts(SubGLAccount, TempGLAccount); end; end; until GLAccount.Next() = 0; end; procedure SetCashFlowDate(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line"; CashFlowDate: Date) var IsHandled: Boolean; begin IsHandled := false; OnBeforeSetCashFlowDate(CashFlowWorksheetLine, IsHandled, SelectionCashFlowForecast); if IsHandled then exit; CashFlowWorksheetLine."Cash Flow Date" := CashFlowDate; if CashFlowDate < WorkDate() then begin if SelectionCashFlowForecast."Overdue CF Dates to Work Date" then CashFlowWorksheetLine."Cash Flow Date" := WorkDate(); CashFlowWorksheetLine.Overdue := true; end end; local procedure CalculateLineAmountForPurchaseLine(PurchHeader2: Record "Purchase Header"; PurchaseLine: Record "Purchase Line"): Decimal var PrepmtAmtInvLCY: Decimal; PurchaseAmount: Decimal; begin PurchaseAmount := GetPurchaseAmountForCFLine(PurchaseLine); if PurchaseAmount = 0 then exit(0); if PurchHeader2."Currency Code" <> '' then begin Currency.Get(PurchHeader2."Currency Code"); PrepmtAmtInvLCY := Round( CurrExchRate.ExchangeAmtFCYToLCY( PurchHeader2."Posting Date", PurchHeader2."Currency Code", PurchaseLine."Prepmt. Amt. Inv.", PurchHeader2."Currency Factor"), Currency."Amount Rounding Precision"); end else PrepmtAmtInvLCY := PurchaseLine."Prepmt. Amt. Inv."; Currency.InitRoundingPrecision(); if PurchHeader2."Prices Including VAT" then exit(-(PurchaseAmount - PrepmtAmtInvLCY)); exit( -(PurchaseAmount - (PrepmtAmtInvLCY + Round(PrepmtAmtInvLCY * PurchaseLine."VAT %" / 100, Currency."Amount Rounding Precision", Currency.VATRoundingDirection())))); end; local procedure CalculateLineAmountForSalesLine(SalesHeader2: Record "Sales Header"; SalesLine: Record "Sales Line"): Decimal var PrepmtAmtInvLCY: Decimal; SalesAmount: Decimal; begin SalesAmount := GetSalesAmountForCFLine(SalesLine); if SalesAmount = 0 then exit(0); if SalesHeader2."Currency Code" <> '' then begin Currency.Get(SalesHeader2."Currency Code"); PrepmtAmtInvLCY := Round( CurrExchRate.ExchangeAmtFCYToLCY( SalesHeader2."Posting Date", SalesHeader2."Currency Code", SalesLine."Prepmt. Amt. Inv.", SalesHeader2."Currency Factor"), Currency."Amount Rounding Precision"); end else PrepmtAmtInvLCY := SalesLine."Prepmt. Amt. Inv."; Currency.InitRoundingPrecision(); if SalesHeader2."Prices Including VAT" then exit(SalesAmount - PrepmtAmtInvLCY); exit( SalesAmount - (PrepmtAmtInvLCY + Round(PrepmtAmtInvLCY * SalesLine."VAT %" / 100, Currency."Amount Rounding Precision", Currency.VATRoundingDirection()))); end; local procedure NoOptionsChosen() Result: Boolean var SourceType: Integer; IsHandled: Boolean; begin IsHandled := false; OnBeforeNoOptionsChosen(Result, IsHandled); if IsHandled then exit(Result); for SourceType := 1 to ArrayLen(ConsiderSource) do if ConsiderSource[SourceType] then exit(false); exit(true); end; procedure InitializeRequest(NewConsiderSource: array[16] of Boolean; CFNo: Code[20]; NewGLBudgetName: Code[10]; GroupByDocumentType: Boolean) begin CopyArray(ConsiderSource, NewConsiderSource, 1); CashFlowNo := CFNo; GLBudgName := NewGLBudgetName; Summarized := GroupByDocumentType; OnAfterInitializeRequest(ConsiderSource, CashFlowNo, GLBudgName, Summarized) end; local procedure InsertManualData(ExecutionDate: Date; CashFlowForecast: Record "Cash Flow Forecast"; ManualAmount: Decimal) begin if ((CashFlowForecast."Manual Payments From" <> 0D) and (ExecutionDate < CashFlowForecast."Manual Payments From")) or ((CashFlowForecast."Manual Payments To" <> 0D) and (ExecutionDate > CashFlowForecast."Manual Payments To")) then exit; SetCashFlowDate(CFWorksheetLine2, ExecutionDate); CFWorksheetLine2."Amount (LCY)" := ManualAmount; InsertTempCFWorksheetLine(CFWorksheetLine2, 0); end; local procedure GetPurchaseAmountForCFLine(PurchaseLine: Record "Purchase Line"): Decimal begin exit(PurchaseLine."Outstanding Amount (LCY)" + PurchaseLine."Amt. Rcd. Not Invoiced (LCY)"); end; local procedure GetSalesAmountForCFLine(SalesLine: Record "Sales Line"): Decimal begin exit(SalesLine."Outstanding Amount (LCY)" + SalesLine."Shipped Not Invoiced (LCY)"); end; local procedure GetJobPlanningAmountForCFLine(JobPlanningLine: Record "Job Planning Line"): Decimal begin JobPlanningLine.CalcFields("Invoiced Amount (LCY)"); exit(JobPlanningLine."Line Amount (LCY)" - JobPlanningLine."Invoiced Amount (LCY)"); end; local procedure GetTaxPayableDateFromSource(SourceTableNum: Integer): Date var CashFlowSetup: Record "Cash Flow Setup"; DocumentDate: Date; begin case SourceTableNum of DATABASE::"Sales Header": DocumentDate := "Sales Header"."Document Date"; DATABASE::"Purchase Header": DocumentDate := "Purchase Header"."Document Date"; DATABASE::"VAT Entry": DocumentDate := "VAT Entry"."Document Date"; end; OnGetTaxPayableDateFromSourceOnBeforeExit(SourceTableNum, "Sales Header", "Purchase Header", "VAT Entry", DocumentDate); exit(CashFlowSetup.GetTaxPaymentDueDate(DocumentDate)); end; local procedure HasTaxBeenPaidOn(PaymentDate: Date): Boolean var CashFlowSetup: Record "Cash Flow Setup"; BankAccountLedgerEntry: Record "Bank Account Ledger Entry"; TaxPaymentStartDate: Date; BalanceAccountType: Enum "Gen. Journal Account Type"; begin TaxPaymentStartDate := CashFlowSetup.GetTaxPaymentStartDate(PaymentDate); case CashFlowSetup."Tax Bal. Account Type" of CashFlowSetup."Tax Bal. Account Type"::" ": exit(false); CashFlowSetup."Tax Bal. Account Type"::Vendor: BalanceAccountType := BankAccountLedgerEntry."Bal. Account Type"::Vendor; CashFlowSetup."Tax Bal. Account Type"::"G/L Account": BalanceAccountType := BankAccountLedgerEntry."Bal. Account Type"::"G/L Account"; end; BankAccountLedgerEntry.SetRange("Bal. Account Type", BalanceAccountType); BankAccountLedgerEntry.SetFilter("Posting Date", '%1..%2', TaxPaymentStartDate, PaymentDate); BankAccountLedgerEntry.SetRange("Bal. Account No.", CashFlowSetup."Tax Bal. Account No."); exit(not BankAccountLedgerEntry.IsEmpty); end; local procedure GetDescriptionForTaxCashFlowLine(SourceTableNum: Integer): Text[250] var PurchaseOrders: Page "Purchase Orders"; SalesOrders: Page "Sales Orders"; VATEntries: Page "VAT Entries"; begin case SourceTableNum of DATABASE::"Purchase Header": exit(StrSubstNo(TaxForMsg, PurchaseOrders.Caption)); DATABASE::"Sales Header": exit(StrSubstNo(TaxForMsg, SalesOrders.Caption)); DATABASE::"VAT Entry": exit(StrSubstNo(TaxForMsg, VATEntries.Caption)); end; end; local procedure GetTaxAmountFromSource(SourceTableNum: Integer): Decimal var CashFlowManagement: Codeunit "Cash Flow Management"; TaxAmount: Decimal; begin case SourceTableNum of DATABASE::"Sales Header": TaxAmount := CashFlowManagement.GetTaxAmountFromSalesOrder("Sales Header"); DATABASE::"Purchase Header": TaxAmount := CashFlowManagement.GetTaxAmountFromPurchaseOrder("Purchase Header"); DATABASE::"VAT Entry": TaxAmount := "VAT Entry".Amount; end; OnAfterGetTaxAmountFromSource(SourceTableNum, "Sales Header", "Purchase Header", "VAT Entry", TaxAmount); exit(TaxAmount); end; local procedure IsDateBeforeStartOfCurrentPeriod(Date: Date): Boolean var CashFlowSetup: Record "Cash Flow Setup"; begin exit(Date < CashFlowSetup.GetCurrentPeriodStartDate()); end; local procedure CheckCircularRefs(var GLAccount: Record "G/L Account") var AccountPair: Code[50]; RecursiveLimit: Integer; begin RecursiveLimit := GetRecursiveLimit(); AccountPair := StrSubstNo(ThreePlaceHoldersLbl, LastTotalAccount, '|', GLAccount."No."); TotalAccountPairs.Add(AccountPair); TotalAccounts.Add(GLAccount."No."); LastTotalAccount := GLAccount."No."; if TotalAccountPairs.Contains(AccountPair) then if CountRepeatedElement(AccountPair) >= RecursiveLimit then Error(CircularRefsErr, GetCircularRefErrorMessage(AccountPair)); end; procedure ClearCircularRefData() begin Clear(TotalAccounts); Clear(TotalAccountPairs); LastTotalAccount := ''; end; local procedure CountRepeatedElement(AccountPair: Code[50]) Result: Integer var Index: Integer; begin for Index := TotalAccountPairs.IndexOf(AccountPair) to TotalAccountPairs.LastIndexOf(AccountPair) do if TotalAccountPairs.Get(Index) = AccountPair then Result += 1; end; local procedure GetRecursiveLimit() Limit: Integer begin Limit := 3; OnAfterGetRecursiveLimit(Limit); end; local procedure GetCircularRefErrorMessage(AccountPair: Code[50]) CircularRefs: Text; var Index: Integer; StartIndex: Integer; EndIndex: Integer; SeparatorChar: Text[1]; begin EndIndex := TotalAccountPairs.Count(); TotalAccountPairs.RemoveAt(EndIndex); EndIndex -= 1; StartIndex := TotalAccountPairs.LastIndexOf(AccountPair); for Index := 1 to EndIndex do begin if Index = StartIndex then CircularRefs += '('; if Index = EndIndex then SeparatorChar := ')' else SeparatorChar := ','; CircularRefs += StrSubstNo(ThreePlaceHoldersLbl, TotalAccounts.Get(Index), SeparatorChar, ' '); end; end; procedure SetSummarized(NewSummarized: Boolean) begin Summarized := NewSummarized; end; procedure GetSummarized(): Boolean begin exit(Summarized); end; local procedure GetSalesOrderPrepaymentAmt(SalesLine: Record "Sales Line"): Decimal var SalesInvoiceHeader: Record "Sales Invoice Header"; RemainingAmount: Decimal; begin SalesInvoiceHeader.SetLoadFields("Prepayment Order No."); SalesInvoiceHeader.SetRange("Prepayment Order No.", SalesLine."Document No."); SalesInvoiceHeader.SetFilter("Remaining Amount", '<>%1', 0); if SalesInvoiceHeader.FindSet() then repeat SalesInvoiceHeader.CalcFields("Remaining Amount"); RemainingAmount += SalesInvoiceHeader."Remaining Amount"; until SalesInvoiceHeader.Next() = 0; exit(RemainingAmount); end; local procedure CheckCashFlowAccountNo(CashFlowAccountNo: Code[20]) var CashFlowAccount: Record "Cash Flow Account"; begin CashFlowAccount.Get(CashFlowAccountNo); end; [IntegrationEvent(false, false)] local procedure OnCFAccountForBudgetOnAfterGetRecordOnAfterGLBudgEntrySetFilters(var GLBudgEntry: Record "G/L Budget Entry") begin end; [IntegrationEvent(false, false)] local procedure OnGetTaxPayableDateFromSourceOnBeforeExit(SourceTableNum: Integer; SalesHeader: Record "Sales Header"; PurchaseHeader: Record "Purchase Header"; VATEntry: Record "VAT Entry"; var DocumentDate: Date) begin end; [IntegrationEvent(false, false)] local procedure OnInsertCFLineForCustLedgerEntryOnBeforeInsertTempCFWorksheetLine(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line"; CashFlowForecast: Record "Cash Flow Forecast"; CustLedgerEntry: Record "Cust. Ledger Entry") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeSetCashFlowDate(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line"; var IsHandled: Boolean; SelectionCashFlowForecast: Record "Cash Flow Forecast") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeNoOptionsChosen(var Result: Boolean; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnJobPlanningLineOnAfterGetRecordOnBeforeInsertCFLineForJobPlanningLine(JobPlanningLine: Record "Job Planning Line") begin end; [IntegrationEvent(false, false)] local procedure OnAfterGetRecursiveLimit(var Limit: Integer) begin end; [IntegrationEvent(false, false)] local procedure OnAfterInitializeRequest(var ConsiderSource: array[16] of Boolean; var CashFlowNo: Code[20]; var GLBudgName: Code[10]; var Summarized: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnAfterInitCFLineForFixedAssetsBudget(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line"; FADepreciationBook: Record "FA Depreciation Book"; InvestmentFixedAsset: Record "Fixed Asset") begin end; [IntegrationEvent(false, false)] local procedure OnInsertTempCFWorksheetLineOnBeforeCalculateCFAmountAndCFDate(var TempCashFlowWorksheetLine: Record "Cash Flow Worksheet Line" temporary; var IsHandled: Boolean); begin end; [IntegrationEvent(false, false)] local procedure OnInsertCFLineForPurchaseLineOnBeforeInsertTempCFWorksheetLine(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line"; var PurchaseHeader: Record "Purchase Header"; var PurchaseLine: Record "Purchase Line") begin end; [IntegrationEvent(false, false)] local procedure OnInsertCFLineForManualRevenueOnBeforeInsertManualData(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line"; CashFlowForecast: Record "Cash Flow Forecast"; CashFlowManualRevenue: Record "Cash Flow Manual Revenue") begin end; [IntegrationEvent(false, false)] local procedure OnInsertCFLineForManualExpenseOnBeforeInsertManualData(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line"; CashFlowForecast: Record "Cash Flow Forecast"; CashFlowManualExpense: Record "Cash Flow Manual Expense") begin end; [IntegrationEvent(false, false)] local procedure OnInsertCFLineForJobPlanningLineOnBeforeInsertTempCFWorksheetLine(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line"; Job: Record Job; CashFlowForecast: Record "Cash Flow Forecast"; JobPlanningLine: Record "Job Planning Line"); begin end; [IntegrationEvent(false, false)] local procedure OnAfterGetTaxAmountFromSource(SourceTableNum: Integer; SalesHeader: Record "Sales Header"; PurchaseHeader: Record "Purchase Header"; VATEntry: Record "VAT Entry"; var TaxAmount: Decimal); begin end; [IntegrationEvent(false, false)] local procedure OnInsertCFLineForFixedAssetsDisposalOnBeforeInsertTempCFWorksheetLine(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line"; CashFlowForecast: Record "Cash Flow Forecast"; SaleFixedAsset: Record "Fixed Asset") begin end; [IntegrationEvent(false, false)] local procedure OnInsertCFLineForSalesLineOnBeforeInsertTempCFWorksheetLine(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line"; CashFlowForecast: Record "Cash Flow Forecast"; SalesLine: Record "Sales Line") begin end; [IntegrationEvent(false, false)] local procedure OnInsertCFLineForVendorLedgEntryOnBeforeInsertTempCFWorksheetLine(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line"; CashFlowForecast: Record "Cash Flow Forecast"; VendorLedgerEntry: Record "Vendor Ledger Entry") begin end; [IntegrationEvent(false, false)] local procedure OnInsertCFLineForGLAccountOnBeforeInsertTempCFWorksheetLine(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line"; CashFlowForecast: Record "Cash Flow Forecast"; CashFlowAccount: Record "Cash Flow Account"); begin end; [IntegrationEvent(true, false)] local procedure OnDeleteEntriesOnBeforeDeleteAllCashFlowForecastEntry(var CashFlowForecastEntry: Record "Cash Flow Forecast Entry"; var TempCashFlowForecast: Record "Cash Flow Forecast" temporary) begin end;}