Codeunit 99000876 Transfer Availability Mgt.

Base Application, Microsoft.Inventory.Transfer

src/Layers/W1/BaseApp/Inventory/Transfer/TransferAvailabilityMgt.Codeunit.al405 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.Transfer;using Microsoft.Inventory.Availability;using Microsoft.Inventory.Item;using Microsoft.Inventory.Requisition;using Microsoft.Inventory.Tracking;codeunit 99000876 "Transfer Availability Mgt."{    var        TransferTxt: Label 'Transfer';        TransferDocumentTxt: Label 'Transfer %1', Comment = '%1 - location code';        PlanRevertTxt: Label 'Plan Revert';        UnsupportedEntitySourceErr: Label 'Unsupported Entity Source Type = %1, Source Subtype = %2.', Comment = '%1 = source type, %2 = source subtype';    // Page "Demand Overview"    [EventSubscriber(ObjectType::Page, Page::"Demand Overview", 'OnSourceTypeTextOnFormat', '', false, false)]    local procedure OnSourceTypeTextOnFormat(var AvailabilityCalcOverview: Record "Availability Calc. Overview"; var Text: Text)    begin        case AvailabilityCalcOverview."Source Type" of            Database::"Transfer Line":                Text := TransferTxt;        end;    end;    // Codeunit "Calc. Availability Overview"    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Calc. Availability Overview", 'OnGetDemandDates', '', false, false)]    local procedure OnGetDemandDates(var AvailabilityCalcOverview: Record "Availability Calc. Overview"; var Item: Record Item; var sender: Codeunit "Calc. Availability Overview")    var        TransLine: Record "Transfer Line";    begin        TransLine.FilterLinesWithItemToPlan(Item, false, false);        if TransLine.FindFirst() then            repeat                TransLine.SetRange("Transfer-from Code", TransLine."Transfer-from Code");                TransLine.SetRange("Variant Code", TransLine."Variant Code");                TransLine.SetRange("Shipment Date", TransLine."Shipment Date");                sender.InsertAvailabilityEntry(                  AvailabilityCalcOverview, AvailabilityCalcOverview.Type::"As of Date",                  TransLine."Shipment Date", TransLine."Transfer-from Code", TransLine."Variant Code");                TransLine.FindLast();                TransLine.SetFilter("Transfer-from Code", Item.GetFilter("Location Filter"));                TransLine.SetFilter("Variant Code", Item.GetFilter("Variant Filter"));                TransLine.SetFilter("Shipment Date", Item.GetFilter("Date Filter"));            until TransLine.Next() = 0;    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Calc. Availability Overview", 'OnGetSupplyDates', '', false, false)]    local procedure OnGetSupplyDates(var AvailabilityCalcOverview: Record "Availability Calc. Overview"; var Item: Record Item; var sender: Codeunit "Calc. Availability Overview")    var        TransLine: Record "Transfer Line";    begin        TransLine.FilterLinesWithItemToPlan(Item, true, false);        if TransLine.FindFirst() then            repeat                TransLine.SetRange("Transfer-to Code", TransLine."Transfer-to Code");                TransLine.SetRange("Variant Code", TransLine."Variant Code");                TransLine.SetRange("Receipt Date", TransLine."Receipt Date");                sender.InsertAvailabilityEntry(                  AvailabilityCalcOverview, AvailabilityCalcOverview.Type::"As of Date",                  TransLine."Receipt Date", TransLine."Transfer-to Code", TransLine."Variant Code");                TransLine.FindLast();                TransLine.SetFilter("Transfer-to Code", Item.GetFilter("Location Filter"));                TransLine.SetFilter("Variant Code", Item.GetFilter("Variant Filter"));                TransLine.SetFilter("Receipt Date", Item.GetFilter("Date Filter"));            until TransLine.Next() = 0;    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Calc. Availability Overview", 'OnGetDemandEntries', '', false, false)]    local procedure OnGetDemandEntries(var AvailabilityCalcOverview: Record "Availability Calc. Overview"; var Item: Record Item; var sender: Codeunit "Calc. Availability Overview")    var        TransLine: Record "Transfer Line";        TransHeader: Record "Transfer Header";    begin        if TransLine.FindLinesWithItemToPlan(Item, false, false) then            repeat                TransHeader.Get(TransLine."Document No.");                TransLine.CalcFields("Reserved Qty. Outbnd. (Base)");                sender.InsertAvailabilityEntry(                    AvailabilityCalcOverview,                    AvailabilityCalcOverview.Type::Demand, TransLine."Shipment Date", TransLine."Transfer-from Code", TransLine."Variant Code",                    -TransLine."Outstanding Qty. (Base)", -TransLine."Reserved Qty. Outbnd. (Base)",                    Database::"Transfer Line", TransLine.Status, TransLine."Document No.", TransHeader."Transfer-to Name",                    Enum::"Demand Order Source Type"::"All Demands");            until TransLine.Next() = 0;    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Calc. Availability Overview", 'OnGetSupplyEntries', '', false, false)]    local procedure OnGetSupplyEntries(var AvailabilityCalcOverview: Record "Availability Calc. Overview"; var Item: Record Item; var sender: Codeunit "Calc. Availability Overview")    var        TransLine: Record "Transfer Line";        TransHeader: Record "Transfer Header";    begin        if TransLine.FindLinesWithItemToPlan(Item, true, false) then            repeat                TransHeader.Get(TransLine."Document No.");                TransLine.CalcFields("Reserved Qty. Inbnd. (Base)");                sender.InsertAvailabilityEntry(                    AvailabilityCalcOverview,                    AvailabilityCalcOverview.Type::Supply, TransLine."Receipt Date", TransLine."Transfer-to Code", TransLine."Variant Code",                    TransLine."Outstanding Qty. (Base)", TransLine."Reserved Qty. Inbnd. (Base)",                    Database::"Transfer Line", TransLine.Status, TransLine."Document No.", TransHeader."Transfer-from Name",                    Enum::"Demand Order Source Type"::"All Demands");            until TransLine.Next() = 0;    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Calc. Availability Overview", 'OnDemandExist', '', false, false)]    local procedure OnDemandExist(var Item: Record Item; var Exists: Boolean)    var        TransferLine: Record "Transfer Line";    begin        Exists := Exists or TransferLine.LinesWithItemToPlanExist(Item, false);    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Calc. Availability Overview", 'OnSupplyExist', '', false, false)]    local procedure OnSupplyExist(var Item: Record Item; var Exists: Boolean)    var        TransferLine: Record "Transfer Line";    begin        Exists := Exists or TransferLine.LinesWithItemToPlanExist(Item, true);    end;    // Table "Availability Info. Buffer"     [EventSubscriber(ObjectType::Table, Database::"Availability Info. Buffer", 'OnLookupAvailableInventory', '', false, false)]    local procedure OnLookupAvailableInventory(var TempReservationEntry: Record "Reservation Entry" temporary; var sender: Record "Availability Info. Buffer")    begin        LookupReservationEntryForQtyOnTransOrdShipment(TempReservationEntry, sender);        LookupReservationEntryForQtyOnTransOrderReceipt(TempReservationEntry, sender);    end;    [EventSubscriber(ObjectType::Table, Database::"Availability Info. Buffer", 'OnLookupGrossRequirement', '', false, false)]    local procedure OnLookupGrossRequirement(var TempReservationEntry: Record "Reservation Entry" temporary; var sender: Record "Availability Info. Buffer")    begin        LookupReservationEntryForQtyOnTransOrdShipment(TempReservationEntry, sender);    end;    [EventSubscriber(ObjectType::Table, Database::"Availability Info. Buffer", 'OnLookupScheduledReceipt', '', false, false)]    local procedure OnLookupScheduledReceipt(var TempReservationEntry: Record "Reservation Entry" temporary; var sender: Record "Availability Info. Buffer")    begin        LookupReservationEntryForQtyOnTransOrderReceipt(TempReservationEntry, sender);    end;    local procedure LookupReservationEntryForQtyOnTransOrdShipment(var TempReservationEntry: Record "Reservation Entry" temporary; var AvailabilityInfoBuffer: Record "Availability Info. Buffer")    var        ReservationEntry: Record "Reservation Entry";    begin        AvailabilityInfoBuffer.AddEntriesForLookUp(            TempReservationEntry,            Database::"Transfer Line",            Format(ReservationEntry."Source Subtype"::"0"),            AvailabilityInfoBuffer.GetOptionFilter(                ReservationEntry."Reservation Status"::Reservation,                ReservationEntry."Reservation Status"::Tracking,                ReservationEntry."Reservation Status"::Surplus            ),            "Reservation Date Filter"::"Shipment Date"        );    end;    local procedure LookupReservationEntryForQtyOnTransOrderReceipt(var TempReservationEntry: Record "Reservation Entry" temporary; var AvailabilityInfoBuffer: Record "Availability Info. Buffer")    var        ReservationEntry: Record "Reservation Entry";    begin        AvailabilityInfoBuffer.AddEntriesForLookUp(            TempReservationEntry,            Database::"Transfer Line",            Format(ReservationEntry."Source Subtype"::"1"),            AvailabilityInfoBuffer.GetOptionFilter(                ReservationEntry."Reservation Status"::Reservation,                ReservationEntry."Reservation Status"::Tracking,                ReservationEntry."Reservation Status"::Surplus            ),            "Reservation Date Filter"::"Expected Receipt Date"        );    end;    // Codeunit "Item Availability Forms Mgt"    procedure ShowItemAvailabilityFromTransLine(var TransLine: Record "Transfer Line"; AvailabilityType: Enum "Item Availability Type")    var        Item: Record Item;        ItemAvailabilityFormsMgt: Codeunit "Item Availability Forms Mgt";        NewDate: Date;        NewVariantCode: Code[10];        NewLocationCode: Code[10];        NewUnitOfMeasureCode: Code[10];    begin        TransLine.TestField("Item No.");        Item.Reset();        Item.Get(TransLine."Item No.");        ItemAvailabilityFormsMgt.FilterItem(Item, TransLine."Transfer-from Code", TransLine."Variant Code", TransLine."Shipment Date");        OnBeforeShowItemAvailabilityFromTransLine(Item, TransLine, AvailabilityType);        case AvailabilityType of            AvailabilityType::Period:                if ItemAvailabilityFormsMgt.ShowItemAvailabilityByPeriod(Item, GetFieldCaption(TransLine.FieldCaption(TransLine."Shipment Date")), TransLine."Shipment Date", NewDate) then                    TransLine.Validate("Shipment Date", NewDate);            AvailabilityType::Variant:                if ItemAvailabilityFormsMgt.ShowItemAvailabilityByVariant(Item, GetFieldCaption(TransLine.FieldCaption(TransLine."Variant Code")), TransLine."Variant Code", NewVariantCode) then                    TransLine.Validate("Variant Code", NewVariantCode);            AvailabilityType::Location:                ItemAvailabilityFormsMgt.ShowItemAvailabilityByLocation(Item, '', TransLine."Transfer-from Code", NewLocationCode);            AvailabilityType::"Event":                if ItemAvailabilityFormsMgt.ShowItemAvailabilityByEvent(Item, GetFieldCaption(TransLine.FieldCaption(TransLine."Shipment Date")), TransLine."Shipment Date", NewDate, false) then                    TransLine.Validate("Shipment Date", NewDate);            AvailabilityType::BOM:                if ItemAvailabilityFormsMgt.ShowItemAvailabilityByBOMLevel(Item, GetFieldCaption(TransLine.FieldCaption(TransLine."Shipment Date")), TransLine."Shipment Date", NewDate) then                    TransLine.Validate("Shipment Date", NewDate);            AvailabilityType::UOM:                if ItemAvailabilityFormsMgt.ShowItemAvailabilityByUOM(Item, GetFieldCaption(TransLine.FieldCaption(TransLine."Unit of Measure Code")), TransLine."Unit of Measure Code", NewUnitOfMeasureCode) then                    TransLine.Validate("Unit of Measure Code", NewUnitOfMeasureCode);        end;    end;    local procedure GetFieldCaption(FieldCaption: Text): Text[80]    begin        exit(CopyStr(FieldCaption, 1, 80));    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeShowItemAvailabilityFromTransLine(var Item: Record Item; var TransLine: Record "Transfer Line"; AvailabilityType: Enum "Item Availability Type")    begin    end;    procedure ShowTransLines(var Item: Record Item; What: Integer)    var        TransLine: Record "Transfer Line";    begin        case What of            Item.FieldNo("Trans. Ord. Shipment (Qty.)"):                TransLine.FindLinesWithItemToPlan(Item, false, false);            Item.FieldNo("Qty. in Transit"),          Item.FieldNo("Trans. Ord. Receipt (Qty.)"):                TransLine.FindLinesWithItemToPlan(Item, true, false);        end;        PAGE.Run(0, TransLine);    end;    // Codeunit "Calc. Inventory Page Data"    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Calc. Inventory Page Data", 'OnTransferToPeriodDetailsElseCase', '', false, false)]    local procedure OnTransferToPeriodDetailsElseCase(var InventoryPageData: Record "Inventory Page Data"; InventoryEventBuffer: Record "Inventory Event Buffer"; SourceType: Integer; SourceSubtype: Integer; SourceID: Code[20]; var IsHandled: Boolean; SourceRefNo: Integer)    begin        if SourceType = Database::"Transfer Line" then begin            TransferTransLine(InventoryEventBuffer, InventoryPageData, SourceType, SourceSubtype, SourceID);            IsHandled := true;        end;    end;    local procedure TransferTransLine(InventoryEventBuffer: Record "Inventory Event Buffer"; var InventoryPageData: Record "Inventory Page Data"; SourceType: Integer; SourceSubtype: Integer; SourceID: Code[20])    var        TransHeader: Record "Transfer Header";        RecRef: RecordRef;    begin        TransHeader.Get(SourceID);        RecRef.GetTable(TransHeader);        InventoryPageData."Source Document ID" := RecRef.RecordId;        InventoryPageData."Document No." := TransHeader."No.";        case SourceSubtype of            0:                case InventoryEventBuffer.Type of                    InventoryEventBuffer.Type::Transfer:                        begin                            // Outbound Transfer                            InventoryPageData.Type := InventoryPageData.Type::Transfer;                            InventoryPageData.Description := TransHeader."Transfer-to Name";                            InventoryPageData.Source := StrSubstNo(TransferDocumentTxt, Format(TransHeader."Transfer-to Code"));                            InventoryPageData."Gross Requirement" := InventoryEventBuffer."Remaining Quantity (Base)";                            InventoryPageData."Reserved Requirement" := InventoryEventBuffer."Reserved Quantity (Base)";                        end;                    InventoryEventBuffer.Type::"Plan Revert":                        begin                            InventoryPageData.Type := InventoryPageData.Type::"Plan Revert";                            InventoryPageData.Description := TransHeader."Transfer-to Name";                            InventoryPageData.Source := PlanRevertTxt;                            InventoryPageData."Action Message Qty." := InventoryEventBuffer."Remaining Quantity (Base)";                            InventoryPageData."Action Message" := InventoryEventBuffer."Action Message";                        end;                end;            1:                begin                    // Inbound Transfer                    InventoryPageData.Type := InventoryPageData.Type::Transfer;                    InventoryPageData.Description := TransHeader."Transfer-from Name";                    InventoryPageData.Source := StrSubstNo(TransferDocumentTxt, Format(TransHeader."Transfer-from Code"));                    InventoryPageData."Scheduled Receipt" := InventoryEventBuffer."Remaining Quantity (Base)";                    InventoryPageData."Reserved Receipt" := InventoryEventBuffer."Reserved Quantity (Base)";                end;            else                Error(UnsupportedEntitySourceErr, SourceType, SourceSubtype);        end;        OnAfterTransferTransLine(InventoryPageData, TransHeader);    end;    [IntegrationEvent(false, false)]    local procedure OnAfterTransferTransLine(var InventoryPageData: Record "Inventory Page Data"; var TransferHeader: Record "Transfer Header")    begin    end;    // Page "Item Availability Line List"    [EventSubscriber(ObjectType::Page, Page::"Item Availability Line List", 'OnAfterMakeEntries', '', false, false)]    local procedure OnAfterMakeEntries(var Item: Record Item; var ItemAvailabilityLine: Record "Item Availability Line"; AvailabilityType: Option "Gross Requirement","Planned Order Receipt","Scheduled Order Receipt","Planned Order Release",All; Sign: Decimal; QtyByUnitOfMeasure: Decimal)    begin        case AvailabilityType of            AvailabilityType::"Gross Requirement":                ItemAvailabilityLine.InsertEntry(                    Database::"Transfer Line", Item.FieldNo("Trans. Ord. Shipment (Qty.)"),                    Item.FieldCaption("Trans. Ord. Shipment (Qty.)"), Item."Trans. Ord. Shipment (Qty.)", QtyByUnitOfMeasure, Sign);            AvailabilityType::"Scheduled Order Receipt":                begin                    ItemAvailabilityLine.InsertEntry(                      Database::"Transfer Line", Item.FieldNo("Qty. in Transit"),                      Item.FieldCaption("Qty. in Transit"), Item."Qty. in Transit", QtyByUnitOfMeasure, Sign);                    ItemAvailabilityLine.InsertEntry(                      Database::"Transfer Line", Item.FieldNo("Trans. Ord. Receipt (Qty.)"),                      Item.FieldCaption("Trans. Ord. Receipt (Qty.)"), Item."Trans. Ord. Receipt (Qty.)", QtyByUnitOfMeasure, Sign);                end;        end;    end;    [EventSubscriber(ObjectType::Page, Page::"Item Availability Line List", 'OnAfterLookupEntries', '', false, false)]    local procedure OnAfterLookupEntries(var Item: Record Item; ItemAvailabilityLine: Record "Item Availability Line");    var        TransferLine: Record "Transfer Line";    begin        case ItemAvailabilityLine."Table No." of            Database::"Transfer Line":                begin                    case ItemAvailabilityLine.QuerySource of                        Item.FieldNo("Trans. Ord. Shipment (Qty.)"):                            TransferLine.FindLinesWithItemToPlan(Item, false, false);                        Item.FieldNo("Trans. Ord. Receipt (Qty.)"), Item.FieldNo("Qty. in Transit"):                            TransferLine.FindLinesWithItemToPlan(Item, true, false);                    end;                    PAGE.RunModal(0, TransferLine);                end;        end;    end;    // Table "Inventory Event Buffer"    procedure TransferFromOutboundTransOrder(var InventoryEventBuffer: Record "Inventory Event Buffer"; TransLine: Record "Transfer Line")    var        RecRef: RecordRef;    begin        InventoryEventBuffer.Init();        RecRef.GetTable(TransLine);        InventoryEventBuffer."Source Line ID" := RecRef.RecordId;        InventoryEventBuffer."Item No." := TransLine."Item No.";        InventoryEventBuffer."Variant Code" := TransLine."Variant Code";        InventoryEventBuffer."Location Code" := TransLine."Transfer-from Code";        InventoryEventBuffer."Availability Date" := TransLine."Shipment Date";        InventoryEventBuffer.Type := InventoryEventBuffer.Type::Transfer;        TransLine.CalcFields("Reserved Qty. Outbnd. (Base)");        InventoryEventBuffer."Remaining Quantity (Base)" := -TransLine."Outstanding Qty. (Base)";        InventoryEventBuffer."Reserved Quantity (Base)" := -TransLine."Reserved Qty. Outbnd. (Base)";        InventoryEventBuffer.Positive := not (InventoryEventBuffer."Remaining Quantity (Base)" < 0);        InventoryEventBuffer."Transfer Direction" := InventoryEventBuffer."Transfer Direction"::Outbound;        OnAfterTransferFromOutboundTransfer(InventoryEventBuffer, TransLine);    end;    procedure TransferFromInboundTransOrder(var InventoryEventBuffer: Record "Inventory Event Buffer"; TransLine: Record "Transfer Line")    var        RecRef: RecordRef;    begin        InventoryEventBuffer.Init();        RecRef.GetTable(TransLine);        InventoryEventBuffer."Source Line ID" := RecRef.RecordId;        InventoryEventBuffer."Item No." := TransLine."Item No.";        InventoryEventBuffer."Variant Code" := TransLine."Variant Code";        InventoryEventBuffer."Location Code" := TransLine."Transfer-to Code";        InventoryEventBuffer."Availability Date" := TransLine."Receipt Date";        InventoryEventBuffer.Type := InventoryEventBuffer.Type::Transfer;        TransLine.CalcFields("Reserved Qty. Inbnd. (Base)", "Reserved Qty. Shipped (Base)");        InventoryEventBuffer."Remaining Quantity (Base)" := TransLine."Quantity (Base)" - TransLine."Qty. Received (Base)";        InventoryEventBuffer."Reserved Quantity (Base)" := TransLine."Reserved Qty. Inbnd. (Base)" + TransLine."Reserved Qty. Shipped (Base)";        InventoryEventBuffer.Positive := not (InventoryEventBuffer."Remaining Quantity (Base)" < 0);        InventoryEventBuffer."Transfer Direction" := InventoryEventBuffer."Transfer Direction"::Inbound;        OnAfterTransferFromInboundTransOrder(InventoryEventBuffer, TransLine);    end;    [IntegrationEvent(false, false)]    local procedure OnAfterTransferFromOutboundTransfer(var InventoryEventBuffer: Record "Inventory Event Buffer"; TransferLine: Record "Transfer Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterTransferFromInboundTransOrder(var InventoryEventBuffer: Record "Inventory Event Buffer"; TransferLine: Record Microsoft.Inventory.Transfer."Transfer Line")    begin    end;}