Report 20502 Subc. Create SubCReturnOrder

Subcontracting, Microsoft.Manufacturing.Subcontracting

src/Apps/W1/Subcontracting/App/src/Purchase/SubcCreateSubCReturnOrder.Report.al437 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.Foundation.UOM;using Microsoft.Inventory.Costing;using Microsoft.Inventory.Item;using Microsoft.Inventory.Transfer;using Microsoft.Manufacturing.Document;using Microsoft.Purchases.Document;using Microsoft.Purchases.Vendor;report 20502 "Subc. Create SubCReturnOrder"{    ApplicationArea = Subcontracting;    Caption = 'Create Subcontracting Return Order';    ProcessingOnly = true;    dataset    {        dataitem("Purchase Header"; "Purchase Header")        {            DataItemTableView = sorting("Document Type", "No.") order(ascending);            dataitem("Purchase Line"; "Purchase Line")            {                DataItemLink = "Document No." = field("No.");                DataItemTableView = sorting("Document Type", "Document No.", "Line No.") order(ascending) where("Prod. Order No." = filter(<> ''));                trigger OnAfterGetRecord()                var                    QtyToPost: Decimal;                begin                    HandleComponentReturnForPurchLine("Purchase Line", true, QtyToPost);                    HandleWIPReturnForPurchLine("Purchase Line", true);                end;            }            trigger OnAfterGetRecord()            begin                "Purchase Header".CalcFields("Subc. Order");                if not "Subc. Order" then                    Error(OrderNoIsNotSubcontractorErr, PurchOrderNo);                if not CheckTransferToCreate() then                    Error(NothingToCreateErr);                Vendor.Get("Purchase Header"."Buy-from Vendor No.");            end;            trigger OnPostDataItem()            begin                ShowDocument();            end;            trigger OnPreDataItem()            begin                PurchOrderNo := CopyStr("Purchase Header".GetFilter("No."), 1, MaxStrLen(PurchOrderNo));                if PurchOrderNo = '' then                    Error(WarningToSpecifyPurchOrderErr);            end;        }    }#if not CLEAN29    trigger OnInitReport()    var#pragma warning disable AL0432        SubcFeatureFlagHandler: Codeunit "Subc. Feature Flag Handler";#pragma warning restore AL0432    begin#pragma warning disable AL0432        if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432            CurrReport.Quit();    end;#endif    var        TransferHeader: Record "Transfer Header";        TransferLine: Record "Transfer Line";        Vendor: Record Vendor;        PurchOrderNo: Code[20];        LineNo: Integer;        NothingToCreateErr: Label 'Nothing to create. No components or WIP items to return for the specified subcontracting order.';        OrderNoDoesNotExistInProdOrderErr: Label 'Operation %1 in the subcontracting order %2 does not exist in the routing %3 of the production order %4.', Comment = '%1=Operation No., %2=Purchase Order No., %3=Routing No., %4=Production Order No.';        OrderNoIsNotSubcontractorErr: Label 'Order %1 is not a Subcontractor work.', Comment = '%1=Purchase Order No.';        SubcLocationCodeMissingErr: Label 'The Subc. Location Code must be specified on Vendor %1 or the Subcontracting Purchase Order to create return orders.', Comment = '%1=Vendor No.';        WarningToSpecifyPurchOrderErr: Label 'Warning. Specify a Purchase Order No. for the Subcontractor work.';    local procedure InsertTransferHeader(TransferFromLocationCode: Code[10]; TransferToLocationCode: Code[10])    var        TransferRoute: Record "Transfer Route";        SubcTransferManagement: Codeunit "Subc. Transfer Management";    begin        TransferHeader.Reset();        TransferHeader.SetRange("Subc. Source Type", TransferHeader."Subc. Source Type"::Subcontracting);        TransferHeader.SetRange("Source ID", "Purchase Header"."Buy-from Vendor No.");        TransferHeader.SetRange(Status, TransferHeader.Status::Open);        TransferHeader.SetRange("Completely Shipped", false);        TransferHeader.SetRange("Transfer-from Code", TransferFromLocationCode);        TransferHeader.SetRange("Transfer-to Code", TransferToLocationCode);        TransferHeader.SetRange("Subc. Return Order", true);        if not TransferHeader.FindFirst() then begin            TransferHeader.Init();            TransferHeader."No." := '';            TransferHeader.Insert(true);            TransferHeader.Validate("Transfer-from Code", TransferFromLocationCode);            TransferHeader.Validate("Transfer-to Code", TransferToLocationCode);            if not TransferRoute.Get(TransferFromLocationCode, TransferToLocationCode) or (TransferRoute."In-Transit Code" = '') then begin                SubcTransferManagement.CheckDirectTransferIsAllowedForTransferHeader(TransferHeader);                TransferHeader.Validate("Direct Transfer", true);            end;            TransferHeader."Subc. Source Type" := TransferHeader."Subc. Source Type"::Subcontracting;            TransferHeader."Source ID" := "Purchase Header"."Buy-from Vendor No.";            TransferHeader."Subcontr. Purch. Order No." := "Purchase Header"."No.";            TransferHeader."Subcontr. PO Line No." := "Purchase Line"."Line No.";            TransferHeader."Subc. Return Order" := true;            TransferHeader."Transfer-from Name" := Vendor.Name;            TransferHeader."Transfer-from Name 2" := Vendor."Name 2";            TransferHeader."Transfer-from Address" := Vendor.Address;            TransferHeader."Transfer-from Address 2" := Vendor."Address 2";            TransferHeader."Transfer-from Post Code" := Vendor."Post Code";            TransferHeader."Transfer-from City" := Vendor.City;            TransferHeader."Transfer-from County" := Vendor.County;            TransferHeader."Trsf.-from Country/Region Code" := Vendor."Country/Region Code";            TransferHeader.Modify();            OnAfterInsertTransferHeader(TransferHeader, Vendor);            LineNo := 0;        end else begin            TransferLine.SetRange("Document No.", TransferHeader."No.");            if TransferLine.FindLast() then                LineNo := TransferLine."Line No."            else                LineNo := 0;        end;    end;    local procedure CheckTransferToCreate(): Boolean    var        PurchaseLine: Record "Purchase Line";        QtyToPost: Decimal;    begin        PurchaseLine.SetCurrentKey("Document Type", Type, "Prod. Order No.", "Prod. Order Line No.", "Routing No.", "Operation No.");        PurchaseLine.SetRange("Document No.", PurchOrderNo);        PurchaseLine.SetFilter("Prod. Order No.", '<>''''');        PurchaseLine.SetFilter("Prod. Order Line No.", '<>0');        PurchaseLine.SetFilter("Operation No.", '<>0');        if PurchaseLine.FindSet() then            repeat                if HandleComponentReturnForPurchLine(PurchaseLine, false, QtyToPost) then                    exit(true);                if HandleWIPReturnForPurchLine(PurchaseLine, false) then                    exit(true);            until PurchaseLine.Next() = 0;        exit(false);    end;    local procedure HandleComponentReturnForPurchLine(PurchaseLine: Record "Purchase Line"; InsertLine: Boolean; var QtyToPost: Decimal): Boolean    var        Item: Record Item;        ProdOrderComponent: Record "Prod. Order Component";        ProdOrderLine: Record "Prod. Order Line";        ProdOrderRoutingLine: Record "Prod. Order Routing Line";        MfgCostCalculationMgt: Codeunit "Mfg. Cost Calculation Mgt.";        SubcTransferManagement: Codeunit "Subc. Transfer Management";        SubcontractingManagement: Codeunit "Subcontracting Management";        UnitofMeasureManagement: Codeunit "Unit of Measure Management";        SubcFromLocationCode: Code[10];        AvailableToReturn: Decimal;        QtyPerUom: Decimal;    begin        if not ProdOrderLine.Get(ProdOrderLine.Status::Released, PurchaseLine."Prod. Order No.", PurchaseLine."Prod. Order Line No.") then            exit(false);        if not ProdOrderRoutingLine.Get(ProdOrderRoutingLine.Status::Released, PurchaseLine."Prod. Order No.",             PurchaseLine."Routing Reference No.", PurchaseLine."Routing No.", PurchaseLine."Operation No.")        then            Error(OrderNoDoesNotExistInProdOrderErr, PurchaseLine."Operation No.", PurchOrderNo, PurchaseLine."Routing No.", PurchaseLine."Prod. Order No.");        if TransferLineAlreadyExists(PurchaseLine) then            exit(false);        Item.SetLoadFields("Base Unit of Measure", "Rounding Precision");        Item.Get(PurchaseLine."No.");        QtyPerUom := UnitofMeasureManagement.GetQtyPerUnitOfMeasure(Item, PurchaseLine."Unit of Measure Code");        ProdOrderComponent.SetCurrentKey(Status, "Prod. Order No.", "Routing Link Code");        ProdOrderComponent.SetRange(Status, ProdOrderComponent.Status::Released);        ProdOrderComponent.SetRange("Prod. Order No.", PurchaseLine."Prod. Order No.");        ProdOrderComponent.SetRange("Prod. Order Line No.", PurchaseLine."Prod. Order Line No.");        ProdOrderComponent.SetRange("Routing Link Code", ProdOrderRoutingLine."Routing Link Code");        ProdOrderComponent.SetRange("Subc. Purchase Order Filter", PurchaseLine."Document No.");        ProdOrderComponent.SetRange("Component Supply Method", ProdOrderComponent."Component Supply Method"::"Transfer to Vendor");        if ProdOrderComponent.FindSet() then begin            GetTransferFromLocationCode(SubcFromLocationCode);            repeat                Item.Get(ProdOrderComponent."Item No.");                QtyToPost := MfgCostCalculationMgt.CalcActNeededQtyBase(ProdOrderLine, ProdOrderComponent,                    Round(PurchaseLine."Outstanding Quantity" * QtyPerUom, UnitofMeasureManagement.QtyRndPrecision()));                ProdOrderComponent.CalcFields(                    "Subc. Qty. in Transit (Base)", "Subc. Qty. transf. to Subcontr",                    "RetQtyOnTransOrder (Base)", "RetQtyInTransit (Base)");                AvailableToReturn :=                    Abs(ProdOrderComponent."Subc. Qty. in Transit (Base)") + Abs(ProdOrderComponent."Subc. Qty. transf. to Subcontr")                    - SubcTransferManagement.CalcConsumedQtyAtSubcLocation(ProdOrderComponent)                    - Abs(ProdOrderComponent."RetQtyOnTransOrder (Base)") - Abs(ProdOrderComponent."RetQtyInTransit (Base)");                if QtyToPost > AvailableToReturn then                    QtyToPost := AvailableToReturn;                if QtyToPost > 0 then                    if InsertLine then begin                        if ProdOrderComponent."Subc. Original Location Code" = '' then                            ProdOrderComponent."Subc. Original Location Code" := ProdOrderComponent."Location Code";                        InsertTransferHeader(SubcFromLocationCode, ProdOrderComponent."Subc. Original Location Code");                        LineNo := LineNo + 10000;                        TransferLine.Init();                        TransferLine."Document No." := TransferHeader."No.";                        TransferLine."Line No." := LineNo;                        TransferLine.Validate("Item No.", ProdOrderComponent."Item No.");                        TransferLine.Validate("Variant Code", ProdOrderComponent."Variant Code");                        TransferLine."Unit of Measure Code" := ProdOrderComponent."Unit of Measure Code";                        TransferLine."Qty. per Unit of Measure" := ProdOrderComponent."Qty. per Unit of Measure";                        TransferLine.Validate(Quantity, Round(QtyToPost / ProdOrderComponent."Qty. per Unit of Measure", Item."Rounding Precision", '>'));                        TransferLine."Subc. Purch. Order No." := PurchaseLine."Document No.";                        TransferLine."Subc. Purch. Order Line No." := PurchaseLine."Line No.";                        TransferLine."Subc. Prod. Order No." := PurchaseLine."Prod. Order No.";                        TransferLine."Subc. Prod. Order Line No." := PurchaseLine."Prod. Order Line No.";                        TransferLine."Subc. Prod. Ord. Comp Line No." := ProdOrderComponent."Line No.";                        TransferLine."Subc. Return Order" := true;                        TransferLine."Subc. Routing No." := ProdOrderRoutingLine."Routing No.";                        TransferLine."Subc. Routing Reference No." := ProdOrderRoutingLine."Routing Reference No.";                        TransferLine."Subc. Work Center No." := ProdOrderRoutingLine."Work Center No.";                        TransferLine."Subc. Operation No." := ProdOrderRoutingLine."Operation No.";                        TransferLine."Subc. Return Order" := true;                        TransferLine.Insert();                        SubcTransferManagement.TransferReservationEntryFromProdOrderCompToTransferOrder(TransferLine, ProdOrderComponent);                        if ProdOrderComponent."Subc. Orig. Bin Code" = '' then                            ProdOrderComponent."Subc. Orig. Bin Code" := ProdOrderComponent."Bin Code";                        if TransferHeader."Transfer-to Code" <> ProdOrderComponent."Location Code" then                            SubcontractingManagement.ValidateProdOrderCompLocationPreservingFlushingMethod(ProdOrderComponent, TransferHeader."Transfer-to Code");                        ProdOrderComponent.Modify();                        SubcTransferManagement.CreateReservEntryForTransferReceiptToProdOrderComp(TransferLine, ProdOrderComponent);                    end else                        exit(true);            until ProdOrderComponent.Next() = 0;        end;        exit(false);    end;    local procedure ShowDocument()    var        SubcPurchFactboxMgmt: Codeunit "Subc. Purch. Factbox Mgmt.";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeShowDocument(TransferHeader, IsHandled);        if IsHandled then            exit;        Commit(); // Used for following call of Transfer Pages        SubcPurchFactboxMgmt.ShowTransferOrdersFromPurchaseOrder("Purchase Header", true);    end;    local procedure TransferLineAlreadyExists(PurchaseLine: Record "Purchase Line"): Boolean    var        TransferLine2: Record "Transfer Line";    begin        if PurchaseLine."Document No." = '' then            exit(false);        TransferLine2.SetRange("Subc. Purch. Order No.", PurchaseLine."Document No.");        TransferLine2.SetRange("Subc. Purch. Order Line No.", PurchaseLine."Line No.");        TransferLine2.SetRange("Subc. Prod. Order No.", PurchaseLine."Prod. Order No.");        TransferLine2.SetRange("Subc. Prod. Order Line No.", PurchaseLine."Prod. Order Line No.");        TransferLine2.SetRange("Derived From Line No.", 0);        TransferLine2.SetRange("Subc. Return Order", true);        exit(not TransferLine2.IsEmpty());    end;    local procedure GetTransferFromLocationCode(var SubcLocationCode: Code[10])    begin        SubcLocationCode := "Purchase Header"."Subc. Location Code";        if SubcLocationCode = '' then begin            SubcLocationCode := Vendor."Subc. Location Code";            if SubcLocationCode = '' then                Error(SubcLocationCodeMissingErr, Vendor."No.");        end;    end;    local procedure HandleWIPReturnForPurchLine(PurchaseLine: Record "Purchase Line"; InsertLine: Boolean): Boolean    var        Item: Record Item;        ProdOrderLine: Record "Prod. Order Line";        ProdOrderRoutingLine: Record "Prod. Order Routing Line";        UOMManagement: Codeunit "Unit of Measure Management";        CompanyWHLocationCode: Code[10];        TransferFromLoc: Code[10];        WIPQtyBase: Decimal;        WIPQtyInUOM: Decimal;        WIPSourceQtyDict: Dictionary of [Code[10], Decimal];        WIPSourceLocationList: List of [Code[10]];    begin        if not ProdOrderLine.Get("Production Order Status"::Released, PurchaseLine."Prod. Order No.", PurchaseLine."Prod. Order Line No.") then            exit(false);        if not ProdOrderRoutingLine.Get("Production Order Status"::Released, PurchaseLine."Prod. Order No.",                PurchaseLine."Routing Reference No.", PurchaseLine."Routing No.", PurchaseLine."Operation No.")        then            exit(false);        if not ProdOrderRoutingLine."Transfer WIP Item" then            exit(false);        if WIPReturnTransferLineAlreadyExists(PurchaseLine) then            exit(false);        CompanyWHLocationCode := ProdOrderLine."Location Code";        GetWIPReturnFromLocations(ProdOrderLine, ProdOrderRoutingLine, WIPSourceLocationList, WIPSourceQtyDict);        if WIPSourceLocationList.Count() = 0 then            exit(false);        if not InsertLine then            exit(true);        Item.SetLoadFields("Base Unit of Measure", "Rounding Precision", Description, "Description 2");        Item.Get(ProdOrderLine."Item No.");        foreach TransferFromLoc in WIPSourceLocationList do begin            WIPQtyBase := WIPSourceQtyDict.Get(TransferFromLoc);            if ProdOrderLine."Qty. per Unit of Measure" <> 0 then                WIPQtyInUOM := Round(WIPQtyBase / ProdOrderLine."Qty. per Unit of Measure", UOMManagement.QtyRndPrecision())            else                WIPQtyInUOM := Round(WIPQtyBase, UOMManagement.QtyRndPrecision());            if WIPQtyInUOM > 0 then begin                InsertTransferHeader(TransferFromLoc, CompanyWHLocationCode);                InsertWIPReturnTransferLine(PurchaseLine, ProdOrderLine, ProdOrderRoutingLine, WIPQtyInUOM);            end;        end;        exit(false);    end;    local procedure GetWIPReturnFromLocations(ProdOrderLine: Record "Prod. Order Line"; ProdOrderRoutingLine: Record "Prod. Order Routing Line"; var WIPSourceLocationList: List of [Code[10]]; var WIPSourceQtyList: Dictionary of [Code[10], Decimal])    var        WIPLedgerEntry: Record "Subcontractor WIP Ledger Entry";        LocationCode: Code[10];    begin        WIPLedgerEntry.SetRange("Prod. Order Status", "Production Order Status"::Released);        WIPLedgerEntry.SetRange("Prod. Order No.", ProdOrderLine."Prod. Order No.");        WIPLedgerEntry.SetRange("Prod. Order Line No.", ProdOrderLine."Line No.");        WIPLedgerEntry.SetRange("Routing No.", ProdOrderRoutingLine."Routing No.");        WIPLedgerEntry.SetRange("Routing Reference No.", ProdOrderRoutingLine."Routing Reference No.");        WIPLedgerEntry.SetRange("Operation No.", ProdOrderRoutingLine."Operation No.");        WIPLedgerEntry.SetRange("In Transit", false);        if WIPLedgerEntry.FindSet() then            repeat                LocationCode := WIPLedgerEntry."Location Code";                if WIPSourceQtyList.ContainsKey(LocationCode) then                    WIPSourceQtyList.Set(LocationCode, WIPSourceQtyList.Get(LocationCode) + WIPLedgerEntry."Quantity (Base)")                else begin                    WIPSourceLocationList.Add(LocationCode);                    WIPSourceQtyList.Add(LocationCode, WIPLedgerEntry."Quantity (Base)");                end;            until WIPLedgerEntry.Next() = 0;    end;    local procedure InsertWIPReturnTransferLine(PurchaseLine: Record "Purchase Line"; ProdOrderLine: Record "Prod. Order Line"; ProdOrderRoutingLine: Record "Prod. Order Routing Line"; WIPQty: Decimal)    begin        LineNo := LineNo + 10000;        TransferLine.Init();        TransferLine."Document No." := TransferHeader."No.";        TransferLine."Line No." := LineNo;        TransferLine.Validate("Item No.", ProdOrderLine."Item No.");        if ProdOrderLine."Variant Code" <> '' then            TransferLine.Validate("Variant Code", ProdOrderLine."Variant Code");        TransferLine.Validate("Unit of Measure Code", ProdOrderLine."Unit of Measure Code");        TransferLine.Validate("Transfer WIP Item", true);        TransferLine.Validate(Quantity, WIPQty);        if ProdOrderRoutingLine."Transfer Description" <> '' then            TransferLine.Description := ProdOrderRoutingLine."Transfer Description";        if ProdOrderRoutingLine."Transfer Description 2" <> '' then            TransferLine."Description 2" := ProdOrderRoutingLine."Transfer Description 2";        TransferLine."Subc. Purch. Order No." := PurchaseLine."Document No.";        TransferLine."Subc. Purch. Order Line No." := PurchaseLine."Line No.";        TransferLine."Subc. Prod. Order No." := ProdOrderLine."Prod. Order No.";        TransferLine."Subc. Prod. Order Line No." := ProdOrderLine."Line No.";        TransferLine."Subc. Routing No." := ProdOrderRoutingLine."Routing No.";        TransferLine."Subc. Routing Reference No." := ProdOrderRoutingLine."Routing Reference No.";        TransferLine."Subc. Work Center No." := ProdOrderRoutingLine."Work Center No.";        TransferLine."Subc. Operation No." := ProdOrderRoutingLine."Operation No.";        TransferLine."Subc. Return Order" := true;        TransferLine.Insert();    end;    local procedure WIPReturnTransferLineAlreadyExists(PurchaseLine: Record "Purchase Line"): Boolean    var        TransferLineToCheck: Record "Transfer Line";    begin        TransferLineToCheck.SetRange("Subc. Purch. Order No.", PurchaseLine."Document No.");        TransferLineToCheck.SetRange("Subc. Prod. Order No.", PurchaseLine."Prod. Order No.");        TransferLineToCheck.SetRange("Subc. Prod. Order Line No.", PurchaseLine."Prod. Order Line No.");        TransferLineToCheck.SetRange("Subc. Operation No.", PurchaseLine."Operation No.");        TransferLineToCheck.SetRange("Derived From Line No.", 0);        TransferLineToCheck.SetRange("Transfer WIP Item", true);        TransferLineToCheck.SetRange("Subc. Return Order", true);        exit(not TransferLineToCheck.IsEmpty());    end;    [IntegrationEvent(false, false)]    local procedure OnAfterInsertTransferHeader(var TransferHeader: Record "Transfer Header"; Vendor: Record Vendor)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeShowDocument(var TransferHeader: Record "Transfer Header"; var IsHandled: Boolean)    begin    end;}