Report 1305 Standard Sales - Order Conf.

Base Application, Microsoft.Sales.Document

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;}