Table 99000853 Inventory Profile

Base Application, Microsoft.Inventory.Tracking

src/Layers/W1/BaseApp/Inventory/Tracking/InventoryProfile.Table.al930 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.Tracking;using Microsoft.Foundation.Enums;using Microsoft.Foundation.UOM;using Microsoft.Inventory.Item;using Microsoft.Inventory.Ledger;using Microsoft.Inventory.Location;using Microsoft.Inventory.Requisition;using Microsoft.Inventory.Transfer;using Microsoft.Sales.Customer;using Microsoft.Warehouse.Request;using Microsoft.Warehouse.Structure;table 99000853 "Inventory Profile"{    Caption = 'Inventory Profile';    DataClassification = CustomerContent;    fields    {        field(3; "Line No."; Integer)        {            Caption = 'Line No.';        }        field(4; "Attribute Priority"; Integer)        {            Caption = 'Attribute Priority';        }        field(5; "Order Priority"; Integer)        {            Caption = 'Order Priority';        }        field(11; "Item No."; Code[20])        {            Caption = 'Item No.';            TableRelation = Item;        }        field(12; "Variant Code"; Code[10])        {            Caption = 'Variant Code';            TableRelation = "Item Variant".Code where("Item No." = field("Item No."),                                                       Code = field("Variant Code"));        }        field(13; "Location Code"; Code[10])        {            Caption = 'Location Code';            TableRelation = Location;        }        field(14; "Bin Code"; Code[20])        {            Caption = 'Bin Code';            TableRelation = Bin.Code where("Location Code" = field("Location Code"));        }        field(15; IsSupply; Boolean)        {            Caption = 'IsSupply';        }        field(16; "Order Relation"; Option)        {            Caption = 'Order Relation';            OptionCaption = 'Normal,Safety Stock,Reorder Point';            OptionMembers = Normal,"Safety Stock","Reorder Point";        }        field(21; "Source Type"; Integer)        {            Caption = 'Source Type';        }        field(22; "Source Order Status"; Integer)        {            Caption = 'Source Order Status';        }        field(23; "Source ID"; Code[20])        {            Caption = 'Source ID';        }        field(24; "Source Batch Name"; Code[10])        {            Caption = 'Source Batch Name';        }        field(25; "Source Ref. No."; Integer)        {            Caption = 'Source Ref. No.';        }        field(26; "Source Prod. Order Line"; Integer)        {            Caption = 'Source Prod. Order Line';        }        field(27; "Primary Order Status"; Integer)        {            Caption = 'Primary Order Status';        }        field(28; "Primary Order No."; Code[20])        {            Caption = 'Primary Order No.';        }        field(29; "Primary Order Line"; Integer)        {            Caption = 'Primary Order Line';        }        field(30; "Primary Order Type"; Integer)        {            Caption = 'Primary Order Type';        }        field(31; "Original Quantity"; Decimal)        {            AutoFormatType = 0;            Caption = 'Original Quantity';            DecimalPlaces = 0 : 5;        }        field(32; "Remaining Quantity (Base)"; Decimal)        {            AutoFormatType = 0;            Caption = 'Remaining Quantity (Base)';            DecimalPlaces = 0 : 5;        }        field(33; "Untracked Quantity"; Decimal)        {            AutoFormatType = 0;            Caption = 'Untracked Quantity';            DecimalPlaces = 0 : 5;        }        field(34; "Original Due Date"; Date)        {            Caption = 'Original Due Date';        }        field(35; "Due Date"; Date)        {            Caption = 'Due Date';        }        field(36; "Planning Flexibility"; Enum "Inventory Planning Flexibility")        {            Caption = 'Planning Flexibility';        }        field(37; "Fixed Date"; Date)        {            Caption = 'Fixed Date';        }        field(38; "Action Message"; Enum "Action Message Type")        {            Caption = 'Action Message';        }        field(39; Binding; Enum "Reservation Binding")        {            Caption = 'Binding';            Editable = false;        }        field(40; "Quantity (Base)"; Decimal)        {            AutoFormatType = 0;            Caption = 'Quantity (Base)';            DecimalPlaces = 0 : 5;        }        field(41; "Min. Quantity"; Decimal)        {            AutoFormatType = 0;            Caption = 'Min. Quantity';            DecimalPlaces = 0 : 5;        }        field(42; "Starting Date"; Date)        {            Caption = 'Starting Date';        }        field(43; "Planning Line No."; Integer)        {            Caption = 'Planning Line No.';        }        field(44; "Unit of Measure Code"; Code[10])        {            Caption = 'Unit of Measure Code';        }        field(45; "Qty. per Unit of Measure"; Decimal)        {            AutoFormatType = 0;            Caption = 'Qty. per Unit of Measure';            DecimalPlaces = 0 : 5;        }        field(46; Quantity; Decimal)        {            AutoFormatType = 0;            Caption = 'Quantity';            DecimalPlaces = 0 : 5;        }        field(47; "Remaining Quantity"; Decimal)        {            AutoFormatType = 0;            Caption = 'Remaining Quantity';            DecimalPlaces = 0 : 5;        }        field(48; "Finished Quantity"; Decimal)        {            AutoFormatType = 0;            Caption = 'Finished Quantity';            DecimalPlaces = 0 : 5;        }        field(50; "Planning Level Code"; Integer)        {            Caption = 'Planning Level Code';            Editable = false;        }        field(51; "Planning Line Phase"; Option)        {            Caption = 'Planning Line Phase';            OptionCaption = ' ,Line Created,Routing Created,Exploded';            OptionMembers = " ","Line Created","Routing Created",Exploded;        }        field(52; "Due Time"; Time)        {            Caption = 'Due Time';        }        field(53; "Sell-to Customer No."; Code[20])        {            Caption = 'Sell-to Customer No.';            TableRelation = Customer;        }        field(54; "Drop Shipment"; Boolean)        {            Caption = 'Drop Shipment';        }        field(55; "Special Order"; Boolean)        {            Caption = 'Special Order';        }        field(56; "Ref. Order No."; Code[20])        {            Caption = 'Ref. Order No.';            Editable = false;        }        field(57; "Ref. Line No."; Integer)        {            BlankZero = true;            Caption = 'Ref. Line No.';            Editable = false;        }        field(58; "Derived from Blanket Order"; Boolean)        {            Caption = 'Derived from Blanket Order';        }        field(59; "Ref. Blanket Order No."; Code[20])        {            Caption = 'Ref. Blanket Order No.';        }        field(60; "Tracking Reference"; Integer)        {            Caption = 'Tracking Reference';        }        field(61; "Lot No."; Code[50])        {            Caption = 'Lot No.';        }        field(62; "Serial No."; Code[50])        {            Caption = 'Serial No.';        }        field(63; "Max. Quantity"; Decimal)        {            AutoFormatType = 0;            Caption = 'Max. Quantity';            DecimalPlaces = 0 : 5;        }        field(64; "Safety Stock Quantity"; Decimal)        {            AutoFormatType = 0;            Caption = 'Safety Stock Quantity';            DecimalPlaces = 0 : 5;        }        field(65; "Is Exception Order"; Boolean)        {            Caption = 'Is Exception Order';        }        field(66; "Transfer Location Not Planned"; Boolean)        {            Caption = 'Transfer Location Not Planned';        }        field(67; "Expiration Date"; Date)        {            Caption = 'Expiration Date';            Editable = false;        }        field(68; "Ref. Order Type"; Enum "Requisition Ref. Order Type")        {            Caption = 'Ref. Order Type';            Editable = false;        }        field(69; "Disallow Cancellation"; Boolean)        {            Caption = 'Disallow Cancellation';        }        field(70; "MPS Order"; Boolean)        {            Caption = 'MPS Order';        }        field(6515; "Package No."; Code[50])        {            Caption = 'Package No.';            CaptionClass = '6,1';        }    }    keys    {        key(Key1; "Line No.")        {            Clustered = true;        }        key(Key2; "Item No.", "Variant Code", "Location Code", "Due Date", "Attribute Priority", "Order Priority")        {        }        key(Key3; "Item No.", "Variant Code", "Location Code", IsSupply, "Primary Order Status", "Primary Order No.", "Due Date", "Order Priority")        {        }        key(Key4; "Source Type", "Source Order Status", "Source ID", "Source Batch Name", "Source Ref. No.", "Source Prod. Order Line", IsSupply, "Due Date")        {        }    }    fieldgroups    {    }    var        UnitofMeasureManagement: Codeunit "Unit of Measure Management";#pragma warning disable AA0470        IncorrectSourceTypeErr: Label 'Tab99000853, TransferToTrackingEntry: Illegal Source Type: %1.';#pragma warning restore AA0470    procedure TransferFromItemLedgerEntry(var ItemLedgerEntry: Record "Item Ledger Entry"; var TrackingReservationEntry: Record "Reservation Entry")    var        ReservationEntry: Record "Reservation Entry";        AutoReservedQty: Decimal;    begin        "Source Type" := Database::"Item Ledger Entry";        "Source Ref. No." := ItemLedgerEntry."Entry No.";        "Item No." := ItemLedgerEntry."Item No.";        "Variant Code" := ItemLedgerEntry."Variant Code";        "Location Code" := ItemLedgerEntry."Location Code";        Quantity := ItemLedgerEntry.Quantity;        "Remaining Quantity" := ItemLedgerEntry."Remaining Quantity";        "Finished Quantity" := Quantity - "Remaining Quantity";        "Quantity (Base)" := ItemLedgerEntry.Quantity;        "Remaining Quantity (Base)" := ItemLedgerEntry."Remaining Quantity";        ItemLedgerEntry.CalcFields("Reserved Quantity");        ItemLedgerEntry.SetReservationFilters(ReservationEntry);        AutoReservedQty := TransferBindings(ReservationEntry, TrackingReservationEntry);        "Untracked Quantity" := ItemLedgerEntry."Remaining Quantity" - ItemLedgerEntry."Reserved Quantity" + AutoReservedQty;        "Unit of Measure Code" := ItemLedgerEntry."Unit of Measure Code";        "Qty. per Unit of Measure" := 1;        IsSupply := ItemLedgerEntry.Positive;        "Due Date" := ItemLedgerEntry."Posting Date";        CopyTrackingFromItemLedgEntry(ItemLedgerEntry);        if TrackingExists() then            "Tracking Reference" := "Line No.";        "Planning Flexibility" := "Planning Flexibility"::None;        OnAfterTransferFromItemLedgerEntry(Rec, ItemLedgerEntry);    end;    procedure CalcReservedQty(var ReservationEntry: Record "Reservation Entry"; var ReservedQty: Decimal)    var        OppositeReservationEntry: Record "Reservation Entry";        IsHandled: Boolean;    begin        ReservationEntry.SetCurrentKey(          "Source ID", "Source Ref. No.", "Source Type", "Source Subtype", "Source Batch Name", "Source Prod. Order Line",          "Reservation Status");        ReservationEntry.SetRange("Reservation Status", ReservationEntry."Reservation Status"::Reservation);        ReservationEntry.SetRange(Binding, ReservationEntry.Binding::"Order-to-Order");        IsHandled := false;        OnCalcReservedQtyOnBeforeReservationEntryLoop(ReservationEntry, ReservedQty, IsHandled);        if not IsHandled then            if ReservationEntry.Find('-') then begin                // Retrieving information about primary order:                if ReservationEntry.Positive then                    OppositeReservationEntry.Get(ReservationEntry."Entry No.", not ReservationEntry.Positive)                else                    OppositeReservationEntry := ReservationEntry;                if "Primary Order No." = '' then begin                    "Primary Order Type" := OppositeReservationEntry."Source Type";                    "Primary Order Status" := OppositeReservationEntry."Source Subtype";                    "Primary Order No." := OppositeReservationEntry."Source ID";                    if OppositeReservationEntry."Source Type" = 5407 then // Database::"Prod. Order Component"                        "Primary Order Line" := OppositeReservationEntry."Source Prod. Order Line";                end;                Binding := ReservationEntry.Binding;                repeat                    ReservedQty := ReservedQty + ReservationEntry."Quantity (Base)";                until ReservationEntry.Next() = 0;            end;    end;    procedure TransferFromOutboundTransfPlan(var RequisitionLine: Record "Requisition Line"; var TrackingReservationEntry: Record "Reservation Entry")    var        ReservationEntry: Record "Reservation Entry";        AutoReservedQty: Decimal;    begin        RequisitionLine.TestField(Type, RequisitionLine.Type::Item);        SetSource(          Database::"Requisition Line", 1, RequisitionLine."Worksheet Template Name", RequisitionLine."Line No.",          RequisitionLine."Journal Batch Name", 0);        "Item No." := RequisitionLine."No.";        "Variant Code" := RequisitionLine."Variant Code";        "Location Code" := RequisitionLine."Transfer-from Code";        "Bin Code" := RequisitionLine."Bin Code";        RequisitionLine.CalcFields("Reserved Qty. (Base)");        RequisitionLine.SetReservationFilters(ReservationEntry);        AutoReservedQty := TransferBindings(ReservationEntry, TrackingReservationEntry);        "Untracked Quantity" := RequisitionLine."Quantity (Base)" - RequisitionLine."Reserved Qty. (Base)" + AutoReservedQty;        "Min. Quantity" := RequisitionLine."Reserved Qty. (Base)" - AutoReservedQty;        Quantity := RequisitionLine.Quantity;        "Finished Quantity" := 0;        "Remaining Quantity" := RequisitionLine.Quantity;        "Quantity (Base)" := RequisitionLine."Quantity (Base)";        "Remaining Quantity (Base)" := RequisitionLine."Quantity (Base)";        "Unit of Measure Code" := RequisitionLine."Unit of Measure Code";        "Qty. per Unit of Measure" := RequisitionLine."Qty. per Unit of Measure";        IsSupply := "Untracked Quantity" <= 0;        "Due Date" := RequisitionLine."Transfer Shipment Date";        OnAfterTransferFromOutboundTransfPlan(Rec, RequisitionLine);    end;    procedure TransferFromOutboundTransfer(var TransferLine: Record "Transfer Line"; var TrackingReservationEntry: Record "Reservation Entry")    var        ReservationEntry: Record "Reservation Entry";        TempReservationEntry: Record "Reservation Entry" temporary;        CurrentInventoryProfile: Record "Inventory Profile";        TransferDirection: Enum "Transfer Direction";        AutoReservedQty: Decimal;        MinQtyInbnd: Decimal;        MinQtyOutbnd: Decimal;    begin        SetSource(Database::"Transfer Line", 0, TransferLine."Document No.", TransferLine."Line No.", '', 0);        "Item No." := TransferLine."Item No.";        "Variant Code" := TransferLine."Variant Code";        "Location Code" := TransferLine."Transfer-from Code";        TransferLine.CalcFields("Reserved Qty. Outbnd. (Base)", "Reserved Qty. Inbnd. (Base)");        TransferLine.SetReservationFilters(ReservationEntry, TransferDirection::Outbound);        AutoReservedQty := -TransferBindings(ReservationEntry, TrackingReservationEntry);        MinQtyOutbnd := TransferLine."Reserved Qty. Outbnd. (Base)" - AutoReservedQty;        CurrentInventoryProfile := Rec;        TransferLine.SetReservationFilters(ReservationEntry, TransferDirection::Inbound);        AutoReservedQty := TransferBindings(ReservationEntry, TempReservationEntry);        MinQtyInbnd := TransferLine."Reserved Qty. Inbnd. (Base)" - AutoReservedQty;        Rec := CurrentInventoryProfile;        if MinQtyInbnd > MinQtyOutbnd then            "Min. Quantity" := MinQtyInbnd        else            "Min. Quantity" := MinQtyOutbnd;        "Untracked Quantity" := TransferLine."Outstanding Qty. (Base)" - MinQtyOutbnd;        Quantity := TransferLine.Quantity;        "Remaining Quantity" := TransferLine."Outstanding Quantity";        "Finished Quantity" := TransferLine."Quantity Shipped";        "Quantity (Base)" := TransferLine."Quantity (Base)";        "Remaining Quantity (Base)" := TransferLine."Outstanding Qty. (Base)";        "Unit of Measure Code" := TransferLine."Unit of Measure Code";        "Qty. per Unit of Measure" := TransferLine."Qty. per Unit of Measure";        IsSupply := "Untracked Quantity" < 0;        "Due Date" := TransferLine."Shipment Date";        "Planning Flexibility" := TransferLine."Planning Flexibility";        OnAfterTransferFromOutboundTransfer(Rec, TransferLine);    end;    procedure TransferFromInboundTransfer(var TransferLine: Record "Transfer Line"; var TrackingReservationEntry: Record "Reservation Entry")    var        ReservationEntry: Record "Reservation Entry";        TempReservationEntry: Record "Reservation Entry" temporary;        CurrentInventoryProfile: Record "Inventory Profile";        TransferDirection: Enum "Transfer Direction";        AutoReservedQty: Decimal;        MinQtyInbnd: Decimal;        MinQtyOutbnd: Decimal;    begin        SetSource(Database::"Transfer Line", 1, TransferLine."Document No.", TransferLine."Line No.", '', TransferLine."Derived From Line No.");        "Item No." := TransferLine."Item No.";        "Variant Code" := TransferLine."Variant Code";        "Location Code" := TransferLine."Transfer-to Code";        TransferLine.CalcFields("Reserved Qty. Outbnd. (Base)", "Reserved Qty. Inbnd. (Base)");        TransferLine.SetReservationFilters(ReservationEntry, TransferDirection::Inbound);        AutoReservedQty := TransferBindings(ReservationEntry, TrackingReservationEntry);        MinQtyInbnd := TransferLine."Reserved Qty. Inbnd. (Base)" - AutoReservedQty;        CurrentInventoryProfile := Rec;        TransferLine.SetReservationFilters(ReservationEntry, TransferDirection::Outbound);        AutoReservedQty := -TransferBindings(ReservationEntry, TempReservationEntry);        MinQtyOutbnd := TransferLine."Reserved Qty. Outbnd. (Base)" - AutoReservedQty;        Rec := CurrentInventoryProfile;        if MinQtyInbnd > MinQtyOutbnd then            "Min. Quantity" := MinQtyInbnd        else            "Min. Quantity" := MinQtyOutbnd;        "Untracked Quantity" := TransferLine."Outstanding Qty. (Base)" - MinQtyInbnd;        Quantity := TransferLine.Quantity;        "Remaining Quantity" := TransferLine."Outstanding Quantity";        "Finished Quantity" := TransferLine."Quantity Received";        "Quantity (Base)" := TransferLine."Quantity (Base)";        "Remaining Quantity (Base)" := TransferLine."Outstanding Qty. (Base)";        "Unit of Measure Code" := TransferLine."Unit of Measure Code";        "Qty. per Unit of Measure" := TransferLine."Qty. per Unit of Measure";        IsSupply := "Untracked Quantity" >= 0;        "Starting Date" := TransferLine."Shipment Date";        "Due Date" := TransferLine."Receipt Date";        "Planning Flexibility" := TransferLine."Planning Flexibility";        OnAfterTransferFromInboundTransfer(Rec, TransferLine);    end;    procedure TransferBindings(var ReservationEntry: Record "Reservation Entry"; var TrackingReservationEntry: Record "Reservation Entry"): Decimal    var        OppositeReservationEntry: Record "Reservation Entry";        AutoReservedQty: Decimal;        Found: Boolean;        InsertTracking: Boolean;        IsHandled: Boolean;        Result: Decimal;    begin        IsHandled := false;        OnBeforeTransferBindings(ReservationEntry, TrackingReservationEntry, Result, IsHandled);        if IsHandled then            exit(Result);        ReservationEntry.SetCurrentKey(          "Source ID", "Source Ref. No.", "Source Type", "Source Subtype", "Source Batch Name", "Source Prod. Order Line",          "Reservation Status");        if ReservationEntry.FindSet() then            repeat                InsertTracking := not                  ((ReservationEntry."Reservation Status" = ReservationEntry."Reservation Status"::Reservation) and                   (ReservationEntry.Binding = ReservationEntry.Binding::" "));                if InsertTracking and ReservationEntry.TrackingExists() and                   (ReservationEntry."Source Type" <> Database::"Item Ledger Entry")                then begin                    TrackingReservationEntry := ReservationEntry;                    TrackingReservationEntry.Insert();                end;                if (ReservationEntry."Reservation Status" = ReservationEntry."Reservation Status"::Reservation) or                    (ReservationEntry."Reservation Status" = ReservationEntry."Reservation Status"::Tracking)                then                    if (ReservationEntry.Binding = ReservationEntry.Binding::"Order-to-Order")                    then begin                        if ReservationEntry."Reservation Status" = ReservationEntry."Reservation Status"::Reservation then                            AutoReservedQty := AutoReservedQty + ReservationEntry."Quantity (Base)";                        if not Found then begin                            if ReservationEntry.Positive then                                OppositeReservationEntry.Get(ReservationEntry."Entry No.", not ReservationEntry.Positive)                            else                                OppositeReservationEntry := ReservationEntry;                            if "Primary Order No." = '' then begin                                "Primary Order Type" := OppositeReservationEntry."Source Type";                                "Primary Order Status" := OppositeReservationEntry."Source Subtype";                                "Primary Order No." := OppositeReservationEntry."Source ID";                                if OppositeReservationEntry."Source Type" <> 5407 then // Database::"Prod. Order Component"                                    "Primary Order Line" := OppositeReservationEntry."Source Ref. No."                                else                                    "Primary Order Line" := OppositeReservationEntry."Source Prod. Order Line";                            end;                            OnTransferBindingsOnAfterAssignPrimaryOrderInfo(Rec, OppositeReservationEntry);                            Binding := ReservationEntry.Binding;                            "Disallow Cancellation" := ReservationEntry."Disallow Cancellation";                            Found := true;                        end;                    end else                        if (ReservationEntry."Reservation Status" = ReservationEntry."Reservation Status"::Reservation) and                           (("Fixed Date" = 0D) or ("Fixed Date" > ReservationEntry."Shipment Date"))                        then                            "Fixed Date" := ReservationEntry."Shipment Date";            until ReservationEntry.Next() = 0;        exit(AutoReservedQty);    end;    procedure TransferQtyFromItemTrgkEntry(var TrackingReservationEntry: Record "Reservation Entry")    begin        "Original Quantity" := 0;        Quantity := TrackingReservationEntry.Quantity;        "Quantity (Base)" := TrackingReservationEntry."Quantity (Base)";        "Finished Quantity" := 0;        "Min. Quantity" := 0;        "Remaining Quantity" := TrackingReservationEntry.Quantity;        "Remaining Quantity (Base)" := TrackingReservationEntry."Quantity (Base)";        "Untracked Quantity" := TrackingReservationEntry."Quantity (Base)";        if not IsSupply then            ChangeSign();        OnAfterTransferQtyFromItemTrgkEntry(Rec, TrackingReservationEntry);    end;    procedure ReduceQtyByItemTracking(var NewInventoryProfile: Record "Inventory Profile")    begin        "Original Quantity" -= NewInventoryProfile."Original Quantity";        Quantity -= NewInventoryProfile.Quantity;        "Quantity (Base)" -= NewInventoryProfile."Quantity (Base)";        "Finished Quantity" -= NewInventoryProfile."Finished Quantity";        "Remaining Quantity" -= NewInventoryProfile."Remaining Quantity";        "Remaining Quantity (Base)" -= NewInventoryProfile."Remaining Quantity (Base)";        "Untracked Quantity" -= NewInventoryProfile."Untracked Quantity";        OnAfterReduceQtyByItemTracking(Rec, NewInventoryProfile);    end;    procedure ChangeSign()    begin        "Original Quantity" := -"Original Quantity";        "Remaining Quantity (Base)" := -"Remaining Quantity (Base)";        "Untracked Quantity" := -"Untracked Quantity";        "Quantity (Base)" := -"Quantity (Base)";        Quantity := -Quantity;        "Remaining Quantity" := -"Remaining Quantity";        "Finished Quantity" := -"Finished Quantity";        OnAfterChangeSign(Rec);    end;    procedure TransferToTrackingEntry(var TrackingReservationEntry: Record "Reservation Entry"; UseSecondaryFields: Boolean)    var        IsHandled: Boolean;    begin        case "Source Type" of            0:                begin                    // Surplus, Reorder Point                    TrackingReservationEntry."Reservation Status" := TrackingReservationEntry."Reservation Status"::Surplus;                    TrackingReservationEntry."Suppressed Action Msg." := true;                    exit;                end;            Database::Microsoft.Manufacturing.Forecast."Production Forecast Entry":                begin                    // Will be marked as Surplus                    TrackingReservationEntry."Reservation Status" := TrackingReservationEntry."Reservation Status"::Surplus;                    TrackingReservationEntry.SetSource(Database::Microsoft.Manufacturing.Forecast."Production Forecast Entry", 0, "Source ID", 0, '', 0);                    TrackingReservationEntry."Suppressed Action Msg." := true;                end;            Database::"Item Ledger Entry":                TrackingReservationEntry.SetSource(                  Database::"Item Ledger Entry", 0, '', "Source Ref. No.", '', 0);            Database::"Transfer Line":                if IsSupply then                    TrackingReservationEntry.SetSource(Database::"Transfer Line", 1, "Source ID", "Source Ref. No.", '', "Source Prod. Order Line")                else                    TrackingReservationEntry.SetSource(Database::"Transfer Line", 0, "Source ID", "Source Ref. No.", '', 0);            else begin                IsHandled := false;                OnTransferToTrackingEntrySourceTypeElseCase(Rec, TrackingReservationEntry, UseSecondaryFields, IsHandled);                if not IsHandled then                    Error(IncorrectSourceTypeErr, "Source Type");            end;        end;        TrackingReservationEntry."Item No." := "Item No.";        TrackingReservationEntry."Location Code" := "Location Code";        TrackingReservationEntry.Description := '';        TrackingReservationEntry."Creation Date" := Today;        TrackingReservationEntry."Created By" := CopyStr(UserId(), 1, 50);        TrackingReservationEntry."Qty. per Unit of Measure" := "Qty. per Unit of Measure";        TrackingReservationEntry."Variant Code" := "Variant Code";        TrackingReservationEntry.Binding := Binding;        TrackingReservationEntry."Disallow Cancellation" := "Disallow Cancellation";        TrackingReservationEntry.CopyTrackingFromInvtProfile(Rec);        TrackingReservationEntry."Expiration Date" := "Expiration Date";        if IsSupply then            TrackingReservationEntry."Quantity (Base)" := "Untracked Quantity"        else            TrackingReservationEntry."Quantity (Base)" := -"Untracked Quantity";        TrackingReservationEntry.Quantity :=          Round(TrackingReservationEntry."Quantity (Base)" / TrackingReservationEntry."Qty. per Unit of Measure", UnitofMeasureManagement.QtyRndPrecision());        TrackingReservationEntry.Positive := TrackingReservationEntry."Quantity (Base)" > 0;        if TrackingReservationEntry."Reservation Status" <> TrackingReservationEntry."Reservation Status"::Surplus then            if ("Planning Level Code" > 0) or               (Binding = Binding::"Order-to-Order")            then                TrackingReservationEntry."Reservation Status" := TrackingReservationEntry."Reservation Status"::Reservation            else                TrackingReservationEntry."Reservation Status" := TrackingReservationEntry."Reservation Status"::Tracking;        if TrackingReservationEntry."Quantity (Base)" = 0 then begin            TrackingReservationEntry."Expected Receipt Date" := GetExpectedReceiptDate();            TrackingReservationEntry."Shipment Date" := "Due Date";        end else            if TrackingReservationEntry.Positive then                TrackingReservationEntry."Expected Receipt Date" := GetExpectedReceiptDate()            else                TrackingReservationEntry."Shipment Date" := "Due Date";        OnAfterTransferToTrackingEntry(TrackingReservationEntry, Rec, UseSecondaryFields);    end;    procedure ActiveInWarehouse(): Boolean    var        WhseValidateSourceLine: Codeunit "Whse. Validate Source Line";    begin        if "Source Type" = Database::"Transfer Line" then            exit(WhseValidateSourceLine.WhseLinesExist("Source Type", 0, "Source ID", "Source Ref. No.", 0, Quantity));        exit(            WhseValidateSourceLine.WhseLinesExist("Source Type", "Source Order Status", "Source ID", "Source Ref. No.", 0, Quantity) or            WhseValidateSourceLine.WhseWorkSheetLinesExistForJobOrProdOrderComponent("Source Type", "Source Order Status", "Source ID", "Source Ref. No.", 0, Quantity));    end;    local procedure GetExpectedReceiptDate(): Date    begin        if "Action Message" in ["Action Message"::Reschedule, "Action Message"::"Resched. & Chg. Qty."] then            exit("Original Due Date");        exit("Due Date");    end;    procedure SetSource(SourceType: Integer; SourceSubtype: Integer; SourceID: Code[20]; SourceRefNo: Integer; SourceBatchName: Code[10]; SourceProdOrderLine: Integer)    begin        "Source Type" := SourceType;        "Source Order Status" := SourceSubtype;        "Source ID" := SourceID;        "Source Ref. No." := SourceRefNo;        "Source Batch Name" := SourceBatchName;        "Source Prod. Order Line" := SourceProdOrderLine;    end;    procedure SetSourceFilter(SourceType: Integer; SourceSubtype: Integer; SourceID: Code[20]; SourceRefNo: Integer; SourceBatchName: Code[10]; SourceProdOrderLine: Integer)    begin        SetRange("Source Type", SourceType);        SetRange("Source Order Status", SourceSubtype);        SetRange("Source ID", SourceID);        SetRange("Source Ref. No.", SourceRefNo);        SetRange("Source Batch Name", SourceBatchName);        SetRange("Source Prod. Order Line", SourceProdOrderLine);    end;    procedure SetSourceTypeFilter(SourceType: Integer)    var        SourceTypeFilter: Text;    begin        SourceTypeFilter := Rec.GetFilter("Source Type");        if SourceTypeFilter = '' then            SetFilter("Source Type", '%1', SourceType)        else begin            SourceTypeFilter += StrSubstNo('|%1', SourceType);            SetFilter("Source Type", SourceTypeFilter);        end;    end;    procedure CopyTrackingFromItemLedgEntry(ItemLedgerEntry: Record "Item Ledger Entry")    begin        "Serial No." := ItemLedgerEntry."Serial No.";        "Lot No." := ItemLedgerEntry."Lot No.";        OnAfterCopyTrackingFromItemLedgEntry(Rec, ItemLedgerEntry);    end;    procedure CopyTrackingFromInvtProfile(InventoryProfile: Record "Inventory Profile")    begin        "Serial No." := InventoryProfile."Serial No.";        "Lot No." := InventoryProfile."Lot No.";        OnAfterCopyTrackingFromInvtProfile(Rec, InventoryProfile);    end;    procedure CopyTrackingFromReservEntry(ReservationEntry: Record "Reservation Entry")    begin        "Serial No." := ReservationEntry."Serial No.";        "Lot No." := ReservationEntry."Lot No.";        OnAfterCopyTrackingFromReservEntry(Rec, ReservationEntry);    end;    procedure SetTrackingFilter(InventoryProfile: Record "Inventory Profile")    begin        if InventoryProfile."Serial No." <> '' then            SetRange("Serial No.", InventoryProfile."Serial No.")        else            SetRange("Serial No.");        if InventoryProfile."Lot No." <> '' then            SetRange("Lot No.", InventoryProfile."Lot No.")        else            SetRange("Lot No.");        OnAfterSetTrackingFilter(Rec, InventoryProfile);    end;    procedure SetTrackingFilterFromInvtProfile(InventoryProfile: Record "Inventory Profile")    begin        SetRange("Lot No.", InventoryProfile."Lot No.");        SetRange("Serial No.", InventoryProfile."Serial No.");        OnAfterSetTrackingFilterFromInvtProfile(Rec, InventoryProfile);    end;    procedure TrackingExists() IsTrackingExists: Boolean    begin        IsTrackingExists := ("Lot No." <> '') or ("Serial No." <> '');        OnAfterTrackingExists(Rec, IsTrackingExists);    end;    procedure InsertSupplyInvtProfile(ToDate: Date)    begin        if Rec.IsSupply then begin            if Rec."Due Date" > ToDate then                Rec."Planning Flexibility" := Rec."Planning Flexibility"::None;            Rec.Insert();        end else            if Rec."Due Date" <= ToDate then begin                Rec.ChangeSign();                Rec."Planning Flexibility" := Rec."Planning Flexibility"::None;                Rec.Insert();            end;    end;    [IntegrationEvent(false, false)]    local procedure OnAfterCopyTrackingFromItemLedgEntry(var InventoryProfile: Record "Inventory Profile"; ItemLedgEntry: Record "Item Ledger Entry")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterCopyTrackingFromInvtProfile(var InventoryProfile: Record "Inventory Profile"; FromInventoryProfile: Record "Inventory Profile")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterCopyTrackingFromReservEntry(var InventoryProfile: Record "Inventory Profile"; ReservEntry: Record "Reservation Entry")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterTransferFromItemLedgerEntry(var InventoryProfile: Record "Inventory Profile"; ItemLedgerEntry: Record "Item Ledger Entry")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterTransferFromInboundTransfer(var InventoryProfile: Record "Inventory Profile"; TransLine: Record "Transfer Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterTransferFromOutboundTransfPlan(var InventoryProfile: Record "Inventory Profile"; RequisitionLine: Record "Requisition Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterTransferFromOutboundTransfer(var InventoryProfile: Record "Inventory Profile"; TransferLine: Record "Transfer Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterTransferToTrackingEntry(var ReservationEntry: Record "Reservation Entry"; InventoryProfile: Record "Inventory Profile"; UseSecondaryFields: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterTrackingExists(InventoryProfile: Record "Inventory Profile"; var IsTrackingExists: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterSetTrackingFilter(var InventoryProfile: Record "Inventory Profile"; FromInventoryProfile: Record "Inventory Profile")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterSetTrackingFilterFromInvtProfile(var InventoryProfile: Record "Inventory Profile"; FromInventoryProfile: Record "Inventory Profile")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnTransferBindingsOnAfterAssignPrimaryOrderInfo(var InventoryProfile: Record "Inventory Profile"; OppositeReservEntry: Record "Reservation Entry")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnTransferToTrackingEntrySourceTypeElseCase(var InventoryProfile: Record "Inventory Profile"; var ReservationEntry: Record "Reservation Entry"; UseSecondaryFields: Boolean; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeTransferBindings(var ReservEntry: Record "Reservation Entry"; var TrackingEntry: Record "Reservation Entry"; var Result: Decimal; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCalcReservedQtyOnBeforeReservationEntryLoop(var ReservationEntry: Record "Reservation Entry"; var ReservedQty: Decimal; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterTransferQtyFromItemTrgkEntry(var InventoryProfile: Record "Inventory Profile"; TrackingReservationEntry: Record "Reservation Entry")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterReduceQtyByItemTracking(var InventoryProfile: Record "Inventory Profile"; NewInventoryProfile: Record "Inventory Profile")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterChangeSign(var InventoryProfile: Record "Inventory Profile")    begin    end;}