Codeunit 5830 Calc. Availability Overview
src/Layers/W1/BaseApp/Inventory/Availability/CalcAvailabilityOverview.Codeunit.al599 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.Availability;using Microsoft.Inventory.Item;using Microsoft.Inventory.Ledger;using Microsoft.Inventory.Requisition;codeunit 5830 "Calc. Availability Overview"{ TableNo = "Availability Calc. Overview"; trigger OnRun() var CopyOfAvailabilityCalcOverview: Record "Availability Calc. Overview"; begin CopyOfAvailabilityCalcOverview.Copy(Rec); Rec.Reset(); Rec.DeleteAll(); Rec.Copy(CopyOfAvailabilityCalcOverview); OpenWindow(Text000, Rec.Count); Item.Reset(); Item.SetFilter("No.", CopyOfAvailabilityCalcOverview.GetFilter("Item No.")); Item.SetFilter("Location Filter", Rec.GetFilter("Location Code")); Item.SetFilter("Variant Filter", Rec.GetFilter("Variant Code")); Item.SetFilter("Date Filter", Rec.GetFilter(Date)); Item.SetRange("Drop Shipment Filter", false); Item.SetRange(Type, Item.Type::Inventory); if Item.Find('-') then begin OpenWindow(Text000, Item.Count); repeat UpdateWindow(); Rec.SetRange("Matches Criteria"); Rec."Item No." := Item."No."; if CheckItemInRange(Rec) then if EntriesExist(Rec) then begin Rec.Reset(); if Rec.FindLast() then; SetEntryNo(Rec."Entry No."); InsertAvailabilityEntry(Rec, Rec.Type::Item, 0D, '', '', 0, 0, 0, 0, '', Item.Description, DemandType::"All Demands"); end; Rec.Copy(CopyOfAvailabilityCalcOverview); until Item.Next() = 0; end; Window.Close(); end; var Item: Record Item; Window: Dialog; StartDate: Date; EndDate: Date; AttachedToEntryNo: Integer; EntryNo: Integer; DemandType: Enum "Demand Order Source Type"; DemandNo: Code[20]; WindowUpdateDateTime: DateTime; NoOfRecords: Integer; i: Integer;#pragma warning disable AA0074 Text000: Label 'Calculating Availability Dates @1@@@@@@@';#pragma warning restore AA0074 procedure CalculateItem(var AvailabilityCalcOverview: Record "Availability Calc. Overview") var CopyOfAvailabilityCalcOverview: Record "Availability Calc. Overview"; CopyOfItem: Record Item; FirstEntryNo: Integer; begin CopyOfItem.Copy(Item); CopyOfAvailabilityCalcOverview.Copy(AvailabilityCalcOverview); StartDate := 0D; EndDate := DMY2Date(31, 12, 9999); if AvailabilityCalcOverview.GetFilter(Date) <> '' then begin StartDate := AvailabilityCalcOverview.GetRangeMin(Date); EndDate := AvailabilityCalcOverview.GetRangeMax(Date); end; Item.Reset(); Item.SetFilter("No.", CopyOfAvailabilityCalcOverview.GetFilter("Item No.")); Item.SetFilter("Location Filter", AvailabilityCalcOverview.GetFilter("Location Code")); Item.SetFilter("Variant Filter", AvailabilityCalcOverview.GetFilter("Variant Code")); Item.SetRange("Drop Shipment Filter", false); AvailabilityCalcOverview.SetRange("Matches Criteria"); Item.Get(AvailabilityCalcOverview."Item No."); AvailabilityCalcOverview.Reset(); AvailabilityCalcOverview.SetCurrentKey("Item No."); AvailabilityCalcOverview.SetRange("Item No.", Item."No."); AvailabilityCalcOverview.DeleteAll(); AvailabilityCalcOverview.Reset(); if AvailabilityCalcOverview.FindLast() then; SetEntryNo(AvailabilityCalcOverview."Entry No."); InsertAvailabilityEntry( AvailabilityCalcOverview, AvailabilityCalcOverview.Type::Item, 0D, '', '', 0, 0, 0, 0, '', Item.Description, DemandType::"All Demands"); CopyOfAvailabilityCalcOverview := AvailabilityCalcOverview; FirstEntryNo := AvailabilityCalcOverview."Entry No."; AvailabilityCalcOverview.CopyFilters(CopyOfAvailabilityCalcOverview); GetInventoryDates(AvailabilityCalcOverview); GetSupplyDates(AvailabilityCalcOverview); GetDemandDates(AvailabilityCalcOverview); AvailabilityCalcOverview.Reset(); AvailabilityCalcOverview.SetCurrentKey("Item No."); AvailabilityCalcOverview.SetRange("Item No.", Item."No."); AvailabilityCalcOverview.SetFilter(Date, CopyOfAvailabilityCalcOverview.GetFilter(Date)); AvailabilityCalcOverview.SetFilter("Location Code", CopyOfAvailabilityCalcOverview.GetFilter("Location Code")); AvailabilityCalcOverview.SetFilter("Variant Code", CopyOfAvailabilityCalcOverview.GetFilter("Variant Code")); if not AvailabilityCalcOverview.FindFirst() then begin AvailabilityCalcOverview.SetRange(Date); AvailabilityCalcOverview.SetRange("Location Code"); AvailabilityCalcOverview.SetRange("Variant Code"); AvailabilityCalcOverview.DeleteAll(); end else if DemandType = DemandType::"All Demands" then AvailabilityCalcOverview.ModifyAll(AvailabilityCalcOverview."Matches Criteria", true); AvailabilityCalcOverview.Reset(); if AvailabilityCalcOverview.Get(FirstEntryNo) then if AvailabilityCalcOverview.Next() = 0 then AvailabilityCalcOverview.Delete(); Item.Copy(CopyOfItem); AvailabilityCalcOverview.Copy(CopyOfAvailabilityCalcOverview); end; procedure CalculateDate(var AvailabilityCalcOverview: Record "Availability Calc. Overview") var CopyOfAvailabilityCalcOverview: Record "Availability Calc. Overview"; FirstEntryNo: Integer; begin CopyOfAvailabilityCalcOverview.Copy(AvailabilityCalcOverview); AttachedToEntryNo := AvailabilityCalcOverview."Attached to Entry No."; Item.Get(AvailabilityCalcOverview."Item No."); AvailabilityCalcOverview.Reset(); AvailabilityCalcOverview.SetRange("Item No.", AvailabilityCalcOverview."Item No."); AvailabilityCalcOverview.SetRange("Location Code", AvailabilityCalcOverview."Location Code"); AvailabilityCalcOverview.SetRange("Variant Code", AvailabilityCalcOverview."Variant Code"); AvailabilityCalcOverview.SetRange(Date, AvailabilityCalcOverview.Date); AvailabilityCalcOverview.SetRange(Level, 2, 3); AvailabilityCalcOverview.DeleteAll(); AvailabilityCalcOverview.Reset(); if AvailabilityCalcOverview.FindLast() then; SetEntryNo(AvailabilityCalcOverview."Entry No."); AvailabilityCalcOverview.TransferFields(CopyOfAvailabilityCalcOverview, false); FirstEntryNo := AvailabilityCalcOverview."Entry No."; Item.SetRange("Location Filter", AvailabilityCalcOverview."Location Code"); Item.SetRange("Variant Filter", AvailabilityCalcOverview."Variant Code"); Item.SetRange("Date Filter", AvailabilityCalcOverview.Date); GetSupplyEntries(AvailabilityCalcOverview); GetDemandEntries(AvailabilityCalcOverview); AvailabilityCalcOverview.Get(FirstEntryNo); if AvailabilityCalcOverview.Next() = 0 then; UpdateRunningTotals(AvailabilityCalcOverview); AvailabilityCalcOverview.Get(FirstEntryNo); if AvailabilityCalcOverview.Next() = 0 then; end; local procedure GetInventoryDates(var AvailabilityCalcOverview: Record "Availability Calc. Overview") var ItemLedgEntry: Record "Item Ledger Entry"; begin ItemLedgEntry.FilterLinesWithItemToPlan(Item, false); if ItemLedgEntry.FindFirst() then repeat ItemLedgEntry.SetRange("Location Code", ItemLedgEntry."Location Code"); ItemLedgEntry.SetRange("Variant Code", ItemLedgEntry."Variant Code"); ItemLedgEntry.CalcSums(ItemLedgEntry."Remaining Quantity"); ItemLedgEntry.SetRange(Positive, ItemLedgEntry.Positive); InsertAvailabilityEntry( AvailabilityCalcOverview, AvailabilityCalcOverview.Type::Inventory, 0D, ItemLedgEntry."Location Code", ItemLedgEntry."Variant Code", ItemLedgEntry."Remaining Quantity", 0, 0, 0, '', '', DemandType::"All Demands"); ItemLedgEntry.FindLast(); ItemLedgEntry.SetFilter(ItemLedgEntry."Location Code", AvailabilityCalcOverview.GetFilter("Location Code")); ItemLedgEntry.SetFilter(ItemLedgEntry."Variant Code", AvailabilityCalcOverview.GetFilter("Variant Code")); ItemLedgEntry.SetRange(Positive); until ItemLedgEntry.Next() = 0; end; local procedure GetSupplyDates(var AvailabilityCalcOverview: Record "Availability Calc. Overview") begin OnGetSupplyDates(AvailabilityCalcOverview, Item); end; local procedure GetDemandDates(var AvailabilityCalcOverview: Record "Availability Calc. Overview") begin OnGetDemandDates(AvailabilityCalcOverview, Item); end; local procedure GetSupplyEntries(var AvailabilityCalcOverview: Record "Availability Calc. Overview") var CopyOfItem: Record Item; begin CopyOfItem.Copy(Item); Item.SetRange("Location Filter", AvailabilityCalcOverview."Location Code"); Item.SetRange("Variant Filter", AvailabilityCalcOverview."Variant Code"); Item.SetRange("Date Filter", AvailabilityCalcOverview.Date); OnGetSupplyEntries(AvailabilityCalcOverview, Item); Item.Copy(CopyOfItem); end; local procedure GetDemandEntries(var AvailabilityCalcOverview: Record "Availability Calc. Overview") var CopyOfItem: Record Item; begin CopyOfItem.Copy(Item); Item.SetRange("Location Filter", AvailabilityCalcOverview."Location Code"); Item.SetRange("Variant Filter", AvailabilityCalcOverview."Variant Code"); Item.SetRange("Date Filter", AvailabilityCalcOverview.Date); OnGetDemandEntries(AvailabilityCalcOverview, Item); Item.Copy(CopyOfItem); end; procedure EntriesExist(var AvailabilityCalcOverview: Record "Availability Calc. Overview"): Boolean var Item: Record Item; begin Item.Get(AvailabilityCalcOverview."Item No."); Item.SetFilter("Location Filter", AvailabilityCalcOverview.GetFilter("Location Code")); Item.SetFilter("Variant Filter", AvailabilityCalcOverview.GetFilter("Variant Code")); Item.SetFilter("Date Filter", AvailabilityCalcOverview.GetFilter(Date)); exit(true in [InventoryExists(Item), SupplyExists(Item), DemandExists(Item)]); end; local procedure InventoryExists(var Item: Record Item): Boolean var ItemLedgEntry: Record "Item Ledger Entry"; begin exit(ItemLedgEntry.LinesWithItemToPlanExist(Item, false)); end; local procedure SupplyExists(var Item: Record Item) Exists: Boolean begin OnSupplyExist(Item, Exists); end; local procedure DemandExists(var Item: Record Item) Exists: Boolean begin OnDemandExist(Item, Exists); end; local procedure ClosingEntryExists(var AvailabilityCalcOverview: Record "Availability Calc. Overview"; NewType: Option; LocationCode: Code[20]; VariantCode: Code[20]; ClosingDate: Date) Found: Boolean var CopyOfAvailabilityCalcOverview: Record "Availability Calc. Overview"; begin CopyOfAvailabilityCalcOverview.Copy(AvailabilityCalcOverview); AvailabilityCalcOverview.SetRange("Item No.", Item."No."); AvailabilityCalcOverview.SetRange("Location Code", LocationCode); AvailabilityCalcOverview.SetRange("Variant Code", VariantCode); AvailabilityCalcOverview.SetRange(Date, ClosingDate); AvailabilityCalcOverview.SetRange(Type, NewType); Found := AvailabilityCalcOverview.FindFirst(); AvailabilityCalcOverview.CopyFilters(CopyOfAvailabilityCalcOverview); end; local procedure CheckItemInRange(var AvailabilityCalcOverview: Record "Availability Calc. Overview"): Boolean var Item: Record Item; Found: Boolean; begin Item.Get(AvailabilityCalcOverview."Item No."); Item.SetFilter("Location Filter", AvailabilityCalcOverview.GetFilter("Location Code")); Item.SetFilter("Variant Filter", AvailabilityCalcOverview.GetFilter("Variant Code")); Item.SetFilter("Date Filter", AvailabilityCalcOverview.GetFilter(Date)); OnCheckItemInRange(Item, DemandType, DemandNo, Found); if Found then exit(true); if DemandType = DemandType::"All Demands" then Found := DemandExists(Item); exit(Found); end; local procedure CheckDemandInDate(AvailCalcOverview: Record "Availability Calc. Overview"): Boolean begin AvailCalcOverview.SetRange("Location Code", AvailCalcOverview."Location Code"); AvailCalcOverview.SetRange("Variant Code", AvailCalcOverview."Variant Code"); AvailCalcOverview.SetRange(Date, AvailCalcOverview.Date); exit(CheckItemInRange(AvailCalcOverview)); end; procedure InsertAvailabilityEntry(var AvailabilityCalcOverview: Record "Availability Calc. Overview"; NewType: Integer; NewDate: Date; NewLocation: Code[10]; NewVariantCode: Code[10]) begin InsertAvailabilityEntry(AvailabilityCalcOverview, NewType, NewDate, NewLocation, NewVariantCode, 0, 0, 0, 0, '', '', "Demand Order Source Type"::"All Demands"); end; procedure InsertAvailabilityEntry(var AvailabilityCalcOverview: Record "Availability Calc. Overview"; NewType: Integer; NewDate: Date; NewLocation: Code[10]; NewVariantCode: Code[10]; NewQuantityBase: Decimal; NewReservQtyBase: Decimal; NewSourceType: Integer; NewSourceOrderStatus: Integer; NewSourceID: Code[20]; NewDescription: Text[100]; NewDemandType: Enum "Demand Order Source Type") var CopyOfItem: Record Item; begin if (NewDate <> 0D) and not (NewDate in [StartDate .. EndDate]) then exit; CopyOfItem.Copy(Item); if NewType in [AvailabilityCalcOverview.Type::"As of Date", AvailabilityCalcOverview.Type::Inventory] then if ClosingEntryExists(AvailabilityCalcOverview, NewType, NewLocation, NewVariantCode, NewDate) then begin if not AvailabilityCalcOverview."Matches Criteria" then begin AvailabilityCalcOverview."Matches Criteria" := CheckDemandInDate(AvailabilityCalcOverview); AvailabilityCalcOverview.Modify(); end; exit; end; if not (NewType in [AvailabilityCalcOverview.Type::Item, AvailabilityCalcOverview.Type::"As of Date"]) then if NewQuantityBase = 0 then exit; AvailabilityCalcOverview.Init(); AvailabilityCalcOverview."Entry No." := GetEntryNo(); AvailabilityCalcOverview.Type := NewType; AvailabilityCalcOverview."Item No." := Item."No."; AvailabilityCalcOverview.Date := NewDate; AvailabilityCalcOverview."Location Code" := NewLocation; AvailabilityCalcOverview."Variant Code" := NewVariantCode; AvailabilityCalcOverview.Quantity := NewQuantityBase; AvailabilityCalcOverview."Reserved Quantity" := NewReservQtyBase; if (DemandType = DemandType::"All Demands") or (AvailabilityCalcOverview.Type = AvailabilityCalcOverview.Type::"As of Date") or ((DemandType = NewDemandType) and (DemandNo in ['', NewSourceID])) then AvailabilityCalcOverview."Matches Criteria" := NewDate in [StartDate .. EndDate]; case NewType of AvailabilityCalcOverview.Type::Item: begin AvailabilityCalcOverview.Level := 0; AvailabilityCalcOverview."Matches Criteria" := true; end; AvailabilityCalcOverview.Type::Inventory: begin AvailabilityCalcOverview."Attached to Entry No." := AvailabilityCalcOverview."Entry No."; AvailabilityCalcOverview.Level := 1; AvailabilityCalcOverview."Inventory Running Total" := AvailabilityCalcOverview.Quantity; AvailabilityCalcOverview."Running Total" := AvailabilityCalcOverview.Quantity; end; AvailabilityCalcOverview.Type::"As of Date": begin AvailabilityCalcOverview."Attached to Entry No." := AvailabilityCalcOverview."Entry No."; AvailabilityCalcOverview.Level := 1; CalcRunningTotals( Item."No.", NewLocation, NewVariantCode, NewDate, AvailabilityCalcOverview."Running Total", AvailabilityCalcOverview."Inventory Running Total", AvailabilityCalcOverview."Supply Running Total", AvailabilityCalcOverview."Demand Running Total"); AllocateToDemand(AvailabilityCalcOverview."Inventory Running Total", AvailabilityCalcOverview."Supply Running Total", AvailabilityCalcOverview."Demand Running Total"); if AvailabilityCalcOverview."Matches Criteria" then AvailabilityCalcOverview."Matches Criteria" := CheckDemandInDate(AvailabilityCalcOverview); end; else AvailabilityCalcOverview."Attached to Entry No." := AttachedToEntryNo; AvailabilityCalcOverview.Level := 2; end; AvailabilityCalcOverview."Source Type" := NewSourceType; AvailabilityCalcOverview."Source Order Status" := NewSourceOrderStatus; AvailabilityCalcOverview."Source ID" := NewSourceID; AvailabilityCalcOverview.Description := NewDescription; OnInsertEntryOnBeforeInsert(AvailabilityCalcOverview); AvailabilityCalcOverview.Insert(); Item.Copy(CopyOfItem); end; local procedure CalcRunningTotals(NewItem: Code[20]; NewLocation: Code[10]; NewVariant: Code[10]; NewDate: Date; var RunningTotal: Decimal; var InventoryRunningTotal: Decimal; var SupplyRunningTotal: Decimal; var DemandRunningTotal: Decimal) var Item: Record Item; begin Item.Get(NewItem); Item.SetRange("Location Filter", NewLocation); Item.SetRange("Variant Filter", NewVariant); Item.SetRange("Date Filter", 0D, NewDate); Item.CalcFields( Item."Reserved Qty. on Purch. Orders", Item."Res. Qty. on Inbound Transfer", Item."Reserved Qty. on Sales Orders", Item."Res. Qty. on Job Order", Item."Res. Qty. on Outbound Transfer", Item."Reserved Qty. on Inventory", Item."Res. Qty. on Assembly Order", Item."Res. Qty. on Asm. Comp.", Item."Res. Qty. on Sales Returns", Item."Res. Qty. on Purch. Returns"); Item.CalcFields( Item."Qty. on Purch. Order", Item."Trans. Ord. Receipt (Qty.)", Item."Qty. on Sales Order", Item."Qty. on Job Order", Item."Trans. Ord. Shipment (Qty.)", Item.Inventory, Item."Qty. on Assembly Order", Item."Qty. on Asm. Component", Item."Qty. on Purch. Return", Item."Qty. on Sales Return"); SupplyRunningTotal := Item."Qty. on Purch. Order" - Item."Reserved Qty. on Purch. Orders" + Item."Qty. on Sales Return" - Item."Res. Qty. on Sales Returns" + Item.CalcScheduledReceiptQty() + Item.CalcPlannedOrderReceiptQty() - Item.CalcReservedQtyOnProdOrder() + Item."Trans. Ord. Receipt (Qty.)" - Item."Res. Qty. on Inbound Transfer" + Item."Qty. on Assembly Order" - Item."Res. Qty. on Assembly Order"; DemandRunningTotal := -Item."Qty. on Sales Order" + Item."Reserved Qty. on Sales Orders" - Item."Qty. on Purch. Return" + Item."Res. Qty. on Purch. Returns" - Item.CalcQtyOnComponentLines() + Item.CalcResQtyonProdOrderComp() - Item."Qty. on Job Order" + Item."Res. Qty. on Job Order" - Item."Trans. Ord. Shipment (Qty.)" + Item."Res. Qty. on Outbound Transfer" - Item."Qty. on Asm. Component" + Item."Res. Qty. on Asm. Comp."; OnAfterCalcDemandRunningTotal(Item, DemandRunningTotal); InventoryRunningTotal := Item.Inventory - Item."Reserved Qty. on Inventory"; RunningTotal := InventoryRunningTotal + SupplyRunningTotal + DemandRunningTotal; OnAfterCalcRunningTotals(Item, RunningTotal, InventoryRunningTotal, SupplyRunningTotal, DemandRunningTotal); end; local procedure UpdateRunningTotals(var AvailabilityCalcOverview: Record "Availability Calc. Overview") var CopyOfAvailCalcOverview: Record "Availability Calc. Overview"; FirstEntryNo: Integer; RunningTotal: Decimal; SupplyRunningTotal: Decimal; DemandRunningTotal: Decimal; InventoryRunningTotal: Decimal; begin CopyOfAvailCalcOverview.Copy(AvailabilityCalcOverview); FirstEntryNo := AvailabilityCalcOverview."Entry No."; if AvailabilityCalcOverview.Date <> 0D then CalcRunningTotals( AvailabilityCalcOverview."Item No.", AvailabilityCalcOverview."Location Code", AvailabilityCalcOverview."Variant Code", CalcDate('<-1D>', AvailabilityCalcOverview.Date), RunningTotal, InventoryRunningTotal, SupplyRunningTotal, DemandRunningTotal); repeat RunningTotal += AvailabilityCalcOverview.Quantity - AvailabilityCalcOverview."Reserved Quantity"; case AvailabilityCalcOverview.Type of AvailabilityCalcOverview.Type::Inventory: InventoryRunningTotal += AvailabilityCalcOverview.Quantity - AvailabilityCalcOverview."Reserved Quantity"; AvailabilityCalcOverview.Type::Supply, AvailabilityCalcOverview.Type::"Supply Forecast": SupplyRunningTotal += AvailabilityCalcOverview.Quantity - AvailabilityCalcOverview."Reserved Quantity"; AvailabilityCalcOverview.Type::Demand: DemandRunningTotal += AvailabilityCalcOverview.Quantity - AvailabilityCalcOverview."Reserved Quantity"; end; AvailabilityCalcOverview."Running Total" := RunningTotal; AvailabilityCalcOverview."Inventory Running Total" := InventoryRunningTotal; AvailabilityCalcOverview."Supply Running Total" := SupplyRunningTotal; AvailabilityCalcOverview."Demand Running Total" := DemandRunningTotal; AllocateToDemand(AvailabilityCalcOverview."Inventory Running Total", AvailabilityCalcOverview."Supply Running Total", AvailabilityCalcOverview."Demand Running Total"); if DemandType = DemandType::"All Demands" then AvailabilityCalcOverview."Matches Criteria" := CopyOfAvailCalcOverview."Matches Criteria"; OnUpdateRunningTotalsOnBeforeModify(AvailabilityCalcOverview); AvailabilityCalcOverview.Modify(); until AvailabilityCalcOverview.Next() = 0; AvailabilityCalcOverview.Get(FirstEntryNo); if AvailabilityCalcOverview.Next() = 0 then; end; local procedure AllocateToDemand(var InventoryRunningTotal: Decimal; var SupplyRunningTotal: Decimal; var DemandRunningTotal: Decimal) var RemQty: Decimal; begin RemQty := DemandRunningTotal; if RemQty < 0 then if InventoryRunningTotal > 0 then if -RemQty > InventoryRunningTotal then begin RemQty += InventoryRunningTotal; InventoryRunningTotal := 0; end else begin InventoryRunningTotal += RemQty; RemQty := 0; end; if RemQty < 0 then if SupplyRunningTotal > 0 then if -RemQty > SupplyRunningTotal then begin RemQty += SupplyRunningTotal; SupplyRunningTotal := 0; end else begin SupplyRunningTotal += RemQty; RemQty := 0; end; DemandRunningTotal := RemQty; end; local procedure GetEntryNo(): Integer begin EntryNo += 1; exit(EntryNo); end; local procedure SetEntryNo(NewEntryNo: Integer) begin EntryNo := NewEntryNo; end; procedure SetParameters(NewDemandType: Enum "Demand Order Source Type"; NewDemandNo: Code[20]) begin DemandType := NewDemandType; DemandNo := NewDemandNo; end; local procedure OpenWindow(DisplayText: Text[250]; NoOfRecords2: Integer) begin i := 0; NoOfRecords := NoOfRecords2; WindowUpdateDateTime := CurrentDateTime; Window.Open(DisplayText); end; local procedure UpdateWindow() begin i := i + 1; if CurrentDateTime - WindowUpdateDateTime >= 1000 then begin WindowUpdateDateTime := CurrentDateTime; Window.Update(1, Round(i / NoOfRecords * 10000, 1)); end; end; [IntegrationEvent(false, false)] local procedure OnAfterCalcRunningTotals(var Item: Record Item; var RunningTotal: Decimal; var InventoryRunningTotal: Decimal; var SupplyRunningTotal: Decimal; var DemandRunningTotal: Decimal) begin end; [IntegrationEvent(false, false)] local procedure OnInsertEntryOnBeforeInsert(var AvailabilityCalcOverview: Record "Availability Calc. Overview") begin end; [IntegrationEvent(false, false)] local procedure OnUpdateRunningTotalsOnBeforeModify(var AvailabilityCalcOverview: Record "Availability Calc. Overview") begin end; [IntegrationEvent(true, false)] local procedure OnGetDemandDates(var AvailabilityCalcOverview: Record "Availability Calc. Overview"; var Item: Record Item) begin end; [IntegrationEvent(true, false)] local procedure OnGetDemandEntries(var AvailabilityCalcOverview: Record "Availability Calc. Overview"; var Item: Record Item) begin end; [IntegrationEvent(true, false)] local procedure OnGetSupplyDates(var AvailabilityCalcOverview: Record "Availability Calc. Overview"; var Item: Record Item) begin end; [IntegrationEvent(true, false)] local procedure OnGetSupplyEntries(var AvailabilityCalcOverview: Record "Availability Calc. Overview"; var Item: Record Item) begin end; [IntegrationEvent(false, false)] local procedure OnCheckItemInRange(var Item: Record Item; DemandType: Enum "Demand Order Source Type"; DemandNo: Code[20]; var Found: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnDemandExist(var Item: Record Item; var Exists: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnSupplyExist(var Item: Record Item; var Exists: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnAfterCalcDemandRunningTotal(var Item: Record Item; var DemandRunningTotal: Decimal) begin end;}