Codeunit 99000857 Prod. Order Line-Planning

Base Application, Microsoft.Manufacturing.Document

src/Layers/W1/BaseApp/Manufacturing/Document/ProdOrderLinePlanning.Codeunit.al273 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.Manufacturing.Document;using Microsoft.Inventory.Item;using Microsoft.Inventory.Item.Substitution;using Microsoft.Inventory.Planning;using Microsoft.Inventory.Requisition;using Microsoft.Inventory.Tracking;codeunit 99000857 "Prod. Order Line-Planning"{    Permissions = tabledata "Production Order" = r,                  tabledata "Prod. Order Component" = r,                  tabledata "Prod. Order Capacity Need" = r;    var        ProductionOrder: Record "Production Order";#if not CLEAN27        GetUnplannedDemand: Codeunit "Get Unplanned Demand";#endif        ProductionTxt: Label 'Production';    [EventSubscriber(ObjectType::Table, Database::"Requisition Line", 'OnSetDemandTypeFromUnplannedDemand', '', true, false)]    local procedure ReqLineOnSetDemandTypeFromUnplannedDemand(var RequisitionLine: Record "Requisition Line"; UnplannedDemand: Record "Unplanned Demand")    begin        if UnplannedDemand."Demand Type" = UnplannedDemand."Demand Type"::Production then            RequisitionLine."Demand Type" := Database::"Prod. Order Component";    end;    [EventSubscriber(ObjectType::Table, Database::"Unplanned Demand", 'OnValidateDemandOrderNoOnGetSourceFields', '', true, false)]    local procedure OnValidateDemandOrderNoOnGetSourceFields(var UnplannedDemand: Record "Unplanned Demand")    var        ProdOrder: Record "Production Order";    begin        case UnplannedDemand."Demand Type" of            UnplannedDemand."Demand Type"::Production:                begin                    ProdOrder.Get(UnplannedDemand."Demand SubType", UnplannedDemand."Demand Order No.");                    UnplannedDemand.Description := ProdOrder.Description;                end;        end;    end;    [EventSubscriber(ObjectType::Report, Report::"Carry Out Action Msg. - Plan.", 'OnCheckDemandType', '', true, false)]    local procedure CarryOutActionMsgPlanOnCheckDemandType(RequisitionLine: Record "Requisition Line")    var        ProdOrderComp: Record "Prod. Order Component";    begin        if RequisitionLine."Demand Type" = Database::"Prod. Order Component" then begin            ProdOrderComp.Get(RequisitionLine."Demand Subtype", RequisitionLine."Demand Order No.", RequisitionLine."Demand Line No.", RequisitionLine."Demand Ref. No.");            RequisitionLine.TestField("No.", ProdOrderComp."Item No.");            if not ((RequisitionLine."Demand Date" = WorkDate()) and (ProdOrderComp."Due Date" in [0D, WorkDate()])) then                RequisitionLine.TestField("Demand Date", ProdOrderComp."Due Date");            RequisitionLine.TestField("Qty. per UOM (Demand)", ProdOrderComp."Qty. per Unit of Measure");            RequisitionLine.TestField("Variant Code", ProdOrderComp."Variant Code");            RequisitionLine.TestField("Location Code", ProdOrderComp."Location Code");            ProdOrderComp.CalcFields("Reserved Qty. (Base)");            RequisitionLine.TestField(                RequisitionLine."Demand Quantity (Base)",                ProdOrderComp."Remaining Qty. (Base)" - ProdOrderComp."Reserved Qty. (Base)");        end;    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Order Planning Mgt.", 'OnInsertDemandLinesOnCopyItemTracking', '', true, false)]    local procedure OnInsertDemandLinesOnCopyItemTracking(var RequisitionLine: Record "Requisition Line"; UnplannedDemand: Record "Unplanned Demand")    var        ProdOrderComponent: Record "Prod. Order Component";        ItemTrackingManagement: Codeunit "Item Tracking Management";    begin        if UnplannedDemand."Demand Type" = UnplannedDemand."Demand Type"::Production then begin            ProdOrderComponent.Get(UnplannedDemand."Demand SubType", UnplannedDemand."Demand Order No.", UnplannedDemand."Demand Line No.", UnplannedDemand."Demand Ref. No.");            ItemTrackingManagement.CopyItemTracking(ProdOrderComponent.RowID1(), RequisitionLine.RowID1(), true);        end;    end;    [EventSubscriber(ObjectType::Page, Page::"Order Planning", 'OnBeforeShowDemandOrder', '', true, false)]    local procedure OrderPlanningOnBeforeShowDemandOrder(RequisitionLine: Record "Requisition Line")    begin        if RequisitionLine."Demand Type" = Database::"Prod. Order Component" then begin            ProductionOrder.Get(RequisitionLine."Demand Subtype", RequisitionLine."Demand Order No.");            case ProductionOrder.Status of                ProductionOrder.Status::Planned:                    PAGE.Run(PAGE::"Planned Production Order", ProductionOrder);                ProductionOrder.Status::"Firm Planned":                    PAGE.Run(PAGE::"Firm Planned Prod. Order", ProductionOrder);                ProductionOrder.Status::Released:                    PAGE.Run(PAGE::"Released Production Order", ProductionOrder);            end;        end;    end;    [EventSubscriber(ObjectType::Page, Page::"Order Planning", 'OnSetRecDemandFilter', '', true, false)]    local procedure OnSetRecDemandFilter(var RequisitionLine: Record "Requisition Line"; DemandOrderFilter: Enum "Demand Order Source Type")    begin        if DemandOrderFilter = DemandOrderFilter::"Production Demand" then begin            RequisitionLine.SetRange("Demand Type", Database::"Prod. Order Component");            RequisitionLine.SetCurrentKey("User ID", "Demand Type", "Worksheet Template Name", "Journal Batch Name", "Line No.");        end;    end;    [EventSubscriber(ObjectType::Page, Page::"Order Planning", 'OnAfterStatusTextOnFormat', '', true, false)]    local procedure OnAfterStatusTextOnFormat(var RequisitionLine: Record "Requisition Line"; var Text: Text)    begin        if RequisitionLine."Demand Line No." = 0 then            if RequisitionLine."Demand Type" = Database::"Prod. Order Component" then                Text := Format(Enum::"Production Order Status".FromInteger(RequisitionLine.Status));    end;    [EventSubscriber(ObjectType::Page, Page::"Order Planning", 'OnAfterDemandTypeTextOnFormat', '', true, false)]    local procedure OnAfterDemandTypeTextOnFormat(var RequisitionLine: Record "Requisition Line"; var Text: Text)    begin        if RequisitionLine."Demand Line No." = 0 then            if RequisitionLine."Demand Type" = Database::"Prod. Order Component" then                Text := ProductionTxt;    end;    [EventSubscriber(ObjectType::Page, Page::"Order Planning", 'OnAfterDemandSubtypeTextOnFormat', '', true, false)]    local procedure OnAfterDemandSubtypeTextOnFormat(var RequisitionLine: Record "Requisition Line"; var Text: Text)    begin        if RequisitionLine."Demand Type" = Database::"Prod. Order Component" then            Text := Format(Enum::"Production Order Status".FromInteger(RequisitionLine.Status));    end;    // Codeunit "Get Unplanned Demand"    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Get Unplanned Demand", 'OnBeforeOpenWindow', '', true, false)]    local procedure OnBeforeOpenPlanningWindow(var RecordCounter: Integer)    var        ProdOrderComp: Record "Prod. Order Component";    begin        ProdOrderComp.SetFilter(            Status, '%1|%2|%3', ProdOrderComp.Status::Planned, ProdOrderComp.Status::"Firm Planned", ProdOrderComp.Status::Released);        RecordCounter += ProdOrderComp.Count();    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Get Unplanned Demand", 'OnAfterGetUnplanned', '', true, false)]    local procedure OnAfterGetUnplanned(var UnplannedDemand: Record "Unplanned Demand"; ItemFilter: TextBuilder; var sender: Codeunit "Get Unplanned Demand")    begin        GetUnplannedProdOrderComp(UnplannedDemand, ItemFilter, sender);    end;    local procedure GetUnplannedProdOrderComp(var UnplannedDemand: Record "Unplanned Demand"; ItemFilter: TextBuilder; var sender: Codeunit "Get Unplanned Demand")    var        ProdOrderComp: Record "Prod. Order Component";        NeedInsertUnplannedDemand: Boolean;        DemandQtyBase: Decimal;    begin        OnBeforeGetUnplannedProdOrderComp(UnplannedDemand, ProdOrderComp);#if not CLEAN27        GetUnplannedDemand.RunOnBeforeGetUnplannedProdOrderComp(UnplannedDemand, ProdOrderComp);#endif        ProdOrderComp.SetFilter(            Status, '%1|%2|%3', ProdOrderComp.Status::Planned, ProdOrderComp.Status::"Firm Planned", ProdOrderComp.Status::Released);        ProdOrderComp.SetFilter("Item No.", ItemFilter.ToText());        if ProdOrderComp.FindSet() then            repeat                sender.UpdateWindow();                DemandQtyBase := GetProdOrderCompNeededQty(ProdOrderComp);                if DemandQtyBase > 0 then begin                    NeedInsertUnplannedDemand :=                        not ((ProdOrderComp.Status.AsInteger() = UnplannedDemand."Demand SubType") and                        (ProdOrderComp."Prod. Order No." = UnplannedDemand."Demand Order No."));                    OnGetUnplannedProdOrderCompOnAfterCalcNeedInsertUnplannedDemand(UnplannedDemand, ProdOrderComp, NeedInsertUnplannedDemand);#if not CLEAN27                    GetUnplannedDemand.RunOnGetUnplannedProdOrderCompOnAfterCalcNeedInsertUnplannedDemand(UnplannedDemand, ProdOrderComp, NeedInsertUnplannedDemand);#endif                    if NeedInsertUnplannedDemand then begin                        sender.InsertUnplannedDemand(                            UnplannedDemand, UnplannedDemand."Demand Type"::Production,                            ProdOrderComp.Status.AsInteger(), ProdOrderComp."Prod. Order No.", ProdOrderComp.Status.AsInteger());                        OnGetUnplannedProdOrderCompOnAfterInsertUnplannedDemand(UnplannedDemand, ProdOrderComp);#if not CLEAN27                        GetUnplannedDemand.RunOnGetUnplannedProdOrderCompOnAfterInsertUnplannedDemand(UnplannedDemand, ProdOrderComp);#endif                    end;                    InsertProdOrderCompLine(UnplannedDemand, ProdOrderComp, DemandQtyBase);                    OnGetUnplannedProdOrderCompOnAfterInsertProdOrderCompLine(UnplannedDemand, ProdOrderComp);#if not CLEAN27                    GetUnplannedDemand.RunOnGetUnplannedProdOrderCompOnAfterInsertProdOrderCompLine(UnplannedDemand, ProdOrderComp);#endif                end;            until ProdOrderComp.Next() = 0;    end;    local procedure GetProdOrderCompNeededQty(ProdOrderComp: Record "Prod. Order Component"): Decimal    var        NeededQty: Decimal;        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeGetProdOrderCompNeededQty(ProdOrderComp, NeededQty, IsHandled);        if IsHandled then            exit(NeededQty);        if ProdOrderComp."Item No." = '' then            exit(0);        ProdOrderComp.CalcFields(ProdOrderComp."Reserved Qty. (Base)");        exit(ProdOrderComp."Remaining Qty. (Base)" - ProdOrderComp."Reserved Qty. (Base)");    end;    local procedure InsertProdOrderCompLine(var UnplannedDemand: Record "Unplanned Demand"; ProdOrderCOmp: Record "Prod. Order Component"; DemandQtyBase: Decimal)    var        UnplannedDemand2: Record "Unplanned Demand";        Item: Record Item;    begin        UnplannedDemand2.Copy(UnplannedDemand);        UnplannedDemand.InitRecord(          ProdOrderComp."Prod. Order Line No.", ProdOrderComp."Line No.", ProdOrderComp."Item No.", ProdOrderComp.Description,          ProdOrderComp."Variant Code", ProdOrderComp."Location Code", ProdOrderComp."Bin Code", ProdOrderComp."Unit of Measure Code",          ProdOrderComp."Qty. per Unit of Measure", DemandQtyBase, ProdOrderComp."Due Date");        Item.Get(UnplannedDemand."Item No.");        UnplannedDemand.Reserve :=          (Item.Reserve = Item.Reserve::Always) and          not ((UnplannedDemand."Demand Type" = UnplannedDemand."Demand Type"::Production) and               (UnplannedDemand."Demand SubType" = ProdOrderComp.Status::Planned.AsInteger()));        OnInsertProdOrderCompLineOnBeforeInsert(UnplannedDemand, ProdOrderComp);#if not CLEAN27        GetUnplannedDemand.RunOnInsertProdOrderCompLineOnBeforeInsert(UnplannedDemand, ProdOrderComp);#endif        UnplannedDemand.Insert();        UnplannedDemand.Copy(UnplannedDemand2);    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Order Planning Mgt.", 'OnInsertAltSupplyLocationOnAfterSelectSubstitution', '', true, false)]    local procedure OnInsertAltSupplyLocationOnAfterSelectSubstitution(var RequisitionLine: Record "Requisition Line"; var TempItemSub: Record "Item Substitution" temporary)    var        ProdOrderComp: Record "Prod. Order Component";        MfgItemSubstitution: Codeunit "Mfg. Item Substitution";    begin        ProdOrderComp.Get(RequisitionLine."Demand Subtype", RequisitionLine."Demand Order No.", RequisitionLine."Demand Line No.", RequisitionLine."Demand Ref. No.");        MfgItemSubstitution.UpdateProdOrderComp(ProdOrderComp, TempItemSub."Substitute No.", TempItemSub."Substitute Variant Code");        ProdOrderComp.Modify(true);        ProdOrderComp.AutoReserve();    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeGetUnplannedProdOrderComp(var UnplannedDemand: Record "Unplanned Demand"; var ProdOrderComponent: Record Microsoft.Manufacturing.Document."Prod. Order Component");    begin    end;    [IntegrationEvent(false, false)]    local procedure OnGetUnplannedProdOrderCompOnAfterCalcNeedInsertUnplannedDemand(var UnplannedDemand: Record "Unplanned Demand"; var ProdOrderComp: Record Microsoft.Manufacturing.Document."Prod. Order Component"; var NeedInsertUnplannedDemand: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnGetUnplannedProdOrderCompOnAfterInsertUnplannedDemand(var UnplannedDemand: Record "Unplanned Demand"; var ProdOrderComp: Record Microsoft.Manufacturing.Document."Prod. Order Component")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnInsertProdOrderCompLineOnBeforeInsert(var UnplannedDemand: Record "Unplanned Demand"; ProdOrderComponent: Record Microsoft.Manufacturing.Document."Prod. Order Component")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnGetUnplannedProdOrderCompOnAfterInsertProdOrderCompLine(var UnplannedDemand: Record "Unplanned Demand"; var ProdOrderComp: Record Microsoft.Manufacturing.Document."Prod. Order Component")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeGetProdOrderCompNeededQty(ProdOrderComponent: Record Microsoft.Manufacturing.Document."Prod. Order Component"; var NeededQty: Decimal; var IsHandled: Boolean);    begin    end;}