Report 1006 Job - Planning Lines
src/Layers/W1/BaseApp/Projects/Project/Reports/JobPlanningLines.Report.al365 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.Projects.Project.Planning;using Microsoft.Projects.Project.Job;using Microsoft.Projects.Project.Journal;using System.Utilities;report 1006 "Job - Planning Lines"{ AdditionalSearchTerms = 'Job - Planning Lines'; ApplicationArea = Jobs; Caption = 'Project - Planning Lines'; ToolTip = 'View all planning lines for the project. You use this window to plan what items, resources, and general ledger expenses that you expect to use on a project (budget) or you can specify what you actually agreed with your customer that he should pay for the project (billable).'; UsageCategory = ReportsAndAnalysis; DefaultRenderingLayout = RDLCLayout; dataset { dataitem(Job; Job) { DataItemTableView = sorting("No."); PrintOnlyIfDetail = true; column(No_Job; StrSubstNo('%1 %2 %3 %4', TableCaption(), FieldCaption("No."), "No.", Description)) { } dataitem("Integer"; "Integer") { DataItemTableView = sorting(Number) where(Number = const(1)); column(CompanyName; COMPANYPROPERTY.DisplayName()) { } column(TodayFormatted; Format(Today, 0, 4)) { } column(JobTaskCaption; "Job Task".TableCaption + ': ' + JTFilter) { } column(ShowJTFilter; JTFilter) { } column(Desc_Job; Job.Description) { } column(CurrCodeJob0Fld; JobCalcBatches.GetCurrencyCode(Job, 0, CurrencyField)) { } column(CurrCodeJob2Fld; JobCalcBatches.GetCurrencyCode(Job, 2, CurrencyField)) { } column(CurrCodeJob3Fld; JobCalcBatches.GetCurrencyCode(Job, 3, CurrencyField)) { } column(JobPlanningLinesCaption; JobPlanningLinesCaptionLbl) { } column(CurrReportPageNoCaption; CurrReportPageNoCaptionLbl) { } column(JobPlannLinePlannDtCptn; JobPlannLinePlannDtCptnLbl) { } column(LineTypeCaption; LineTypeCaptionLbl) { } } dataitem("Job Task"; "Job Task") { DataItemLink = "Job No." = field("No."); DataItemTableView = sorting("Job No.", "Job Task No."); PrintOnlyIfDetail = true; RequestFilterFields = "Job No.", "Job Task No."; column(JobTaskNo_JobTask; "Job Task No.") { } column(Desc_JobTask; Description) { } column(TotalCost1_JobTask; TotalCost[1]) { } column(TotalCost2_JobTask; TotalCost[2]) { } column(FooterTotalCost1_JobTask; FooterTotalCost1) { } column(FooterTotalCost2_JobTask; FooterTotalCost2) { } column(FooterLineDisAmt1_JobTask; FooterLineDiscountAmount1) { } column(FooterLineDisAmt2_JobTask; FooterLineDiscountAmount2) { } column(FooterLineAmt1_JobTask; FooterLineAmount1) { } column(FooterLineAmt2_JobTask; FooterLineAmount2) { } column(JobTaskNo_JobTaskCaption; FieldCaption("Job Task No.")) { } column(TotalScheduleCaption; TotalScheduleCaptionLbl) { } column(TotalContractCaption; TotalContractCaptionLbl) { } dataitem("Job Planning Line"; "Job Planning Line") { DataItemLink = "Job No." = field("Job No."), "Job Task No." = field("Job Task No."), "Planning Date" = field("Planning Date Filter"); DataItemLinkReference = "Job Task"; DataItemTableView = sorting("Job No.", "Job Task No.", "Line No."); column(TotCostLCY_JobPlanningLine; "Total Cost (LCY)") { } column(Qty_JobPlanningLine; Quantity) { IncludeCaption = false; } column(Desc_JobPlanningLine; Description) { IncludeCaption = false; } column(No_JobPlanningLine; "No.") { IncludeCaption = false; } column(Type_JobPlanningLine; Type) { IncludeCaption = false; } column(PlannDate_JobPlanningLine; Format("Planning Date")) { } column(DocNo_JobPlanningLine; "Document No.") { IncludeCaption = false; } column(UOMCode_JobPlanningLine; "Unit of Measure Code") { IncludeCaption = false; } column(LineDiscAmLCY_JobPlanningLine; "Line Discount Amount (LCY)") { } column(AmtLCY_JobPlanningLine; "Line Amount (LCY)") { } column(LineType_JobPlanningLine; SelectStr(ConvertToJobLineType().AsInteger(), Text000)) { } column(FieldLocalCurr_JobPlanningLine; CurrencyField = CurrencyField::"Local Currency") { } column(TotalCost_JobPlanningLine; "Total Cost") { } column(LineDiscAmt_JobPlanningLine; "Line Discount Amount") { } column(LineAmt_JobPlanningLine; "Line Amount") { } column(ForeignCurr_JobPlanningLine; CurrencyField = CurrencyField::"Foreign Currency") { } column(TotalCost1_JobPlanningLine; TotalCost[1]) { } column(LineAmt1_JobPlanningLine; LineAmount[1]) { } column(LineDisAmt1_JobPlanningLine; LineDiscountAmount[1]) { } column(LineAmt2_JobPlanningLine; LineAmount[2]) { } column(LineDisAmt2_JobPlanningLine; LineDiscountAmount[2]) { } column(TotalCost2_JobPlanningLine; TotalCost[2]) { } column(JobNo_JobPlanningLine; "Job No.") { } column(JobTaskNo_JobPlanningLine; "Job Task No.") { } column(ScheduleCaption; ScheduleCaptionLbl) { } column(ContractCaption; ContractCaptionLbl) { } trigger OnAfterGetRecord() begin if CurrencyField = CurrencyField::"Local Currency" then begin if "Schedule Line" then begin FooterTotalCost1 += "Total Cost (LCY)"; TotalCost[1] += "Total Cost (LCY)"; FooterLineDiscountAmount1 += "Line Discount Amount (LCY)"; LineDiscountAmount[1] += "Line Discount Amount (LCY)"; FooterLineAmount1 += "Line Amount (LCY)"; LineAmount[1] += "Line Amount (LCY)"; end; if "Contract Line" then begin FooterTotalCost2 += "Total Cost (LCY)"; TotalCost[2] += "Total Cost (LCY)"; FooterLineDiscountAmount2 += "Line Discount Amount (LCY)"; LineDiscountAmount[2] += "Line Discount Amount (LCY)"; FooterLineAmount2 += "Line Amount (LCY)"; LineAmount[2] += "Line Amount (LCY)"; end; end else begin if "Schedule Line" then begin FooterTotalCost1 += "Total Cost"; TotalCost[1] += "Total Cost"; FooterLineDiscountAmount1 += "Line Discount Amount"; LineDiscountAmount[1] += "Line Discount Amount"; FooterLineAmount1 += "Line Amount"; LineAmount[1] += "Line Amount"; end; if "Contract Line" then begin FooterTotalCost2 += "Total Cost"; TotalCost[2] += "Total Cost"; FooterLineDiscountAmount2 += "Line Discount Amount"; LineDiscountAmount[2] += "Line Discount Amount"; FooterLineAmount2 += "Line Amount"; LineAmount[2] += "Line Amount"; end; end; end; } trigger OnPreDataItem() begin Clear(TotalCost); Clear(LineDiscountAmount); Clear(LineAmount); end; } trigger OnAfterGetRecord() var JobPlanningLine: Record "Job Planning Line"; begin JobPlanningLine.SetRange("Job No.", "No."); JobPlanningLine.SetFilter("Planning Date", JobPlanningDateFilter); if not JobPlanningLine.FindFirst() then CurrReport.Skip(); FooterTotalCost1 := 0; FooterTotalCost2 := 0; FooterLineDiscountAmount1 := 0; FooterLineDiscountAmount2 := 0; FooterLineAmount1 := 0; FooterLineAmount2 := 0; end; trigger OnPreDataItem() begin SetFilter("No.", JobFilter); end; } } requestpage { AboutTitle = 'About Project - Planning Lines'; AboutText = 'Get an overview of planning and tasks for a project.'; layout { area(content) { group(Options) { Caption = 'Options'; field(CurrencyField; CurrencyField) { ApplicationArea = Jobs; Caption = 'Currency'; OptionCaption = 'Local Currency,Foreign Currency'; ToolTip = 'Specifies the currency that amounts are shown in.'; } } } } actions { } } rendering { layout(RDLCLayout) { Type = RDLC; LayoutFile = './Projects/Project/Reports/JobPlanningLines.rdlc'; Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.'; } } labels { JobPlannLineTypeCaption = 'Type'; JobPlannLineDocNoCaption = 'Document No.'; JobPlannLineNoCaption = 'No.'; JobPlannLineDescCaption = 'Description'; JobPlannLineQtyCaption = 'Quantity'; JobPlannLineUOMCodeCptn = 'Unit of Measure Code'; JobTaskNo_JobTaskCptn = 'Project Task No.'; } trigger OnPreReport() begin JTFilter := "Job Task".GetFilters(); JobFilter := "Job Task".GetFilter("Job No."); JobPlanningDateFilter := "Job Task".GetFilter("Planning Date Filter"); end; var JobCalcBatches: Codeunit "Job Calculate Batches"; TotalCost: array[2] of Decimal; LineDiscountAmount: array[2] of Decimal; LineAmount: array[2] of Decimal; JobFilter: Text; JTFilter: Text; CurrencyField: Option "Local Currency","Foreign Currency";#pragma warning disable AA0074 Text000: Label 'Budget,Billable,Bud.+Bill.';#pragma warning restore AA0074 FooterTotalCost1: Decimal; FooterTotalCost2: Decimal; FooterLineDiscountAmount1: Decimal; FooterLineDiscountAmount2: Decimal; FooterLineAmount1: Decimal; FooterLineAmount2: Decimal; JobPlanningLinesCaptionLbl: Label 'Project Planning Lines'; CurrReportPageNoCaptionLbl: Label 'Page'; JobPlannLinePlannDtCptnLbl: Label 'Planning Date'; LineTypeCaptionLbl: Label 'Line Type'; TotalScheduleCaptionLbl: Label 'Total Budget'; TotalContractCaptionLbl: Label 'Total Billable'; ScheduleCaptionLbl: Label 'Budget'; ContractCaptionLbl: Label 'Billable'; JobPlanningDateFilter: Text; procedure InitializeRequest(NewCurrencyField: Option "Local Currency","Foreign Currency") begin CurrencyField := NewCurrencyField; end;}