Table 365 Analysis View Entry
src/Layers/W1/BaseApp/Finance/Analysis/AnalysisViewEntry.Table.al444 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.Analysis;using Microsoft.CashFlow.Account;using Microsoft.CashFlow.Forecast;using Microsoft.Finance.Consolidation;using Microsoft.Finance.Currency;using Microsoft.Finance.Dimension;using Microsoft.Finance.FinancialReports;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.Finance.GeneralLedger.Ledger;using Microsoft.Finance.GeneralLedger.Setup;/// <summary>/// Stores aggregated financial data for analysis views with dimension breakdown./// Contains pre-calculated amounts from G/L entries and cash flow entries for optimized reporting performance./// </summary>/// <remarks>/// Analysis view entries are created and updated by the UpdateAnalysisView process. Each record represents/// aggregated transaction data for a specific account, business unit, date, and dimension combination./// Supports both G/L Account and Cash Flow Account sources with up to 4 dimensions./// </remarks>table 365 "Analysis View Entry"{ Caption = 'Analysis View Entry'; DrillDownPageID = "Analysis View Entries"; LookupPageID = "Analysis View Entries"; DataClassification = CustomerContent; fields { /// <summary> /// Code of the analysis view that owns this entry. /// </summary> field(1; "Analysis View Code"; Code[10]) { Caption = 'Analysis View Code'; ToolTip = 'Specifies the analysis view.'; NotBlank = true; TableRelation = "Analysis View" where("Account Source" = field("Account Source")); } /// <summary> /// Business unit code for consolidation and multi-company analysis. /// </summary> field(2; "Business Unit Code"; Code[20]) { Caption = 'Business Unit Code'; ToolTip = 'Specifies the code for the business unit that the analysis view is based on.'; TableRelation = "Business Unit"; } /// <summary> /// Account number (G/L Account or Cash Flow Account) that this entry represents. /// </summary> field(3; "Account No."; Code[20]) { Caption = 'Account No.'; ToolTip = 'Specifies the account that the analysis entry comes from.'; TableRelation = if ("Account Source" = const("G/L Account")) "G/L Account" else if ("Account Source" = const("Cash Flow Account")) "Cash Flow Account"; ValidateTableRelation = false; trigger OnLookup() var GLAccount: Record "G/L Account"; CashFlowAccount: Record "Cash Flow Account"; GLAccountList: Page "G/L Account List"; CashFlowAccountList: Page "Cash Flow Account List"; IsHandled: Boolean; begin OnLookupAccountNo(Rec, IsHandled); if IsHandled then exit; case "Account Source" of "Account Source"::"G/L Account": begin GLAccountList.LookupMode(true); if GLAccountList.RunModal() = ACTION::LookupOK then begin GLAccountList.GetRecord(GLAccount); Rec.Validate("Account No.", GLAccount."No."); end; end; "Account Source"::"Cash Flow Account": begin CashFlowAccountList.LookupMode(true); if CashFlowAccountList.RunModal() = ACTION::LookupOK then begin CashFlowAccountList.GetRecord(CashFlowAccount); Rec.Validate("Account No.", CashFlowAccount."No."); end; end; end; end; } /// <summary> /// First dimension value code for multi-dimensional analysis and reporting. /// </summary> field(4; "Dimension 1 Value Code"; Code[20]) { AccessByPermission = TableData Dimension = R; CaptionClass = GetCaptionClass(1); Caption = 'Dimension 1 Value Code'; ToolTip = 'Specifies the dimension value you selected for the analysis view dimension that you defined as Dimension 1 on the analysis view card.'; } /// <summary> /// Second dimension value code for multi-dimensional analysis and reporting. /// </summary> field(5; "Dimension 2 Value Code"; Code[20]) { AccessByPermission = TableData Dimension = R; CaptionClass = GetCaptionClass(2); Caption = 'Dimension 2 Value Code'; ToolTip = 'Specifies the dimension value you selected for the analysis view dimension that you defined as Dimension 2 on the analysis view card.'; } /// <summary> /// Third dimension value code for extended multi-dimensional analysis and reporting. /// </summary> field(6; "Dimension 3 Value Code"; Code[20]) { AccessByPermission = TableData "Dimension Combination" = R; CaptionClass = GetCaptionClass(3); Caption = 'Dimension 3 Value Code'; ToolTip = 'Specifies the dimension value you selected for the analysis view dimension that you defined as Dimension 3 on the analysis view card.'; } /// <summary> /// Fourth dimension value code for comprehensive multi-dimensional analysis and reporting. /// </summary> field(7; "Dimension 4 Value Code"; Code[20]) { AccessByPermission = TableData "Dimension Combination" = R; CaptionClass = GetCaptionClass(4); Caption = 'Dimension 4 Value Code'; ToolTip = 'Specifies the dimension value you selected for the analysis view dimension that you defined as Dimension 4 on the analysis view card.'; } /// <summary> /// Posting date of the transactions aggregated in this entry. /// </summary> field(8; "Posting Date"; Date) { Caption = 'Posting Date'; ToolTip = 'Specifies the entry''s posting date.'; } /// <summary> /// Unique entry number for this analysis view entry record. /// </summary> field(9; "Entry No."; Integer) { Caption = 'Entry No.'; } /// <summary> /// Net amount (debit minus credit) aggregated from the underlying transactions. /// </summary> field(10; Amount; Decimal) { AutoFormatExpression = ''; AutoFormatType = 1; Caption = 'Amount'; ToolTip = 'Specifies the amount of the analysis view budget entry.'; trigger OnLookup() begin DrillDown(); end; } /// <summary> /// Total debit amounts aggregated from the underlying transactions. /// </summary> field(11; "Debit Amount"; Decimal) { AutoFormatExpression = ''; AutoFormatType = 1; Caption = 'Debit Amount'; ToolTip = 'Specifies the total of the ledger entries that represent debits.'; } /// <summary> /// Total credit amounts aggregated from the underlying transactions. /// </summary> field(12; "Credit Amount"; Decimal) { AutoFormatExpression = ''; AutoFormatType = 1; Caption = 'Credit Amount'; ToolTip = 'Specifies the total of the ledger entries that represent credits.'; } /// <summary> /// Additional currency amount when using additional reporting currency. /// </summary> field(13; "Add.-Curr. Amount"; Decimal) { AccessByPermission = TableData Currency = R; AutoFormatExpression = GetAdditionalReportingCurrencyCode(); AutoFormatType = 1; Caption = 'Add.-Curr. Amount'; ToolTip = 'Specifies (in the additional reporting currency) the VAT difference that arises when you make a correction to a VAT amount on a sales or purchase document.'; } /// <summary> /// Additional currency debit amount for multi-currency analysis and reporting. /// Provides debit amounts in additional reporting currency for global financial analysis. /// </summary> field(14; "Add.-Curr. Debit Amount"; Decimal) { AccessByPermission = TableData Currency = R; AutoFormatExpression = GetAdditionalReportingCurrencyCode(); AutoFormatType = 1; Caption = 'Add.-Curr. Debit Amount'; ToolTip = 'Specifies, in the additional reporting currency, the amount of the debit entry.'; } /// <summary> /// Additional currency credit amount for multi-currency analysis and reporting. /// Provides credit amounts in additional reporting currency for global financial analysis. /// </summary> field(15; "Add.-Curr. Credit Amount"; Decimal) { AccessByPermission = TableData Currency = R; AutoFormatExpression = GetAdditionalReportingCurrencyCode(); AutoFormatType = 1; Caption = 'Add.-Curr. Credit Amount'; ToolTip = 'Specifies, in the additional reporting currency, the amount of the credit entry.'; } /// <summary> /// Source type indicating whether this entry originates from G/L accounts or Cash Flow accounts. /// Determines the account structure and available dimensions for analysis view processing. /// </summary> field(16; "Account Source"; Enum "Analysis Account Source") { Caption = 'Account Source'; ToolTip = 'Specifies an account that you can use as a filter to define what is displayed in the Analysis by Dimensions window.'; } /// <summary> /// Cash flow forecast number for cash flow analysis view entries. /// Links to specific cash flow forecast for cash flow account source entries. /// </summary> field(17; "Cash Flow Forecast No."; Code[20]) { Caption = 'Cash Flow Forecast No.'; ToolTip = 'Specifies a number for the cash flow forecast.'; TableRelation = "Cash Flow Forecast"; } } keys { key(Key1; "Analysis View Code", "Account No.", "Account Source", "Dimension 1 Value Code", "Dimension 2 Value Code", "Dimension 3 Value Code", "Dimension 4 Value Code", "Business Unit Code", "Posting Date", "Entry No.", "Cash Flow Forecast No.") { Clustered = true; } key(Key2; "Analysis View Code", "Account No.", "Account Source", "Dimension 1 Value Code", "Dimension 2 Value Code", "Dimension 3 Value Code", "Dimension 4 Value Code", "Business Unit Code", "Posting Date", "Cash Flow Forecast No.") { SumIndexFields = Amount, "Debit Amount", "Credit Amount", "Add.-Curr. Amount", "Add.-Curr. Debit Amount", "Add.-Curr. Credit Amount"; } } fieldgroups { } var AnalysisView: Record "Analysis View";#pragma warning disable AA0074 Text000: Label '1,5,,Dimension 1 Value Code'; Text001: Label '1,5,,Dimension 2 Value Code'; Text002: Label '1,5,,Dimension 3 Value Code'; Text003: Label '1,5,,Dimension 4 Value Code';#pragma warning restore AA0074 /// <summary> /// Gets the caption class for dimension fields based on analysis view configuration. /// Provides dynamic field captions based on the analysis view's dimension setup and naming. /// </summary> /// <param name="AnalysisViewDimType">Dimension number (1-4) to get caption class for</param> /// <returns>Caption class string for dynamic field captioning based on analysis view setup</returns> procedure GetCaptionClass(AnalysisViewDimType: Integer) Result: Text[250] var IsHandled: Boolean; begin IsHandled := false; OnBeforeGetCaptionClass(Rec, AnalysisViewDimType, AnalysisView, Result, IsHandled); if IsHandled then exit; if AnalysisView.Code <> "Analysis View Code" then AnalysisView.Get("Analysis View Code"); case AnalysisViewDimType of 1: begin if AnalysisView."Dimension 1 Code" <> '' then exit('1,5,' + AnalysisView."Dimension 1 Code"); exit(Text000); end; 2: begin if AnalysisView."Dimension 2 Code" <> '' then exit('1,5,' + AnalysisView."Dimension 2 Code"); exit(Text001); end; 3: begin if AnalysisView."Dimension 3 Code" <> '' then exit('1,5,' + AnalysisView."Dimension 3 Code"); exit(Text002); end; 4: begin if AnalysisView."Dimension 4 Code" <> '' then exit('1,5,' + AnalysisView."Dimension 4 Code"); exit(Text003); end; end; OnAfterGetCaptionClass(AnalysisView, AnalysisViewDimType, Result); end; [Scope('OnPrem')] procedure DrillDown() var TempGLEntry: Record "G/L Entry" temporary; TempCFForecastEntry: Record "Cash Flow Forecast Entry" temporary; AnalysisViewEntryToGLEntries: Codeunit AnalysisViewEntryToGLEntries; IsHandled: Boolean; begin IsHandled := false; OnBeforeDrilldown(Rec, IsHandled); if IsHandled then exit; if "Account Source" = "Account Source"::"G/L Account" then begin TempGLEntry.Reset(); TempGLEntry.DeleteAll(); AnalysisViewEntryToGLEntries.GetGLEntries(Rec, TempGLEntry); PAGE.RunModal(PAGE::"General Ledger Entries", TempGLEntry); end else begin TempCFForecastEntry.Reset(); TempCFForecastEntry.DeleteAll(); AnalysisViewEntryToGLEntries.GetCFLedgEntries(Rec, TempCFForecastEntry); PAGE.RunModal(PAGE::"Cash Flow Forecast Entries", TempCFForecastEntry); end; OnAfterDrillDown(Rec); end; /// <summary> /// Copies dimension filters from account schedule line to analysis view entry. /// Transfers filter criteria for dimension-based analysis and reporting in account schedules. /// </summary> /// <param name="AccSchedLine">Account schedule line containing dimension filters to copy</param> procedure CopyDimFilters(var AccSchedLine: Record "Acc. Schedule Line") begin AccSchedLine.CopyFilter("Dimension 1 Filter", "Dimension 1 Value Code"); AccSchedLine.CopyFilter("Dimension 2 Filter", "Dimension 2 Value Code"); AccSchedLine.CopyFilter("Dimension 3 Filter", "Dimension 3 Value Code"); AccSchedLine.CopyFilter("Dimension 4 Filter", "Dimension 4 Value Code"); end; /// <summary> /// Sets dimension filters on analysis view entry using text filter expressions. /// Applies filter criteria for all four dimensions in analysis view queries and reports. /// </summary> /// <param name="DimFilter1">Filter expression for dimension 1 value code</param> /// <param name="DimFilter2">Filter expression for dimension 2 value code</param> /// <param name="DimFilter3">Filter expression for dimension 3 value code</param> /// <param name="DimFilter4">Filter expression for dimension 4 value code</param> procedure SetDimFilters(DimFilter1: Text; DimFilter2: Text; DimFilter3: Text; DimFilter4: Text) begin SetFilter("Dimension 1 Value Code", DimFilter1); SetFilter("Dimension 2 Value Code", DimFilter2); SetFilter("Dimension 3 Value Code", DimFilter3); SetFilter("Dimension 4 Value Code", DimFilter4); end; /// <summary> /// Integration event raised after calculating caption class for analysis view dimension fields. /// Enables customization of dimension field captions based on analysis view configuration. /// </summary> /// <param name="AnalysisView">Analysis view record containing dimension setup</param> /// <param name="AnalysisViewDimType">Dimension number (1-4) being processed</param> /// <param name="Result">Caption class result that can be modified by subscribers</param> [IntegrationEvent(false, false)] local procedure OnAfterGetCaptionClass(var AnalysisView: Record "Analysis View"; AnalysisViewDimType: Integer; var Result: Text[250]) begin end; /// <summary> /// Integration event raised after drilldown operation completes on analysis view entries. /// Enables additional processing after viewing detailed entries for analysis view records. /// </summary> /// <param name="AnalysisViewEntry">Analysis view entry record that was drilled down</param> [IntegrationEvent(false, false)] local procedure OnAfterDrillDown(var AnalysisViewEntry: Record "Analysis View Entry") begin end; /// <summary> /// Integration event raised before calculating caption class for analysis view dimension fields. /// Enables custom logic to override standard caption class calculation. /// </summary> /// <param name="AnalysisViewEntry">Analysis view entry record being processed</param> /// <param name="AnalysisViewDimType">Dimension number (1-4) being processed</param> /// <param name="AnalysisView">Analysis view record with dimension configuration</param> /// <param name="Result">Caption class result that can be set by subscribers</param> /// <param name="IsHandled">Set to true to skip standard caption class processing</param> [IntegrationEvent(false, false)] local procedure OnBeforeGetCaptionClass(var AnalysisViewEntry: Record "Analysis View Entry"; AnalysisViewDimType: Integer; var AnalysisView: Record "Analysis View"; var Result: Text[250]; var IsHandled: Boolean) begin end; /// <summary> /// Integration event raised before drilldown operation on analysis view entries. /// Enables custom drilldown logic to override standard G/L or Cash Flow entry display. /// </summary> /// <param name="AnalysisViewEntry">Analysis view entry record being drilled down</param> /// <param name="IsHandled">Set to true to skip standard drilldown processing</param> [IntegrationEvent(false, false)] local procedure OnBeforeDrilldown(var AnalysisViewEntry: Record "Analysis View Entry"; var IsHandled: Boolean) begin end; /// <summary> /// Integration event raised when looking up account numbers in analysis view entries. /// Enables custom lookup logic for G/L accounts or Cash Flow accounts based on account source. /// </summary> /// <param name="AnalysisViewEntry">Analysis view entry record with account information</param> /// <param name="IsHandled">Set to true to skip standard account lookup processing</param> [IntegrationEvent(false, false)] local procedure OnLookupAccountNo(var AnalysisViewEntry: Record "Analysis View Entry"; var IsHandled: Boolean) begin end; local procedure GetAdditionalReportingCurrencyCode(): Code[10] var GLSetup: Record "General Ledger Setup"; begin GLSetup.Get(); exit(GLSetup."Additional Reporting Currency"); end;}