Page 353 Item Availability Lines

Base Application, Microsoft.Inventory.Availability

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;}