Table extension 36950 Accounting Period
src/Apps/W1/PowerBIReports/App/Core/TableExtensions/AccountingPeriod.TableExt.al30 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.PowerBIReports;using Microsoft.Foundation.Period;tableextension 36950 "Accounting Period" extends "Accounting Period"{ fields { modify("Starting Date") { trigger OnAfterValidate() var PBISetup: Record "PowerBI Reports Setup"; begin if PBISetup.Get() then begin if "Starting Date" < PBISetup."Date Table Starting Date" then PBISetup."Date Table Starting Date" := "Starting Date"; if "Starting Date" > PBISetup."Date Table Ending Date" then PBISetup."Date Table Ending Date" := "Starting Date"; if PBISetup.WritePermission() then PBISetup.Modify(); end; end; } }}