Report 8612 Create Vendor Journal Lines

Base Application, Microsoft.Finance.GeneralLedger.Journal

src/Layers/W1/BaseApp/Finance/GeneralLedger/Journal/CreateVendorJournalLines.Report.al423 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.Finance.GeneralLedger.Journal;using Microsoft.Purchases.Vendor;/// <summary>/// Report for bulk creation of vendor journal lines from vendor master data and standard journal templates./// Generates journal lines for multiple vendors using standard journal line templates with vendor-specific account assignments./// </summary>/// <remarks>/// Mass journal line creation functionality for vendor-related transactions./// Uses standard journal templates as the basis for line creation with automatic vendor account assignment./// Key features: Bulk vendor processing, standard template application, customizable document types and posting dates./// Integration: Creates lines in specified journal batch, applies vendor posting group settings, supports filtering criteria./// </remarks>report 8612 "Create Vendor Journal Lines"{    ApplicationArea = Basic, Suite;    Caption = 'Create Vendor Journal Lines';    ProcessingOnly = true;    UsageCategory = Tasks;    dataset    {        dataitem(Vendor; Vendor)        {            DataItemTableView = sorting("No.");            RequestFilterFields = "No.", "Currency Code", "Country/Region Code", "Vendor Posting Group", Blocked;            trigger OnAfterGetRecord()            var                StdGenJournalLine: Record "Standard General Journal Line";            begin                GenJnlLine.Init();                if GetStandardJournalLine() then begin                    Initialize(StdGenJournal, GenJnlBatch.Name);                    StdGenJournalLine.SetRange("Journal Template Name", StdGenJournal."Journal Template Name");                    StdGenJournalLine.SetRange("Standard Journal Code", StdGenJournal.Code);                    if StdGenJournalLine.FindSet() then                        repeat                            CopyGenJnlFromStdJnl(StdGenJournalLine, GenJnlLine);                            if PostingDate <> 0D then                                GenJnlLine.Validate("Posting Date", PostingDate);                            GenJnlLine.Validate("Document Type", DocumentTypes);                            GenJnlLine.Validate("Account Type", GenJnlLine."Account Type"::Vendor);                            GenJnlLine.Validate("Account No.", "No.");                            if (GenJnlBatch."Bal. Account Type" = GenJnlBatch."Bal. Account Type"::"G/L Account") and                               (GenJnlBatch."Bal. Account No." <> '')                            then begin                                GenJnlLine.Validate("Bal. Account Type", GenJnlLine."Bal. Account Type"::"G/L Account");                                GenJnlLine.Validate("Bal. Account No.", GenJnlBatch."Bal. Account No.");                            end else                                if "Vendor Posting Group" <> '' then                                    if VendorPostGrp.Get("Vendor Posting Group") then begin                                        GenJnlLine.Validate("Bal. Account Type", GenJnlLine."Bal. Account Type"::"G/L Account");                                        GenJnlLine.Validate("Bal. Account No.", VendorPostGrp."Payables Account");                                    end;                            if DocumentDate <> 0D then begin                                GenJnlLine.Validate("Posting Date", DocumentDate);                                GenJnlLine."Posting Date" := PostingDate;                            end;                            if not GenJnlLine.Insert(true) then                                GenJnlLine.Modify(true);                        until StdGenJournalLine.Next() = 0;                end else begin                    GenJnlLine.Validate("Journal Template Name", GenJnlLine.GetFilter("Journal Template Name"));                    GenJnlLine.Validate("Journal Batch Name", BatchName);                    GenJnlLine."Line No." := LineNo;                    GenJnlLine.SetUpNewLine(LastGenJnlLine, 0, true);                    LineNo := LineNo + 10000;                    if PostingDate <> 0D then                        GenJnlLine.Validate("Posting Date", PostingDate);                    GenJnlLine.Validate("Document Type", DocumentTypes);                    if (GenJnlLine."Document No." = '') and (DocumentNo <> '') then                        GenJnlLine.Validate("Document No.", DocumentNo);                    GenJnlLine.Validate("Account Type", GenJnlLine."Account Type"::Vendor);                    GenJnlLine.Validate("Account No.", "No.");                    if (GenJnlBatch."Bal. Account Type" = GenJnlBatch."Bal. Account Type"::"G/L Account") and                       (GenJnlBatch."Bal. Account No." <> '')                    then begin                        GenJnlLine.Validate("Bal. Account Type", GenJnlLine."Bal. Account Type"::"G/L Account");                        GenJnlLine.Validate("Bal. Account No.", GenJnlBatch."Bal. Account No.");                    end else                        if "Vendor Posting Group" <> '' then                            if VendorPostGrp.Get("Vendor Posting Group") then begin                                GenJnlLine.Validate("Bal. Account Type", GenJnlLine."Bal. Account Type"::"G/L Account");                                GenJnlLine.Validate("Bal. Account No.", VendorPostGrp."Payables Account");                            end;                    if DocumentDate <> 0D then begin                        GenJnlLine.Validate("Posting Date", DocumentDate);                        GenJnlLine."Posting Date" := PostingDate;                    end;                    if not GenJnlLine.Insert(true) then                        GenJnlLine.Modify(true);                end;            end;            trigger OnPreDataItem()            begin                CheckJournalTemplate();                CheckBatchName();                CheckPostingDate();                GenJnlLine.SetRange("Journal Template Name", JournalTemplate);                GenJnlLine.SetRange("Journal Batch Name", BatchName);                if GenJnlLine.FindLast() then                    LineNo := GenJnlLine."Line No." + 10000                else                    LineNo := 10000;                GenJnlBatch.Get(JournalTemplate, BatchName);                if TemplateCode <> '' then                    StdGenJournal.Get(JournalTemplate, TemplateCode);            end;        }    }    requestpage    {        SaveValues = true;        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(DocumentTypes; DocumentTypes)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Document Type';                        ToolTip = 'Specifies the type of document that is processed by the report or batch job.';                    }                    field(DocumentNo; DocumentNo)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Document No.';                        ToolTip = 'Specifies the default document number of the journal line.';                    }                    field(PostingDate; PostingDate)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Posting Date';                        ToolTip = 'Specifies the date for the posting of this batch job. By default, the working date is entered, but you can change it.';                        trigger OnValidate()                        begin                            CheckPostingDate();                        end;                    }                    field(DocumentDate; DocumentDate)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Document Date';                        ToolTip = 'Specifies the document date that will be inserted on the created records.';                    }                    field(JournalTemplate; JournalTemplate)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Journal Template';                        TableRelation = "Gen. Journal Template".Name;                        ToolTip = 'Specifies the journal template that the vendor journal is based on.';                        trigger OnLookup(var Text: Text): Boolean                        var                            GenJnlTemplate: Record "Gen. Journal Template";                            GenJnlTemplates: Page "General Journal Templates";                        begin                            GenJnlTemplate.SetRange(Type, GenJnlTemplate.Type::General);                            GenJnlTemplate.SetRange(Recurring, false);                            GenJnlTemplates.SetTableView(GenJnlTemplate);                            GenJnlTemplates.LookupMode := true;                            GenJnlTemplates.Editable := false;                            if GenJnlTemplates.RunModal() = ACTION::LookupOK then begin                                GenJnlTemplates.GetRecord(GenJnlTemplate);                                JournalTemplate := GenJnlTemplate.Name;                            end;                        end;                        trigger OnValidate()                        begin                            CheckJournalTemplate();                        end;                    }                    field(BatchName; BatchName)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Batch Name';                        TableRelation = "Gen. Journal Batch".Name;                        ToolTip = 'Specifies the name of the journal batch, a personalized journal layout, that the journal is based on.';                        trigger OnLookup(var Text: Text): Boolean                        var                            GenJnlBatches: Page "General Journal Batches";                        begin                            if JournalTemplate <> '' then begin                                GenJnlBatch.SetRange("Journal Template Name", JournalTemplate);                                GenJnlBatches.SetTableView(GenJnlBatch);                            end;                            GenJnlBatches.LookupMode := true;                            GenJnlBatches.Editable := false;                            if GenJnlBatches.RunModal() = ACTION::LookupOK then begin                                GenJnlBatches.GetRecord(GenJnlBatch);                                BatchName := GenJnlBatch.Name;                            end;                        end;                        trigger OnValidate()                        begin                            CheckBatchName();                        end;                    }                    field(TemplateCode; TemplateCode)                    {                        ApplicationArea = Suite;                        Caption = 'Standard General Journal';                        TableRelation = "Standard General Journal".Code;                        ToolTip = 'Specifies the standard general journal that the batch job uses.';                        trigger OnLookup(var Text: Text): Boolean                        var                            StdGenJournal1: Record "Standard General Journal";                            StdGenJnls: Page "Standard General Journals";                        begin                            if JournalTemplate <> '' then begin                                StdGenJournal1.SetRange("Journal Template Name", JournalTemplate);                                StdGenJnls.SetTableView(StdGenJournal1);                            end;                            StdGenJnls.LookupMode := true;                            StdGenJnls.Editable := false;                            if StdGenJnls.RunModal() = ACTION::LookupOK then begin                                StdGenJnls.GetRecord(StdGenJournal1);                                TemplateCode := StdGenJournal1.Code;                            end;                        end;                    }                }            }        }        actions        {        }        trigger OnOpenPage()        begin            if PostingDate = 0D then                PostingDate := WorkDate();        end;    }    labels    {    }    trigger OnPostReport()    begin        Message(Text004);    end;    var        StdGenJournal: Record "Standard General Journal";        GenJnlBatch: Record "Gen. Journal Batch";        GenJnlLine: Record "Gen. Journal Line";        LastGenJnlLine: Record "Gen. Journal Line";        VendorPostGrp: Record "Vendor Posting Group";        DocumentTypes: Option " ",Payment,Invoice,"Credit Memo","Finance Charge Memo",Reminder,Refund;        PostingDate: Date;        DocumentDate: Date;        BatchName: Code[10];        TemplateCode: Code[20];        LineNo: Integer;        JournalTemplate: Text[10];#pragma warning disable AA0074        Text001: Label 'Gen. Journal Template name is blank.';        Text002: Label 'Gen. Journal Batch name is blank.';        Text004: Label 'General journal lines are successfully created.';#pragma warning restore AA0074        PostingDateIsEmptyErr: Label 'The posting date is empty.';        DocumentNo: Code[20];    local procedure GetStandardJournalLine(): Boolean    var        StdGenJounalLine: Record "Standard General Journal Line";    begin        if TemplateCode = '' then            exit;        StdGenJounalLine.SetRange("Journal Template Name", StdGenJournal."Journal Template Name");        StdGenJounalLine.SetRange("Standard Journal Code", StdGenJournal.Code);        exit(not StdGenJounalLine.IsEmpty());    end;    /// <summary>    /// Initializes vendor journal line creation process with standard journal configuration and batch settings.    /// Sets up journal template context, batch assignment, and line numbering for vendor-specific journal line generation.    /// </summary>    /// <param name="StdGenJnl">Standard general journal record containing vendor journal template and configuration settings</param>    /// <param name="JnlBatchName">Target journal batch name where new vendor journal lines will be created</param>    procedure Initialize(var StdGenJnl: Record "Standard General Journal"; JnlBatchName: Code[10])    begin        GenJnlLine."Journal Template Name" := StdGenJnl."Journal Template Name";        GenJnlLine."Journal Batch Name" := JnlBatchName;        GenJnlLine.SetRange("Journal Template Name", StdGenJnl."Journal Template Name");        GenJnlLine.SetRange("Journal Batch Name", JnlBatchName);        LastGenJnlLine.SetRange("Journal Template Name", StdGenJnl."Journal Template Name");        LastGenJnlLine.SetRange("Journal Batch Name", JnlBatchName);        if LastGenJnlLine.FindLast() then;        GenJnlBatch.SetRange("Journal Template Name", StdGenJnl."Journal Template Name");        GenJnlBatch.SetRange(Name, JnlBatchName);        if GenJnlBatch.FindFirst() then;    end;    local procedure CopyGenJnlFromStdJnl(StdGenJnlLine: Record "Standard General Journal Line"; var GenJnlLine: Record "Gen. Journal Line")    var        GenJnlManagement: Codeunit GenJnlManagement;        Balance: Decimal;        TotalBalance: Decimal;        ShowBalance: Boolean;        ShowTotalBalance: Boolean;    begin        GenJnlLine.Init();        GenJnlLine."Line No." := 0;        GenJnlManagement.CalcBalance(GenJnlLine, LastGenJnlLine, Balance, TotalBalance, ShowBalance, ShowTotalBalance);        GenJnlLine.SetUpNewLine(LastGenJnlLine, Balance, true);        if LastGenJnlLine."Line No." <> 0 then            GenJnlLine."Line No." := LastGenJnlLine."Line No." + 10000        else            GenJnlLine."Line No." := 10000;        GenJnlLine.TransferFields(StdGenJnlLine, false);        GenJnlLine.UpdateLineBalance();        GenJnlLine.Validate("Currency Code");        if GenJnlLine."VAT Prod. Posting Group" <> '' then            GenJnlLine.Validate("VAT Prod. Posting Group");        if (GenJnlLine."VAT %" <> 0) and GenJnlBatch."Allow VAT Difference" then            GenJnlLine.Validate("VAT Amount", StdGenJnlLine."VAT Amount");        GenJnlLine.Validate("Bal. VAT Prod. Posting Group");        if GenJnlBatch."Allow VAT Difference" then            GenJnlLine.Validate("Bal. VAT Amount", StdGenJnlLine."Bal. VAT Amount");        GenJnlLine.Insert(true);        LastGenJnlLine := GenJnlLine;    end;    /// <summary>    /// Initializes report request parameters for document type, posting date, and document date configuration.    /// Sets up basic posting parameters for vendor journal line creation from external calls or batch processing.    /// </summary>    /// <param name="DocumentTypesFrom">Document type option for vendor journal lines (Invoice, Credit Memo, Payment, etc.)</param>    /// <param name="PostingDateFrom">Posting date to be applied to all created vendor journal lines</param>    /// <param name="DocumentDateFrom">Document date to be applied to all created vendor journal lines</param>    procedure InitializeRequest(DocumentTypesFrom: Option; PostingDateFrom: Date; DocumentDateFrom: Date)    begin        DocumentTypes := DocumentTypesFrom;        PostingDate := PostingDateFrom;        DocumentDate := DocumentDateFrom;    end;    /// <summary>    /// Initializes report template configuration parameters for vendor journal creation with template and batch settings.    /// Sets up the target journal destination and optional standard template for vendor transaction automation.    /// </summary>    /// <param name="JournalTemplateFrom">General journal template name for vendor journal line creation</param>    /// <param name="BatchNameFrom">Journal batch name for organizing created vendor journal lines</param>    /// <param name="TemplateCodeFrom">Optional standard journal template code for predefined vendor line configurations</param>    procedure InitializeRequestTemplate(JournalTemplateFrom: Text[10]; BatchNameFrom: Code[10]; TemplateCodeFrom: Code[20])    begin        JournalTemplate := JournalTemplateFrom;        BatchName := BatchNameFrom;        TemplateCode := TemplateCodeFrom;    end;    /// <summary>    /// Sets the default document number to be applied to created vendor journal lines when no document number is specified.    /// Provides centralized document numbering control for bulk vendor journal line creation and vendor transaction management.    /// </summary>    /// <param name="NewDocumentNo">Document number to use as default for all created vendor journal lines</param>    procedure SetDefaultDocumentNo(NewDocumentNo: Code[20])    begin        DocumentNo := NewDocumentNo;    end;    local procedure CheckPostingDate()    begin        if PostingDate = 0D then            Error(PostingDateIsEmptyErr);    end;    local procedure CheckBatchName()    begin        if BatchName = '' then            Error(Text002);    end;    local procedure CheckJournalTemplate()    begin        if JournalTemplate = '' then            Error(Text001);    end;}