Codeunit 1331 Trial Balance Cache Mgt.
src/Layers/W1/BaseApp/Finance/FinancialReports/TrialBalanceCacheMgt.Codeunit.al150 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>/// Management codeunit for trial balance cache operations including staleness detection and refresh scheduling./// Optimizes trial balance performance through intelligent caching with configurable refresh intervals./// </summary>/// <remarks>/// Performance optimization codeunit that manages trial balance data caching to reduce calculation overhead./// Provides cache staleness detection, refresh interval management, and automated cache maintenance/// for improved trial balance response times in high-usage scenarios./// </remarks>codeunit 1331 "Trial Balance Cache Mgt."{ trigger OnRun() begin end; var RefreshFrequencyErr: Label 'Refresh intervals of less than 10 minutes are not supported.'; [Scope('OnPrem')] procedure IsCacheStale(): Boolean var TrialBalanceCacheInfo: Record "Trial Balance Cache Info"; begin if not TrialBalanceCacheInfo.Get() then exit(true); exit(CurrentDateTime - TrialBalanceCacheInfo."Last Modified Date/Time" >= GetCacheRefreshInterval()); end; [Scope('OnPrem')] procedure LoadFromCache(var DescriptionsArr: array[9] of Text[100]; var ValuesArr: array[9, 2] of Decimal; var PeriodCaptionTxt: array[2] of Text): Boolean var TrialBalanceCache: Record "Trial Balance Cache"; TrialBalanceCacheInfo: Record "Trial Balance Cache Info"; Index: Integer; CaptionsSaved: Boolean; begin Clear(DescriptionsArr); Clear(ValuesArr); Clear(PeriodCaptionTxt); // If the number of trial balance cached is <> array length means that // something went wrong. Reset if thats the case if TrialBalanceCache.Count <> ArrayLen(DescriptionsArr) then begin TrialBalanceCache.DeleteAll(); TrialBalanceCacheInfo.DeleteAll(); exit(false); end; Index := 1; if TrialBalanceCache.FindSet() then repeat DescriptionsArr[Index] := TrialBalanceCache.Description; ValuesArr[Index, 1] := TrialBalanceCache."Period 1 Amount"; ValuesArr[Index, 2] := TrialBalanceCache."Period 2 Amount"; if not CaptionsSaved then begin PeriodCaptionTxt[1] := TrialBalanceCache."Period 1 Caption"; PeriodCaptionTxt[2] := TrialBalanceCache."Period 2 Caption"; CaptionsSaved := true; end; Index := Index + 1; until TrialBalanceCache.Next() = 0; exit(true); end; [Scope('OnPrem')] procedure SaveToCache(DescriptionsArr: array[9] of Text[100]; ValuesArr: array[9, 2] of Decimal; PeriodCaptionTxt: array[2] of Text) var TrialBalanceCacheInfo: Record "Trial Balance Cache Info"; TrialBalanceCache: Record "Trial Balance Cache"; Index: Integer; CaptionsSaved: Boolean; CacheFound: Boolean; begin TrialBalanceCache.LockTable(); CacheFound := TrialBalanceCache.FindSet(); if not IsCacheStale() then exit; Index := 1; if CacheFound then repeat TrialBalanceCache.Description := DescriptionsArr[Index]; TrialBalanceCache."Period 1 Amount" := ValuesArr[Index, 1]; TrialBalanceCache."Period 2 Amount" := ValuesArr[Index, 2]; if not CaptionsSaved then begin TrialBalanceCache."Period 1 Caption" := CopyStr(PeriodCaptionTxt[1], 1, MaxStrLen(TrialBalanceCache."Period 1 Caption")); TrialBalanceCache."Period 2 Caption" := CopyStr(PeriodCaptionTxt[2], 1, MaxStrLen(TrialBalanceCache."Period 2 Caption")); CaptionsSaved := true; end; TrialBalanceCache.Modify(); Index := Index + 1; until TrialBalanceCache.Next() = 0 else for Index := 1 to ArrayLen(DescriptionsArr) do begin TrialBalanceCache.Init(); TrialBalanceCache."Entry No." := Index; TrialBalanceCache.Description := DescriptionsArr[Index]; TrialBalanceCache."Period 1 Amount" := ValuesArr[Index, 1]; TrialBalanceCache."Period 2 Amount" := ValuesArr[Index, 2]; if not CaptionsSaved then begin TrialBalanceCache."Period 1 Caption" := CopyStr(PeriodCaptionTxt[1], 1, MaxStrLen(TrialBalanceCache."Period 1 Caption")); TrialBalanceCache."Period 2 Caption" := CopyStr(PeriodCaptionTxt[2], 1, MaxStrLen(TrialBalanceCache."Period 2 Caption")); CaptionsSaved := true; end; TrialBalanceCache.Insert(); end; if TrialBalanceCacheInfo.Get() then begin TrialBalanceCacheInfo."Last Modified Date/Time" := CurrentDateTime; TrialBalanceCacheInfo.Modify(); end else begin TrialBalanceCacheInfo.Init(); TrialBalanceCacheInfo."Last Modified Date/Time" := CurrentDateTime; TrialBalanceCacheInfo.Insert(); end end; local procedure GetCacheRefreshInterval() Interval: Duration var MinInterval: Duration; begin MinInterval := 10 * 60 * 1000; // 10 minutes Interval := 60 * 60 * 1000; // 1 hr OnGetCacheRefreshInterval(Interval); if Interval < MinInterval then Error(RefreshFrequencyErr); end; /// <summary> /// Integration event for customizing trial balance cache refresh interval. /// Enables modification of the default cache refresh frequency for performance tuning. /// </summary> /// <param name="Interval">Cache refresh interval in milliseconds, can be modified</param> [IntegrationEvent(false, false)] local procedure OnGetCacheRefreshInterval(var Interval: Duration) begin end;}