Codeunit 7308 Replenishment

Base Application, Microsoft.Warehouse.Worksheet

src/Layers/W1/BaseApp/Warehouse/Worksheet/Replenishment.Codeunit.al404 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.Worksheet;using Microsoft.Foundation.UOM;using Microsoft.Inventory.Item;using Microsoft.Inventory.Location;using Microsoft.Inventory.Tracking;using Microsoft.Warehouse.Structure;codeunit 7308 Replenishment{    trigger OnRun()    begin    end;    var        Bin: Record Bin;        BinType: Record "Bin Type";        TempWhseWkshLine: Record "Whse. Worksheet Line" temporary;        ItemUnitOfMeasure: Record "Item Unit of Measure";        Location: Record Location;        UOMMgt: Codeunit "Unit of Measure Management";        WhseWkshTemplateName: Code[10];        WhseWkshName: Code[10];        LocationCode: Code[10];        RemainQtyToReplenishBase: Decimal;        NextLineNo: Integer;        DoNotFillQtytoHandle: Boolean;        MustNotBeErr: Label 'must not be %1.', Comment = '%1 - field value';    procedure ReplenishBin(ToBinContent: Record "Bin Content"; AllowBreakBulk: Boolean)    var        ExcludedQtyBase: Decimal;        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeReplenishBin(ToBinContent, IsHandled, RemainQtyToReplenishBase, AllowBreakBulk);        if IsHandled then            exit;        if not ToBinContent.Fixed then            ToBinContent.FieldError(Fixed, StrSubstNo(MustNotBeErr, ToBinContent.FieldCaption(Fixed)));        if BinBlockedInbound(ToBinContent."Location Code", ToBinContent."Bin Code") then            Bin.FieldError("Block Movement", StrSubstNo(MustNotBeErr, Bin."Block Movement"));        ExcludedQtyBase := 0;        OnReplenishBinOnAfterAssignExcludedQtyBase(ToBinContent, ExcludedQtyBase);        if not ToBinContent.NeedToReplenish(ExcludedQtyBase) then            exit;        RemainQtyToReplenishBase := ToBinContent.CalcQtyToReplenish(ExcludedQtyBase);        if RemainQtyToReplenishBase <= 0 then            exit;        FindReplenishmtBin(ToBinContent, AllowBreakBulk);    end;    procedure FindReplenishmtBin(ToBinContent: Record "Bin Content"; AllowBreakBulk: Boolean)    var        FromBinContent: Record "Bin Content";        WhseWkshLine2: Record "Whse. Worksheet Line";        QtyAvailToTakeBase: Decimal;        MovementQtyBase: Decimal;        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeFindReplenishmtBin(            TempWhseWkshLine, ToBinContent, AllowBreakBulk, NextLineNo,            WhseWkshTemplateName, WhseWkshName, LocationCode, DoNotFillQtytoHandle, RemainQtyToReplenishBase, IsHandled);        if IsHandled then            exit;        FromBinContent.Reset();        FromBinContent.SetCurrentKey(            "Location Code", "Item No.", "Variant Code", "Cross-Dock Bin",            "Qty. per Unit of Measure", "Bin Ranking");        FromBinContent.Ascending(false);        FromBinContent.SetRange("Location Code", ToBinContent."Location Code");        FromBinContent.SetRange("Item No.", ToBinContent."Item No.");        FromBinContent.SetRange("Variant Code", ToBinContent."Variant Code");        FromBinContent.SetRange("Cross-Dock Bin", false);        FromBinContent.SetRange("Qty. per Unit of Measure", ToBinContent."Qty. per Unit of Measure");        FromBinContent.SetFilter("Bin Ranking", '<%1', ToBinContent."Bin Ranking");        OnFindReplenishmtBinOnAfterFromBinContentSetFilters(FromBinContent, ToBinContent);        if FromBinContent.Find('-') then begin            WhseWkshLine2.Copy(TempWhseWkshLine);            TempWhseWkshLine.SetCurrentKey(                "Item No.", "From Bin Code", "Location Code", "Variant Code", "From Unit of Measure Code");            TempWhseWkshLine.SetRange("Item No.", FromBinContent."Item No.");            TempWhseWkshLine.SetRange("Location Code", FromBinContent."Location Code");            TempWhseWkshLine.SetRange("Variant Code", FromBinContent."Variant Code");            repeat                IsHandled := false;                OnFindReplenishmtBinOnBeforeCalcQtyAvailToTakeBase(FromBinContent, IsHandled);                if not IsHandled then                    if UseForReplenishment(FromBinContent) then begin                        QtyAvailToTakeBase := FromBinContent.CalcQtyAvailToTake(0);                        TempWhseWkshLine.SetRange("From Bin Code", FromBinContent."Bin Code");                        TempWhseWkshLine.SetRange("From Unit of Measure Code", FromBinContent."Unit of Measure Code");                        TempWhseWkshLine.CalcSums("Qty. (Base)");                        QtyAvailToTakeBase := QtyAvailToTakeBase - TempWhseWkshLine."Qty. (Base)";                        if QtyAvailToTakeBase > 0 then begin                            if QtyAvailToTakeBase < RemainQtyToReplenishBase then                                MovementQtyBase := QtyAvailToTakeBase                            else                                MovementQtyBase := RemainQtyToReplenishBase;                            CreateWhseWkshLine(ToBinContent, FromBinContent, MovementQtyBase);                            RemainQtyToReplenishBase := RemainQtyToReplenishBase - MovementQtyBase;                        end;                    end;            until (FromBinContent.Next() = 0) or (RemainQtyToReplenishBase = 0);            TempWhseWkshLine.Copy(WhseWkshLine2);        end;        if AllowBreakBulk then            if RemainQtyToReplenishBase > 0 then                FindBreakbulkBin(ToBinContent);    end;    procedure SetRemainQtyToReplenishBase(NewRemainQtyToReplenishBase: Decimal)    begin        RemainQtyToReplenishBase := NewRemainQtyToReplenishBase;    end;    procedure FindBreakbulkBin(ToBinContent: Record "Bin Content")    var        FromBinContent: Record "Bin Content";        WhseWkshLine2: Record "Whse. Worksheet Line";        QtyAvailToTakeBase: Decimal;        MovementQtyBase: Decimal;        SkipItemUnitOfMeasure: Boolean;    begin        ItemUnitOfMeasure.Reset();        ItemUnitOfMeasure.SetCurrentKey("Item No.", "Qty. per Unit of Measure");        ItemUnitOfMeasure.SetRange("Item No.", ToBinContent."Item No.");        ItemUnitOfMeasure.SetFilter(          "Qty. per Unit of Measure", '>%1', ToBinContent."Qty. per Unit of Measure");        if ItemUnitOfMeasure.Find('-') then            repeat                FromBinContent.Reset();                FromBinContent.SetCurrentKey(                  "Location Code", "Item No.", "Variant Code", "Cross-Dock Bin",                  "Qty. per Unit of Measure", "Bin Ranking");                FromBinContent.SetRange("Location Code", ToBinContent."Location Code");                FromBinContent.SetRange("Item No.", ToBinContent."Item No.");                FromBinContent.SetRange("Variant Code", ToBinContent."Variant Code");                FromBinContent.SetRange("Cross-Dock Bin", false);                FromBinContent.SetRange(                  "Qty. per Unit of Measure", ItemUnitOfMeasure."Qty. per Unit of Measure");                FromBinContent.SetFilter("Bin Ranking", '<%1', ToBinContent."Bin Ranking");                FromBinContent.Ascending(false);                SkipItemUnitOfMeasure := false;                OnFindBreakbulkBinOnAfterFromBinContentSetFilters(FromBinContent, ToBinContent, ItemUnitOfMeasure, SkipItemUnitOfMeasure);                if not SkipItemUnitOfMeasure then                    if FromBinContent.Find('-') then begin                        WhseWkshLine2.Copy(TempWhseWkshLine);                        TempWhseWkshLine.SetCurrentKey(                          "Item No.", "From Bin Code", "Location Code", "Variant Code", "From Unit of Measure Code");                        TempWhseWkshLine.SetRange("Item No.", FromBinContent."Item No.");                        TempWhseWkshLine.SetRange("Location Code", FromBinContent."Location Code");                        TempWhseWkshLine.SetRange("Variant Code", FromBinContent."Variant Code");                        repeat                            if UseForReplenishment(FromBinContent) then begin                                QtyAvailToTakeBase := FromBinContent.CalcQtyAvailToTake(0);                                TempWhseWkshLine.SetRange("From Bin Code", FromBinContent."Bin Code");                                TempWhseWkshLine.SetRange("From Unit of Measure Code", FromBinContent."Unit of Measure Code");                                TempWhseWkshLine.CalcSums("Qty. (Base)");                                QtyAvailToTakeBase := QtyAvailToTakeBase - TempWhseWkshLine."Qty. (Base)";                                if QtyAvailToTakeBase > 0 then begin                                    MovementQtyBase := QtyAvailToTakeBase;                                    if RemainQtyToReplenishBase < MovementQtyBase then                                        MovementQtyBase := RemainQtyToReplenishBase;                                    CreateWhseWkshLine(ToBinContent, FromBinContent, MovementQtyBase);                                    RemainQtyToReplenishBase := RemainQtyToReplenishBase - MovementQtyBase;                                end;                            end;                        until (FromBinContent.Next() = 0) or (RemainQtyToReplenishBase = 0);                        TempWhseWkshLine.Copy(WhseWkshLine2);                    end;            until (ItemUnitOfMeasure.Next() = 0) or (RemainQtyToReplenishBase = 0);    end;    procedure CreateWhseWkshLine(ToBinContent: Record "Bin Content"; FromBinContent: Record "Bin Content"; MovementQtyBase: Decimal)    begin        TempWhseWkshLine.Init();        TempWhseWkshLine."Worksheet Template Name" := WhseWkshTemplateName;        TempWhseWkshLine.Name := WhseWkshName;        TempWhseWkshLine."Location Code" := LocationCode;        TempWhseWkshLine."Line No." := NextLineNo;        TempWhseWkshLine."From Bin Code" := FromBinContent."Bin Code";        TempWhseWkshLine."From Zone Code" := FromBinContent."Zone Code";        TempWhseWkshLine."From Unit of Measure Code" := FromBinContent."Unit of Measure Code";        TempWhseWkshLine."Qty. per From Unit of Measure" := FromBinContent."Qty. per Unit of Measure";        TempWhseWkshLine."To Bin Code" := ToBinContent."Bin Code";        TempWhseWkshLine."To Zone Code" := ToBinContent."Zone Code";        TempWhseWkshLine."Unit of Measure Code" := ToBinContent."Unit of Measure Code";        TempWhseWkshLine."Qty. per Unit of Measure" := ToBinContent."Qty. per Unit of Measure";        TempWhseWkshLine."Item No." := ToBinContent."Item No.";        TempWhseWkshLine.Validate("Variant Code", ToBinContent."Variant Code");        TempWhseWkshLine.Validate(Quantity, Round(MovementQtyBase / ToBinContent."Qty. per Unit of Measure", UOMMgt.QtyRndPrecision()));        TempWhseWkshLine."Qty. (Base)" := MovementQtyBase;        TempWhseWkshLine."Qty. Outstanding (Base)" := MovementQtyBase;        TempWhseWkshLine."Qty. to Handle (Base)" := MovementQtyBase;        TempWhseWkshLine."Whse. Document Type" := TempWhseWkshLine."Whse. Document Type"::"Whse. Mov.-Worksheet";        TempWhseWkshLine."Whse. Document No." := WhseWkshName;        TempWhseWkshLine."Whse. Document Line No." := TempWhseWkshLine."Line No.";        OnCreateWhseWkshLineOnBeforeInsertTempWhseWkshLine(TempWhseWkshLine, ToBinContent);        TempWhseWkshLine.Insert();        NextLineNo := NextLineNo + 10000;    end;    procedure GetTempWhseWkshLine(var TempWhseWorksheetLineOut: Record "Whse. Worksheet Line" temporary)    begin        TempWhseWorksheetLineOut.Reset();        TempWhseWorksheetLineOut.Copy(TempWhseWkshLine, true);    end;    procedure InsertWhseWkshLine() Result: Boolean    var        WhseWkshLine: Record "Whse. Worksheet Line";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeInsertWhseWkshLine(TempWhseWkshLine, DoNotFillQtytoHandle, Result, IsHandled);        if IsHandled then            exit(Result);        TempWhseWkshLine.Reset();        TempWhseWkshLine.SetFilter(Quantity, '>0');        if TempWhseWkshLine.Find('-') then begin            repeat                WhseWkshLine.Init();                WhseWkshLine := TempWhseWkshLine;                if DoNotFillQtytoHandle then begin                    WhseWkshLine."Qty. to Handle" := 0;                    WhseWkshLine."Qty. to Handle (Base)" := 0;                end;                if PickAccordingToFEFO(TempWhseWkshLine."Item No.", TempWhseWkshLine."Variant Code") then begin                    WhseWkshLine."From Zone Code" := '';                    WhseWkshLine."From Bin Code" := '';                end;                WhseWkshLine.Insert();                OnInsertWhseWkshLineOnAfterWhseWkshLineInsert(WhseWkshLine);            until TempWhseWkshLine.Next() = 0;            exit(true);        end;        exit(false);    end;    local procedure BinBlockedInbound(LocationCode2: Code[10]; BinCode2: Code[20]) Blocked: Boolean    begin        GetBin(LocationCode2, BinCode2);        Blocked := Bin."Block Movement" in          [Bin."Block Movement"::Inbound, Bin."Block Movement"::All];        exit(Blocked);    end;    procedure UseForReplenishment(FromBinContent: Record "Bin Content"): Boolean    begin        if FromBinContent."Block Movement" in           [FromBinContent."Block Movement"::Outbound,            FromBinContent."Block Movement"::All]        then            exit(false);        GetBinType(FromBinContent."Bin Type Code");        exit(not (BinType.Receive or BinType.Ship));    end;    local procedure GetBinType(BinTypeCode: Code[10])    begin        if BinTypeCode = '' then begin            Clear(BinType);            BinType.Init();        end else            if BinType.Code <> BinTypeCode then                BinType.Get(BinTypeCode);    end;    local procedure GetBin(LocationCode2: Code[10]; BinCode2: Code[20])    begin        if (Bin."Location Code" <> LocationCode2) or           (Bin.Code <> BinCode2)        then            Bin.Get(LocationCode2, BinCode2);    end;    procedure SetWhseWorksheet(WhseWkshTemplateName2: Code[10]; WhseWkshName2: Code[10]; LocationCode2: Code[10]; DoNotFillQtytoHandle2: Boolean)    var        WhseWorksheetLine: Record "Whse. Worksheet Line";    begin        TempWhseWkshLine.DeleteAll();        WhseWorksheetLine.SetRange("Worksheet Template Name", WhseWkshTemplateName2);        WhseWorksheetLine.SetRange(Name, WhseWkshName2);        WhseWorksheetLine.SetRange("Location Code", LocationCode2);        OnSetWhseWorksheetOnAfterWhseWorksheetLineSetFilters(WhseWorksheetLine);        if WhseWorksheetLine.FindLast() then            NextLineNo := WhseWorksheetLine."Line No." + 10000        else            NextLineNo := 10000;        WhseWkshTemplateName := WhseWkshTemplateName2;        WhseWkshName := WhseWkshName2;        LocationCode := LocationCode2;        Location.Get(LocationCode);        DoNotFillQtytoHandle := DoNotFillQtytoHandle2;    end;    local procedure PickAccordingToFEFO(ItemNo: Code[20]; VariantCode: Code[10]): Boolean    var        DummyItemTrackingSetup: Record "Item Tracking Setup";        ItemTrackingMgt: Codeunit "Item Tracking Management";        EntriesExist: Boolean;        IsHandled: Boolean;        Result: Boolean;    begin        IsHandled := false;        OnBeforePickAccordingToFEFO(Location, ItemNo, VariantCode, Result, IsHandled);        if IsHandled then            exit(Result);        if not Location."Pick According to FEFO" then            exit(false);        if not ItemTrackingMgt.GetWhseItemTrkgSetup(ItemNo) then            exit(false);        if Location."Directed Put-away and Pick" or (Location."Require Receive" and Location."Require Shipment") then            if ItemTrackingMgt.ExistingExpirationDate(ItemNo, VariantCode, DummyItemTrackingSetup, false, EntriesExist) <> 0D then                exit(true);        if ItemTrackingMgt.WhseExistingExpirationDate(ItemNo, VariantCode, Location, DummyItemTrackingSetup, EntriesExist) <> 0D then            exit(true);        exit(false);    end;    [IntegrationEvent(false, false)]    local procedure OnBeforePickAccordingToFEFO(Location: Record Location; ItemNo: Code[20]; VariantCode: Code[10]; var Result: Boolean; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCreateWhseWkshLineOnBeforeInsertTempWhseWkshLine(var TempWhseWkshLine: Record "Whse. Worksheet Line" temporary; var ToBinContent: Record "Bin Content")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnFindReplenishmtBinOnAfterFromBinContentSetFilters(var FromBinContent: Record "Bin Content"; var ToBinContent: Record "Bin Content")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnInsertWhseWkshLineOnAfterWhseWkshLineInsert(var WhseWkshLine: Record "Whse. Worksheet Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnFindReplenishmtBinOnBeforeCalcQtyAvailToTakeBase(FromBinContent: Record "Bin Content"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeInsertWhseWkshLine(var TempWhseWkshLine: Record "Whse. Worksheet Line" temporary; DoNotFillQtytoHandle: Boolean; var Result: Boolean; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeFindReplenishmtBin(var TempWhseWkshLine: Record "Whse. Worksheet Line" temporary; ToBinContent: Record "Bin Content"; AllowBreakBulk: Boolean; var NextLineNo: Integer; WhseWkshTemplateName: Code[10]; WhseWkshName: Code[10]; LocationCode: Code[10]; DoNotFillQtytoHandle: Boolean; RemainQtyToReplenishBase: Decimal; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnReplenishBinOnAfterAssignExcludedQtyBase(ToBinContent: Record "Bin Content"; var ExcludedQtyBase: Decimal)    begin    end;    [IntegrationEvent(true, false)]    local procedure OnBeforeReplenishBin(ToBinContent: Record "Bin Content"; var IsHandled: Boolean; RemainQtyToReplenishBase: Decimal; AllowBreakBulk: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnFindBreakbulkBinOnAfterFromBinContentSetFilters(var FromBinContent: Record "Bin Content"; var ToBinContent: Record "Bin Content"; ItemUnitOfMeasure: Record "Item Unit of Measure"; var SkipItemUnitOfMeasure: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnSetWhseWorksheetOnAfterWhseWorksheetLineSetFilters(var WhseWorksheetLine: Record "Whse. Worksheet Line")    begin    end;}