Codeunit 6648 Purch.-Get Return Shipments
src/Layers/W1/BaseApp/Purchases/Document/PurchGetReturnShipments.Codeunit.al366 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.Purchases.Document;using Microsoft.Foundation.Attachment;using Microsoft.Foundation.UOM;using Microsoft.Purchases.History;codeunit 6648 "Purch.-Get Return Shipments"{ TableNo = "Purchase Line"; trigger OnRun() begin CheckHeader(Rec); ReturnShptLine.SetCurrentKey("Pay-to Vendor No."); ReturnShptLine.SetRange("Pay-to Vendor No.", PurchHeader."Pay-to Vendor No."); ReturnShptLine.SetFilter("Return Qty. Shipped Not Invd.", '<>0'); ReturnShptLine.SetRange("Currency Code", PurchHeader."Currency Code"); OnRunOnAfterSetReturnShptLineFilters(ReturnShptLine, PurchHeader); GetReturnShptLines.SetTableView(ReturnShptLine); GetReturnShptLines.LookupMode := true; GetReturnShptLines.SetPurchHeader(PurchHeader); GetReturnShptLines.RunModal(); end; var#pragma warning disable AA0074#pragma warning disable AA0470 Text000: Label 'The %1 on the %2 %3 and the %4 %5 must be the same.';#pragma warning restore AA0470#pragma warning restore AA0074 PurchHeader: Record "Purchase Header"; PurchLine: Record "Purchase Line"; ReturnShptHeader: Record "Return Shipment Header"; ReturnShptLine: Record "Return Shipment Line"; UOMMgt: Codeunit "Unit of Measure Management"; GetReturnShptLines: Page "Get Return Shipment Lines"; LineListHasAttachments: Dictionary of [Code[20], Boolean]; procedure CreateInvLines(var ReturnShptLine2: Record "Return Shipment Line") var DifferentCurrencies: Boolean; ShouldInsertReturnRcptLine: Boolean; OrderNoList: List of [Code[20]]; begin ReturnShptLine2.SetFilter("Return Qty. Shipped Not Invd.", '<>0'); OnCreateInvLinesOnAfterReturnShptLine2SetFilters(ReturnShptLine2, PurchHeader); if ReturnShptLine2.Find('-') then begin PurchLine.LockTable(); PurchLine.SetRange("Document Type", PurchHeader."Document Type"); PurchLine.SetRange("Document No.", PurchHeader."No."); PurchLine."Document Type" := PurchHeader."Document Type"; PurchLine."Document No." := PurchHeader."No."; repeat if ReturnShptHeader."No." <> ReturnShptLine2."Document No." then begin ReturnShptHeader.Get(ReturnShptLine2."Document No."); CheckReturnShptPayToVendorNo(ReturnShptHeader, PurchHeader, ReturnShptLine2); DifferentCurrencies := false; if ReturnShptHeader."Currency Code" <> PurchHeader."Currency Code" then begin Message(Text000, PurchHeader.FieldCaption("Currency Code"), PurchHeader.TableCaption(), PurchHeader."No.", ReturnShptHeader.TableCaption(), ReturnShptHeader."No."); DifferentCurrencies := true; end; OnBeforeTransferLineToPurchaseDoc(ReturnShptHeader, ReturnShptLine2, PurchHeader, DifferentCurrencies); end; ShouldInsertReturnRcptLine := not DifferentCurrencies; OnCreateInvLinesOnAfterCalcShouldInsertReturnRcptLine(ReturnShptHeader, ReturnShptLine2, PurchHeader, ShouldInsertReturnRcptLine, PurchLine); if ShouldInsertReturnRcptLine then begin ReturnShptLine := ReturnShptLine2; CheckReturnShipmentLineVATBusPostingGroup(ReturnShptLine, PurchHeader); ReturnShptLine.InsertInvLineFromRetShptLine(PurchLine); CopyDocumentAttachments(ReturnShptLine2, PurchLine); if ReturnShptLine2.Type = ReturnShptLine2.Type::"Charge (Item)" then GetItemChargeAssgnt(ReturnShptLine2, PurchLine."Qty. to Invoice"); end; OnCreateInvLinesOnAfterLoopIteration(ReturnShptHeader, ReturnShptLine2, PurchHeader, PurchLine, ShouldInsertReturnRcptLine); if ReturnShptLine2."Return Order No." <> '' then if not OrderNoList.Contains(ReturnShptLine2."Return Order No.") then OrderNoList.Add(ReturnShptLine2."Return Order No."); until ReturnShptLine2.Next() = 0; CopyDocumentAttachments(OrderNoList, PurchHeader); end; OnAfterCreateInvLines(PurchHeader); end; local procedure CheckHeader(PurchaseLine: Record "Purchase Line") var IsHandled: Boolean; begin IsHandled := false; OnBeforeCheckHeader(PurchHeader, PurchaseLine, IsHandled); if IsHandled then exit; PurchHeader.Get(PurchaseLine."Document Type", PurchaseLine."Document No."); PurchHeader.TestField("Document Type", PurchHeader."Document Type"::"Credit Memo"); PurchHeader.TestField(Status, PurchHeader.Status::Open); end; local procedure CheckReturnShipmentLineVATBusPostingGroup(ReturnShipmentLine: Record "Return Shipment Line"; PurchaseHeader: Record "Purchase Header") var IsHandled: Boolean; begin IsHandled := false; OnBeforeCheckReturnShipmentLineVATBusPostingGroup(ReturnShipmentLine, PurchaseHeader, IsHandled); if IsHandled then exit; ReturnShipmentLine.TestField("VAT Bus. Posting Group", PurchaseHeader."VAT Bus. Posting Group"); end; local procedure CheckReturnShptPayToVendorNo(ReturnShptHeader: Record "Return Shipment Header"; PurchHeader: Record "Purchase Header"; ReturnShptLine: Record "Return Shipment Line") var IsHandled: Boolean; begin IsHandled := false; OnBeforeCheckReturnShptPayToVendorNo(ReturnShptHeader, PurchHeader, ReturnShptLine, IsHandled); if IsHandled then exit; ReturnShptHeader.TestField("Pay-to Vendor No.", PurchHeader."Pay-to Vendor No."); end; procedure SetPurchHeader(var PurchHeader2: Record "Purchase Header") var IsHandled: Boolean; begin PurchHeader.Get(PurchHeader2."Document Type", PurchHeader2."No."); IsHandled := false; OnSetPurchHeaderOnBegoreTestIsCreditMemo(PurchHeader, IsHandled); if not IsHandled then PurchHeader.TestField("Document Type", PurchHeader."Document Type"::"Credit Memo"); end; procedure GetItemChargeAssgnt(var ReturnShptLine: Record "Return Shipment Line"; QtyToInv: Decimal) var PurchOrderLine: Record "Purchase Line"; ItemChargeAssgntPurch: Record "Item Charge Assignment (Purch)"; begin if not PurchOrderLine.Get(PurchOrderLine."Document Type"::"Return Order", ReturnShptLine."Return Order No.", ReturnShptLine."Return Order Line No.") then exit; ItemChargeAssgntPurch.LockTable(); ItemChargeAssgntPurch.Reset(); ItemChargeAssgntPurch.SetRange("Document Type", PurchOrderLine."Document Type"); ItemChargeAssgntPurch.SetRange("Document No.", PurchOrderLine."Document No."); ItemChargeAssgntPurch.SetRange("Document Line No.", PurchOrderLine."Line No."); ItemChargeAssgntPurch.CalcSums("Qty. to Assign"); if ItemChargeAssgntPurch."Qty. to Assign" <> 0 then CopyItemChargeAssgnt( PurchOrderLine, ReturnShptLine, ItemChargeAssgntPurch."Qty. to Assign", QtyToInv / ItemChargeAssgntPurch."Qty. to Assign"); end; local procedure CopyItemChargeAssgnt(PurchOrderLine: Record "Purchase Line"; ReturnShptLine: Record "Return Shipment Line"; QtyToAssign: Decimal; QtyFactor: Decimal) var ReturnShptLine2: Record "Return Shipment Line"; PurchLine2: Record "Purchase Line"; ItemChargeAssgntPurch: Record "Item Charge Assignment (Purch)"; ItemChargeAssgntPurch2: Record "Item Charge Assignment (Purch)"; InsertChargeAssgnt: Boolean; begin ItemChargeAssgntPurch.SetRange("Document Type", PurchOrderLine."Document Type"); ItemChargeAssgntPurch.SetRange("Document No.", PurchOrderLine."Document No."); ItemChargeAssgntPurch.SetRange("Document Line No.", PurchOrderLine."Line No."); if ItemChargeAssgntPurch.FindSet() then repeat if ItemChargeAssgntPurch."Qty. to Assign" <> 0 then begin ItemChargeAssgntPurch2 := ItemChargeAssgntPurch; ItemChargeAssgntPurch2."Qty. to Assign" := Round(QtyFactor * ItemChargeAssgntPurch2."Qty. to Assign", UOMMgt.QtyRndPrecision()); PurchLine2.SetRange("Return Shipment No.", ReturnShptLine."Document No."); PurchLine2.SetRange("Return Shipment Line No.", ReturnShptLine."Line No."); PurchLine2.SetAutoCalcFields("Qty. to Assign"); if PurchLine2.Find('-') then repeat InsertChargeAssgnt := PurchLine2."Qty. to Assign" <> PurchLine2.Quantity; until (PurchLine2.Next() = 0) or InsertChargeAssgnt; if InsertChargeAssgnt then begin ItemChargeAssgntPurch2."Document Type" := PurchLine2."Document Type"; ItemChargeAssgntPurch2."Document No." := PurchLine2."Document No."; ItemChargeAssgntPurch2."Document Line No." := PurchLine2."Line No."; ItemChargeAssgntPurch2."Qty. Assigned" := 0; if Abs(QtyToAssign) < Abs(ItemChargeAssgntPurch2."Qty. to Assign") then ItemChargeAssgntPurch2."Qty. to Assign" := QtyToAssign; if Abs(PurchLine2.Quantity - PurchLine2."Qty. to Assign") < Abs(ItemChargeAssgntPurch2."Qty. to Assign") then ItemChargeAssgntPurch2."Qty. to Assign" := PurchLine2.Quantity - PurchLine2."Qty. to Assign"; ItemChargeAssgntPurch2.Validate("Unit Cost"); if ItemChargeAssgntPurch2."Applies-to Doc. Type" = PurchOrderLine."Document Type" then begin ItemChargeAssgntPurch2."Applies-to Doc. Type" := PurchLine2."Document Type"; ItemChargeAssgntPurch2."Applies-to Doc. No." := PurchLine2."Document No."; ReturnShptLine2.SetCurrentKey("Return Order No.", "Return Order Line No."); ReturnShptLine2.SetRange("Return Order No.", ItemChargeAssgntPurch."Applies-to Doc. No."); ReturnShptLine2.SetRange("Return Order Line No.", ItemChargeAssgntPurch."Applies-to Doc. Line No."); ReturnShptLine2.SetFilter(Quantity, '<>0'); if ReturnShptLine2.FindFirst() then begin PurchLine2.SetCurrentKey("Document Type", "Receipt No.", "Receipt Line No."); PurchLine2.SetRange("Document Type", PurchLine2."Document Type"::"Credit Memo"); PurchLine2.SetRange("Return Shipment No.", ReturnShptLine2."Document No."); PurchLine2.SetRange("Return Shipment Line No.", ReturnShptLine2."Line No."); OnCopyItemChargeAssgntOnBeforeFindPurchLine2(PurchLine2, ItemChargeAssgntPurch2); if PurchLine2.FindFirst() and (PurchLine2.Quantity <> 0) then begin OnCopyItemChargeAssgntOnAfterFindPurchLine2(PurchLine2, ItemChargeAssgntPurch2); ItemChargeAssgntPurch2."Applies-to Doc. Line No." := PurchLine2."Line No." end else InsertChargeAssgnt := false; end else InsertChargeAssgnt := false; end; end; if InsertChargeAssgnt and (ItemChargeAssgntPurch2."Qty. to Assign" <> 0) then begin ItemChargeAssgntPurch2.Insert(); QtyToAssign := QtyToAssign - ItemChargeAssgntPurch2."Qty. to Assign"; end; end; until ItemChargeAssgntPurch.Next() = 0; end; procedure GetPurchRetOrderCrMemos(var TempPurchCrMemoHdr: Record "Purch. Cr. Memo Hdr." temporary; ReturnOrderNo: Code[20]) var PurchCrMemoHdr: Record "Purch. Cr. Memo Hdr."; PurchCrMemosByRetOrder: Query "Purch. Cr. Memos By Ret. Order"; begin TempPurchCrMemoHdr.Reset(); TempPurchCrMemoHdr.DeleteAll(); PurchCrMemosByRetOrder.SetRange(Order_No_, ReturnOrderNo); PurchCrMemosByRetOrder.SetFilter(Quantity, '<>0'); PurchCrMemosByRetOrder.Open(); while PurchCrMemosByRetOrder.Read() do begin PurchCrMemoHdr.Get(PurchCrMemosByRetOrder.Document_No_); TempPurchCrMemoHdr := PurchCrMemoHdr; TempPurchCrMemoHdr.Insert(); end; end; local procedure AnyLineHasAttachments(DocNo: Code[20]): boolean begin if not LineListHasAttachments.ContainsKey(DocNo) then LineListHasAttachments.Add(DocNo, EntityHasAttachments(DocNo, Database::"Purchase Line")); exit(LineListHasAttachments.Get(DocNo)); end; local procedure EntityHasAttachments(DocNo: Code[20]; TableNo: Integer): boolean var DocumentAttachment: Record "Document Attachment"; begin DocumentAttachment.ReadIsolation := IsolationLevel::ReadUncommitted; DocumentAttachment.SetRange("Table ID", TableNo); DocumentAttachment.SetRange("Document Type", DocumentAttachment."Document Type"::"Return Order"); DocumentAttachment.SetRange("No.", DocNo); exit(not DocumentAttachment.IsEmpty()); end; local procedure CopyDocumentAttachments(OrderNoList: List of [Code[20]]; var PurchaseHeader: Record "Purchase Header") var OrderPurchaseHeader: Record "Purchase Header"; DocumentAttachmentMgmt: Codeunit "Document Attachment Mgmt"; OrderNo: Code[20]; begin OrderPurchaseHeader.ReadIsolation := IsolationLevel::ReadCommitted; OrderPurchaseHeader.SetLoadFields("Document Type", "No."); foreach OrderNo in OrderNoList do if OrderHasAttachments(OrderNo) then if OrderPurchaseHeader.Get(OrderPurchaseHeader."Document Type"::"Return Order", OrderNo) then DocumentAttachmentMgmt.CopyAttachments(OrderPurchaseHeader, PurchaseHeader); end; local procedure CopyDocumentAttachments(var ReturnShptLine2: Record "Return Shipment Line"; var PurchaseLine: Record "Purchase Line") var OrderPurchaseLine: Record "Purchase Line"; DocumentAttachmentMgmt: Codeunit "Document Attachment Mgmt"; begin if (ReturnShptLine2."Return Order No." = '') or (ReturnShptLine2."Return Order Line No." = 0) then exit; if not AnyLineHasAttachments(ReturnShptLine2."Return Order No.") then exit; OrderPurchaseLine.ReadIsolation := IsolationLevel::ReadCommitted; OrderPurchaseLine.SetLoadFields("Document Type", "Document No.", "Line No."); if OrderPurchaseLine.Get(OrderPurchaseLine."Document Type"::"Return Order", ReturnShptLine2."Return Order No.", ReturnShptLine2."Return Order Line No.") then DocumentAttachmentMgmt.CopyAttachments(OrderPurchaseLine, PurchaseLine); end; local procedure OrderHasAttachments(DocNo: Code[20]): boolean begin exit(EntityHasAttachments(DocNo, Database::"Purchase Header")); end; [IntegrationEvent(false, false)] local procedure OnAfterCreateInvLines(PurchaseHeader: Record "Purchase Header") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeCheckHeader(var PurchaseHeader: Record "Purchase Header"; PurchaseLine: Record "Purchase Line"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeCheckReturnShptPayToVendorNo(ReturnShipmentHeader: Record "Return Shipment Header"; PurchaseHeader: Record "Purchase Header"; ReturnShipmentLine: Record "Return Shipment Line"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeTransferLineToPurchaseDoc(ReturnShipmentHeader: Record "Return Shipment Header"; ReturnShipmentLine: Record "Return Shipment Line"; var PurchaseHeader: Record "Purchase Header"; var TransferLine: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnCreateInvLinesOnAfterCalcShouldInsertReturnRcptLine(var ReturnShipmentHeader: Record "Return Shipment Header"; var ReturnShipmentLine: Record "Return Shipment Line"; var PurchaseHeader: Record "Purchase Header"; var ShouldInsertReturnRcptLine: Boolean; PurchLine: Record "Purchase Line") begin end; [IntegrationEvent(false, false)] local procedure OnCreateInvLinesOnAfterReturnShptLine2SetFilters(var ReturnShipmentLine: Record "Return Shipment Line"; var PurchaseHeader: Record "Purchase Header") begin end; [IntegrationEvent(false, false)] local procedure OnCreateInvLinesOnAfterLoopIteration(ReturnShipmentHeader: Record "Return Shipment Header"; ReturnShipmentLine2: Record "Return Shipment Line"; PurchaseHeader: Record "Purchase Header"; PurchaseLine: Record "Purchase Line"; ShouldInsertReturnRcptLine: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnRunOnAfterSetReturnShptLineFilters(var ReturnShipmentLine: Record "Return Shipment Line"; PurchaseHeader: Record "Purchase Header") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeCheckReturnShipmentLineVATBusPostingGroup(ReturnShipmentLine: Record "Return Shipment Line"; PurchaseHeader: Record "Purchase Header"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnCopyItemChargeAssgntOnAfterFindPurchLine2(var PurchLine2: Record "Purchase Line"; var ItemChargeAssgntPurch2: Record "Item Charge Assignment (Purch)"); begin end; [IntegrationEvent(false, false)] local procedure OnCopyItemChargeAssgntOnBeforeFindPurchLine2(var PurchLine2: Record "Purchase Line"; var ItemChargeAssgntPurch2: Record "Item Charge Assignment (Purch)"); begin end; [IntegrationEvent(false, false)] local procedure OnSetPurchHeaderOnBegoreTestIsCreditMemo(var PurchaseHeader: Record "Purchase Header"; var IsHandled: Boolean) begin end;}