Codeunit 20520 Subc. Prod. Order Rtng. Ext.

Subcontracting, Microsoft.Manufacturing.Subcontracting

src/Apps/W1/Subcontracting/App/src/Manufacturing/SubcProdOrderRtngExt.Codeunit.al347 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.Subcontracting;using Microsoft.Inventory.Transfer;using Microsoft.Manufacturing.Document;using Microsoft.Manufacturing.Routing;using Microsoft.Manufacturing.WorkCenter;using Microsoft.Purchases.Document;codeunit 20520 "Subc. Prod. Order Rtng. Ext."{    var#if not CLEAN29#pragma warning disable AL0432        SubcFeatureFlagHandler: Codeunit "Subc. Feature Flag Handler";#pragma warning restore AL0432#endif        CannotModifyRtngLineTransferExistsErr: Label 'You cannot change this routing line because transfer orders exist for the linked production order %1, purchase order %2.', Comment = '%1=Production Order No., %2=Purchase Order No.';        CannotModifyRtngLineStockAtSubcErr: Label 'You cannot change this routing line because there are remaining components or WIP items transferred to the subcontractor for production order %1, purchase order %2.', Comment = '%1=Production Order No., %2=Purchase Order No.';    [EventSubscriber(ObjectType::Table, Database::"Prod. Order Routing Line", OnBeforeDeleteEvent, '', false, false)]    local procedure OnBeforeDeleteProdOrderRtngLine(var Rec: Record "Prod. Order Routing Line"; RunTrigger: Boolean)    begin#if not CLEAN29#pragma warning disable AL0432        if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432            exit;#endif        if Rec.IsTemporary then            exit;        if not RunTrigger then            exit;        if Rec."Transfer WIP Item" then            CheckSubcRtngLineDocumentsExist(Rec);    end;    [EventSubscriber(ObjectType::Table, Database::"Prod. Order Routing Line", OnAfterDeleteEvent, '', false, false)]    local procedure OnAfterDeleteProdOrderRtngLine(var Rec: Record "Prod. Order Routing Line"; RunTrigger: Boolean)    begin#if not CLEAN29#pragma warning disable AL0432        if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432            exit;#endif        if Rec.IsTemporary then            exit;        if not RunTrigger then            exit;        HandleSubcontractingAfterRoutingLineDelete(Rec);    end;    [EventSubscriber(ObjectType::Table, Database::"Prod. Order Routing Line", OnBeforeValidateEvent, "No.", false, false)]    local procedure OnBeforeValidateNo(var Rec: Record "Prod. Order Routing Line"; var xRec: Record "Prod. Order Routing Line"; CurrFieldNo: Integer)    var        SubcontractingManagement: Codeunit "Subcontracting Management";    begin#if not CLEAN29#pragma warning disable AL0432        if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432            exit;#endif        if Rec.IsTemporary then            exit;        if CurrFieldNo <> 0 then            if (xRec."No." <> Rec."No.") and xRec."Transfer WIP Item" then                CheckSubcRtngLineDocumentsExist(xRec);        if (xRec."No." <> Rec."No.") and (Rec."Routing Link Code" <> '') then            SubcontractingManagement.UpdLinkedComponents(Rec, true);    end;    [EventSubscriber(ObjectType::Table, Database::"Prod. Order Routing Line", OnBeforeValidateEvent, "Operation No.", false, false)]    local procedure OnBeforeValidateOperationNo(var Rec: Record "Prod. Order Routing Line"; var xRec: Record "Prod. Order Routing Line"; CurrFieldNo: Integer)    begin#if not CLEAN29#pragma warning disable AL0432        if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432            exit;#endif        if Rec.IsTemporary then            exit;        if CurrFieldNo <> 0 then            if (xRec."Operation No." <> Rec."Operation No.") and xRec."Transfer WIP Item" then                CheckSubcRtngLineDocumentsExist(xRec);    end;    [EventSubscriber(ObjectType::Table, Database::"Prod. Order Routing Line", OnBeforeValidateEvent, "Routing Link Code", false, false)]    local procedure OnBeforeValidateRoutingLinkCode(var Rec: Record "Prod. Order Routing Line"; var xRec: Record "Prod. Order Routing Line"; CurrFieldNo: Integer)    begin#if not CLEAN29#pragma warning disable AL0432        if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432            exit;#endif        if Rec.IsTemporary then            exit;        if CurrFieldNo <> 0 then            if (xRec."Routing Link Code" <> Rec."Routing Link Code") and xRec."Transfer WIP Item" then                CheckSubcRtngLineDocumentsExist(xRec);    end;    [EventSubscriber(ObjectType::Table, Database::"Prod. Order Routing Line", OnBeforeValidateEvent, "Type", false, false)]    local procedure OnBeforeValidateType(var Rec: Record "Prod. Order Routing Line"; var xRec: Record "Prod. Order Routing Line"; CurrFieldNo: Integer)    begin#if not CLEAN29#pragma warning disable AL0432        if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432            exit;#endif        if Rec.IsTemporary then            exit;        if CurrFieldNo <> 0 then            if (xRec.Type <> Rec.Type) and xRec."Transfer WIP Item" then                CheckSubcRtngLineDocumentsExist(xRec);    end;    [EventSubscriber(ObjectType::Table, Database::"Prod. Order Routing Line", OnBeforeValidateEvent, "Transfer WIP Item", false, false)]    local procedure OnBeforeValidateTransferWIPItem(var Rec: Record "Prod. Order Routing Line"; var xRec: Record "Prod. Order Routing Line"; CurrFieldNo: Integer)    begin#if not CLEAN29#pragma warning disable AL0432        if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432            exit;#endif        if Rec.IsTemporary then            exit;        if CurrFieldNo <> 0 then            if (xRec."Transfer WIP Item" <> Rec."Transfer WIP Item") and xRec."Transfer WIP Item" then                CheckSubcRtngLineDocumentsExist(xRec);    end;    [EventSubscriber(ObjectType::Table, Database::"Prod. Order Routing Line", OnAfterDeleteRelations, '', false, false)]    local procedure OnAfterDeleteProdOrderRoutingLineRelations(var ProdOrderRoutingLine: Record "Prod. Order Routing Line"; SkipUpdateOfCompBinCodes: Boolean)    var        ProdOrderRoutingComment: Record "Subc. Prod. Rtng. Comment";    begin#if not CLEAN29#pragma warning disable AL0432        if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432            exit;#endif        if ProdOrderRoutingLine.IsTemporary() then            exit;        ProdOrderRoutingComment.SetRange(Status, ProdOrderRoutingLine.Status);        ProdOrderRoutingComment.SetRange("Prod. Order No.", ProdOrderRoutingLine."Prod. Order No.");        ProdOrderRoutingComment.SetRange("Routing Reference No.", ProdOrderRoutingLine."Routing Reference No.");        ProdOrderRoutingComment.SetRange("Routing No.", ProdOrderRoutingLine."Routing No.");        ProdOrderRoutingComment.SetRange("Operation No.", ProdOrderRoutingLine."Operation No.");        ProdOrderRoutingComment.DeleteAll();    end;    [EventSubscriber(ObjectType::Table, Database::"Prod. Order Routing Line", OnAfterWorkCenterTransferFields, '', false, false)]    local procedure OnAfterWorkCenterTransferFields(var ProdOrderRoutingLine: Record "Prod. Order Routing Line"; WorkCenter: Record "Work Center")    var        SubcPriceManagement: Codeunit "Subc. Price Management";    begin#if not CLEAN29#pragma warning disable AL0432        if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432            exit;#endif        SubcPriceManagement.GetSubcPriceList(ProdOrderRoutingLine);    end;    [EventSubscriber(ObjectType::Table, Database::"Prod. Order Routing Line", OnAfterCopyFromRoutingLine, '', false, false)]    local procedure OnAfterCopyFromRoutingLine(var ProdOrderRoutingLine: Record "Prod. Order Routing Line"; RoutingLine: Record "Routing Line")    begin#if not CLEAN29#pragma warning disable AL0432        if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432            exit;#endif        ProdOrderRoutingLine."Transfer WIP Item" := RoutingLine."Transfer WIP Item";        ProdOrderRoutingLine."Transfer Description" := RoutingLine."Transfer Description";        ProdOrderRoutingLine."Transfer Description 2" := RoutingLine."Transfer Description 2";    end;    [EventSubscriber(ObjectType::Table, Database::"Prod. Order Routing Line", OnAfterCopyFromPlanningRoutingLine, '', false, false)]    local procedure OnAfterCopyFromPlanningRoutingLine(var ProdOrderRoutingLine: Record "Prod. Order Routing Line"; PlanningRoutingLine: Record "Planning Routing Line")    begin#if not CLEAN29#pragma warning disable AL0432        if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432            exit;#endif        ProdOrderRoutingLine."Transfer WIP Item" := PlanningRoutingLine."Transfer WIP Item";        ProdOrderRoutingLine."Transfer Description" := PlanningRoutingLine."Transfer Description";        ProdOrderRoutingLine."Transfer Description 2" := PlanningRoutingLine."Transfer Description 2";    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Prod. Order Route Management", OnCalculateOnBeforeProdOrderRtngLineLoopIteration, '', false, false)]    local procedure CheckSubcontractingOnCalculateOnBeforeProdOrderRtngLineLoopIteration(var ProdOrderRoutingLine: Record "Prod. Order Routing Line"; var ProdOrderLine: Record "Prod. Order Line"; var IsHandled: Boolean)    begin#if not CLEAN29#pragma warning disable AL0432        if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432            exit;#endif        ProdOrderRoutingLine.CheckForSubcontractingPurchaseLineTypeMismatch();    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Prod. Order Status Management", OnAfterToProdOrderRtngLineInsert, '', false, false)]    local procedure TransferSubcontractingCommentsOnAfterToProdOrderRoutingLineInsert(var ToProdOrderRoutingLine: Record "Prod. Order Routing Line"; var FromProdOrderRoutingLine: Record "Prod. Order Routing Line")    begin#if not CLEAN29#pragma warning disable AL0432        if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432            exit;#endif        if FromProdOrderRoutingLine.IsTemporary() or ToProdOrderRoutingLine.IsTemporary() then            exit;        TransferSubcontractingComments(FromProdOrderRoutingLine, ToProdOrderRoutingLine);    end;    local procedure TransferSubcontractingComments(FromProdOrderRoutingLine: Record "Prod. Order Routing Line"; ToProdOrderRoutingLine: Record "Prod. Order Routing Line")    var        FromSubcProdRtngComment, ToSubcProdRtngComment : Record "Subc. Prod. Rtng. Comment";    begin        FromSubcProdRtngComment.SetRange(Status, FromProdOrderRoutingLine.Status);        FromSubcProdRtngComment.SetRange("Prod. Order No.", FromProdOrderRoutingLine."Prod. Order No.");        FromSubcProdRtngComment.SetRange("Routing Reference No.", FromProdOrderRoutingLine."Routing Reference No.");        FromSubcProdRtngComment.SetRange("Routing No.", FromProdOrderRoutingLine."Routing No.");        FromSubcProdRtngComment.SetRange("Operation No.", FromProdOrderRoutingLine."Operation No.");        if FromSubcProdRtngComment.FindSet() then begin            repeat                ToSubcProdRtngComment := FromSubcProdRtngComment;                ToSubcProdRtngComment.Status := ToProdOrderRoutingLine.Status;                ToSubcProdRtngComment."Prod. Order No." := ToProdOrderRoutingLine."Prod. Order No.";                ToSubcProdRtngComment."Routing Reference No." := ToProdOrderRoutingLine."Routing Reference No.";                ToSubcProdRtngComment."Routing No." := ToProdOrderRoutingLine."Routing No.";                ToSubcProdRtngComment."Operation No." := ToProdOrderRoutingLine."Operation No.";                ToSubcProdRtngComment.Insert();            until FromSubcProdRtngComment.Next() = 0;            FromSubcProdRtngComment.DeleteAll();        end;    end;    local procedure HandleSubcontractingAfterRoutingLineDelete(var ProdOrderRoutingLine: Record "Prod. Order Routing Line")    var        WorkCenter: Record "Work Center";        SubcontractingManagement: Codeunit "Subcontracting Management";    begin        if ProdOrderRoutingLine.Status = ProdOrderRoutingLine.Status::Released then            if ProdOrderRoutingLine.Type = ProdOrderRoutingLine.Type::"Work Center" then begin                WorkCenter.SetLoadFields("Subcontractor No.");                if WorkCenter.Get(ProdOrderRoutingLine."No.") then                    if (ProdOrderRoutingLine."Routing Link Code" <> '') and (WorkCenter."Subcontractor No." <> '') then                        SubcontractingManagement.DelLocationLinkedComponents(ProdOrderRoutingLine, false);            end;    end;    local procedure CheckSubcRtngLineDocumentsExist(ProdOrderRoutingLine: Record "Prod. Order Routing Line")    var        PurchaseLine: Record "Purchase Line";    begin        PurchaseLine.SetCurrentKey("Document Type", Type, "Prod. Order No.", "Prod. Order Line No.");        PurchaseLine.SetRange("Document Type", PurchaseLine."Document Type"::Order);        PurchaseLine.SetRange("Prod. Order No.", ProdOrderRoutingLine."Prod. Order No.");        PurchaseLine.SetRange("Routing No.", ProdOrderRoutingLine."Routing No.");        PurchaseLine.SetRange("Routing Reference No.", ProdOrderRoutingLine."Routing Reference No.");        PurchaseLine.SetRange("Operation No.", ProdOrderRoutingLine."Operation No.");        if PurchaseLine.FindSet() then            repeat                if HasSubcTransferForPurchLine(PurchaseLine) then                    Error(CannotModifyRtngLineTransferExistsErr, PurchaseLine."Prod. Order No.", PurchaseLine."Document No.");                if HasStockAtSubcLocation(PurchaseLine, ProdOrderRoutingLine) then                    Error(CannotModifyRtngLineStockAtSubcErr, PurchaseLine."Prod. Order No.", PurchaseLine."Document No.");            until PurchaseLine.Next() = 0;    end;    local procedure HasSubcTransferForPurchLine(PurchaseLine: Record "Purchase Line"): Boolean    var        TransferLine: Record "Transfer Line";    begin        TransferLine.SetRange("Subc. Purch. Order No.", PurchaseLine."Document No.");        TransferLine.SetRange("Subc. Purch. Order Line No.", PurchaseLine."Line No.");        TransferLine.SetRange("Subc. Prod. Order No.", PurchaseLine."Prod. Order No.");        exit(not TransferLine.IsEmpty());    end;    local procedure HasStockAtSubcLocation(PurchaseLine: Record "Purchase Line"; ProdOrderRoutingLine: Record "Prod. Order Routing Line"): Boolean    var        ProdOrderComponent: Record "Prod. Order Component";        SubcWIPLedgerEntry: Record "Subcontractor WIP Ledger Entry";        SubcTransferManagement: Codeunit "Subc. Transfer Management";        NetStockAtSubcLocation: Decimal;    begin        ProdOrderComponent.SetCurrentKey(Status, "Prod. Order No.", "Routing Link Code");        ProdOrderComponent.SetRange(Status, "Production Order Status"::Released);        ProdOrderComponent.SetRange("Prod. Order No.", PurchaseLine."Prod. Order No.");        ProdOrderComponent.SetRange("Prod. Order Line No.", PurchaseLine."Prod. Order Line No.");        ProdOrderComponent.SetRange("Component Supply Method", ProdOrderComponent."Component Supply Method"::"Transfer to Vendor");        ProdOrderComponent.SetRange("Subc. Purchase Order Filter", PurchaseLine."Document No.");        ProdOrderComponent.SetRange("Routing Link Code", ProdOrderRoutingLine."Routing Link Code");        ProdOrderComponent.SetAutoCalcFields("Subc. Qty. transf. to Subcontr");        if ProdOrderComponent.FindSet() then            repeat                if ProdOrderComponent."Subc. Qty. transf. to Subcontr" <> 0 then begin                    NetStockAtSubcLocation := ProdOrderComponent."Subc. Qty. transf. to Subcontr";                    NetStockAtSubcLocation -= SubcTransferManagement.CalcConsumedQtyAtSubcLocation(ProdOrderComponent);                    if NetStockAtSubcLocation > 0 then                        exit(true);                end;            until ProdOrderComponent.Next() = 0;        SubcWIPLedgerEntry.SetCurrentKey("Prod. Order No.", "Prod. Order Status", "Prod. Order Line No.", "Routing Reference No.", "Routing No.", "Operation No.", "Location Code");        SubcWIPLedgerEntry.SetRange("Prod. Order No.", PurchaseLine."Prod. Order No.");        SubcWIPLedgerEntry.SetRange("Prod. Order Status", "Production Order Status"::Released);        SubcWIPLedgerEntry.SetRange("Prod. Order Line No.", PurchaseLine."Prod. Order Line No.");        SubcWIPLedgerEntry.SetRange("Routing Reference No.", ProdOrderRoutingLine."Routing Reference No.");        SubcWIPLedgerEntry.SetRange("Routing No.", ProdOrderRoutingLine."Routing No.");        SubcWIPLedgerEntry.SetRange("Operation No.", ProdOrderRoutingLine."Operation No.");        SubcWIPLedgerEntry.SetRange("In Transit", false);        SubcWIPLedgerEntry.CalcSums("Quantity (Base)");        if SubcWIPLedgerEntry."Quantity (Base)" <> 0 then            exit(true);        exit(false);    end;}