Report extension 99001048 Mfg. Planning Availability
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