Table 843 Cash Flow Setup
src/Layers/W1/BaseApp/CashFlow/Setup/CashFlowSetup.Table.al539 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.Setup;using Microsoft.CashFlow.Account;using Microsoft.CashFlow.Forecast;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.Finance.VAT.Ledger;using Microsoft.FixedAssets.FixedAsset;using Microsoft.Foundation.NoSeries;using Microsoft.Foundation.Period;using Microsoft.Projects.Project.Planning;using Microsoft.Purchases.History;using Microsoft.Purchases.Vendor;using Microsoft.Sales.History;using System.AI;using System.Environment;using System.Security.Encryption;table 843 "Cash Flow Setup"{ Caption = 'Cash Flow Setup'; DataClassification = CustomerContent; DrillDownPageID = "Cash Flow Setup"; LookupPageID = "Cash Flow Setup"; fields { field(1; "Primary Key"; Code[10]) { AllowInCustomizations = Never; Caption = 'Primary Key'; DataClassification = SystemMetadata; } field(2; "Cash Flow Forecast No. Series"; Code[20]) { Caption = 'Cash Flow Forecast No. Series'; TableRelation = "No. Series"; } field(3; "Receivables CF Account No."; Code[20]) { Caption = 'Receivables CF Account No.'; TableRelation = "Cash Flow Account"; trigger OnValidate() begin CheckAccountType("Receivables CF Account No."); end; } field(4; "Payables CF Account No."; Code[20]) { Caption = 'Payables CF Account No.'; TableRelation = "Cash Flow Account"; trigger OnValidate() begin CheckAccountType("Payables CF Account No."); end; } field(5; "Sales Order CF Account No."; Code[20]) { AccessByPermission = TableData "Sales Shipment Header" = R; Caption = 'Sales Order CF Account No.'; TableRelation = "Cash Flow Account"; trigger OnValidate() begin CheckAccountType("Sales Order CF Account No."); end; } field(6; "Purch. Order CF Account No."; Code[20]) { AccessByPermission = TableData "Purch. Rcpt. Header" = R; Caption = 'Purch. Order CF Account No.'; TableRelation = "Cash Flow Account"; trigger OnValidate() begin CheckAccountType("Purch. Order CF Account No."); end; } field(8; "FA Budget CF Account No."; Code[20]) { AccessByPermission = TableData "Fixed Asset" = R; Caption = 'FA Budget CF Account No.'; TableRelation = "Cash Flow Account"; trigger OnValidate() begin CheckAccountType("FA Budget CF Account No."); end; } field(9; "FA Disposal CF Account No."; Code[20]) { AccessByPermission = TableData "Fixed Asset" = R; Caption = 'FA Disposal CF Account No.'; TableRelation = "Cash Flow Account"; trigger OnValidate() begin CheckAccountType("FA Disposal CF Account No."); end; } field(11; "CF No. on Chart in Role Center"; Code[20]) { Caption = 'CF No. on Chart in Role Center'; trigger OnValidate() begin if not ConfirmedChartRoleCenterCFNo("CF No. on Chart in Role Center") then "CF No. on Chart in Role Center" := xRec."CF No. on Chart in Role Center"; end; } field(12; "Job CF Account No."; Code[20]) { AccessByPermission = TableData "Job Planning Line" = R; Caption = 'Project CF Account No.'; TableRelation = "Cash Flow Account"; trigger OnValidate() begin CheckAccountType("Job CF Account No."); end; } field(13; "Automatic Update Frequency"; Option) { Caption = 'Automatic Update Frequency'; OptionCaption = 'Never,Daily,Weekly'; OptionMembers = Never,Daily,Weekly; trigger OnValidate() var CashFlowManagement: Codeunit "Cash Flow Management"; begin if "Automatic Update Frequency" = xRec."Automatic Update Frequency" then exit; CashFlowManagement.DeleteJobQueueEntries(); CashFlowManagement.CreateAndStartJobQueueEntry("Automatic Update Frequency"); end; } field(14; "Tax CF Account No."; Code[20]) { AccessByPermission = TableData "VAT Entry" = R; Caption = 'Tax CF Account No.'; TableRelation = "Cash Flow Account"; trigger OnValidate() begin CheckAccountType("Tax CF Account No."); end; } field(19; "Taxable Period"; Option) { Caption = 'Taxable Period'; InitValue = Quarterly; OptionCaption = 'Monthly,Quarterly,Accounting Period,Yearly'; OptionMembers = Monthly,Quarterly,"Accounting Period",Yearly; } field(20; "Tax Payment Window"; DateFormula) { Caption = 'Tax Payment Window'; } field(21; "Tax Bal. Account Type"; Option) { Caption = 'Tax Bal. Account Type'; OptionCaption = ' ,Vendor,G/L Account'; OptionMembers = " ",Vendor,"G/L Account"; trigger OnValidate() begin EmptyTaxBalAccountIfTypeChanged(xRec."Tax Bal. Account Type"); end; } field(22; "Tax Bal. Account No."; Code[20]) { Caption = 'Tax Bal. Account No.'; TableRelation = if ("Tax Bal. Account Type" = const("G/L Account")) "G/L Account" else if ("Tax Bal. Account Type" = const(Vendor)) Vendor; } field(23; "API Key"; Text[250]) { Caption = 'API Key'; trigger OnValidate() begin if not IsNullGuid("Service Pass API Key ID") then EnableEncryption(); SaveUserDefinedAPIKey("API Key"); end; } field(24; "API URL"; Text[250]) { Caption = 'API URL'; trigger OnValidate() var AzureMLConnector: Codeunit "Azure ML Connector"; begin AzureMLConnector.ValidateApiUrl("API URL"); end; } field(25; "Variance %"; Integer) { Caption = 'Variance %'; InitValue = 35; MaxValue = 100; MinValue = 1; } field(26; "Historical Periods"; Integer) { Caption = 'Historical Periods'; InitValue = 24; MaxValue = 24; MinValue = 5; } field(27; Horizon; Integer) { Caption = 'Horizon'; InitValue = 4; MaxValue = 24; MinValue = 3; } field(28; "Period Type"; Option) { Caption = 'Period Type'; InitValue = Month; OptionCaption = 'Day,Week,Month,Quarter,Year'; OptionMembers = Day,Week,Month,Quarter,Year; } field(29; TimeOut; Integer) { Caption = 'TimeOut'; InitValue = 120; MinValue = 1; } field(30; "Service Pass API Key ID"; Guid) { Caption = 'Service Pass API Key ID'; Description = 'The Key for retrieving the API Key from Isolated Storage.'; } field(33; "Time Series Model"; Option) { Caption = 'Time Series Model'; OptionCaption = 'ARIMA,ETS,STL,ETS+ARIMA,ETS+STL,ALL,TBATS', Locked = true; OptionMembers = ARIMA,ETS,STL,"ETS+ARIMA","ETS+STL",ALL,TBATS; } field(34; "Azure AI Enabled"; Boolean) { Caption = 'Azure AI Enabled'; InitValue = false; } field(35; "Show AzureAI Notification"; Boolean) { Caption = 'Show AzureAI Notification'; InitValue = true; } } keys { key(Key1; "Primary Key") { Clustered = true; } } fieldgroups { } var IsolatedStorageManagement: Codeunit "Isolated Storage Management";#pragma warning disable AA0074#pragma warning disable AA0470 Text001: Label 'Cash Flow Forecast %1 %2 is shown in the chart on the Role Center. Do you want to show this Cash Flow Forecast instead?', Comment = 'Cash Flow <No.> <Description> is shown in the chart on the Role Center.';#pragma warning restore AA0470#pragma warning restore AA0074 procedure CheckAccountType("Code": Code[20]) var CFAccount: Record "Cash Flow Account"; begin if Code <> '' then begin CFAccount.Get(Code); CFAccount.TestField("Account Type", CFAccount."Account Type"::Entry); end; end; procedure SetChartRoleCenterCFNo(CashFlowNo: Code[20]) begin Get(); "CF No. on Chart in Role Center" := CashFlowNo; Modify(); end; procedure GetChartRoleCenterCFNo(): Code[20] begin Get(); exit("CF No. on Chart in Role Center"); end; local procedure ConfirmedChartRoleCenterCFNo(NewCashFlowNo: Code[20]): Boolean var CashFlowForecast: Record "Cash Flow Forecast"; begin if NewCashFlowNo = '' then exit(true); if not (xRec."CF No. on Chart in Role Center" in ['', NewCashFlowNo]) then begin CashFlowForecast.Get(xRec."CF No. on Chart in Role Center"); exit(Confirm(StrSubstNo(Text001, CashFlowForecast."No.", CashFlowForecast.Description), true)); end; exit(true); end; procedure GetTaxPaymentDueDate(ReferenceDate: Date): Date var EndOfTaxPeriod: Date; begin Get(); EndOfTaxPeriod := CalculateTaxableDate(ReferenceDate, true); exit(CalcDate("Tax Payment Window", EndOfTaxPeriod)); end; procedure GetTaxPeriodStartEndDates(TaxDueDate: Date; var StartDate: Date; var EndDate: Date) begin Get(); EndDate := GetTaxPeriodEndDate(TaxDueDate); StartDate := CalculateTaxableDate(EndDate, false); end; procedure GetTaxPaymentStartDate(TaxDueDate: Date): Date begin Get(); exit(CalcDate('<1D>', GetTaxPeriodEndDate(TaxDueDate))); end; procedure GetTaxPeriodEndDate(TaxDueDate: Date): Date var ReverseDateFormula: DateFormula; begin Get(); Evaluate(ReverseDateFormula, ReverseDateFormulaAsText()); exit(CalcDate(ReverseDateFormula, TaxDueDate)); end; procedure GetCurrentPeriodStartDate(): Date begin Get(); exit(CalculateTaxableDate(WorkDate(), false)); end; procedure GetCurrentPeriodEndDate(): Date begin Get(); exit(CalculateTaxableDate(WorkDate(), true)); end; procedure UpdateTaxPaymentInfo(NewTaxablePeriod: Option; NewPaymentWindow: DateFormula; NewTaxBalAccountType: Option; NewTaxBalAccountNum: Code[20]) var Modified: Boolean; begin Get(); if "Taxable Period" <> NewTaxablePeriod then begin "Taxable Period" := NewTaxablePeriod; Modified := true; end; if "Tax Payment Window" <> NewPaymentWindow then begin "Tax Payment Window" := NewPaymentWindow; Modified := true; end; if "Tax Bal. Account Type" <> NewTaxBalAccountType then begin "Tax Bal. Account Type" := NewTaxBalAccountType; Modified := true; end; if "Tax Bal. Account No." <> NewTaxBalAccountNum then begin "Tax Bal. Account No." := NewTaxBalAccountNum; Modified := true; end; if Modified then Modify(); end; local procedure CalculateTaxableDate(ReferenceDate: Date; FindLastRec: Boolean) Result: Date var AccountingPeriod: Record "Accounting Period"; begin case "Taxable Period" of "Taxable Period"::Monthly: if FindLastRec then Result := CalcDate('<CM>', ReferenceDate) else Result := CalcDate('<-CM>', ReferenceDate); "Taxable Period"::Quarterly: if FindLastRec then Result := CalcDate('<CQ>', ReferenceDate) else Result := CalcDate('<-CQ>', ReferenceDate); "Taxable Period"::"Accounting Period": if FindLastRec then begin // The end of the current accounting period is the start of the next acc. period - 1 day AccountingPeriod.SetFilter("Starting Date", '>%1', ReferenceDate); AccountingPeriod.FindFirst(); Result := AccountingPeriod."Starting Date" - 1; end else begin // The end of the current accounting period is the start of the next acc. period - 1 day AccountingPeriod.SetFilter("Starting Date", '<=%1', ReferenceDate); AccountingPeriod.FindFirst(); Result := AccountingPeriod."Starting Date"; end; "Taxable Period"::Yearly: if FindLastRec then Result := CalcDate('<CY>', ReferenceDate) else Result := CalcDate('<-CY>', ReferenceDate); end; end; local procedure ReverseDateFormulaAsText() Result: Text var TempChar: Char; begin Result := Format("Tax Payment Window"); if Result = '' then exit(''); if not (CopyStr(Result, 1, 1) in ['+', '-']) then Result := '+' + Result; TempChar := '#'; Result := ReplaceCharInString(Result, '+', TempChar); Result := ReplaceCharInString(Result, '-', '+'); Result := ReplaceCharInString(Result, TempChar, '-'); end; local procedure ReplaceCharInString(StringToReplace: Text; OldChar: Char; NewChar: Char) Result: Text var Index: Integer; FirstPart: Text; LastPart: Text; begin Index := StrPos(StringToReplace, Format(OldChar)); Result := StringToReplace; while Index > 0 do begin if Index > 1 then FirstPart := CopyStr(Result, 1, Index - 1); if Index < StrLen(Result) then LastPart := CopyStr(Result, Index + 1); Result := FirstPart + Format(NewChar) + LastPart; Index := StrPos(Result, Format(OldChar)); end; end; procedure HasValidTaxAccountInfo(): Boolean begin exit("Tax Bal. Account Type" <> "Tax Bal. Account Type"::" "); end; procedure EmptyTaxBalAccountIfTypeChanged(OldTypeValue: Option) begin if "Tax Bal. Account Type" <> OldTypeValue then "Tax Bal. Account No." := ''; end; [Scope('OnPrem')] procedure SaveUserDefinedAPIKey(APIKeyValue: SecretText) begin if IsNullGuid("Service Pass API Key ID") then "Service Pass API Key ID" := CreateGuid(); IsolatedStorageManagement.Set("Service Pass API Key ID", APIKeyValue, DATASCOPE::Company); end; [Scope('OnPrem')] procedure GetMLCredentials(var ApiUrl: Text[250]; var ApiKey: SecretText; var LimitValue: Decimal; var UsingStandardCredentials: Boolean): Boolean var EnvironmentInfo: Codeunit "Environment Information"; Value: SecretText; begin // user-defined credentials if IsAPIUserDefined() then begin IsolatedStorageManagement.Get("Service Pass API Key ID", DATASCOPE::Company, Value); ApiKey := Value; if (ApiKey.IsEmpty()) or ("API URL" = '') then exit(false); ApiUrl := "API URL"; UsingStandardCredentials := false; exit(true); end; UsingStandardCredentials := true; // if credentials not user-defined retrieve it from Azure Key Vault if EnvironmentInfo.IsSaaS() then exit(RetrieveSaaSMLCredentials(ApiUrl, ApiKey, LimitValue)); end; local procedure RetrieveSaaSMLCredentials(var ApiUrl: Text[250]; var ApiKey: SecretText; var LimitValue: Decimal): Boolean var TimeSeriesManagement: Codeunit "Time Series Management"; LimitType: Option; begin exit(TimeSeriesManagement.GetMLForecastCredentials(ApiUrl, ApiKey, LimitType, LimitValue)); end; internal procedure EnableEncryption() var CryptographyManagement: Codeunit "Cryptography Management"; begin if not CryptographyManagement.IsEncryptionEnabled() then CryptographyManagement.EnableEncryption(false); end; [Scope('OnPrem')] internal procedure GetUserDefinedAPIKeySecret(): SecretText var Value: SecretText; begin // user-defined credentials if not IsNullGuid("Service Pass API Key ID") then begin IsolatedStorageManagement.Get("Service Pass API Key ID", DATASCOPE::Company, Value); exit(Value); end; end; procedure IsAPIUserDefined(): Boolean begin exit(not (IsNullGuid("Service Pass API Key ID") or ("API URL" = ''))); end;}