Report 1305 Standard Sales - Order Conf.
src/Layers/W1/BaseApp/Sales/Document/StandardSalesOrderConf.Report.al1,337 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.Assembly.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.Foundation.UOM;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 order confirmation document to send to customers./// </summary>report 1305 "Standard Sales - Order Conf."{ Caption = 'Sales - Confirmation'; DefaultRenderingLayout = "StandardSalesOrderConf.docx"; PreviewMode = PrintLayout; WordMergeDataItem = Header; dataset { dataitem(Header; "Sales Header") { DataItemTableView = sorting("Document Type", "No.") where("Document Type" = const(Order)); RequestFilterFields = "No.", "Sell-to Customer No.", "No. Printed"; RequestFilterHeading = 'Sales Order'; 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(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(CustomerPostalBarCode; FormatAddr.PostalBarCode(1)) { } column(YourReference; "Your Reference") { } column(YourReference_Lbl; FieldCaption("Your Reference")) { } column(ShipmentMethodDescription; ShipmentMethod.Description) { } column(ShipmentMethodDescription_Lbl; ShptMethodDescLbl) { } column(Shipment_Lbl; ShipmentLbl) { } column(ShipmentDate; Format("Shipment Date", 0, 4)) { } column(ShipmentDate_Lbl; FieldCaption("Shipment Date")) { } 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(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(DocumentNo; "No.") { } column(DocumentNo_Lbl; InvNoLbl) { } column(QuoteNo; "Quote No.") { } column(QuoteNo_Lbl; FieldCaption("Quote No.")) { } column(PricesIncludingVAT; "Prices Including VAT") { } column(PricesIncludingVAT_Lbl; FieldCaption("Prices Including VAT")) { } column(PricesIncludingVATYesNo; Format("Prices Including VAT")) { } column(SalesPerson_Lbl; SalespersonLbl) { } column(SalesPersonText_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(SellToFaxNo; GetSellToCustomerFaxNo()) { } column(SellToPhoneNo; "Sell-to Phone No.") { } column(LegalEntityType; Cust.GetLegalEntityType()) { } column(LegalEntityType_Lbl; Cust.GetLegalEntityTypeLbl()) { } column(Copy_Lbl; CopyLbl) { } column(EMail_Lbl; EMailLbl) { } 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(Invoice_Lbl; SalesConfirmationLbl) { } 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()) { } column(ExtDocNo_SalesHeader; "External Document No.") { } column(ExtDocNo_SalesHeader_Lbl; FieldCaption("External Document No.")) { } column(ShowWorkDescription; ShowWorkDescription) { } 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 = "Currency Code"; AutoFormatType = 1; } column(AmountIncludingVAT_Line_Lbl; FieldCaption("Amount Including VAT")) { AutoFormatExpression = "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(ShipmentDate_Line; Format("Shipment Date")) { } column(ShipmentDate_Line_Lbl; PostedShipmentDateLbl) { } column(PlannedShipmentDate_Line; Format("Planned Shipment Date")) { } column(PlannedShipmentDate_Line_Lbl; FieldCaption("Planned Shipment Date")) { } 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(ItemReferenceNo; "Item Reference No.") { } column(ItemReferenceNo_Lbl; FieldCaption("Item Reference No.")) { } dataitem(AssemblyLine; "Assembly Line") { DataItemTableView = sorting("Document No.", "Line No."); column(LineNo_AssemblyLine; "No.") { } column(Description_AssemblyLine; Description) { } column(Quantity_AssemblyLine; Quantity) { DecimalPlaces = 0 : 5; } column(UnitOfMeasure_AssemblyLine; GetUOMText("Unit of Measure Code")) { } column(VariantCode_AssemblyLine; "Variant Code") { } trigger OnPreDataItem() begin if not DisplayAssemblyInformation then CurrReport.Break(); if not AsmInfoExistsForLine then CurrReport.Break(); SetRange("Document Type", AsmHeader."Document Type"); SetRange("Document No.", AsmHeader."No."); end; } trigger OnAfterGetRecord() begin if (Description = '') and ("No." = '') and (Quantity = 0) and (Amount = 0) then CurrReport.Skip(); if Type = Type::"G/L Account" then "No." := ''; if "Line Discount %" = 0 then LineDiscountPctText := '' else LineDiscountPctText := StrSubstNo('%1%', -Round("Line Discount %", 0.1)); if DisplayAssemblyInformation then AsmInfoExistsForLine := AsmToOrderExists(AsmHeader); 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"); OnLineOnAfterGetRecordOnAfterCalcTotals(Header, Line, TotalAmount, TotalAmountVAT, TotalAmountInclVAT); 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; if "VAT Clause Code" <> '' then begin VATClauseLine := VATAmountLine; if VATClauseLine.Insert() then; end; end; trigger OnPreDataItem() begin Clear(VATBaseLCY); Clear(VATAmountLCY); TotalVATBaseLCY := 0; TotalVATAmountLCY := 0; VATClauseLine.DeleteAll(); end; } dataitem(VATClauseLine; "VAT Amount Line") { DataItemTableView = sorting("VAT Identifier", "VAT Calculation Type", "Tax Group Code", "Use Tax", Positive); UseTemporary = true; column(VATIdentifier_VATClauseLine; "VAT Identifier") { } column(Code_VATClauseLine; VATClause.Code) { } column(Code_VATClauseLine_Lbl; VATClause.FieldCaption(Code)) { } column(Description_VATClauseLine; VATClauseText) { } column(Description2_VATClauseLine; VATClause."Description 2") { } column(VATAmount_VATClauseLine; "VAT Amount") { AutoFormatExpression = Header."Currency Code"; AutoFormatType = 1; } column(NoOfVATClauses; Count) { } trigger OnAfterGetRecord() begin if "VAT Clause Code" = '' then CurrReport.Skip(); if not VATClause.Get("VAT Clause Code") then CurrReport.Skip(); VATClauseText := VATClause.GetDescriptionText(Header); end; } dataitem(ReportTotalsLine; "Report Totals Buffer") { DataItemTableView = sorting("Line No."); UseTemporary = true; column(Description_ReportTotalsLine; Description) { } column(Amount_ReportTotalsLine; Amount) { AutoFormatExpression = Header."Currency Code"; AutoFormatType = 1; } 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"))) { } 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, false); OnLineOnAfterGetRecordOnBeforeCalcVATAmountLines(Header, Line); Line.CalcVATAmountLines(0, Header, Line, VATAmountLine); Line.UpdateVATOnLines(0, Header, Line, VATAmountLine); OnHeaderOnAfterGetRecordOnAfterUpdateVATOnLines(Header, Line, VATAmountLine); if not IsReportInPreviewMode() then CODEUNIT.Run(CODEUNIT::"Sales-Printed", Header); OnHeaderOnAfterGetRecordOnAfterUpdateNoPrinted(IsReportInPreviewMode(), Header); CurrReport.Language := LanguageMgt.GetLanguageIdOrDefault("Language Code"); CurrReport.FormatRegion := LanguageMgt.GetFormatRegionOrDefault("Format Region"); 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 Orders") then ArchiveManagement.StoreSalesDocument(Header, LogInteraction); TotalSubTotal := 0; TotalInvDiscAmount := 0; TotalAmount := 0; TotalAmountVAT := 0; TotalAmountInclVAT := 0; TotalPaymentDiscOnVAT := 0; 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(DisplayAsmInformation; DisplayAssemblyInformation) { ApplicationArea = Assembly; Caption = 'Show Assembly Components'; ToolTip = 'Specifies if you want the report to include information about components that were used in linked assembly orders that supplied the item(s) being sold. (Only possible for RDLC report layout.)'; } field(ArchiveDocument; ArchiveDocument) { ApplicationArea = Basic, Suite; Caption = 'Archive Document'; ToolTip = 'Specifies if the document is archived after you print it.'; trigger OnValidate() begin if not ArchiveDocument then LogInteraction := false; end; } } } } actions { } trigger OnInit() begin InitLogInteraction(); LogInteractionEnable := LogInteraction; ArchiveDocument := SalesSetup."Archive Orders"; OnAfterOnInit(Header); end; } rendering { layout("StandardSalesOrderConf.rdlc") { Type = RDLC; LayoutFile = './Sales/Document/StandardSalesOrderConf.rdlc'; Caption = 'Standard Sales Order Confirmation (RDLC)'; Summary = 'Detailed layout with all fields.'; } layout("StandardSalesOrderConf.docx") { Type = Word; LayoutFile = './Sales/Document/StandardSalesOrderConf.docx'; Caption = 'Standard Sales Order Confirmation (Word)'; Summary = 'Simple layout with most necessary fields.'; } layout("StandardSalesOrderConfThemable.docx") { Type = Word; LayoutFile = './Sales/Document/StandardSalesOrderConfThemable.docx'; Caption = 'Standard Sales Order Confirmation - themable Word layout'; Summary = 'Simple themable layout with most necessary fields.'; } layout("StandardOrderConfirmationEmail.docx") { Type = Word; LayoutFile = './Sales/Document/StandardOrderConfirmationEmail.docx'; Caption = 'Standard Sales Order Confirmation Email (Word)'; Summary = 'Layout intended for an email body.'; } } 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( 3, 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( 3, 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 GLSetup: Record "General Ledger Setup"; DummyCompanyInfo: Record "Company Information"; SalesSetup: Record "Sales & Receivables Setup"; Cust: Record Customer; RespCenter: Record "Responsibility Center"; AsmHeader: Record "Assembly Header"; SellToContact: Record Contact; BillToContact: Record Contact; LanguageMgt: Codeunit Language; FormatAddr: Codeunit "Format Address"; FormatDocument: Codeunit "Format Document"; SegManagement: Codeunit SegManagement; AutoFormat: Codeunit "Auto Format"; WorkDescriptionInstream: InStream; MoreLines: Boolean; CopyText: Text[30]; TransHeaderAmount: Decimal; LogInteractionEnable: Boolean; AsmInfoExistsForLine: Boolean; CompanyLogoPosition: Integer; CalculatedExchRate: Decimal; ExchangeRateText: Text; VATClauseText: Text; PrevLineAmount: Decimal; PmtDiscText: Text; ShowWorkDescription: Boolean; WorkDescriptionLine: Text; 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 'Order No.'; LineAmtAfterInvDiscLbl: Label 'Payment Discount on VAT'; LocalCurrencyLbl: Label 'Local Currency'; PageLbl: Label 'Page'; PostedShipmentDateLbl: Label 'Shipment Date'; ShipmentLbl: Label 'Shipment'; ShiptoAddrLbl: Label 'Ship-to Address'; SubtotalLbl: Label 'Subtotal'; TotalLbl: Label 'Total'; 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.'; 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 order confirmation is attached to this message.'; 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 CompanyInfo: Record "Company Information"; PaymentTerms: Record "Payment Terms"; PaymentMethod: Record "Payment Method"; SalespersonPurchaser: Record "Salesperson/Purchaser"; ShipmentMethod: Record "Shipment Method"; CompanyBankAccount: Record "Bank Account"; VATClause: Record "VAT Clause"; CustAddr: array[8] of Text[100]; ShipToAddr: array[8] of Text[100]; CompanyAddr: array[8] of Text[100]; ArchiveDocument: Boolean; DisplayAssemblyInformation: Boolean; LogInteraction: Boolean; TotalSubTotal: Decimal; TotalAmount: Decimal; TotalAmountInclVAT: Decimal; TotalAmountVAT: Decimal; TotalInvDiscAmount: Decimal; TotalPaymentDiscOnVAT: Decimal; FirstLineHasBeenOutput: Boolean; TotalExclVATText: Text[50]; TotalInclVATText: Text[50]; TotalText: Text[50]; CurrCode: Text[10]; CurrSymbol: Text[10]; FormattedLineAmount: Text; FormattedQuantity: Text; FormattedUnitPrice: Text; FormattedVATPct: Text; LineDiscountPctText: Text; SalesPersonText: Text[50]; ShowShippingAddr: Boolean; VATBaseLCY: Decimal; VATAmountLCY: Decimal; TotalVATBaseLCY: Decimal; TotalVATAmountLCY: Decimal; PaymentTermsDescLbl: Label 'Payment Terms'; PaymentMethodDescLbl: Label 'Payment Method'; SalesConfirmationLbl: Label 'Order Confirmation'; SalesInvLineDiscLbl: Label 'Discount %'; SalespersonLbl: Label 'Sales person'; ShptMethodDescLbl: Label 'Shipment Method'; local procedure InitLogInteraction() begin LogInteraction := SegManagement.FindInteractionTemplateCode(Enum::"Interaction Log Entry Document Type"::"Sales Ord. Cnfrmn.") <> ''; end; local procedure DocumentCaption() DocCaption: Text[250] begin DocCaption := SalesConfirmationLbl; OnAfterDocumentCaption(Header, DocCaption); end; /// <summary> /// Initializes the request parameters for the sales order confirmation report. /// </summary> /// <param name="NewLogInteraction">Specifies whether to log interaction.</param> /// <param name="DisplayAsmInfo">Specifies whether to display assembly information.</param> procedure InitializeRequest(NewLogInteraction: Boolean; DisplayAsmInfo: Boolean) begin LogInteraction := NewLogInteraction; DisplayAssemblyInformation := DisplayAsmInfo; 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."Currency Code", 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 GetUOMText(UOMCode: Code[10]): Text[50] var UnitOfMeasure: Record "Unit of Measure"; begin if not UnitOfMeasure.Get(UOMCode) then exit(UOMCode); exit(UnitOfMeasure.Description); 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; [IntegrationEvent(false, false)] local procedure OnAfterOnInit(var SalesHeader: Record "Sales Header") begin end; [IntegrationEvent(false, false)] local procedure OnAfterDocumentCaption(SalesHeader: Record "Sales Header"; var DocCaption: Text[250]) begin end; [IntegrationEvent(false, false)] local procedure OnHeaderOnAfterGetRecordOnAfterUpdateVATOnLines(var SalesHeader: Record "Sales Header"; var SalesLine: Record "Sales Line"; var VATAmountLine: Record "VAT Amount Line") begin end; [IntegrationEvent(false, false)] local procedure OnLineOnAfterGetRecordOnBeforeCalcVATAmountLines(SalesHeader: Record "Sales Header"; var SalesLine: Record "Sales Line") begin end; [IntegrationEvent(false, false)] local procedure OnLineOnAfterGetRecordOnAfterCalcTotals(var SalesHeader: Record "Sales Header"; var SalesLine: Record "Sales Line"; var VATBaseAmount: Decimal; var VATAmount: Decimal; var TotalAmountInclVAT: Decimal) begin end; [IntegrationEvent(false, false)] local procedure OnAfterFormatDocumentFields(var SalesHeader: Record "Sales Header") 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;}