Page 500 Available - Requisition Lines
- App
- Base Application
- Namespace
- Microsoft.Inventory.Requisition
- Versions
- 17-28
- Source table
- 246
Procedures, 14Events, 3Obsolete, 11
Versions171819202122232425262728
Source29
Source in 29
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;
}