Query 762 Acc. Sched. Line Desc. Count
src/Layers/W1/BaseApp/Finance/FinancialReports/AccSchedLineDescCount.Query.al39 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.Finance.FinancialReports;/// <summary>/// Query for counting account schedule lines with duplicate descriptions within the same schedule./// Identifies potential data quality issues by finding non-empty descriptions that occur more than once./// </summary>/// <remarks>/// Used for data validation and cleanup processes to maintain unique line descriptions/// within account schedule definitions. Filters out empty descriptions and counts only duplicates./// </remarks>query 762 "Acc. Sched. Line Desc. Count"{ Caption = 'Acc. Sched. Line Desc. Count'; elements { dataitem(Acc_Schedule_Line; "Acc. Schedule Line") { column(Schedule_Name; "Schedule Name") { } column(Description; Description) { ColumnFilter = Description = filter(<> ''); } column(Count_) { ColumnFilter = Count_ = filter(> 1); Method = Count; } } }}