Report 1304 Standard Sales - Quote

Base Application, Microsoft.Sales.Document

src/Layers/W1/BaseApp/Sales/Document/StandardSalesQuote.Report.al1,286 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.Bank.BankAccount;using Microsoft.CRM.Contact;using Microsoft.CRM.Interaction;using Microsoft.CRM.Segment;using Microsoft.CRM.Team;using Microsoft.Finance.Currency;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Finance.VAT.Calculation;using Microsoft.Finance.VAT.Clause;using Microsoft.Foundation.Address;using Microsoft.Foundation.Company;using Microsoft.Foundation.PaymentTerms;using Microsoft.Foundation.Reporting;using Microsoft.Foundation.Shipping;using Microsoft.Inventory.Location;using Microsoft.Sales.Customer;using Microsoft.Sales.Posting;using Microsoft.Sales.Setup;using Microsoft.Utilities;using System.Email;using System.Globalization;using System.Reflection;using System.Text;using System.Utilities;/// <summary>/// Generates a sales quote document to send to customers as a proposal./// </summary>report 1304 "Standard Sales - Quote"{    Caption = 'Sales - Quote';    DefaultRenderingLayout = "StandardSalesQuote.docx";    PreviewMode = PrintLayout;    WordMergeDataItem = Header;    dataset    {        dataitem(Header; "Sales Header")        {            DataItemTableView = sorting("Document Type", "No.") where("Document Type" = const(Quote));            RequestFilterFields = "No.", "Sell-to Customer No.", "No. Printed";            RequestFilterHeading = 'Sales Quote';            column(CompanyAddress1; CompanyAddr[1])            {            }            column(CompanyAddress2; CompanyAddr[2])            {            }            column(CompanyAddress3; CompanyAddr[3])            {            }            column(CompanyAddress4; CompanyAddr[4])            {            }            column(CompanyAddress5; CompanyAddr[5])            {            }            column(CompanyAddress6; CompanyAddr[6])            {            }            column(CompanyAddress7; CompanyAddr[7])            {            }            column(CompanyAddress8; CompanyAddr[8])            {            }            column(CompanyHomePage; CompanyInfo."Home Page")            {            }            column(CompanyEMail; CompanyInfo."E-Mail")            {            }            column(CompanyPicture; DummyCompanyInfo.Picture)            {            }            column(CompanyPhoneNo; CompanyInfo."Phone No.")            {            }            column(CompanyPhoneNo_Lbl; CompanyInfoPhoneNoLbl)            {            }            column(CompanyGiroNo; CompanyInfo."Giro No.")            {            }            column(CompanyGiroNo_Lbl; CompanyInfoGiroNoLbl)            {            }            column(CompanyBankName; CompanyBankAccount.Name)            {            }            column(CompanyBankName_Lbl; CompanyInfoBankNameLbl)            {            }            column(CompanyBankBranchNo; CompanyBankAccount."Bank Branch No.")            {            }            column(CompanyBankBranchNo_Lbl; CompanyBankAccount.FieldCaption("Bank Branch No."))            {            }            column(CompanyBankAccountNo; CompanyBankAccount."Bank Account No.")            {            }            column(CompanyBankAccountNo_Lbl; CompanyInfoBankAccNoLbl)            {            }            column(CompanyIBAN; CompanyBankAccount.IBAN)            {            }            column(CompanyIBAN_Lbl; CompanyBankAccount.FieldCaption(IBAN))            {            }            column(CompanySWIFT; CompanyBankAccount."SWIFT Code")            {            }            column(CompanySWIFT_Lbl; CompanyBankAccount.FieldCaption("SWIFT Code"))            {            }            column(CompanyLogoPosition; CompanyLogoPosition)            {            }            column(CompanyRegistrationNumber; CompanyInfo.GetRegistrationNumber())            {            }            column(CompanyRegistrationNumber_Lbl; CompanyInfo.GetRegistrationNumberLbl())            {            }            column(CompanyVATRegNo; CompanyInfo.GetVATRegistrationNumber())            {            }            column(CompanyVATRegNo_Lbl; CompanyInfo.GetVATRegistrationNumberLbl())            {            }            column(CompanyVATRegistrationNo; CompanyInfo.GetVATRegistrationNumber())            {            }            column(CompanyVATRegistrationNo_Lbl; CompanyInfo.GetVATRegistrationNumberLbl())            {            }            column(CompanyLegalOffice; LegalOfficeTxt)            {            }            column(CompanyLegalOffice_Lbl; LegalOfficeLbl)            {            }            column(CompanyCustomGiro; CustomGiroTxt)            {            }            column(CompanyCustomGiro_Lbl; CustomGiroLbl)            {            }            column(CompanyLegalStatement; LegalStatementLbl)            {            }            column(CustomerAddress1; CustAddr[1])            {            }            column(CustomerAddress2; CustAddr[2])            {            }            column(CustomerAddress3; CustAddr[3])            {            }            column(CustomerAddress4; CustAddr[4])            {            }            column(CustomerAddress5; CustAddr[5])            {            }            column(CustomerAddress6; CustAddr[6])            {            }            column(CustomerAddress7; CustAddr[7])            {            }            column(CustomerAddress8; CustAddr[8])            {            }            column(CustomerPostalBarCode; FormatAddr.PostalBarCode(1))            {            }            column(ExternalDocumentNo; "External Document No.")            {            }            column(ExternalDocumentNoLbl; FieldCaption("External Document No."))            {            }            column(YourReference; "Your Reference")            {            }            column(YourReference__Lbl; FieldCaption("Your Reference"))            {            }            column(ShipmentMethodDescription; ShipmentMethod.Description)            {            }            column(ShipmentMethodDescription_Lbl; ShptMethodDescLbl)            {            }            column(Shipment_Lbl; ShipmentLbl)            {            }            column(ShowShippingAddress; ShowShippingAddr)            {            }            column(ShipToAddress_Lbl; ShiptoAddrLbl)            {            }            column(ShipToAddress1; ShipToAddr[1])            {            }            column(ShipToAddress2; ShipToAddr[2])            {            }            column(ShipToAddress3; ShipToAddr[3])            {            }            column(ShipToAddress4; ShipToAddr[4])            {            }            column(ShipToAddress5; ShipToAddr[5])            {            }            column(ShipToAddress6; ShipToAddr[6])            {            }            column(ShipToAddress7; ShipToAddr[7])            {            }            column(ShipToAddress8; ShipToAddr[8])            {            }            column(ShipToPhoneNo; Header."Ship-to Phone No.")            {            }            column(SellToContactPhoneNoLbl; SellToContactPhoneNoLbl)            {            }            column(SellToContactMobilePhoneNoLbl; SellToContactMobilePhoneNoLbl)            {            }            column(SellToContactEmailLbl; SellToContactEmailLbl)            {            }            column(BillToContactPhoneNoLbl; BillToContactPhoneNoLbl)            {            }            column(BillToContactMobilePhoneNoLbl; BillToContactMobilePhoneNoLbl)            {            }            column(BillToContactEmailLbl; BillToContactEmailLbl)            {            }            column(SellToContactPhoneNo; SellToContact."Phone No.")            {            }            column(SellToContactMobilePhoneNo; SellToContact."Mobile Phone No.")            {            }            column(SellToContactEmail; SellToContact."E-Mail")            {            }            column(BillToContactPhoneNo; BillToContact."Phone No.")            {            }            column(BillToContactMobilePhoneNo; BillToContact."Mobile Phone No.")            {            }            column(BillToContactEmail; BillToContact."E-Mail")            {            }            column(PaymentTermsDescription; PaymentTerms.Description)            {            }            column(PaymentTermsDescription_Lbl; PaymentTermsDescLbl)            {            }            column(PaymentMethodDescription; PaymentMethod.Description)            {            }            column(PaymentMethodDescription_Lbl; PaymentMethodDescLbl)            {            }            column(DocumentCopyText; StrSubstNo(DocumentCaption(), CopyText))            {            }            column(BilltoCustumerNo; "Bill-to Customer No.")            {            }            column(BilltoCustomerNo_Lbl; FieldCaption("Bill-to Customer No."))            {            }            column(DocumentDate; Format("Document Date", 0, 4))            {            }            column(DocumentDate_Lbl; FieldCaption("Document Date"))            {            }            column(DueDate; Format("Due Date", 0, 4))            {            }            column(DueDate_Lbl; FieldCaption("Due Date"))            {            }            column(QuoteValidToDate; Format("Quote Valid Until Date", 0, 4))            {            }            column(QuoteValidToDate_Lbl; QuoteValidToDateLbl)            {            }            column(DocumentNo; "No.")            {            }            column(DocumentNo_Lbl; InvNoLbl)            {            }            column(PricesIncludingVAT; "Prices Including VAT")            {            }            column(PricesIncludingVAT_Lbl; FieldCaption("Prices Including VAT"))            {            }            column(PricesIncludingVATYesNo; Format("Prices Including VAT"))            {            }            column(SalesPerson_Lbl; SalespersonLbl)            {            }            column(SalesPersonBlank_Lbl; SalesPersonText)            {            }            column(SalesPersonName; SalespersonPurchaser.Name)            {            }            column(SelltoCustomerNo; "Sell-to Customer No.")            {            }            column(SelltoCustomerNo_Lbl; FieldCaption("Sell-to Customer No."))            {            }            column(VATRegistrationNo; GetCustomerVATRegistrationNumber())            {            }            column(VATRegistrationNo_Lbl; GetCustomerVATRegistrationNumberLbl())            {            }            column(LegalEntityType; Cust.GetLegalEntityType())            {            }            column(LegalEntityType_Lbl; Cust.GetLegalEntityTypeLbl())            {            }            column(Copy_Lbl; CopyLbl)            {            }            column(EMail_Lbl; EMailLbl)            {            }            column(Estimate_Lbl; EstimateLbl)            {            }            column(YourEstimate_Lbl; YourEstimateLbl)            {            }            column(EstimateBody_Lbl; EstimateBodyLbl)            {            }            column(From_Lbl; FromLbl)            {            }            column(EstimateFor_Lbl; EstimateForLbl)            {            }            column(Questions_Lbl; QuestionsLbl)            {            }            column(Contact_Lbl; CompanyInfo.GetContactUsText())            {            }            column(Thanks_Lbl; ThanksLbl)            {            }            column(HomePage_Lbl; HomePageLbl)            {            }            column(InvoiceDiscountBaseAmount_Lbl; InvDiscBaseAmtLbl)            {            }            column(InvoiceDiscountAmount_Lbl; InvDiscountAmtLbl)            {            }            column(LineAmountAfterInvoiceDiscount_Lbl; LineAmtAfterInvDiscLbl)            {            }            column(LocalCurrency_Lbl; LocalCurrencyLbl)            {            }            column(ExchangeRateAsText; ExchangeRateText)            {            }            column(Page_Lbl; PageLbl)            {            }            column(SalesInvoiceLineDiscount_Lbl; SalesInvLineDiscLbl)            {            }            column(DocumentTitle_Lbl; SalesConfirmationLbl)            {            }            column(ShowWorkDescription; ShowWorkDescription)            {            }            column(Subtotal_Lbl; SubtotalLbl)            {            }            column(Total_Lbl; TotalLbl)            {            }            column(VATAmount_Lbl; VATAmtLbl)            {            }            column(VATBase_Lbl; VATBaseLbl)            {            }            column(VATAmountSpecification_Lbl; VATAmtSpecificationLbl)            {            }            column(VATClauses_Lbl; VATClausesLbl)            {            }            column(VATIdentifier_Lbl; VATIdentifierLbl)            {            }            column(VATPercentage_Lbl; VATPercentageLbl)            {            }            column(VATClause_Lbl; VATClause.TableCaption())            {            }            dataitem(Line; "Sales Line")            {                DataItemLink = "Document No." = field("No.");                DataItemLinkReference = Header;                DataItemTableView = sorting("Document No.", "Line No.");                UseTemporary = true;                column(LineNo_Line; "Line No.")                {                }                column(AmountExcludingVAT_Line; Amount)                {                    AutoFormatExpression = "Currency Code";                    AutoFormatType = 1;                }                column(AmountExcludingVAT_Line_Lbl; FieldCaption(Amount))                {                }                column(AmountIncludingVAT_Line; "Amount Including VAT")                {                    AutoFormatExpression = Header."Currency Code";                    AutoFormatType = 1;                }                column(AmountIncludingVAT_Line_Lbl; FieldCaption("Amount Including VAT"))                {                    AutoFormatExpression = Header."Currency Code";                    AutoFormatType = 1;                }                column(Description_Line; Description)                {                }                column(Description_Line_Lbl; FieldCaption(Description))                {                }                column(LineDiscountPercent_Line; "Line Discount %")                {                }                column(LineDiscountPercentText_Line; LineDiscountPctText)                {                }                column(LineAmount_Line; FormattedLineAmount)                {                    AutoFormatExpression = "Currency Code";                    AutoFormatType = 1;                }                column(LineAmount_Line_Lbl; FieldCaption("Line Amount"))                {                }                column(ItemNo_Line; "No.")                {                }                column(ItemNo_Line_Lbl; FieldCaption("No."))                {                }                column(ItemReferenceNo_Line; "Item Reference No.")                {                }                column(ItemReferenceNo_Line_Lbl; FieldCaption("Item Reference No."))                {                }                column(ShipmentDate_Line; Format("Shipment Date"))                {                }                column(ShipmentDate_Lbl; PostedShipmentDateLbl)                {                }                column(Quantity_Line; FormattedQuantity)                {                }                column(Quantity_Line_Lbl; FieldCaption(Quantity))                {                }                column(Type_Line; Format(Type))                {                }                column(UnitPrice; FormattedUnitPrice)                {                    AutoFormatExpression = "Currency Code";                    AutoFormatType = 2;                }                column(UnitPrice_Lbl; FieldCaption("Unit Price"))                {                }                column(UnitOfMeasure; "Unit of Measure")                {                }                column(UnitOfMeasure_Lbl; FieldCaption("Unit of Measure"))                {                }                column(VATIdentifier_Line; "VAT Identifier")                {                }                column(VATIdentifier_Line_Lbl; FieldCaption("VAT Identifier"))                {                }                column(VATPct_Line; FormattedVATPct)                {                }                column(VATPct_Line_Lbl; FieldCaption("VAT %"))                {                }                column(TransHeaderAmount; TransHeaderAmount)                {                    AutoFormatExpression = "Currency Code";                    AutoFormatType = 1;                }                column(Unit_Lbl; UnitLbl)                {                }                column(Qty_Lbl; QtyLbl)                {                }                column(Price_Lbl; PriceLbl)                {                }                column(PricePer_Lbl; PricePerLbl)                {                }                trigger OnAfterGetRecord()                begin                    if Type = Type::"G/L Account" then                        "No." := '';                    if "Line Discount %" = 0 then                        LineDiscountPctText := ''                    else                        LineDiscountPctText := StrSubstNo('%1%', -Round("Line Discount %", 0.1));                    TransHeaderAmount += PrevLineAmount;                    PrevLineAmount := "Line Amount";                    TotalSubTotal += "Line Amount";                    TotalInvDiscAmount -= "Inv. Discount Amount";                    TotalAmount += Amount;                    TotalAmountVAT += "Amount Including VAT" - Amount;                    TotalAmountInclVAT += "Amount Including VAT";                    TotalPaymentDiscOnVAT += -("Line Amount" - "Inv. Discount Amount" - "Amount Including VAT");                    FormatDocument.SetSalesLine(Line, FormattedQuantity, FormattedUnitPrice, FormattedVATPct, FormattedLineAmount);                    if FirstLineHasBeenOutput then                        Clear(DummyCompanyInfo.Picture);                    FirstLineHasBeenOutput := true;                end;                trigger OnPreDataItem()                begin                    MoreLines := Find('+');                    while MoreLines and (Description = '') and ("No." = '') and (Quantity = 0) and (Amount = 0) do                        MoreLines := Next(-1) <> 0;                    if not MoreLines then                        CurrReport.Break();                    SetFilter("Line No.", '<=%1', "Line No.");                    TransHeaderAmount := 0;                    PrevLineAmount := 0;                    FirstLineHasBeenOutput := false;                    DummyCompanyInfo.Picture := CompanyInfo.Picture;                end;            }            dataitem(WorkDescriptionLines; "Integer")            {                DataItemTableView = sorting(Number) where(Number = filter(1 .. 99999));                column(WorkDescriptionLineNumber; Number)                {                }                column(WorkDescriptionLine; WorkDescriptionLine)                {                }                trigger OnAfterGetRecord()                var                    TypeHelper: Codeunit "Type Helper";                begin                    if WorkDescriptionInstream.EOS then                        CurrReport.Break();                    WorkDescriptionLine := TypeHelper.ReadAsTextWithSeparator(WorkDescriptionInstream, TypeHelper.LFSeparator());                    if WorkDescriptionLine = '' then                        CurrReport.Break();                end;                trigger OnPostDataItem()                begin                    Clear(WorkDescriptionInstream)                end;                trigger OnPreDataItem()                begin                    if not ShowWorkDescription then                        CurrReport.Break();                    Header."Work Description".CreateInStream(WorkDescriptionInstream, TEXTENCODING::UTF8);                end;            }            dataitem(VATAmountLine; "VAT Amount Line")            {                DataItemTableView = sorting("VAT Identifier", "VAT Calculation Type", "Tax Group Code", "Use Tax", Positive);                UseTemporary = true;                column(InvoiceDiscountAmount_VATAmountLine; "Invoice Discount Amount")                {                    AutoFormatExpression = Header."Currency Code";                    AutoFormatType = 1;                }                column(InvoiceDiscountAmount_VATAmountLine_Lbl; FieldCaption("Invoice Discount Amount"))                {                }                column(InvoiceDiscountBaseAmount_VATAmountLine; "Inv. Disc. Base Amount")                {                    AutoFormatExpression = Header."Currency Code";                    AutoFormatType = 1;                }                column(InvoiceDiscountBaseAmount_VATAmountLine_Lbl; FieldCaption("Inv. Disc. Base Amount"))                {                }                column(LineAmount_VatAmountLine; "Line Amount")                {                    AutoFormatExpression = Header."Currency Code";                    AutoFormatType = 1;                }                column(LineAmount_VatAmountLine_Lbl; FieldCaption("Line Amount"))                {                }                column(VATAmount_VatAmountLine; "VAT Amount")                {                    AutoFormatExpression = Header."Currency Code";                    AutoFormatType = 1;                }                column(VATAmount_VatAmountLine_Lbl; FieldCaption("VAT Amount"))                {                }                column(VATAmountLCY_VATAmountLine; VATAmountLCY)                {                }                column(VATAmountLCY_VATAmountLine_Lbl; VATAmountLCYLbl)                {                }                column(VATBase_VatAmountLine; "VAT Base")                {                    AutoFormatExpression = Header."Currency Code";                    AutoFormatType = 1;                }                column(VATBase_VatAmountLine_Lbl; FieldCaption("VAT Base"))                {                }                column(VATBaseLCY_VATAmountLine; VATBaseLCY)                {                }                column(VATBaseLCY_VATAmountLine_Lbl; VATBaseLCYLbl)                {                }                column(VATIdentifier_VatAmountLine; "VAT Identifier")                {                }                column(VATIdentifier_VatAmountLine_Lbl; FieldCaption("VAT Identifier"))                {                }                column(VATPct_VatAmountLine; "VAT %")                {                    DecimalPlaces = 0 : 5;                }                column(VATPct_VatAmountLine_Lbl; FieldCaption("VAT %"))                {                }                column(NoOfVATIdentifiers; Count)                {                }                trigger OnAfterGetRecord()                begin                    VATBaseLCY :=                      GetBaseLCY(                        Header."Posting Date", Header."Currency Code",                        Header."Currency Factor");                    VATAmountLCY :=                      GetAmountLCY(                        Header."Posting Date", Header."Currency Code",                        Header."Currency Factor");                    TotalVATBaseLCY += VATBaseLCY;                    TotalVATAmountLCY += VATAmountLCY;                end;                trigger OnPreDataItem()                begin                    Clear(VATBaseLCY);                    Clear(VATAmountLCY);                    TotalVATBaseLCY := 0;                    TotalVATAmountLCY := 0;                end;            }            dataitem(ReportTotalsLine; "Report Totals Buffer")            {                DataItemTableView = sorting("Line No.");                UseTemporary = true;                column(Description_ReportTotalsLine; Description)                {                }                column(Amount_ReportTotalsLine; Amount)                {                }                column(AmountFormatted_ReportTotalsLine; "Amount Formatted")                {                }                column(FontBold_ReportTotalsLine; "Font Bold")                {                }                column(FontUnderline_ReportTotalsLine; "Font Underline")                {                }                trigger OnPreDataItem()                begin                    CreateReportTotalLines();                end;            }            dataitem(LetterText; "Integer")            {                DataItemTableView = sorting(Number) where(Number = const(1));                column(GreetingText; GreetingLbl)                {                }                column(BodyText; BodyLbl)                {                }                column(ClosingText; ClosingLbl)                {                }                column(PmtDiscText; PmtDiscText)                {                }                trigger OnPreDataItem()                begin                    PmtDiscText := '';                    if Header."Payment Discount %" <> 0 then                        PmtDiscText := StrSubstNo(PmtDiscTxt, Header."Pmt. Discount Date", Header."Payment Discount %");                end;            }            dataitem(Totals; "Integer")            {                DataItemTableView = sorting(Number) where(Number = const(1));                column(TotalNetAmount; TotalAmount)                {                    AutoFormatExpression = Header."Currency Code";                    AutoFormatType = 1;                }                column(TotalVATBaseLCY; TotalVATBaseLCY)                {                }                column(TotalAmountIncludingVAT; Format(TotalAmountInclVAT, 0, AutoFormat.ResolveAutoFormat(Enum::"Auto Format"::AmountFormat, Header."Currency Code")))                {                    AutoFormatExpression = Header."Currency Code";                    AutoFormatType = 1;                }                column(TotalVATAmount; TotalAmountVAT)                {                    AutoFormatExpression = Header."Currency Code";                    AutoFormatType = 1;                }                column(TotalVATAmountLCY; TotalVATAmountLCY)                {                }                column(TotalInvoiceDiscountAmount; TotalInvDiscAmount)                {                    AutoFormatExpression = Header."Currency Code";                    AutoFormatType = 1;                }                column(TotalPaymentDiscountOnVAT; TotalPaymentDiscOnVAT)                {                }                column(TotalVATAmountText; VATAmountLine.VATAmountText())                {                }                column(TotalExcludingVATText; TotalExclVATText)                {                }                column(TotalIncludingVATText; TotalInclVATText)                {                }                column(TotalSubTotal; TotalSubTotal)                {                    AutoFormatExpression = Header."Currency Code";                    AutoFormatType = 1;                }                column(TotalSubTotalMinusInvoiceDiscount; TotalSubTotal + TotalInvDiscAmount)                {                }                column(TotalText; TotalText)                {                }                column(CurrencyCode; CurrCode)                {                }                column(CurrencySymbol; CurrSymbol)                {                }            }            trigger OnAfterGetRecord()            var                CurrencyExchangeRate: Record "Currency Exchange Rate";                Currency: Record Currency;                GeneralLedgerSetup: Record "General Ledger Setup";                ArchiveManagement: Codeunit ArchiveManagement;                SalesPost: Codeunit "Sales-Post";            begin                FirstLineHasBeenOutput := false;                Clear(Line);                Clear(SalesPost);                VATAmountLine.DeleteAll();                Line.DeleteAll();                SalesPost.GetSalesLines(Header, Line, 0);                OnBeforeCalcVATAmountLines(Header, Line);                Line.CalcVATAmountLines(0, Header, Line, VATAmountLine);                Line.UpdateVATOnLines(0, Header, Line, VATAmountLine);                OnLineOnAfterGetRecordOnAfterUpdateVATOnLines(Header, Line);                if not IsReportInPreviewMode() then                    CODEUNIT.Run(CODEUNIT::"Sales-Printed", Header);                OnHeaderOnAfterGetRecordOnAfterUpdateNoPrinted(IsReportInPreviewMode(), Header);                SetFormatRegion("Format Region");                SetLanguage("Language Code");                FormatAddr.SetLanguageCode("Language Code");                CalcFields("Work Description");                ShowWorkDescription := "Work Description".HasValue;                FormatAddr.GetCompanyAddr("Responsibility Center", RespCenter, CompanyInfo, CompanyAddr);                FormatAddr.SalesHeaderBillTo(CustAddr, Header);                ShowShippingAddr := FormatAddr.SalesHeaderShipTo(ShipToAddr, CustAddr, Header);                if not CompanyBankAccount.Get(Header."Company Bank Account Code") then                    CompanyBankAccount.CopyBankFieldsFromCompanyInfo(CompanyInfo);                if not Cust.Get("Bill-to Customer No.") then                    Clear(Cust);                if "Currency Code" <> '' then begin                    CurrencyExchangeRate.FindCurrency("Posting Date", "Currency Code", 1);                    CalculatedExchRate :=                      Round(1 / "Currency Factor" * CurrencyExchangeRate."Exchange Rate Amount", 0.000001);                    ExchangeRateText := StrSubstNo(ExchangeRateTxt, CalculatedExchRate, CurrencyExchangeRate."Exchange Rate Amount");                    CurrCode := "Currency Code";                    if Currency.Get("Currency Code") then                        CurrSymbol := Currency.GetCurrencySymbol();                end else                    if GeneralLedgerSetup.Get() then begin                        CurrCode := GeneralLedgerSetup."LCY Code";                        CurrSymbol := GeneralLedgerSetup.GetCurrencySymbol();                    end;                FormatDocumentFields(Header);                if SellToContact.Get("Sell-to Contact No.") then;                if BillToContact.Get("Bill-to Contact No.") then;                if not IsReportInPreviewMode() and                   (CurrReport.UseRequestPage and ArchiveDocument or                    not CurrReport.UseRequestPage and (SalesSetup."Archive Quotes" <> SalesSetup."Archive Quotes"::Never))                then                    case SalesSetup."Archive Quotes" of                        SalesSetup."Archive Quotes"::Always:                            ArchiveManagement.ArchSalesDocumentNoConfirm(Header);                        SalesSetup."Archive Quotes"::Question:                            begin                                CurrReport.Language := LanguageMgt.GetLanguageIdOrDefault(LanguageMgt.GetUserLanguageCode());                                ArchiveManagement.ArchiveSalesDocument(Header);                                CurrReport.Language := LanguageMgt.GetLanguageIdOrDefault("Language Code");                            end;                    end;                TotalSubTotal := 0;                TotalInvDiscAmount := 0;                TotalAmount := 0;                TotalAmountVAT := 0;                TotalAmountInclVAT := 0;            end;            trigger OnPreDataItem()            begin                FirstLineHasBeenOutput := false;            end;        }    }    requestpage    {        SaveValues = true;        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(LogInteraction; LogInteraction)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Log Interaction';                        Enabled = LogInteractionEnable;                        ToolTip = 'Specifies that interactions with the contact are logged.';                    }                    field(ArchiveDocument; ArchiveDocument)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Archive Document';                        ToolTip = 'Specifies if the document is archived after you preview or print it.';                        trigger OnValidate()                        begin                            if not ArchiveDocument then                                LogInteraction := false;                        end;                    }                }            }        }        actions        {        }        trigger OnInit()        begin            InitLogInteraction();            LogInteractionEnable := LogInteraction;            ArchiveDocument := SalesSetup."Archive Quotes" <> SalesSetup."Archive Quotes"::Never;        end;    }    rendering    {        layout("StandardSalesQuote.rdlc")        {            Type = RDLC;            LayoutFile = './Sales/Document/StandardSalesQuote.rdlc';            Caption = 'Standard Sales Quote (RDLC)';            Summary = 'The Standard Sales Quote (RDLC) provides a detailed layout.';        }        layout("StandardSalesQuote.docx")        {            Type = Word;            LayoutFile = './Sales/Document/StandardSalesQuote.docx';            Caption = 'Standard Sales Quote (Word)';            Summary = 'The Standard Sales Quote (Word) provides a basic layout.';        }        layout("StandardSalesQuoteBlue.docx")        {            Type = Word;            LayoutFile = './Sales/Document/StandardSalesQuoteBlue.docx';            Caption = 'Standard Sales Quote - Blue (Word)';            Summary = 'The Standard Sales Quote - Blue (Word) provides a basic layout with a blue theme.';        }        layout("StandardSalesQuoteBlueThemable.docx")        {            Type = Word;            LayoutFile = './Sales/Document/StandardSalesQuoteBlueThemable.docx';            Caption = 'Standard Sales Quote - blue themable Word layout';            Summary = 'The Standard Sales Quote - Themable (Word) provides a basic Themable layout.';        }        layout("StandardSalesQuoteEmail.docx")        {            Type = Word;            LayoutFile = './Sales/Document/StandardSalesQuoteEmail.docx';            Caption = 'Standard Sales Quote Email (Word)';            Summary = 'The Standard Sales Quote Email (Word) provides an email body layout.';        }    }    labels    {    }    trigger OnInitReport()    var        SalesHeader: Record "Sales Header";        IsHandled: Boolean;    begin        GLSetup.Get();        CompanyInfo.SetAutoCalcFields(Picture);        CompanyInfo.Get();        SalesSetup.Get();        CompanyInfo.VerifyAndSetPaymentInfo();        if SalesHeader.GetLegalStatement() <> '' then            LegalStatementLbl := SalesHeader.GetLegalStatement();        IsHandled := false;        OnInitReportForGlobalVariable(IsHandled, LegalOfficeTxt, LegalOfficeLbl, CustomGiroTxt, CustomGiroLbl, LegalStatementLbl);    end;    trigger OnPostReport()    begin        if LogInteraction and not IsReportInPreviewMode() then            if Header.FindSet() then                repeat                    Header.CalcFields("No. of Archived Versions");                    if Header."Bill-to Contact No." <> '' then                        SegManagement.LogDocument(                          1, Header."No.", Header."Doc. No. Occurrence",                          Header."No. of Archived Versions", Database::Contact, Header."Bill-to Contact No.",                          Header."Salesperson Code", Header."Campaign No.", Header."Posting Description", Header."Opportunity No.")                    else                        SegManagement.LogDocument(                          1, Header."No.", Header."Doc. No. Occurrence",                          Header."No. of Archived Versions", Database::Customer, Header."Bill-to Customer No.",                          Header."Salesperson Code", Header."Campaign No.", Header."Posting Description", Header."Opportunity No.");                until Header.Next() = 0;    end;    trigger OnPreReport()    begin        if Header.GetFilters = '' then            Error(NoFilterSetErr);        CompanyLogoPosition := SalesSetup."Logo Position on Documents";    end;    var        DummyCompanyInfo: Record "Company Information";        Cust: Record Customer;        LanguageMgt: Codeunit Language;        FormatAddr: Codeunit "Format Address";        FormatDocument: Codeunit "Format Document";        SegManagement: Codeunit SegManagement;        AutoFormat: Codeunit "Auto Format";        WorkDescriptionInstream: InStream;        WorkDescriptionLine: Text;        MoreLines: Boolean;        ShowWorkDescription: Boolean;        CopyText: Text[30];        ShowShippingAddr: Boolean;        LogInteractionEnable: Boolean;        CompanyLogoPosition: Integer;        CalculatedExchRate: Decimal;        ExchangeRateText: Text;        PrevLineAmount: Decimal;        PmtDiscText: Text;        SalesConfirmationLbl: Label 'Sales Quote';        YourEstimateLbl: Label 'Your Estimate';        EstimateLbl: Label 'Estimate';        SalespersonLbl: Label 'Sales person';        CompanyInfoBankAccNoLbl: Label 'Account No.';        CompanyInfoBankNameLbl: Label 'Bank';        CompanyInfoGiroNoLbl: Label 'Giro No.';        CompanyInfoPhoneNoLbl: Label 'Phone No.';        CopyLbl: Label 'Copy';        EMailLbl: Label 'Email';        HomePageLbl: Label 'Home Page';        InvDiscBaseAmtLbl: Label 'Invoice Discount Base Amount';        InvDiscountAmtLbl: Label 'Invoice Discount';        InvNoLbl: Label 'No.';        LineAmtAfterInvDiscLbl: Label 'Payment Discount on VAT';        LocalCurrencyLbl: Label 'Local Currency';        PageLbl: Label 'Page';        PaymentMethodDescLbl: Label 'Payment Method';        PostedShipmentDateLbl: Label 'Shipment Date';        SalesInvLineDiscLbl: Label 'Discount %';        ShipmentLbl: Label 'Shipment';        ShiptoAddrLbl: Label 'Ship-to Address';        SubtotalLbl: Label 'Subtotal';        TotalLbl: Label 'Total';        UnitLbl: Label 'Unit';        VATAmtSpecificationLbl: Label 'VAT Amount Specification';        VATAmtLbl: Label 'VAT Amount';        VATAmountLCYLbl: Label 'VAT Amount (LCY)';        VATBaseLbl: Label 'VAT Base';        VATBaseLCYLbl: Label 'VAT Base (LCY)';        VATClausesLbl: Label 'VAT Clause';        VATIdentifierLbl: Label 'VAT Identifier';        VATPercentageLbl: Label 'VAT %';        ExchangeRateTxt: Label 'Exchange rate: %1/%2', Comment = '%1 and %2 are both amounts.';        NoFilterSetErr: Label 'You must specify one or more filters to avoid accidentally printing all documents.';        FromLbl: Label 'From';        EstimateForLbl: Label 'Estimate for';        QuestionsLbl: Label 'Questions?';        ThanksLbl: Label 'Thank You!';        GreetingLbl: Label 'Hello';        ClosingLbl: Label 'Sincerely';        PmtDiscTxt: Label 'If we receive the payment before %1, you are eligible for a %2% payment discount.', Comment = '%1 = Discount Due Date %2 = value of Payment Discount % ';        BodyLbl: Label 'Thank you for your business. Your quote is attached to this message.';        EstimateBodyLbl: Label 'As promised, here''s our estimate. Please see the attached estimate for details.';        QuoteValidToDateLbl: Label 'Valid to';        QtyLbl: Label 'Qty', Comment = 'Short form of Quantity';        PriceLbl: Label 'Price';        PricePerLbl: Label 'Price per';        SellToContactPhoneNoLbl: Label 'Sell-to Contact Phone No.';        SellToContactMobilePhoneNoLbl: Label 'Sell-to Contact Mobile Phone No.';        SellToContactEmailLbl: Label 'Sell-to Contact E-Mail';        BillToContactPhoneNoLbl: Label 'Bill-to Contact Phone No.';        BillToContactMobilePhoneNoLbl: Label 'Bill-to Contact Mobile Phone No.';        BillToContactEmailLbl: Label 'Bill-to Contact E-Mail';        LCYTxt: label ' (LCY)';        LegalOfficeTxt, LegalOfficeLbl, CustomGiroTxt, CustomGiroLbl, LegalStatementLbl : Text;    protected var        GLSetup: Record "General Ledger Setup";        SalesSetup: Record "Sales & Receivables Setup";        CompanyInfo: Record "Company Information";        RespCenter: Record "Responsibility Center";        SellToContact: Record Contact;        BillToContact: Record Contact;        VATClause: Record "VAT Clause";        CompanyBankAccount: Record "Bank Account";        CustAddr: array[8] of Text[100];        ShipToAddr: array[8] of Text[100];        CompanyAddr: array[8] of Text[100];        CurrCode: Text[10];        CurrSymbol: Text[10];        TotalText: Text[50];        TotalExclVATText: Text[50];        TotalInclVATText: Text[50];        ArchiveDocument: Boolean;        LogInteraction: Boolean;        TotalSubTotal: Decimal;        TotalAmount: Decimal;        TotalAmountInclVAT: Decimal;        TotalAmountVAT: Decimal;        TotalInvDiscAmount: Decimal;        TotalPaymentDiscOnVAT: Decimal;        TransHeaderAmount: Decimal;        ShipmentMethod: Record "Shipment Method";        PaymentTerms: Record "Payment Terms";        PaymentMethod: Record "Payment Method";        SalespersonPurchaser: Record "Salesperson/Purchaser";        FirstLineHasBeenOutput: Boolean;        SalesPersonText: Text[50];        LineDiscountPctText: Text;        FormattedVATPct: Text;        FormattedUnitPrice: Text;        FormattedQuantity: Text;        FormattedLineAmount: Text;        VATBaseLCY: Decimal;        VATAmountLCY: Decimal;        TotalVATBaseLCY: Decimal;        TotalVATAmountLCY: Decimal;        PaymentTermsDescLbl: Label 'Payment Terms';        ShptMethodDescLbl: Label 'Shipment Method';    local procedure InitLogInteraction()    begin        LogInteraction := SegManagement.FindInteractionTemplateCode(Enum::"Interaction Log Entry Document Type"::"Sales Qte.") <> '';    end;    local procedure DocumentCaption(): Text[250]    begin        exit(SalesConfirmationLbl);    end;    /// <summary>    /// Initializes the request parameters for the sales quote report.    /// </summary>    /// <param name="NewLogInteraction">Specifies whether to log interaction.</param>    procedure InitializeRequest(NewLogInteraction: Boolean)    begin        LogInteraction := NewLogInteraction;    end;    protected procedure IsReportInPreviewMode(): Boolean    var        MailManagement: Codeunit "Mail Management";    begin        exit(CurrReport.Preview() or MailManagement.IsHandlingGetEmailBody());    end;    local procedure FormatDocumentFields(SalesHeader: Record "Sales Header")    begin        FormatDocument.SetTotalLabels(SalesHeader.GetCurrencySymbol(), TotalText, TotalInclVATText, TotalExclVATText);        FormatDocument.SetSalesPerson(SalespersonPurchaser, SalesHeader."Salesperson Code", SalesPersonText);        FormatDocument.SetPaymentTerms(PaymentTerms, SalesHeader."Payment Terms Code", SalesHeader."Language Code");        FormatDocument.SetPaymentMethod(PaymentMethod, SalesHeader."Payment Method Code", SalesHeader."Language Code");        FormatDocument.SetShipmentMethod(ShipmentMethod, SalesHeader."Shipment Method Code", SalesHeader."Language Code");        OnAfterFormatDocumentFields(SalesHeader);    end;    local procedure CreateReportTotalLines()    begin        ReportTotalsLine.DeleteAll();        if (TotalInvDiscAmount <> 0) or (TotalAmountVAT <> 0) then            ReportTotalsLine.Add(SubtotalLbl, TotalSubTotal, true, false, false, Header."Currency Code");        if TotalInvDiscAmount <> 0 then begin            ReportTotalsLine.Add(InvDiscountAmtLbl, TotalInvDiscAmount, false, false, false, Header."Currency Code");            if TotalAmountVAT <> 0 then                ReportTotalsLine.Add(TotalExclVATText, TotalAmount, true, false, false, Header."Currency Code");        end;        if TotalAmountVAT <> 0 then begin            ReportTotalsLine.Add(VATAmountLine.VATAmountText(), TotalAmountVAT, false, true, false, Header."Currency Code");            if TotalVATAmountLCY <> TotalAmountVAT then                ReportTotalsLine.Add(VATAmountLine.VATAmountText() + LCYTxt, TotalVATAmountLCY, false, true, false);        end;    end;    local procedure SetFormatRegion(FormatRegion: Text[80])    begin        CurrReport.FormatRegion := LanguageMgt.GetFormatRegionOrDefault(FormatRegion);        OnAfterSetFormatRegion();    end;    local procedure SetLanguage(LanguageCode: Code[10])    begin        CurrReport.Language := LanguageMgt.GetLanguageIdOrDefault(LanguageCode);        OnAfterSetLanguage();    end;    [IntegrationEvent(false, false)]    local procedure OnAfterFormatDocumentFields(var SalesHeader: Record "Sales Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterSetLanguage()    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterSetFormatRegion()    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCalcVATAmountLines(var Header: Record "Sales Header"; var Line: Record "Sales Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnLineOnAfterGetRecordOnAfterUpdateVATOnLines(var SalesHeader: Record "Sales Header"; var SalesLine: Record "Sales Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnInitReportForGlobalVariable(var IsHandled: Boolean; var LegalOfficeTxt: Text; var LegalOfficeLbl: Text; var CustomGiroTxt: Text; var CustomGiroLbl: Text; var LegalStatementLbl: Text)    begin    end;    [IntegrationEvent(true, false)]    local procedure OnHeaderOnAfterGetRecordOnAfterUpdateNoPrinted(ReportInPreviewMode: Boolean; var SalesHeader: Record "Sales Header")    begin    end;}