Codeunit 99000778 OrderTrackingManagement

Base Application, Microsoft.Foundation.Navigate

src/Layers/W1/BaseApp/Foundation/Navigate/OrderTrackingManagement.Codeunit.al763 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.Foundation.Navigate;using Microsoft.Inventory.Journal;using Microsoft.Inventory.Ledger;using Microsoft.Inventory.Planning;using Microsoft.Inventory.Requisition;using Microsoft.Inventory.Tracking;using Microsoft.Inventory.Transfer;using Microsoft.Purchases.Document;using Microsoft.Sales.Document;codeunit 99000778 OrderTrackingManagement{    Permissions = TableData "Sales Line" = r,                  TableData "Purchase Line" = r,                  TableData "Order Tracking Entry" = rimd;    trigger OnRun()    begin    end;    var#pragma warning disable AA0074        Text000: Label 'Counting records...';        Text003: Label 'CURRENT LINE';        Text004: Label 'CANCELLATION';        Text005: Label 'NON-PEGGED ';        Text006: Label 'SHIPMENT';        Text007: Label 'RECEIPT';        Text008: Label 'There are no order tracking entries for this line.';        Text009: Label 'The order tracking entries for this line have a date conflict.';#pragma warning restore AA0074        ItemLedgEntry: Record "Item Ledger Entry";        ItemLedgEntry2: Record "Item Ledger Entry";        ItemLedgEntry3: Record "Item Ledger Entry";        PurchLine: Record "Purchase Line";        ItemJnlLine: Record "Item Journal Line";        ReqLine: Record "Requisition Line";        PlanningComponent: Record "Planning Component";        ReservEntry: Record "Reservation Entry";        TempReservEntryList: Record "Reservation Entry" temporary;        TempOrderTrackingEntry: Record "Order Tracking Entry" temporary;        CreateReservEntry: Codeunit "Create Reserv. Entry";        ReservEngineMgt: Codeunit "Reservation Engine Mgt.";        CaptionText: Text;        Type: Option " ",Sales,"Req. Line",Purchase,"Item Jnl","BOM Jnl","Item Ledg. Entry","Prod. Order Line","Prod. Order Comp.","Planning Line","Planning Comp.",Transfer,"Service Order";        ID: Code[20];        BatchName: Code[20];        Subtype: Integer;        ProdOrderLineNo: Integer;        RefNo: Integer;        EntryNo: Integer;        MultipleSummedUpQty: Decimal;        SearchUp: Boolean;        IsPlanning: Boolean;        DateWarning: Boolean;        SearchUpIsSet: Boolean;        MultipleItemLedgEntries: Boolean;    procedure IsSearchUp(): Boolean    begin        exit(SearchUp);    end;    procedure GetCaption(): Text    begin        exit(CaptionText);    end;    procedure SetReqLine(var CurrentReqLine: Record "Requisition Line")    begin        ReqLine := CurrentReqLine;        ReservEntry.InitSortingAndFilters(false);        ReqLine.SetReservationFilters(ReservEntry);        CaptionText := ReqLine.GetSourceCaption();        IsPlanning := ReqLine."Planning Line Origin" <> ReqLine."Planning Line Origin"::" ";    end;    procedure SetPlanningComponent(var CurrentPlanningComponent: Record "Planning Component")    begin        PlanningComponent := CurrentPlanningComponent;        ReservEntry.InitSortingAndFilters(false);        PlanningComponent.SetReservationFilters(ReservEntry);        CaptionText := PlanningComponent.GetSourceCaption();        IsPlanning := true;    end;    procedure SetItemLedgEntry(var CurrentItemLedgEntry: Record "Item Ledger Entry")    begin        ItemLedgEntry := CurrentItemLedgEntry;        ReservEntry.InitSortingAndFilters(false);        ItemLedgEntry.SetReservationFilters(ReservEntry);        CaptionText := ItemLedgEntry.GetSourceCaption();        ItemLedgEntry2 := ItemLedgEntry;        ItemLedgEntry2.Mark(true);    end;    procedure SetMultipleItemLedgEntries(var TempItemLedgEntry: Record "Item Ledger Entry" temporary; SourceType: Integer; SourceSubtype: Integer; SourceID: Code[20]; SourceBatchName: Code[10]; SourceProdOrderLine: Integer; SourceRefNo: Integer)    var        ItemTrackingMgt: Codeunit "Item Tracking Management";    begin        // Used from posted shipment and receipt with item tracking.        ItemTrackingMgt.CollectItemEntryRelation(TempItemLedgEntry, SourceType, SourceSubtype, SourceID,          SourceBatchName, SourceProdOrderLine, SourceRefNo, 0);        TempItemLedgEntry.SetFilter("Remaining Quantity", '<>%1', 0);        if not TempItemLedgEntry.FindSet() then;        ReservEntry.InitSortingAndFilters(false);        TempItemLedgEntry.SetReservationFilters(ReservEntry);        CaptionText := TempItemLedgEntry.GetSourceCaption();        repeat            ItemLedgEntry2 := TempItemLedgEntry;            ItemLedgEntry2.Mark(true);            MultipleSummedUpQty += TempItemLedgEntry."Remaining Quantity";        until TempItemLedgEntry.Next() = 0;        MultipleItemLedgEntries := (TempItemLedgEntry.Count > 1);    end;    procedure SetSourceRecord(var SourceRecordVar: Variant)    begin        OnSetSourceRecord(SourceRecordVar, ReservEntry, CaptionText, ItemLedgEntry2);    end;    procedure TrackedQuantity(): Decimal    var        FilterReservEntry: Record "Reservation Entry";        QtyTracked1: Decimal;        QtyTracked2: Decimal;    begin        if MultipleItemLedgEntries then            exit(MultipleSummedUpQty);        ReservEntry.SetRange("Reservation Status", ReservEntry."Reservation Status"::Reservation,          ReservEntry."Reservation Status"::Tracking);        if ReservEntry.Find('-') then            repeat                QtyTracked1 += ReservEntry."Quantity (Base)";            until ReservEntry.Next() = 0;        if IsPlanning then            if DerivePlanningFilter(ReservEntry, FilterReservEntry) then begin                FilterReservEntry.SetRange("Reservation Status", FilterReservEntry."Reservation Status"::Reservation,                  FilterReservEntry."Reservation Status"::Tracking);                if FilterReservEntry.Find('-') then                    repeat                        QtyTracked2 += FilterReservEntry."Quantity (Base)";                    until FilterReservEntry.Next() = 0;                exit((QtyTracked1 + QtyTracked2) * CreateReservEntry.SignFactor(FilterReservEntry));            end;        exit(QtyTracked1 * CreateReservEntry.SignFactor(ReservEntry));    end;    procedure FindRecord(Which: Text[250]; var OrderTrackingEntry2: Record "Order Tracking Entry"): Boolean    begin        TempOrderTrackingEntry := OrderTrackingEntry2;        if not TempOrderTrackingEntry.Find(Which) then            exit(false);        OrderTrackingEntry2 := TempOrderTrackingEntry;        exit(true);    end;    procedure GetNextRecord(Steps: Integer; var OrderTrackingEntry2: Record "Order Tracking Entry") CurrentSteps: Integer    begin        TempOrderTrackingEntry := OrderTrackingEntry2;        CurrentSteps := TempOrderTrackingEntry.Next(Steps);        if CurrentSteps <> 0 then            OrderTrackingEntry2 := TempOrderTrackingEntry;        exit(CurrentSteps);    end;    procedure FindRecords(): Boolean    begin        exit(FindRecordsInner(false));    end;    procedure FindRecordsWithoutMessage(): Boolean    begin        exit(FindRecordsInner(true));    end;    local procedure FindRecordsInner(SuppressMessages: Boolean) TrackingExists: Boolean    var        Window: Dialog;    begin        OnBeforeFindRecordsInner(SuppressMessages);        TempReservEntryList.DeleteAll();        TempOrderTrackingEntry.DeleteAll();        EntryNo := 1;        if not SuppressMessages then            Window.Open(Text000);        TempOrderTrackingEntry.Init();        TempOrderTrackingEntry."Entry No." := 0;        DrillOrdersUp(ReservEntry, 1);        ItemLedgEntry2.SetCurrentKey("Entry No.");        ItemLedgEntry2.MarkedOnly(true);        if ItemLedgEntry2.Find('-') then            repeat                InsertItemLedgTrackEntry(1, ItemLedgEntry2, ItemLedgEntry2."Remaining Quantity", ItemLedgEntry2);            until ItemLedgEntry2.Next() = 0;        TrackingExists := TempOrderTrackingEntry.Find('-');        if not TrackingExists and not SuppressMessages then            Message(Text008);        if DateWarning and not SuppressMessages then            Message(Text009);        if not SuppressMessages then            Window.Close();        exit(TrackingExists);    end;    local procedure DrillOrdersUp(var ReservEntry: Record "Reservation Entry"; Level: Integer)    var        FilterReservEntry: Record "Reservation Entry";        ContinueDrillUp: Boolean;        IncludePlanningFilter: Boolean;    begin        if Level > 20 then            exit;        ReservEntry.SetRange("Reservation Status", ReservEntry."Reservation Status"::Reservation,          ReservEntry."Reservation Status"::Tracking);        if ReservEntry.Find('-') then begin            if Level = 1 then                if not SearchUpIsSet then begin                    SearchUp := not ReservEntry.Positive;                    SearchUpIsSet := true;                end;            repeat                ProcessReservEntry(ReservEntry, FilterReservEntry, ContinueDrillUp, IncludePlanningFilter, Level);            until ReservEntry.Next() = 0;        end;        if Level = 1 then            if DerivePlanningFilter(ReservEntry, FilterReservEntry) then begin                if not SearchUpIsSet then begin                    SearchUp := not FilterReservEntry.Positive;                    SearchUpIsSet := true;                end;                DrillOrdersUp(FilterReservEntry, Level);            end;        OnAfterDrillOrdersUp(TempOrderTrackingEntry, ReservEntry, Level, EntryNo, SearchUp, SearchUpIsSet);    end;    local procedure ProcessReservEntry(var ReservEntry: Record "Reservation Entry"; var FilterReservEntry: Record "Reservation Entry"; var ContinueDrillUp: Boolean; var IncludePlanningFilter: Boolean; Level: Integer)    var        ReservEntry2: Record "Reservation Entry";        ReservEntry3: Record "Reservation Entry";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeProcessReservEntry(ReservEntry, FilterReservEntry, ContinueDrillUp, IncludePlanningFilter, Level, IsHandled);        if IsHandled then            exit;        ReservEntry3.Get(ReservEntry."Entry No.", not ReservEntry.Positive);        InsertOrderTrackingEntry(ReservEntry, ReservEntry3, Level);        case ReservEntry3."Source Type" of            DATABASE::"Item Ledger Entry":                begin                    ItemLedgEntry3.Get(ReservEntry3."Source Ref. No.");                    DrillItemLedgEntries(Level + 1, ItemLedgEntry3);                end;            DATABASE::"Planning Component":                begin                    FiltersForTrackingFromComponents(ReservEntry3, ReservEntry2);                    DrillOrdersUp(ReservEntry2, Level + 1);                    if DerivePlanningFilter(ReservEntry3, FilterReservEntry) then                        DrillOrdersUp(FilterReservEntry, Level + 1);                end;            DATABASE::"Requisition Line":                begin                    FiltersForTrackingFromReqLine(ReservEntry3, ReservEntry2, SearchUp);                    DrillOrdersUp(ReservEntry2, Level + 1);                    if DerivePlanningFilter(ReservEntry3, FilterReservEntry) then                        DrillOrdersUp(FilterReservEntry, Level + 1);                end;            DATABASE::"Transfer Line":                begin                    FiltersForTrackingFromTransfer(ReservEntry3, ReservEntry2, SearchUp);                    DrillOrdersUp(ReservEntry2, Level + 1);                    if DerivePlanningFilter(ReservEntry3, FilterReservEntry) then                        DrillOrdersUp(FilterReservEntry, Level + 1);                end;            else begin                OnDrillOrdersUpCaseElse(ReservEntry3, ReservEntry2, SearchUp, ContinueDrillUp, IncludePlanningFilter);                if ContinueDrillUp then                    DrillOrdersUp(ReservEntry2, Level + 1);                if IncludePlanningFilter then                    if DerivePlanningFilter(ReservEntry3, FilterReservEntry) then                        DrillOrdersUp(FilterReservEntry, Level + 1);            end;        end;    end;    local procedure FiltersForTrackingFromComponents(FromReservationEntry: Record "Reservation Entry"; var ToReservationEntry: Record "Reservation Entry")    begin        ToReservationEntry.Reset();        ToReservationEntry.SetSourceFilter(DATABASE::"Requisition Line", 0, FromReservationEntry."Source ID", FromReservationEntry."Source Prod. Order Line", true);        ToReservationEntry.SetSourceFilter(FromReservationEntry."Source Batch Name", 0);    end;    local procedure FiltersForTrackingFromReqLine(FromReservationEntry: Record "Reservation Entry"; var ToReservationEntry: Record "Reservation Entry"; IsSearchUp: Boolean)    var        RequisitionLine: Record "Requisition Line";    begin        ToReservationEntry.Reset();        RequisitionLine.Get(FromReservationEntry."Source ID", FromReservationEntry."Source Batch Name", FromReservationEntry."Source Ref. No.");        if RequisitionLine."Replenishment System" = RequisitionLine."Replenishment System"::Transfer then begin            if IsSearchUp then                ToReservationEntry.SetSourceFilter(DATABASE::"Requisition Line", 1, FromReservationEntry."Source ID", FromReservationEntry."Source Ref. No.", true)            else                ToReservationEntry.SetSourceFilter(DATABASE::"Requisition Line", 0, FromReservationEntry."Source ID", FromReservationEntry."Source Ref. No.", true);            ToReservationEntry.SetSourceFilter(FromReservationEntry."Source Batch Name", 0);        end else begin            ToReservationEntry.SetSourceFilter(DATABASE::"Planning Component", 0, FromReservationEntry."Source ID", -1, true);            ToReservationEntry.SetSourceFilter(FromReservationEntry."Source Batch Name", FromReservationEntry."Source Ref. No.");        end;    end;    local procedure FiltersForTrackingFromTransfer(FromReservationEntry: Record "Reservation Entry"; var ToReservationEntry: Record "Reservation Entry"; IsSearchUp: Boolean)    begin        ToReservationEntry.Reset();        if IsSearchUp then            ToReservationEntry.SetSourceFilter(FromReservationEntry."Source Type", 0, FromReservationEntry."Source ID", FromReservationEntry."Source Ref. No.", true)        else            ToReservationEntry.SetSourceFilter(FromReservationEntry."Source Type", 1, FromReservationEntry."Source ID", FromReservationEntry."Source Ref. No.", true);        ToReservationEntry.SetRange("Source Batch Name", FromReservationEntry."Source Batch Name");    end;    local procedure DrillItemLedgEntries(Level: Integer; ItemLedgEntry4: Record "Item Ledger Entry")    var        ItemLedgEntry5: Record "Item Ledger Entry";        ItemLedgEntry6: Record "Item Ledger Entry";        ItemApplnEntry: Record "Item Application Entry";        SignFactor: Integer;    begin        if Level > 20 then            exit;        if ItemLedgEntry4.Positive then begin            ItemApplnEntry.SetCurrentKey("Inbound Item Entry No.", "Outbound Item Entry No.");            ItemApplnEntry.SetRange("Inbound Item Entry No.", ItemLedgEntry4."Entry No.");            ItemApplnEntry.SetFilter("Outbound Item Entry No.", '<>0');            ItemApplnEntry.SetRange("Item Ledger Entry No.");        end else begin            ItemApplnEntry.SetCurrentKey("Outbound Item Entry No.", "Item Ledger Entry No.");            ItemApplnEntry.SetRange("Outbound Item Entry No.", ItemLedgEntry4."Entry No.");            ItemApplnEntry.SetRange("Item Ledger Entry No.", ItemLedgEntry4."Entry No.");            ItemApplnEntry.SetRange("Inbound Item Entry No.");        end;        if ItemApplnEntry.Find('-') then            repeat                if ItemLedgEntry4.Positive then begin                    SignFactor := -1;                    ItemLedgEntry5.Get(ItemApplnEntry."Outbound Item Entry No.")                end else begin                    SignFactor := 1;                    ItemLedgEntry5.Get(ItemApplnEntry."Inbound Item Entry No.");                end;                if SearchUp = ItemLedgEntry5.Positive then begin                    InsertItemLedgTrackEntry(Level, ItemLedgEntry5, ItemApplnEntry.Quantity * SignFactor, ItemLedgEntry4);                    if (ItemLedgEntry5."Order Type" = ItemLedgEntry5."Order Type"::Production) and                       (ItemLedgEntry5."Order No." <> '')                    then begin                        ItemLedgEntry6.SetCurrentKey("Order Type", "Order No.", "Order Line No.", "Entry Type");                        ItemLedgEntry6.SetRange("Source Type", ItemLedgEntry4."Source Type"::Item);                        if ItemLedgEntry5."Entry Type" = ItemLedgEntry5."Entry Type"::Consumption then                            ItemLedgEntry6.SetRange("Entry Type", ItemLedgEntry4."Entry Type"::Output)                        else                            ItemLedgEntry6.SetRange("Entry Type", ItemLedgEntry4."Entry Type"::Consumption);                        if not SearchUp then                            ItemLedgEntry6.SetRange("Item No.", ItemLedgEntry5."Source No.")                        else                            ItemLedgEntry6.SetRange("Item No.", ItemLedgEntry5."Item No.");                        ItemLedgEntry6.SetRange("Order Type", ItemLedgEntry6."Order Type"::Production);                        ItemLedgEntry6.SetRange("Order No.", ItemLedgEntry5."Order No.");                        if ItemLedgEntry6.Find('-') then                            repeat                                InsertItemLedgTrackEntry(Level + 1, ItemLedgEntry6, ItemLedgEntry6.Quantity, ItemLedgEntry4);                                DrillItemLedgEntries(Level + 1, ItemLedgEntry6);                            until ItemLedgEntry6.Next() = 0;                    end;                end;            until ItemApplnEntry.Next() = 0;        if (ItemLedgEntry4."Order Type" = ItemLedgEntry4."Order Type"::Production) and (ItemLedgEntry4."Order No." <> '') then begin            ItemLedgEntry6.SetCurrentKey("Order Type", "Order No.", "Order Line No.", "Entry Type");            ItemLedgEntry6.SetRange("Source Type", ItemLedgEntry4."Source Type"::Item);            if ItemLedgEntry5."Entry Type" = ItemLedgEntry5."Entry Type"::Consumption then                ItemLedgEntry6.SetRange("Entry Type", ItemLedgEntry4."Entry Type"::Output)            else                ItemLedgEntry6.SetRange("Entry Type", ItemLedgEntry4."Entry Type"::Consumption);            ItemLedgEntry6.SetRange("Order Type", ItemLedgEntry6."Order Type"::Production);            ItemLedgEntry6.SetRange("Order No.", ItemLedgEntry5."Order No.");            if not SearchUp then                ItemLedgEntry6.SetRange("Item No.", ItemLedgEntry5."Source No.")            else                ItemLedgEntry6.SetRange("Item No.", ItemLedgEntry5."Item No.");            if ItemLedgEntry6.Find('-') then                repeat                    if ItemLedgEntry4."Entry No." <> ItemLedgEntry6."Entry No." then begin                        InsertItemLedgTrackEntry(Level + 1, ItemLedgEntry6, ItemLedgEntry6.Quantity, ItemLedgEntry4);                        DrillItemLedgEntries(Level + 1, ItemLedgEntry6);                    end;                until ItemLedgEntry6.Next() = 0;        end;    end;    local procedure InsertOrderTrackingEntry(var ReservEntry: Record "Reservation Entry"; var ReservEntry2: Record "Reservation Entry"; Level: Integer)    begin        TempReservEntryList := ReservEntry;        TempReservEntryList.Positive := false;        if not TempReservEntryList.Insert() then            exit;        TempOrderTrackingEntry.Reset();        TempOrderTrackingEntry.Init();        TempOrderTrackingEntry.Level := Level;        TempOrderTrackingEntry."For Type" := ReservEntry."Source Type";        TempOrderTrackingEntry."For Subtype" := ReservEntry."Source Subtype";        TempOrderTrackingEntry."For ID" := ReservEntry."Source ID";        TempOrderTrackingEntry."For Batch Name" := ReservEntry."Source Batch Name";        TempOrderTrackingEntry."For Prod. Order Line" := ReservEntry."Source Prod. Order Line";        TempOrderTrackingEntry."For Ref. No." := ReservEntry."Source Ref. No.";        TempOrderTrackingEntry."From Type" := ReservEntry2."Source Type";        TempOrderTrackingEntry."From Subtype" := ReservEntry2."Source Subtype";        TempOrderTrackingEntry."From ID" := ReservEntry2."Source ID";        TempOrderTrackingEntry."From Batch Name" := ReservEntry2."Source Batch Name";        TempOrderTrackingEntry."From Prod. Order Line" := ReservEntry2."Source Prod. Order Line";        TempOrderTrackingEntry."From Ref. No." := ReservEntry2."Source Ref. No.";        if ReservEntry."Expected Receipt Date" > ReservEntry."Shipment Date" then begin            TempOrderTrackingEntry.Warning := true;            DateWarning := true;        end;        OnInsertOrderTrackingEntryOnBeforeOrderTrackingEntryExists(TempOrderTrackingEntry, ReservEntry, ReservEntry2);        if OrderTrackingEntryExists() then begin            TempOrderTrackingEntry.Quantity += ReservEntry."Quantity (Base)";            TempOrderTrackingEntry.Modify();            exit;        end;        TempOrderTrackingEntry."Entry No." := EntryNo;        TempOrderTrackingEntry."Demanded by" := ReservEngineMgt.CreateForText(ReservEntry);        TempOrderTrackingEntry."Supplied by" := ReservEngineMgt.CreateFromText(ReservEntry);        TempOrderTrackingEntry."Item No." := ReservEntry."Item No.";        TempOrderTrackingEntry."Shipment Date" := ReservEntry."Shipment Date";        TempOrderTrackingEntry."Expected Receipt Date" := ReservEntry."Expected Receipt Date";        if MultipleItemLedgEntries then            TempOrderTrackingEntry.Quantity := MultipleSummedUpQty        else            TempOrderTrackingEntry.Quantity := ReservEntry."Quantity (Base)";        if SearchUp then            TempOrderTrackingEntry.Name := TempOrderTrackingEntry."Supplied by"        else            TempOrderTrackingEntry.Name := TempOrderTrackingEntry."Demanded by";        if Level = 1 then            if SearchUp then                TempOrderTrackingEntry."Demanded by" := Text003            else                TempOrderTrackingEntry."Supplied by" := Text003;        Type := TempOrderTrackingEntry."For Type";        Subtype := TempOrderTrackingEntry."For Subtype";        ID := TempOrderTrackingEntry."For ID";        BatchName := TempOrderTrackingEntry."For Batch Name";        ProdOrderLineNo := TempOrderTrackingEntry."For Prod. Order Line";        RefNo := TempOrderTrackingEntry."For Ref. No.";        case Type of            DATABASE::"Purchase Line":                if PurchLine.Get(Subtype, ID, RefNo) then begin                    TempOrderTrackingEntry."Starting Date" := PurchLine."Expected Receipt Date";                    TempOrderTrackingEntry."Ending Date" := PurchLine."Expected Receipt Date";                end;            DATABASE::"Requisition Line":                if ReqLine.Get(ID, BatchName, RefNo) then begin                    TempOrderTrackingEntry."Starting Date" := ReqLine."Due Date";                    TempOrderTrackingEntry."Ending Date" := ReqLine."Due Date";                end;            DATABASE::"Item Journal Line":                if ItemJnlLine.Get(ID, BatchName, RefNo) then begin                    TempOrderTrackingEntry."Starting Date" := ItemJnlLine."Posting Date";                    TempOrderTrackingEntry."Ending Date" := ItemJnlLine."Posting Date";                end;            DATABASE::"Item Ledger Entry":                if ItemLedgEntry.Get(RefNo) then begin                    TempOrderTrackingEntry."Starting Date" := WorkDate();                    TempOrderTrackingEntry."Ending Date" := WorkDate();                end;            DATABASE::"Planning Component":                if PlanningComponent.Get(ID, BatchName, ProdOrderLineNo, RefNo) then begin                    TempOrderTrackingEntry."Starting Date" := PlanningComponent."Due Date";                    if ReqLine.Get(ID, BatchName, ProdOrderLineNo) then                        TempOrderTrackingEntry."Ending Date" := ReqLine."Ending Date";                end;            else                OnInsertOrderTrackingEntry(TempOrderTrackingEntry, Type, Subtype, ID, RefNo, BatchName, ProdOrderLineNo);        end;        if TempOrderTrackingEntry."From Type" = DATABASE::"Requisition Line" then            if ReqLine.Get(                 TempOrderTrackingEntry."From ID", TempOrderTrackingEntry."From Batch Name", TempOrderTrackingEntry."From Ref. No.")            then                if ReqLine."Action Message" = ReqLine."Action Message"::Cancel then                    TempOrderTrackingEntry.Name := Text004;        OnInsertOrderTrackingEntryOnBeforeTempOrderTrackingEntryInsert(TempOrderTrackingEntry, ReservEntry, ReservEntry2);        TempOrderTrackingEntry.Insert();        EntryNo := EntryNo + 1;        OnAfterInsertTrackingEntry(TempOrderTrackingEntry, DateWarning);    end;    local procedure InsertItemLedgTrackEntry(Level: Integer; ToItemLedgEntry: Record "Item Ledger Entry"; TrackQuantity: Decimal; FromItemLedgEntry: Record "Item Ledger Entry")    var        PeggingText: Text[30];    begin        if TrackQuantity = 0 then            exit;        TempOrderTrackingEntry.Reset();        TempOrderTrackingEntry.Init();        TempOrderTrackingEntry."Entry No." := EntryNo;        if SearchUp then begin            TempOrderTrackingEntry."Demanded by" :=              StrSubstNo(                '%1 %2', FromItemLedgEntry.TableCaption(), FromItemLedgEntry."Entry No.");            TempOrderTrackingEntry."Supplied by" :=              StrSubstNo(                '%1 %2', ToItemLedgEntry.TableCaption(), ToItemLedgEntry."Entry No.");        end else begin            TempOrderTrackingEntry."Supplied by" :=              StrSubstNo(                '%1 %2', FromItemLedgEntry.TableCaption(), FromItemLedgEntry."Entry No.");            TempOrderTrackingEntry."Demanded by" :=              StrSubstNo(                '%1 %2', ToItemLedgEntry.TableCaption(), ToItemLedgEntry."Entry No.");        end;        if Level = 1 then begin            if ToItemLedgEntry."Entry No." = FromItemLedgEntry."Entry No." then                PeggingText := Text005            else                PeggingText := '';            if SearchUp then                TempOrderTrackingEntry."Demanded by" := PeggingText + Text006            else                TempOrderTrackingEntry."Supplied by" := PeggingText + Text007;        end;        TempOrderTrackingEntry."Item No." := ToItemLedgEntry."Item No.";        TempOrderTrackingEntry.Quantity := TrackQuantity;        TempOrderTrackingEntry.Level := Level;        TempOrderTrackingEntry."For Type" := DATABASE::"Item Ledger Entry";        TempOrderTrackingEntry."For Ref. No." := FromItemLedgEntry."Entry No.";        TempOrderTrackingEntry."From Type" := DATABASE::"Item Ledger Entry";        TempOrderTrackingEntry."From Ref. No." := ToItemLedgEntry."Entry No.";        if SearchUp then            TempOrderTrackingEntry.Name := TempOrderTrackingEntry."Supplied by"        else            TempOrderTrackingEntry.Name := TempOrderTrackingEntry."Demanded by";        Type := TempOrderTrackingEntry."For Type";        RefNo := ToItemLedgEntry."Entry No.";        TempOrderTrackingEntry."Starting Date" := 0D;        TempOrderTrackingEntry."Ending Date" := 0D;        OnBeforeTempOrderTrackingEntryInsert(TempOrderTrackingEntry, ToItemLedgEntry, FromItemLedgEntry);        TempOrderTrackingEntry.Insert();        EntryNo := EntryNo + 1;    end;    local procedure OrderTrackingEntryExists(): Boolean    var        OrderTrackingEntry2: Record "Order Tracking Entry";    begin        OrderTrackingEntry2 := TempOrderTrackingEntry;        TempOrderTrackingEntry.SetRange(Level, TempOrderTrackingEntry.Level);        TempOrderTrackingEntry.SetRange("For Type", TempOrderTrackingEntry."For Type");        TempOrderTrackingEntry.SetRange("For Subtype", TempOrderTrackingEntry."For Subtype");        TempOrderTrackingEntry.SetRange("For ID", TempOrderTrackingEntry."For ID");        TempOrderTrackingEntry.SetRange("For Batch Name", TempOrderTrackingEntry."For Batch Name");        TempOrderTrackingEntry.SetRange("For Prod. Order Line", TempOrderTrackingEntry."For Prod. Order Line");        TempOrderTrackingEntry.SetRange("For Ref. No.", TempOrderTrackingEntry."For Ref. No.");        TempOrderTrackingEntry.SetRange("From Type", TempOrderTrackingEntry."From Type");        TempOrderTrackingEntry.SetRange("From Subtype", TempOrderTrackingEntry."From Subtype");        TempOrderTrackingEntry.SetRange("From ID", TempOrderTrackingEntry."From ID");        TempOrderTrackingEntry.SetRange("From Batch Name", TempOrderTrackingEntry."From Batch Name");        TempOrderTrackingEntry.SetRange("From Prod. Order Line", TempOrderTrackingEntry."From Prod. Order Line");        TempOrderTrackingEntry.SetRange("From Ref. No.", TempOrderTrackingEntry."From Ref. No.");        OnOrderTrackingEntryExistsOnBeforeFindTrackingEntry(TempOrderTrackingEntry);        if TempOrderTrackingEntry.Find('-') then begin            TempOrderTrackingEntry.Reset();            exit(true);        end;        TempOrderTrackingEntry.Reset();        TempOrderTrackingEntry := OrderTrackingEntry2;        exit(false);    end;    procedure DerivePlanningFilter(var FromReservEntry: Record "Reservation Entry"; var ToReservEntry: Record "Reservation Entry") OK: Boolean    var        FilterReqLine: Record "Requisition Line";        FilterPlanningComponent: Record "Planning Component";    begin        OK := false;        ToReservEntry.SetRange("Source Type", DATABASE::"Planning Component");        if FromReservEntry.GetFilter("Source Type") = ToReservEntry.GetFilter("Source Type") then begin            Evaluate(FilterPlanningComponent."Line No.", FromReservEntry.GetFilter("Source Ref. No."));            Evaluate(FilterPlanningComponent."Worksheet Line No.", FromReservEntry.GetFilter("Source Prod. Order Line"));            if not FilterPlanningComponent.Get(                    FromReservEntry.GetRangeMin("Source ID"), FromReservEntry.GetRangeMin("Source Batch Name"),                    FilterPlanningComponent."Worksheet Line No.", FilterPlanningComponent."Line No.")            then                exit(false);            OnDerivePlanningFilterOnSetToReservationFilter(ToReservEntry, FilterPlanningComponent);            ToReservEntry.SetRange("Source Prod. Order Line", FilterPlanningComponent."Ref. Order Line No.");            OK := ToReservEntry.Find('-');        end else begin            ToReservEntry.SetRange("Source Type", DATABASE::"Requisition Line");            if FromReservEntry.GetFilter("Source Type") = ToReservEntry.GetFilter("Source Type") then begin                Evaluate(FilterReqLine."Line No.", FromReservEntry.GetFilter("Source Ref. No."));                if not FilterReqLine.Get(FromReservEntry.GetRangeMin("Source ID"),                        FromReservEntry.GetRangeMin("Source Batch Name"), FilterReqLine."Line No.")                then                    exit(false);                if FilterReqLine."Action Message".AsInteger() > FilterReqLine."Action Message"::New.AsInteger() then                    case FilterReqLine."Ref. Order Type" of                        FilterReqLine."Ref. Order Type"::Purchase:                            begin                                ToReservEntry.SetSourceFilter(DATABASE::"Purchase Line", 1, FilterReqLine."Ref. Order No.", FilterReqLine."Ref. Line No.", true);                                OK := ToReservEntry.Find('-');                            end;                        FilterReqLine."Ref. Order Type"::Transfer:                            begin                                ToReservEntry.SetSourceFilter(DATABASE::"Transfer Line", 1, FilterReqLine."Ref. Order No.", FilterReqLine."Ref. Line No.", true);                                ToReservEntry.SetRange("Source Prod. Order Line", 0);                                OK := ToReservEntry.Find('-');                            end;                        else                            OnDerivePlanningFilterOnSetRequisitionLineFilters(ToReservEntry, FilterReqLine, OK);                    end;            end else                OnDerivePlanningFilterOnCheckReservationSourceTypeElse(FromReservEntry, ToReservEntry, OK);        end;    end;    [IntegrationEvent(false, false)]    local procedure OnAfterInsertTrackingEntry(var OrderTrackingEntry: Record "Order Tracking Entry"; var DateWarning: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnSetSourceRecord(var SourceRecordVar: Variant; var ReservationEntry: Record "Reservation Entry"; var CaptionText: Text; var ItemLedgerEntry2: Record "Item Ledger Entry")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeProcessReservEntry(var ReservEntry: Record "Reservation Entry"; var FilterReservEntry: Record "Reservation Entry"; var ContinueDrillUp: Boolean; var IncludePlanningFilter: Boolean; Level: Integer; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeTempOrderTrackingEntryInsert(var TempOrderTrackingEntry: Record "Order Tracking Entry" temporary; ToItemLedgerEntry: Record "Item Ledger Entry"; FromItemLedgerEntry: Record "Item Ledger Entry")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnDrillOrdersUpCaseElse(var ReservationEntry3: Record "Reservation Entry"; var ReservationEntry2: Record "Reservation Entry"; SearchUp: Boolean; var ContinueDrillUp: Boolean; var IncludePlanningFilter: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnInsertOrderTrackingEntry(var OrderTrackingEntry: Record "Order Tracking Entry"; Type: Option; Subtype: Integer; ID: Code[20]; RefNo: Integer; BatchName: Code[20]; ProdOrderLineNo: Integer)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnInsertOrderTrackingEntryOnBeforeTempOrderTrackingEntryInsert(var TempOrderTrackingEntry: Record "Order Tracking Entry"; var ReservEntry: Record "Reservation Entry"; var ReservEntry2: Record "Reservation Entry")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeFindRecordsInner(var SuppressMessages: Boolean)    begin    end;#if not CLEAN27    [Obsolete('This event is never raised.', '27.0')]    [IntegrationEvent(false, false)]    local procedure OnSetSourceLine(SourceRecRef: RecordRef; var ReservEntry: Record "Reservation Entry"; var ItemLedgerEntry: Record "Item Ledger Entry")    begin    end;#endif    [IntegrationEvent(false, false)]    local procedure OnDerivePlanningFilterOnSetToReservationFilter(var ToReservEntry: Record "Reservation Entry"; FilterPlanningComponent: Record "Planning Component")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnDerivePlanningFilterOnSetRequisitionLineFilters(var ToReservEntry: Record "Reservation Entry"; FilterReqLine: Record "Requisition Line"; var OK: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnOrderTrackingEntryExistsOnBeforeFindTrackingEntry(var TempOrderTrackingEntry: Record "Order Tracking Entry" temporary)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnDerivePlanningFilterOnCheckReservationSourceTypeElse(var FromReservationEntry: Record "Reservation Entry"; var ToReservationEntry: Record "Reservation Entry"; var IsOK: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterDrillOrdersUp(var TempOrderTrackingEntry: Record "Order Tracking Entry" temporary; var ReservationEntry: Record "Reservation Entry"; Level: Integer; var EntryNo: Integer; var SearchUp: Boolean; var SearchUpIsSet: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnInsertOrderTrackingEntryOnBeforeOrderTrackingEntryExists(var TempOrderTrackingEntry: Record "Order Tracking Entry" temporary; ReservationEntry: Record "Reservation Entry"; ReservationEntry2: Record "Reservation Entry")    begin    end;}