Query 762 Acc. Sched. Line Desc. Count

Base Application, Microsoft.Finance.FinancialReports

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;            }        }    }}