Report 99001015 Calculate Subcontracts

Base Application, Microsoft.Manufacturing.Planning

src/Layers/W1/BaseApp/Manufacturing/Planning/CalculateSubcontracts.Report.al439 lines, Copyright (c) Microsoft Corporation. MIT

#if not CLEAN28// ------------------------------------------------------------------------------------------------// 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.Planning;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Foundation.UOM;using Microsoft.Inventory.Costing;using Microsoft.Inventory.Item;using Microsoft.Inventory.Item.Catalog;using Microsoft.Inventory.Requisition;using Microsoft.Manufacturing.Document;using Microsoft.Manufacturing.Setup;using Microsoft.Manufacturing.WorkCenter;using Microsoft.Purchases.Document;report 99001015 "Calculate Subcontracts"{    Caption = 'Calculate Subcontracts (Obsolete)';    ProcessingOnly = true;    ObsoleteReason = 'Will be replaced by Report "Subc. Calculate Subcontracts" in the Subcontracting App.';    ObsoleteState = Pending;    ObsoleteTag = '28.0';    dataset    {        dataitem("Work Center"; "Work Center")        {            DataItemTableView = sorting("No.");            RequestFilterFields = "No.", "Subcontractor No.";            dataitem("Prod. Order Routing Line"; "Prod. Order Routing Line")            {                DataItemLink = "No." = field("No.");                DataItemTableView = sorting(Type, "No.") where(Status = const(Released), Type = const("Work Center"), "Routing Status" = filter(< Finished));                RequestFilterFields = "Prod. Order No.", "Starting Date";                trigger OnAfterGetRecord()                begin                    TempProdOrderRoutingLine.Init();                    TempProdOrderRoutingLine := "Prod. Order Routing Line";                    TempProdOrderRoutingLine.Insert();                end;            }            trigger OnAfterGetRecord()            begin                if "Subcontractor No." = '' then                    CurrReport.Skip();                Window.Update(1, "No.");            end;            trigger OnPreDataItem()            begin                TempProdOrderRoutingLine.DeleteAll();                ReqLine.SetRange("Worksheet Template Name", ReqLine."Worksheet Template Name");                ReqLine.SetRange("Journal Batch Name", ReqLine."Journal Batch Name");                ReqLine.DeleteAll();            end;            trigger OnPostDataItem()            begin                CalculateSubContractRequirements();            end;        }    }    requestpage    {        layout        {        }        actions        {        }    }    labels    {    }    trigger OnInitReport()    begin        MfgSetup.Get();    end;    trigger OnPreReport()    begin        ReqWkshTmpl.Get(ReqLine."Worksheet Template Name");        ReqWkShName.Get(ReqLine."Worksheet Template Name", ReqLine."Journal Batch Name");        ReqLine.SetRange("Worksheet Template Name", ReqLine."Worksheet Template Name");        ReqLine.SetRange("Journal Batch Name", ReqLine."Journal Batch Name");        ReqLine.LockTable();        if ReqLine.FindLast() then            ReqLine.Init();        Window.Open(Text000 + Text001);    end;    var        MfgSetup: Record "Manufacturing Setup";        ReqWkshTmpl: Record "Req. Wksh. Template";        ReqWkShName: Record "Requisition Wksh. Name";        ReqLine: Record "Requisition Line";        ProdOrderLine: Record "Prod. Order Line";        GLSetup: Record "General Ledger Setup";        PurchLine: Record "Purchase Line";        Item: Record Item;        ItemVariant: Record "Item Variant";        TempProdOrderRoutingLine: Record "Prod. Order Routing Line" temporary;        MfgCostCalcMgt: Codeunit "Mfg. Cost Calculation Mgt.";        UOMMgt: Codeunit "Unit of Measure Management";        Window: Dialog;        BaseQtyToPurch: Decimal;        QtyToPurch: Decimal;        GLSetupRead: Boolean;#pragma warning disable AA0074#pragma warning disable AA0470        Text000: Label 'Processing Work Centers   #1##########\';        Text001: Label 'Processing Orders         #2########## ';#pragma warning restore AA0470#pragma warning restore AA0074        ProductionBlockedOutputItemQst: Label 'Item %1 is blocked for production output and cannot be calculated. Do you want to continue?', Comment = '%1 Item No.';        ProductionBlockedOutputItemVariantQst: Label 'Variant %1 for item %2 is blocked for production output and cannot be calculated. Do you want to continue?', Comment = '%1 - Item Variant Code, %2 - Item No.';    procedure SetWkShLine(NewReqLine: Record "Requisition Line")    begin        ReqLine := NewReqLine;    end;    local procedure InsertReqWkshLine(ProdOrderRoutingLine: Record "Prod. Order Routing Line")    var        WorkCenter: Record "Work Center";        IsHandled: Boolean;    begin        IsHandled := false;        if ProdOrderRoutingLine.Type = ProdOrderRoutingLine.Type::"Work Center" then            WorkCenter.Get(ProdOrderRoutingLine."No.");#pragma warning disable AL0432        OnBeforeInsertReqWkshLine(ProdOrderRoutingLine, WorkCenter, ReqLine, IsHandled, ProdOrderLine);#pragma warning restore AL0432        if IsHandled then            exit;        ProdOrderLine.CalcFields("Total Exp. Oper. Output (Qty.)");        ReqLine.SetSubcontracting(true);        ReqLine.BlockDynamicTracking(true);        if not CanCreateRequisitionLineFromProdOrderLine(ProdOrderLine."Item No.", ProdOrderLine."Variant Code") then            exit;        ReqLine.Init();        ReqLine."Line No." := ReqLine."Line No." + 10000;        ReqLine.Validate(Type, ReqLine.Type::Item);        ReqLine.Validate("No.", ProdOrderLine."Item No.");        ReqLine.Validate("Variant Code", ProdOrderLine."Variant Code");        ReqLine.Validate("Unit of Measure Code", ProdOrderLine."Unit of Measure Code");        ReqLine.Validate(Quantity, QtyToPurch);        GetGLSetup();        IsHandled := false;#pragma warning disable AL0432        OnBeforeValidateUnitCost(ReqLine, WorkCenter, IsHandled, ProdOrderLine, ProdOrderRoutingLine);#pragma warning restore AL0432        if not IsHandled then            if ReqLine.Quantity <> 0 then begin                if WorkCenter."Unit Cost Calculation" = WorkCenter."Unit Cost Calculation"::Units then                    ReqLine.Validate(                        ReqLine."Direct Unit Cost",                        Round(                            ProdOrderRoutingLine."Direct Unit Cost" * ProdOrderLine."Qty. per Unit of Measure",                            GLSetup."Unit-Amount Rounding Precision"))                else                    ReqLine.Validate(                        ReqLine."Direct Unit Cost",                        Round(                            (ProdOrderRoutingLine."Expected Operation Cost Amt." - ProdOrderRoutingLine."Expected Capacity Ovhd. Cost") /                            ProdOrderLine."Total Exp. Oper. Output (Qty.)",                            GLSetup."Unit-Amount Rounding Precision"));            end else                ReqLine.Validate(ReqLine."Direct Unit Cost", 0);        ReqLine."Qty. per Unit of Measure" := 0;        ReqLine."Quantity (Base)" := 0;        ReqLine."Qty. Rounding Precision" := ProdOrderLine."Qty. Rounding Precision";        ReqLine."Qty. Rounding Precision (Base)" := ProdOrderLine."Qty. Rounding Precision (Base)";        ReqLine."Prod. Order No." := ProdOrderLine."Prod. Order No.";        ReqLine."Prod. Order Line No." := ProdOrderLine."Line No.";        ReqLine."Due Date" := ProdOrderRoutingLine."Ending Date";        ReqLine."Requester ID" := CopyStr(UserId(), 1, 50);        ReqLine."Location Code" := ProdOrderLine."Location Code";        ReqLine."Bin Code" := ProdOrderLine."Bin Code";        ReqLine."Routing Reference No." := ProdOrderRoutingLine."Routing Reference No.";        ReqLine."Routing No." := ProdOrderRoutingLine."Routing No.";        ReqLine."Operation No." := ProdOrderRoutingLine."Operation No.";        ReqLine."Work Center No." := ProdOrderRoutingLine."Work Center No.";        ReqLine.Validate(ReqLine."Vendor No.", WorkCenter."Subcontractor No.");        ReqLine.Description := ProdOrderRoutingLine.Description;        ReqLine."Description 2" := ProdOrderRoutingLine."Description 2";        SetVendorItemNo();#pragma warning disable AL0432        OnAfterTransferProdOrderRoutingLine(ReqLine, ProdOrderRoutingLine);#pragma warning restore AL0432        // If purchase order already exist we will change this if possible        PurchLine.Reset();        PurchLine.SetCurrentKey("Document Type", Type, "Prod. Order No.", "Prod. Order Line No.", "Routing No.", "Operation No.");        PurchLine.SetRange("Document Type", PurchLine."Document Type"::Order);        PurchLine.SetRange(Type, PurchLine.Type::Item);        PurchLine.SetRange("Prod. Order No.", ProdOrderLine."Prod. Order No.");        PurchLine.SetRange("Prod. Order Line No.", ProdOrderLine."Line No.");        PurchLine.SetRange("Routing No.", ProdOrderRoutingLine."Routing No.");        PurchLine.SetRange("Operation No.", ProdOrderRoutingLine."Operation No.");        PurchLine.SetRange("Planning Flexibility", PurchLine."Planning Flexibility"::Unlimited);        PurchLine.SetRange("Quantity Received", 0);        if PurchLine.FindFirst() then begin            ReqLine.Validate(ReqLine.Quantity, ReqLine.Quantity + PurchLine."Outstanding Quantity");            ReqLine."Quantity (Base)" := 0;            ReqLine."Replenishment System" := ReqLine."Replenishment System"::Purchase;            ReqLine."Ref. Order No." := PurchLine."Document No.";            ReqLine."Ref. Order Type" := ReqLine."Ref. Order Type"::Purchase;            ReqLine."Ref. Line No." := PurchLine."Line No.";            if PurchLine."Expected Receipt Date" = ReqLine."Due Date" then                ReqLine."Action Message" := ReqLine."Action Message"::"Change Qty."            else                ReqLine."Action Message" := ReqLine."Action Message"::"Resched. & Chg. Qty.";            ReqLine."Accept Action Message" := true;        end else begin            ReqLine."Replenishment System" := ReqLine."Replenishment System"::"Prod. Order";            ReqLine."Ref. Order No." := ProdOrderLine."Prod. Order No.";            ReqLine."Ref. Order Type" := ReqLine."Ref. Order Type"::"Prod. Order";            ReqLine."Ref. Order Status" := ProdOrderLine.Status;            ReqLine."Ref. Line No." := ProdOrderLine."Line No.";            ReqLine."Action Message" := ReqLine."Action Message"::New;            ReqLine."Accept Action Message" := true;        end;        if ReqLine."Ref. Order No." <> '' then            ReqLine.GetDimFromRefOrderLine(true);#pragma warning disable AL0432        OnBeforeReqWkshLineInsert(ReqLine, ProdOrderLine);#pragma warning restore AL0432        ReqLine.Insert();    end;    local procedure GetGLSetup()    begin        if not GLSetupRead then            GLSetup.Get();        GLSetupRead := true;    end;    local procedure DeleteRepeatedReqLines(ProdOrderRoutingLine: Record "Prod. Order Routing Line")    var        RequisitionLine: Record "Requisition Line";    begin        RequisitionLine.SetRange(Type, RequisitionLine.Type::Item);        RequisitionLine.SetRange("No.", ProdOrderLine."Item No.");        RequisitionLine.SetRange("Prod. Order No.", ProdOrderLine."Prod. Order No.");        RequisitionLine.SetRange("Prod. Order Line No.", ProdOrderLine."Line No.");        RequisitionLine.SetRange("Operation No.", ProdOrderRoutingLine."Operation No.");#pragma warning disable AL0432        OnDeleteRepeatedReqLinesOnAfterRequisitionLineSetFilters(RequisitionLine, ProdOrderLine, ProdOrderRoutingLine);#pragma warning restore AL0432        RequisitionLine.DeleteAll(true);    end;    local procedure SetVendorItemNo()    var        ItemVendor: Record "Item Vendor";    begin        if ReqLine."No." = '' then            exit;        if Item."No." <> ReqLine."No." then begin            Item.SetLoadFields("No.");            Item.Get(ReqLine."No.");        end;        ItemVendor.Init();        ItemVendor."Vendor No." := ReqLine."Vendor No.";        ItemVendor."Variant Code" := ReqLine."Variant Code";        Item.FindItemVend(ItemVendor, ReqLine."Location Code");        ReqLine.Validate("Vendor Item No.", ItemVendor."Vendor Item No.");#pragma warning disable AL0432        OnAfterSetVendorItemNo(ReqLine, ItemVendor, Item);#pragma warning restore AL0432    end;    local procedure CanCreateRequisitionLineFromProdOrderLine(ItemNo: Code[20]; VariantCode: Code[20]): Boolean    begin        if not GuiAllowed() then            exit;        if ItemNo <> '' then begin            if Item."No." <> ItemNo then begin                Item.SetLoadFields("Production Blocked");                Item.Get(ItemNo);            end;            case Item."Production Blocked" of                Item."Production Blocked"::Output:                    begin                        ShowProdBlockedForItemConfirmation(ItemNo);                        exit(false);                    end;            end;        end;        if (ItemNo <> '') and (VariantCode <> '') then begin            if (ItemVariant."Item No." <> ItemNo) or (ItemVariant.Code <> VariantCode) then begin                ItemVariant.SetLoadFields("Production Blocked");                ItemVariant.Get(ItemNo, VariantCode);            end;            case ItemVariant."Production Blocked" of                ItemVariant."Production Blocked"::Output:                    begin                        ShowProdBlockedForItemVariantConfirmation(ItemNo, VariantCode);                        exit(false);                    end;            end;        end;        exit(true);    end;    local procedure CalculateSubContractRequirements()    begin#pragma warning disable AL0432        OnProdOrderRoutingLineOnBeforeCalculateSubContractRequirements(TempProdOrderRoutingLine);#pragma warning restore AL0432        if TempProdOrderRoutingLine.IsEmpty() then            exit;        TempProdOrderRoutingLine.SetCurrentKey("Prod. Order No.", "Routing Reference No.", Status, "Routing No.", "Operation No.");        if TempProdOrderRoutingLine.FindSet() then            repeat                Window.Update(2, TempProdOrderRoutingLine."Prod. Order No.");                ProdOrderLine.SetCurrentKey(Status, "Prod. Order No.", "Routing No.", "Routing Reference No.");                ProdOrderLine.SetRange(Status, TempProdOrderRoutingLine.Status);                ProdOrderLine.SetRange("Prod. Order No.", TempProdOrderRoutingLine."Prod. Order No.");                ProdOrderLine.SetRange("Routing No.", TempProdOrderRoutingLine."Routing No.");                ProdOrderLine.SetRange("Routing Reference No.", TempProdOrderRoutingLine."Routing Reference No.");#pragma warning disable AL0432                OnProdOrderRoutingLineOnAfterGetRecordOnAfterProdOrderLineSetFilters(ProdOrderLine, TempProdOrderRoutingLine);#pragma warning restore AL0432                if ProdOrderLine.FindSet() then begin                    DeleteRepeatedReqLines(TempProdOrderRoutingLine);                    repeat                        BaseQtyToPurch :=                            MfgCostCalcMgt.CalcQtyAdjdForRoutingScrap(                                MfgCostCalcMgt.CalcQtyAdjdForBOMScrap(                                    ProdOrderLine."Quantity (Base)", ProdOrderLine."Scrap %"),                                    TempProdOrderRoutingLine."Scrap Factor % (Accumulated)", TempProdOrderRoutingLine."Fixed Scrap Qty. (Accum.)") -                            (MfgCostCalcMgt.CalcOutputQtyBaseOnPurchOrder(ProdOrderLine, TempProdOrderRoutingLine) +                             MfgCostCalcMgt.CalcActOutputQtyBase(ProdOrderLine, TempProdOrderRoutingLine));                        QtyToPurch := Round(BaseQtyToPurch / ProdOrderLine."Qty. per Unit of Measure", UOMMgt.QtyRndPrecision());#pragma warning disable AL0432                        OnAfterCalcQtyToPurch(ProdOrderLine, QtyToPurch);#pragma warning restore AL0432                        if QtyToPurch > 0 then                            InsertReqWkshLine(TempProdOrderRoutingLine);                    until ProdOrderLine.Next() = 0;                end;            until TempProdOrderRoutingLine.Next() = 0;    end;    local procedure ShowProdBlockedForItemConfirmation(ItemNo: Code[20])    begin        if not Confirm(StrSubstNo(ProductionBlockedOutputItemQst, ItemNo)) then            Error('');    end;    local procedure ShowProdBlockedForItemVariantConfirmation(ItemNo: Code[20]; VariantCode: Code[20])    begin        if not Confirm(StrSubstNo(ProductionBlockedOutputItemVariantQst, VariantCode, ItemNo)) then            Error('');    end;    [Obsolete('Will be replaced by Report "Subc. Calculate Subcontracts" in the Subcontracting App.', '29.0')]    [IntegrationEvent(false, false)]    local procedure OnAfterCalcQtyToPurch(ProdOrderLine: Record "Prod. Order Line"; var QtyToPurch: Decimal)    begin    end;    [Obsolete('Will be replaced by Report "Subc. Calculate Subcontracts" in the Subcontracting App.', '29.0')]    [IntegrationEvent(false, false)]    local procedure OnAfterTransferProdOrderRoutingLine(var RequisitionLine: Record "Requisition Line"; ProdOrderRoutingLine: Record "Prod. Order Routing Line")    begin    end;    [Obsolete('Will be replaced by Report "Subc. Calculate Subcontracts" in the Subcontracting App.', '29.0')]    [IntegrationEvent(false, false)]    local procedure OnBeforeInsertReqWkshLine(var ProdOrderRoutingLine: Record "Prod. Order Routing Line"; var WorkCenter: Record "Work Center"; var ReqLine: Record "Requisition Line"; var IsHandled: Boolean; ProdOrderLine: Record "Prod. Order Line");    begin    end;    [Obsolete('Will be replaced by Report "Subc. Calculate Subcontracts" in the Subcontracting App.', '29.0')]    [IntegrationEvent(false, false)]    local procedure OnBeforeValidateUnitCost(var RequisitionLine: Record "Requisition Line"; var WorkCenter: Record "Work Center"; var IsHandled: Boolean; ProdOrderLine: Record "Prod. Order Line"; ProdOrderRoutingLine: Record "Prod. Order Routing Line")    begin    end;    [Obsolete('Will be replaced by Report "Subc. Calculate Subcontracts" in the Subcontracting App.', '29.0')]    [IntegrationEvent(false, false)]    local procedure OnBeforeReqWkshLineInsert(var RequisitionLine: Record "Requisition Line"; ProdOrderLine: Record "Prod. Order Line")    begin    end;    [Obsolete('Will be replaced by Report "Subc. Calculate Subcontracts" in the Subcontracting App.', '29.0')]    [IntegrationEvent(false, false)]    local procedure OnDeleteRepeatedReqLinesOnAfterRequisitionLineSetFilters(var RequisitionLine: Record "Requisition Line"; ProdOrderLine: Record "Prod. Order Line"; ProdOrderRoutingLine: Record "Prod. Order Routing Line")    begin    end;    [Obsolete('Will be replaced by Report "Subc. Calculate Subcontracts" in the Subcontracting App.', '29.0')]    [IntegrationEvent(false, false)]    local procedure OnProdOrderRoutingLineOnAfterGetRecordOnAfterProdOrderLineSetFilters(var ProdOrderLine: Record "Prod. Order Line"; ProdOrderRoutingLine: Record "Prod. Order Routing Line")    begin    end;    [Obsolete('Will be replaced by Report "Subc. Calculate Subcontracts" in the Subcontracting App.', '29.0')]    [IntegrationEvent(false, false)]    local procedure OnAfterSetVendorItemNo(var RequisitionLine: Record "Requisition Line"; ItemVendor: Record "Item Vendor"; Item: Record Item)    begin    end;    [Obsolete('Will be replaced by Report "Subc. Calculate Subcontracts" in the Subcontracting App.', '29.0')]    [IntegrationEvent(false, false)]    local procedure OnProdOrderRoutingLineOnBeforeCalculateSubContractRequirements(var TempProdOrderRoutingLine: Record "Prod. Order Routing Line" temporary)    begin    end;}#endif