Table 50 Accounting Period
src/Layers/W1/BaseApp/Foundation/Period/AccountingPeriod.Table.al230 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.Foundation.Period;using Microsoft.Inventory.Costing;using Microsoft.Inventory.Item;using Microsoft.Inventory.Setup;table 50 "Accounting Period"{ Caption = 'Accounting Period'; LookupPageID = "Accounting Periods"; DataClassification = CustomerContent; fields { field(1; "Starting Date"; Date) { Caption = 'Starting Date'; ToolTip = 'Specifies the date that the accounting period will begin.'; NotBlank = true; trigger OnValidate() begin Name := Format("Starting Date", 0, Text000); end; } field(2; Name; Text[10]) { Caption = 'Name'; ToolTip = 'Specifies the name of the accounting period.'; } field(3; "New Fiscal Year"; Boolean) { Caption = 'New Fiscal Year'; ToolTip = 'Specifies whether to use the accounting period to start a fiscal year.'; trigger OnValidate() begin TestField("Date Locked", false); if "New Fiscal Year" then begin if not InvtSetup.Get() then exit; "Average Cost Calc. Type" := InvtSetup."Average Cost Calc. Type"; "Average Cost Period" := InvtSetup."Average Cost Period"; end else begin "Average Cost Calc. Type" := "Average Cost Calc. Type"::" "; "Average Cost Period" := "Average Cost Period"::" "; end; end; } field(4; Closed; Boolean) { Caption = 'Closed'; ToolTip = 'Specifies if the accounting period belongs to a closed fiscal year.'; Editable = false; } field(5; "Date Locked"; Boolean) { Caption = 'Date Locked'; ToolTip = 'Specifies if you can change the starting date for the accounting period.'; Editable = false; } field(5804; "Average Cost Calc. Type"; Enum "Average Cost Calculation Type") { AccessByPermission = TableData Item = R; Caption = 'Average Cost Calc. Type'; ToolTip = 'Specifies how the average cost for items in the accounting period was calculated.'; Editable = false; } field(5805; "Average Cost Period"; Enum "Average Cost Period Type") { AccessByPermission = TableData Item = R; Caption = 'Average Cost Period'; ToolTip = 'Specifies the period type that was used in the accounting period to calculate the average cost.'; Editable = false; } } keys { key(Key1; "Starting Date") { Clustered = true; } key(Key2; "New Fiscal Year", "Date Locked") { } key(Key3; Closed) { } } fieldgroups { fieldgroup(Brick; "Starting Date", Name, "New Fiscal Year", Closed) { } } trigger OnDelete() begin TestField("Date Locked", false); end; trigger OnInsert() begin AccountingPeriod2 := Rec; if AccountingPeriod2.Find('>') then AccountingPeriod2.TestField("Date Locked", false); end; trigger OnRename() begin TestField("Date Locked", false); AccountingPeriod2 := Rec; if AccountingPeriod2.Find('>') then AccountingPeriod2.TestField("Date Locked", false); end; var AccountingPeriod2: Record "Accounting Period"; InvtSetup: Record "Inventory Setup";#pragma warning disable AA0074 Text000: Label '<Month Text,10>', Locked = true;#pragma warning restore AA0074 MonthTxt: Label '<Month Text>', Locked = true; procedure UpdateAvgItems() var ChangeAvgCostSetting: Codeunit "Change Average Cost Setting"; begin ChangeAvgCostSetting.UpdateAvgCostFromAccPeriodChg(Rec); end; procedure GetFiscalYearEndDate(ReferenceDate: Date): Date var AccountingPeriod: Record "Accounting Period"; begin exit(GetFiscalYearEndDate(AccountingPeriod, ReferenceDate)) end; procedure GetFiscalYearEndDate(var AccountingPeriod: Record "Accounting Period"; ReferenceDate: Date): Date begin AccountingPeriod.Reset(); if AccountingPeriod.IsEmpty() then exit(CalcDate('<CY>', ReferenceDate)); AccountingPeriod.SetRange("New Fiscal Year", true); AccountingPeriod.SetRange("Starting Date", 0D, ReferenceDate); if AccountingPeriod.FindLast() then AccountingPeriod.SetRange("Starting Date"); if AccountingPeriod.Find('>') then exit(AccountingPeriod."Starting Date" - 1); end; procedure GetFiscalYearStartDate(ReferenceDate: Date): Date var AccountingPeriod: Record "Accounting Period"; begin exit(GetFiscalYearStartDate(AccountingPeriod, ReferenceDate)) end; procedure GetFiscalYearStartDate(var AccountingPeriod: Record "Accounting Period"; ReferenceDate: Date): Date begin AccountingPeriod.Reset(); if AccountingPeriod.IsEmpty() then exit(CalcDate('<-CY>', ReferenceDate)); AccountingPeriod.SetRange("New Fiscal Year", true); AccountingPeriod.SetRange("Starting Date", 0D, ReferenceDate); if AccountingPeriod.FindLast() then exit(AccountingPeriod."Starting Date") end; procedure CorrespondingAccountingPeriodExists(var AccountingPeriod: Record "Accounting Period"; AccSchedDate: Date): Boolean begin AccountingPeriod.SetFilter("Starting Date", '%1', CalcDate('<-CM>', AccSchedDate)); if AccountingPeriod.FindFirst() then exit(true); exit(false); end; procedure MakeRecurringTexts(PostingDate: Date; var DocumentNo: Code[20]; var Description: Text[100]) var AccountingPeriod: Record "Accounting Period"; Day: Integer; Week: Integer; Month: Integer; Year: Integer; MonthText: Text[30]; IsHandled: Boolean; begin IsHandled := false; OnBeforeMakeRecurringTexts(PostingDate, DocumentNo, Description, IsHandled); if IsHandled then exit; Day := Date2DMY(PostingDate, 1); Week := Date2DWY(PostingDate, 2); Month := Date2DMY(PostingDate, 2); MonthText := Format(PostingDate, 0, MonthTxt); Year := Date2DMY(PostingDate, 3); AccountingPeriod.SetRange("Starting Date", 0D, PostingDate); if not AccountingPeriod.FindLast() then AccountingPeriod.Name := ''; DocumentNo := CopyStr( DelChr( PadStr( StrSubstNo(DocumentNo, Day, Week, Month, MonthText, AccountingPeriod.Name, Year), MaxStrLen(DocumentNo)), '>'), 1, MaxStrLen(DocumentNo)); Description := CopyStr( DelChr( PadStr( StrSubstNo(Description, Day, Week, Month, MonthText, AccountingPeriod.Name, Year), MaxStrLen(Description)), '>'), 1, MaxStrLen(Description)); end; [IntegrationEvent(false, false)] local procedure OnBeforeMakeRecurringTexts(PostingDate: Date; var DocumentNo: Code[20]; var Description: Text[100]; var IsHandled: Boolean) begin end;}