Report 7390 Whse. Calculate Inventory

Base Application, Microsoft.Warehouse.Structure

src/Layers/W1/BaseApp/Warehouse/Structure/WhseCalculateInventory.Report.al553 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.Warehouse.Structure;using Microsoft.Foundation.AuditCodes;using Microsoft.Foundation.NoSeries;using Microsoft.Foundation.UOM;using Microsoft.Inventory.Counting.Tracking;using Microsoft.Inventory.Item;using Microsoft.Inventory.Location;using Microsoft.Inventory.Tracking;using Microsoft.Warehouse.Journal;using Microsoft.Warehouse.Ledger;report 7390 "Whse. Calculate Inventory"{    Caption = 'Whse. Calculate Inventory';    ProcessingOnly = true;    dataset    {        dataitem("Bin Content"; "Bin Content")        {            DataItemTableView = sorting("Location Code", "Bin Code", "Item No.", "Variant Code", "Unit of Measure Code");            RequestFilterFields = "Zone Code", "Bin Code", "Item No.", "Variant Code", "Unit of Measure Code", "Bin Type Code", "Warehouse Class Code";            trigger OnAfterGetRecord()            begin                if SkipCycleSKU("Location Code", "Item No.", "Variant Code") then                    CurrReport.Skip();                if not HideValidationDialog then                    Window.Update();                CalcFields("Quantity (Base)");                if ("Quantity (Base)" <> 0) or ZeroQty then                    InsertWhseJnlLine("Bin Content");            end;            trigger OnPostDataItem()            begin                if not HideValidationDialog then                    Window.Close();            end;            trigger OnPreDataItem()            var                WhseJnlTemplate: Record "Warehouse Journal Template";            begin                if RegisteringDate = 0D then                    Error(Text001, WhseJnlLine.FieldCaption("Registering Date"));                SetRange("Location Code", WhseJnlLine."Location Code");                OnBinContentOnBeforePreDataItem("Bin Content", WhseJnlLine);                WhseJnlTemplate.Get(WhseJnlLine."Journal Template Name");                WhseJnlBatch.Get(                  WhseJnlLine."Journal Template Name",                  WhseJnlLine."Journal Batch Name", WhseJnlLine."Location Code");                if NextDocNo = '' then begin                    if WhseJnlBatch."No. Series" <> '' then begin                        WhseJnlLine.SetRange("Journal Template Name", WhseJnlLine."Journal Template Name");                        WhseJnlLine.SetRange("Journal Batch Name", WhseJnlLine."Journal Batch Name");                        WhseJnlLine.SetRange("Location Code", WhseJnlLine."Location Code");                        if not WhseJnlLine.FindFirst() then                            NextDocNo := NoSeriesBatch.GetNextNo(WhseJnlBatch."No. Series", RegisteringDate);                        WhseJnlLine.Init();                    end;                    if NextDocNo = '' then                        Error(Text001, WhseJnlLine.FieldCaption("Whse. Document No."));                end;                NextLineNo := 0;                if not HideValidationDialog then                    Window.Open(Text002, "Bin Code");            end;        }        dataitem("Warehouse Entry"; "Warehouse Entry")        {            trigger OnAfterGetRecord()            var                BinContent: Record "Bin Content";                SkipRecord: Boolean;            begin                this.GetLocation("Location Code");                SkipRecord := ShouldSkipRecord();                OnWarehouseEntryOnAfterGetRecordOnAfterCalcSkipRecord("Warehouse Entry", SkipRecord);                if SkipRecord then                    CurrReport.Skip();                BinContent.CopyFilters("Bin Content");                BinContent.SetRange("Location Code", "Location Code");                BinContent.SetRange("Item No.", "Item No.");                BinContent.SetRange("Variant Code", "Variant Code");                BinContent.SetRange("Unit of Measure Code", "Unit of Measure Code");                if not BinContent.IsEmpty() then                    CurrReport.Skip();                InitBinContent(TempBinContent, "Warehouse Entry");                if not TempBinContent.Find() then                    TempBinContent.Insert();            end;            trigger OnPostDataItem()            begin                TempBinContent.Reset();                if TempBinContent.FindSet() then                    repeat                        InsertWhseJnlLine(TempBinContent);                    until TempBinContent.Next() = 0;            end;            trigger OnPreDataItem()            begin                if ("Bin Content".GetFilter("Zone Code") = '') and                   ("Bin Content".GetFilter("Bin Code") = '')                then                    CurrReport.Break();                "Bin Content".CopyFilter("Location Code", "Location Code");                "Bin Content".CopyFilter("Zone Code", "Zone Code");                "Bin Content".CopyFilter("Bin Code", "Bin Code");                "Bin Content".CopyFilter("Item No.", "Item No.");                "Bin Content".CopyFilter("Variant Code", "Variant Code");                "Bin Content".CopyFilter("Unit of Measure Code", "Unit of Measure Code");                "Bin Content".CopyFilter("Bin Type Code", "Bin Type Code");                "Bin Content".CopyFilter("Lot No. Filter", "Lot No.");                "Bin Content".CopyFilter("Serial No. Filter", "Serial No.");                TempBinContent.Reset();                TempBinContent.DeleteAll();            end;        }    }    requestpage    {        SaveValues = true;        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(RegisteringDate; RegisteringDate)                    {                        ApplicationArea = Warehouse;                        Caption = 'Registering Date';                        ToolTip = 'Specifies the date for registering this batch job. The program automatically enters the work date in this field, but you can change it.';                        trigger OnValidate()                        begin                            ValidateRegisteringDate();                        end;                    }                    field(WhseDocumentNo; NextDocNo)                    {                        ApplicationArea = Warehouse;                        Caption = 'Whse. Document No.';                        ToolTip = 'Specifies which document number will be entered in the Document No. field on the journal lines created by the batch job.';                    }                    field(ZeroQty; ZeroQty)                    {                        ApplicationArea = Warehouse;                        Caption = 'Items Not on Inventory';                        ToolTip = 'Specifies if journal lines should be created for items that are not on inventory, that is, items where the value in the Qty. (Calculated) field is 0.';                    }                }            }        }        actions        {        }        trigger OnOpenPage()        begin            if RegisteringDate = 0D then                RegisteringDate := WorkDate();            ValidateRegisteringDate();        end;    }    labels    {    }    trigger OnPostReport()    begin        OnAfterOnPostReport(WhseJnlLine);    end;    var        SourceCodeSetup: Record "Source Code Setup";        TempBinContent: Record "Bin Content" temporary;        NoSeriesBatch: Codeunit "No. Series - Batch";        UOMMgt: Codeunit "Unit of Measure Management";        Window: Dialog;        StockProposal: Boolean;#pragma warning disable AA0074#pragma warning disable AA0470        Text001: Label 'Enter the %1.';        Text002: Label 'Processing bins    #1##########';#pragma warning restore AA0470#pragma warning restore AA0074    protected var        Bin: Record Bin;        Location: Record Location;        WhseJnlBatch: Record "Warehouse Journal Batch";        WhseJnlLine: Record "Warehouse Journal Line";        HideValidationDialog: Boolean;        NextDocNo: Code[20];        NextLineNo: Integer;        RegisteringDate: Date;        CycleSourceType: Option " ",Item,SKU;        PhysInvtCountCode: Code[10];        ZeroQty: Boolean;    procedure SetWhseJnlLine(var NewWhseJnlLine: Record "Warehouse Journal Line")    begin        WhseJnlLine := NewWhseJnlLine;    end;    local procedure ValidateRegisteringDate()    var        NoSeries: Codeunit "No. Series";    begin        WhseJnlBatch.Get(          WhseJnlLine."Journal Template Name",          WhseJnlLine."Journal Batch Name", WhseJnlLine."Location Code");        if WhseJnlBatch."No. Series" = '' then            NextDocNo := ''        else            NextDocNo := NoSeries.PeekNextNo(WhseJnlBatch."No. Series", RegisteringDate);    end;    local procedure InitBinContent(var BinContent: Record "Bin Content"; WarehouseEntry: Record "Warehouse Entry")    var        BinRec: Record Bin;    begin        BinContent.Init();        BinContent."Location Code" := WarehouseEntry."Location Code";        BinContent."Item No." := WarehouseEntry."Item No.";        BinContent."Bin Code" := WarehouseEntry."Bin Code";        BinContent."Variant Code" := WarehouseEntry."Variant Code";        BinContent."Unit of Measure Code" := WarehouseEntry."Unit of Measure Code";        BinContent."Quantity (Base)" := 0;        // Get current Zone Code from Bin table instead of historical value from Warehouse Entry        if BinRec.Get(WarehouseEntry."Location Code", WarehouseEntry."Bin Code") then            BinContent."Zone Code" := BinRec."Zone Code"        else            BinContent."Zone Code" := WarehouseEntry."Zone Code";        OnAfterInitBinContent(BinContent, WarehouseEntry);    end;    procedure InsertWhseJnlLine(BinContent: Record "Bin Content")    var        WhseEntry: Record "Warehouse Entry";        ItemUOM: Record "Item Unit of Measure";        TempItemTrackingSetup: Record "Item Tracking Setup";        ItemTrackingMgt: Codeunit "Item Tracking Management";        WhseEntryTrackingDistinct: Query "Whse. Entry Tracking Distinct";        ProcessedKeys: Dictionary of [Text, Boolean];        EffectiveKey: Text;        ExpDate: Date;        EntriesExist: Boolean;        IsHandled: Boolean;        ProcessNext: Boolean;        ProcessRecord: Boolean;        SerialNoActive: Boolean;        LotNoActive: Boolean;        PackageNoActive: Boolean;        WhseEntryTrackingDistinctRead: Boolean;    begin        if NextLineNo = 0 then begin            WhseJnlLine.LockTable();            WhseJnlLine.SetRange("Journal Template Name", WhseJnlLine."Journal Template Name");            WhseJnlLine.SetRange("Journal Batch Name", WhseJnlLine."Journal Batch Name");            WhseJnlLine.SetRange("Location Code", WhseJnlLine."Location Code");            if WhseJnlLine.FindLast() then                NextLineNo := WhseJnlLine."Line No.";            SourceCodeSetup.Get();        end;        GetLocation(BinContent."Location Code");        WhseEntry.SetCurrentKey("Item No.", "Bin Code", "Location Code", "Variant Code", "Unit of Measure Code", "Lot No.", "Serial No.");        WhseEntry.SetRange("Item No.", BinContent."Item No.");        WhseEntry.SetRange("Bin Code", BinContent."Bin Code");        WhseEntry.SetRange("Location Code", BinContent."Location Code");        WhseEntry.SetRange("Variant Code", BinContent."Variant Code");        WhseEntry.SetRange("Unit of Measure Code", BinContent."Unit of Measure Code");        WhseEntry.SetLoadFields("Serial No.", "Lot No.", "Package No.", "Warranty Date", "Expiration Date", "Qty. (Base)");        OnInsertWhseJnlLineOnAfterWhseEntrySetFilters(WhseEntry, "Bin Content");        // Performance: enumerate distinct tracking combinations via SQL GROUP BY instead of iterating every Warehouse Entry.        GetSpecificTrackingOptions(BinContent."Item No.", SerialNoActive, LotNoActive, PackageNoActive);        WhseEntryTrackingDistinct.SetRange(Item_No_, BinContent."Item No.");        WhseEntryTrackingDistinct.SetRange(Bin_Code, BinContent."Bin Code");        WhseEntryTrackingDistinct.SetRange(Location_Code, BinContent."Location Code");        WhseEntryTrackingDistinct.SetRange(Variant_Code, BinContent."Variant Code");        WhseEntryTrackingDistinct.SetRange(Unit_of_Measure_Code, BinContent."Unit of Measure Code");        if WhseEntryTrackingDistinct.Open() then begin            WhseEntryTrackingDistinctRead := WhseEntryTrackingDistinct.Read();            ProcessNext := WhseEntryTrackingDistinctRead or ZeroQty;            while ProcessNext do begin                // Reset tracking filters; only the dimensions enabled for the item will be re-applied below.                WhseEntry.SetRange("Serial No.");                WhseEntry.SetRange("Lot No.");                WhseEntry.SetRange("Package No.");                ProcessRecord := true;                if WhseEntryTrackingDistinctRead then begin                    // Collapse query rows that differ only in inactive tracking dimensions to avoid duplicate journal lines.                    EffectiveKey := BuildSpecificTrackingKey(WhseEntryTrackingDistinct, SerialNoActive, LotNoActive, PackageNoActive);                    if ProcessedKeys.ContainsKey(EffectiveKey) then                        ProcessRecord := false                    else begin                        ProcessedKeys.Add(EffectiveKey, true);                        if SerialNoActive then                            WhseEntry.SetRange("Serial No.", WhseEntryTrackingDistinct.Serial_No_);                        if LotNoActive then                            WhseEntry.SetRange("Lot No.", WhseEntryTrackingDistinct.Lot_No_);                        if PackageNoActive then                            WhseEntry.SetRange("Package No.", WhseEntryTrackingDistinct.Package_No_);                    end;                end;                if ProcessRecord then                    if WhseEntry.FindFirst() or ZeroQty then begin                        WhseEntry.CalcSums("Qty. (Base)");                        if (WhseEntry."Qty. (Base)" <> 0) or ZeroQty then begin                            ItemUOM.Get(BinContent."Item No.", BinContent."Unit of Measure Code");                            NextLineNo += 10000;                            WhseJnlLine.Init();                            WhseJnlLine."Line No." := NextLineNo;                            WhseJnlLine.Validate("Registering Date", RegisteringDate);                            WhseJnlLine.Validate("Entry Type", WhseJnlLine."Entry Type"::"Positive Adjmt.");                            WhseJnlLine.Validate("Whse. Document No.", NextDocNo);                            WhseJnlLine.Validate("Item No.", BinContent."Item No.");                            WhseJnlLine.Validate("Variant Code", BinContent."Variant Code");                            WhseJnlLine.Validate("Location Code", BinContent."Location Code");                            WhseJnlLine."From Bin Code" := Location."Adjustment Bin Code";                            WhseJnlLine."From Zone Code" := Bin."Zone Code";                            WhseJnlLine."From Bin Type Code" := Bin."Bin Type Code";                            WhseJnlLine.Validate("To Zone Code", BinContent."Zone Code");                            WhseJnlLine.Validate("To Bin Code", BinContent."Bin Code");                            WhseJnlLine.Validate("Zone Code", BinContent."Zone Code");                            WhseJnlLine.SetProposal(StockProposal);                            WhseJnlLine.Validate("Bin Code", BinContent."Bin Code");                            WhseJnlLine.Validate("Source Code", SourceCodeSetup."Whse. Phys. Invt. Journal");                            WhseJnlLine.Validate("Unit of Measure Code", BinContent."Unit of Measure Code");                            WhseJnlLine.CopyTrackingFromWhseEntry(WhseEntry);                            WhseJnlLine."Warranty Date" := WhseEntry."Warranty Date";                            TempItemTrackingSetup.CopyTrackingFromWhseEntry(WhseEntry);                            ExpDate := ItemTrackingMgt.ExistingExpirationDate(WhseJnlLine."Item No.", WhseJnlLine."Variant Code", TempItemTrackingSetup, false, EntriesExist);                            if EntriesExist then                                WhseJnlLine."Expiration Date" := ExpDate                            else                                WhseJnlLine."Expiration Date" := WhseEntry."Expiration Date";                            WhseJnlLine."Phys. Inventory" := true;                            WhseJnlLine."Qty. (Calculated)" := Round(WhseEntry."Qty. (Base)" / ItemUOM."Qty. per Unit of Measure", UOMMgt.QtyRndPrecision());                            WhseJnlLine."Qty. (Calculated) (Base)" := WhseEntry."Qty. (Base)";                            IsHandled := false;                            OnInsertWhseJnlLineOnBeforeValidateQtyPhysInventory(WhseJnlLine, WhseEntry, IsHandled);                            if not IsHandled then begin                                WhseJnlLine.Validate("Qty. (Phys. Inventory)", WhseJnlLine."Qty. (Calculated)");                                WhseJnlLine.Validate("Qty. (Phys. Inventory) (Base)", WhseEntry."Qty. (Base)");                            end;                            if Location."Use ADCS" then                                WhseJnlLine.Validate("Qty. (Phys. Inventory)", 0);                            WhseJnlLine."Registering No. Series" := WhseJnlBatch."Registering No. Series";                            WhseJnlLine."Whse. Document Type" :=                              WhseJnlLine."Whse. Document Type"::"Whse. Phys. Inventory";                            if WhseJnlBatch."Reason Code" <> '' then                                WhseJnlLine."Reason Code" := WhseJnlBatch."Reason Code";                            WhseJnlLine."Phys Invt Counting Period Code" := PhysInvtCountCode;                            WhseJnlLine."Phys Invt Counting Period Type" := CycleSourceType;                            OnBeforeWhseJnlLineInsert(WhseJnlLine, WhseEntry, NextLineNo);                            WhseJnlLine.Insert(true);                            OnAfterWhseJnlLineInsert(WhseJnlLine, NextLineNo, "Bin Content");                        end;                    end;                ProcessNext := WhseEntryTrackingDistinct.Read();            end;        end;        WhseEntryTrackingDistinct.Close();    end;    procedure InitializeRequest(NewRegisteringDate: Date; WhseDocNo: Code[20]; ItemsNotOnInvt: Boolean)    begin        RegisteringDate := NewRegisteringDate;        NextDocNo := WhseDocNo;        ZeroQty := ItemsNotOnInvt;    end;    procedure InitializePhysInvtCount(PhysInvtCountCode2: Code[10]; CycleSourceType2: Option " ",Item,SKU)    begin        PhysInvtCountCode := PhysInvtCountCode2;        CycleSourceType := CycleSourceType2;    end;    procedure SetHideValidationDialog(NewHideValidationDialog: Boolean)    begin        HideValidationDialog := NewHideValidationDialog;    end;    local procedure SkipCycleSKU(LocationCode: Code[10]; ItemNo: Code[20]; VariantCode: Code[10]): Boolean    var        SKU: Record "Stockkeeping Unit";    begin        if CycleSourceType = CycleSourceType::Item then            if SKU.ReadPermission then                if SKU.Get(LocationCode, ItemNo, VariantCode) then                    exit(true);        exit(false);    end;    local procedure ShouldSkipRecord(): Boolean    var        Item: Record Item;    begin        if ("Warehouse Entry"."Bin Code" = Location."Adjustment Bin Code") then            exit(true);        Item.SetRange("No.", "Warehouse Entry"."Item No.");        if Item.IsEmpty() then            exit(true);        if SkipCycleSKU("Warehouse Entry"."Location Code", "Warehouse Entry"."Item No.", "Warehouse Entry"."Variant Code") then            exit(true);        exit(false);    end;    procedure GetLocation(LocationCode: Code[10])    begin        if Location.Code <> LocationCode then begin            Location.Get(LocationCode);            Location.TestField("Adjustment Bin Code");            Bin.Get(Location.Code, Location."Adjustment Bin Code");            Bin.TestField("Zone Code");        end;    end;    procedure SetProposalMode(NewValue: Boolean)    begin        StockProposal := NewValue;    end;    local procedure GetSpecificTrackingOptions(ItemNo: Code[20]; var SerialNoActive: Boolean; var LotNoActive: Boolean; var PackageNoActive: Boolean)    var        Item: Record Item;        ItemTrackingCode: Record "Item Tracking Code";        PhysInvTrackingMgt: Codeunit "Phys. Invt. Tracking Mgt.";    begin        // Determines which tracking dimensions drive grouping for the item.        // Defaults to all dimensions active so untracked items still group by blank tracking values.        SerialNoActive := true;        LotNoActive := true;        PackageNoActive := true;        if not Item.Get(ItemNo) then            exit;        if not PhysInvTrackingMgt.GetTrackingNosFromWhse(Item) then            exit;        if not ItemTrackingCode.Get(Item."Item Tracking Code") then            exit;        SerialNoActive := ItemTrackingCode."SN Specific Tracking" and ItemTrackingCode."SN Warehouse Tracking";        LotNoActive := ItemTrackingCode."Lot Specific Tracking" and ItemTrackingCode."Lot Warehouse Tracking";        PackageNoActive := ItemTrackingCode."Package Specific Tracking" and ItemTrackingCode."Package Warehouse Tracking";    end;    local procedure BuildSpecificTrackingKey(var WhseEntryTrackingDistinct: Query "Whse. Entry Tracking Distinct"; SerialNoActive: Boolean; LotNoActive: Boolean; PackageNoActive: Boolean): Text    var        SerialNo: Code[50];        LotNo: Code[50];        PackageNo: Code[50];        Separator: Char;    begin        // Builds a deduplication key using only active dimensions; inactive dimensions contribute blank.        // Uses a non-printable separator (NUL) to prevent collisions if Code values contain printable delimiters.        Separator := 0;        if SerialNoActive then            SerialNo := WhseEntryTrackingDistinct.Serial_No_;        if LotNoActive then            LotNo := WhseEntryTrackingDistinct.Lot_No_;        if PackageNoActive then            PackageNo := WhseEntryTrackingDistinct.Package_No_;        exit(SerialNo + Separator + LotNo + Separator + PackageNo);    end;    [IntegrationEvent(false, false)]    local procedure OnAfterInitBinContent(var BinContent: Record "Bin Content"; WarehouseEntry: Record "Warehouse Entry")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterOnPostReport(var WarehouseJournalLine: Record "Warehouse Journal Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterWhseJnlLineInsert(var WarehouseJournalLine: Record "Warehouse Journal Line"; var NextLineNo: Integer; var BinContent: Record "Bin Content")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeWhseJnlLineInsert(var WarehouseJournalLine: Record "Warehouse Journal Line"; var WarehouseEntry: Record "Warehouse Entry"; var NextLineNo: Integer)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBinContentOnBeforePreDataItem(var BinContent: Record "Bin Content"; var WarehouseJournalLine: Record "Warehouse Journal Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnInsertWhseJnlLineOnAfterWhseEntrySetFilters(var WhseEntry: Record "Warehouse Entry"; var BinContent: Record "Bin Content")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnWarehouseEntryOnAfterGetRecordOnAfterCalcSkipRecord(var WarehouseEntry: Record "Warehouse Entry"; var SkipRecord: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnInsertWhseJnlLineOnBeforeValidateQtyPhysInventory(var WarehouseJournalLine: Record "Warehouse Journal Line"; var WarehouseEntry: Record "Warehouse Entry"; var IsHandled: Boolean)    begin    end;}