Page 99000902 Item Availability Line List

Base Application, Microsoft.Inventory.Availability

src/Layers/W1/BaseApp/Inventory/Availability/ItemAvailabilityLineList.Page.al190 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;page 99000902 "Item Availability Line List"{    Caption = 'Item Availability Line List';    Editable = false;    PageType = List;    SourceTable = "Item Availability Line";    SourceTableTemporary = true;    layout    {        area(content)        {            repeater(Control1)            {                ShowCaption = false;                field(Name; Rec.Name)                {                    ApplicationArea = Basic, Suite;                }                field(Quantity; Rec.Quantity)                {                    ApplicationArea = Basic, Suite;                    trigger OnDrillDown()                    begin                        LookupEntries();                    end;                }            }        }    }    actions    {    }    trigger OnOpenPage()    begin        Rec.DeleteAll();        MakeWhat();    end;    var        ItemLedgerEntry: Record "Item Ledger Entry";        AvailType: Option "Gross Requirement","Planned Order Receipt","Scheduled Order Receipt","Planned Order Release",All;        Sign: Integer;        QtyByUnitOfMeasure: Decimal;    protected var        Item: Record Item;    procedure Init(NewType: Option "Gross Requirement","Planned Order Receipt","Scheduled Order Receipt","Planned Order Release",All; var NewItem: Record Item)    begin        AvailType := NewType;        Item.Copy(NewItem);        OnAfterInit(NewItem, AvailType);    end;    local procedure MakeEntries()    begin        case AvailType of        end;        OnAfterMakeEntries(Item, Rec, AvailType, Sign, QtyByUnitOfMeasure);    end;    local procedure MakeWhat()    begin        Sign := 1;        if AvailType <> AvailType::All then            MakeEntries()        else begin            Item.SetRange("Date Filter", 0D, Item.GetRangeMax("Date Filter"));            OnItemSetFilter(Item);            Item.CalcFields(              "Qty. on Purch. Order",              "Qty. on Sales Order",              "Qty. on Job Order",              "Net Change",              "Purch. Req. Receipt (Qty.)",              "Planning Issues (Qty.)",              "Purch. Req. Release (Qty.)",              "Qty. in Transit",              "Trans. Ord. Shipment (Qty.)",              "Trans. Ord. Receipt (Qty.)",              "Qty. on Assembly Order",              "Qty. on Asm. Component",              "Qty. on Purch. Return",              "Qty. on Sales Return");            OnItemCalcFields(Item);            if Item.Inventory <> 0 then                Rec.InsertEntry(                    Database::"Item Ledger Entry", Item.FieldNo(Inventory),                    ItemLedgerEntry.TableCaption(), Item.Inventory, QtyByUnitOfMeasure, Sign);            AvailType := AvailType::"Gross Requirement";            Sign := -1;            MakeEntries();            AvailType := AvailType::"Planned Order Receipt";            Sign := 1;            MakeEntries();            AvailType := AvailType::"Scheduled Order Receipt";            Sign := 1;            MakeEntries();            AvailType := AvailType::All;        end;    end;    local procedure LookupEntries()    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeLookupEntries(Rec, Item, IsHandled);        if IsHandled then            exit;        case Rec."Table No." of            Database::"Item Ledger Entry":                begin                    ItemLedgerEntry.SetCurrentKey("Item No.", "Entry Type", "Variant Code", "Drop Shipment", "Location Code", "Posting Date");                    ItemLedgerEntry.SetRange("Item No.", Item."No.");                    ItemLedgerEntry.SetFilter("Variant Code", Item.GetFilter("Variant Filter"));                    ItemLedgerEntry.SetFilter("Drop Shipment", Item.GetFilter("Drop Shipment Filter"));                    ItemLedgerEntry.SetFilter("Location Code", Item.GetFilter("Location Filter"));                    ItemLedgerEntry.SetFilter("Global Dimension 1 Code", Item.GetFilter("Global Dimension 1 Filter"));                    ItemLedgerEntry.SetFilter("Global Dimension 2 Code", Item.GetFilter("Global Dimension 2 Filter"));                    ItemLedgerEntry.SetFilter("Unit of Measure Code", Item.GetFilter("Unit of Measure Filter"));                    OnItemLedgerEntrySetFilter(ItemLedgerEntry);                    PAGE.RunModal(0, ItemLedgerEntry);                end;        end;        OnAfterLookupEntries(Item, Rec."Table No.", Rec);    end;    procedure SetQtyByUnitOfMeasure(NewQtyByUnitOfMeasure: Decimal);    begin        QtyByUnitOfMeasure := NewQtyByUnitOfMeasure;    end;    [IntegrationEvent(false, false)]    local procedure OnItemCalcFields(var Item: Record Item)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnItemSetFilter(var Item: Record Item)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnItemLedgerEntrySetFilter(var ItemLedgerEntry: Record "Item Ledger Entry")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterMakeEntries(var Item: Record Item; var ItemAvailabilityLine: Record "Item Availability Line"; AvailabilityType: Option; Sign: Decimal; QtyByUnitOfMeasure: Decimal)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterLookupEntries(var Item: Record Item; TableID: Integer; ItemAvailabilityLine: Record "Item Availability Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeLookupEntries(ItemAvailabilityLine: Record "Item Availability Line"; var Item: Record Item; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterInit(var Item: Record Item; var AvailType: Option "Gross Requirement","Planned Order Receipt","Scheduled Order Receipt","Planned Order Release",All)    begin    end;}