Report 8613 Create Item Journal Lines

Base Application, Microsoft.Inventory.Journal

src/Layers/W1/BaseApp/Finance/GeneralLedger/Journal/CreateItemJournalLines.Report.al392 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.Inventory.Journal;using Microsoft.Foundation.UOM;using Microsoft.Inventory.Item;/// <summary>/// Batch job for bulk creation of item journal lines from item master data with configurable entry types and posting parameters./// Supports both standard journal template usage and direct journal line creation for inventory adjustments and transactions./// </summary>/// <remarks>/// Key functionality: Creates item journal lines for multiple items simultaneously with specified entry types, posting dates, and document parameters./// Integration: Works with Item Journal Templates, Item Journal Batches, and Standard Item Journals for template-based line creation./// Use cases: Bulk inventory adjustments, mass item transactions, and automated journal line generation from item selections./// </remarks>report 8613 "Create Item Journal Lines"{    ApplicationArea = Basic, Suite;    Caption = 'Create Item Journal Lines';    ProcessingOnly = true;    UsageCategory = Tasks;    dataset    {        dataitem(Item; Item)        {            DataItemTableView = sorting("No.");            RequestFilterFields = "No.", "Statistics Group", "Vendor No.", Blocked;            trigger OnAfterGetRecord()            var                StdItemJnlLine: Record "Standard Item Journal Line";            begin                ItemJnlLine.Init();                if GetStandardJournalLine() then begin                    Initialize(StdItemJnl, ItemJnlBatch.Name);                    StdItemJnlLine.SetRange("Journal Template Name", StdItemJnl."Journal Template Name");                    StdItemJnlLine.SetRange("Standard Journal Code", StdItemJnl.Code);                    if StdItemJnlLine.FindSet() then                        repeat                            CopyItemJnlFromStdJnl(StdItemJnlLine, ItemJnlLine);                            ItemJnlLine.Validate("Entry Type", EntryTypes);                            ItemJnlLine.Validate("Item No.", "No.");                            if PostingDate <> 0D then                                ItemJnlLine.Validate("Posting Date", PostingDate);                            if DocumentDate <> 0D then begin                                ItemJnlLine.Validate("Posting Date", DocumentDate);                                ItemJnlLine."Posting Date" := PostingDate;                            end;                            if not ItemJnlLine.Insert(true) then                                ItemJnlLine.Modify(true);                        until StdItemJnlLine.Next() = 0;                end else begin                    ItemJnlLine.Validate("Journal Template Name", ItemJnlLine.GetFilter("Journal Template Name"));                    ItemJnlLine.Validate("Journal Batch Name", BatchName);                    ItemJnlLine."Line No." := LineNo;                    LineNo := LineNo + 10000;                    ItemJnlLine.Validate("Entry Type", EntryTypes);                    ItemJnlLine.Validate("Item No.", "No.");                    if PostingDate <> 0D then                        ItemJnlLine.Validate("Posting Date", PostingDate);                    if DocumentDate <> 0D then begin                        ItemJnlLine.Validate("Posting Date", DocumentDate);                        ItemJnlLine."Posting Date" := PostingDate;                    end;                    if (ItemJnlLine."Document No." = '') and (DocumentNo <> '') then                        ItemJnlLine.Validate("Document No.", DocumentNo);                    if not ItemJnlLine.Insert(true) then                        ItemJnlLine.Modify(true);                end;            end;            trigger OnPreDataItem()            begin                CheckJournalTemplate();                CheckBatchName();                CheckPostingDate();                ItemJnlLine.SetRange("Journal Template Name", JournalTemplate);                ItemJnlLine.SetRange("Journal Batch Name", BatchName);                if ItemJnlLine.FindLast() then                    LineNo := ItemJnlLine."Line No." + 10000                else                    LineNo := 10000;                ItemJnlBatch.Get(JournalTemplate, BatchName);                if TemplateCode <> '' then                    StdItemJnl.Get(JournalTemplate, TemplateCode);            end;        }    }    requestpage    {        SaveValues = true;        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(EntryTypes; EntryTypes)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Entry Type';                        OptionCaption = 'Purchase,Sale,Positive Adjmt.,Negative Adjmt.';                        ToolTip = 'Specifies the entry type.';                    }                    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 = "Item Journal Template".Name;                        ToolTip = 'Specifies the journal template that the item journal is based on.';                        trigger OnLookup(var Text: Text): Boolean                        var                            ItemJnlTemplate: Record "Item Journal Template";                            ItemJnlTemplates: Page "Item Journal Templates";                        begin                            ItemJnlTemplate.SetRange(Type, ItemJnlTemplate.Type::Item);                            ItemJnlTemplate.SetRange(Recurring, false);                            ItemJnlTemplates.SetTableView(ItemJnlTemplate);                            ItemJnlTemplates.LookupMode := true;                            ItemJnlTemplates.Editable := false;                            if ItemJnlTemplates.RunModal() = ACTION::LookupOK then begin                                ItemJnlTemplates.GetRecord(ItemJnlTemplate);                                JournalTemplate := ItemJnlTemplate.Name;                            end;                        end;                        trigger OnValidate()                        begin                            CheckJournalTemplate();                        end;                    }                    field(BatchName; BatchName)                    {                        ApplicationArea = Basic, Suite;                        Caption = '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                            ItemJnlBatches: Page "Item Journal Batches";                        begin                            if JournalTemplate <> '' then begin                                ItemJnlBatch.SetRange("Journal Template Name", JournalTemplate);                                ItemJnlBatches.SetTableView(ItemJnlBatch);                            end;                            ItemJnlBatches.LookupMode := true;                            ItemJnlBatches.Editable := false;                            if ItemJnlBatches.RunModal() = ACTION::LookupOK then begin                                ItemJnlBatches.GetRecord(ItemJnlBatch);                                BatchName := ItemJnlBatch.Name;                            end;                        end;                        trigger OnValidate()                        begin                            CheckBatchName();                        end;                    }                    field(TemplateCode; TemplateCode)                    {                        ApplicationArea = Suite;                        Caption = 'Standard Item Journal';                        TableRelation = "Standard Item Journal".Code;                        ToolTip = 'Specifies the standard item journal that the batch job uses.';                        trigger OnLookup(var Text: Text): Boolean                        var                            StdItemJnl1: Record "Standard Item Journal";                            StdItemJnls: Page "Standard Item Journals";                        begin                            if JournalTemplate <> '' then begin                                StdItemJnl1.SetRange("Journal Template Name", JournalTemplate);                                StdItemJnls.SetTableView(StdItemJnl1);                            end;                            StdItemJnls.LookupMode := true;                            StdItemJnls.Editable := false;                            if StdItemJnls.RunModal() = ACTION::LookupOK then begin                                StdItemJnls.GetRecord(StdItemJnl1);                                TemplateCode := StdItemJnl1.Code;                            end;                        end;                    }                }            }        }        actions        {        }        trigger OnOpenPage()        begin            if PostingDate = 0D then                PostingDate := WorkDate();        end;    }    labels    {    }    trigger OnPostReport()    begin        Message(Text004);    end;    var        StdItemJnl: Record "Standard Item Journal";        ItemJnlBatch: Record "Item Journal Batch";        LastItemJnlLine: Record "Item Journal Line";        ItemJnlLine: Record "Item Journal Line";        UOMMgt: Codeunit "Unit of Measure Management";        EntryTypes: Option Purchase,Sale,"Positive Adjmt.","Negative Adjmt.";        PostingDate: Date;        DocumentDate: Date;        BatchName: Code[10];        TemplateCode: Code[20];        LineNo: Integer;        JournalTemplate: Text[10];#pragma warning disable AA0074        Text001: Label 'Item Journal Template name is blank.';        Text002: Label 'Item Journal Batch name is blank.';        Text004: Label 'Item Journal lines are successfully created.';#pragma warning restore AA0074        PostingDateIsEmptyErr: Label 'The Posting Date is empty.';        DocumentNo: Code[20];    local procedure GetStandardJournalLine(): Boolean    var        StdItemJnlLine: Record "Standard Item Journal Line";    begin        if TemplateCode = '' then            exit;        StdItemJnlLine.SetRange("Journal Template Name", StdItemJnl."Journal Template Name");        StdItemJnlLine.SetRange("Standard Journal Code", StdItemJnl.Code);        exit(not StdItemJnlLine.IsEmpty());    end;    /// <summary>    /// Initializes journal line creation process with standard journal template and batch configuration.    /// Sets up journal template name, batch name, and prepares line numbering sequence for new journal lines.    /// </summary>    /// <param name="StdItemJnl">Standard item journal record containing template configuration and settings</param>    /// <param name="JnlBatchName">Journal batch name where new item journal lines will be created</param>    procedure Initialize(StdItemJnl: Record "Standard Item Journal"; JnlBatchName: Code[10])    begin        ItemJnlLine."Journal Template Name" := StdItemJnl."Journal Template Name";        ItemJnlLine."Journal Batch Name" := JnlBatchName;        ItemJnlLine.SetRange("Journal Template Name", StdItemJnl."Journal Template Name");        ItemJnlLine.SetRange("Journal Batch Name", JnlBatchName);        LastItemJnlLine.SetRange("Journal Template Name", StdItemJnl."Journal Template Name");        LastItemJnlLine.SetRange("Journal Batch Name", JnlBatchName);        if LastItemJnlLine.FindLast() then;    end;    local procedure CopyItemJnlFromStdJnl(StdItemJnlLine: Record "Standard Item Journal Line"; var ItemJnlLine: Record "Item Journal Line")    begin        ItemJnlLine.Init();        ItemJnlLine."Line No." := 0;        ItemJnlLine.SetUpNewLine(LastItemJnlLine);        if LastItemJnlLine."Line No." <> 0 then            ItemJnlLine."Line No." := LastItemJnlLine."Line No." + 10000        else            ItemJnlLine."Line No." := 10000;        ItemJnlLine.TransferFields(StdItemJnlLine, false);        if (ItemJnlLine."Item No." <> '') and (ItemJnlLine."Unit Amount" = 0) then            ItemJnlLine.RecalculateUnitAmount();        if (ItemJnlLine."Entry Type" = ItemJnlLine."Entry Type"::Output) and           (ItemJnlLine."Value Entry Type" <> ItemJnlLine."Value Entry Type"::Revaluation)        then            ItemJnlLine."Invoiced Quantity" := 0        else            ItemJnlLine."Invoiced Quantity" := ItemJnlLine.Quantity;        ItemJnlLine.TestField("Qty. per Unit of Measure");        ItemJnlLine."Invoiced Qty. (Base)" :=          Round(ItemJnlLine."Invoiced Quantity" * ItemJnlLine."Qty. per Unit of Measure", UOMMgt.QtyRndPrecision());        ItemJnlLine."Dimension Set ID" := 0;        ItemJnlLine.Insert(true);        LastItemJnlLine := ItemJnlLine;    end;    /// <summary>    /// Initializes report parameters for entry type, posting date, and document date configuration.    /// Sets default values for journal line creation process from external procedure calls.    /// </summary>    /// <param name="EntryTypesFrom">Entry type option for journal lines: Purchase, Sale, Positive Adjmt., or Negative Adjmt.</param>    /// <param name="PostingDateFrom">Posting date to be applied to created journal lines</param>    /// <param name="DocumentDateFrom">Document date to be applied to created journal lines</param>    procedure InitializeRequest(EntryTypesFrom: Option; PostingDateFrom: Date; DocumentDateFrom: Date)    begin        EntryTypes := EntryTypesFrom;        PostingDate := PostingDateFrom;        DocumentDate := DocumentDateFrom;    end;    /// <summary>    /// Initializes report template configuration parameters for journal template, batch name, and standard template code.    /// Sets up the target journal destination and optional standard journal template for automated line creation.    /// </summary>    /// <param name="JournalTemplateFrom">Item journal template name where lines will be created</param>    /// <param name="BatchNameFrom">Journal batch name for organizing created journal lines</param>    /// <param name="TemplateCodeFrom">Optional standard journal template code for predefined 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 journal lines when no document number is specified.    /// Provides programmatic control over document numbering for batch journal line creation processes.    /// </summary>    /// <param name="NewDocumentNo">Document number to use as default for created 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;}