Report 99001048 Planning Availability

Base Application, Microsoft.Manufacturing.Reports

src/Layers/W1/BaseApp/Inventory/Reports/PlanningAvailability.Report.al577 lines, Copyright (c) Microsoft Corporation. MIT

#if not CLEAN27// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Manufacturing.Reports;using Microsoft.Inventory.Item;using Microsoft.Inventory.Planning;using Microsoft.Inventory.Requisition;using Microsoft.Inventory.Setup;using Microsoft.Inventory.Transfer;using Microsoft.Projects.Project.Planning;using Microsoft.Purchases.Document;using Microsoft.Sales.Document;using System.Utilities;report 99001048 "Planning Availability"{    ApplicationArea = Basic, Suite;    Caption = 'Planning Availability (Obsolete)';    UsageCategory = ReportsAndAnalysis;    ObsoleteState = Pending;    ObsoleteReason = 'This report has been deprecated and will be removed in a future release.';    ObsoleteTag = '27.0';    DefaultRenderingLayout = RDLCLayout;    dataset    {        dataitem(TopLevel; Integer)        {            DataItemTableView = where(Number = const(1));            dataitem("Production Forecast Entry"; Microsoft.Manufacturing.Forecast."Production Forecast Entry")            {                DataItemTableView = sorting("Production Forecast Name", "Item No.", "Variant Code", "Component Forecast", "Forecast Date", "Location Code");                trigger OnAfterGetRecord()                begin                    BufferCounter += 1;                    TempForecastPlanningBuffer.SetRange("Item No.", "Item No.");                    TempForecastPlanningBuffer.SetRange(Date, "Forecast Date");                    if "Component Forecast" then                        TempForecastPlanningBuffer.SetRange("Document Type", TempForecastPlanningBuffer."Document Type"::"Production Forecast-Component")                    else                        TempForecastPlanningBuffer.SetRange("Document Type", TempForecastPlanningBuffer."Document Type"::"Production Forecast-Sales");                    if TempForecastPlanningBuffer.FindFirst() then begin                        TempForecastPlanningBuffer."Gross Requirement" += "Forecast Quantity";                        TempForecastPlanningBuffer.Modify();                    end else                        InsertNewForecast("Production Forecast Entry");                end;                trigger OnPreDataItem()                var                    InventorySetup: Record "Inventory Setup";                begin                    InventorySetup.Get();                    SetRange("Production Forecast Name", InventorySetup."Current Demand Forecast");                end;            }            dataitem("Sales Line"; "Sales Line")            {                DataItemTableView = sorting("Document Type", "Document No.", "Line No.");                trigger OnAfterGetRecord()                begin                    if SelectionReq then begin                        NewRecordWithDetails("Shipment Date", "No.", Description);                        TempPlanningBuffer."Document Type" := TempPlanningBuffer."Document Type"::"Sales Order";                        TempPlanningBuffer."Document No." := "Document No.";                        TempPlanningBuffer."Gross Requirement" := "Outstanding Qty. (Base)";                        TempPlanningBuffer.Insert();                    end else begin                        TempPlanningBuffer.SetRange("Item No.", "No.");                        TempPlanningBuffer.SetRange(Date, "Shipment Date");                        if TempPlanningBuffer.Find('-') then begin                            TempPlanningBuffer."Gross Requirement" := TempPlanningBuffer."Gross Requirement" + "Outstanding Qty. (Base)";                            TempPlanningBuffer.Modify();                        end else begin                            NewRecordWithDetails("Shipment Date", "No.", Description);                            TempPlanningBuffer."Gross Requirement" := "Outstanding Qty. (Base)";                            TempPlanningBuffer.Insert();                        end;                    end;                    ModifyForecast("No.", "Shipment Date", TempPlanningBuffer."Document Type"::"Production Forecast-Sales", "Outstanding Qty. (Base)");                end;                trigger OnPreDataItem()                begin                    TempPlanningBuffer.DeleteAll();                    SetRange("Document Type", "Document Type"::Order);                    SetRange(Type, Type::Item);                end;            }            dataitem("Job Planning Line"; "Job Planning Line")            {                DataItemTableView = sorting("Job No.", "Job Task No.", "Line No.");                trigger OnAfterGetRecord()                begin                    if SelectionReq then begin                        NewRecordWithDetails("Planning Date", "No.", Description);                        TempPlanningBuffer."Document Type" := TempPlanningBuffer."Document Type"::"Job Order";                        TempPlanningBuffer."Document No." := "Job No.";                        TempPlanningBuffer."Gross Requirement" := "Remaining Qty. (Base)";                        TempPlanningBuffer.Insert();                    end else begin                        TempPlanningBuffer.SetRange("Item No.", "No.");                        TempPlanningBuffer.SetRange(Date, "Planning Date");                        if TempPlanningBuffer.Find('-') then begin                            TempPlanningBuffer."Gross Requirement" := TempPlanningBuffer."Gross Requirement" + "Remaining Qty. (Base)";                            TempPlanningBuffer.Modify();                        end else begin                            NewRecordWithDetails("Planning Date", "No.", Description);                            TempPlanningBuffer."Gross Requirement" := "Remaining Qty. (Base)";                            TempPlanningBuffer.Insert();                        end;                    end;                end;                trigger OnPreDataItem()                begin                    SetRange(Status, Status::Order);                    SetRange(Type, Type::Item);                end;            }            dataitem("Purchase Line"; "Purchase Line")            {                DataItemTableView = sorting("Document Type", "Document No.", "Line No.");                trigger OnAfterGetRecord()                begin                    ReqLine2.SetRange("Ref. Order No.", "Document No.");                    ReqLine2.SetRange("Ref. Line No.", "Line No.");                    if ReqLine2.FindFirst() then                        CurrReport.Skip();                    if SelectionReq then begin                        NewRecordWithDetails("Expected Receipt Date", "No.", Description);                        TempPlanningBuffer."Document Type" := TempPlanningBuffer."Document Type"::"Purchase Order";                        TempPlanningBuffer."Document No." := "Document No.";                        TempPlanningBuffer."Scheduled Receipts" := "Outstanding Qty. (Base)";                        TempPlanningBuffer.Insert();                    end else begin                        TempPlanningBuffer.SetRange("Item No.", "No.");                        TempPlanningBuffer.SetRange(Date, "Expected Receipt Date");                        if TempPlanningBuffer.Find('-') then begin                            TempPlanningBuffer."Scheduled Receipts" := TempPlanningBuffer."Scheduled Receipts" + "Outstanding Qty. (Base)";                            TempPlanningBuffer.Modify();                        end else begin                            NewRecordWithDetails("Expected Receipt Date", "No.", Description);                            TempPlanningBuffer."Scheduled Receipts" := "Outstanding Qty. (Base)";                            TempPlanningBuffer.Insert();                        end;                    end;                end;                trigger OnPreDataItem()                begin                    SetRange("Document Type", "Document Type"::Order);                    SetRange(Type, Type::Item);                    ReqLine2.Reset();                    ReqLine2.SetCurrentKey("Ref. Order Type", "Ref. Order Status", "Ref. Order No.", "Ref. Line No.");                    ReqLine2.SetRange("Ref. Order Type", ReqLine2."Ref. Order Type"::Purchase);                end;            }            dataitem("Transfer Line"; "Transfer Line")            {                DataItemTableView = sorting("Transfer-from Code", Status, "Derived From Line No.", "Item No.", "Variant Code", "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code", "Shipment Date", "In-Transit Code");                trigger OnAfterGetRecord()                begin                    if SelectionReq then begin                        NewRecordWithDetails("Shipment Date", "Item No.", Description);                        TempPlanningBuffer."Document Type" := TempPlanningBuffer."Document Type"::Transfer;                        TempPlanningBuffer."Document No." := "Document No.";                        TempPlanningBuffer."Gross Requirement" := "Outstanding Qty. (Base)";                        TempPlanningBuffer.Insert();                        NewRecordWithDetails("Receipt Date", "Item No.", Description);                        TempPlanningBuffer."Document Type" := TempPlanningBuffer."Document Type"::Transfer;                        TempPlanningBuffer."Document No." := "Document No.";                        TempPlanningBuffer."Scheduled Receipts" := "Outstanding Qty. (Base)" + "Qty. in Transit (Base)";                        TempPlanningBuffer.Insert();                    end else begin                        TempPlanningBuffer.SetRange("Item No.", "Item No.");                        TempPlanningBuffer.SetRange(Date, "Shipment Date");                        if TempPlanningBuffer.Find('-') then begin                            TempPlanningBuffer."Gross Requirement" := TempPlanningBuffer."Gross Requirement" + "Outstanding Qty. (Base)";                            TempPlanningBuffer.Modify();                        end else begin                            NewRecordWithDetails("Shipment Date", "Item No.", Description);                            TempPlanningBuffer."Gross Requirement" := "Outstanding Qty. (Base)";                            TempPlanningBuffer.Insert();                        end;                        TempPlanningBuffer.SetRange(Date, "Receipt Date");                        if TempPlanningBuffer.Find('-') then begin                            TempPlanningBuffer."Scheduled Receipts" :=                            TempPlanningBuffer."Scheduled Receipts" +                            "Outstanding Qty. (Base)" +                            "Qty. in Transit (Base)";                            TempPlanningBuffer.Modify();                        end else begin                            NewRecordWithDetails("Receipt Date", "Item No.", Description);                            TempPlanningBuffer."Scheduled Receipts" := "Outstanding Qty. (Base)" + "Qty. in Transit (Base)";                            TempPlanningBuffer.Insert();                        end;                    end;                end;                trigger OnPreDataItem()                begin                    SetRange("Derived From Line No.", 0);                end;            }            dataitem("Requisition Line"; "Requisition Line")            {                DataItemTableView = sorting("Worksheet Template Name", "Journal Batch Name", "Line No.");                trigger OnAfterGetRecord()                begin                    if SelectionReq then begin                        NewRecordWithDetails("Due Date", "No.", Description);                        TempPlanningBuffer."Document Type" := TempPlanningBuffer."Document Type"::"Requisition Line";                        TempPlanningBuffer."Planned Receipts" := "Quantity (Base)";                        OnRequisitionLineOnBeforeTempPlanningBufferInsert(TempPlanningBuffer, "Requisition Line");                        TempPlanningBuffer.Insert();                    end else begin                        TempPlanningBuffer.SetRange("Item No.", "No.");                        TempPlanningBuffer.SetRange(Date, "Due Date");                        if TempPlanningBuffer.Find('-') then begin                            TempPlanningBuffer."Planned Receipts" := TempPlanningBuffer."Planned Receipts" + "Quantity (Base)";                            TempPlanningBuffer.Modify();                        end else begin                            NewRecordWithDetails("Due Date", "No.", Description);                            TempPlanningBuffer."Planned Receipts" := "Quantity (Base)";                            TempPlanningBuffer.Insert();                        end;                    end;                end;                trigger OnPreDataItem()                begin                    SetRange(Type, Type::Item);                end;            }            dataitem("Planning Component"; "Planning Component")            {                DataItemTableView = sorting("Worksheet Template Name", "Worksheet Batch Name", "Worksheet Line No.", "Line No.");                trigger OnAfterGetRecord()                begin                    if SelectionReq then begin                        NewRecordWithDetails("Due Date", "Item No.", Description);                        TempPlanningBuffer."Document Type" := TempPlanningBuffer."Document Type"::"Planning Comp.";                        TempPlanningBuffer."Document No." := ReqLine."Ref. Order No.";                        TempPlanningBuffer."Gross Requirement" := "Expected Quantity (Base)";                        TempPlanningBuffer.Insert();                    end else begin                        TempPlanningBuffer.SetRange("Item No.", "Item No.");                        TempPlanningBuffer.SetRange(Date, "Due Date");                        if TempPlanningBuffer.Find('-') then begin                            TempPlanningBuffer."Gross Requirement" := TempPlanningBuffer."Gross Requirement" + "Expected Quantity (Base)";                            TempPlanningBuffer.Modify();                        end else begin                            NewRecordWithDetails("Due Date", "Item No.", Description);                            TempPlanningBuffer."Gross Requirement" := "Expected Quantity (Base)";                            TempPlanningBuffer.Insert();                        end;                    end;                    ModifyForecast("Item No.", "Due Date", TempPlanningBuffer."Document Type"::"Production Forecast-Component", "Expected Quantity (Base)");                end;            }            dataitem("Planning Buffer"; "Planning Buffer")            {                DataItemTableView = sorting("Item No.", Date);                RequestFilterFields = "Item No.", Date;            }            dataitem("Integer"; "Integer")            {                DataItemTableView = sorting(Number) where(Number = filter(1 ..));                column(CompanyName; COMPANYPROPERTY.DisplayName())                {                }                column(TodayFormatted; Format(Today, 0, 4))                {                }                column(PlngBuffTableCaptFilter; TempPlanningBuffer.TableCaption + ': ' + PlanningFilter)                {                }                column(PlanningFilter; PlanningFilter)                {                }                column(ItemInventory; Item.Inventory)                {                }                column(PlanningBuffItemNo; TempPlanningBuffer."Item No.")                {                }                column(PlanningBuffDesc; TempPlanningBuffer.Description)                {                }                column(ShowIntBody1; PrintBoolean and SelectionReq)                {                }                column(PlanningBuffDocNo; TempPlanningBuffer."Document No.")                {                }                column(PlanningBuffDocType; Format(TempPlanningBuffer."Document Type"))                {                }                column(ProjectedBalance; ProjectedBalance)                {                    DecimalPlaces = 0 : 5;                }                column(PlngBuffScheduledReceipts; TempPlanningBuffer."Scheduled Receipts")                {                }                column(PlngBuffPlannedReceipts; TempPlanningBuffer."Planned Receipts")                {                }                column(PlngBuffGrossRequirement; TempPlanningBuffer."Gross Requirement")                {                }                column(PlanningBuffDate; Format(TempPlanningBuffer.Date))                {                }                column(ShowIntBody2; SelectionReq and PrintBoolean2)                {                }                column(ShowIntBody3; PrintBoolean and (not SelectionReq))                {                }                column(ShowIntBody4; (not SelectionReq) and PrintBoolean2)                {                }                column(PlanningAvailabilityCaptn; PlanningAvailabilityCaptnLbl)                {                }                column(CurrReportPageNoCaption; CurrReportPageNoCaptionLbl)                {                }                column(DocumentNoCaption; DocumentNoCaptionLbl)                {                }                column(DocumentTypeCaption; DocumentTypeCaptionLbl)                {                }                column(ProjectedBalanceCaption; ProjectedBalanceCaptionLbl)                {                }                column(ScheduledReceiptsCaption; ScheduledReceiptsCaptionLbl)                {                }                column(PlannedReceiptsCaption; PlannedReceiptsCaptionLbl)                {                }                column(GrossRequirementCaption; GrossRequirementCaptionLbl)                {                }                column(AvailableInventoryCaption; AvailableInventoryCaptionLbl)                {                }                column(DateCaption; DateCaptionLbl)                {                }                trigger OnAfterGetRecord()                begin                    if Number = 1 then                        TempPlanningBuffer.Find('-')                    else                        if TempPlanningBuffer.Next() = 0 then                            CurrReport.Break();                    Item.SetRange("Date Filter", 0D, TempPlanningBuffer.Date);                    if Item.Get(TempPlanningBuffer."Item No.") then begin                        PrintBoolean2 := true;                        if TempPlanningBuffer."Item No." = OldItem then                            PrintBoolean := false                        else begin                            PrintBoolean := true;                            OldItem := TempPlanningBuffer."Item No.";                            Item.CalcFields(Inventory);                            ProjectedBalance := Item.Inventory;                        end;                        ProjectedBalance :=                        ProjectedBalance -                        TempPlanningBuffer."Gross Requirement" +                        TempPlanningBuffer."Planned Receipts" +                        TempPlanningBuffer."Scheduled Receipts";                    end else                        PrintBoolean2 := false;                end;                trigger OnPreDataItem()                begin                    TempForecastPlanningBuffer.Reset();                    TempForecastPlanningBuffer.SetFilter("Gross Requirement", '>0');                    if TempForecastPlanningBuffer.FindSet() then                        repeat                            if SelectionReq then begin                                NewRecord();                                TempPlanningBuffer := TempForecastPlanningBuffer;                                TempPlanningBuffer."Buffer No." := BufferCounter;                                TempPlanningBuffer.Insert();                            end else begin                                TempPlanningBuffer.SetRange("Item No.", TempForecastPlanningBuffer."Item No.");                                TempPlanningBuffer.SetRange(Date, TempForecastPlanningBuffer.Date);                                if TempPlanningBuffer.FindSet(true) then begin                                    TempPlanningBuffer."Gross Requirement" += TempForecastPlanningBuffer."Gross Requirement";                                    TempPlanningBuffer.Modify();                                end else begin                                    NewRecord();                                    TempPlanningBuffer := TempForecastPlanningBuffer;                                    TempPlanningBuffer."Buffer No." := BufferCounter;                                    TempPlanningBuffer.Insert();                                end;                            end;                        until TempForecastPlanningBuffer.Next() = 0;                    TempPlanningBuffer.SetCurrentKey("Item No.", Date);                    TempPlanningBuffer.CopyFilters("Planning Buffer");                end;            }        }    }    requestpage    {        AboutTitle = 'About Planning Availability (Obsolete)';        AboutText = 'Helps you manage inventory levels and ensure that items are available when you need them.** This report is obsolete and will be removed in a future release.** Please refer to the report documentation for alternative ways to retrieve this information.';        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(Selection; SelectionReq)                    {                        ApplicationArea = Manufacturing;                        Caption = 'Detailed';                        DrillDown = true;                        ToolTip = 'Specifies whether you want the report to display a detailed list of each demand and supply entry. The report will instead show the total cumulative demand and supply.';                    }                }            }        }        actions        {        }    }    rendering    {        layout(RDLCLayout)        {            Type = RDLC;            LayoutFile = './Inventory/Reports/PlanningAvailability.rdlc';            Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.';        }    }    labels    {    }    trigger OnInitReport()    begin        SelectionReq := true;    end;    trigger OnPreReport()    begin        PlanningFilter := "Planning Buffer".GetFilters();        CollectData();    end;    var        TempForecastPlanningBuffer: Record "Planning Buffer" temporary;        Item: Record Item;        ReqLine: Record "Requisition Line";        PlanningFilter: Text;        OldItem: Code[20];        PrintBoolean: Boolean;        BufferCounter: Integer;        ProjectedBalance: Decimal;        PrintBoolean2: Boolean;        PlanningAvailabilityCaptnLbl: Label 'Planning Availability';        CurrReportPageNoCaptionLbl: Label 'Page';        DocumentNoCaptionLbl: Label 'Document No.';        DocumentTypeCaptionLbl: Label 'Document Type';        ProjectedBalanceCaptionLbl: Label 'Projected Balance';        ScheduledReceiptsCaptionLbl: Label 'Scheduled Receipts';        PlannedReceiptsCaptionLbl: Label 'Planned Receipts';        GrossRequirementCaptionLbl: Label 'Gross Requirement';        AvailableInventoryCaptionLbl: Label 'Available Inventory';        DateCaptionLbl: Label 'Date';    protected var        ReqLine2: Record "Requisition Line";        TempPlanningBuffer: Record "Planning Buffer" temporary;        SelectionReq: Boolean;    local procedure CollectData();    begin        OnCollectData(TempPlanningBuffer, SelectionReq);    end;    local procedure NewRecord()    begin        TempPlanningBuffer.SetRange("Item No.");        TempPlanningBuffer.SetRange(Date);        if not TempPlanningBuffer.Find('+') then            BufferCounter := 1        else begin            BufferCounter := TempPlanningBuffer."Buffer No." + 1;            Clear(TempPlanningBuffer);        end;        TempPlanningBuffer."Buffer No." := BufferCounter;    end;    procedure NewRecordWithDetails(NewDate: Date; NewItemNo: Code[20]; NewDescription: Text[100])    begin        NewRecord();        TempPlanningBuffer.Date := NewDate;        TempPlanningBuffer."Item No." := NewItemNo;        TempPlanningBuffer.Description := NewDescription;    end;    local procedure InsertNewForecast(ProdForecastEntry: Record Microsoft.Manufacturing.Forecast."Production Forecast Entry")    begin        TempForecastPlanningBuffer.Init();        TempForecastPlanningBuffer."Buffer No." := BufferCounter;        TempForecastPlanningBuffer.Date := ProdForecastEntry."Forecast Date";        if ProdForecastEntry."Component Forecast" then            TempForecastPlanningBuffer."Document Type" := TempForecastPlanningBuffer."Document Type"::"Production Forecast-Component"        else            TempForecastPlanningBuffer."Document Type" := TempForecastPlanningBuffer."Document Type"::"Production Forecast-Sales";        TempForecastPlanningBuffer."Document No." := ProdForecastEntry."Production Forecast Name";        TempForecastPlanningBuffer."Item No." := ProdForecastEntry."Item No.";        TempForecastPlanningBuffer.Description := ProdForecastEntry.Description;        TempForecastPlanningBuffer."Gross Requirement" := ProdForecastEntry."Forecast Quantity";        TempForecastPlanningBuffer.Insert();    end;    protected procedure ModifyForecast(ItemNo: Code[20]; Date: Date; DocumentType: Option; Quantity: Decimal)    begin        Clear(TempForecastPlanningBuffer);        TempForecastPlanningBuffer.SetRange("Item No.", ItemNo);        TempForecastPlanningBuffer.SetFilter(Date, '..%1', Date);        TempForecastPlanningBuffer.SetRange("Document Type", DocumentType);        if TempForecastPlanningBuffer.FindLast() then begin            TempForecastPlanningBuffer."Gross Requirement" -= Quantity;            TempForecastPlanningBuffer.Modify();        end;    end;    [IntegrationEvent(true, false)]    local procedure OnCollectData(var TempPlanningBuffer: Record "Planning Buffer" temporary; Selection: Boolean)    begin    end;    [InternalEvent(false)]    local procedure OnRequisitionLineOnBeforeTempPlanningBufferInsert(var TempPlanningBuffer: Record "Planning Buffer" temporary; RequisitionLine: Record "Requisition Line")    begin    end;}#endif