Codeunit 20441 Qlty. Disp. Purchase Return

Quality Management, Microsoft.QualityManagement.Dispositions.Purchase

src/Apps/W1/Quality Management/app/src/Dispositions/Purchase/QltyDispPurchaseReturn.Codeunit.al318 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.QualityManagement.Dispositions.Purchase;using Microsoft.Foundation.UOM;using Microsoft.Inventory.Item;using Microsoft.Inventory.Ledger;using Microsoft.Inventory.Tracking;using Microsoft.Purchases.Document;using Microsoft.Purchases.History;using Microsoft.QualityManagement.Dispositions;using Microsoft.QualityManagement.Document;using Microsoft.QualityManagement.Integration.Inventory;using Microsoft.QualityManagement.Utilities;using Microsoft.Utilities;/// <summary>/// The purpose of this reaction is to create a purchase return as a reaction to an inspection result./// </summary>codeunit 20441 "Qlty. Disp. Purchase Return" implements "Qlty. Disposition"{    var        TempCreatedBufferPurchaseHeader: Record "Purchase Header" temporary;        NoPurchRcptLineErr: Label 'Could not find a related purchase receipt line with sufficient quantity for %1 from Quality Inspection %2,%3. Confirm the inspection source is a Purchase Line and that it has been received prior to creating a return.', Comment = '%1=item,%2=inspection,%3=re-inspection';        DocumentTypeLbl: Label 'Purchase Return';    /// <summary>    /// Creates a purchase return order from a quality inspection and explicit disposition options.    /// </summary>    /// <param name="QltyInspectionHeader">The inspection that identifies the inventory and purchase receipt.</param>    /// <param name="QltyQuantityBehavior">The rule used to determine the return quantity.</param>    /// <param name="OptionalSpecificQuantity">The specific base quantity to return when required by the quantity behavior.</param>    /// <param name="OptionalSourceLocationFilter">An optional source location filter.</param>    /// <param name="OptionalSourceBinFilter">An optional source bin filter.</param>    /// <param name="ReasonCode">The optional return reason code.</param>    /// <param name="ExternalDocumentNo">The optional vendor credit memo number.</param>    /// <returns>True if subscribers report that a purchase return was created; otherwise, false.</returns>    internal procedure PerformDisposition(var QltyInspectionHeader: Record "Qlty. Inspection Header"; QltyQuantityBehavior: Enum "Qlty. Quantity Behavior"; OptionalSpecificQuantity: Decimal; OptionalSourceLocationFilter: Text; OptionalSourceBinFilter: Text; ReasonCode: Code[10]; ExternalDocumentNo: Code[35]): Boolean    var        TempInstructionQltyDispositionBuffer: Record "Qlty. Disposition Buffer" temporary;    begin        TempInstructionQltyDispositionBuffer."Disposition Action" := TempInstructionQltyDispositionBuffer."Disposition Action"::"Create Purchase Return";        TempInstructionQltyDispositionBuffer."Qty. To Handle (Base)" := OptionalSpecificQuantity;        TempInstructionQltyDispositionBuffer."Quantity Behavior" := QltyQuantityBehavior;        TempInstructionQltyDispositionBuffer."Location Filter" := CopyStr(OptionalSourceLocationFilter, 1, MaxStrLen(TempInstructionQltyDispositionBuffer."Location Filter"));        TempInstructionQltyDispositionBuffer."Bin Filter" := CopyStr(OptionalSourceBinFilter, 1, MaxStrLen(TempInstructionQltyDispositionBuffer."Bin Filter"));        TempInstructionQltyDispositionBuffer."Reason Code" := ReasonCode;        TempInstructionQltyDispositionBuffer."External Document No." := ExternalDocumentNo;        exit(PerformDisposition(QltyInspectionHeader, TempInstructionQltyDispositionBuffer));    end;    /// <summary>    /// Creates a purchase return order and return lines for the inspection inventory.    /// </summary>    /// <param name="QltyInspectionHeader">The inspection that identifies the inventory and purchase receipt.</param>    /// <param name="TempInstructionQltyDispositionBuffer">The disposition instructions containing quantity, source filters, reason code, and vendor credit memo number.</param>    /// <returns>True if subscribers report that a purchase return was created; otherwise, false.</returns>    procedure PerformDisposition(var QltyInspectionHeader: Record "Qlty. Inspection Header"; var TempInstructionQltyDispositionBuffer: Record "Qlty. Disposition Buffer" temporary) DidSomething: Boolean    var        CreatedReturnOrderPurchaseHeader: Record "Purchase Header";        PurchRcptLine: Record "Purch. Rcpt. Line";        TempQuantityToActQltyDispositionBuffer: Record "Qlty. Disposition Buffer" temporary;        QltyInventoryAvailability: Codeunit "Qlty. Inventory Availability";        QltyNotificationMgmt: Codeunit "Qlty. Notification Mgmt.";        IsHandled: Boolean;        VendorCreditMemoNo: Code[35];    begin        VendorCreditMemoNo := CopyStr(TempInstructionQltyDispositionBuffer."External Document No.", 1, MaxStrLen(VendorCreditMemoNo));        OnBeforeProcessDisposition(QltyInspectionHeader, TempInstructionQltyDispositionBuffer, DidSomething, IsHandled);        if IsHandled then            exit;        QltyInventoryAvailability.PopulateQuantityBuffer(QltyInspectionHeader, TempInstructionQltyDispositionBuffer, TempQuantityToActQltyDispositionBuffer);        if not TempQuantityToActQltyDispositionBuffer.FindSet() then begin            QltyNotificationMgmt.NotifyDocumentCreationFailed(QltyInspectionHeader, TempInstructionQltyDispositionBuffer, DocumentTypeLbl);            exit;        end;        if not FindPurchaseReceiptLineForInspection(QltyInspectionHeader, TempQuantityToActQltyDispositionBuffer, PurchRcptLine) then            Error(NoPurchRcptLineErr, QltyInspectionHeader."Source Item No.", QltyInspectionHeader."No.", QltyInspectionHeader."Re-inspection No.");        TempQuantityToActQltyDispositionBuffer.FindSet();        repeat            if CreatedReturnOrderPurchaseHeader."No." = '' then                CreatePurchaseReturnOrderFromPurchaseReceiptLine(PurchRcptLine, CreatedReturnOrderPurchaseHeader, VendorCreditMemoNo);            CreatePurchaseReturnOrderLine(QltyInspectionHeader, TempQuantityToActQltyDispositionBuffer, PurchRcptLine, CreatedReturnOrderPurchaseHeader);        until TempQuantityToActQltyDispositionBuffer.Next() = 0;        OnAfterProcessDisposition(QltyInspectionHeader, TempInstructionQltyDispositionBuffer, CreatedReturnOrderPurchaseHeader, DidSomething);        if CreatedReturnOrderPurchaseHeader."No." <> '' then            QltyNotificationMgmt.NotifyDocumentCreated(QltyInspectionHeader, TempInstructionQltyDispositionBuffer, DocumentTypeLbl, CreatedReturnOrderPurchaseHeader."No.", CreatedReturnOrderPurchaseHeader)        else            QltyNotificationMgmt.NotifyDocumentCreationFailed(QltyInspectionHeader, TempInstructionQltyDispositionBuffer, DocumentTypeLbl);    end;    /// <summary>    /// Finds a purchase receipt line with enough remaining quantity for the requested return.    /// </summary>    /// <param name="QltyInspectionHeader">The inspection that identifies the source purchase order line and tracking values.</param>    /// <param name="TempQuantityToActQltyDispositionBuffer">The calculated quantities to return.</param>    /// <param name="PurchRcptLine">The matching purchase receipt line.</param>    /// <returns>True if a receipt line with sufficient remaining quantity was found; otherwise, false.</returns>    local procedure FindPurchaseReceiptLineForInspection(var QltyInspectionHeader: Record "Qlty. Inspection Header"; var TempQuantityToActQltyDispositionBuffer: Record "Qlty. Disposition Buffer" temporary; var PurchRcptLine: Record "Purch. Rcpt. Line"): Boolean    var        PurchRcptLine2: Record "Purch. Rcpt. Line";        TempItemLedgerEntry: Record "Item Ledger Entry" temporary;        MgmtItemTrackingDocManagement: Codeunit "Item Tracking Doc. Management";        UOMMgtUnitOfMeasureManagement: Codeunit "Unit of Measure Management";        AvailableQty: Decimal;        AvailableQtyBase: Decimal;        ReturnQtyBase: Decimal;        UnusedRevUnitCostLCY: Decimal;    begin        TempQuantityToActQltyDispositionBuffer.CalcSums("Qty. To Handle (Base)");        ReturnQtyBase := TempQuantityToActQltyDispositionBuffer."Qty. To Handle (Base)";        PurchRcptLine2.SetRange("Order No.", QltyInspectionHeader."Source Document No.");        PurchRcptLine2.SetRange("Order Line No.", QltyInspectionHeader."Source Document Line No.");        if QltyInspectionHeader."Source Item No." <> '' then begin            PurchRcptLine2.SetRange(Type, PurchRcptLine.Type::Item);            PurchRcptLine2.SetRange("No.", QltyInspectionHeader."Source Item No.");        end;        if QltyInspectionHeader.IsItemTrackingUsed() then begin            PurchRcptLine2.SetLoadFields("Document No.", "Line No.");            if PurchRcptLine2.FindSet() then                repeat                    MgmtItemTrackingDocManagement.RetrieveEntriesFromShptRcpt(TempItemLedgerEntry, Database::"Purch. Rcpt. Line",                        0,                        PurchRcptLine2."Document No.",                        '',                        0,                        PurchRcptLine2."Line No.");                    if QltyInspectionHeader."Source Lot No." <> '' then                        TempItemLedgerEntry.SetRange("Lot No.", QltyInspectionHeader."Source Lot No.");                    if QltyInspectionHeader."Source Serial No." <> '' then                        TempItemLedgerEntry.SetRange("Serial No.", QltyInspectionHeader."Source Serial No.");                    if QltyInspectionHeader."Source Package No." <> '' then                        TempItemLedgerEntry.SetRange("Package No.", QltyInspectionHeader."Source Package No.");                    if not TempItemLedgerEntry.IsEmpty() then begin                        TempItemLedgerEntry.CalcSums("Remaining Quantity");                        if TempItemLedgerEntry."Remaining Quantity" >= ReturnQtyBase then                            exit(PurchRcptLine.Get(PurchRcptLine2."Document No.", PurchRcptLine2."Line No."));                    end;                until PurchRcptLine2.Next() = 0;        end else begin            PurchRcptLine2.SetLoadFields("Document No.", "Line No.", "Qty. per Unit of Measure");            if PurchRcptLine2.FindSet() then                repeat                    PurchRcptLine2.CalcReceivedPurchNotReturned(AvailableQty, UnusedRevUnitCostLCY, true);                    AvailableQtyBase := UOMMgtUnitOfMeasureManagement.CalcBaseQty(AvailableQty, PurchRcptLine2."Qty. per Unit of Measure");                    if AvailableQtyBase >= ReturnQtyBase then                        exit(PurchRcptLine.Get(PurchRcptLine2."Document No.", PurchRcptLine2."Line No."));                until PurchRcptLine2.Next() = 0;        end;    end;    /// <summary>    /// Creates a purchase return order header for the vendor on a purchase receipt line.    /// </summary>    /// <param name="InPurchRcptLine">The purchase receipt line that supplies the vendor.</param>    /// <param name="ReturnOrderPurchaseHeader">The created purchase return order header.</param>    /// <param name="VendorCreditMemoNotMemo">The optional vendor credit memo number.</param>    local procedure CreatePurchaseReturnOrderFromPurchaseReceiptLine(var InPurchRcptLine: Record "Purch. Rcpt. Line"; var ReturnOrderPurchaseHeader: Record "Purchase Header"; VendorCreditMemoNotMemo: Code[35])    begin        ReturnOrderPurchaseHeader.Init();        ReturnOrderPurchaseHeader."Document Type" := ReturnOrderPurchaseHeader."Document Type"::"Return Order";        ReturnOrderPurchaseHeader.Validate("Buy-from Vendor No.", InPurchRcptLine."Buy-from Vendor No.");        if VendorCreditMemoNotMemo <> '' then            ReturnOrderPurchaseHeader."Vendor Cr. Memo No." := VendorCreditMemoNotMemo;        ReturnOrderPurchaseHeader.Insert(true);        if TempCreatedBufferPurchaseHeader."No." <> ReturnOrderPurchaseHeader."No." then begin            TempCreatedBufferPurchaseHeader := ReturnOrderPurchaseHeader;            TempCreatedBufferPurchaseHeader.Insert();        end;    end;    /// <summary>    /// Creates or increases a purchase return order line and assigns inspection item tracking.    /// </summary>    /// <param name="QltyInspectionHeader">The inspection that identifies the item, variant, and tracking values.</param>    /// <param name="TempQuantityToActQltyDispositionBuffer">The return quantity and optional reason code.</param>    /// <param name="PurchRcptLine">The purchase receipt line copied to the return order.</param>    /// <param name="ReturnOrderPurchaseHeader">The purchase return order receiving the line.</param>    local procedure CreatePurchaseReturnOrderLine(var QltyInspectionHeader: Record "Qlty. Inspection Header"; var TempQuantityToActQltyDispositionBuffer: Record "Qlty. Disposition Buffer" temporary; var PurchRcptLine: Record "Purch. Rcpt. Line"; var ReturnOrderPurchaseHeader: Record "Purchase Header")    var        ReturnOrderPurchaseLine: Record "Purchase Line";        Item: Record Item;        DocCopyDocumentMgt: Codeunit "Copy Document Mgt.";        UOMMgtUnitOfMeasureManagement: Codeunit "Unit of Measure Management";        QltyItemTrackingMgmt: Codeunit "Qlty. Item Tracking Mgmt.";        UnusedLinesNotCopied: Integer;        QtyPerUOM: Decimal;        QtyToReturn: Decimal;        UnusedMissingExCostRevLink: Boolean;        ExistingLine: Boolean;        ItemTracking: Boolean;        IsHandled: Boolean;    begin        Item.Get(QltyInspectionHeader."Source Item No.");        ItemTracking := QltyInspectionHeader.IsItemTrackingUsed();        ReturnOrderPurchaseLine.SetRange("Document Type", ReturnOrderPurchaseLine."Document Type"::"Return Order");        ReturnOrderPurchaseLine.SetRange("Document No.", ReturnOrderPurchaseHeader."No.");        ReturnOrderPurchaseLine.SetRange(Type, ReturnOrderPurchaseLine.Type::Item);        ReturnOrderPurchaseLine.SetRange("No.", QltyInspectionHeader."Source Item No.");        ReturnOrderPurchaseLine.SetRange("Variant Code", QltyInspectionHeader."Source Variant Code");        if ReturnOrderPurchaseLine.FindFirst() then            ExistingLine := true;        OnBeforeCreateOrUpdatePurchaseReturnOrderLine(QltyInspectionHeader, TempQuantityToActQltyDispositionBuffer, PurchRcptLine, ReturnOrderPurchaseHeader, ReturnOrderPurchaseLine, IsHandled);        if IsHandled then            exit;        if not ExistingLine then begin            if not GuiAllowed() then                DocCopyDocumentMgt.SetHideProcessWindow(true);            PurchRcptLine.SetRecFilter();            DocCopyDocumentMgt.CopyPurchRcptLinesToDoc(ReturnOrderPurchaseHeader, PurchRcptLine, UnusedLinesNotCopied, UnusedMissingExCostRevLink);            if ReturnOrderPurchaseLine.FindFirst() then begin                QtyPerUOM := UOMMgtUnitOfMeasureManagement.GetQtyPerUnitOfMeasure(Item, ReturnOrderPurchaseLine."Unit of Measure Code");                QtyToReturn := UOMMgtUnitOfMeasureManagement.CalcQtyFromBase(                    TempQuantityToActQltyDispositionBuffer."Qty. To Handle (Base)",                    QtyPerUOM);                if ItemTracking then                    QltyItemTrackingMgmt.DeleteAndRecreatePurchaseReturnOrderLineTracking(QltyInspectionHeader, ReturnOrderPurchaseLine, QtyToReturn);                if ReturnOrderPurchaseLine.Quantity <> QtyToReturn then                    ReturnOrderPurchaseLine.Validate(Quantity, QtyToReturn);                if TempQuantityToActQltyDispositionBuffer."Reason Code" <> '' then                    ReturnOrderPurchaseLine.Validate("Return Reason Code", TempQuantityToActQltyDispositionBuffer."Reason Code");                ReturnOrderPurchaseLine.Modify(true);            end;        end else begin            QtyPerUOM := UOMMgtUnitOfMeasureManagement.GetQtyPerUnitOfMeasure(Item, ReturnOrderPurchaseLine."Unit of Measure Code");            QtyToReturn := UOMMgtUnitOfMeasureManagement.CalcQtyFromBase(TempQuantityToActQltyDispositionBuffer."Qty. To Handle (Base)", QtyPerUOM);            QtyToReturn := QtyToReturn + ReturnOrderPurchaseLine.Quantity;            if ItemTracking then                QltyItemTrackingMgmt.DeleteAndRecreatePurchaseReturnOrderLineTracking(QltyInspectionHeader, ReturnOrderPurchaseLine, QtyToReturn);            ReturnOrderPurchaseLine.Validate(Quantity, QtyToReturn);            ReturnOrderPurchaseLine.Modify(true);        end;        OnAfterCreateOrUpdatePurchaseReturnOrderLine(QltyInspectionHeader, TempQuantityToActQltyDispositionBuffer, PurchRcptLine, ReturnOrderPurchaseHeader, ReturnOrderPurchaseLine);    end;    /// <summary>    /// Gets the created purchase return headers that were created as buffer tables.    /// </summary>    /// <param name="TempCreatedBufferPurchaseHeader2">The temporary record populated with created purchase return headers.</param>    internal procedure GetCreatedPurchaseReturnBuffer(var TempCreatedBufferPurchaseHeader2: Record "Purchase Header" temporary)    begin        TempCreatedBufferPurchaseHeader2.Copy(TempCreatedBufferPurchaseHeader, true);    end;    /// <summary>    /// Provides an opportunity to modify the create Purchase Return Order behavior or replace it completely.    /// </summary>    /// <param name="QltyInspectionHeader">The inspection being processed.</param>    /// <param name="TempInstructionQltyDispositionBuffer">The disposition instructions.</param>    /// <param name="DidSomething">Indicates whether a purchase return was created.</param>    /// <param name="IsHandled">Set to true to skip the default purchase return processing.</param>    [IntegrationEvent(false, false)]    procedure OnBeforeProcessDisposition(var QltyInspectionHeader: Record "Qlty. Inspection Header"; var TempInstructionQltyDispositionBuffer: Record "Qlty. Disposition Buffer" temporary; var DidSomething: Boolean; var IsHandled: Boolean)    begin    end;    /// <summary>    /// Occurs after the purchase return order and its lines are processed.    /// </summary>    /// <param name="QltyInspectionHeader">The inspection that was processed.</param>    /// <param name="TempInstructionQltyDispositionBuffer">The disposition instructions.</param>    /// <param name="CreatedReturnOrderPurchaseHeader">The created purchase return order header.</param>    /// <param name="DidSomething">Indicates whether a purchase return was created.</param>    [IntegrationEvent(false, false)]    procedure OnAfterProcessDisposition(var QltyInspectionHeader: Record "Qlty. Inspection Header"; var TempInstructionQltyDispositionBuffer: Record "Qlty. Disposition Buffer" temporary; var CreatedReturnOrderPurchaseHeader: Record "Purchase Header"; var DidSomething: Boolean)    begin    end;    /// <summary>    /// Occurs before a purchase return order line is created or updated and can replace the default handling.    /// </summary>    /// <param name="QltyInspectionHeader">The inspection that identifies the returned inventory.</param>    /// <param name="TempQuantityToActQltyDispositionBuffer">The return quantity and optional reason code.</param>    /// <param name="PurchRcptLine">The original purchase receipt line.</param>    /// <param name="ReturnOrderPurchaseHeader">The purchase return order header.</param>    /// <param name="ReturnOrderPurchaseLine">The new or existing purchase return order line.</param>    /// <param name="IsHandled">Set to true to skip the default line creation or update.</param>    [IntegrationEvent(false, false)]    procedure OnBeforeCreateOrUpdatePurchaseReturnOrderLine(var QltyInspectionHeader: Record "Qlty. Inspection Header"; var TempQuantityToActQltyDispositionBuffer: Record "Qlty. Disposition Buffer" temporary; var PurchRcptLine: Record "Purch. Rcpt. Line"; var ReturnOrderPurchaseHeader: Record "Purchase Header"; var ReturnOrderPurchaseLine: Record "Purchase Line"; var IsHandled: Boolean)    begin    end;    /// <summary>    /// Occurs after a purchase return order line is created or updated.    /// </summary>    /// <param name="QltyInspectionHeader">The inspection that identifies the returned inventory.</param>    /// <param name="TempQuantityToActQltyDispositionBuffer">The return quantity and optional reason code.</param>    /// <param name="PurchRcptLine">The original purchase receipt line.</param>    /// <param name="ReturnOrderPurchaseHeader">The purchase return order header.</param>    /// <param name="ReturnOrderPurchaseLine">The new or existing purchase return order line.</param>    [IntegrationEvent(false, false)]    procedure OnAfterCreateOrUpdatePurchaseReturnOrderLine(var QltyInspectionHeader: Record "Qlty. Inspection Header"; var TempQuantityToActQltyDispositionBuffer: Record "Qlty. Disposition Buffer" temporary; var PurchRcptLine: Record "Purch. Rcpt. Line"; var ReturnOrderPurchaseHeader: Record "Purchase Header"; var ReturnOrderPurchaseLine: Record "Purchase Line")    begin    end;}