Report 1304 Standard Sales - Quote
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;}