Codeunit 131306 Library - Journals

Application Test Library

src/Layers/W1/Tests/ApplicationTestLibrary/LibraryJournals.Codeunit.al220 lines, Copyright (c) Microsoft Corporation. MIT

/// <summary>/// Provides utility functions for creating and managing various journal types in test scenarios, including general journals, item journals, and resource journals./// </summary>codeunit 131306 "Library - Journals"{    trigger OnRun()    begin    end;    var        LibraryUtility: Codeunit "Library - Utility";        LibraryERM: Codeunit "Library - ERM";    procedure CreateGenJournalLine(var GenJournalLine: Record "Gen. Journal Line"; JournalTemplateName: Code[10]; JournalBatchName: Code[10]; DocumentType: Enum "Gen. Journal Document Type"; AccountType: Enum "Gen. Journal Account Type"; AccountNo: Code[20]; BalAccountType: Enum "Gen. Journal Account Type"; BalAccountNo: Code[20]; Amount: Decimal)    var        GenJournalBatch: Record "Gen. Journal Batch";        NoSeries: Record "No. Series";        NoSeriesCodeunit: Codeunit "No. Series";        RecRef: RecordRef;    begin        // Find a balanced template/batch pair.        GenJournalBatch.Get(JournalTemplateName, JournalBatchName);        // Create a General Journal Entry.        GenJournalLine.Init();        GenJournalLine.Validate("Journal Template Name", JournalTemplateName);        GenJournalLine.Validate("Journal Batch Name", JournalBatchName);        RecRef.GetTable(GenJournalLine);        GenJournalLine.Validate("Line No.", LibraryUtility.GetNewLineNo(RecRef, GenJournalLine.FieldNo("Line No.")));        GenJournalLine.Insert(true);        GenJournalLine.Validate("Posting Date", WorkDate());  // Defaults to work date.        GenJournalLine.Validate("VAT Reporting Date", WorkDate());        GenJournalLine.Validate("Document Type", DocumentType);        GenJournalLine.Validate("Account Type", AccountType);        GenJournalLine.Validate("Account No.", AccountNo);        GenJournalLine.Validate(Amount, Amount);        if NoSeries.Get(GenJournalBatch."No. Series") then            GenJournalLine.Validate("Document No.", NoSeriesCodeunit.PeekNextNo(GenJournalBatch."No. Series")) // Unused but required field for posting.        else            GenJournalLine.Validate(              "Document No.", LibraryUtility.GenerateRandomCode(GenJournalLine.FieldNo("Document No."), DATABASE::"Gen. Journal Line"));        GenJournalLine.Validate("External Document No.", GenJournalLine."Document No.");  // Unused but required for vendor posting.        GenJournalLine.Validate("Source Code", LibraryERM.FindGeneralJournalSourceCode());  // Unused but required for AU, NZ builds        GenJournalLine.Validate("Bal. Account Type", BalAccountType);        GenJournalLine.Validate("Bal. Account No.", BalAccountNo);        OnBeforeModifyGenJnlLineWhenCreate(GenJournalLine);        GenJournalLine.Modify(true);    end;    procedure CreateGenJournalLine2(var GenJournalLine: Record "Gen. Journal Line"; JournalTemplateName: Code[10]; JournalBatchName: Code[10]; DocumentType: Enum "Gen. Journal Document Type"; AccountType: Enum "Gen. Journal Account Type"; AccountNo: Code[20]; BalAccountType: Enum "Gen. Journal Account Type"; BalAccountNo: Code[20]; Amount: Decimal)    var        GenJournalBatch: Record "Gen. Journal Batch";        LastGenJnlLine: Record "Gen. Journal Line";        RecRef: RecordRef;        Balance: Decimal;    begin        // This function should replace the one above, but it requires a lot of changes to existing tests so I'm keeping both for now and will refactor when time permits        // Find a balanced template/batch pair.        GenJournalBatch.Get(JournalTemplateName, JournalBatchName);        // get the last Gen Jnl Line as template or insert a new doc no (to avoid CODEUNIT.RUN in WRITE transaction error)        Clear(GenJournalLine);        GenJournalLine.SetRange("Journal Template Name", JournalTemplateName);        GenJournalLine.SetRange("Journal Batch Name", JournalBatchName);        if not GetLastGenJnlLineAndBalance(GenJournalLine, LastGenJnlLine, Balance, JournalTemplateName, JournalBatchName) then            SetLastGenJnlLineFields(LastGenJnlLine, GenJournalBatch);        // Create a General Journal Entry.        GenJournalLine.Validate("Journal Template Name", JournalTemplateName);        GenJournalLine.Validate("Journal Batch Name", JournalBatchName);        RecRef.GetTable(GenJournalLine);        GenJournalLine.Validate("Line No.", LibraryUtility.GetNewLineNo(RecRef, GenJournalLine.FieldNo("Line No.")));        GenJournalLine.Insert(true);        // Initialize the new line        GenJournalLine.SetUpNewLine(LastGenJnlLine, Balance, true);        // fill in additional fields        GenJournalLine.Validate("Document Type", DocumentType);        GenJournalLine.Validate("Account Type", AccountType);        GenJournalLine.Validate("Account No.", AccountNo);        GenJournalLine.Validate(Amount, Amount);        GenJournalLine.Validate("External Document No.", GenJournalLine."Document No.");  // Unused but required for vendor posting.        GenJournalLine.Validate("Source Code", LibraryERM.FindGeneralJournalSourceCode());  // Unused but required for AU, NZ builds        GenJournalLine.Validate("Bal. Account Type", BalAccountType);        GenJournalLine.Validate("Bal. Account No.", BalAccountNo);        OnBeforeModifyGenJnlLineWhenCreate(GenJournalLine);        GenJournalLine.Modify(true);    end;    procedure CreateGenJournalLineWithBatch(var GenJournalLine: Record "Gen. Journal Line"; DocumentType: Enum "Gen. Journal Document Type"; AccountType: Enum "Gen. Journal Account Type"; AccountNo: Code[20]; LineAmount: Decimal)    var        GenJournalBatch: Record "Gen. Journal Batch";        GLAccount: Record "G/L Account";    begin        CreateGenJournalBatch(GenJournalBatch);        LibraryERM.CreateGLAccount(GLAccount);        CreateGenJournalLine(          GenJournalLine,          GenJournalBatch."Journal Template Name",          GenJournalBatch.Name,          DocumentType,          AccountType,          AccountNo,          GenJournalLine."Bal. Account Type"::"G/L Account",          GLAccount."No.",          LineAmount);    end;    procedure CreateGenJournalBatch(var GenJournalBatch: Record "Gen. Journal Batch")    var        GenJournalTemplate: Record "Gen. Journal Template";    begin        LibraryERM.CreateGenJournalTemplate(GenJournalTemplate);        LibraryERM.CreateGenJournalBatch(GenJournalBatch, GenJournalTemplate.Name);    end;    procedure CreateGenJournalBatchWithType(var GenJournalBatch: Record "Gen. Journal Batch"; TemplateType: Enum "Gen. Journal Template Type")    var        GenJournalTemplate: Record "Gen. Journal Template";    begin        LibraryERM.CreateGenJournalTemplate(GenJournalTemplate);        GenJournalTemplate.Validate(Type, TemplateType);        GenJournalTemplate.Modify(true);        LibraryERM.CreateGenJournalBatch(GenJournalBatch, GenJournalTemplate.Name);    end;    procedure SelectGenJournalBatch(var GenJournalBatch: Record "Gen. Journal Batch"; GenJournalTemplateCode: Code[10])    var        GLAccount: Record "G/L Account";    begin        // Select General Journal Batch Name for General Journal Line.        GenJournalBatch.SetRange("Journal Template Name", GenJournalTemplateCode);        GenJournalBatch.SetRange("Bal. Account Type", GenJournalBatch."Bal. Account Type"::"G/L Account");        LibraryERM.CreateGLAccount(GLAccount);        if not GenJournalBatch.FindFirst() then begin            // Create New General Journal Batch.            LibraryERM.CreateGenJournalBatch(GenJournalBatch, GenJournalTemplateCode);            GenJournalBatch.Validate("No. Series", LibraryERM.CreateNoSeriesCode());            GenJournalBatch.Validate("Bal. Account Type", GenJournalBatch."Bal. Account Type"::"G/L Account");        end;        GenJournalBatch.Validate("Bal. Account No.", GLAccount."No.");        GenJournalBatch.Modify(true);    end;    procedure SelectGenJournalTemplate(Type: Enum "Gen. Journal Template Type"; PageID: Integer): Code[10]    var        GenJournalTemplate: Record "Gen. Journal Template";    begin        GenJournalTemplate.SetRange(Type, Type);        GenJournalTemplate.SetRange(Recurring, false);        GenJournalTemplate.SetRange("Page ID", PageID);        if not GenJournalTemplate.FindFirst() then begin            GenJournalTemplate.Init();            GenJournalTemplate.Validate(              Name, LibraryUtility.GenerateRandomCode(GenJournalTemplate.FieldNo(Name), DATABASE::"Gen. Journal Template"));            GenJournalTemplate.Validate(Type, Type);            GenJournalTemplate.Validate("Page ID", PageID);            GenJournalTemplate.Validate(Recurring, false);            GenJournalTemplate.Insert(true);        end;        exit(GenJournalTemplate.Name);    end;    local procedure GetLastGenJnlLineAndBalance(var GenJournalLine: Record "Gen. Journal Line"; var LastGenJnlLine: Record "Gen. Journal Line"; var Balance: Decimal; JournalTemplateName: Code[20]; JournalBatchName: Code[20]) LineExists: Boolean    var        GenJnlManagement: Codeunit GenJnlManagement;        TotalBalance: Decimal;        ShowBalance: Boolean;        ShowTotalBalance: Boolean;    begin        LastGenJnlLine.SetRange("Journal Template Name", JournalTemplateName);        LastGenJnlLine.SetRange("Journal Batch Name", JournalBatchName);        LineExists := LastGenJnlLine.FindLast();        GenJnlManagement.CalcBalance(GenJournalLine, LastGenJnlLine, Balance, TotalBalance, ShowBalance, ShowTotalBalance);        exit(LineExists);    end;    local procedure SetLastGenJnlLineFields(var LastGenJnlLine: Record "Gen. Journal Line"; GenJournalBatch: Record "Gen. Journal Batch")    var        NoSeries: Codeunit "No. Series";    begin        if GenJournalBatch."No. Series" <> '' then            LastGenJnlLine."Document No." := NoSeries.PeekNextNo(GenJournalBatch."No. Series")        else            LastGenJnlLine."Document No." :=              LibraryUtility.GenerateRandomCode(LastGenJnlLine.FieldNo("Document No."), DATABASE::"Gen. Journal Line");        LastGenJnlLine."Posting Date" := WorkDate();        LastGenJnlLine."VAT Reporting Date" := WorkDate();    end;    procedure SetPostWithJobQueue(PostWithJobQueue: Boolean)    var        GeneralLedgerSetup: Record "General Ledger Setup";    begin        GeneralLedgerSetup.Get();        GeneralLedgerSetup.Validate("Post with Job Queue", PostWithJobQueue);        GeneralLedgerSetup.Modify(true);    end;    procedure SetPostAndPrintWithJobQueue(PostAndPrintWithJobQueue: Boolean)    var        GeneralLedgerSetup: Record "General Ledger Setup";    begin        GeneralLedgerSetup.Get();        GeneralLedgerSetup.Validate("Post & Print with Job Queue", PostAndPrintWithJobQueue);        GeneralLedgerSetup.Modify(true);    end;    [IntegrationEvent(false, false)]    internal procedure OnBeforeModifyGenJnlLineWhenCreate(var GenJournalLine: Record "Gen. Journal Line")    begin    end;}