Report 8613 Create Item Journal Lines
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;}