Codeunit 6638 Sales-Get Return Receipts
src/Layers/W1/BaseApp/Sales/Document/SalesGetReturnReceipts.Codeunit.al399 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.Sales.Document;using Microsoft.Foundation.Attachment;using Microsoft.Foundation.UOM;using Microsoft.Sales.History;/// <summary>/// Retrieves return receipt lines to create credit memo lines for invoicing returned goods./// </summary>codeunit 6638 "Sales-Get Return Receipts"{ TableNo = "Sales Line"; trigger OnRun() var IsHandled: Boolean; begin CheckHeader(Rec); ReturnRcptLine.SetCurrentKey("Bill-to Customer No."); ReturnRcptLine.SetRange("Bill-to Customer No.", SalesHeader."Bill-to Customer No."); ReturnRcptLine.SetFilter("Return Qty. Rcd. Not Invd.", '<>0'); ReturnRcptLine.SetRange("Currency Code", SalesHeader."Currency Code"); OnRunOnAfterSetReturnRcptLineFilters(ReturnRcptLine, SalesHeader); IsHandled := false; OnRunOnBeforeGetReturnRcptLines(ReturnRcptLine, SalesHeader, IsHandled); if not IsHandled then begin GetReturnRcptLines.SetTableView(ReturnRcptLine); GetReturnRcptLines.LookupMode := true; GetReturnRcptLines.SetSalesHeader(SalesHeader); GetReturnRcptLines.RunModal(); end; end; var SalesHeader: Record "Sales Header"; SalesLine: Record "Sales Line"; ReturnRcptHeader: Record "Return Receipt Header"; ReturnRcptLine: Record "Return Receipt Line"; UOMMgt: Codeunit "Unit of Measure Management"; GetReturnRcptLines: Page "Get Return Receipt Lines"; LineListHasAttachments: Dictionary of [Code[20], Boolean];#pragma warning disable AA0074#pragma warning disable AA0470 Text001: Label 'The %1 on the %2 %3 and the %4 %5 must be the same.';#pragma warning restore AA0470#pragma warning restore AA0074 /// <summary> /// Creates credit memo lines from return receipt lines. /// </summary> /// <param name="ReturnRcptLine2">The return receipt lines to create credit memo lines from.</param> procedure CreateInvLines(var ReturnRcptLine2: Record "Return Receipt Line") var DifferentCurrencies: Boolean; ShouldInsertReturnRcptLine: Boolean; IsHandled: Boolean; OrderNoList: List of [Code[20]]; begin ReturnRcptLine2.SetFilter("Return Qty. Rcd. Not Invd.", '<>0'); OnCreateInvLinesOnAfterReturnRcptLine2SetFilters(ReturnRcptLine2, SalesHeader); if ReturnRcptLine2.Find('-') then begin SalesLine.LockTable(); SalesLine.SetRange("Document Type", SalesHeader."Document Type"); SalesLine.SetRange("Document No.", SalesHeader."No."); SalesLine."Document Type" := SalesHeader."Document Type"; SalesLine."Document No." := SalesHeader."No."; IsHandled := false; OnCreateInvLinesOnBeforeLoopReturnRcptLines(ReturnRcptLine2, SalesLine, ReturnRcptHeader, IsHandled); if IsHandled then exit; repeat if ReturnRcptHeader."No." <> ReturnRcptLine2."Document No." then begin ReturnRcptHeader.Get(ReturnRcptLine2."Document No."); CheckReturnReceiptBillToCustomerNo(ReturnRcptHeader, SalesHeader, ReturnRcptLine2); DifferentCurrencies := false; if ReturnRcptHeader."Currency Code" <> SalesHeader."Currency Code" then begin Message(Text001, SalesHeader.FieldCaption("Currency Code"), SalesHeader.TableCaption, SalesHeader."No.", ReturnRcptHeader.TableCaption(), ReturnRcptHeader."No."); DifferentCurrencies := true; end; OnBeforeTransferLineToSalesDoc(ReturnRcptHeader, ReturnRcptLine2, SalesHeader, DifferentCurrencies); end; ShouldInsertReturnRcptLine := not DifferentCurrencies; OnCreateInvLinesOnAfterCalcShouldInsertReturnRcptLine(ReturnRcptHeader, ReturnRcptLine2, SalesHeader, ShouldInsertReturnRcptLine); if ShouldInsertReturnRcptLine then begin ReturnRcptLine := ReturnRcptLine2; CheckReturnReceiptLineVATBusPostingGroup(ReturnRcptLine2, SalesHeader); ReturnRcptLine.InsertInvLineFromRetRcptLine(SalesLine); CopyDocumentAttachments(ReturnRcptLine2, SalesLine); if ReturnRcptLine2.Type = ReturnRcptLine2.Type::"Charge (Item)" then GetItemChargeAssgnt(ReturnRcptLine2, SalesLine."Qty. to Invoice"); end; OnCreateInvLinesOnAfterReturnRcptLoop(ShouldInsertReturnRcptLine, ReturnRcptHeader, ReturnRcptLine2, SalesHeader, SalesLine); if ReturnRcptLine2."Return Order No." <> '' then if not OrderNoList.Contains(ReturnRcptLine2."Return Order No.") then OrderNoList.Add(ReturnRcptLine2."Return Order No."); until ReturnRcptLine2.Next() = 0; CopyDocumentAttachments(OrderNoList, SalesHeader); end; OnAfterCreateInvLines(SalesHeader); end; local procedure CheckReturnReceiptLineVATBusPostingGroup(ReturnReceiptLine: Record "Return Receipt Line"; SalesHeader: Record "Sales Header") var IsHandled: Boolean; begin IsHandled := false; OnBeforeTestReturnReceiptLineVATBusPostingGroup(ReturnReceiptLine, SalesHeader, IsHandled); if IsHandled then exit; ReturnReceiptLine.TestField("VAT Bus. Posting Group", SalesHeader."VAT Bus. Posting Group"); end; /// <summary> /// Sets the sales header for which to get return receipts. /// </summary> /// <param name="SalesHeader2">The sales credit memo header.</param> procedure SetSalesHeader(var SalesHeader2: Record "Sales Header") var IsHandled: Boolean; begin IsHandled := false; OnSetSalesHeaderOnBeforeTestIsCreditMemo(SalesHeader, IsHandled); if not IsHandled then begin SalesHeader.Get(SalesHeader2."Document Type", SalesHeader2."No."); SalesHeader.TestField("Document Type", SalesHeader."Document Type"::"Credit Memo"); end; end; local procedure CheckHeader(SalesLine: Record "Sales Line") var IsHandled: Boolean; begin IsHandled := false; OnBeforeCheckHeader(SalesHeader, SalesLine, IsHandled); if IsHandled then exit; SalesHeader.Get(SalesLine."Document Type", SalesLine."Document No."); SalesHeader.TestField("Document Type", SalesHeader."Document Type"::"Credit Memo"); SalesHeader.TestField(Status, SalesHeader.Status::Open); end; local procedure CheckReturnReceiptBillToCustomerNo(ReturnReceiptHeader: Record "Return Receipt Header"; SalesHeader2: Record "Sales Header"; ReturnReceiptLine: Record "Return Receipt Line") var IsHandled: Boolean; begin IsHandled := false; OnBeforeCheckReturnReceiptBillToCustomerNo(ReturnReceiptHeader, SalesHeader2, ReturnReceiptLine, IsHandled); if IsHandled then exit; ReturnReceiptHeader.TestField("Bill-to Customer No.", ReturnReceiptLine."Bill-to Customer No."); end; /// <summary> /// Gets item charge assignments from the return receipt line. /// </summary> /// <param name="ReturnRcptLine">The return receipt line with item charges.</param> /// <param name="QtyToInv">The quantity to invoice.</param> procedure GetItemChargeAssgnt(var ReturnRcptLine: Record "Return Receipt Line"; QtyToInv: Decimal) var SalesOrderLine: Record "Sales Line"; ItemChargeAssgntSales: Record "Item Charge Assignment (Sales)"; begin if not SalesOrderLine.Get(SalesOrderLine."Document Type"::"Return Order", ReturnRcptLine."Return Order No.", ReturnRcptLine."Return Order Line No.") then exit; ItemChargeAssgntSales.LockTable(); ItemChargeAssgntSales.Reset(); ItemChargeAssgntSales.SetRange("Document Type", SalesOrderLine."Document Type"); ItemChargeAssgntSales.SetRange("Document No.", SalesOrderLine."Document No."); ItemChargeAssgntSales.SetRange("Document Line No.", SalesOrderLine."Line No."); ItemChargeAssgntSales.CalcSums("Qty. to Assign"); if ItemChargeAssgntSales."Qty. to Assign" <> 0 then CopyItemChargeAssgnt( SalesOrderLine, ReturnRcptLine, ItemChargeAssgntSales."Qty. to Assign", QtyToInv / ItemChargeAssgntSales."Qty. to Assign"); end; local procedure CopyItemChargeAssgnt(SalesOrderLine: Record "Sales Line"; ReturnRcptLine: Record "Return Receipt Line"; QtyToAssign: Decimal; QtyFactor: Decimal) var ReturnRcptLine2: Record "Return Receipt Line"; SalesLine2: Record "Sales Line"; ItemChargeAssgntSales: Record "Item Charge Assignment (Sales)"; ItemChargeAssgntSales2: Record "Item Charge Assignment (Sales)"; InsertChargeAssgnt: Boolean; begin ItemChargeAssgntSales.SetRange("Document Type", SalesOrderLine."Document Type"); ItemChargeAssgntSales.SetRange("Document No.", SalesOrderLine."Document No."); ItemChargeAssgntSales.SetRange("Document Line No.", SalesOrderLine."Line No."); if ItemChargeAssgntSales.FindSet() then repeat if ItemChargeAssgntSales."Qty. to Assign" <> 0 then begin ItemChargeAssgntSales2 := ItemChargeAssgntSales; ItemChargeAssgntSales2."Qty. to Assign" := Round(QtyFactor * ItemChargeAssgntSales2."Qty. to Assign", UOMMgt.QtyRndPrecision()); SalesLine2.SetRange("Return Receipt No.", ReturnRcptLine."Document No."); SalesLine2.SetRange("Return Receipt Line No.", ReturnRcptLine."Line No."); SalesLine2.SetAutoCalcFields("Qty. to Assign"); if SalesLine2.Find('-') then repeat InsertChargeAssgnt := SalesLine2."Qty. to Assign" <> SalesLine2.Quantity; until (SalesLine2.Next() = 0) or InsertChargeAssgnt; if InsertChargeAssgnt then begin ItemChargeAssgntSales2."Document Type" := SalesLine2."Document Type"; ItemChargeAssgntSales2."Document No." := SalesLine2."Document No."; ItemChargeAssgntSales2."Document Line No." := SalesLine2."Line No."; ItemChargeAssgntSales2."Qty. Assigned" := 0; if Abs(QtyToAssign) < Abs(ItemChargeAssgntSales2."Qty. to Assign") then ItemChargeAssgntSales2."Qty. to Assign" := QtyToAssign; if Abs(SalesLine2.Quantity - SalesLine2."Qty. to Assign") < Abs(ItemChargeAssgntSales2."Qty. to Assign") then ItemChargeAssgntSales2."Qty. to Assign" := SalesLine2.Quantity - SalesLine2."Qty. to Assign"; ItemChargeAssgntSales2.Validate("Unit Cost"); if ItemChargeAssgntSales2."Applies-to Doc. Type" = SalesOrderLine."Document Type" then begin ItemChargeAssgntSales2."Applies-to Doc. Type" := SalesLine2."Document Type"; ItemChargeAssgntSales2."Applies-to Doc. No." := SalesLine2."Document No."; ReturnRcptLine2.SetCurrentKey("Return Order No.", "Return Order Line No."); ReturnRcptLine2.SetRange("Return Order No.", ItemChargeAssgntSales."Applies-to Doc. No."); ReturnRcptLine2.SetRange("Return Order Line No.", ItemChargeAssgntSales."Applies-to Doc. Line No."); ReturnRcptLine2.SetFilter(Quantity, '<>0'); if ReturnRcptLine2.FindFirst() then begin SalesLine2.SetCurrentKey("Document Type", "Shipment No.", "Shipment Line No."); SalesLine2.SetRange("Document Type", SalesOrderLine."Document Type"::"Credit Memo"); SalesLine2.SetRange("Return Receipt No.", ReturnRcptLine2."Document No."); SalesLine2.SetRange("Return Receipt Line No.", ReturnRcptLine2."Line No."); if SalesLine2.FindFirst() and (SalesLine2.Quantity <> 0) then ItemChargeAssgntSales2."Applies-to Doc. Line No." := SalesLine2."Line No." else InsertChargeAssgnt := false; end else InsertChargeAssgnt := false; end; end; if InsertChargeAssgnt and (ItemChargeAssgntSales2."Qty. to Assign" <> 0) then begin ItemChargeAssgntSales2.Insert(); QtyToAssign := QtyToAssign - ItemChargeAssgntSales2."Qty. to Assign"; end; end; until ItemChargeAssgntSales.Next() = 0; end; /// <summary> /// Gets posted sales credit memos related to a return order. /// </summary> /// <param name="TempSalesCrMemoHeader">Returns the temporary table with related credit memo headers.</param> /// <param name="ReturnOrderNo">The return order number to find credit memos for.</param> procedure GetSalesRetOrderCrMemos(var TempSalesCrMemoHeader: Record "Sales Cr.Memo Header" temporary; ReturnOrderNo: Code[20]) var SalesCrMemoHeader: Record "Sales Cr.Memo Header"; SalesCrMemosByRetOrder: Query "Sales Cr. Memos By Ret. Order"; begin TempSalesCrMemoHeader.Reset(); TempSalesCrMemoHeader.DeleteAll(); SalesCrMemosByRetOrder.SetRange(Order_No_, ReturnOrderNo); SalesCrMemosByRetOrder.SetFilter(Quantity, '<>0'); SalesCrMemosByRetOrder.Open(); while SalesCrMemosByRetOrder.Read() do begin SalesCrMemoHeader.Get(SalesCrMemosByRetOrder.Document_No_); TempSalesCrMemoHeader := SalesCrMemoHeader; TempSalesCrMemoHeader.Insert(); end; end; local procedure AnyLineHasAttachments(DocNo: Code[20]): boolean begin if not LineListHasAttachments.ContainsKey(DocNo) then LineListHasAttachments.Add(DocNo, EntityHasAttachments(DocNo, Database::"Sales 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(var ReturnRcptLine2: Record "Return Receipt Line"; var SalesLine2: Record "Sales Line") var OrderSalesLine: Record "Sales Line"; DocumentAttachmentMgmt: Codeunit "Document Attachment Mgmt"; begin if (ReturnRcptLine2."Return Order No." = '') or (ReturnRcptLine2."Return Order Line No." = 0) then exit; if not AnyLineHasAttachments(ReturnRcptLine2."Return Order No.") then exit; OrderSalesLine.ReadIsolation := IsolationLevel::ReadCommitted; OrderSalesLine.SetLoadFields("Document Type", "Document No.", "Line No."); if OrderSalesLine.Get(OrderSalesLine."Document Type"::"Return Order", ReturnRcptLine2."Return Order No.", ReturnRcptLine2."Return Order Line No.") then DocumentAttachmentMgmt.CopyAttachments(OrderSalesLine, SalesLine2); end; local procedure CopyDocumentAttachments(OrderNoList: List of [Code[20]]; var SalesHeader2: Record "Sales Header") var OrderSalesHeader: Record "Sales Header"; DocumentAttachmentMgmt: Codeunit "Document Attachment Mgmt"; OrderNo: Code[20]; begin OrderSalesHeader.ReadIsolation := IsolationLevel::ReadCommitted; OrderSalesHeader.SetLoadFields("Document Type", "No."); foreach OrderNo in OrderNoList do if OrderHasAttachments(OrderNo) then if OrderSalesHeader.Get(OrderSalesHeader."Document Type"::"Return Order", OrderNo) then DocumentAttachmentMgmt.CopyAttachments(OrderSalesHeader, SalesHeader2); end; local procedure OrderHasAttachments(DocNo: Code[20]): boolean begin exit(EntityHasAttachments(DocNo, Database::"Sales Header")); end; [IntegrationEvent(false, false)] local procedure OnAfterCreateInvLines(var SalesHeader: Record "Sales Header") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeTransferLineToSalesDoc(ReturnReceiptHeader: Record "Return Receipt Header"; ReturnReceiptLine: Record "Return Receipt Line"; var SalesHeader: Record "Sales Header"; var TransferLine: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnCreateInvLinesOnAfterCalcShouldInsertReturnRcptLine(var ReturnReceiptHeader: Record "Return Receipt Header"; var ReturnReceiptLine: Record "Return Receipt Line"; var SalesHeader: Record "Sales Header"; var ShouldInsertReturnRcptLine: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnCreateInvLinesOnAfterReturnRcptLine2SetFilters(var ReturnReceiptLine: Record "Return Receipt Line"; var SalesHeader: Record "Sales Header") begin end; [IntegrationEvent(false, false)] local procedure OnCreateInvLinesOnAfterReturnRcptLoop(ShouldInsertReturnRcptLine: Boolean; ReturnReceiptHeader: Record "Return Receipt Header"; ReturnReceiptLine: Record "Return Receipt Line"; SalesHeader: Record "Sales Header"; SalesLine: Record "Sales Line") begin end; [IntegrationEvent(false, false)] local procedure OnRunOnAfterSetReturnRcptLineFilters(var ReturnReceiptLine: Record "Return Receipt Line"; SalesHeader: Record "Sales Header") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeTestReturnReceiptLineVATBusPostingGroup(ReturnReceiptLine: Record "Return Receipt Line"; SalesHeader: Record "Sales Header"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnRunOnBeforeGetReturnRcptLines(var ReturnReceiptLine: Record "Return Receipt Line"; SalesHeader: Record "Sales Header"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnCreateInvLinesOnBeforeLoopReturnRcptLines(var ReturnReceiptLine: Record "Return Receipt Line"; var SalesLine: Record "Sales Line"; var ReturnReceiptHeader: Record "Return Receipt Header"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeCheckReturnReceiptBillToCustomerNo(ReturnReceiptHeader: Record "Return Receipt Header"; SalesHeader: Record "Sales Header"; var ReturnReceiptLine: Record "Return Receipt Line"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeCheckHeader(var SalesHeader: Record "Sales Header"; SalesLine: Record "Sales Line"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnSetSalesHeaderOnBeforeTestIsCreditMemo(var SalesHeader: Record "Sales Header"; var IsHandled: Boolean) begin end;}