Codeunit 6502 Late Binding Management
src/Layers/W1/BaseApp/Inventory/Tracking/LateBindingManagement.Codeunit.al729 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.Inventory.Ledger;codeunit 6502 "Late Binding Management"{ trigger OnRun() begin end; var TempCurrSupplyReservEntry: Record "Reservation Entry" temporary; TempCurrDemandReservEntry: Record "Reservation Entry" temporary; TempSupplyReservEntry: Record "Reservation Entry" temporary; TempReservEntryDelete: Record "Reservation Entry" temporary; TempReservEntryModify: Record "Reservation Entry" temporary; TempReservEntryInsert: Record "Reservation Entry" temporary; TempReservEntryOrderTrackingSurplus: Record "Reservation Entry" temporary; ReservMgt: Codeunit "Reservation Management"; LastEntryNo: Integer; local procedure CleanUpVariables() begin ClearAll(); TempReservEntryDelete.Reset(); TempReservEntryDelete.DeleteAll(); TempReservEntryModify.Reset(); TempReservEntryModify.DeleteAll(); TempReservEntryInsert.Reset(); TempReservEntryInsert.DeleteAll(); TempCurrSupplyReservEntry.Reset(); TempCurrSupplyReservEntry.DeleteAll(); TempCurrDemandReservEntry.Reset(); TempCurrDemandReservEntry.DeleteAll(); TempSupplyReservEntry.Reset(); TempSupplyReservEntry.DeleteAll(); end; procedure ReallocateTrkgSpecification(var TempTrackingSpecification: Record "Tracking Specification" temporary) begin // Go through the tracking specification and calculate what is available/reserved/can be reallocated // The buffer fields on TempTrackingSpecification are used as follows: // "Buffer Value1" : Non-allocated item tracking // "Buffer Value2" : Total inventory // "Buffer Value3" : Total reserved inventory // "Buffer Value4" : Qty for reallocation (negative = need for reallocation) // "Buffer Value5" : Total non-specific reserved inventory (can be un-reserved through reallocation) CleanUpVariables(); TempTrackingSpecification.CalcSums("Buffer Value1"); // Non-allocated item tracking if TempTrackingSpecification."Buffer Value1" = 0 then exit; // Item tracking is fully allocated => no basis for reallocation if not CalcInventory(TempTrackingSpecification) then exit; // No reservations exist => no basis for reallocation TempTrackingSpecification.SetFilter("Buffer Value4", '< %1', 0); if TempTrackingSpecification.IsEmpty() then begin TempTrackingSpecification.Reset(); exit; // Supply is available - no need for reallocation end; TempTrackingSpecification.Reset(); // Try to free sufficient supply by reallocation within the tracking specification CalcAllocations(TempTrackingSpecification); TempTrackingSpecification.Reset(); TempTrackingSpecification.CalcSums("Buffer Value4"); if TempTrackingSpecification."Buffer Value4" < 0 then if not PrepareTempDataSet(TempTrackingSpecification, Abs(TempTrackingSpecification."Buffer Value4")) then exit; // There is not sufficient free supply to cover reallocation TempTrackingSpecification.Reset(); Reallocate(TempTrackingSpecification); // Write to database in the end WriteToDatabase(); end; local procedure Reallocate(var TempTrackingSpecification: Record "Tracking Specification" temporary) AllocationsChanged: Boolean var TempTrackingSpecification2: Record "Tracking Specification" temporary; QtyToReallocate: Decimal; begin TempTrackingSpecification.Reset(); TempTrackingSpecification.SetFilter("Buffer Value4", '< %1', 0); if TempTrackingSpecification.FindSet() then repeat TempTrackingSpecification2 := TempTrackingSpecification; TempTrackingSpecification2.Insert(); until TempTrackingSpecification.Next() = 0; TempTrackingSpecification.Reset(); TempCurrSupplyReservEntry.Reset(); if TempTrackingSpecification2.FindSet() then repeat TempCurrSupplyReservEntry.SetTrackingFilterFromSpec(TempTrackingSpecification2); QtyToReallocate := Abs(TempTrackingSpecification2."Buffer Value4"); if TempCurrSupplyReservEntry.FindSet() then repeat QtyToReallocate := ReshuffleReservEntry(TempCurrSupplyReservEntry, QtyToReallocate, TempTrackingSpecification); until (TempCurrSupplyReservEntry.Next() = 0) or (QtyToReallocate = 0); AllocationsChanged := AllocationsChanged or (QtyToReallocate <> Abs(TempTrackingSpecification2."Buffer Value4")); until TempTrackingSpecification2.Next() = 0; end; local procedure PrepareTempDataSet(var TempTrackingSpecification: Record "Tracking Specification" temporary; QtyToPrepare: Decimal): Boolean var ItemLedgEntry: Record "Item Ledger Entry"; TempReservEntry: Record "Reservation Entry" temporary; begin if QtyToPrepare <= 0 then exit(true); TempTrackingSpecification.Reset(); ItemLedgEntry.SetCurrentKey("Item No.", Open, "Variant Code", Positive, "Location Code", "Entry No."); ItemLedgEntry.SetLoadFields("Item No.", "Variant Code", "Location Code", "Qty. per Unit of Measure", Description, "Remaining Quantity", "Serial No.", "Lot No.", "Package No."); ItemLedgEntry.SetRange("Item No.", TempTrackingSpecification."Item No."); ItemLedgEntry.SetRange("Variant Code", TempTrackingSpecification."Variant Code"); ItemLedgEntry.SetRange("Location Code", TempTrackingSpecification."Location Code"); ItemLedgEntry.SetRange(Positive, true); ItemLedgEntry.SetRange(Open, true); OnPrepareTempDataSetOnAfterItemLedgEntrySetFilters(ItemLedgEntry, TempTrackingSpecification); if ItemLedgEntry.FindSet() then repeat TempTrackingSpecification.SetTrackingFilterFromItemLedgEntry(ItemLedgEntry); if TempTrackingSpecification.IsEmpty() then begin if not TempSupplyReservEntry.Get(-ItemLedgEntry."Entry No.", true) then InsertTempSupplyReservEntry(ItemLedgEntry); // GET record QtyToPrepare -= ItemLedgEntry."Remaining Quantity"; TempSupplyReservEntry.Get(-ItemLedgEntry."Entry No.", true); GetReservEntriesForItemLedgEntry(TempReservEntry, ItemLedgEntry."Entry No."); if TempReservEntry.FindSet() then repeat TempSupplyReservEntry."Quantity (Base)" -= TempReservEntry."Quantity (Base)"; TempSupplyReservEntry.Modify(); if TempReservEntry."Reservation Status" = TempReservEntry."Reservation Status"::Surplus then begin TempSupplyReservEntry := TempReservEntry; TempSupplyReservEntry.Insert(); end else QtyToPrepare += TempReservEntry."Quantity (Base)"; until TempReservEntry.Next() = 0; if TempSupplyReservEntry."Quantity (Base)" = 0 then TempSupplyReservEntry.Delete() end; DeleteOrderTrackingSurplusEntryForItemLedgEntry(ItemLedgEntry."Entry No."); until (ItemLedgEntry.Next() = 0) or (QtyToPrepare <= 0); TempTrackingSpecification.Reset(); exit(QtyToPrepare <= 0); end; local procedure ReshuffleReservEntry(SupplyReservEntry: Record "Reservation Entry"; QtyToReshuffle: Decimal; var TempTrackingSpecification: Record "Tracking Specification" temporary) RemainingQty: Decimal var TotalAvailable: Decimal; QtyToReshuffleThisLine: Decimal; xQtyToReshuffleThisLine: Decimal; AdjustmentQty: Decimal; NewQty: Decimal; xQty: Decimal; begin if not SupplyReservEntry.IsReservationOrTracking() then exit; // The entry is neither reservation nor tracking and cannot be reshuffled if not SupplyReservEntry.Positive then exit; // The entry is not supply and cannot be reshuffled TempCurrDemandReservEntry.Get(SupplyReservEntry."Entry No.", not SupplyReservEntry.Positive); // Demand if TempCurrDemandReservEntry.TrackingExists() then // The reservation is not open exit; // The entry is a specific allocation and cannot be reshuffled if QtyToReshuffle <= 0 then exit; TempSupplyReservEntry.CalcSums("Quantity (Base)"); TotalAvailable := TempSupplyReservEntry."Quantity (Base)"; if TotalAvailable < QtyToReshuffle then exit(QtyToReshuffle); if SupplyReservEntry."Quantity (Base)" > QtyToReshuffle then QtyToReshuffleThisLine := QtyToReshuffle else QtyToReshuffleThisLine := SupplyReservEntry."Quantity (Base)"; xQtyToReshuffleThisLine := QtyToReshuffleThisLine; TempSupplyReservEntry.SetRange("Reservation Status", TempSupplyReservEntry."Reservation Status"::Surplus); if TempSupplyReservEntry.FindSet() then repeat TempTrackingSpecification.SetTrackingFilterFromReservEntry(TempSupplyReservEntry); if TempTrackingSpecification.FindFirst() then begin if TempTrackingSpecification."Buffer Value4" > 0 then begin if TempTrackingSpecification."Buffer Value4" < QtyToReshuffleThisLine then begin AdjustmentQty := QtyToReshuffleThisLine - TempTrackingSpecification."Buffer Value4"; QtyToReshuffleThisLine := TempTrackingSpecification."Buffer Value4"; end else AdjustmentQty := 0; xQty := QtyToReshuffleThisLine; QtyToReshuffleThisLine := MakeConnection(TempSupplyReservEntry, TempCurrDemandReservEntry, QtyToReshuffleThisLine); TempTrackingSpecification."Buffer Value4" -= (xQty - QtyToReshuffleThisLine); TempTrackingSpecification.Modify(); QtyToReshuffleThisLine += AdjustmentQty; end; end else QtyToReshuffleThisLine := MakeConnection(TempSupplyReservEntry, TempCurrDemandReservEntry, QtyToReshuffleThisLine); until (TempSupplyReservEntry.Next() = 0) or (QtyToReshuffleThisLine = 0); RemainingQty := QtyToReshuffle - xQtyToReshuffleThisLine + QtyToReshuffleThisLine; // Modify the original demand/supply entries NewQty := SupplyReservEntry."Quantity (Base)" - xQtyToReshuffleThisLine + QtyToReshuffleThisLine; if NewQty = 0 then begin TempReservEntryDelete := SupplyReservEntry; TempReservEntryDelete.Insert(); TempReservEntryDelete := TempCurrDemandReservEntry; TempReservEntryDelete.Insert(); end else begin TempReservEntryModify := SupplyReservEntry; TempReservEntryModify."Quantity (Base)" := NewQty; TempReservEntryModify.Insert(); TempReservEntryModify := TempCurrDemandReservEntry; TempReservEntryModify."Quantity (Base)" := -NewQty; TempReservEntryModify.Insert(); end; TempTrackingSpecification.Reset(); end; local procedure MakeConnection(var SupplySurplusEntry: Record "Reservation Entry"; var DemandReservEntry: Record "Reservation Entry"; QtyToReshuffle: Decimal) RemainingQty: Decimal var NewEntryNo: Integer; IsHandled: Boolean; begin if SupplySurplusEntry."Quantity (Base)" = 0 then exit(QtyToReshuffle); if SupplySurplusEntry."Quantity (Base)" <= QtyToReshuffle then begin // Convert supply surplus fully if SupplySurplusEntry."Entry No." < 0 then begin // Item Ledger Entry temporary record LastEntryNo := LastEntryNo + 1; NewEntryNo := -LastEntryNo; end else NewEntryNo := SupplySurplusEntry."Entry No."; TempReservEntryInsert := DemandReservEntry; TempReservEntryInsert."Entry No." := NewEntryNo; TempReservEntryInsert."Expected Receipt Date" := SupplySurplusEntry."Expected Receipt Date"; TempReservEntryInsert."Quantity (Base)" := -SupplySurplusEntry."Quantity (Base)"; TempReservEntryInsert.Insert(); TempReservEntryModify := SupplySurplusEntry; TempReservEntryModify."Entry No." := NewEntryNo; TempReservEntryModify."Reservation Status" := DemandReservEntry."Reservation Status"; TempReservEntryModify."Shipment Date" := DemandReservEntry."Shipment Date"; if SupplySurplusEntry."Entry No." < 0 then begin // Entry does not really exist TempReservEntryInsert := TempReservEntryModify; TempReservEntryInsert.Insert(); end else TempReservEntryModify.Insert(); RemainingQty := QtyToReshuffle - SupplySurplusEntry."Quantity (Base)"; SupplySurplusEntry."Quantity (Base)" := 0; SupplySurplusEntry.Modify(); end else begin if SupplySurplusEntry."Entry No." > 0 then begin TempReservEntryModify := SupplySurplusEntry; TempReservEntryModify."Quantity (Base)" -= QtyToReshuffle; IsHandled := false; OnMakeConnectionOnBeforeTempReservEntryModifyInsert(TempReservEntryModify, SupplySurplusEntry, QtyToReshuffle, IsHandled); if not IsHandled then TempReservEntryModify.Insert(); end; LastEntryNo := LastEntryNo + 1; NewEntryNo := -LastEntryNo; TempReservEntryInsert := SupplySurplusEntry; TempReservEntryInsert."Entry No." := NewEntryNo; TempReservEntryInsert."Reservation Status" := DemandReservEntry."Reservation Status"; TempReservEntryInsert.Validate("Quantity (Base)", QtyToReshuffle); TempReservEntryInsert."Shipment Date" := DemandReservEntry."Shipment Date"; TempReservEntryInsert.Insert(); TempReservEntryInsert := DemandReservEntry; TempReservEntryInsert."Entry No." := NewEntryNo; TempReservEntryInsert."Expected Receipt Date" := SupplySurplusEntry."Expected Receipt Date"; TempReservEntryInsert.Validate("Quantity (Base)", -QtyToReshuffle); TempReservEntryInsert.Insert(); SupplySurplusEntry."Quantity (Base)" -= QtyToReshuffle; SupplySurplusEntry.Modify(); RemainingQty := 0; end; end; local procedure WriteToDatabase() var ReservEntry: Record "Reservation Entry"; PrevNegEntryNo: Integer; LastInsertedEntryNo: Integer; begin TempReservEntryDelete.Reset(); TempReservEntryModify.Reset(); TempReservEntryInsert.Reset(); if TempReservEntryDelete.FindSet() then repeat ReservEntry := TempReservEntryDelete; ReservEntry.Delete(); until TempReservEntryDelete.Next() = 0; if TempReservEntryModify.FindSet() then repeat ReservEntry := TempReservEntryModify; ReservEntry.Validate("Quantity (Base)"); ReservEntry.Modify(); until TempReservEntryModify.Next() = 0; PrevNegEntryNo := 0; LastInsertedEntryNo := 0; if TempReservEntryInsert.FindSet() then repeat ReservEntry := TempReservEntryInsert; if ReservEntry."Entry No." < 0 then if ReservEntry."Entry No." = PrevNegEntryNo then ReservEntry."Entry No." := LastInsertedEntryNo else begin PrevNegEntryNo := ReservEntry."Entry No."; ReservEntry."Entry No." := 0; end; ReservEntry.Validate("Quantity (Base)"); ReservEntry.UpdateItemTracking(); ReservEntry.Insert(); LastInsertedEntryNo := ReservEntry."Entry No."; until TempReservEntryInsert.Next() = 0; end; local procedure CalcInventory(var TempTrackingSpecification: Record "Tracking Specification" temporary): Boolean var ItemLedgEntry: Record "Item Ledger Entry"; ReservEntry: Record "Reservation Entry"; TotalReservedQty: Decimal; begin ReservEntry.ReadIsolation := IsolationLevel::ReadUncommitted; // Read uncommitted to avoid deadlocks during UpdLock transaction ReservEntry.SetRange("Item No.", TempTrackingSpecification."Item No."); ReservEntry.SetRange("Variant Code", TempTrackingSpecification."Variant Code"); ReservEntry.SetRange("Location Code", TempTrackingSpecification."Location Code"); ReservEntry.SetRange("Source Type", DATABASE::"Item Ledger Entry"); ReservEntry.SetRange("Source Subtype", 0); ReservEntry.SetRange("Reservation Status", ReservEntry."Reservation Status"::Reservation); ReservEntry.SetFilter("Item Tracking", '<> %1', ReservEntry."Item Tracking"::None); if ReservEntry.IsEmpty() then // No reservations with Item Tracking exist against inventory - no basis for reallocation. exit(false); ReservEntry.ReadIsolation := IsolationLevel::Default; if ReservEntry.IsEmpty() then; ItemLedgEntry.SetLoadFields("Item No.", "Variant Code", "Location Code", "Qty. per Unit of Measure", Description, "Remaining Quantity", "Serial No.", "Lot No.", "Package No."); ItemLedgEntry.SetRange("Item No.", TempTrackingSpecification."Item No."); ItemLedgEntry.SetRange("Variant Code", TempTrackingSpecification."Variant Code"); ItemLedgEntry.SetRange("Location Code", TempTrackingSpecification."Location Code"); ItemLedgEntry.SetRange(Positive, true); ItemLedgEntry.SetRange(Open, true); ItemLedgEntry.SetAutoCalcFields("Reserved Quantity"); if TempTrackingSpecification.FindSet() then repeat ItemLedgEntry.SetTrackingFilterFromSpec(TempTrackingSpecification); if ItemLedgEntry.FindSet() then repeat if not TempSupplyReservEntry.Get(-ItemLedgEntry."Entry No.", true) then begin TempTrackingSpecification."Buffer Value2" += ItemLedgEntry."Remaining Quantity"; TempTrackingSpecification."Buffer Value3" += ItemLedgEntry."Reserved Quantity"; InsertTempSupplyReservEntry(ItemLedgEntry); end; until ItemLedgEntry.Next() = 0; TempTrackingSpecification."Buffer Value4" := TempTrackingSpecification."Buffer Value2" - // Total Inventory TempTrackingSpecification."Buffer Value3" + // Reserved Inventory TempTrackingSpecification."Buffer Value1"; // Non-allocated lot/sn demand (signed negatively) TempTrackingSpecification.Modify(); TotalReservedQty += TempTrackingSpecification."Buffer Value3"; until TempTrackingSpecification.Next() = 0; if TotalReservedQty = 0 then exit(false); // No need to consider reallocation if no reservations exist. exit(true); end; local procedure CalcAllocations(var TempTrackingSpecification: Record "Tracking Specification" temporary): Boolean var ReservEntry: Record "Reservation Entry"; ReservEntry2: Record "Reservation Entry"; QtyNeededForReallocation: Decimal; begin ReservEntry.SetCurrentKey("Item No.", "Source Type", "Source Subtype", "Reservation Status", "Location Code", "Variant Code"); ReservEntry.SetRange("Item No.", TempTrackingSpecification."Item No."); ReservEntry.SetRange("Variant Code", TempTrackingSpecification."Variant Code"); ReservEntry.SetRange("Location Code", TempTrackingSpecification."Location Code"); ReservEntry.SetRange("Source Type", DATABASE::"Item Ledger Entry"); // (ILE) ReservEntry.SetRange("Source Subtype", 0); ReservEntry.SetRange(Positive, true); ReservEntry.SetRange("Reservation Status", ReservEntry."Reservation Status"::Reservation, ReservEntry."Reservation Status"::Tracking); TempTrackingSpecification.SetFilter("Buffer Value4", '< %1', 0); if TempTrackingSpecification.FindSet() then repeat ReservEntry.SetTrackingFilterFromTrackingSpecIfNotBlank(TempTrackingSpecification); if ReservEntry.FindSet(true) then repeat ReservEntry2.Get(ReservEntry."Entry No.", not ReservEntry.Positive); // Get demand if not ReservEntry2.TrackingExists() then begin TempCurrSupplyReservEntry := ReservEntry; TempCurrSupplyReservEntry.Insert(); TempTrackingSpecification."Buffer Value5" += ReservEntry."Quantity (Base)"; TempCurrDemandReservEntry := ReservEntry2; TempCurrDemandReservEntry.Insert(); end; until (ReservEntry.Next() = 0) or (TempTrackingSpecification."Buffer Value4" + TempTrackingSpecification."Buffer Value5" >= 0); if TempTrackingSpecification."Buffer Value4" + TempTrackingSpecification."Buffer Value5" < 0 then // Not sufficient qty exit(false); TempTrackingSpecification.Modify(); QtyNeededForReallocation += Abs(TempTrackingSpecification."Buffer Value4"); until TempTrackingSpecification.Next() = 0; TempTrackingSpecification.SetFilter("Buffer Value4", '>= %1', 0); ReservEntry.SetRange("Reservation Status"); // The quantity temporary records representing Item Ledger Entries are adjusted according to the // reservation entries actually existing in the database pointing at those entries. Otherwise these // would be counted twice. if TempTrackingSpecification.FindSet() then repeat ReservEntry.SetTrackingFilterFromTrackingSpecIfNotBlank(TempTrackingSpecification); if ReservEntry.FindSet() then repeat TempSupplyReservEntry.Get(-ReservEntry."Source Ref. No.", true); TempSupplyReservEntry."Quantity (Base)" -= ReservEntry."Quantity (Base)"; if TempSupplyReservEntry."Quantity (Base)" = 0 then TempSupplyReservEntry.Delete() else TempSupplyReservEntry.Modify(); if ReservEntry."Reservation Status" = ReservEntry."Reservation Status"::Surplus then begin TempSupplyReservEntry := ReservEntry; TempSupplyReservEntry.Insert(); end; until (ReservEntry.Next() = 0); QtyNeededForReallocation -= TempTrackingSpecification."Buffer Value4"; until (TempTrackingSpecification.Next() = 0); exit(QtyNeededForReallocation <= 0); end; local procedure InsertTempSupplyReservEntry(ItemLedgEntry: Record "Item Ledger Entry") var IsHandled: Boolean; begin IsHandled := false; OnBeforeInsertTempSupplyReservEntry(TempSupplyReservEntry, ItemLedgEntry, IsHandled); if not IsHandled then begin TempSupplyReservEntry.Init(); TempSupplyReservEntry."Entry No." := -ItemLedgEntry."Entry No."; TempSupplyReservEntry.Positive := true; TempSupplyReservEntry."Source Type" := DATABASE::"Item Ledger Entry"; TempSupplyReservEntry."Source Ref. No." := ItemLedgEntry."Entry No."; TempSupplyReservEntry."Item No." := ItemLedgEntry."Item No."; TempSupplyReservEntry."Variant Code" := ItemLedgEntry."Variant Code"; TempSupplyReservEntry."Location Code" := ItemLedgEntry."Location Code"; TempSupplyReservEntry."Qty. per Unit of Measure" := ItemLedgEntry."Qty. per Unit of Measure"; TempSupplyReservEntry.Description := ItemLedgEntry.Description; TempSupplyReservEntry.CopyTrackingFromItemLedgEntry(ItemLedgEntry); TempSupplyReservEntry."Quantity (Base)" := ItemLedgEntry."Remaining Quantity"; TempSupplyReservEntry."Reservation Status" := TempSupplyReservEntry."Reservation Status"::Surplus; TempSupplyReservEntry."Expected Receipt Date" := 0D; TempSupplyReservEntry."Shipment Date" := 0D; OnBeforeTempSupplyReservEntryInsert(TempSupplyReservEntry, ItemLedgEntry); TempSupplyReservEntry.Insert(); end; end; procedure NonspecificReservedQty(var ItemLedgEntry: Record "Item Ledger Entry") UnspecificQty: Decimal var ReservEntry: Record "Reservation Entry"; ReservEntry2: Record "Reservation Entry"; begin if not ItemLedgEntry.FindSet() then exit; ReservEntry.SetCurrentKey("Item No.", "Source Type", "Source Subtype", "Reservation Status", "Location Code", "Variant Code"); ReservEntry.SetRange("Item No.", ItemLedgEntry."Item No."); ReservEntry.SetRange("Variant Code", ItemLedgEntry."Variant Code"); ReservEntry.SetRange("Location Code", ItemLedgEntry."Location Code"); ReservEntry.SetRange("Source Type", DATABASE::"Item Ledger Entry"); ReservEntry.SetRange("Source Subtype", 0); ReservEntry.SetRange("Reservation Status", ReservEntry."Reservation Status"::Reservation); ReservEntry.SetRange(Positive, true); ReservEntry.CopyTrackingFilterFromItemLedgEntry(ItemLedgEntry); if not ReservEntry.FindSet() then exit; repeat ReservEntry2.Get(ReservEntry."Entry No.", not ReservEntry.Positive); // Get demand if not ReservEntry2.TrackingExists() then UnspecificQty -= ReservEntry2."Quantity (Base)"; // Sum up negative entries to a positive value until ReservEntry.Next() = 0; end; procedure NonSpecificReservedQtyExceptForSource(ItemLedgerEntryNo: Integer; TempTrackingSpecification: Record "Tracking Specification" temporary) UnspecificQty: Decimal var ItemLedgerEntry: Record "Item Ledger Entry"; ReservEntry: Record "Reservation Entry"; OppositeReservEntry: Record "Reservation Entry"; ItemLedgerEntryReserve: Codeunit "Item Ledger Entry-Reserve"; begin UnspecificQty := 0; ItemLedgerEntry.Get(ItemLedgerEntryNo); ItemLedgerEntryReserve.FilterReservFor(ReservEntry, ItemLedgerEntry); ReservEntry.SetRange("Reservation Status", ReservEntry."Reservation Status"::Reservation); ReservEntry.SetRange(Positive, true); if ReservEntry.FindSet() then repeat OppositeReservEntry.Get(ReservEntry."Entry No.", not ReservEntry.Positive); if not OppositeReservEntry.TrackingExists() and not OppositeReservEntry.HasSamePointerWithSpec(TempTrackingSpecification) then UnspecificQty -= OppositeReservEntry."Quantity (Base)"; until ReservEntry.Next() = 0; end; procedure ReleaseForReservation(ItemNo: Code[20]; VariantCode: Code[10]; LocationCode: Code[10]; ItemTrackingSetup: Record "Item Tracking Setup"; QtyToRelease: Decimal) AllocationsChanged: Boolean var TempTrackingSpecification: Record "Tracking Specification" temporary; begin // Local procedure used when doing item tracking specific reservations // "Buffer Value4" : Qty for reallocation (negative = need for reallocation) CleanUpVariables(); TempTrackingSpecification."Item No." := ItemNo; TempTrackingSpecification."Variant Code" := VariantCode; TempTrackingSpecification."Location Code" := LocationCode; TempTrackingSpecification.CopyTrackingFromItemTrackingSetup(ItemTrackingSetup); TempTrackingSpecification."Quantity (Base)" := QtyToRelease; TempTrackingSpecification."Buffer Value4" := -QtyToRelease; TempTrackingSpecification.Insert(); PrepareTempDataSet(TempTrackingSpecification, QtyToRelease); CalcAllocations(TempTrackingSpecification); AllocationsChanged := Reallocate(TempTrackingSpecification); WriteToDatabase(); end; procedure ReleaseForReservation(var CalcItemLedgEntry: Record "Item Ledger Entry"; CalcReservEntry: Record "Reservation Entry"; RemainingQtyToReserve: Decimal) AllocationsChanged: Boolean var ItemTrackingSetup: Record "Item Tracking Setup"; AvailableToReserve: Decimal; begin // Used when doing item tracking specific reservations on reservation form. // "Buffer Value4" : Qty for reallocation (negative = need for reallocation) CalcItemLedgEntry.SetAutoCalcFields("Reserved Quantity"); if CalcItemLedgEntry.FindSet() then repeat AvailableToReserve += CalcItemLedgEntry."Remaining Quantity" - CalcItemLedgEntry."Reserved Quantity"; until (CalcItemLedgEntry.Next() = 0) or (AvailableToReserve >= RemainingQtyToReserve); if AvailableToReserve < RemainingQtyToReserve then begin ItemTrackingSetup.CopyTrackingFromReservEntry(CalcReservEntry); AllocationsChanged := ReleaseForReservation( CalcReservEntry."Item No.", CalcReservEntry."Variant Code", CalcReservEntry."Location Code", ItemTrackingSetup, RemainingQtyToReserve - AvailableToReserve); end; end; procedure ReserveItemTrackingLine(TrackingSpecification: Record "Tracking Specification") var ReservEntry: Record "Reservation Entry"; QtyToReserveBase: Decimal; QtyToReserve: Decimal; UnreservedQty: Decimal; AvailabilityDate: Date; begin // Used when fully reserving an item tracking line QtyToReserveBase := TrackingSpecification."Quantity (Base)" - TrackingSpecification."Quantity Handled (Base)"; if QtyToReserveBase <= 0 then exit; ReservMgt.SetCalcReservEntry(TrackingSpecification, ReservEntry); if ReservEntry."Quantity (Base)" < 0 then AvailabilityDate := ReservEntry."Shipment Date" else AvailabilityDate := ReservEntry."Expected Receipt Date"; UnreservedQty := TrackingSpecification."Quantity (Base)" - TrackingSpecification."Quantity Handled (Base)"; ReservEntry.SetPointerFilter(); ReservEntry.SetTrackingFilterFromReservEntry(ReservEntry); ReservEntry.SetRange("Reservation Status", ReservEntry."Reservation Status"::Reservation); ReservEntry.SetLoadFields("Quantity (Base)"); if ReservEntry.FindSet() then repeat UnreservedQty -= Abs(ReservEntry."Quantity (Base)"); until ReservEntry.Next() = 0; if QtyToReserveBase > UnreservedQty then QtyToReserveBase := UnreservedQty; OnReserveItemTrackingLineOnBeforeAutoReserveOneLine(ReservEntry); ReservMgt.AutoReserveOneLine(1, QtyToReserve, QtyToReserveBase, '', AvailabilityDate); end; procedure ReserveItemTrackingLine(TrackingSpecification: Record "Tracking Specification"; QtyToReserve: Decimal; QtyToReserveBase: Decimal) var ReservEntry: Record "Reservation Entry"; AvailabilityDate: Date; begin // Used when reserving a specific quantity on an item tracking line if QtyToReserveBase <= 0 then exit; ReservMgt.SetCalcReservEntry(TrackingSpecification, ReservEntry); ReservMgt.SetOrderTrackingSurplusEntries(TempReservEntryOrderTrackingSurplus); if ReservEntry."Quantity (Base)" < 0 then AvailabilityDate := ReservEntry."Shipment Date" else AvailabilityDate := ReservEntry."Expected Receipt Date"; ReservMgt.AutoReserveOneLine(1, QtyToReserve, QtyToReserveBase, '', AvailabilityDate); end; procedure SetOrderTrackingSurplusEntries(var TempReservEntry: Record "Reservation Entry" temporary) begin TempReservEntryOrderTrackingSurplus.DeleteAll(); if TempReservEntry.FindSet() then repeat TempReservEntryOrderTrackingSurplus := TempReservEntry; TempReservEntryOrderTrackingSurplus.Insert(); until TempReservEntry.Next() = 0; end; local procedure GetReservEntriesForItemLedgEntry(var TempReservationEntry: Record "Reservation Entry" temporary; ItemLedgEntryNo: Integer) var ReservationEntry: Record "Reservation Entry"; begin TempReservationEntry.DeleteAll(); ReservationEntry.SetSourceFilter(DATABASE::"Item Ledger Entry", 0, '', ItemLedgEntryNo, true); ReservationEntry.SetRange("Untracked Surplus", false); if ReservationEntry.FindSet() then repeat if not TempReservEntryOrderTrackingSurplus.Get(ReservationEntry."Entry No.", ReservationEntry.Positive) then begin TempReservationEntry := ReservationEntry; TempReservationEntry.Insert(); end; until ReservationEntry.Next() = 0; end; local procedure DeleteOrderTrackingSurplusEntryForItemLedgEntry(ItemLedgEntryNo: Integer) begin TempReservEntryOrderTrackingSurplus.Reset(); TempReservEntryOrderTrackingSurplus.SetSourceFilter(DATABASE::"Item Ledger Entry", 0, '', ItemLedgEntryNo, true); if TempReservEntryOrderTrackingSurplus.FindSet() then repeat TempReservEntryDelete := TempReservEntryOrderTrackingSurplus; TempReservEntryDelete.Insert(); until TempReservEntryOrderTrackingSurplus.Next() = 0; end; [IntegrationEvent(false, false)] local procedure OnBeforeTempSupplyReservEntryInsert(var ReservationEntry: Record "Reservation Entry"; ItemLedgerEntry: Record "Item Ledger Entry") begin end; [IntegrationEvent(false, false)] local procedure OnReserveItemTrackingLineOnBeforeAutoReserveOneLine(var ReservationEntry: Record "Reservation Entry") begin end; [IntegrationEvent(false, false)] local procedure OnPrepareTempDataSetOnAfterItemLedgEntrySetFilters(var ItemLedgEntry: Record "Item Ledger Entry"; var TempTrackingSpecification: Record "Tracking Specification") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeInsertTempSupplyReservEntry(var TempSupplyReservEntry: Record "Reservation Entry" temporary; ItemLedgEntry: Record "Item Ledger Entry"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnMakeConnectionOnBeforeTempReservEntryModifyInsert(var TempReservEntryModify: Record "Reservation Entry" temporary; SupplySurplusEntry: Record "Reservation Entry"; QtyToReshuffle: Decimal; var IsHandled: Boolean) begin end;}