Report 5913 Service - Shipment
src/Layers/W1/BaseApp/Service/History/ServiceShipment.Report.al754 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.Service.History;using Microsoft.Bank.BankAccount;using Microsoft.CRM.Team;using Microsoft.Finance.Dimension;using Microsoft.Foundation.Address;using Microsoft.Foundation.Company;using Microsoft.Inventory.Location;using Microsoft.Inventory.Reports;using Microsoft.Inventory.Tracking;using Microsoft.Service.Setup;using Microsoft.Utilities;using System.Email;using System.Globalization;using System.Utilities;report 5913 "Service - Shipment"{ DefaultLayout = RDLC; RDLCLayout = './Service/History/ServiceShipment.rdlc'; Caption = 'Service - Shipment'; WordMergeDataItem = "Service Shipment Header"; dataset { dataitem("Service Shipment Header"; "Service Shipment Header") { DataItemTableView = sorting("No."); RequestFilterFields = "No.", "Customer No.", "No. Printed"; RequestFilterHeading = 'Posted Service Shipment'; column(No_ServiceShptHrd; "No.") { } column(DocumentDate; DocumentDateLbl) { } column(EmailIdCaption; EmailIdCaptionLbl) { } column(HomePageCaption; HomePageCaptionLbl) { } column(SrvcShipHeaderCustNoCaption; SrvcShipHeaderCustNoCaptionLbl) { } column(WarrantyCaption; WarrantyCaptionLbl) { } dataitem(CopyLoop; "Integer") { DataItemTableView = sorting(Number); dataitem(PageLoop; "Integer") { DataItemTableView = sorting(Number) where(Number = const(1)); column(CompanyInfo2Picture; CompanyInfo2.Picture) { } column(CompanyInfo1Picture; CompanyInfo1.Picture) { } column(CompanyInfo3Picture; CompanyInfo3.Picture) { } column(ServiceShptCopyText; StrSubstNo(Text002, CopyText)) { } column(ShipToAddr1; ShipToAddr[1]) { } column(CompanyAddr1; CompanyAddr[1]) { } column(ShipToAddr2; ShipToAddr[2]) { } column(CompanyAddr2; CompanyAddr[2]) { } column(ShipToAddr3; ShipToAddr[3]) { } column(CompanyAddr3; CompanyAddr[3]) { } column(ShipToAddr4; ShipToAddr[4]) { } column(CompanyAddr4; CompanyAddr[4]) { } column(ShipToAddr5; ShipToAddr[5]) { } column(PhoneNo_CompanyInfo; CompanyInfo."Phone No.") { } column(ShipToAddr6; ShipToAddr[6]) { } column(HomePage; CompanyInfo."Home Page") { } column(EMailId; CompanyInfo."E-Mail") { } column(CompanyInfoVATRegnNo; CompanyInfo."VAT Registration No.") { } column(CompanyInfoGiroNo; CompanyInfo."Giro No.") { } column(CompanyInfoBankName; CompanyBankAccount.Name) { } column(CompanyInfoBankAccNo; CompanyBankAccount."Bank Account No.") { } column(CustNo_ServShptHrd; "Service Shipment Header"."Customer No.") { } column(ServShptHrdDocDt; Format("Service Shipment Header"."Document Date")) { } column(SalesPersonText; SalesPersonText) { } column(SalesPurchPersonName; SalesPurchPerson.Name) { } column(No1_ServiceShptHrd; "Service Shipment Header"."No.") { } column(ReferenceText; ReferenceText) { } column(YourRef_ServShptHrd; "Service Shipment Header"."Your Reference") { } column(ShipToAddr7; ShipToAddr[7]) { } column(ShipToAddr8; ShipToAddr[8]) { } column(CompanyAddr5; CompanyAddr[5]) { } column(CompanyAddr6; CompanyAddr[6]) { } column(CompanyAddr7; CompanyAddr[7]) { } column(CompanyAddr8; CompanyAddr[8]) { } column(PostingDate_ServShptHrd; Format("Service Shipment Header"."Posting Date")) { } column(PageCaption; StrSubstNo(Text003, '')) { } column(OutputNo; OutputNo) { } column(ItemTrackingAppendixCaption; ItemTrackingAppendixCaptionLbl) { } column(PhoneNoCaption; PhoneNoCaptionLbl) { } column(VATRegNoCaption; VATRegNoCaptionLbl) { } column(GiroNoCaption; GiroNoCaptionLbl) { } column(BankNameCaption; BankNameCaptionLbl) { } column(BankAccNoCaption; BankAccNoCaptionLbl) { } column(ServiceShpHdrNoCaption; ServiceShpHdrNoCaptionLbl) { } column(ServiceShpHdrPostingDateCaption; ServiceShpHdrPostingDateCaptionLbl) { } column(CustNo_ServShptHrdCaption; "Service Shipment Header".FieldCaption("Customer No.")) { } dataitem(DimensionLoop1; "Integer") { DataItemLinkReference = "Service Shipment Header"; DataItemTableView = sorting(Number); column(DimText; DimText) { } column(DimensionLoop1Number; Number) { } column(HdrDimsCaption; HdrDimsCaptionLbl) { } trigger OnAfterGetRecord() begin DimText := DimTxtArr[Number]; end; trigger OnPreDataItem() begin if not ShowInternalInfo then CurrReport.Break(); FindDimTxt("Service Shipment Header"."Dimension Set ID"); SetRange(Number, 1, DimTxtArrLength); end; } dataitem("Service Shipment Item Line"; "Service Shipment Item Line") { DataItemLink = "No." = field("No."); DataItemLinkReference = "Service Shipment Header"; DataItemTableView = sorting("No.", "Line No."); column(ContractNo_ServShptItemLn; "Contract No.") { } column(Des_ServShptItemLn; Description) { } column(SerialNo_ServShptItemLn; "Serial No.") { } column(ItemNo_ServShptItemLn; "Item No.") { } column(ItemGrpCode_ServShptLn; "Service Item Group Code") { } column(ServItemNo_ServShptItemLn; "Service Item No.") { } column(Warranty; Format(Warranty)) { } column(LnNo_ServShptItemLn; "Line No.") { } column(SrvcShpItemLineCaption; SrvcShpItemLineCaptionLbl) { } column(ContractNo_ServShptItemLnCaption; FieldCaption("Contract No.")) { } column(Des_ServShptItemLnCaption; FieldCaption(Description)) { } column(SerialNo_ServShptItemLnCaption; FieldCaption("Serial No.")) { } column(ItemNo_ServShptItemLnCaption; FieldCaption("Item No.")) { } column(ItemGrpCode_ServShptLnCaption; FieldCaption("Service Item Group Code")) { } column(ServItemNo_ServShptItemLnCaption; FieldCaption("Service Item No.")) { } } dataitem("Service Shipment Line"; "Service Shipment Line") { DataItemLink = "Document No." = field("No."); DataItemLinkReference = "Service Shipment Header"; DataItemTableView = sorting("Document No.", "Line No."); column(ServShptLnDescription; Description) { } column(ShowInternalInfo; ShowInternalInfo) { } column(ShowCorrectionLines; ShowCorrectionLines) { } column(ShowLotSN; ShowLotSN) { } column(Type_ServiceShptItemLn; Type) { } column(Qty_ServiceShptItemLn; Quantity) { } column(UnitofMeasure_ServShptLn; "Unit of Measure") { } column(No_ServiceShptItemLn; "No.") { } column(QtyInvoiced_ServShptLine; "Quantity Invoiced") { } column(QtyConsumed_ServShptLine; "Quantity Consumed") { } column(LnNo_ServiceShptItemLn; "Line No.") { } column(ServiceShpLineCaption; ServiceShpLineCaptionLbl) { } column(QtyInvoicedCaption; QtyInvoicedCaptionLbl) { } column(QtyConsumedCaption; QtyConsumedCaptionLbl) { } column(ServShptLnDescriptionCaption; FieldCaption(Description)) { } column(Qty_ServiceShptItemLnCaption; FieldCaption(Quantity)) { } column(UnitofMeasure_ServShptLnCaption; FieldCaption("Unit of Measure")) { } column(No_ServiceShptItemLnCaption; FieldCaption("No.")) { } dataitem(DimensionLoop2; "Integer") { DataItemTableView = sorting(Number); column(DimText_DimLoop2; DimText) { } column(DimensionLoop2Number; Number) { } column(LineDimsCaption; LineDimsCaptionLbl) { } trigger OnAfterGetRecord() begin DimText := DimTxtArr[Number]; end; trigger OnPreDataItem() begin if not ShowInternalInfo then CurrReport.Break(); FindDimTxt("Service Shipment Line"."Dimension Set ID"); SetRange(Number, 1, DimTxtArrLength); end; } trigger OnAfterGetRecord() begin if not ShowCorrectionLines and Correction then CurrReport.Skip(); end; trigger OnPostDataItem() begin if ShowLotSN then TrackingSpecCount := ItemTrackingDocMgt.RetrieveDocumentItemTracking( TempTrackingSpecification, "Service Shipment Header"."No.", DATABASE::"Service Shipment Header", 0); end; trigger OnPreDataItem() begin MoreLines := Find('+'); while MoreLines and (Description = '') and ("No." = '') and (Quantity = 0) do MoreLines := Next(-1) <> 0; if not MoreLines then CurrReport.Break(); SetFilter("Line No.", '<=%1', "Line No."); end; } dataitem(Total; "Integer") { DataItemTableView = sorting(Number) where(Number = const(1)); } dataitem(Total2; "Integer") { DataItemTableView = sorting(Number) where(Number = const(1)); column(BilltoCustNo_ServShptHrd; "Service Shipment Header"."Bill-to Customer No.") { } column(CustAddr1; CustAddr[1]) { } column(CustAddr2; CustAddr[2]) { } column(CustAddr3; CustAddr[3]) { } column(CustAddr4; CustAddr[4]) { } column(CustAddr5; CustAddr[5]) { } column(CustAddr6; CustAddr[6]) { } column(CustAddr7; CustAddr[7]) { } column(CustAddr8; CustAddr[8]) { } column(BilltoAddrCaption; BilltoAddrCaptionLbl) { } column(BilltoCustNo_ServShptHrdCaption; "Service Shipment Header".FieldCaption("Bill-to Customer No.")) { } trigger OnPreDataItem() begin if not ShowCustAddr then CurrReport.Break(); end; } dataitem(ItemTrackingLine; "Integer") { DataItemTableView = sorting(Number); column(TrackingSpecBufItemNo; TempTrackingSpecification."Item No.") { } column(TrackingSpecBufDesc; TempTrackingSpecification.Description) { } column(TrackingSpecBufLotNo; TempTrackingSpecification."Lot No.") { } column(TrackingSpecBufSerialNo; TempTrackingSpecification."Serial No.") { } column(TrackingSpecBufQty; TempTrackingSpecification."Quantity (Base)") { } column(ShowTotal; ShowTotal) { } column(ShowGroup; ShowGroup) { } column(QuantityCaption; QuantityCaptionLbl) { } column(SerialNoCaption; SerialNoCaptionLbl) { } column(LotNoCaption; LotNoCaptionLbl) { } column(DescriptionCaption; DescriptionCaptionLbl) { } dataitem(TotalItemTracking; "Integer") { DataItemTableView = sorting(Number) where(Number = const(1)); column(TotalQty; TotalQty) { } } trigger OnAfterGetRecord() begin if Number = 1 then TempTrackingSpecification.FindSet() else TempTrackingSpecification.Next(); if not ShowCorrectionLines and TempTrackingSpecification.Correction then CurrReport.Skip(); if TempTrackingSpecification.Correction then TempTrackingSpecification."Quantity (Base)" := -TempTrackingSpecification."Quantity (Base)"; ShowTotal := false; if ItemTrackingAppendix.IsStartNewGroup(TempTrackingSpecification) then ShowTotal := true; ShowGroup := false; if (TempTrackingSpecification."Source Ref. No." <> OldRefNo) or (TempTrackingSpecification."Item No." <> OldNo) then begin OldRefNo := TempTrackingSpecification."Source Ref. No."; OldNo := TempTrackingSpecification."Item No."; TotalQty := 0; end else ShowGroup := true; TotalQty += TempTrackingSpecification."Quantity (Base)"; end; trigger OnPreDataItem() begin if TrackingSpecCount = 0 then CurrReport.Break(); SetRange(Number, 1, TrackingSpecCount); TempTrackingSpecification.SetCurrentKey( "Source ID", "Source Type", "Source Subtype", "Source Batch Name", "Source Prod. Order Line", "Source Ref. No."); end; } trigger OnPreDataItem() begin // Item Tracking: if ShowLotSN then begin TrackingSpecCount := 0; OldRefNo := 0; ShowGroup := false; end; end; } trigger OnAfterGetRecord() begin if Number > 1 then begin CopyText := FormatDocument.GetCOPYText(); OutputNo += 1; end; TotalQty := 0; // Item Tracking end; trigger OnPostDataItem() begin if not IsReportInPreviewMode() then CODEUNIT.Run(CODEUNIT::"Service Shpt.-Printed", "Service Shipment Header"); end; trigger OnPreDataItem() begin NoOfLoops := 1 + Abs(NoOfCopies); 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("Service Shipment Header"); FormatDocumentFields("Service Shipment Header"); if not CompanyBankAccount.Get("Service Shipment Header"."Company Bank Account Code") then CompanyBankAccount.CopyBankFieldsFromCompanyInfo(CompanyInfo); end; } } requestpage { AboutTitle = 'About Service - Shipment'; AboutText = 'Generate a service shipment document that you can send to your customer.'; SaveValues = true; layout { area(content) { group(Options) { Caption = 'Options'; field(NoOfCopies; NoOfCopies) { ApplicationArea = Service; Caption = 'No. of Copies'; ToolTip = 'Specifies how many copies of the document to print.'; } field(ShowInternalInfo; ShowInternalInfo) { ApplicationArea = Service; Caption = 'Show Internal Information'; ToolTip = 'Specifies if you want the printed report to show information that is only for internal use.'; } field("Show Correction Lines"; ShowCorrectionLines) { ApplicationArea = Service; Caption = 'Show Correction Lines'; ToolTip = 'Specifies if the correction lines of an undoing of quantity posting will be shown on the report.'; } field(ShowLotSN; ShowLotSN) { ApplicationArea = Service; Caption = 'Show Lot/Serial No. Appendix'; ToolTip = 'Specifies if you want to print an appendix to the service shipment report that shows the lot and serial numbers that are in the shipment.'; } } } } actions { } } labels { } trigger OnInitReport() begin CompanyInfo.Get(); ServiceSetup.Get(); FormatDocument.SetLogoPosition(ServiceSetup."Logo Position on Documents", CompanyInfo1, CompanyInfo2, CompanyInfo3); end; var SalesPurchPerson: Record "Salesperson/Purchaser"; CompanyBankAccount: Record "Bank Account"; ServiceSetup: Record "Service Mgt. Setup"; DimSetEntry: Record "Dimension Set Entry"; RespCenter: Record "Responsibility Center"; TempTrackingSpecification: Record "Tracking Specification" temporary; ItemTrackingAppendix: Report "Item Tracking Appendix"; LanguageMgt: Codeunit Language; FormatAddr: Codeunit "Format Address"; FormatDocument: Codeunit "Format Document"; ItemTrackingDocMgt: Codeunit "Item Tracking Doc. Management"; NoOfCopies: Integer; NoOfLoops: Integer; TrackingSpecCount: Integer; OldRefNo: Integer; TotalQty: Decimal; OldNo: Code[20]; CopyText: Text[30]; CustAddr: array[8] of Text[100]; ShipToAddr: array[8] of Text[100]; CompanyAddr: array[8] of Text[100]; SalesPersonText: Text[20]; ReferenceText: Text[80]; DimText: Text[120]; ShowCustAddr: Boolean; MoreLines: Boolean; ShowInternalInfo: Boolean; ShowCorrectionLines: Boolean; ShowLotSN: Boolean; ShowTotal: Boolean; ShowGroup: Boolean; OutputNo: Integer; DimTxtArrLength: Integer; DimTxtArr: array[500] of Text[50];#pragma warning disable AA0074#pragma warning disable AA0470 Text002: Label 'Service - Shipment %1'; Text003: Label 'Page %1';#pragma warning restore AA0470#pragma warning restore AA0074 ItemTrackingAppendixCaptionLbl: Label 'Item Tracking - Appendix'; PhoneNoCaptionLbl: Label 'Phone No.'; VATRegNoCaptionLbl: Label 'VAT Registration No.'; GiroNoCaptionLbl: Label 'Giro No.'; BankNameCaptionLbl: Label 'Bank'; BankAccNoCaptionLbl: Label 'Account No.'; ServiceShpHdrNoCaptionLbl: Label 'Shipment No.'; ServiceShpHdrPostingDateCaptionLbl: Label 'Posting Date'; HdrDimsCaptionLbl: Label 'Header Dimensions'; SrvcShpItemLineCaptionLbl: Label 'Service Shipment Item Line'; ServiceShpLineCaptionLbl: Label 'Service Shipment Line'; QtyInvoicedCaptionLbl: Label 'Quantity Invoiced'; QtyConsumedCaptionLbl: Label 'Quantity Consumed'; LineDimsCaptionLbl: Label 'Line Dimensions'; BilltoAddrCaptionLbl: Label 'Bill-to Address'; QuantityCaptionLbl: Label 'Quantity'; SerialNoCaptionLbl: Label 'Serial No.'; LotNoCaptionLbl: Label 'Lot No.'; DescriptionCaptionLbl: Label 'Description'; DocumentDateLbl: Label 'Document Date'; EmailIdCaptionLbl: Label 'Email'; HomePageCaptionLbl: Label 'HomePage'; SrvcShipHeaderCustNoCaptionLbl: Label 'Customer No'; WarrantyCaptionLbl: Label 'Warranty'; protected var CompanyInfo: Record "Company Information"; CompanyInfo1: Record "Company Information"; CompanyInfo2: Record "Company Information"; CompanyInfo3: Record "Company Information"; local procedure FindDimTxt(DimSetID: Integer) var Separation: Text[5]; i: Integer; TxtToAdd: Text[120]; StartNewLine: Boolean; begin DimSetEntry.SetRange("Dimension Set ID", DimSetID); DimTxtArrLength := 0; for i := 1 to ArrayLen(DimTxtArr) do DimTxtArr[i] := ''; if not DimSetEntry.FindSet() then exit; Separation := '; '; repeat TxtToAdd := DimSetEntry."Dimension Code" + ' - ' + DimSetEntry."Dimension Value Code"; if DimTxtArrLength = 0 then StartNewLine := true else StartNewLine := StrLen(DimTxtArr[DimTxtArrLength]) + StrLen(Separation) + StrLen(TxtToAdd) > MaxStrLen(DimTxtArr[1]); if StartNewLine then begin DimTxtArrLength += 1; DimTxtArr[DimTxtArrLength] := TxtToAdd end else DimTxtArr[DimTxtArrLength] := DimTxtArr[DimTxtArrLength] + Separation + TxtToAdd; until DimSetEntry.Next() = 0; end; procedure InitializeRequest(NewShowInternalInfo: Boolean; NewShowCorrectionLines: Boolean; NewShowLotSN: Boolean) begin ShowInternalInfo := NewShowInternalInfo; ShowCorrectionLines := NewShowCorrectionLines; ShowLotSN := NewShowLotSN; end; local procedure IsReportInPreviewMode(): Boolean var MailManagement: Codeunit "Mail Management"; begin exit(CurrReport.Preview or MailManagement.IsHandlingGetEmailBody()); end; local procedure FormatAddressFields(var ServiceShipmentHeader: Record "Service Shipment Header") var ServiceFormatAddress: Codeunit "Service Format Address"; begin FormatAddr.GetCompanyAddr(ServiceShipmentHeader."Responsibility Center", RespCenter, CompanyInfo, CompanyAddr); ServiceFormatAddress.ServiceShptShipTo(ShipToAddr, ServiceShipmentHeader); ShowCustAddr := ServiceFormatAddress.ServiceShptBillTo(CustAddr, ShipToAddr, ServiceShipmentHeader); end; local procedure FormatDocumentFields(ServiceShipmentHeader: Record "Service Shipment Header") begin FormatDocument.SetSalesPerson(SalesPurchPerson, ServiceShipmentHeader."Salesperson Code", SalesPersonText); ReferenceText := FormatDocument.SetText(ServiceShipmentHeader."Your Reference" <> '', ServiceShipmentHeader.FieldCaption("Your Reference")); end;}