Table extension 99000829 Mfg. Planning Component

Base Application, Microsoft.Inventory.Planning

src/Layers/W1/BaseApp/Manufacturing/Inventory/Planning/MfgPlanningComponent.TableExt.al269 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.Inventory.Planning;using Microsoft.Inventory.Location;using Microsoft.Inventory.Requisition;using Microsoft.Manufacturing.Document;using Microsoft.Manufacturing.Routing;tableextension 99000829 "Mfg. Planning Component" extends "Planning Component"{    fields    {        field(19; "Routing Link Code"; Code[10])        {            Caption = 'Routing Link Code';            DataClassification = CustomerContent;            TableRelation = "Routing Link";            trigger OnValidate()            var                PlanningRtngLine: Record "Planning Routing Line";            begin                if "Calculation Formula" = "Calculation Formula"::"Fixed Quantity" then                    Validate("Expected Quantity", Quantity)                else                    UpdateExpectedQuantityForPlanningNeeds();                "Due Date" := ReqLine."Starting Date";                "Due Time" := ReqLine."Starting Time";                if "Routing Link Code" <> '' then begin                    PlanningRtngLine.SetRange("Worksheet Template Name", "Worksheet Template Name");                    PlanningRtngLine.SetRange("Worksheet Batch Name", "Worksheet Batch Name");                    PlanningRtngLine.SetRange("Worksheet Line No.", "Worksheet Line No.");                    PlanningRtngLine.SetRange("Routing Link Code", "Routing Link Code");                    if PlanningRtngLine.FindFirst() then begin                        "Due Date" := PlanningRtngLine."Starting Date";                        "Due Time" := PlanningRtngLine."Starting Time";                    end;                end;                if Format("Lead-Time Offset") <> '' then begin                    if "Due Date" = 0D then                        "Due Date" := ReqLine."Ending Date";                    "Due Date" :=                      "Due Date" -                      (CalcDate("Lead-Time Offset", WorkDate()) - WorkDate());                    "Due Time" := 0T;                end;                OnValidateRoutingLinkCodeOnBeforeValidateDueDate(Rec, ReqLine, PlanningRtngLine);                Validate("Due Date");            end;        }        field(20; "Scrap %"; Decimal)        {            AutoFormatType = 0;            BlankNumbers = BlankNeg;            Caption = 'Scrap %';            DataClassification = CustomerContent;            DecimalPlaces = 0 : 5;            MaxValue = 100;            trigger OnValidate()            begin                UpdateExpectedQuantityForPlanningNeeds();            end;        }    }    procedure PlanningNeeds(): Decimal    var        PlanningRtngLine: Record "Planning Routing Line";        NeededQty: Decimal;        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforePlanningNeeds(Rec, NeededQty, IsHandled);        if IsHandled then            exit(NeededQty);        GetReqLine();        "Due Date" := ReqLine."Starting Date";        PlanningRtngLine.Reset();        PlanningRtngLine.SetRange("Worksheet Template Name", "Worksheet Template Name");        PlanningRtngLine.SetRange("Worksheet Batch Name", "Worksheet Batch Name");        PlanningRtngLine.SetRange("Worksheet Line No.", "Worksheet Line No.");        if "Routing Link Code" <> '' then            PlanningRtngLine.SetRange("Routing Link Code", "Routing Link Code");        if PlanningRtngLine.FindFirst() then            NeededQty :=              ReqLine.Quantity * (1 + ReqLine."Scrap %" / 100) *              (1 + PlanningRtngLine."Scrap Factor % (Accumulated)") * (1 + "Scrap %" / 100) +              PlanningRtngLine."Fixed Scrap Qty. (Accum.)"        else            if ReqLine."Replenishment System" = ReqLine."Replenishment System"::Assembly then                NeededQty := ReqLine.Quantity            else                NeededQty := ReqLine.Quantity * (1 + ReqLine."Scrap %" / 100) * (1 + "Scrap %" / 100);        OnAfterPlanningNeeds(Rec, ReqLine, PlanningRtngLine, NeededQty);        exit(NeededQty);    end;    procedure TransferFromComponent(var ProdOrderComp: Record "Prod. Order Component")    begin        "Ref. Order Type" := "Ref. Order Type"::"Prod. Order";        "Ref. Order Status" := ProdOrderComp.Status;        "Ref. Order No." := ProdOrderComp."Prod. Order No.";        "Ref. Order Line No." := ProdOrderComp."Prod. Order Line No.";        "Line No." := ProdOrderComp."Line No.";        "Item No." := ProdOrderComp."Item No.";        Description := ProdOrderComp.Description;        "Description 2" := ProdOrderComp."Description 2";        "Unit of Measure Code" := ProdOrderComp."Unit of Measure Code";        "Quantity per" := ProdOrderComp."Quantity per";        Quantity := ProdOrderComp.Quantity;        Position := ProdOrderComp.Position;        "Position 2" := ProdOrderComp."Position 2";        "Position 3" := ProdOrderComp."Position 3";        "Lead-Time Offset" := ProdOrderComp."Lead-Time Offset";        "Routing Link Code" := ProdOrderComp."Routing Link Code";        "Scrap %" := ProdOrderComp."Scrap %";        "Variant Code" := ProdOrderComp."Variant Code";        "Expected Quantity" := ProdOrderComp."Expected Quantity";        "Location Code" := ProdOrderComp."Location Code";        "Dimension Set ID" := ProdOrderComp."Dimension Set ID";        "Shortcut Dimension 1 Code" := ProdOrderComp."Shortcut Dimension 1 Code";        "Shortcut Dimension 2 Code" := ProdOrderComp."Shortcut Dimension 2 Code";        "Bin Code" := ProdOrderComp."Bin Code";        Length := ProdOrderComp.Length;        Width := ProdOrderComp.Width;        Weight := ProdOrderComp.Weight;        Depth := ProdOrderComp.Depth;        "Calculation Formula" := ProdOrderComp."Calculation Formula";        "Planning Level Code" := ProdOrderComp."Planning Level Code";        "Unit Cost" := ProdOrderComp."Unit Cost";        "Cost Amount" := ProdOrderComp."Cost Amount";        "Due Date" := ProdOrderComp."Due Date";        "Direct Unit Cost" := ProdOrderComp."Direct Unit Cost";        "Indirect Cost %" := ProdOrderComp."Indirect Cost %";        "Overhead Rate" := ProdOrderComp."Overhead Rate";        "Direct Cost Amount" := ProdOrderComp."Direct Cost Amount";        "Overhead Amount" := ProdOrderComp."Overhead Amount";        "Qty. per Unit of Measure" := ProdOrderComp."Qty. per Unit of Measure";        "Qty. Rounding Precision" := ProdOrderComp."Qty. Rounding Precision";        "Qty. Rounding Precision (Base)" := ProdOrderComp."Qty. Rounding Precision (Base)";        "Quantity (Base)" := ProdOrderComp."Quantity (Base)";        "Expected Quantity (Base)" := ProdOrderComp."Expected Qty. (Base)";        "Original Expected Qty. (Base)" := ProdOrderComp."Expected Qty. (Base)";        UpdateDatetime();        OnAfterTransferFromComponent(Rec, ProdOrderComp);    end;    local procedure FindFirstRtngLine(var PlanningRoutingLine: Record "Planning Routing Line"; ReqLine: Record "Requisition Line"): Boolean    begin        PlanningRoutingLine.Reset();        PlanningRoutingLine.SetRange("Worksheet Template Name", ReqLine."Worksheet Template Name");        PlanningRoutingLine.SetRange("Worksheet Batch Name", ReqLine."Journal Batch Name");        PlanningRoutingLine.SetRange("Worksheet Line No.", ReqLine."Line No.");        PlanningRoutingLine.SetFilter("No.", '<>%1', '');        PlanningRoutingLine.SetRange("Previous Operation No.", '');        if "Routing Link Code" <> '' then begin            PlanningRoutingLine.SetRange("Routing Link Code", "Routing Link Code");            PlanningRoutingLine.SetRange("Previous Operation No.");            if PlanningRoutingLine.Count = 0 then begin                PlanningRoutingLine.SetRange("Routing Link Code");                PlanningRoutingLine.SetRange("Previous Operation No.", '');            end;        end;        exit(PlanningRoutingLine.FindFirst());    end;    procedure GetRefOrderTypeBin() BinCode: Code[20]    var        PlanningRoutingLine: Record "Planning Routing Line";        ProdOrderWarehouseMgt: Codeunit "Prod. Order Warehouse Mgt.";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeGetRefOrderTypeBin(Rec, ReqLine, Location, BinCode, IsHandled);        if IsHandled then            exit;        case ReqLine."Ref. Order Type" of            ReqLine."Ref. Order Type"::"Prod. Order":                begin                    if "Location Code" = ReqLine."Location Code" then                        if FindFirstRtngLine(PlanningRoutingLine, ReqLine) then                            BinCode :=                                ProdOrderWarehouseMgt.GetProdCenterBinCode(                                    PlanningRoutingLine.Type, PlanningRoutingLine."No.", "Location Code", true, "Flushing Method");                    OnGetRefOrderTypeBinOnAfterGetBinCodeFromRoutingLine(Rec, PlanningRoutingLine, ReqLine, BinCode);                    if BinCode <> '' then                        exit(BinCode);                    BinCode := GetFlushingMethodBin();                end;            ReqLine."Ref. Order Type"::Assembly:                BinCode := Location."To-Assembly Bin Code";        end;    end;    local procedure GetFlushingMethodBin(): Code[20]    begin        case "Flushing Method" of            "Flushing Method"::"Pick + Manual",            "Flushing Method"::"Pick + Forward",            "Flushing Method"::"Pick + Backward":                exit(Location."To-Production Bin Code");            "Flushing Method"::Manual,            "Flushing Method"::Forward,            "Flushing Method"::Backward:                exit(Location."Open Shop Floor Bin Code");        end;    end;    procedure UpdateExpectedQuantityForPlanningNeeds()    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeUpdateExpectedQuantityForPlanningNeeds(Rec, IsHandled);        if IsHandled then            exit;        Validate("Expected Quantity", Quantity * PlanningNeeds());    end;    [IntegrationEvent(false, false)]    local procedure OnAfterPlanningNeeds(PlanningComponent: Record "Planning Component"; RequisitionLine: Record "Requisition Line"; PlanningRoutingLine: Record "Planning Routing Line"; var NeededQty: Decimal)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterTransferFromComponent(var PlanningComponent: Record "Planning Component"; var ProdOrderComp: Record "Prod. Order Component")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnValidateRoutingLinkCodeOnBeforeValidateDueDate(var PlanningComponent: Record "Planning Component"; RequisitionLine: Record "Requisition Line"; var PlanningRoutingLine: Record "Planning Routing Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeGetRefOrderTypeBin(PlanningComponent: Record "Planning Component"; RequisitionLine: Record "Requisition Line"; Location: Record Location; var BinCode: Code[20]; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnGetRefOrderTypeBinOnAfterGetBinCodeFromRoutingLine(var PlanningComponent: Record "Planning Component"; var PlanningRoutingLine: Record "Planning Routing Line"; var RequisitionLine: Record "Requisition Line"; var BinCode: Code[20])    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforePlanningNeeds(var PlanningComponent: Record "Planning Component"; var NeededQty: Decimal; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeUpdateExpectedQuantityForPlanningNeeds(var PlanningComponent: Record "Planning Component"; var IsHandled: Boolean)    begin    end;}