Report 1007 Job - Transaction Detail
src/Layers/W1/BaseApp/Projects/Project/Reports/JobTransactionDetail.Report.al414 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.Reports;using Microsoft.Projects.Project.Job;using Microsoft.Projects.Project.Journal;using Microsoft.Projects.Project.Ledger;using System.Utilities;report 1007 "Job - Transaction Detail"{ AdditionalSearchTerms = 'Job - Transaction Detail'; ApplicationArea = Jobs; Caption = 'Project Task - Transaction Detail'; ToolTip = 'View all postings with entries for a selected project for a selected period, which have been charged to a certain project. At the end of each project list, the amounts are totaled separately for the Sales and Usage entry types.'; UsageCategory = ReportsAndAnalysis; DefaultRenderingLayout = RDLCLayout; dataset { dataitem(Job; Job) { DataItemTableView = sorting("No."); RequestFilterFields = "No."; column(No_Job; "No.") { } column(JobTotalCost1; JobTotalCost[1]) { } column(JobTotalCost2; JobTotalCost[2]) { } column(JobTotalPrice1; JobTotalPrice[1]) { } column(JobTotalPrice2; JobTotalPrice[2]) { } column(JobTotalLineDiscAmount1; JobTotalLineDiscAmount[1]) { } column(JobTotalLineDiscAmount2; JobTotalLineDiscAmount[2]) { } column(JobTotalLineAmount1; JobTotalLineAmount[1]) { } column(JobTotalLineAmount2; JobTotalLineAmount[2]) { } dataitem("Integer"; "Integer") { DataItemTableView = sorting(Number) where(Number = const(1)); column(CompanyName; COMPANYPROPERTY.DisplayName()) { } column(TodayFormatted; Format(Today, 0, 4)) { } column(JobFilterCaption; Job.TableCaption + ': ' + JobFilter) { } column(JobFilter; JobFilter) { } column(JobLedgEntryFilterCaption; "Job Ledger Entry".TableCaption + ': ' + JobLedgEntryFilter) { } column(JobLedgEntryFilter; JobLedgEntryFilter) { } column(Description_Job; Job.Description) { } column(CurrencyField0; JobCalculateBatches.GetCurrencyCode(Job, 0, CurrencyFieldReq)) { } column(CurrencyField1; JobCalculateBatches.GetCurrencyCode(Job, 1, CurrencyFieldReq)) { } column(CurrencyField2; JobCalculateBatches.GetCurrencyCode(Job, 2, CurrencyFieldReq)) { } column(CurrencyField3; JobCalculateBatches.GetCurrencyCode(Job, 3, CurrencyFieldReq)) { } column(JobTransactionDetailCaption; JobTransactionDetailCaptionLbl) { } column(PageNoCaption; PageNoCaptionLbl) { } column(JobNoCaption; JobNoCaptionLbl) { } column(PostingDateCaption; PostingDateCaptionLbl) { } column(JobLedgEntryEntryTypeCaption; "Job Ledger Entry".FieldCaption("Entry Type")) { } column(JobLedgEntryDocNoCaption; "Job Ledger Entry".FieldCaption("Document No.")) { } column(JobLedgEntryTypeCaption; "Job Ledger Entry".FieldCaption(Type)) { } column(JobLedgEntryNoCaption; "Job Ledger Entry".FieldCaption("No.")) { } column(JobLedgEntryQtyCaption; "Job Ledger Entry".FieldCaption(Quantity)) { } column(JobLedgEntryUOMCodeCaption; "Job Ledger Entry".FieldCaption("Unit of Measure Code")) { } column(JobLedgEntryEntryNoCaption; "Job Ledger Entry".FieldCaption("Entry No.")) { } } dataitem("Job Task"; "Job Task") { DataItemLink = "Job No." = field("No."); DataItemTableView = sorting("Job No.", "Job Task No."); PrintOnlyIfDetail = true; column(JobTaskNo_JobTask; "Job Task No.") { } column(Description_JobTask; Description) { } column(CurrencyField; CurrencyFieldReq) { } column(TotalCostTotal1; TotalCostTotal[1]) { AutoFormatType = 1; } column(TotalCostTotal2; TotalCostTotal[2]) { AutoFormatType = 1; } column(TotalPriceTotal1; TotalPriceTotal[1]) { AutoFormatType = 1; } column(TotalPriceTotal2; TotalPriceTotal[2]) { AutoFormatType = 1; } column(TotalLineDiscAmt1; TotalLineDiscAmount[1]) { AutoFormatType = 1; } column(TotalLineDiscAmt2; TotalLineDiscAmount[2]) { AutoFormatType = 1; } column(TotalLineAmt1; TotalLineAmount[1]) { AutoFormatType = 1; } column(JobNo_JobTask; "Job No.") { } column(JobTaskJobTaskNoCaption; FieldCaption("Job Task No.")) { } column(TotalUsageCaption; TotalUsageCaptionLbl) { } column(TotalSaleCaption; TotalSaleCaptionLbl) { } dataitem("Job Ledger Entry"; "Job Ledger Entry") { DataItemLink = "Job No." = field("Job No."), "Job Task No." = field("Job Task No."); DataItemTableView = sorting("Job No.", "Job Task No.", "Entry Type", "Posting Date"); RequestFilterFields = "Posting Date"; column(EntryNo_JobLedgEntry; "Entry No.") { } column(LineAmtLCY_JobLedgEntry; "Line Amount (LCY)") { } column(LineDiscAmtLCY_JobLedgEntry; "Line Discount Amount (LCY)") { } column(TotalPriceLCY_JobLedgEntry; "Total Price (LCY)") { } column(TotalCostLCY_JobLedgEntry; "Total Cost (LCY)") { } column(UOMCode_JobLedgEntry; "Unit of Measure Code") { } column(Quantity_JobLedgEntry; Quantity) { } column(No_JobLedgEntry; "No.") { } column(Type_JobLedgEntry; Type) { } column(DocNo_JobLedgEntry; "Document No.") { } column(EntryType_JobLedgEntry; "Entry Type") { } column(PostDate_JobLedgEntry; Format("Posting Date")) { } column(LineAmt_JobLedgEntry; "Line Amount") { } column(LineDiscAmt_JobLedgEntry; "Line Discount Amount") { } column(TotalPrice_JobLedgEntry; "Total Price") { } column(TotalCost_JobLedgEntry; "Total Cost") { } column(TotalCostTotal11; TotalCostTotal[1]) { AutoFormatType = 1; } column(TotalCostTotal21; TotalCostTotal[2]) { AutoFormatType = 1; } column(TotalPriceTotal11; TotalPriceTotal[1]) { AutoFormatType = 1; } column(TotalPriceTotal21; TotalPriceTotal[2]) { AutoFormatType = 1; } column(TotalLineDiscAmt11; TotalLineDiscAmount[1]) { AutoFormatType = 1; } column(TotalLineDiscAmt21; TotalLineDiscAmount[2]) { AutoFormatType = 1; } column(TotalLineAmt11; TotalLineAmount[1]) { AutoFormatType = 1; } column(JobNo_JobLedgEntry; "Job No.") { } column(JobTaskNo_JobLedgEntry; "Job Task No.") { } column(UsageCaption; UsageCaptionLbl) { } column(SalesCaption; SalesCaptionLbl) { } trigger OnAfterGetRecord() begin if "Entry Type" = "Entry Type"::Usage then I := 1 else I := 2; if CurrencyFieldReq = CurrencyFieldReq::"Local Currency" then begin TotalCostTotal[I] += "Total Cost (LCY)"; TotalPriceTotal[I] += "Total Price (LCY)"; TotalLineDiscAmount[I] += "Line Discount Amount (LCY)"; TotalLineAmount[I] += "Line Amount (LCY)"; JobTotalCost[I] += "Total Cost (LCY)"; JobTotalLineAmount[I] += "Line Amount (LCY)"; JobTotalLineDiscAmount[I] += "Line Discount Amount (LCY)"; JobTotalPrice[I] += "Total Price (LCY)"; end else begin TotalCostTotal[I] += "Total Cost"; TotalPriceTotal[I] += "Total Price"; TotalLineDiscAmount[I] += "Line Discount Amount"; TotalLineAmount[I] += "Line Amount"; JobTotalCost[I] += "Total Cost"; JobTotalLineAmount[I] += "Line Amount"; JobTotalLineDiscAmount[I] += "Line Discount Amount"; JobTotalPrice[I] += "Total Price"; end; end; trigger OnPreDataItem() begin Clear(TotalCostTotal); Clear(TotalPriceTotal); Clear(TotalLineDiscAmount); Clear(TotalLineAmount); end; } trigger OnPreDataItem() begin Clear(TotalCostTotal); Clear(TotalPriceTotal); Clear(TotalLineDiscAmount); Clear(TotalLineAmount); end; } trigger OnAfterGetRecord() var JobLedgEntry: Record "Job Ledger Entry"; begin Clear(JobTotalCost); Clear(JobTotalPrice); Clear(JobTotalLineAmount); Clear(JobTotalLineDiscAmount); JobLedgEntry.SetCurrentKey("Job No.", "Entry Type"); JobLedgEntry.SetRange("Job No.", "No."); JobLedgEntry.SetRange("Entry Type", JobLedgEntry."Entry Type"::Usage); if JobLedgEntry.IsEmpty() then CurrReport.Skip(); end; } } requestpage { AboutTitle = 'About Project Task - Transaction Detail'; AboutText = 'Get an overview of posted project tasks, such as resources and items.'; layout { area(content) { group(Options) { Caption = 'Options'; field(CurrencyField; CurrencyFieldReq) { 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/JobTransactionDetail.rdlc'; Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.'; } } labels { } trigger OnPreReport() begin JobFilter := Job.GetFilters(); JobLedgEntryFilter := "Job Ledger Entry".GetFilters(); end; var JobCalculateBatches: Codeunit "Job Calculate Batches"; TotalCostTotal: array[2] of Decimal; TotalPriceTotal: array[2] of Decimal; TotalLineDiscAmount: array[2] of Decimal; TotalLineAmount: array[2] of Decimal; JobTotalCost: array[2] of Decimal; JobTotalPrice: array[2] of Decimal; JobTotalLineDiscAmount: array[2] of Decimal; JobTotalLineAmount: array[2] of Decimal; JobFilter: Text; JobLedgEntryFilter: Text; I: Integer; JobTransactionDetailCaptionLbl: Label 'Project - Transaction Detail'; PageNoCaptionLbl: Label 'Page'; JobNoCaptionLbl: Label 'Project No.'; PostingDateCaptionLbl: Label 'Posting Date'; TotalUsageCaptionLbl: Label 'Total Usage'; TotalSaleCaptionLbl: Label 'Total Sale'; UsageCaptionLbl: Label 'Usage'; SalesCaptionLbl: Label 'Sales'; protected var CurrencyFieldReq: Option "Local Currency","Foreign Currency"; procedure InitializeRequest(NewCurrencyField: Option "Local Currency","Foreign Currency") begin CurrencyFieldReq := NewCurrencyField; end;}