Report 6653 Combine Return Receipts
src/Layers/W1/BaseApp/Sales/Document/CombineReturnReceipts.Report.al449 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.Finance.GeneralLedger.Setup;using Microsoft.Finance.VAT.Calculation;using Microsoft.Sales.Customer;using Microsoft.Sales.History;using Microsoft.Sales.Posting;using Microsoft.Sales.Setup;using System.Globalization;/// <summary>/// Consolidates multiple return receipts into a single sales credit memo for efficient processing./// </summary>report 6653 "Combine Return Receipts"{ ApplicationArea = SalesReturnOrder, PurchReturnOrder; Caption = 'Combine Return Receipts'; ToolTip = 'Return items covered by different purchase return orders to the same vendor on one shipment. When you ship the items, you post the related purchase return orders as shipped and this creates posted purchase return shipments. When you are ready to invoice these items, you can create one purchase credit memo that automatically includes the posted purchase return shipment lines so that you invoice all the open purchase return orders at the same time.'; ProcessingOnly = true; UsageCategory = Tasks; dataset { dataitem(SalesOrderHeader; "Sales Header") { DataItemTableView = sorting("Document Type", "Combine Shipments", "Bill-to Customer No.") where("Document Type" = const("Return Order"), "Combine Shipments" = const(true)); RequestFilterFields = "Sell-to Customer No.", "Bill-to Customer No."; RequestFilterHeading = 'Sales Return Order'; dataitem("Return Receipt Header"; "Return Receipt Header") { DataItemLink = "Return Order No." = field("No."); DataItemTableView = sorting("Return Order No."); RequestFilterFields = "Posting Date"; RequestFilterHeading = 'Posted Return Receipts'; dataitem("Return Receipt Line"; "Return Receipt Line") { DataItemLink = "Document No." = field("No."); DataItemTableView = sorting("Document No.", "Line No.") where("Return Qty. Rcd. Not Invd." = filter(<> 0)); trigger OnAfterGetRecord() var SalesGetReturnReceipts: Codeunit "Sales-Get Return Receipts"; IsHandled: Boolean; begin IsHandled := false; OnBeforeReturnReceiptLineOnAfterGetRecord("Return Receipt Line", IsHandled); if IsHandled then CurrReport.Skip(); if "Return Qty. Rcd. Not Invd." <> 0 then begin if "Bill-to Customer No." <> Cust."No." then Cust.Get("Bill-to Customer No."); if Cust.Blocked <> Cust.Blocked::All then begin if ShouldFinalizeSalesInvHeader(SalesOrderHeader, SalesHeader, "Return Receipt Line") then begin if SalesHeader."No." <> '' then FinalizeSalesInvHeader(); InsertSalesInvHeader(); SalesLine.SetRange("Document Type", SalesHeader."Document Type"); SalesLine.SetRange("Document No.", SalesHeader."No."); SalesLine."Document Type" := SalesHeader."Document Type"; SalesLine."Document No." := SalesHeader."No."; end; ReturnRcptLine := "Return Receipt Line"; ReturnRcptLine.InsertInvLineFromRetRcptLine(SalesLine); if Type = Type::"Charge (Item)" then SalesGetReturnReceipts.GetItemChargeAssgnt("Return Receipt Line", SalesLine."Qty. to Invoice"); end else NoOfSalesInvErrors := NoOfSalesInvErrors + 1; end; end; } trigger OnAfterGetRecord() begin Window.Update(3, "No."); end; } trigger OnAfterGetRecord() begin CurrReport.Language := LanguageMgt.GetLanguageIdOrDefault("Language Code"); CurrReport.FormatRegion := LanguageMgt.GetFormatRegionOrDefault("Format Region"); Window.Update(1, "Bill-to Customer No."); Window.Update(2, "No."); end; trigger OnPostDataItem() begin CurrReport.Language := ReportLanguage; Window.Close(); ShowResult(); end; trigger OnPreDataItem() begin if PostingDateReq = 0D then Error(Text000); if DocDateReq = 0D then Error(Text001); if VATDateReq = 0D then Error(VATDateEmptyErr); Window.Open( Text002 + Text003 + Text004 + Text005); OnAfterSalesOrderHeaderOnPreDataItem(SalesOrderHeader); ReportLanguage := CurrReport.Language(); end; } } requestpage { SaveValues = true; layout { area(content) { group(Options) { Caption = 'Options'; field(PostingDateReq; PostingDateReq) { ApplicationArea = SalesReturnOrder; Caption = 'Posting Date'; ToolTip = 'Specifies the posting date for the credit memo(s) that the batch job creates.'; trigger OnValidate() begin UpdateVATDate(); end; } field(DocDateReq; DocDateReq) { ApplicationArea = SalesReturnOrder; Caption = 'Document Date'; ToolTip = 'Specifies the document date for the credit memo(s) that the batch job creates. This field must be filled in.'; trigger OnValidate() begin UpdateVATDate(); end; } field(VATDate; VATDateReq) { ApplicationArea = VAT; Caption = 'VAT Date'; Editable = VATDateEnabled; Visible = VATDateEnabled; ToolTip = 'Specifies the VAT date for the credit memo(s) that the batch job creates. This field must be filled in.'; } field(CalcInvDisc; CalcInvDisc) { ApplicationArea = SalesReturnOrder; Caption = 'Calc. Inv. Discount'; ToolTip = 'Specifies if you want the invoice discounts calculated automatically.'; trigger OnValidate() begin SalesSetup.Get(); SalesSetup.TestField("Calc. Inv. Discount", false); end; } field(PostInv; PostInv) { ApplicationArea = SalesReturnOrder; Caption = 'Post Credit Memos'; ToolTip = 'Specifies if you want to have the credit memos posted immediately.'; } } } } actions { } trigger OnOpenPage() var VATReportingDateMgt: Codeunit "VAT Reporting Date Mgt"; begin if PostingDateReq = 0D then PostingDateReq := WorkDate(); if DocDateReq = 0D then DocDateReq := WorkDate(); if VATDateReq = 0D then VATDateReq := GLSetup.GetVATDate(PostingDateReq, DocDateReq); SalesSetup.Get(); CalcInvDisc := SalesSetup."Calc. Inv. Discount"; VATDateEnabled := VATReportingDateMgt.IsVATDateEnabled(); end; } labels { } var GLSetup: Record "General Ledger Setup"; SalesHeader: Record "Sales Header"; SalesLine: Record "Sales Line"; ReturnRcptLine: Record "Return Receipt Line"; SalesSetup: Record "Sales & Receivables Setup"; Cust: Record Customer; LanguageMgt: Codeunit Language; SalesCalcDisc: Codeunit "Sales-Calc. Discount"; SalesPost: Codeunit "Sales-Post"; Window: Dialog; HideDialog: Boolean; NoOfSalesInvErrors: Integer; NoOfSalesInv: Integer; ReportLanguage: Integer;#pragma warning disable AA0074 Text000: Label 'Enter the posting date.'; Text001: Label 'Enter the document date.'; Text002: Label 'Combining return receipts...\\';#pragma warning disable AA0470 Text003: Label 'Customer No. #1##########\'; Text004: Label 'Return Order No. #2##########\'; Text005: Label 'Return Receipt No. #3##########'; Text007: Label 'Not all the credit memos were posted. A total of %1 credit memos were not posted.';#pragma warning restore AA0470 Text008: Label 'There is nothing to combine.';#pragma warning disable AA0470 Text010: Label 'The return receipts are now combined and the number of credit memos created is %1.';#pragma warning restore AA0470#pragma warning restore AA0074 VATDateEmptyErr: Label 'Enter the VAT date.'; protected var PostingDateReq: Date; DocDateReq: Date; VATDateReq: Date; CalcInvDisc: Boolean; PostInv: Boolean; VATDateEnabled: Boolean; local procedure FinalizeSalesInvHeader() var ShouldPostInv: Boolean; begin OnBeforeFinalizeSalesInvHeader(SalesHeader); if CalcInvDisc then SalesCalcDisc.Run(SalesLine); SalesHeader.Find(); Commit(); Clear(SalesCalcDisc); Clear(SalesPost); NoOfSalesInv := NoOfSalesInv + 1; ShouldPostInv := PostInv; OnFinalizeSalesInvHeaderOnAfterCalcShouldPostInv(SalesHeader, NoOfSalesInv, ShouldPostInv); if ShouldPostInv then begin Clear(SalesPost); if not SalesPost.Run(SalesHeader) then NoOfSalesInvErrors := NoOfSalesInvErrors + 1; end; end; local procedure InsertSalesInvHeader() var IsHandled: Boolean; begin IsHandled := false; OnBeforeInsertSalesInvHeader(SalesHeader, SalesOrderHeader, "Return Receipt Header", "Return Receipt Line", NoOfSalesInv, IsHandled); if not IsHandled then begin SalesHeader.Init(); SalesHeader."Document Type" := SalesHeader."Document Type"::"Credit Memo"; SalesHeader."No." := ''; OnBeforeSalesCrMemoHeaderInsert(SalesHeader, SalesOrderHeader); SalesHeader.Insert(true); ValidateCustomerNoFromOrder(SalesHeader, SalesOrderHeader); SalesHeader.Validate("Currency Code", SalesOrderHeader."Currency Code"); SalesHeader.Validate("Posting Date", PostingDateReq); SalesHeader.Validate("Document Date", DocDateReq); SalesHeader.Validate("VAT Reporting Date", VATDateReq); SalesHeader."Shortcut Dimension 1 Code" := SalesOrderHeader."Shortcut Dimension 1 Code"; SalesHeader."Shortcut Dimension 2 Code" := SalesOrderHeader."Shortcut Dimension 2 Code"; SalesHeader."Dimension Set ID" := SalesOrderHeader."Dimension Set ID"; OnBeforeSalesCrMemoHeaderModify(SalesHeader, SalesOrderHeader); SalesHeader.Modify(); Commit(); end; OnAfterInsertSalesInvHeader(SalesHeader, "Return Receipt Header"); end; local procedure ValidateCustomerNoFromOrder(var ToSalesHeader: Record "Sales Header"; FromSalesOrderHeader: Record "Sales Header") var IsHandled: Boolean; begin IsHandled := false; OnBeforeValidateCustomerNoFromOrder(ToSalesHeader, FromSalesOrderHeader, "Return Receipt Header", "Return Receipt Line", IsHandled); if IsHandled then exit; ToSalesHeader.Validate("Sell-to Customer No.", FromSalesOrderHeader."Bill-to Customer No."); if ToSalesHeader."Bill-to Customer No." <> ToSalesHeader."Sell-to Customer No." then ToSalesHeader.Validate("Bill-to Customer No.", FromSalesOrderHeader."Bill-to Customer No."); end; /// <summary> /// Initializes the request with posting parameters. /// </summary> /// <param name="NewPostingDate">The posting date for combined credit memos.</param> /// <param name="NewDocumentDate">The document date for combined credit memos.</param> /// <param name="NewCalcInvDisc">Whether to calculate invoice discount.</param> /// <param name="NewPostCreditMemo">Whether to post the credit memo after combining.</param> procedure InitializeRequest(NewPostingDate: Date; NewDocumentDate: Date; NewCalcInvDisc: Boolean; NewPostCreditMemo: Boolean) begin PostingDateReq := NewPostingDate; DocDateReq := NewDocumentDate; VATDateReq := GLSetup.GetVATDate(PostingDateReq, DocDateReq); CalcInvDisc := NewCalcInvDisc; PostInv := NewPostCreditMemo; end; /// <summary> /// Initializes the request with posting parameters including VAT date. /// </summary> /// <param name="NewPostingDate">The posting date for combined credit memos.</param> /// <param name="NewDocumentDate">The document date for combined credit memos.</param> /// <param name="NewVATDate">The VAT date for combined credit memos.</param> /// <param name="NewCalcInvDisc">Whether to calculate invoice discount.</param> /// <param name="NewPostCreditMemo">Whether to post the credit memo after combining.</param> procedure InitializeRequest(NewPostingDate: Date; NewDocumentDate: Date; NewVATDate: Date; NewCalcInvDisc: Boolean; NewPostCreditMemo: Boolean) begin InitializeRequest(NewPostingDate, NewDocumentDate, NewCalcInvDisc, NewPostCreditMemo); VATDateReq := NewVATDate; end; /// <summary> /// Sets whether to hide dialog messages during processing. /// </summary> /// <param name="NewHideDialog">Whether to hide dialog messages.</param> procedure SetHideDialog(NewHideDialog: Boolean) begin HideDialog := NewHideDialog; end; local procedure ShowResult() begin OnBeforeShowResult(SalesHeader, NoOfSalesInvErrors, PostInv); if SalesHeader."No." <> '' then begin // Not the first time FinalizeSalesInvHeader(); OnReturnReceiptHeaderOnAfterFinalizeSalesInvHeader(SalesHeader, NoOfSalesInvErrors, PostInv, HideDialog); if not HideDialog then if NoOfSalesInvErrors = 0 then Message(Text010, NoOfSalesInv) else Message(Text007, NoOfSalesInvErrors) end else if not HideDialog then Message(Text008); end; local procedure ShouldFinalizeSalesInvHeader(SalesOrderHeader: Record "Sales Header"; SalesHeader: Record "Sales Header"; ReturnReceiptLine: Record "Return Receipt Line") Finalize: Boolean begin Finalize := (SalesOrderHeader."Bill-to Customer No." <> SalesHeader."Bill-to Customer No.") or (SalesOrderHeader."Currency Code" <> SalesHeader."Currency Code") or (SalesOrderHeader."Dimension Set ID" <> SalesHeader."Dimension Set ID"); OnAfterShouldFinalizeSalesInvHeader(SalesOrderHeader, SalesHeader, Finalize, ReturnReceiptLine, "Return Receipt Header"); exit(Finalize); end; local procedure UpdateVATDate() begin VATDateReq := GLSetup.GetVATDate(PostingDateReq, DocDateReq); end; [IntegrationEvent(false, false)] local procedure OnAfterInsertSalesInvHeader(var SalesHeader: Record "Sales Header"; var ReturnReceiptHeader: Record "Return Receipt Header") begin end; [IntegrationEvent(false, false)] local procedure OnAfterSalesOrderHeaderOnPreDataItem(var SalesOrderHeader: Record "Sales Header") begin end; [IntegrationEvent(false, false)] local procedure OnAfterShouldFinalizeSalesInvHeader(var SalesOrderHeader: Record "Sales Header"; SalesHeader: Record "Sales Header"; var Finalize: Boolean; ReturnReceiptLine: Record "Return Receipt Line"; ReturnReceiptHeader: Record "Return Receipt Header") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeFinalizeSalesInvHeader(var SalesHeader: Record "Sales Header") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeInsertSalesInvHeader(var SalesHeader: Record "Sales Header"; SalesOrderHeader: Record "Sales Header"; ReturnReceiptHeader: Record "Return Receipt Header"; ReturnReceiptLine: Record "Return Receipt Line"; var NoOfSalesInv: Integer; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeReturnReceiptLineOnAfterGetRecord(var ReturnReceiptLine: Record "Return Receipt Line"; var IsHandled: Boolean); begin end; [IntegrationEvent(false, false)] local procedure OnBeforeSalesCrMemoHeaderInsert(var SalesHeader: Record "Sales Header"; SalesOrderHeader: Record "Sales Header") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeSalesCrMemoHeaderModify(var SalesHeader: Record "Sales Header"; SalesOrderHeader: Record "Sales Header") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeShowResult(var SalesHeader: Record "Sales Header"; var NoOfSalesInvErrors: Integer; PostInv: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeValidateCustomerNoFromOrder(var SalesHeader: Record "Sales Header"; SalesOrderHeader: Record "Sales Header"; ReturnReceiptHeader: Record "Return Receipt Header"; ReturnReceiptLine: Record "Return Receipt Line"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnFinalizeSalesInvHeaderOnAfterCalcShouldPostInv(var SalesHeader: Record "Sales Header"; var NoOfSalesInv: Integer; var ShouldPostInv: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnReturnReceiptHeaderOnAfterFinalizeSalesInvHeader(var SalesHeader: Record "Sales Header"; var NoOfSalesCrMemoErrors: Integer; PostInv: Boolean; HideDialog: Boolean) begin end;}