Table 850 Cash Flow Manual Expense
src/Layers/W1/BaseApp/CashFlow/Setup/CashFlowManualExpense.Table.al181 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.Finance.Dimension;table 850 "Cash Flow Manual Expense"{ Caption = 'Cash Flow Manual Expense'; DrillDownPageID = "Cash Flow Manual Expenses"; LookupPageID = "Cash Flow Manual Expenses"; DataClassification = CustomerContent; fields { field(2; "Code"; Code[10]) { Caption = 'Code'; NotBlank = true; } field(3; "Cash Flow Account No."; Code[20]) { Caption = 'Cash Flow Account No.'; TableRelation = "Cash Flow Account"; trigger OnValidate() var CFAccount: Record "Cash Flow Account"; begin if "Cash Flow Account No." <> '' then begin CFAccount.Get("Cash Flow Account No."); CFAccount.TestField("Account Type", CFAccount."Account Type"::Entry); if "Cash Flow Account No." <> xRec."Cash Flow Account No." then Description := CFAccount.Name; end; end; } field(4; Description; Text[100]) { Caption = 'Description'; } field(5; "Starting Date"; Date) { Caption = 'Starting Date'; } field(6; "Ending Date"; Date) { Caption = 'Ending Date'; } field(7; "Recurring Frequency"; DateFormula) { Caption = 'Recurring Frequency'; } field(8; Amount; Decimal) { AutoFormatType = 1; AutoFormatExpression = ''; Caption = 'Amount'; } field(9; "Global Dimension 1 Code"; Code[20]) { CaptionClass = '1,1,1'; Caption = 'Global Dimension 1 Code'; TableRelation = "Dimension Value".Code where("Global Dimension No." = const(1), Blocked = const(false)); trigger OnValidate() begin Rec.ValidateShortcutDimCode(1, "Global Dimension 1 Code"); Modify(); end; } field(10; "Global Dimension 2 Code"; Code[20]) { CaptionClass = '1,1,2'; Caption = 'Global Dimension 2 Code'; TableRelation = "Dimension Value".Code where("Global Dimension No." = const(2), Blocked = const(false)); trigger OnValidate() begin Rec.ValidateShortcutDimCode(2, "Global Dimension 2 Code"); Modify(); end; } } keys { key(Key1; "Code") { Clustered = true; } key(Key2; "Starting Date") { } } fieldgroups { } trigger OnDelete() begin DimMgt.DeleteDefaultDim(DATABASE::"Cash Flow Manual Expense", Code); end; trigger OnInsert() var BlankCashFlowAccount: Record "Cash Flow Account"; ExistingCashFlowManualExpense: Record "Cash Flow Manual Expense"; begin if Rec.Code = '' then if ExistingCashFlowManualExpense.Get('') then Error(CodeIsNotSetErr, BlankCashFlowAccount.TableCaption(), BlankCashFlowAccount.FieldCaption(BlankCashFlowAccount."Source Type"), BlankCashFlowAccount."Source Type"::"Cash Flow Manual Expense"); DimMgt.UpdateDefaultDim( DATABASE::"Cash Flow Manual Expense", Code, "Global Dimension 1 Code", "Global Dimension 2 Code"); end; trigger OnRename() begin DimMgt.RenameDefaultDim(DATABASE::"Cash Flow Manual Expense", xRec.Code, Code); end; var DimMgt: Codeunit DimensionManagement; ExpTxt: Label 'EXP', Comment = 'Abbreviation of Expense, used as prefix for code (e.g. EXP000001)'; procedure ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20]) begin OnBeforeValidateShortcutDimCode(Rec, xRec, FieldNumber, ShortcutDimCode); DimMgt.ValidateDimValueCode(FieldNumber, ShortcutDimCode); if not IsTemporary then DimMgt.SaveDefaultDim(DATABASE::"Cash Flow Manual Expense", Code, FieldNumber, ShortcutDimCode); OnAfterValidateShortcutDimCode(Rec, xRec, FieldNumber, ShortcutDimCode); end; procedure InitNewRecord() var CashFlowManualExpense: Record "Cash Flow Manual Expense"; CashFlowAccount: Record "Cash Flow Account"; CashFlowCode: Code[10]; begin CashFlowManualExpense.SetFilter(Code, '%1', ExpTxt + '0*'); if not CashFlowManualExpense.FindLast() then CashFlowCode := PadStr(ExpTxt, MaxStrLen(CashFlowManualExpense.Code), '0') else CashFlowCode := CashFlowManualExpense.Code; CashFlowCode := IncStr(CashFlowCode); CashFlowAccount.SetRange("Source Type", CashFlowAccount."Source Type"::"Cash Flow Manual Expense"); if not CashFlowAccount.FindFirst() then exit; Code := CashFlowCode; "Cash Flow Account No." := CashFlowAccount."No."; "Starting Date" := WorkDate(); "Ending Date" := 0D; end; [IntegrationEvent(false, false)] local procedure OnAfterValidateShortcutDimCode(var CashFlowManualExpense: Record "Cash Flow Manual Expense"; var xCashFlowManualExpense: Record "Cash Flow Manual Expense"; FieldNumber: Integer; var ShortcutDimCode: Code[20]) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeValidateShortcutDimCode(var CashFlowManualExpense: Record "Cash Flow Manual Expense"; var xCashFlowManualExpense: Record "Cash Flow Manual Expense"; FieldNumber: Integer; var ShortcutDimCode: Code[20]) begin end; var CodeIsNotSetErr: Label 'Cannot insert the line because no code value is set. Please verify that you have set up the %1 with the %2 set to %3.', Comment = '%1 is Cash Flow Account, %2 is Source Type, %3 is Cash Flow Manual Expense';}