Report extension 99001048 Mfg. Planning Availability

Base Application, Microsoft.Manufacturing.Reports

src/Layers/W1/BaseApp/Manufacturing/Inventory/Planning/MfgPlanningAvailability.ReportExt.al139 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.Manufacturing.Document;reportextension 99001048 "Mfg. Planning Availability" extends "Planning Availability"{    dataset    {        addafter("Transfer Line")        {            dataitem("Prod. Order Line"; "Prod. Order Line")            {                DataItemTableView = sorting(Status, "Prod. Order No.", "Line No.");                trigger OnAfterGetRecord()                begin                    if not (Status in [Status::Simulated, Status::Finished]) then begin                        ReqLine2.SetRange("Ref. Order Status", Status);                        ReqLine2.SetRange("Ref. Order No.", "Prod. Order No.");                        ReqLine2.SetRange("Ref. Line No.", "Line No.");                        if ReqLine2.FindFirst() then                            CurrReport.Skip();                        if SelectionReq then begin                            NewRecordWithDetails("Due Date", "Item No.", Description);                            TempPlanningBuffer."Document Type" := TempPlanningBuffer."Document Type"::"Purchase Order";                            TempPlanningBuffer."Document No." := "Prod. Order No.";                            case Status of                                Status::"Firm Planned":                                    begin                                        TempPlanningBuffer."Document Type" := TempPlanningBuffer."Document Type"::"Firm Planned Prod. Order";                                        TempPlanningBuffer."Scheduled Receipts" := "Remaining Qty. (Base)";                                    end;                                Status::Released:                                    begin                                        TempPlanningBuffer."Document Type" := TempPlanningBuffer."Document Type"::"Released Prod. Order";                                        TempPlanningBuffer."Scheduled Receipts" := "Remaining Qty. (Base)";                                    end;                                Status::Planned:                                    begin                                        TempPlanningBuffer."Document Type" := TempPlanningBuffer."Document Type"::"Planned Prod. Order";                                        TempPlanningBuffer."Planned Receipts" := "Remaining Qty. (Base)";                                    end;                            end;                            TempPlanningBuffer.Insert();                        end else begin                            TempPlanningBuffer.SetRange("Item No.", "Item No.");                            TempPlanningBuffer.SetRange(Date, "Due Date");                            if TempPlanningBuffer.Find('-') then begin                                if Status = Status::Planned then                                    TempPlanningBuffer."Planned Receipts" :=                                    TempPlanningBuffer."Planned Receipts" +                                    "Remaining Qty. (Base)"                                else                                    TempPlanningBuffer."Scheduled Receipts" :=                                    TempPlanningBuffer."Scheduled Receipts" +                                    "Remaining Qty. (Base)";                                TempPlanningBuffer.Modify();                            end else begin                                NewRecordWithDetails("Due Date", "Item No.", Description);                                if Status = Status::Planned then                                    TempPlanningBuffer."Planned Receipts" := "Remaining Qty. (Base)"                                else                                    TempPlanningBuffer."Scheduled Receipts" := "Remaining Qty. (Base)";                                TempPlanningBuffer.Insert();                            end;                        end;                    end;                end;                trigger OnPreDataItem()                begin                    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"::"Prod. Order");                end;            }        }        addafter("Requisition Line")        {            dataitem("Prod. Order Component"; "Prod. Order Component")            {                DataItemTableView = sorting(Status, "Prod. Order No.", "Prod. Order Line No.", "Line No.");                trigger OnAfterGetRecord()                begin                    if not (Status in [Status::Simulated, Status::Finished]) then begin                        ReqLine2.SetRange("Ref. Order Status", Status);                        ReqLine2.SetRange("Ref. Order No.", "Prod. Order No.");                        ReqLine2.SetRange("Ref. Line No.", "Prod. Order Line No.");                        if ReqLine2.FindFirst() then                            CurrReport.Skip();                        if SelectionReq then begin                            NewRecordWithDetails("Due Date", "Item No.", Description);                            TempPlanningBuffer."Document Type" := TempPlanningBuffer."Document Type"::"Purchase Order";                            TempPlanningBuffer."Document No." := "Prod. Order No.";                            TempPlanningBuffer."Gross Requirement" := "Remaining Qty. (Base)";                            case Status of                                Status::"Firm Planned":                                    TempPlanningBuffer."Document Type" := TempPlanningBuffer."Document Type"::"Firm Planned Prod. Order Comp.";                                Status::Released:                                    TempPlanningBuffer."Document Type" := TempPlanningBuffer."Document Type"::"Released Prod. Order Comp.";                                Status::Planned:                                    TempPlanningBuffer."Document Type" := TempPlanningBuffer."Document Type"::"Planned Prod. Order Comp.";                            end;                            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" + "Remaining Qty. (Base)";                                TempPlanningBuffer.Modify();                            end else begin                                NewRecordWithDetails("Due Date", "Item No.", Description);                                TempPlanningBuffer."Gross Requirement" := "Remaining Qty. (Base)";                                TempPlanningBuffer.Insert();                            end;                        end;                    end;                    ModifyForecast("Item No.", "Due Date", TempPlanningBuffer."Document Type"::"Production Forecast-Component", "Remaining Qty. (Base)");                end;                trigger OnPreDataItem()                begin                    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"::"Prod. Order");                end;            }        }    }}#endif