Report 302 Get Demand To Reserve

Base Application, Microsoft.Inventory.Tracking

src/Layers/W1/BaseApp/Inventory/Tracking/GetDemandToReserve.Report.al428 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.Tracking;using Microsoft.Inventory.Item;using Microsoft.Inventory.Transfer;using Microsoft.Projects.Project.Planning;using Microsoft.Sales.Document;using System.Utilities;report 302 "Get Demand To Reserve"{    ApplicationArea = Reservation;    ProcessingOnly = true;    Caption = 'Get Demand to Reserve';    dataset    {        dataitem(FilterItem; Item)        {            DataItemTableView = sorting("No.")                                where(Type = const(Inventory));            RequestFilterFields = "No.", "Variant Filter", "Location Filter", "Date Filter";            RequestFilterHeading = 'Filters';        }        dataitem(FilterLine; Integer)        {            DataItemTableView = sorting(Number) where(Number = const(1));            dataitem(SalesOrderLine; "Sales Line")            {                DataItemTableView = sorting("Document Type", "Document No.", "Line No.")                                    where("Document Type" = const(Order),                                        "Drop Shipment" = const(false),                                        Type = const(Item),                                        "Outstanding Qty. (Base)" = filter(<> 0));                trigger OnPreDataItem()                begin                    if not (DemandType in [Enum::"Reservation Demand Type"::All, Enum::"Reservation Demand Type"::"Sales Orders"]) then                        CurrReport.Break();                    SetFilter("No.", FilterItem.GetFilter("No."));                    SetFilter("Variant Code", FilterItem.GetFilter("Variant Filter"));                    SetFilter("Location Code", FilterItem.GetFilter("Location Filter"));                    SetFilter("Shipment Date", FilterItem.GetFilter("Date Filter"));                    SetFilter(Reserve, '<>%1', SalesOrderLine.Reserve::Never);                    FilterGroup(2);                    if DateFilter <> '' then                        SetFilter("Shipment Date", DateFilter);                    if VariantFilterFromBatch <> '' then                        SetFilter("Variant Code", VariantFilterFromBatch);                    if LocationFilterFromBatch <> '' then                        SetFilter("Location Code", LocationFilterFromBatch);                    FilterGroup(0);                end;                trigger OnAfterGetRecord()                var                    Item: Record Item;                    IsHandled: Boolean;                begin                    if not IsInventoriableItem() then                        CurrReport.Skip();                    if not CheckIfSalesLineMeetsReservedFromStockSetting(Abs("Outstanding Qty. (Base)"), ReservedFromStock)                    then                        CurrReport.Skip();                    if ItemFilterFromBatch <> '' then begin                        Item.SetView(ReservationWkshBatch.GetItemFilterBlobAsViewFilters());                        Item.FilterGroup(2);                        Item.SetRange("No.", "No.");                        Item.FilterGroup(0);                        if Item.IsEmpty() then                            CurrReport.Skip();                    end;                    IsHandled := false;                    OnSalesOrderLineOnAfterGetRecordOnBeforeSetTempSalesLine(SalesOrderLine, IsHandled);                    if not IsHandled then begin                        TempSalesLine := SalesOrderLine;                        TempSalesLine.Insert();                    end;                end;            }            dataitem(TransferOrderLine; "Transfer Line")            {                DataItemTableView = sorting("Document No.", "Line No.")                                    where("Derived From Line No." = const(0),                                        "Outstanding Qty. (Base)" = filter(<> 0));                trigger OnPreDataItem()                begin                    if not (DemandType in [Enum::"Reservation Demand Type"::All, Enum::"Reservation Demand Type"::"Transfer Orders"]) then                        CurrReport.Break();                    SetFilter("Item No.", FilterItem.GetFilter("No."));                    SetFilter("Variant Code", FilterItem.GetFilter("Variant Filter"));                    SetFilter("Transfer-from Code", FilterItem.GetFilter("Location Filter"));                    SetFilter("Shipment Date", FilterItem.GetFilter("Date Filter"));                    FilterGroup(2);                    if DateFilter <> '' then                        SetFilter("Shipment Date", DateFilter);                    if VariantFilterFromBatch <> '' then                        SetFilter("Variant Code", VariantFilterFromBatch);                    if LocationFilterFromBatch <> '' then                        SetFilter("Transfer-from Code", LocationFilterFromBatch);                    FilterGroup(0);                end;                trigger OnAfterGetRecord()                var                    Item: Record Item;                    IsHandled: Boolean;                begin                    if not CheckIfTransferLineMeetsReservedFromStockSetting("Outstanding Qty. (Base)", ReservedFromStock)                    then                        CurrReport.Skip();                    if ItemFilterFromBatch <> '' then begin                        Item.SetView(ReservationWkshBatch.GetItemFilterBlobAsViewFilters());                        Item.FilterGroup(2);                        Item.SetRange("No.", "Item No.");                        Item.FilterGroup(0);                        if Item.IsEmpty() then                            CurrReport.Skip();                    end;                    IsHandled := false;                    OnTransferOrderLineOnAfterGetRecordOnBeforeSetTempTransferLine(TransferOrderLine, IsHandled);                    if not IsHandled then begin                        TempTransferLine := TransferOrderLine;                        TempTransferLine.Insert();                    end;                end;            }            dataitem(JobPlanningLine; "Job Planning Line")            {                DataItemTableView = sorting("Job No.", "Job Task No.", "Line No.")                                    where(Type = const(Item),                                        "Remaining Qty. (Base)" = filter(<> 0));                trigger OnPreDataItem()                begin                    if not (DemandType in [Enum::"Reservation Demand Type"::All, Enum::"Reservation Demand Type"::"Job Usage"]) then                        CurrReport.Break();                    SetFilter("No.", FilterItem.GetFilter("No."));                    SetFilter("Variant Code", FilterItem.GetFilter("Variant Filter"));                    SetFilter("Location Code", FilterItem.GetFilter("Location Filter"));                    SetFilter("Planning Date", FilterItem.GetFilter("Date Filter"));                    SetFilter(Reserve, '<>%1', JobPlanningLine.Reserve::Never);                    FilterGroup(2);                    if DateFilter <> '' then                        SetFilter("Planning Date", DateFilter);                    if VariantFilterFromBatch <> '' then                        SetFilter("Variant Code", VariantFilterFromBatch);                    if LocationFilterFromBatch <> '' then                        SetFilter("Location Code", LocationFilterFromBatch);                    FilterGroup(0);                end;                trigger OnAfterGetRecord()                var                    Item: Record Item;                    IsHandled: Boolean;                begin                    if not IsInventoriableItem() then                        CurrReport.Skip();                    if not CheckIfJobPlngLineMeetsReservedFromStockSetting("Remaining Qty. (Base)", ReservedFromStock)                    then                        CurrReport.Skip();                    if ItemFilterFromBatch <> '' then begin                        Item.SetView(ReservationWkshBatch.GetItemFilterBlobAsViewFilters());                        Item.FilterGroup(2);                        Item.SetRange("No.", "No.");                        Item.FilterGroup(0);                        if Item.IsEmpty() then                            CurrReport.Skip();                    end;                    IsHandled := false;                    OnJobPlanningLineOnAfterGetRecordOnBeforeSetTempJobPlanningLine(JobPlanningLine, IsHandled);                    if not IsHandled then begin                        TempJobPlanningLine := JobPlanningLine;                        TempJobPlanningLine.Insert();                    end;                end;            }        }    }    requestpage    {        SaveValues = true;        layout        {            area(Content)            {                group(BatchFilters)                {                    Editable = false;                    Caption = 'Batch Filters';                    Visible = BatchFiltersVisible;                    field("Batch Name"; BatchName)                    {                        Caption = 'Batch Name';                        ToolTip = 'Specifies the batch name to use for the reservation worksheet.';                    }                    field("Demand Type From Batch"; DemandTypeFromBatch)                    {                        Caption = 'Demand Type';                        ToolTip = 'Specifies the demand type to use for the reservation worksheet.';                    }                    field("Item Filter"; ItemFilterFromBatch)                    {                        Caption = 'Item Filter';                        ToolTip = 'Specifies the item filter to use for the reservation worksheet.';                    }                    field("Variant Filter"; VariantFilterFromBatch)                    {                        Caption = 'Variant Filter';                        ToolTip = 'Specifies the variant filter to use for the reservation worksheet.';                        Importance = Additional;                    }                    field("Location Filter"; LocationFilterFromBatch)                    {                        Caption = 'Location Filter';                        ToolTip = 'Specifies the location filter to use for the reservation worksheet.';                        Importance = Additional;                    }                    field("Start Date"; StartDateFromBatchInText)                    {                        Caption = 'Start Date';                        ToolTip = 'Specifies the start date to use for the reservation worksheet.';                    }                    field("End Date"; EndDateFromBatchInText)                    {                        Caption = 'End Date';                        ToolTip = 'Specifies the end date to use for the reservation worksheet.';                    }                }                group(Settings)                {                    Caption = 'Settings';                    field("Show Batch Filters"; BatchFiltersVisible)                    {                        Caption = 'Show batch filters';                        ToolTip = 'Specifies whether to show or hide the batch filters.';                        Importance = Additional;                    }                    field("Demand Type"; DemandType)                    {                        Caption = 'Demand Type';                        ToolTip = 'Specifies the type of demand to reserve.';                        Editable = DemandTypeEditable;                    }                    field(Name; ReservedFromStock)                    {                        Caption = 'Reserved from stock';                        ToolTip = 'Specifies whether you want to include only demand lines that are fully or partially reserved from stock.';                        ValuesAllowed = 0, None, Partial;                        Importance = Additional;                        Visible = false;                    }                    field("Auto Allocate"; AutoAllocate)                    {                        Caption = 'Allocate After Populate';                        ToolTip = 'Specifies whether to automatically allocate quantity in the reservation worksheet after the report is run.';                    }                }            }        }        trigger OnOpenPage()        begin            DemandTypeEditable := DemandTypeFromBatch = DemandTypeFromBatch::All;            if not DemandTypeEditable then                DemandType := DemandTypeFromBatch;        end;    }    trigger OnInitReport()    begin        Clear(BatchName);        Clear(DemandTypeFromBatch);        Clear(ItemFilterFromBatch);        Clear(VariantFilterFromBatch);        Clear(LocationFilterFromBatch);        Clear(DateFilter);        Clear(StartDateFromBatch);        Clear(EndDateFromBatch);    end;    trigger OnPreReport()    begin        TempSalesLine.DeleteAll();        TempTransferLine.DeleteAll();        TempJobPlanningLine.DeleteAll();    end;    var        TempSalesLine: Record "Sales Line" temporary;        TempTransferLine: Record "Transfer Line" temporary;        TempJobPlanningLine: Record "Job Planning Line" temporary;        BatchName: Code[10];        StartDateFromBatchInText: Text;        EndDateFromBatchInText: Text;        StartDateFromBatch: Date;        EndDateFromBatch: Date;        DemandTypeEditable: Boolean;        AutoAllocate: Boolean;        BatchFiltersVisible: Boolean;    protected var        ReservationWkshBatch: Record "Reservation Wksh. Batch";        DemandType: Enum "Reservation Demand Type";        DemandTypeFromBatch: Enum "Reservation Demand Type";        ReservedFromStock: Enum "Reservation From Stock";        DateFilter: Text;        ItemFilterFromBatch: Text;        VariantFilterFromBatch: Text;        LocationFilterFromBatch: Text;    procedure GetSalesOrderLines(var TempSalesLineToReturn: Record "Sales Line" temporary)    begin        TempSalesLineToReturn.Copy(TempSalesLine, true);    end;    procedure GetTransferOrderLines(var TempTransferLineToReturn: Record "Transfer Line" temporary)    begin        TempTransferLineToReturn.Copy(TempTransferLine, true);    end;    procedure GetJobPlanningLines(var TempJobPlanningLineToReturn: Record "Job Planning Line" temporary)    begin        TempJobPlanningLineToReturn.Copy(TempJobPlanningLine, true);    end;    procedure GetAllocateAfterPopulate(): Boolean    begin        exit(AutoAllocate);    end;    procedure SetBatchName(NewBatchName: Code[10])    begin        BatchName := NewBatchName;        GetBatchFilters();    end;    local procedure GetBatchFilters()    var        StartDateFormulaFromBatch: DateFormula;        EndDateFormulaFromBatch: DateFormula;        StartDate: Date;        EndDate: Date;    begin        if not ReservationWkshBatch.Get(BatchName) then            exit;        DemandTypeFromBatch := ReservationWkshBatch."Demand Type";        ItemFilterFromBatch := ReservationWkshBatch.GetItemFilterAsDisplayText();        VariantFilterFromBatch := ReservationWkshBatch.GetVariantFilterBlobAsText();        LocationFilterFromBatch := ReservationWkshBatch.GetLocationFilterBlobAsText();        StartDateFromBatchInText := '';        EndDateFromBatchInText := '';        if Format(ReservationWkshBatch."Start Date Formula") = '' then            StartDateFromBatch := 0D        else begin            StartDateFormulaFromBatch := ReservationWkshBatch."Start Date Formula";            StartDateFromBatch := CalcDate(StartDateFormulaFromBatch, WorkDate());            StartDateFromBatchInText := Format(StartDateFromBatch);        end;        if Format(ReservationWkshBatch."End Date Formula") = '' then            EndDateFromBatch := DMY2Date(31, 12, 9998)        else begin            EndDateFormulaFromBatch := ReservationWkshBatch."End Date Formula";            EndDateFromBatch := CalcDate(EndDateFormulaFromBatch, WorkDate());            EndDateFromBatchInText := Format(EndDateFromBatch);        end;        StartDate := StartDateFromBatch;        EndDate := EndDateFromBatch;        DateFilter := Format(StartDate) + '..' + Format(EndDate);    end;    procedure SetParameters(NewBatchFiltersVisible: Boolean; NewDemandType: Enum "Reservation Demand Type"; NewReservedFromStock: Enum "Reservation From Stock"; NewAutoAllocate: Boolean)    begin        BatchFiltersVisible := NewBatchFiltersVisible;        DemandType := NewDemandType;        ReservedFromStock := NewReservedFromStock;        AutoAllocate := NewAutoAllocate;    end;#if not CLEAN27    [Obsolete('This event is never raised.', '27.0')]    [IntegrationEvent(false, false)]    local procedure OnGetDemand(var FilterItem: Record Item; var ReservationWkshBatch: Record "Reservation Wksh. Batch"; DemandType: Enum "Reservation Demand Type"; DateFilter: Text; VariantFilterFromBatch: Text; LocationFilterFromBatch: Text; ItemFilterFromBatch: Text; ReservedFromStock: Enum "Reservation From Stock");    begin    end;#endif    [IntegrationEvent(false, false)]    local procedure OnSalesOrderLineOnAfterGetRecordOnBeforeSetTempSalesLine(var OrderSalesLine: Record "Sales Line"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnTransferOrderLineOnAfterGetRecordOnBeforeSetTempTransferLine(var TransferLine: Record "Transfer Line"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnJobPlanningLineOnAfterGetRecordOnBeforeSetTempJobPlanningLine(var JobPlanningLine: Record "Job Planning Line"; var IsHandled: Boolean)    begin    end;}