Report 215 Archived Sales Quote

Base Application, Microsoft.Sales.Archive

src/Layers/W1/BaseApp/Sales/Archive/ArchivedSalesQuote.Report.al1,145 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.Archive;using Microsoft.Bank.BankAccount;using Microsoft.CRM.Team;using Microsoft.Finance.Currency;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Finance.VAT.Calculation;using Microsoft.Foundation.Address;using Microsoft.Foundation.Company;using Microsoft.Foundation.PaymentTerms;using Microsoft.Foundation.Shipping;using Microsoft.Inventory.Location;using Microsoft.Sales.Document;using Microsoft.Sales.Setup;using Microsoft.Utilities;using System.Email;using System.Globalization;using System.Utilities;/// <summary>/// Generates a printable document for an archived sales quote./// </summary>report 215 "Archived Sales Quote"{    Caption = 'Archived Sales Quote';    WordMergeDataItem = "Sales Header Archive";    DefaultRenderingLayout = RDLCLayout;    dataset    {        dataitem("Sales Header Archive"; "Sales Header Archive")        {            DataItemTableView = sorting("Document Type", "No.") where("Document Type" = const(Quote));            RequestFilterFields = "No.", "Sell-to Customer No.", "No. Printed";            RequestFilterHeading = 'Archived Sales Quote';            column(Sales_Header_Archive_Document_Type; "Document Type")            {            }            column(Sales_Header_Archive_No_; "No.")            {            }            column(Sales_Header_Archive_Doc__No__Occurrence; "Doc. No. Occurrence")            {            }            column(Sales_Header_Archive_Version_No_; "Version No.")            {            }            dataitem(CopyLoop; "Integer")            {                DataItemTableView = sorting(Number);                dataitem(PageLoop; "Integer")                {                    DataItemTableView = sorting(Number) where(Number = const(1));                    column(CompanyInfo2_Picture; CompanyInfo2.Picture)                    {                    }                    column(CompanyInfo_Picture; CompanyInfo.Picture)                    {                    }                    column(CompanyInfo1_Picture; CompanyInfo1.Picture)                    {                    }                    column(STRSUBSTNO_Text004_CopyText_; StrSubstNo(Text004, CopyText))                    {                    }                    column(CustAddr_1_; CustAddr[1])                    {                    }                    column(CompanyAddr_1_; CompanyAddr[1])                    {                    }                    column(CustAddr_2_; CustAddr[2])                    {                    }                    column(CompanyAddr_2_; CompanyAddr[2])                    {                    }                    column(CustAddr_3_; CustAddr[3])                    {                    }                    column(CompanyAddr_3_; CompanyAddr[3])                    {                    }                    column(CustAddr_4_; CustAddr[4])                    {                    }                    column(CompanyAddr_4_; CompanyAddr[4])                    {                    }                    column(CustAddr_5_; CustAddr[5])                    {                    }                    column(CompanyInfo__Phone_No__; CompanyInfo."Phone No.")                    {                    }                    column(CustAddr_6_; CustAddr[6])                    {                    }                    column(CompanyInfo__Fax_No__; CompanyInfo."Fax No.")                    {                    }                    column(CompanyInfo__VAT_Registration_No__; CompanyInfo."VAT Registration No.")                    {                    }                    column(CompanyInfo__Giro_No__; CompanyInfo."Giro No.")                    {                    }                    column(CompanyInfo__Bank_Name_; CompanyBankAccount.Name)                    {                    }                    column(CompanyInfo__Bank_Account_No__; CompanyBankAccount."Bank Account No.")                    {                    }                    column(Sales_Header_Archive___Bill_to_Customer_No__; "Sales Header Archive"."Bill-to Customer No.")                    {                    }                    column(FORMAT__Sales_Header_Archive___Document_Date__0_4_; Format("Sales Header Archive"."Document Date", 0, 4))                    {                    }                    column(VATNoText; VATNoText)                    {                    }                    column(Sales_Header_Archive___VAT_Registration_No__; "Sales Header Archive"."VAT Registration No.")                    {                    }                    column(Sales_Header_Archive___Shipment_Date_; Format("Sales Header Archive"."Shipment Date"))                    {                    }                    column(SalesPersonText; SalesPersonText)                    {                    }                    column(SalesPurchPerson_Name; SalesPurchPerson.Name)                    {                    }                    column(Sales_Header_Archive___No__; "Sales Header Archive"."No.")                    {                    }                    column(ReferenceText; ReferenceText)                    {                    }                    column(Sales_Header_Archive___Your_Reference_; "Sales Header Archive"."Your Reference")                    {                    }                    column(CustAddr_7_; CustAddr[7])                    {                    }                    column(CustAddr_8_; CustAddr[8])                    {                    }                    column(CompanyAddr_5_; CompanyAddr[5])                    {                    }                    column(CompanyAddr_6_; CompanyAddr[6])                    {                    }                    column(CompanyAddr_7_; CompanyAddr[7])                    {                    }                    column(CompanyAddr_8_; CompanyAddr[8])                    {                    }                    column(Sales_Header_Archive___Prices_Including_VAT_; "Sales Header Archive"."Prices Including VAT")                    {                    }                    column(STRSUBSTNO_Text011__Sales_Header_Archive___Version_No____Sales_Header_Archive___No__of_Archived_Versions__; StrSubstNo(Text011, "Sales Header Archive"."Version No.", "Sales Header Archive"."No. of Archived Versions"))                    {                    }                    column(PageCaption; StrSubstNo(Text005, ''))                    {                    }                    column(OutputNo; OutputNo)                    {                    }                    column(PricesInclVAT_YesNo; Format("Sales Header Archive"."Prices Including VAT"))                    {                    }                    column(VATBaseDiscountPercent; "Sales Header Archive"."VAT Base Discount %")                    {                    }                    column(PageLoop_Number; Number)                    {                    }                    column(CompanyInfo__Phone_No__Caption; CompanyInfo__Phone_No__CaptionLbl)                    {                    }                    column(CompanyInfo__Fax_No__Caption; CompanyInfo__Fax_No__CaptionLbl)                    {                    }                    column(CompanyInfo__VAT_Registration_No__Caption; CompanyInfo__VAT_Registration_No__CaptionLbl)                    {                    }                    column(CompanyInfo__Giro_No__Caption; CompanyInfo__Giro_No__CaptionLbl)                    {                    }                    column(CompanyInfo__Bank_Name_Caption; CompanyInfo__Bank_Name_CaptionLbl)                    {                    }                    column(CompanyInfo__Bank_Account_No__Caption; CompanyInfo__Bank_Account_No__CaptionLbl)                    {                    }                    column(Sales_Header_Archive___Bill_to_Customer_No__Caption; "Sales Header Archive".FieldCaption("Bill-to Customer No."))                    {                    }                    column(Sales_Header_Archive___Shipment_Date_Caption; Sales_Header_Archive___Shipment_Date_CaptionLbl)                    {                    }                    column(Sales_Header_Archive___No__Caption; Sales_Header_Archive___No__CaptionLbl)                    {                    }                    column(Sales_Header_Archive___Prices_Including_VAT_Caption; "Sales Header Archive".FieldCaption("Prices Including VAT"))                    {                    }                    dataitem(DimensionLoop1; "Integer")                    {                        DataItemLinkReference = "Sales Header Archive";                        DataItemTableView = sorting(Number) where(Number = filter(1 ..));                        column(DimText; DimText)                        {                        }                        column(DimText_Control80; DimText)                        {                        }                        column(DimensionLoop1_Number; Number)                        {                        }                        column(Header_DimensionsCaption; Header_DimensionsCaptionLbl)                        {                        }                        trigger OnAfterGetRecord()                        begin                            if Number = 1 then begin                                if not DimSetEntry1.FindSet() then                                    CurrReport.Break();                            end else                                if not Continue then                                    CurrReport.Break();                            Clear(DimText);                            Continue := false;                            repeat                                OldDimText := DimText;                                if DimText = '' then                                    DimText := StrSubstNo('%1 %2', DimSetEntry1."Dimension Code", DimSetEntry1."Dimension Value Code")                                else                                    DimText :=                                      StrSubstNo(                                        '%1, %2 %3', DimText,                                        DimSetEntry1."Dimension Code", DimSetEntry1."Dimension Value Code");                                if StrLen(DimText) > MaxStrLen(OldDimText) then begin                                    DimText := OldDimText;                                    Continue := true;                                    exit;                                end;                            until DimSetEntry1.Next() = 0;                        end;                        trigger OnPreDataItem()                        begin                            if not ShowInternalInfo then                                CurrReport.Break();                        end;                    }                    dataitem("Sales Line Archive"; "Sales Line Archive")                    {                        DataItemLink = "Document Type" = field("Document Type"), "Document No." = field("No."), "Doc. No. Occurrence" = field("Doc. No. Occurrence"), "Version No." = field("Version No.");                        DataItemLinkReference = "Sales Header Archive";                        DataItemTableView = sorting("Document Type", "Document No.", "Line No.");                        trigger OnPreDataItem()                        begin                            CurrReport.Break();                        end;                    }                    dataitem(RoundLoop; "Integer")                    {                        DataItemTableView = sorting(Number);                        column(SalesLineArchTmp__Line_Amount_; TempSalesLineArchive."Line Amount")                        {                            AutoFormatExpression = "Sales Header Archive"."Currency Code";                            AutoFormatType = 1;                        }                        column(SalesLineArchTmp_Description; TempSalesLineArchive.Description)                        {                        }                        column(RoundLoopBody3Visibility; TempSalesLineArchive.Type = TempSalesLineArchive.Type::" ")                        {                        }                        column(Sales_Line_Archive___No__; "Sales Line Archive"."No.")                        {                        }                        column(Sales_Line_Archive__Description; "Sales Line Archive".Description)                        {                        }                        column(Sales_Line_Archive__Quantity; "Sales Line Archive".Quantity)                        {                        }                        column(Sales_Line_Archive___Unit_of_Measure_; "Sales Line Archive"."Unit of Measure")                        {                        }                        column(Sales_Line_Archive___Line_Amount_; "Sales Line Archive"."Line Amount")                        {                            AutoFormatExpression = "Sales Header Archive"."Currency Code";                            AutoFormatType = 1;                        }                        column(Sales_Line_Archive___Unit_Price_; "Sales Line Archive"."Unit Price")                        {                            AutoFormatExpression = "Sales Header Archive"."Currency Code";                            AutoFormatType = 2;                        }                        column(Sales_Line_Archive___Line_Discount___; "Sales Line Archive"."Line Discount %")                        {                        }                        column(Sales_Line_Archive___Allow_Invoice_Disc__; "Sales Line Archive"."Allow Invoice Disc.")                        {                        }                        column(Sales_Line_Archive___VAT_Identifier_; "Sales Line Archive"."VAT Identifier")                        {                        }                        column(AllowInvoiceDis_YesNo; Format("Sales Line Archive"."Allow Invoice Disc."))                        {                        }                        column(SalesLineNo; "Sales Line Archive"."Line No.")                        {                        }                        column(SalesLineNoText; Format("Sales Line Archive"."Line No."))                        {                        }                        column(RoundLoopBody4Visibility; TempSalesLineArchive.Type <> TempSalesLineArchive.Type::" ")                        {                        }                        column(SalesLineType; Format("Sales Line Archive".Type))                        {                        }                        column(SalesLineArchTmp__Line_Amount__Control84; TempSalesLineArchive."Line Amount")                        {                            AutoFormatExpression = "Sales Header Archive"."Currency Code";                            AutoFormatType = 1;                        }                        column(SalesLineArchTmp__Inv__Discount_Amount_; TempSalesLineArchive."Inv. Discount Amount")                        {                            AutoFormatExpression = "Sales Header Archive"."Currency Code";                            AutoFormatType = 1;                        }                        column(SalesLineArchTmp__Line_Amount__Control61; TempSalesLineArchive."Line Amount")                        {                            AutoFormatExpression = "Sales Header Archive"."Currency Code";                            AutoFormatType = 1;                        }                        column(TotalText; TotalText)                        {                        }                        column(SalesLineArchTmp__Line_Amount__SalesLineArchTmp__Inv__Discount_Amount_; TempSalesLineArchive."Line Amount" - TempSalesLineArchive."Inv. Discount Amount")                        {                            AutoFormatExpression = "Sales Header Archive"."Currency Code";                            AutoFormatType = 1;                        }                        column(VATAmountLine_VATAmountText; TempVATAmountLine.VATAmountText())                        {                        }                        column(TotalExclVATText; TotalExclVATText)                        {                        }                        column(TotalInclVATText; TotalInclVATText)                        {                        }                        column(SalesLineArchTmp__Line_Amount__SalesLineArchTmp__Inv__Discount_Amount__Control88; TempSalesLineArchive."Line Amount" - TempSalesLineArchive."Inv. Discount Amount")                        {                            AutoFormatExpression = "Sales Header Archive"."Currency Code";                            AutoFormatType = 1;                        }                        column(VATAmount; VATAmount)                        {                            AutoFormatExpression = "Sales Header Archive"."Currency Code";                            AutoFormatType = 1;                        }                        column(SalesLineArchTmp__Line_Amount__SalesLineArchTmp__Inv__Discount_Amount____VATAmount; TempSalesLineArchive."Line Amount" - TempSalesLineArchive."Inv. Discount Amount" + VATAmount)                        {                            AutoFormatExpression = "Sales Header Archive"."Currency Code";                            AutoFormatType = 1;                        }                        column(VATDiscountAmount; -VATDiscountAmount)                        {                            AutoFormatExpression = "Sales Header Archive"."Currency Code";                            AutoFormatType = 1;                        }                        column(TotalExclVATText_Control131; TotalExclVATText)                        {                        }                        column(VATAmountLine_VATAmountText_Control132; TempVATAmountLine.VATAmountText())                        {                        }                        column(TotalInclVATText_Control133; TotalInclVATText)                        {                        }                        column(TotalAmountInclVAT; TotalAmountInclVAT)                        {                            AutoFormatExpression = "Sales Header Archive"."Currency Code";                            AutoFormatType = 1;                        }                        column(VATAmount_Control135; VATAmount)                        {                            AutoFormatExpression = "Sales Header Archive"."Currency Code";                            AutoFormatType = 1;                        }                        column(VATBaseAmount; VATBaseAmount)                        {                            AutoFormatExpression = "Sales Header Archive"."Currency Code";                            AutoFormatType = 1;                        }                        column(RoundLoop_Number; Number)                        {                        }                        column(Sales_Line_Archive__DescriptionCaption; "Sales Line Archive".FieldCaption(Description))                        {                        }                        column(Sales_Line_Archive___No__Caption; "Sales Line Archive".FieldCaption("No."))                        {                        }                        column(Sales_Line_Archive__QuantityCaption; "Sales Line Archive".FieldCaption(Quantity))                        {                        }                        column(Sales_Line_Archive___Unit_of_Measure_Caption; "Sales Line Archive".FieldCaption("Unit of Measure"))                        {                        }                        column(Unit_PriceCaption; Unit_PriceCaptionLbl)                        {                        }                        column(Sales_Line_Archive___Line_Discount___Caption; Sales_Line_Archive___Line_Discount___CaptionLbl)                        {                        }                        column(AmountCaption; AmountCaptionLbl)                        {                        }                        column(Sales_Line_Archive___Allow_Invoice_Disc__Caption; "Sales Line Archive".FieldCaption("Allow Invoice Disc."))                        {                        }                        column(Sales_Line_Archive___VAT_Identifier_Caption; Sales_Line_Archive___VAT_Identifier_CaptionLbl)                        {                        }                        column(ContinuedCaption; ContinuedCaptionLbl)                        {                        }                        column(ContinuedCaption_Control83; ContinuedCaption_Control83Lbl)                        {                        }                        column(SalesLineArchTmp__Inv__Discount_Amount_Caption; SalesLineArchTmp__Inv__Discount_Amount_CaptionLbl)                        {                        }                        column(SubtotalCaption; SubtotalCaptionLbl)                        {                        }                        column(VATDiscountAmountCaption; VATDiscountAmountCaptionLbl)                        {                        }                        dataitem(DimensionLoop2; "Integer")                        {                            DataItemTableView = sorting(Number) where(Number = filter(1 ..));                            column(DimText_Control81; DimText)                            {                            }                            column(DimensionLoop2_Number; Number)                            {                            }                            column(Line_DimensionsCaption; Line_DimensionsCaptionLbl)                            {                            }                            trigger OnAfterGetRecord()                            begin                                if Number = 1 then begin                                    if not DimSetEntry2.FindSet() then                                        CurrReport.Break();                                end else                                    if not Continue then                                        CurrReport.Break();                                Clear(DimText);                                Continue := false;                                repeat                                    OldDimText := DimText;                                    if DimText = '' then                                        DimText := StrSubstNo('%1 %2', DimSetEntry2."Dimension Code", DimSetEntry2."Dimension Value Code")                                    else                                        DimText :=                                          StrSubstNo(                                            '%1, %2 %3', DimText,                                            DimSetEntry2."Dimension Code", DimSetEntry2."Dimension Value Code");                                    if StrLen(DimText) > MaxStrLen(OldDimText) then begin                                        DimText := OldDimText;                                        Continue := true;                                        exit;                                    end;                                until DimSetEntry2.Next() = 0;                            end;                            trigger OnPreDataItem()                            begin                                if not ShowInternalInfo then                                    CurrReport.Break();                            end;                        }                        trigger OnAfterGetRecord()                        begin                            if Number = 1 then                                TempSalesLineArchive.Find('-')                            else                                TempSalesLineArchive.Next();                            "Sales Line Archive" := TempSalesLineArchive;                            DimSetEntry2.SetRange("Dimension Set ID", "Sales Line Archive"."Dimension Set ID");                        end;                        trigger OnPostDataItem()                        begin                            TempSalesLineArchive.DeleteAll();                        end;                        trigger OnPreDataItem()                        begin                            MoreLines := TempSalesLineArchive.Find('+');                            while MoreLines and (TempSalesLineArchive.Description = '') and (TempSalesLineArchive."Description 2" = '') and                                  (TempSalesLineArchive."No." = '') and (TempSalesLineArchive.Quantity = 0) and                                  (TempSalesLineArchive.Amount = 0)                            do                                MoreLines := TempSalesLineArchive.Next(-1) <> 0;                            if not MoreLines then                                CurrReport.Break();                            TempSalesLineArchive.SetRange("Line No.", 0, TempSalesLineArchive."Line No.");                            SetRange(Number, 1, TempSalesLineArchive.Count);                        end;                    }                    dataitem(VATCounter; "Integer")                    {                        DataItemTableView = sorting(Number);                        column(VATAmountLine__VAT_Base_; TempVATAmountLine."VAT Base")                        {                            AutoFormatExpression = "Sales Header Archive"."Currency Code";                            AutoFormatType = 1;                        }                        column(VATAmountLine__VAT_Amount_; TempVATAmountLine."VAT Amount")                        {                            AutoFormatExpression = "Sales Header Archive"."Currency Code";                            AutoFormatType = 1;                        }                        column(VATAmountLine__Line_Amount_; TempVATAmountLine."Line Amount")                        {                            AutoFormatExpression = "Sales Header Archive"."Currency Code";                            AutoFormatType = 1;                        }                        column(VATAmountLine__Inv__Disc__Base_Amount_; TempVATAmountLine."Inv. Disc. Base Amount")                        {                            AutoFormatExpression = "Sales Header Archive"."Currency Code";                            AutoFormatType = 1;                        }                        column(VATAmountLine__Invoice_Discount_Amount_; TempVATAmountLine."Invoice Discount Amount")                        {                            AutoFormatExpression = "Sales Header Archive"."Currency Code";                            AutoFormatType = 1;                        }                        column(VATAmountLine__VAT_Amount__Control69; TempVATAmountLine."VAT Amount")                        {                            AutoFormatExpression = "Sales Header Archive"."Currency Code";                            AutoFormatType = 1;                        }                        column(VATAmountLine__VAT_Base__Control70; TempVATAmountLine."VAT Base")                        {                            AutoFormatExpression = "Sales Line Archive"."Currency Code";                            AutoFormatType = 1;                        }                        column(VATAmountLine__Invoice_Discount_Amount__Control71; TempVATAmountLine."Invoice Discount Amount")                        {                            AutoFormatExpression = "Sales Header Archive"."Currency Code";                            AutoFormatType = 1;                        }                        column(VATAmountLine__Inv__Disc__Base_Amount__Control72; TempVATAmountLine."Inv. Disc. Base Amount")                        {                            AutoFormatExpression = "Sales Header Archive"."Currency Code";                            AutoFormatType = 1;                        }                        column(VATAmountLine__Line_Amount__Control73; TempVATAmountLine."Line Amount")                        {                            AutoFormatExpression = "Sales Header Archive"."Currency Code";                            AutoFormatType = 1;                        }                        column(VATAmountLine__VAT___; TempVATAmountLine."VAT %")                        {                            DecimalPlaces = 0 : 5;                        }                        column(VATAmountLine__VAT_Identifier_; TempVATAmountLine."VAT Identifier")                        {                        }                        column(VATAmountLine__VAT_Base__Control110; TempVATAmountLine."VAT Base")                        {                            AutoFormatExpression = "Sales Header Archive"."Currency Code";                            AutoFormatType = 1;                        }                        column(VATAmountLine__VAT_Amount__Control111; TempVATAmountLine."VAT Amount")                        {                            AutoFormatExpression = "Sales Header Archive"."Currency Code";                            AutoFormatType = 1;                        }                        column(VATAmountLine__Line_Amount__Control97; TempVATAmountLine."Line Amount")                        {                            AutoFormatExpression = "Sales Header Archive"."Currency Code";                            AutoFormatType = 1;                        }                        column(VATAmountLine__Inv__Disc__Base_Amount__Control98; TempVATAmountLine."Inv. Disc. Base Amount")                        {                            AutoFormatExpression = "Sales Header Archive"."Currency Code";                            AutoFormatType = 1;                        }                        column(VATAmountLine__Invoice_Discount_Amount__Control99; TempVATAmountLine."Invoice Discount Amount")                        {                            AutoFormatExpression = "Sales Header Archive"."Currency Code";                            AutoFormatType = 1;                        }                        column(VATAmountLine__VAT_Base__Control114; TempVATAmountLine."VAT Base")                        {                            AutoFormatExpression = "Sales Header Archive"."Currency Code";                            AutoFormatType = 1;                        }                        column(VATAmountLine__VAT_Amount__Control115; TempVATAmountLine."VAT Amount")                        {                            AutoFormatExpression = "Sales Header Archive"."Currency Code";                            AutoFormatType = 1;                        }                        column(VATAmountLine__Line_Amount__Control100; TempVATAmountLine."Line Amount")                        {                            AutoFormatExpression = "Sales Header Archive"."Currency Code";                            AutoFormatType = 1;                        }                        column(VATAmountLine__Inv__Disc__Base_Amount__Control104; TempVATAmountLine."Inv. Disc. Base Amount")                        {                            AutoFormatExpression = "Sales Header Archive"."Currency Code";                            AutoFormatType = 1;                        }                        column(VATAmountLine__Invoice_Discount_Amount__Control105; TempVATAmountLine."Invoice Discount Amount")                        {                            AutoFormatExpression = "Sales Header Archive"."Currency Code";                            AutoFormatType = 1;                        }                        column(VATCounter_Number; Number)                        {                        }                        column(VATAmountLine__VAT___Caption; VATAmountLine__VAT___CaptionLbl)                        {                        }                        column(VATAmountLine__VAT_Base__Control70Caption; VATAmountLine__VAT_Base__Control70CaptionLbl)                        {                        }                        column(VATAmountLine__VAT_Amount__Control69Caption; VATAmountLine__VAT_Amount__Control69CaptionLbl)                        {                        }                        column(VAT_Amount_SpecificationCaption; VAT_Amount_SpecificationCaptionLbl)                        {                        }                        column(VATAmountLine__Line_Amount__Control73Caption; VATAmountLine__Line_Amount__Control73CaptionLbl)                        {                        }                        column(VATAmountLine__Inv__Disc__Base_Amount__Control72Caption; VATAmountLine__Inv__Disc__Base_Amount__Control72CaptionLbl)                        {                        }                        column(VATAmountLine__Invoice_Discount_Amount__Control71Caption; VATAmountLine__Invoice_Discount_Amount__Control71CaptionLbl)                        {                        }                        column(VATAmountLine__VAT_Identifier_Caption; VATAmountLine__VAT_Identifier_CaptionLbl)                        {                        }                        column(VATAmountLine__VAT_Base_Caption; VATAmountLine__VAT_Base_CaptionLbl)                        {                        }                        column(VATAmountLine__VAT_Base__Control110Caption; VATAmountLine__VAT_Base__Control110CaptionLbl)                        {                        }                        column(VATAmountLine__VAT_Base__Control114Caption; VATAmountLine__VAT_Base__Control114CaptionLbl)                        {                        }                        trigger OnAfterGetRecord()                        begin                            TempVATAmountLine.GetLine(Number);                        end;                        trigger OnPreDataItem()                        begin                            if VATAmount = 0 then                                CurrReport.Break();                            SetRange(Number, 1, TempVATAmountLine.Count);                        end;                    }                    dataitem(VATCounterLCY; "Integer")                    {                        DataItemTableView = sorting(Number);                        column(VALExchRate; VALExchRate)                        {                        }                        column(VALSpecLCYHeader; VALSpecLCYHeader)                        {                        }                        column(VALVATBaseLCY; VALVATBaseLCY)                        {                            AutoFormatType = 1;                        }                        column(VALVATAmountLCY; VALVATAmountLCY)                        {                            AutoFormatType = 1;                        }                        column(VALVATAmountLCY_Control152; VALVATAmountLCY)                        {                            AutoFormatType = 1;                        }                        column(VALVATBaseLCY_Control153; VALVATBaseLCY)                        {                            AutoFormatType = 1;                        }                        column(VATAmountLine__VAT____Control154; TempVATAmountLine."VAT %")                        {                            DecimalPlaces = 0 : 5;                        }                        column(VATAmountLine__VAT_Identifier__Control155; TempVATAmountLine."VAT Identifier")                        {                        }                        column(VALVATAmountLCY_Control156; VALVATAmountLCY)                        {                            AutoFormatType = 1;                        }                        column(VALVATBaseLCY_Control157; VALVATBaseLCY)                        {                            AutoFormatType = 1;                        }                        column(VALVATAmountLCY_Control159; VALVATAmountLCY)                        {                            AutoFormatType = 1;                        }                        column(VALVATBaseLCY_Control160; VALVATBaseLCY)                        {                            AutoFormatType = 1;                        }                        column(VATCounterLCY_Number; Number)                        {                        }                        column(VALVATAmountLCY_Control152Caption; VALVATAmountLCY_Control152CaptionLbl)                        {                        }                        column(VALVATBaseLCY_Control153Caption; VALVATBaseLCY_Control153CaptionLbl)                        {                        }                        column(VATAmountLine__VAT____Control154Caption; VATAmountLine__VAT____Control154CaptionLbl)                        {                        }                        column(VATAmountLine__VAT_Identifier__Control155Caption; VATAmountLine__VAT_Identifier__Control155CaptionLbl)                        {                        }                        column(VALVATBaseLCYCaption; VALVATBaseLCYCaptionLbl)                        {                        }                        column(VALVATBaseLCY_Control157Caption; VALVATBaseLCY_Control157CaptionLbl)                        {                        }                        column(VALVATBaseLCY_Control160Caption; VALVATBaseLCY_Control160CaptionLbl)                        {                        }                        trigger OnAfterGetRecord()                        begin                            TempVATAmountLine.GetLine(Number);                            VALVATBaseLCY :=                              TempVATAmountLine.GetBaseLCY(                                "Sales Header Archive"."Posting Date", "Sales Header Archive"."Currency Code",                                "Sales Header Archive"."Currency Factor");                            VALVATAmountLCY :=                              TempVATAmountLine.GetAmountLCY(                                "Sales Header Archive"."Posting Date", "Sales Header Archive"."Currency Code",                                "Sales Header Archive"."Currency Factor");                        end;                        trigger OnPreDataItem()                        begin                            if (not GLSetup."Print VAT specification in LCY") or                               ("Sales Header Archive"."Currency Code" = '') or                               (TempVATAmountLine.GetTotalVATAmount() = 0)                            then                                CurrReport.Break();                            SetRange(Number, 1, TempVATAmountLine.Count);                            Clear(VALVATBaseLCY);                            Clear(VALVATAmountLCY);                            if GLSetup."LCY Code" = '' then                                VALSpecLCYHeader := Text008 + Text009                            else                                VALSpecLCYHeader := Text008 + Format(GLSetup."LCY Code");                            CurrExchRate.FindCurrency("Sales Header Archive"."Order Date", "Sales Header Archive"."Currency Code", 1);                            VALExchRate := StrSubstNo(Text010, CurrExchRate."Relational Exch. Rate Amount", CurrExchRate."Exchange Rate Amount");                        end;                    }                    dataitem(Total; "Integer")                    {                        DataItemTableView = sorting(Number) where(Number = const(1));                        column(PaymentTerms_Description; PaymentTerms.Description)                        {                        }                        column(ShipmentMethod_Description; ShipmentMethod.Description)                        {                        }                        column(Total_Number; Number)                        {                        }                        column(PaymentTerms_DescriptionCaption; PaymentTerms_DescriptionCaptionLbl)                        {                        }                        column(ShipmentMethod_DescriptionCaption; ShipmentMethod_DescriptionCaptionLbl)                        {                        }                    }                    dataitem(Total2; "Integer")                    {                        DataItemTableView = sorting(Number) where(Number = const(1));                        column(Sales_Header_Archive___Sell_to_Customer_No__; "Sales Header Archive"."Sell-to Customer No.")                        {                        }                        column(ShipToAddr_1_; ShipToAddr[1])                        {                        }                        column(ShipToAddr_2_; ShipToAddr[2])                        {                        }                        column(ShipToAddr_3_; ShipToAddr[3])                        {                        }                        column(ShipToAddr_4_; ShipToAddr[4])                        {                        }                        column(ShipToAddr_5_; ShipToAddr[5])                        {                        }                        column(ShipToAddr_6_; ShipToAddr[6])                        {                        }                        column(ShipToAddr_7_; ShipToAddr[7])                        {                        }                        column(ShipToAddr_8_; ShipToAddr[8])                        {                        }                        column(Total2_Number; Number)                        {                        }                        column(Ship_to_AddressCaption; Ship_to_AddressCaptionLbl)                        {                        }                        column(Sales_Header_Archive___Sell_to_Customer_No__Caption; "Sales Header Archive".FieldCaption("Sell-to Customer No."))                        {                        }                        trigger OnPreDataItem()                        begin                            if not ShowShippingAddr then                                CurrReport.Break();                        end;                    }                }                trigger OnAfterGetRecord()                var                    TempSalesHeader: Record "Sales Header" temporary;                    TempSalesLine: Record "Sales Line" temporary;                begin                    InitTempLines(TempSalesHeader, TempSalesLine);                    VATAmount := TempVATAmountLine.GetTotalVATAmount();                    VATBaseAmount := TempVATAmountLine.GetTotalVATBase();                    VATDiscountAmount :=                      TempVATAmountLine.GetTotalVATDiscount(TempSalesHeader."Currency Code", TempSalesHeader."Prices Including VAT");                    TotalAmountInclVAT := TempVATAmountLine.GetTotalAmountInclVAT();                    if Number > 1 then begin                        CopyText := FormatDocument.GetCOPYText();                        OutputNo += 1;                    end;                end;                trigger OnPostDataItem()                begin                    if not IsReportInPreviewMode() then                        CODEUNIT.Run(CODEUNIT::"SalesCount-PrintedArch", "Sales Header Archive");                end;                trigger OnPreDataItem()                begin                    NoOfLoops := Abs(NoOfCopies) + 1;                    CopyText := '';                    SetRange(Number, 1, NoOfLoops);                    OutputNo := 1;                end;            }            trigger OnAfterGetRecord()            begin                CurrReport.Language := LanguageMgt.GetLanguageIdOrDefault("Language Code");                CurrReport.FormatRegion := LanguageMgt.GetFormatRegionOrDefault("Format Region");                FormatAddr.SetLanguageCode("Language Code");                FormatAddressFields("Sales Header Archive");                FormatDocumentFields("Sales Header Archive");                if not CompanyBankAccount.Get("Sales Header Archive"."Company Bank Account Code") then                    CompanyBankAccount.CopyBankFieldsFromCompanyInfo(CompanyInfo);                DimSetEntry1.SetRange("Dimension Set ID", "Dimension Set ID");                CalcFields("No. of Archived Versions");            end;        }    }    requestpage    {        SaveValues = true;        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(NoOfCopies; NoOfCopies)                    {                        ApplicationArea = Suite;                        Caption = 'No. of Copies';                        ToolTip = 'Specifies how many copies of the document to print.';                    }                    field(ShowInternalInfo; ShowInternalInfo)                    {                        ApplicationArea = Suite;                        Caption = 'Show Internal Information';                        ToolTip = 'Specifies if you want the printed report to show information that is only for internal use.';                    }                }            }        }        actions        {        }    }    rendering    {        layout(RDLCLayout)        {            Type = RDLC;            LayoutFile = './Sales/Archive/ArchivedSalesQuote.rdlc';            Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.';        }    }    labels    {    }    trigger OnInitReport()    begin        GLSetup.Get();        CompanyInfo.Get();        SalesSetup.Get();        case SalesSetup."Logo Position on Documents" of            SalesSetup."Logo Position on Documents"::"No Logo":                ;            SalesSetup."Logo Position on Documents"::Left:                CompanyInfo.CalcFields(Picture);            SalesSetup."Logo Position on Documents"::Center:                begin                    CompanyInfo1.Get();                    CompanyInfo1.CalcFields(Picture);                end;            SalesSetup."Logo Position on Documents"::Right:                begin                    CompanyInfo2.Get();                    CompanyInfo2.CalcFields(Picture);                end;        end;    end;    var        GLSetup: Record "General Ledger Setup";        ShipmentMethod: Record "Shipment Method";        PaymentTerms: Record "Payment Terms";        SalesPurchPerson: Record "Salesperson/Purchaser";        CompanyBankAccount: Record "Bank Account";        SalesSetup: Record "Sales & Receivables Setup";        TempVATAmountLine: Record "VAT Amount Line" temporary;        TempSalesLineArchive: Record "Sales Line Archive" temporary;        DimSetEntry1: Record "Dimension Set Entry";        DimSetEntry2: Record "Dimension Set Entry";        RespCenter: Record "Responsibility Center";        CurrExchRate: Record "Currency Exchange Rate";        LanguageMgt: Codeunit Language;        FormatAddr: Codeunit "Format Address";        FormatDocument: Codeunit "Format Document";        CustAddr: array[8] of Text[100];        ShipToAddr: array[8] of Text[100];        CompanyAddr: array[8] of Text[100];        SalesPersonText: Text[50];        VATNoText: Text[80];        ReferenceText: Text[80];        TotalText: Text[50];        TotalExclVATText: Text[50];        TotalInclVATText: Text[50];        MoreLines: Boolean;        NoOfCopies: Integer;        NoOfLoops: Integer;        CopyText: Text[30];        ShowShippingAddr: Boolean;        DimText: Text[120];        OldDimText: Text[75];        ShowInternalInfo: Boolean;        Continue: Boolean;        VATAmount: Decimal;        VATBaseAmount: Decimal;        VATDiscountAmount: Decimal;        TotalAmountInclVAT: Decimal;        VALVATBaseLCY: Decimal;        VALVATAmountLCY: Decimal;        VALSpecLCYHeader: Text[80];        VALExchRate: Text[50];        OutputNo: Integer;#pragma warning disable AA0074        Text004: Label 'Sales - Quote Archived %1', Comment = '%1 = Document No.';#pragma warning disable AA0470        Text005: Label 'Page %1';#pragma warning restore AA0470        Text008: Label 'VAT Amount Specification in ';        Text009: Label 'Local Currency';#pragma warning disable AA0470        Text010: Label 'Exchange rate: %1/%2';        Text011: Label 'Version %1 of %2';#pragma warning restore AA0470#pragma warning restore AA0074        CompanyInfo__Phone_No__CaptionLbl: Label 'Phone No.';        CompanyInfo__Fax_No__CaptionLbl: Label 'Fax No.';        CompanyInfo__VAT_Registration_No__CaptionLbl: Label 'VAT Reg. No.';        CompanyInfo__Giro_No__CaptionLbl: Label 'Giro No.';        CompanyInfo__Bank_Name_CaptionLbl: Label 'Bank';        CompanyInfo__Bank_Account_No__CaptionLbl: Label 'Account No.';        Sales_Header_Archive___Shipment_Date_CaptionLbl: Label 'Shipment Date';        Sales_Header_Archive___No__CaptionLbl: Label 'Quote No.';        Header_DimensionsCaptionLbl: Label 'Header Dimensions';        Unit_PriceCaptionLbl: Label 'Unit Price';        Sales_Line_Archive___Line_Discount___CaptionLbl: Label 'Disc. %';        AmountCaptionLbl: Label 'Amount';        Sales_Line_Archive___VAT_Identifier_CaptionLbl: Label 'VAT Identifier';        ContinuedCaptionLbl: Label 'Continued';        ContinuedCaption_Control83Lbl: Label 'Continued';        SalesLineArchTmp__Inv__Discount_Amount_CaptionLbl: Label 'Inv. Discount Amount';        SubtotalCaptionLbl: Label 'Subtotal';        VATDiscountAmountCaptionLbl: Label 'Payment Discount on VAT';        Line_DimensionsCaptionLbl: Label 'Line Dimensions';        VATAmountLine__VAT___CaptionLbl: Label 'VAT %';        VATAmountLine__VAT_Base__Control70CaptionLbl: Label 'VAT Base';        VATAmountLine__VAT_Amount__Control69CaptionLbl: Label 'VAT Amount';        VAT_Amount_SpecificationCaptionLbl: Label 'VAT Amount Specification';        VATAmountLine__Line_Amount__Control73CaptionLbl: Label 'Line Amount';        VATAmountLine__Inv__Disc__Base_Amount__Control72CaptionLbl: Label 'Inv. Disc. Base Amount';        VATAmountLine__Invoice_Discount_Amount__Control71CaptionLbl: Label 'Invoice Discount Amount';        VATAmountLine__VAT_Identifier_CaptionLbl: Label 'VAT Identifier';        VATAmountLine__VAT_Base_CaptionLbl: Label 'Continued';        VATAmountLine__VAT_Base__Control110CaptionLbl: Label 'Continued';        VATAmountLine__VAT_Base__Control114CaptionLbl: Label 'Total';        VALVATAmountLCY_Control152CaptionLbl: Label 'VAT Amount';        VALVATBaseLCY_Control153CaptionLbl: Label 'VAT Base';        VATAmountLine__VAT____Control154CaptionLbl: Label 'VAT %';        VATAmountLine__VAT_Identifier__Control155CaptionLbl: Label 'VAT Identifier';        VALVATBaseLCYCaptionLbl: Label 'Continued';        VALVATBaseLCY_Control157CaptionLbl: Label 'Continued';        VALVATBaseLCY_Control160CaptionLbl: Label 'Total';        PaymentTerms_DescriptionCaptionLbl: Label 'Payment Terms';        ShipmentMethod_DescriptionCaptionLbl: Label 'Shipment Method';        Ship_to_AddressCaptionLbl: Label 'Ship-to Address';    protected var        CompanyInfo: Record "Company Information";        CompanyInfo1: Record "Company Information";        CompanyInfo2: Record "Company Information";    local procedure IsReportInPreviewMode(): Boolean    var        MailManagement: Codeunit "Mail Management";    begin        exit(CurrReport.Preview or MailManagement.IsHandlingGetEmailBody());    end;    local procedure FormatAddressFields(var SalesHeaderArchive: Record "Sales Header Archive")    begin        FormatAddr.GetCompanyAddr(SalesHeaderArchive."Responsibility Center", RespCenter, CompanyInfo, CompanyAddr);        FormatAddr.SalesHeaderArchBillTo(CustAddr, SalesHeaderArchive);        ShowShippingAddr := FormatAddr.SalesHeaderArchShipTo(ShipToAddr, CustAddr, SalesHeaderArchive);    end;    local procedure FormatDocumentFields(SalesHeaderArchive: Record "Sales Header Archive")    begin        FormatDocument.SetTotalLabels(SalesHeaderArchive."Currency Code", TotalText, TotalInclVATText, TotalExclVATText);        FormatDocument.SetSalesPerson(SalesPurchPerson, SalesHeaderArchive."Salesperson Code", SalesPersonText);        FormatDocument.SetPaymentTerms(PaymentTerms, SalesHeaderArchive."Payment Terms Code", SalesHeaderArchive."Language Code");        FormatDocument.SetShipmentMethod(ShipmentMethod, SalesHeaderArchive."Shipment Method Code", SalesHeaderArchive."Language Code");        ReferenceText := FormatDocument.SetText(SalesHeaderArchive."Your Reference" <> '', SalesHeaderArchive.FieldCaption("Your Reference"));        VATNoText := FormatDocument.SetText(SalesHeaderArchive."VAT Registration No." <> '', SalesHeaderArchive.FieldCaption("VAT Registration No."));    end;    local procedure InitTempLines(var TempSalesHeader: Record "Sales Header" temporary; var TempSalesLine: Record "Sales Line" temporary)    var        SalesLineArchive: Record "Sales Line Archive";    begin        Clear(TempSalesLineArchive);        TempSalesLineArchive.DeleteAll();        SalesLineArchive.SetRange("Document Type", "Sales Header Archive"."Document Type");        SalesLineArchive.SetRange("Document No.", "Sales Header Archive"."No.");        SalesLineArchive.SetRange("Version No.", "Sales Header Archive"."Version No.");        if SalesLineArchive.FindSet() then            repeat                TempSalesLineArchive := SalesLineArchive;                TempSalesLineArchive.Insert();                TempSalesLine.TransferFields(SalesLineArchive);                TempSalesLine.Insert();            until SalesLineArchive.Next() = 0;        TempSalesHeader.TransferFields("Sales Header Archive");        TempSalesLine."Prepayment Line" := true;  // used as flag in CalcVATAmountLines -> not invoice rounding        TempSalesLine.CalcVATAmountLines(0, TempSalesHeader, TempSalesLine, TempVATAmountLine);    end;}