Page 353 Item Availability Lines
src/Layers/W1/BaseApp/Inventory/Availability/ItemAvailabilityLines.Page.al396 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.Foundation.Enums;using Microsoft.Foundation.Period;using Microsoft.Inventory.Item;using Microsoft.Inventory.Transfer;page 353 "Item Availability Lines"{ Caption = 'Lines'; DeleteAllowed = false; InsertAllowed = false; LinksAllowed = false; ModifyAllowed = false; PageType = ListPart; ShowFilter = false; SourceTable = "Item Availability Buffer"; SourceTableTemporary = true; layout { area(content) { repeater(Control1) { Editable = false; ShowCaption = false; field("Period Start"; Rec."Period Start") { ApplicationArea = Basic, Suite; Caption = 'Period Start'; } field("Period Name"; Rec."Period Name") { ApplicationArea = Basic, Suite; Caption = 'Period Name'; } field(GrossRequirement; Rec."Gross Requirement") { ApplicationArea = Basic, Suite; Caption = 'Gross Requirement'; DecimalPlaces = 0 : 5; trigger OnDrillDown() begin ShowItemAvailLineList(0) end; } field(ScheduledRcpt; Rec."Scheduled Receipt") { ApplicationArea = Basic, Suite; Caption = 'Scheduled Receipt'; DecimalPlaces = 0 : 5; trigger OnDrillDown() begin ShowItemAvailLineList(2); end; } field(PlannedOrderRcpt; Rec."Planned Order Receipt") { ApplicationArea = Basic, Suite; Caption = 'Planned Order Receipt'; DecimalPlaces = 0 : 5; trigger OnDrillDown() begin ShowItemAvailLineList(1); end; } field(ProjAvailableBalance; Rec."Projected Available Balance") { ApplicationArea = Basic, Suite; Caption = 'Projected Available Balance'; DecimalPlaces = 0 : 5; trigger OnDrillDown() begin ShowItemAvailLineList(4); end; } field("Item.Inventory"; Rec.Inventory) { ApplicationArea = Basic, Suite; Caption = 'Inventory'; DecimalPlaces = 0 : 5; Visible = false; trigger OnDrillDown() begin ItemAvailFormsMgt.ShowItemLedgerEntries(Item, false); end; }#pragma warning disable AA0100 field("Item.""Qty. on Purch. Order"""; Rec."Qty. on Purch. Order")#pragma warning restore AA0100 { ApplicationArea = Basic, Suite; Caption = 'Qty. on Purch. Order'; DecimalPlaces = 0 : 5; DrillDown = true; ToolTip = 'Specifies how many units of the item are inbound on purchase orders, meaning listed on outstanding purchase order lines.'; Visible = false; trigger OnDrillDown() var PurchAvailabilityMgt: Codeunit Microsoft.Purchases.Document."Purch. Availability Mgt."; begin PurchAvailabilityMgt.ShowPurchLines(Item); end; }#pragma warning disable AA0100 field("Item.""Qty. on Sales Order"""; Rec."Qty. on Sales Order")#pragma warning restore AA0100 { ApplicationArea = Basic, Suite; Caption = 'Qty. on Sales Order'; DecimalPlaces = 0 : 5; DrillDown = true; ToolTip = 'Specifies how many units of the item are allocated to sales orders, meaning listed on outstanding sales orders lines.'; Visible = false; trigger OnDrillDown() var SalesAvailabilityMgt: Codeunit Microsoft.Sales.Document."Sales Availability Mgt."; begin SalesAvailabilityMgt.ShowSalesLines(Item); end; }#pragma warning disable AA0100 field("Item.""Qty. on Job Order"""; Rec."Qty. on Job Order")#pragma warning restore AA0100 { ApplicationArea = Jobs; Caption = 'Qty. on Project Order'; DecimalPlaces = 0 : 5; ToolTip = 'Specifies how many units of the item are allocated to projects, meaning listed on outstanding project planning lines. The field is automatically updated based on the Remaining Qty. field in the Project Planning Lines window.'; Visible = false; trigger OnDrillDown() var JobPlanningAvailabilityiMgt: Codeunit Microsoft.Projects.Project.Planning."Job Planning Availability Mgt."; begin JobPlanningAvailabilityiMgt.ShowJobPlanningLines(Item); end; }#pragma warning disable AA0100 field("Item.""Trans. Ord. Shipment (Qty.)"""; Rec."Trans. Ord. Shipment (Qty.)")#pragma warning restore AA0100 { ApplicationArea = Basic, Suite; Caption = 'Trans. Ord. Shipment (Qty.)'; DecimalPlaces = 0 : 5; ToolTip = 'Specifies the quantity of the items that remains to be shipped. The program calculates this quantity as the difference between the Quantity and the Quantity Shipped fields. It automatically updates the field each time you either update the Quantity or Quantity Shipped field.'; Visible = false; trigger OnDrillDown() var TransferAvailabilityMgt: Codeunit "Transfer Availability Mgt."; begin TransferAvailabilityMgt.ShowTransLines(Item, Item.FieldNo("Trans. Ord. Shipment (Qty.)")); end; }#pragma warning disable AA0100 field("Item.""Qty. in Transit"""; Rec."Qty. in Transit")#pragma warning restore AA0100 { ApplicationArea = Location; Caption = 'Qty. in Transit'; DecimalPlaces = 0 : 5; ToolTip = 'Specifies the quantity of the items that are currently in transit.'; Visible = false; trigger OnDrillDown() var TransferAvailabilityMgt: Codeunit "Transfer Availability Mgt."; begin TransferAvailabilityMgt.ShowTransLines(Item, Item.FieldNo("Qty. in Transit")); end; }#pragma warning disable AA0100 field("Item.""Trans. Ord. Receipt (Qty.)"""; Rec."Trans. Ord. Receipt (Qty.)")#pragma warning restore AA0100 { ApplicationArea = Basic, Suite; Caption = 'Trans. Ord. Receipt (Qty.)'; DecimalPlaces = 0 : 5; ToolTip = 'Specifies the quantity of the items that remain to be received but are not yet shipped. The program calculates this quantity as the difference between the Quantity and the Quantity Shipped fields. It automatically updates the field each time you either update the Quantity or Quantity Shipped field.'; Visible = false; trigger OnDrillDown() var TransferAvailabilityMgt: Codeunit "Transfer Availability Mgt."; begin TransferAvailabilityMgt.ShowTransLines(Item, Item.FieldNo("Trans. Ord. Receipt (Qty.)")); end; }#pragma warning disable AA0100 field("Item.""Qty. on Asm. Component"""; Rec."Qty. on Asm. Comp. Lines")#pragma warning restore AA0100 { ApplicationArea = Assembly; Caption = 'Qty. on Asm. Comp. Lines'; ToolTip = 'Specifies how many units of the item are allocated to assembly component orders.'; Visible = false; trigger OnDrillDown() var AssemblyAvailabilityMgt: Codeunit Microsoft.Assembly.Document."Assembly Availability Mgt."; begin AssemblyAvailabilityMgt.ShowAsmCompLines(Item); end; }#pragma warning disable AA0100 field("Item.""Qty. on Assembly Order"""; Rec."Qty. on Assembly Order")#pragma warning restore AA0100 { ApplicationArea = Assembly; Caption = 'Qty. on Assembly Order'; ToolTip = 'Specifies how many units of the item are allocated to assembly orders, which is how many are listed on outstanding assembly order headers.'; Visible = false; trigger OnDrillDown() var AssemblyAvailabilityMgt: Codeunit Microsoft.Assembly.Document."Assembly Availability Mgt."; begin AssemblyAvailabilityMgt.ShowAsmOrders(Item); end; } field(ExpectedInventory; Rec."Expected Inventory") { ApplicationArea = Assembly; Caption = 'Expected Inventory'; DecimalPlaces = 0 : 5; Visible = false; } field(QtyAvailable; Rec."Available Inventory") { ApplicationArea = Basic, Suite; Caption = 'Available Inventory'; DecimalPlaces = 0 : 5; Visible = false; } field(PlannedOrderReleases; Rec."Planned Order Releases") { ApplicationArea = Basic, Suite; Caption = 'Planned Order Releases'; DecimalPlaces = 0 : 5; Visible = true; trigger OnDrillDown() begin ShowItemAvailLineList(3); end; }#pragma warning disable AA0100 field("Item.""Net Change"""; Rec."Net Change")#pragma warning restore AA0100 { ApplicationArea = Basic, Suite; Caption = 'Net Change'; DecimalPlaces = 0 : 5; DrillDown = true; ToolTip = 'Specifies the net change in the inventory of the item during the period entered in the Date Filter field.'; Visible = false; trigger OnDrillDown() begin ItemAvailFormsMgt.ShowItemLedgerEntries(Item, true); end; } } } } actions { } trigger OnAfterGetRecord() begin if DateRec.Get(Rec."Period Type", Rec."Period Start") then; CalcAvailQuantities(Item); end; trigger OnInit() begin SetItemFilter(); end; trigger OnFindRecord(Which: Text) FoundDate: Boolean var VariantRec: Variant; begin VariantRec := Rec; FoundDate := PeriodFormLinesMgt.FindDate(VariantRec, DateRec, Which, PeriodType.AsInteger()); Rec := VariantRec; end; trigger OnNextRecord(Steps: Integer) ResultSteps: Integer var VariantRec: Variant; begin VariantRec := Rec; ResultSteps := PeriodFormLinesMgt.NextDate(VariantRec, DateRec, Steps, PeriodType.AsInteger()); Rec := VariantRec; end; trigger OnOpenPage() begin Rec.Reset(); end; var DateRec: Record System.Utilities.Date; ItemAvailFormsMgt: Codeunit "Item Availability Forms Mgt"; PeriodFormLinesMgt: Codeunit "Period Form Lines Mgt."; protected var Item: Record Item; PeriodType: Enum "Analysis Period Type"; AmountType: Enum "Analysis Amount Type"; procedure SetLines(var NewItem: Record Item; NewPeriodType: Enum "Analysis Period Type"; NewAmountType: Enum "Analysis Amount Type") begin Item.Copy(NewItem); Rec.DeleteAll(); PeriodType := NewPeriodType; AmountType := NewAmountType; CurrPage.Update(false); OnAfterSet(Item, PeriodType.AsInteger(), AmountType); end; local procedure SetItemFilter() begin if AmountType = AmountType::"Net Change" then Item.SetRange("Date Filter", Rec."Period Start", Rec."Period End") else Item.SetRange("Date Filter", 0D, Rec."Period End"); OnAfterSetItemFilter(Item, Rec."Period Start", Rec."Period End"); end; local procedure ShowItemAvailLineList(What: Integer) begin SetItemFilter(); ItemAvailFormsMgt.ShowItemAvailLineList(Item, What); end; local procedure CalcAvailQuantities(var Item: Record Item) var DummyQtyAvailable: Decimal; begin SetItemFilter(); ItemAvailFormsMgt.CalcAvailQuantities( Item, AmountType = AmountType::"Balance at Date", Rec."Gross Requirement", Rec."Planned Order Receipt", Rec."Scheduled Receipt", Rec."Planned Order Releases", Rec."Projected Available Balance", Rec."Expected Inventory", DummyQtyAvailable, Rec."Available Inventory"); Rec.Inventory := Item.Inventory; Rec."Qty. on Purch. Order" := Item."Qty. on Purch. Order"; Rec."Qty. on Sales Order" := Item."Qty. on Sales Order"; Rec."Qty. on Job Order" := Item."Qty. on Job Order"; Rec."Trans. Ord. Shipment (Qty.)" := Item."Trans. Ord. Shipment (Qty.)"; Rec."Qty. in Transit" := Item."Qty. in Transit"; Rec."Trans. Ord. Receipt (Qty.)" := Item."Trans. Ord. Receipt (Qty.)"; Rec."Qty. on Asm. Comp. Lines" := Item."Qty. on Asm. Component"; Rec."Qty. on Assembly Order" := Item."Qty. on Assembly Order"; Rec."Scheduled Receipt (Qty.)" := Item.CalcScheduledReceiptQty(); Rec."Scheduled Issue (Qty.)" := Item.CalcQtyOnComponentLines(); Rec."Net Change" := Item."Net Change"; OnAfterCalcAvailQuantities(Rec, Item); end; [IntegrationEvent(true, false)] local procedure OnAfterCalcAvailQuantities(var ItemAvailabilityBuffer: Record "Item Availability Buffer"; var Item: Record Item) begin end; [IntegrationEvent(false, false)] local procedure OnAfterSet(var Item: Record Item; PeriodType: Integer; AmountType: Enum "Analysis Amount Type") begin end; [IntegrationEvent(false, false)] local procedure OnAfterSetItemFilter(var Item: Record Item; PeriodStart: Date; PeriodEnd: Date) begin end;}