Codeunit 1305 Sales-Quote to Invoice

Base Application, Microsoft.Sales.Document

src/Layers/W1/BaseApp/Sales/Document/SalesQuotetoInvoice.Codeunit.al279 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.Sales.Comment;using Microsoft.Sales.Customer;using Microsoft.Sales.Setup;using Microsoft.Utilities;using System.Email;using System.Utilities;/// <summary>/// Converts a sales quote directly into a sales invoice for immediate billing./// </summary>codeunit 1305 "Sales-Quote to Invoice"{    TableNo = "Sales Header";    trigger OnRun()    var        Cust: Record Customer;        SalesQuoteLine: Record "Sales Line";        SalesCommentLine: Record "Sales Comment Line";        SalesInvoiceLine: Record "Sales Line";        CustCheckCrLimit: Codeunit "Cust-Check Cr. Limit";        IsHandled: Boolean;    begin        OnBeforeOnRun(Rec);        Rec.TestField("Document Type", Rec."Document Type"::Quote);        if Rec."Sell-to Customer No." = '' then            Error(SpecifyCustomerErr);        if Rec."Bill-to Customer No." = '' then            Error(SpecifyBillToCustomerNoErr, Rec.FieldCaption("Bill-to Customer No."));        Rec.OnCheckSalesPostRestrictions();        Cust.Get(Rec."Sell-to Customer No.");        Cust.CheckBlockedCustOnDocs(Cust, Rec."Document Type"::Quote, true, false);        Rec.CalcFields("Amount Including VAT", "Invoice Discount Amount", "Work Description");        Rec.ValidateSalesPersonOnSalesHeader(Rec, true, false);        OnRunOnBeforeRunLineChecks(Rec);        Rec.CheckForBlockedLines();        CheckForAssembleToOrderLines(Rec);        SalesInvoiceHeader := Rec;        SalesInvoiceLine.LockTable();        CreateSalesInvoiceHeader(SalesInvoiceHeader, Rec);        CreateSalesInvoiceLines(SalesInvoiceHeader, Rec, SalesQuoteLine);        OnAfterInsertAllSalesInvLines(SalesInvoiceLine, Rec);        SalesSetup.Get();        ArchiveSalesQuote(Rec);        if SalesSetup."Default Posting Date" = SalesSetup."Default Posting Date"::"No Date" then begin            SalesInvoiceHeader."Posting Date" := 0D;            SalesInvoiceHeader.Modify();        end;        UpdateEmailParameters(SalesInvoiceHeader);        IsHandled := false;        OnBeforeDeletionOfQuote(Rec, SalesInvoiceHeader, IsHandled, SalesQuoteLine);        if not IsHandled then begin            SalesCommentLine.DeleteComments(Rec."Document Type".AsInteger(), Rec."No.");            Rec.DeleteLinks();            Rec.Delete();            SalesQuoteLine.DeleteAll();        end;        Commit();        Clear(CustCheckCrLimit);        OnAfterOnRun(Rec, SalesInvoiceHeader);    end;    var        SalesSetup: Record "Sales & Receivables Setup";        SalesInvoiceHeader: Record "Sales Header";        SpecifyCustomerErr: Label 'You must select a customer before you can convert a quote to an invoice.';        SpecifyBillToCustomerNoErr: Label 'You must specify the %1 before you can convert a quote to an invoice.', Comment = '%1 is Bill-To Customer No.';        CannotConvertAssembleToOrderItemErr: Label 'You can not convert sales quote to sales invoice because one or more lines is linked to assembly quote. Change the %1 to zero or convert the quote to order instead.', Comment = '%1 = field name';    local procedure ArchiveSalesQuote(var SalesHeader: Record "Sales Header")    var        ArchiveManagement: Codeunit ArchiveManagement;        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeArchiveSalesQuote(SalesHeader, SalesInvoiceHeader, IsHandled);        if IsHandled then            exit;        case SalesSetup."Archive Quotes" of            SalesSetup."Archive Quotes"::Always:                ArchiveManagement.ArchSalesDocumentNoConfirm(SalesHeader);            SalesSetup."Archive Quotes"::Question:                ArchiveManagement.ArchiveSalesDocument(SalesHeader);        end;    end;    /// <summary>    /// Retrieves the sales invoice header created from the quote conversion.    /// </summary>    /// <param name="SalesHeader2">Returns the created sales invoice header.</param>    procedure GetSalesInvoiceHeader(var SalesHeader2: Record "Sales Header")    begin        SalesHeader2 := SalesInvoiceHeader;    end;    local procedure CreateSalesInvoiceHeader(var SalesInvoiceHeader: Record "Sales Header"; SalesQuoteHeader: Record "Sales Header")    var        GLSetup: Record "General Ledger Setup";    begin        SalesInvoiceHeader."Document Type" := SalesInvoiceHeader."Document Type"::Invoice;        SalesInvoiceHeader."No. Printed" := 0;        SalesInvoiceHeader.Status := SalesInvoiceHeader.Status::Open;        SalesInvoiceHeader."No." := '';        SalesInvoiceHeader."Quote No." := SalesQuoteHeader."No.";        OnCreateSalesInvoiceHeaderOnBeforeSalesInvoiceHeaderInsert(SalesInvoiceHeader, SalesQuoteHeader);        SalesInvoiceHeader.Insert(true);        if SalesQuoteHeader."Posting Date" <> 0D then            SalesInvoiceHeader."Posting Date" := SalesQuoteHeader."Posting Date"        else            SalesInvoiceHeader."Posting Date" := WorkDate();        SalesInvoiceHeader.InitFromSalesHeader(SalesQuoteHeader);        SalesInvoiceHeader."VAT Reporting Date" := GLSetup.GetVATDate(SalesInvoiceHeader."Posting Date", SalesInvoiceHeader."Document Date");        SalesInvoiceHeader.Validate("Posting Date");        OnBeforeInsertSalesInvoiceHeader(SalesInvoiceHeader, SalesQuoteHeader);        SalesInvoiceHeader.Modify();    end;    local procedure CreateSalesInvoiceLines(SalesInvoiceHeader: Record "Sales Header"; SalesQuoteHeader: Record "Sales Header"; var SalesQuoteLine: Record "Sales Line")    var        SalesInvoiceLine: Record "Sales Line";        SalesLineReserve: Codeunit "Sales Line-Reserve";        IsHandled: Boolean;    begin        SalesQuoteLine.Reset();        SalesQuoteLine.SetRange("Document Type", SalesQuoteHeader."Document Type");        SalesQuoteLine.SetRange("Document No.", SalesQuoteHeader."No.");        OnAfterSalesQuoteLineSetFilters(SalesQuoteLine);        if SalesQuoteLine.FindSet() then            repeat                IsHandled := false;                OnBeforeCreateSalesInvoiceLineLoop(SalesQuoteLine, SalesQuoteHeader, SalesInvoiceHeader, IsHandled);                if not IsHandled then begin                    SalesInvoiceLine := SalesQuoteLine;                    SalesInvoiceLine."Document Type" := SalesInvoiceHeader."Document Type";                    SalesInvoiceLine."Document No." := SalesInvoiceHeader."No.";                    if SalesInvoiceLine."No." <> '' then                        SalesInvoiceLine.DefaultDeferralCode();                    SalesInvoiceLine.InitQtyToShip();                    OnBeforeInsertSalesInvoiceLine(SalesQuoteLine, SalesQuoteHeader, SalesInvoiceLine, SalesInvoiceHeader);                    SalesInvoiceLine.Insert();                    SalesLineReserve.TransferSaleLineToSalesLine(SalesQuoteLine, SalesInvoiceLine, SalesQuoteLine."Outstanding Qty. (Base)");                    SalesLineReserve.VerifyQuantity(SalesInvoiceLine, SalesQuoteLine);                    OnAfterInsertSalesInvoiceLine(SalesQuoteLine, SalesQuoteHeader, SalesInvoiceLine, SalesInvoiceHeader);                end;            until SalesQuoteLine.Next() = 0;        MoveLineCommentsToSalesInvoice(SalesInvoiceHeader, SalesQuoteHeader);        OnCreateSalesInvoiceLinesOnBeforeSalesQuoteLineDeleteAll(SalesQuoteHeader, SalesInvoiceHeader, SalesQuoteLine);    end;    local procedure MoveLineCommentsToSalesInvoice(SalesInvoiceHeader: Record "Sales Header"; SalesQuoteHeader: Record "Sales Header")    var        SalesCommentLine: Record "Sales Comment Line";        RecordLinkManagement: Codeunit "Record Link Management";    begin        SalesCommentLine.CopyComments(          SalesQuoteHeader."Document Type".AsInteger(), SalesInvoiceHeader."Document Type".AsInteger(), SalesQuoteHeader."No.", SalesInvoiceHeader."No.");        RecordLinkManagement.CopyLinks(SalesQuoteHeader, SalesInvoiceHeader);    end;    local procedure UpdateEmailParameters(SalesHeader: Record "Sales Header")    var        EmailParameter: Record "Email Parameter";    begin        EmailParameter.SetRange("Document No", SalesHeader."Quote No.");        EmailParameter.SetRange("Document Type", SalesHeader."Document Type"::Quote);        EmailParameter.DeleteAll();    end;    local procedure CheckForAssembleToOrderLines(QuoteSalesHeader: Record "Sales Header")    var        CurrentSalesLine: Record "Sales Line";    begin        CurrentSalesLine.SetRange("Document Type", QuoteSalesHeader."Document Type");        CurrentSalesLine.SetRange("Document No.", QuoteSalesHeader."No.");        CurrentSalesLine.SetRange(Type, CurrentSalesLine.Type::Item);        CurrentSalesLine.SetFilter("Qty. to Assemble to Order", '<> 0');        if not CurrentSalesLine.IsEmpty() then            Error(CannotConvertAssembleToOrderItemErr, CurrentSalesLine.FieldCaption("Qty. to Assemble to Order"));    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeInsertSalesInvoiceHeader(var SalesInvoiceHeader: Record "Sales Header"; QuoteSalesHeader: Record "Sales Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterInsertSalesInvoiceLine(SalesQuoteLine: Record "Sales Line"; SalesQuoteHeader: Record "Sales Header"; var SalesInvoiceLine: Record "Sales Line"; SalesInvoiceHeader: Record "Sales Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterInsertAllSalesInvLines(var SalesInvoiceLine: Record "Sales Line"; SalesQuoteHeader: Record "Sales Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterOnRun(var SalesHeader: Record "Sales Header"; var SalesInvoiceHeader: Record "Sales Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterSalesQuoteLineSetFilters(var SalesQuoteLine: Record "Sales Line");    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeArchiveSalesQuote(var SalesHeader: Record "Sales Header"; var SalesInvoiceHeader: Record "Sales Header"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeOnRun(var SalesHeader: Record "Sales Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeInsertSalesInvoiceLine(SalesQuoteLine: Record "Sales Line"; SalesQuoteHeader: Record "Sales Header"; var SalesInvoiceLine: Record "Sales Line"; SalesInvoiceHeader: Record "Sales Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCreateSalesInvoiceLineLoop(var SalesQuoteLine: Record "Sales Line"; var SalesQuoteHeader: Record "Sales Header"; var SalesInvoiceHeader: Record "Sales Header"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeDeletionOfQuote(var SalesHeader: Record "Sales Header"; var SalesInvoiceHeader: Record "Sales Header"; var IsHandled: Boolean; var SalesQuoteLine: Record "Sales Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCreateSalesInvoiceHeaderOnBeforeSalesInvoiceHeaderInsert(var SalesInvoiceHeader: Record "Sales Header"; SalesQuoteHeader: Record "Sales Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCreateSalesInvoiceLinesOnBeforeSalesQuoteLineDeleteAll(QuoteSalesHeader: Record "Sales Header"; InvoiceSalesHeader: Record "Sales Header"; var QuoteSalesLine: Record "Sales Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnRunOnBeforeRunLineChecks(var SalesHeader: Record "Sales Header")    begin    end;}