Report 215 Archived Sales Quote
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;}