Page 500 Available - Requisition Lines
src/Layers/W1/BaseApp/Inventory/Requisition/AvailableRequisitionLines.Page.al334 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.Requisition;using Microsoft.Finance.Dimension;using Microsoft.Foundation.Enums;using Microsoft.Inventory.Item;using Microsoft.Inventory.Tracking;page 500 "Available - Requisition Lines"{ Caption = 'Available - Requisition Lines'; DataCaptionExpression = CaptionText; DeleteAllowed = false; Editable = false; InsertAllowed = false; LinksAllowed = false; ModifyAllowed = false; PageType = List; Permissions = TableData "Requisition Line" = rm; SourceTable = "Requisition Line"; SourceTableView = sorting(Type, "No.", "Variant Code", "Location Code", "Sales Order No.", "Planning Line Origin", "Due Date"); layout { area(content) { repeater(Control1) { ShowCaption = false; field("Location Code"; Rec."Location Code") { ApplicationArea = Location; } field("Due Date"; Rec."Due Date") { ApplicationArea = Basic, Suite; } field("Quantity (Base)"; Rec."Quantity (Base)") { ApplicationArea = Basic, Suite; ToolTip = 'Specifies that when the quantity field is updated, this field is updated.'; } field("Reserved Qty. (Base)"; Rec."Reserved Qty. (Base)") { ApplicationArea = Reservation; Editable = false; ToolTip = 'Specifies that when the reserved quantity field is updated, this field is updated.'; } field(QtyToReserveBase; QtyToReserveBase) { 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 requisition line, 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("&Line") { Caption = '&Line'; Image = Line; 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(); CurrPage.SaveRecord(); 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() begin ReservEntry.LockTable(); UpdateReservMgt(); Rec.GetReservationQty(QtyReserved, QtyReservedBase, QtyToReserve, QtyToReserveBase); ReservMgt.CalculateRemainingQty(NewQtyReserved, NewQtyReservedBase); ReservMgt.CopySign(NewQtyReserved, QtyToReserve); ReservMgt.CopySign(NewQtyReservedBase, QtyToReserveBase); if NewQtyReservedBase <> 0 then if Abs(NewQtyReservedBase) > Abs(QtyToReserveBase) then CreateReservation(QtyToReserve, QtyToReserveBase) else CreateReservation(NewQtyReserved, NewQtyReservedBase) else Error(Text000); end; } action("&Cancel Reservation") { 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() var ConfirmManagement: Codeunit System.Utilities."Confirm Management"; begin if not ConfirmManagement.GetResponseOrDefault(Text001, true) then exit; ReservEntry2.Copy(ReservEntry); Rec.SetReservationFilters(ReservEntry2); if ReservEntry2.Find('-') then begin UpdateReservMgt(); repeat ReservEngineMgt.CancelReservation(ReservEntry2); until ReservEntry2.Next() = 0; UpdateReservFrom(); end; end; } action("&Show Entire Worksheet") { ApplicationArea = Planning; Caption = '&Show Entire Worksheet'; Image = Worksheet; ToolTip = 'Open the requisition worksheet that the view is based on.'; trigger OnAction() var ReqWkshTemplate: Record "Req. Wksh. Template"; ReqLine2: Record "Requisition Line"; begin ReqWkshTemplate.Get(Rec."Worksheet Template Name"); ReqLine2 := Rec; ReqLine2.FilterGroup(2); ReqLine2.SetRange("Worksheet Template Name", Rec."Worksheet Template Name"); ReqLine2.SetRange("Journal Batch Name", Rec."Journal Batch Name"); ReqLine2.FilterGroup(0); PAGE.Run(ReqWkshTemplate."Page ID", ReqLine2); end; } } } } trigger OnAfterGetRecord() begin Rec.GetReservationQty(QtyReserved, QtyReservedBase, QtyToReserve, QtyToReserveBase); 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; NewQtyReservedBase: Decimal; CaptionText: Text;#pragma warning disable AA0074 Text000: Label 'Fully reserved.'; Text001: Label 'Do you want to cancel the reservation?';#pragma warning disable AA0470 Text003: Label 'Available Quantity is %1.';#pragma warning restore AA0470#pragma warning restore AA0074 protected var ReservEntry: Record "Reservation Entry"; SourceRecRef: RecordRef; QtyToReserve: Decimal; QtyToReserveBase: Decimal; QtyReserved: Decimal; QtyReservedBase: Decimal; 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; local procedure CreateReservation(ReserveQuantity: Decimal; ReserveQuantityBase: Decimal) var TrackingSpecification: Record "Tracking Specification"; begin Rec.CalcFields("Reserved Qty. (Base)"); if Rec."Quantity (Base)" - Rec."Reserved Qty. (Base)" < ReserveQuantityBase then Error(Text003, Rec."Quantity (Base)" + Rec."Reserved Qty. (Base)"); Rec.TestField("No.", ReservEntry."Item No."); Rec.TestField("Variant Code", ReservEntry."Variant Code"); Rec.TestField("Location Code", ReservEntry."Location Code"); UpdateReservMgt(); TrackingSpecification.InitTrackingSpecification( DATABASE::"Requisition Line", 0, Rec."Worksheet Template Name", Rec."Journal Batch Name", 0, Rec."Line No.", Rec."Variant Code", Rec."Location Code", Rec."Qty. per Unit of Measure"); ReservMgt.CreateReservation( ReservEntry.Description, Rec."Due Date", ReserveQuantity, ReserveQuantityBase, 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()); 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() begin Rec.SetRange(Type, Rec.Type::Item); Rec.SetRange("No.", ReservEntry."Item No."); Rec.SetRange("Variant Code", ReservEntry."Variant Code"); Rec.SetRange("Location Code", ReservEntry."Location Code"); Rec.SetFilter("Due Date", ReservMgt.GetAvailabilityFilter(ReservEntry."Shipment Date")); if ReservMgt.IsPositive() then Rec.SetFilter("Quantity (Base)", '>0') else Rec.SetFilter("Quantity (Base)", '<0'); Rec.SetRange("Sales Order No.", ''); OnAfterSetFilters(Rec, ReservEntry); end; [IntegrationEvent(false, false)] local procedure OnAfterSetFilters(var RequisitionLine: Record "Requisition Line"; ReservationEntry: Record "Reservation Entry") 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;}