Table 762 Account Schedules Chart Setup
src/Layers/W1/BaseApp/Finance/FinancialReports/AccountSchedulesChartSetup.Table.al511 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;using System.Visualization;/// <summary>/// Stores chart configuration settings for account schedule visualizations./// Manages chart setup parameters, period definitions, and chart type configurations for financial data presentation./// </summary>/// <remarks>/// Central configuration table for account schedule chart functionality. Links account schedules/// and column layouts with chart visualization parameters including period settings, axis definitions,/// and chart line configurations. Supports measure and dimension-based chart presentations./// </remarks>table 762 "Account Schedules Chart Setup"{ Caption = 'Account Schedules Chart Setup'; LookupPageID = "Account Schedule Chart List"; DataClassification = CustomerContent; fields { /// <summary> /// User ID that owns this chart setup configuration. /// </summary> field(1; "User ID"; Text[132]) { Caption = 'User ID'; ToolTip = 'Specifies the ID of the user who posted the entry, to be used, for example, in the change log.'; DataClassification = EndUserIdentifiableInformation; Editable = false; } /// <summary> /// Chart setup name for identification and selection. /// </summary> field(2; Name; Text[30]) { Caption = 'Name'; ToolTip = 'Specifies the name of the specific chart.'; } /// <summary> /// Detailed description of the chart setup purpose and configuration. /// </summary> field(3; Description; Text[250]) { Caption = 'Description'; ToolTip = 'Specifies the description of the specific chart.'; } /// <summary> /// Account schedule name used as the row definition for the chart. /// </summary> field(10; "Account Schedule Name"; Code[10]) { Caption = 'Account Schedule Name'; ToolTip = 'Specifies the name of the row definition that is used to generate the chart that is shown in the Finance Performance window.'; TableRelation = "Acc. Schedule Name".Name; trigger OnValidate() var AccSchedChartManagement: Codeunit "Acc. Sched. Chart Management"; begin AccSchedChartManagement.CheckDuplicateAccScheduleLineDescription("Account Schedule Name"); RefreshLines(false); end; } /// <summary> /// Column layout name used as the column definition for the chart. /// </summary> field(20; "Column Layout Name"; Code[10]) { Caption = 'Column Layout Name'; ToolTip = 'Specifies the name of the column layout in the account schedule that is used to generate the advanced chart that is shown in the Finance Performance window.'; TableRelation = "Column Layout Name".Name; trigger OnValidate() var AccSchedChartManagement: Codeunit "Acc. Sched. Chart Management"; begin AccSchedChartManagement.CheckDuplicateColumnLayoutColumnHeader("Column Layout Name"); RefreshLines(false); end; } /// <summary> /// Determines what the X-axis of the chart represents (Period, Account Schedule Line, or Column). /// </summary> field(30; "Base X-Axis on"; Option) { Caption = 'Base X-Axis on'; ToolTip = 'Specifies how the values from the selected account schedule are displayed in the specific chart.'; OptionCaption = 'Period,Acc. Sched. Line,Acc. Sched. Column'; OptionMembers = Period,"Acc. Sched. Line","Acc. Sched. Column"; trigger OnValidate() begin RefreshLines(false); if "End Date" = 0D then "End Date" := "Start Date"; end; } /// <summary> /// Starting date for period-based chart analysis. /// </summary> field(31; "Start Date"; Date) { Caption = 'Start Date'; ToolTip = 'Specifies the first date on which account schedule values are included in the chart.'; trigger OnValidate() begin TestField("Start Date"); end; } /// <summary> /// Ending date for period-based chart analysis. /// </summary> field(32; "End Date"; Date) { Caption = 'End Date'; ToolTip = 'Specifies the last date on which financial report values are included in the chart.'; trigger OnValidate() begin TestField("End Date"); end; } /// <summary> /// Length of each period in the chart (Day, Week, Month, Quarter, Year). /// </summary> field(41; "Period Length"; Option) { Caption = 'Period Length'; ToolTip = 'Specifies the length of periods in the chart.'; OptionCaption = 'Day,Week,Month,Quarter,Year'; OptionMembers = Day,Week,Month,Quarter,Year; } /// <summary> /// Number of periods to display in the chart visualization. /// </summary> field(42; "No. of Periods"; Integer) { Caption = 'No. of Periods'; ToolTip = 'Specifies how many periods are shown in the chart.'; InitValue = 12; trigger OnValidate() begin if "No. of Periods" < 1 then Error(Text002, FieldCaption("No. of Periods"), "No. of Periods"); end; } /// <summary> /// Indicates whether this setup was the last viewed chart configuration. /// </summary> field(50; "Last Viewed"; Boolean) { Caption = 'Last Viewed'; Editable = false; trigger OnValidate() var AccountSchedulesChartSetup: Record "Account Schedules Chart Setup"; begin if (not "Last Viewed") or ("Last Viewed" = xRec."Last Viewed") then exit; AccountSchedulesChartSetup.SetRange("User ID", "User ID"); AccountSchedulesChartSetup.SetFilter(Name, '<>%1', Name); AccountSchedulesChartSetup.SetRange("Last Viewed", true); AccountSchedulesChartSetup.ModifyAll("Last Viewed", false); end; } /// <summary> /// Indicates whether to include future periods in the chart analysis. /// </summary> field(51; "Look Ahead"; Boolean) { Caption = 'Look Ahead'; } } keys { key(Key1; "User ID", Name) { Clustered = true; } } fieldgroups { } trigger OnDelete() begin DeleteLines(); end; var#pragma warning disable AA0074 Text001: Label '%1 %2', Comment = '%1=Account Schdule Line_Description %2=Column Layout_Coulmn Header';#pragma warning disable AA0470 Text002: Label 'You cannot set %1 to %2.';#pragma warning restore AA0470#pragma warning restore AA0074 /// <summary> /// Sets the account schedule name and updates the record. /// Validates and modifies the chart setup with new account schedule configuration. /// </summary> /// <param name="AccSchedName">Account schedule name to set</param> procedure SetAccScheduleName(AccSchedName: Code[10]) begin Validate("Account Schedule Name", AccSchedName); Modify(true); end; /// <summary> /// Sets the column layout name and updates the record. /// Validates and modifies the chart setup with new column layout configuration. /// </summary> /// <param name="ColumnLayoutName">Column layout name to set</param> procedure SetColumnLayoutName(ColumnLayoutName: Code[10]) begin Validate("Column Layout Name", ColumnLayoutName); Modify(true); end; /// <summary> /// Sets the chart axis display option and updates the record. /// Configures what the X-axis represents in the chart visualization. /// </summary> /// <param name="ShowPer">Show period option to set</param> procedure SetShowPer(ShowPer: Option) begin Validate("Base X-Axis on", ShowPer); Modify(true); end; /// <summary> /// Sets the period length for chart analysis and updates the record. /// Defines the time span for each period in the chart visualization. /// </summary> /// <param name="PeriodLength">Period length option to set</param> procedure SetPeriodLength(PeriodLength: Option) begin "Period Length" := PeriodLength; Modify(true); end; /// <summary> /// Marks this chart setup as the last viewed configuration. /// Updates the record and clears last viewed flag from other setups. /// </summary> procedure SetLastViewed() begin Validate("Last Viewed", true); Modify(true); end; /// <summary> /// Sets filters on chart setup lines based on current chart configuration. /// Links chart setup lines to this configuration for data retrieval. /// </summary> /// <param name="AccSchedChartSetupLine">Chart setup line record to filter</param> procedure SetLinkToLines(var AccSchedChartSetupLine: Record "Acc. Sched. Chart Setup Line") begin AccSchedChartSetupLine.SetRange("User ID", "User ID"); AccSchedChartSetupLine.SetRange(Name, Name); end; /// <summary> /// Sets filters on chart setup lines for measure-based chart display. /// Configures line filtering based on X-axis configuration for measure presentation. /// </summary> /// <param name="AccSchedChartSetupLine">Chart setup line record to filter for measures</param> procedure SetLinkToMeasureLines(var AccSchedChartSetupLine: Record "Acc. Sched. Chart Setup Line") begin SetLinkToLines(AccSchedChartSetupLine); case "Base X-Axis on" of "Base X-Axis on"::Period: ; "Base X-Axis on"::"Acc. Sched. Line": AccSchedChartSetupLine.SetRange("Account Schedule Line No.", 0); "Base X-Axis on"::"Acc. Sched. Column": AccSchedChartSetupLine.SetRange("Column Layout Line No.", 0); end; end; /// <summary> /// Sets filters on chart setup lines for dimension-based chart display. /// Configures line filtering based on X-axis configuration for dimension presentation. /// </summary> /// <param name="AccSchedChartSetupLine">Chart setup line record to filter for dimensions</param> procedure SetLinkToDimensionLines(var AccSchedChartSetupLine: Record "Acc. Sched. Chart Setup Line") begin SetLinkToLines(AccSchedChartSetupLine); case "Base X-Axis on" of "Base X-Axis on"::Period: begin AccSchedChartSetupLine.SetRange("Account Schedule Line No.", 0); AccSchedChartSetupLine.SetRange("Column Layout Line No.", 0); end; "Base X-Axis on"::"Acc. Sched. Line": AccSchedChartSetupLine.SetRange("Column Layout Line No.", 0); "Base X-Axis on"::"Acc. Sched. Column": AccSchedChartSetupLine.SetRange("Account Schedule Line No.", 0); end; end; /// <summary> /// Refreshes chart setup lines based on current account schedule and column layout configuration. /// Updates line data when configuration changes or when forced refresh is requested. /// </summary> /// <param name="Force">True to force refresh regardless of changes, false to refresh only on changes</param> procedure RefreshLines(Force: Boolean) var AccSchedChartSetupLine: Record "Acc. Sched. Chart Setup Line"; TempAccSchedChartSetupLine: Record "Acc. Sched. Chart Setup Line" temporary; begin if not Force then if ("Account Schedule Name" = xRec."Account Schedule Name") and ("Column Layout Name" = xRec."Column Layout Name") and ("Base X-Axis on" = xRec."Base X-Axis on") then exit; GetMeasuresInTemp(TempAccSchedChartSetupLine); SetLinkToLines(AccSchedChartSetupLine); AccSchedChartSetupLine.DeleteAll(); AccSchedChartSetupLine.Reset(); if TempAccSchedChartSetupLine.FindSet() then repeat AccSchedChartSetupLine := TempAccSchedChartSetupLine; AccSchedChartSetupLine.Insert(); until TempAccSchedChartSetupLine.Next() = 0; end; /// <summary> /// Applies filters to account schedule lines based on current chart setup configuration. /// Filters lines to match the assigned account schedule name and exclude empty descriptions. /// </summary> /// <param name="AccScheduleLine">Account schedule line record to filter</param> procedure FilterAccSchedLines(var AccScheduleLine: Record "Acc. Schedule Line") begin AccScheduleLine.SetRange("Schedule Name", "Account Schedule Name"); AccScheduleLine.SetFilter(Description, '<>%1', ''); end; /// <summary> /// Applies filters to column layout records based on current chart setup configuration. /// Filters columns to match the assigned column layout name and exclude empty headers. /// </summary> /// <param name="ColumnLayout">Column layout record to filter</param> procedure FilterColumnLayout(var ColumnLayout: Record "Column Layout") begin ColumnLayout.SetRange("Column Layout Name", "Column Layout Name"); ColumnLayout.SetFilter("Column Header", '<>%1', ''); end; local procedure GetMeasuresInTemp(var TempAccSchedChartSetupLine: Record "Acc. Sched. Chart Setup Line" temporary) var AccScheduleLine: Record "Acc. Schedule Line"; ColumnLayout: Record "Column Layout"; begin FilterAccSchedLines(AccScheduleLine); FilterColumnLayout(ColumnLayout); case "Base X-Axis on" of "Base X-Axis on"::Period: if ColumnLayout.FindSet() then repeat if AccScheduleLine.FindSet() then repeat InsertLineIntoTemp(TempAccSchedChartSetupLine, AccScheduleLine, ColumnLayout); until AccScheduleLine.Next() = 0; until ColumnLayout.Next() = 0; "Base X-Axis on"::"Acc. Sched. Line", "Base X-Axis on"::"Acc. Sched. Column": begin if AccScheduleLine.FindSet() then repeat InsertLineIntoTemp(TempAccSchedChartSetupLine, AccScheduleLine, ColumnLayout); until AccScheduleLine.Next() = 0; Clear(AccScheduleLine); if ColumnLayout.FindSet() then repeat InsertLineIntoTemp(TempAccSchedChartSetupLine, AccScheduleLine, ColumnLayout); until ColumnLayout.Next() = 0; end; end; SetChartTypesToDefault(TempAccSchedChartSetupLine); end; local procedure InsertLineIntoTemp(var TempAccSchedChartSetupLine: Record "Acc. Sched. Chart Setup Line" temporary; AccScheduleLine: Record "Acc. Schedule Line"; ColumnLayout: Record "Column Layout") var AccSchedChartSetupLine: Record "Acc. Sched. Chart Setup Line"; begin TempAccSchedChartSetupLine.Init(); TempAccSchedChartSetupLine."User ID" := "User ID"; TempAccSchedChartSetupLine.Name := Name; TempAccSchedChartSetupLine."Account Schedule Name" := "Account Schedule Name"; TempAccSchedChartSetupLine."Account Schedule Line No." := AccScheduleLine."Line No."; TempAccSchedChartSetupLine."Column Layout Name" := "Column Layout Name"; TempAccSchedChartSetupLine."Column Layout Line No." := ColumnLayout."Line No."; case "Base X-Axis on" of "Base X-Axis on"::Period: begin TempAccSchedChartSetupLine."Original Measure Name" := StrSubstNo(Text001, AccScheduleLine.Description, ColumnLayout."Column Header"); TempAccSchedChartSetupLine."Measure Value" := StrSubstNo(Text001, AccScheduleLine."Line No.", ColumnLayout."Line No."); end; "Base X-Axis on"::"Acc. Sched. Line", "Base X-Axis on"::"Acc. Sched. Column": case true of AccScheduleLine."Line No." = 0: begin TempAccSchedChartSetupLine."Original Measure Name" := ColumnLayout."Column Header"; TempAccSchedChartSetupLine."Measure Value" := Format(ColumnLayout."Line No."); end; ColumnLayout."Line No." = 0: begin TempAccSchedChartSetupLine."Original Measure Name" := AccScheduleLine.Description; TempAccSchedChartSetupLine."Measure Value" := Format(AccScheduleLine."Line No."); end; end; end; TempAccSchedChartSetupLine."Measure Name" := TempAccSchedChartSetupLine."Original Measure Name"; if AccSchedChartSetupLine.Get(TempAccSchedChartSetupLine."User ID", TempAccSchedChartSetupLine.Name, TempAccSchedChartSetupLine."Account Schedule Line No.", TempAccSchedChartSetupLine."Column Layout Line No.") then TempAccSchedChartSetupLine."Chart Type" := AccSchedChartSetupLine."Chart Type"; TempAccSchedChartSetupLine.Insert(); end; local procedure SetChartTypesToDefault(var TempAccSchedChartSetupLine: Record "Acc. Sched. Chart Setup Line" temporary) var TempAccSchedChartSetupLine2: Record "Acc. Sched. Chart Setup Line" temporary; begin TempAccSchedChartSetupLine2.Copy(TempAccSchedChartSetupLine, true); SetMeasureChartTypesToDefault(TempAccSchedChartSetupLine2); TempAccSchedChartSetupLine2.Reset(); SetLinkToDimensionLines(TempAccSchedChartSetupLine2); TempAccSchedChartSetupLine2.SetFilter("Chart Type", '<>%1', TempAccSchedChartSetupLine2."Chart Type"::" "); if TempAccSchedChartSetupLine2.IsEmpty() then SetDimensionChartTypesToDefault(TempAccSchedChartSetupLine2); end; /// <summary> /// Sets default chart types for measure lines in chart setup configuration. /// Assigns column chart types to unset measure lines up to maximum supported measures. /// </summary> /// <param name="AccSchedChartSetupLine">Chart setup line record to update with default chart types</param> procedure SetMeasureChartTypesToDefault(var AccSchedChartSetupLine: Record "Acc. Sched. Chart Setup Line") var BusinessChartBuffer: Record "Business Chart Buffer"; MaxNumMeasures: Integer; NumOfMeasuresToBeSet: Integer; begin AccSchedChartSetupLine.Reset(); SetLinkToMeasureLines(AccSchedChartSetupLine); AccSchedChartSetupLine.SetFilter("Chart Type", '<>%1', AccSchedChartSetupLine."Chart Type"::" "); MaxNumMeasures := BusinessChartBuffer.GetMaxNumberOfMeasures(); NumOfMeasuresToBeSet := MaxNumMeasures - AccSchedChartSetupLine.Count(); if NumOfMeasuresToBeSet > 0 then begin AccSchedChartSetupLine.SetRange("Chart Type", AccSchedChartSetupLine."Chart Type"::" "); if AccSchedChartSetupLine.FindSet() then repeat AccSchedChartSetupLine."Chart Type" := AccSchedChartSetupLine.GetDefaultAccSchedChartType(); AccSchedChartSetupLine.Modify(); NumOfMeasuresToBeSet -= 1; until (NumOfMeasuresToBeSet = 0) or (AccSchedChartSetupLine.Next() = 0); end; end; /// <summary> /// Sets default chart types for dimension lines in chart setup configuration. /// Assigns default chart types to unset dimension lines for visualization. /// </summary> /// <param name="AccSchedChartSetupLine">Chart setup line record to update with default chart types</param> procedure SetDimensionChartTypesToDefault(var AccSchedChartSetupLine: Record "Acc. Sched. Chart Setup Line") begin AccSchedChartSetupLine.Reset(); SetLinkToDimensionLines(AccSchedChartSetupLine); AccSchedChartSetupLine.SetRange("Chart Type", AccSchedChartSetupLine."Chart Type"::" "); AccSchedChartSetupLine.ModifyAll("Chart Type", AccSchedChartSetupLine.GetDefaultAccSchedChartType()); end; local procedure DeleteLines() var AccSchedChartSetupLine: Record "Acc. Sched. Chart Setup Line"; begin AccSchedChartSetupLine.SetRange("User ID", "User ID"); AccSchedChartSetupLine.SetRange(Name, Name); AccSchedChartSetupLine.DeleteAll(); end;}