Table 5605 FA Journal Setup
src/Layers/W1/BaseApp/FixedAssets/FixedAsset/FAJournalSetup.Table.al408 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.FixedAssets.Journal;using Microsoft.Finance.GeneralLedger.Journal;using Microsoft.FixedAssets.Depreciation;using Microsoft.FixedAssets.Insurance;using Microsoft.Foundation.NoSeries;using System.Security.AccessControl;using System.Security.User;table 5605 "FA Journal Setup"{ Caption = 'FA Journal Setup'; DataClassification = CustomerContent; DrillDownPageID = "FA Journal Setup"; LookupPageID = "FA Journal Setup"; fields { field(1; "Depreciation Book Code"; Code[10]) { Caption = 'Depreciation Book Code'; ToolTip = 'Specifies the code for the depreciation book to which the line will be posted if you have selected Fixed Asset in the Type field for this line.'; NotBlank = true; TableRelation = "Depreciation Book"; } field(2; "User ID"; Code[50]) { Caption = 'User ID'; ToolTip = 'Specifies the ID of the user who posted the entry, to be used, for example, in the change log.'; DataClassification = EndUserIdentifiableInformation; TableRelation = User."User Name"; ValidateTableRelation = false; trigger OnValidate() var UserSelection: Codeunit "User Selection"; begin UserSelection.ValidateUserName("User ID"); end; } field(3; "FA Jnl. Template Name"; Code[10]) { Caption = 'FA Jnl. Template Name'; ToolTip = 'Specifies an FA journal template.'; Editable = true; TableRelation = "FA Journal Template"; trigger OnValidate() begin "FA Jnl. Batch Name" := ''; end; } field(4; "FA Jnl. Batch Name"; Code[10]) { Caption = 'FA Jnl. Batch Name'; ToolTip = 'Specifies the relevant FA journal batch name.'; TableRelation = "FA Journal Batch".Name where("Journal Template Name" = field("FA Jnl. Template Name")); } field(5; "Gen. Jnl. Template Name"; Code[10]) { Caption = 'Gen. Jnl. Template Name'; ToolTip = 'Specifies a general journal template.'; TableRelation = "Gen. Journal Template"; trigger OnValidate() begin "Gen. Jnl. Batch Name" := ''; end; } field(6; "Gen. Jnl. Batch Name"; Code[10]) { Caption = 'Gen. Jnl. Batch Name'; ToolTip = 'Specifies the relevant general journal batch name.'; TableRelation = "Gen. Journal Batch".Name where("Journal Template Name" = field("Gen. Jnl. Template Name")); } field(7; "Insurance Jnl. Template Name"; Code[10]) { Caption = 'Insurance Jnl. Template Name'; ToolTip = 'Specifies an insurance journal template.'; TableRelation = "Insurance Journal Template"; trigger OnValidate() begin "Insurance Jnl. Batch Name" := ''; end; } field(8; "Insurance Jnl. Batch Name"; Code[10]) { Caption = 'Insurance Jnl. Batch Name'; ToolTip = 'Specifies the relevant insurance journal batch name.'; TableRelation = "Insurance Journal Batch".Name where("Journal Template Name" = field("Insurance Jnl. Template Name")); } } keys { key(Key1; "Depreciation Book Code", "User ID") { Clustered = true; } } fieldgroups { } trigger OnInsert() begin DeprBook.LockTable(); DeprBook.Get("Depreciation Book Code"); end; var DeprBook: Record "Depreciation Book";#pragma warning disable AA0074#pragma warning disable AA0470 Text000: Label 'You must specify %1.';#pragma warning restore AA0470#pragma warning restore AA0074 procedure GenJnlName(var DeprBook: Record "Depreciation Book"; var GenJnlLine: Record "Gen. Journal Line"; var NextLineNo: Integer) var FAJnlSetup: Record "FA Journal Setup"; GenJnlTemplate: Record "Gen. Journal Template"; GenJnlBatch: Record "Gen. Journal Batch"; FAGetJnl: Codeunit "FA Get Journal"; TemplateName: Code[10]; BatchName: Code[10]; begin if not FAJnlSetup.Get(DeprBook.Code, UserId) then FAJnlSetup.Get(DeprBook.Code, ''); FAJnlSetup.TestField("Gen. Jnl. Template Name"); FAJnlSetup.TestField("Gen. Jnl. Batch Name"); TemplateName := FAJnlSetup."Gen. Jnl. Template Name"; BatchName := FAJnlSetup."Gen. Jnl. Batch Name"; OnGenJnlNameOnBeforeGenJnlTemplateGet(DeprBook, GenJnlLine, NextLineNo, TemplateName, BatchName); GenJnlTemplate.Get(TemplateName); GenJnlBatch.Get(TemplateName, BatchName); FAGetJnl.SetGenJnlRange(GenJnlLine, TemplateName, BatchName); NextLineNo := GenJnlLine."Line No."; end; procedure FAJnlName(var DeprBook: Record "Depreciation Book"; var FAJnlLine: Record "FA Journal Line"; var NextLineNo: Integer) var FAJnlSetup: Record "FA Journal Setup"; FAJnlTemplate: Record "FA Journal Template"; FAJnlBatch: Record "FA Journal Batch"; FAGetJnl: Codeunit "FA Get Journal"; TemplateName: Code[10]; BatchName: Code[10]; begin if not FAJnlSetup.Get(DeprBook.Code, UserId) then FAJnlSetup.Get(DeprBook.Code, ''); FAJnlSetup.TestField("FA Jnl. Template Name"); FAJnlSetup.TestField("FA Jnl. Batch Name"); TemplateName := FAJnlSetup."FA Jnl. Template Name"; BatchName := FAJnlSetup."FA Jnl. Batch Name"; OnFAJnlNameOnBeforeFAJnlTemplateGet(DeprBook, FAJnlLine, NextLineNo, TemplateName, BatchName); FAJnlTemplate.Get(TemplateName); FAJnlBatch.Get(TemplateName, BatchName); FAGetJnl.SetFAJnlRange(FAJnlLine, TemplateName, BatchName); NextLineNo := FAJnlLine."Line No."; end; procedure InsuranceJnlName(var DeprBook: Record "Depreciation Book"; var InsuranceJnlLine: Record "Insurance Journal Line"; var NextLineNo: Integer) var FAJnlSetup: Record "FA Journal Setup"; InsuranceJnlTempl: Record "Insurance Journal Template"; InsuranceJnlBatch: Record "Insurance Journal Batch"; FAGetJnl: Codeunit "FA Get Journal"; TemplateName: Code[10]; BatchName: Code[10]; begin if not FAJnlSetup.Get(DeprBook.Code, UserId) then FAJnlSetup.Get(DeprBook.Code, ''); FAJnlSetup.TestField("Insurance Jnl. Template Name"); FAJnlSetup.TestField("Insurance Jnl. Batch Name"); TemplateName := FAJnlSetup."Insurance Jnl. Template Name"; BatchName := FAJnlSetup."Insurance Jnl. Batch Name"; InsuranceJnlTempl.Get(TemplateName); InsuranceJnlBatch.Get(TemplateName, BatchName); FAGetJnl.SetInsuranceJnlRange(InsuranceJnlLine, TemplateName, BatchName); NextLineNo := InsuranceJnlLine."Line No."; end; procedure SetGenJnlTrailCodes(var GenJnlLine: Record "Gen. Journal Line") var GenJnlTemplate: Record "Gen. Journal Template"; GenJnlBatch: Record "Gen. Journal Batch"; IsHandled: Boolean; begin OnBeforeSetGenJnlTrailCodes(GenJnlLine, IsHandled); if IsHandled then exit; GenJnlTemplate.Get(GenJnlLine."Journal Template Name"); GenJnlBatch.Get(GenJnlLine."Journal Template Name", GenJnlLine."Journal Batch Name"); GenJnlLine."Source Code" := GenJnlTemplate."Source Code"; GenJnlLine."Reason Code" := GenJnlBatch."Reason Code"; GenJnlBatch.TestField("Bal. Account Type", GenJnlLine."Bal. Account Type"::"G/L Account"); GenJnlBatch.TestField("Bal. Account No.", ''); end; procedure GetFAJnlDocumentNo(var FAJnlLine: Record "FA Journal Line"; PostingDate: Date; CreateError: Boolean): Code[20] var FAJnlBatch: Record "FA Journal Batch"; NoSeries: Codeunit "No. Series"; DocumentNo: Code[20]; IsHandled: Boolean; begin IsHandled := false; OnBeforeGetFAJnlDocumentNo(FAJnlLine, IsHandled); if IsHandled then exit; FAJnlBatch.Get(FAJnlLine."Journal Template Name", FAJnlLine."Journal Batch Name"); if (FAJnlBatch."No. Series" <> '') and not FAJnlLine.Find('=><') then DocumentNo := NoSeries.PeekNextNo(FAJnlBatch."No. Series", PostingDate); if (DocumentNo = '') and CreateError then Error(Text000, FAJnlLine.FieldCaption("Document No.")); exit(DocumentNo); end; procedure GetGenJnlDocumentNo(var GenJnlLine: Record "Gen. Journal Line"; PostingDate: Date; CreateError: Boolean): Code[20] var GenJnlBatch: Record "Gen. Journal Batch"; NoSeries: Codeunit "No. Series"; DocumentNo: Code[20]; IsHandled: Boolean; begin IsHandled := false; OnBeforeGetGenJnlDocumentNo(GenJnlLine, IsHandled); if IsHandled then exit; GenJnlBatch.Get(GenJnlLine."Journal Template Name", GenJnlLine."Journal Batch Name"); if (GenJnlBatch."No. Series" <> '') and not GenJnlLine.Find('=><') then DocumentNo := NoSeries.PeekNextNo(GenJnlBatch."No. Series", PostingDate); if (DocumentNo = '') and CreateError then Error(Text000, GenJnlLine.FieldCaption("Document No.")); exit(DocumentNo); end; procedure GetInsuranceJnlDocumentNo(var InsuranceJnlLine: Record "Insurance Journal Line"; PostingDate: Date): Code[20] var InsuranceJnlBatch: Record "Insurance Journal Batch"; NoSeries: Codeunit "No. Series"; DocumentNo: Code[20]; begin InsuranceJnlBatch.Get(InsuranceJnlLine."Journal Template Name", InsuranceJnlLine."Journal Batch Name"); if (InsuranceJnlBatch."No. Series" <> '') and not InsuranceJnlLine.Find('=><') then DocumentNo := NoSeries.PeekNextNo(InsuranceJnlBatch."No. Series", PostingDate); if DocumentNo = '' then Error(Text000, InsuranceJnlLine.FieldCaption("Document No.")); exit(DocumentNo); end; procedure GetFANoSeries(var FAJnlLine: Record "FA Journal Line"): Code[20] var FAJnlBatch: Record "FA Journal Batch"; begin FAJnlBatch.Get(FAJnlLine."Journal Template Name", FAJnlLine."Journal Batch Name"); if FAJnlBatch."No. Series" <> FAJnlBatch."Posting No. Series" then exit(FAJnlBatch."Posting No. Series"); exit(''); end; procedure GetGenNoSeries(var GenJnlLine: Record "Gen. Journal Line"): Code[20] var GenJnlBatch: Record "Gen. Journal Batch"; begin GenJnlBatch.Get(GenJnlLine."Journal Template Name", GenJnlLine."Journal Batch Name"); if GenJnlBatch."No. Series" <> GenJnlBatch."Posting No. Series" then exit(GenJnlBatch."Posting No. Series"); exit(''); end; procedure GetInsuranceNoSeries(var InsuranceJnlLine: Record "Insurance Journal Line"): Code[20] var InsuranceJnlBatch: Record "Insurance Journal Batch"; begin InsuranceJnlBatch.Get(InsuranceJnlLine."Journal Template Name", InsuranceJnlLine."Journal Batch Name"); if InsuranceJnlBatch."No. Series" <> InsuranceJnlBatch."Posting No. Series" then exit(InsuranceJnlBatch."Posting No. Series"); exit(''); end; procedure SetFAJnlTrailCodes(var FAJnlLine: Record "FA Journal Line") var FAJnlTemplate: Record "FA Journal Template"; FAJnlBatch: Record "FA Journal Batch"; IsHandled: Boolean; begin OnBeforeSetFAJnlTrailCodes(FAJnlLine, IsHandled); if IsHandled then exit; FAJnlTemplate.Get(FAJnlLine."Journal Template Name"); FAJnlBatch.Get(FAJnlLine."Journal Template Name", FAJnlLine."Journal Batch Name"); FAJnlLine."Source Code" := FAJnlTemplate."Source Code"; FAJnlLine."Reason Code" := FAJnlBatch."Reason Code"; end; procedure SetInsuranceJnlTrailCodes(var InsuranceJnlLine: Record "Insurance Journal Line") var InsuranceJnlTempl: Record "Insurance Journal Template"; InsuranceJnlBatch: Record "Insurance Journal Batch"; begin InsuranceJnlTempl.Get(InsuranceJnlLine."Journal Template Name"); InsuranceJnlBatch.Get(InsuranceJnlLine."Journal Template Name", InsuranceJnlLine."Journal Batch Name"); InsuranceJnlLine."Source Code" := InsuranceJnlTempl."Source Code"; InsuranceJnlLine."Reason Code" := InsuranceJnlBatch."Reason Code"; end; procedure IncFAJnlBatchName(var FAJnlBatch: Record "FA Journal Batch") var FAJnlSetup: Record "FA Journal Setup"; begin if FAJnlSetup.Find('-') then repeat if (FAJnlSetup."FA Jnl. Template Name" = FAJnlBatch."Journal Template Name") and (FAJnlSetup."FA Jnl. Batch Name" = FAJnlBatch.Name) then begin FAJnlSetup."FA Jnl. Batch Name" := IncStr(FAJnlSetup."FA Jnl. Batch Name"); FAJnlSetup.Modify(); end; until FAJnlSetup.Next() = 0; OnAfterIncFAJnlBatchName(FAJnlBatch); end; procedure IncGenJnlBatchName(var GenJnlBatch: Record "Gen. Journal Batch") var FAJnlSetup: Record "FA Journal Setup"; begin if FAJnlSetup.Find('-') then repeat if (FAJnlSetup."Gen. Jnl. Template Name" = GenJnlBatch."Journal Template Name") and (FAJnlSetup."Gen. Jnl. Batch Name" = GenJnlBatch.Name) then begin FAJnlSetup."Gen. Jnl. Batch Name" := IncStr(FAJnlSetup."Gen. Jnl. Batch Name"); FAJnlSetup.Modify(); end; until FAJnlSetup.Next() = 0; OnAfterIncGenJnlBatchName(GenJnlBatch); end; procedure IncInsuranceJnlBatchName(var InsuranceJnlBatch: Record "Insurance Journal Batch") var FAJnlSetup: Record "FA Journal Setup"; begin if FAJnlSetup.Find('-') then repeat if (FAJnlSetup."Insurance Jnl. Template Name" = InsuranceJnlBatch."Journal Template Name") and (FAJnlSetup."Insurance Jnl. Batch Name" = InsuranceJnlBatch.Name) then begin FAJnlSetup."Insurance Jnl. Batch Name" := IncStr(FAJnlSetup."Insurance Jnl. Batch Name"); FAJnlSetup.Modify(); end; until FAJnlSetup.Next() = 0; end; [IntegrationEvent(false, false)] local procedure OnBeforeSetGenJnlTrailCodes(var GenJnlLine: Record "Gen. Journal Line"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeSetFAJnlTrailCodes(var FAJnlLine: Record "FA Journal Line"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnFAJnlNameOnBeforeFAJnlTemplateGet(var DepreciationBook: Record "Depreciation Book"; var FAJournalLine: Record "FA Journal Line"; NextLineNo: Integer; var TemplateName: Code[10]; var BatchName: Code[10]) begin end; [IntegrationEvent(false, false)] local procedure OnGenJnlNameOnBeforeGenJnlTemplateGet(var DepreciationBook: Record "Depreciation Book"; var GenJournalLine: Record "Gen. Journal Line"; NextLineNo: Integer; var TemplateName: Code[10]; var BatchName: Code[10]) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeGetFAJnlDocumentNo(var FAJournalLine: Record "FA Journal Line"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnAfterIncGenJnlBatchName(var GenJournalBatch: Record "Gen. Journal Batch") begin end; [IntegrationEvent(false, false)] local procedure OnAfterIncFAJnlBatchName(var FAJournalBatch: Record "FA Journal Batch") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeGetGenJnlDocumentNo(var GenJournalLine: Record "Gen. Journal Line"; var IsHandled: Boolean) begin end;}