Page 504 Available - Item Ledg. Entries

Base Application, Microsoft.Inventory.Ledger

src/Layers/W1/BaseApp/Inventory/Ledger/AvailableItemLedgEntries.Page.al394 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.Ledger;using Microsoft.Finance.Dimension;using Microsoft.Foundation.Enums;using Microsoft.Inventory.Item;using Microsoft.Inventory.Tracking;page 504 "Available - Item Ledg. Entries"{    Caption = 'Available - Item Ledg. Entries';    DataCaptionExpression = CaptionText;    DeleteAllowed = false;    Editable = false;    InsertAllowed = false;    LinksAllowed = false;    ModifyAllowed = false;    PageType = List;    Permissions = TableData "Item Ledger Entry" = rm;    SourceTable = "Item Ledger Entry";    SourceTableView = sorting("Item No.", Open);    layout    {        area(content)        {            repeater(Control1)            {                ShowCaption = false;                field("Entry Type"; Rec."Entry Type")                {                    ApplicationArea = Basic, Suite;                }                field("Document No."; Rec."Document No.")                {                    ApplicationArea = Basic, Suite;                }                field("Serial No."; Rec."Serial No.")                {                    ApplicationArea = ItemTracking;                    Visible = false;                }                field("Lot No."; Rec."Lot No.")                {                    ApplicationArea = ItemTracking;                    Visible = false;                }                field("Package No."; Rec."Package No.")                {                    ApplicationArea = ItemTracking;                }                field("Location Code"; Rec."Location Code")                {                    ApplicationArea = Location;                }                field("Posting Date"; Rec."Posting Date")                {                    ApplicationArea = Basic, Suite;                }                field("Remaining Quantity"; Rec."Remaining Quantity")                {                    ApplicationArea = Basic, Suite;                }                field("Reserved Quantity"; Rec."Reserved Quantity")                {                    ApplicationArea = Reservation;                    Editable = false;                }                field(QtyToReserve; QtyToReserve)                {                    ApplicationArea = Reservation;                    AutoFormatType = 0;                    Caption = 'Available Quantity';                    DecimalPlaces = 0 : 5;                    Editable = false;                    ToolTip = 'Specifies the quantity of the item that is available for reservation.';                }                field(ReservedQuantity; GetReservedQtyInLine())                {                    ApplicationArea = Reservation;                    AutoFormatType = 0;                    Caption = 'Current Reserved Quantity';                    DecimalPlaces = 0 : 5;                    ToolTip = 'Specifies the quantity of the item that is reserved from the item ledger entry, for the current line or entry.';                    trigger OnDrillDown()                    begin                        ReservEntry2.Reset();                        Rec.SetReservationFilters(ReservEntry2);                        ReservEntry2.SetRange("Reservation Status", ReservEntry2."Reservation Status"::Reservation);                        ReservMgt.MarkReservConnection(ReservEntry2, ReservEntry);                        PAGE.RunModal(PAGE::"Reservation Entries", ReservEntry2);                        UpdateReservFrom();                        CurrPage.Update();                    end;                }            }        }    }    actions    {        area(navigation)        {            group("Ent&ry")            {                Caption = 'Ent&ry';                Image = Entry;                action(Dimensions)                {                    AccessByPermission = TableData Dimension = R;                    ApplicationArea = Dimensions;                    Caption = 'Dimensions';                    Image = Dimensions;                    ShortCutKey = 'Alt+D';                    ToolTip = 'View or edit dimensions, such as area, project, or department, that you can assign to sales and purchase documents to distribute costs and analyze transaction history.';                    trigger OnAction()                    begin                        Rec.ShowDimensions();                    end;                }            }        }        area(processing)        {            group("F&unctions")            {                Caption = 'F&unctions';                Image = "Action";                action(Reserve)                {                    ApplicationArea = Reservation;                    Caption = '&Reserve';                    Image = Reserve;                    ToolTip = 'Reserve the quantity that is required on the document line that you opened this window for.';                    trigger OnAction()                    var                        NewQtyReserved2: Decimal;                    begin                        ReservEntry.LockTable();                        UpdateReservMgt();                        Rec.GetReservationQty(QtyReserved, QtyToReserve);                        ReservMgt.CalculateRemainingQty(NewQtyReserved2, NewQtyReserved);                        if MaxQtyDefined and (Abs(MaxQtyToReserve) < Abs(NewQtyReserved)) then                            NewQtyReserved := MaxQtyToReserve;                        ReservMgt.CopySign(NewQtyReserved, QtyToReserve);                        if NewQtyReserved <> 0 then begin                            OnBeforeCreateReservation(ReservEntry, Rec."Lot No.", Rec."Serial No.");                            if Abs(NewQtyReserved) > Abs(QtyToReserve) then begin                                CreateReservation(QtyToReserve);                                MaxQtyToReserve := MaxQtyToReserve - QtyToReserve;                            end else begin                                CreateReservation(NewQtyReserved);                                MaxQtyToReserve := MaxQtyToReserve - NewQtyReserved;                            end;                            if MaxQtyToReserve < 0 then                                MaxQtyToReserve := 0;                        end else                            Error(FullyReservedErr);                    end;                }                action(CancelReservation)                {                    AccessByPermission = TableData Item = R;                    ApplicationArea = Reservation;                    Caption = '&Cancel Reservation';                    Image = Cancel;                    ToolTip = 'Cancel the reservation that exists for the document line that you opened this window for.';                    trigger OnAction()                    begin                        if not Confirm(CancelReservationQst, false) then                            exit;                        Rec.GetReservationQty(QtyReserved, QtyToReserve);                        ReservEntry2.Copy(ReservEntry);                        if ReservMgt.IsPositive() then                            Rec.SetReservationFilters(ReservEntry2)                        else                            Error(CanCancelInventoryReservationOnlyErr);                        ReservEntry2.SetRange("Expected Receipt Date");                        if ReservEntry2.Find('-') then begin                            UpdateReservMgt();                            repeat                                ReservEngineMgt.CancelReservation(ReservEntry2);                            until ReservEntry2.Next() = 0;                            TotalAvailQty := TotalAvailQty + QtyReserved;                            MaxQtyToReserve := MaxQtyToReserve + QtyReserved;                            UpdateReservFrom();                        end;                    end;                }            }        }        area(Promoted)        {            group(Category_Process)            {                Caption = 'Process';                actionref(Reserve_Promoted; Reserve)                {                }                actionref(CancelReservation_Promoted; CancelReservation)                {                }                actionref(Dimensions_Promoted; Dimensions)                {                }            }        }    }    trigger OnAfterGetRecord()    begin        Rec.GetReservationQty(QtyReserved, QtyToReserve);    end;    trigger OnOpenPage()    begin        ReservEntry.TestField("Source Type");        SetFilters();    end;    var        ReservEntry2: Record "Reservation Entry";        ReservMgt: Codeunit "Reservation Management";        ReservEngineMgt: Codeunit "Reservation Engine Mgt.";        NewQtyReserved: Decimal;        CaptionText: Text;        FullyReservedErr: Label 'Fully reserved.';        CancelReservationQst: Label 'Do you want to cancel the reservation?';        ReservationCannotBeCarriedErr: Label 'Reservation cannot be carried out because the available quantity is already allocated in a warehouse.';        CanCancelInventoryReservationOnlyErr: Label 'You can only cancel reservations to inventory.';        CannotReserveFromSpecialOrderErr: Label 'You cannot reserve from this item ledger entry because the associated special sales order %1 has not been posted yet.', Comment = '%1: Sales Order No.';    protected var        ReservEntry: Record "Reservation Entry";        SourceRecRef: RecordRef;        QtyToReserve: Decimal;        QtyReserved: Decimal;        TotalAvailQty: Decimal;        MaxQtyToReserve: Decimal;        MaxQtyDefined: Boolean;    procedure SetSource(CurrentSourceRecRef: RecordRef; CurrentReservEntry: Record "Reservation Entry")    var        TransferDirection: Enum "Transfer Direction";    begin        SetSource(CurrentSourceRecRef, CurrentReservEntry, TransferDirection::Outbound);    end;    procedure SetSource(CurrentSourceRecRef: RecordRef; CurrentReservEntry: Record "Reservation Entry"; Direction: Enum "Transfer Direction")    begin        Clear(ReservMgt);        SourceRecRef := CurrentSourceRecRef;        ReservEntry := CurrentReservEntry;        ReservMgt.TestItemType(SourceRecRef);        ReservMgt.SetReservSource(SourceRecRef, Direction);        CaptionText := ReservMgt.FilterReservFor(SourceRecRef, ReservEntry, Direction);    end;    procedure SetTotalAvailQty(TotalAvailQty2: Decimal)    begin        TotalAvailQty := TotalAvailQty2;    end;    procedure SetMaxQtyToReserve(NewMaxQtyToReserve: Decimal)    begin        MaxQtyToReserve := NewMaxQtyToReserve;        MaxQtyDefined := true;    end;    local procedure CreateReservation(var ReserveQuantity: Decimal)    var        TrackingSpecification: Record "Tracking Specification";        SpecialOrderSalesNo: Code[20];    begin        Rec.TestField("Drop Shipment", false);        Rec.TestField("Item No.", ReservEntry."Item No.");        Rec.TestField("Variant Code", ReservEntry."Variant Code");        Rec.TestField("Location Code", ReservEntry."Location Code");        SpecialOrderSalesNo := ReservMgt.FindUnfinishedSpecialOrderSalesNo(Rec);        if SpecialOrderSalesNo <> '' then            Error(CannotReserveFromSpecialOrderErr, SpecialOrderSalesNo);        if TotalAvailQty < 0 then begin            ReserveQuantity := 0;            exit;        end;        if TotalAvailQty < ReserveQuantity then            ReserveQuantity := TotalAvailQty;        TotalAvailQty := TotalAvailQty - ReserveQuantity;        if (TotalAvailQty = 0) and           (ReserveQuantity = 0) and           (QtyToReserve <> 0)        then            Error(ReservationCannotBeCarriedErr);        UpdateReservMgt();        TrackingSpecification.InitTrackingSpecification(            DATABASE::"Item Ledger Entry", 0, '', '', 0, Rec."Entry No.",            Rec."Variant Code", Rec."Location Code", Rec."Qty. per Unit of Measure");        TrackingSpecification.CopyTrackingFromItemLedgEntry(Rec);        ReservMgt.CreateReservation(          ReservEntry.Description, 0D, 0, ReserveQuantity, TrackingSpecification);        UpdateReservFrom();    end;    local procedure UpdateReservFrom()    begin        SetSource(SourceRecRef, ReservEntry, ReservEntry.GetTransferDirection());        OnAfterUpdateReservFrom(ReservEntry);    end;    local procedure UpdateReservMgt()    begin        Clear(ReservMgt);        ReservMgt.SetReservSource(SourceRecRef, ReservEntry.GetTransferDirection());        ReservMgt.SetTrackingFromReservEntry(ReservEntry);        OnAfterUpdateReservMgt(ReservEntry);    end;    protected procedure GetReservedQtyInLine(): Decimal    begin        ReservEntry2.Reset();        Rec.SetReservationFilters(ReservEntry2);        ReservEntry2.SetRange("Reservation Status", ReservEntry2."Reservation Status"::Reservation);        exit(ReservMgt.MarkReservConnection(ReservEntry2, ReservEntry));    end;    local procedure SetFilters()    var        ItemTrackingType: Enum "Item Tracking Type";        FieldFilter: Text;    begin        Rec.Reset();        Rec.SetRange("Item No.", ReservEntry."Item No.");        Rec.SetRange("Variant Code", ReservEntry."Variant Code");        Rec.SetRange("Location Code", ReservEntry."Location Code");        Rec.SetRange("Drop Shipment", false);        Rec.SetRange(Open, true);        if ReservEntry.FieldFilterNeeded(FieldFilter, ReservMgt.IsPositive(), ItemTrackingType::"Lot No.") then            Rec.SetFilter("Lot No.", FieldFilter);        if ReservEntry.FieldFilterNeeded(FieldFilter, ReservMgt.IsPositive(), ItemTrackingType::"Serial No.") then            Rec.SetFilter("Serial No.", FieldFilter);        if ReservMgt.IsPositive() then begin            Rec.SetRange(Positive, true);            Rec.SetFilter("Remaining Quantity", '>0');        end else begin            Rec.SetRange(Positive, false);            Rec.SetFilter("Remaining Quantity", '<0');        end;        OnAfterSetFilters(Rec, ReservEntry, ReservMgt);    end;    [IntegrationEvent(false, false)]    local procedure OnAfterSetFilters(var ItemLedgerEntry: Record "Item Ledger Entry"; ReservationEntry: Record "Reservation Entry"; var ReservMgt: Codeunit "Reservation Management")    begin    end;    [IntegrationEvent(true, false)]    local procedure OnAfterUpdateReservFrom(var ReservationEntry: Record "Reservation Entry")    begin    end;    [IntegrationEvent(true, false)]    local procedure OnAfterUpdateReservMgt(var ReservationEntry: Record "Reservation Entry")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCreateReservation(ReservationEntry: Record "Reservation Entry"; LotNo: Code[50]; SerialNo: Code[50])    begin    end;}