Skip to main content
GL

FinYearSetup

PX.Objects.GL
Field NameTypeDisplay NameForeign Key
BegFinYear
datetime2Financial Year Starts On-
Description:The start date of the financial year.
BelongsToNextYearNonexistent in DB
bitBelongs to Next Year-
Description:When set to "true", indicates that the system must set the financial year to the one, following the year of the selected start date of the year. For example, if the selected start date is 10/28/2014 and this option is set to "true", the FirstFinYear will be "2015". If this option is set to "false", FirstFinYear for the same date will be "2014".
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
char(8)-
Description:No description available
CreatedDateTime
datetime-
Description:No description available
EndYearCalcMethod
char(2)Year End Calculation Method-
Description:The method used to determine the end date of a year with week-long periods. Available values are: "CA" - Last day of the financial year, "LD" - Include last selected day of week of the year, "ND" - Include selected day of week, nearest tot the end of the year. For more information on these options see the documentation for the Financial Year (GL101000) form.
EndYearDayOfWeek
intPeriods Start Day of Week-
Description:The day of the week when period starts. Relevant only for the period types based on weeks. Allowed values are: 1 - "Sunday", 2 - "Monday", 3 - "Tuesday", 4 - "Wednesday", 5 - "Thursday", 6 - "Friday", 7 - "Saturday".
FinPeriods
smallintNumber of Financial Periods-
Description:The number of financial periods in the year.
FirstFinYear
char(4)First Financial Year-
Description:First financial year, for which data is stored in the system.
HasAdjustmentPeriod
bitHas Adjustment Period-
Description:When set to "true", indicates that the system generates an additional period for posting adjustments. The adjustment period has the same start and end date and is the last period of the year. No date in the year corresponds to the adjustment period, so it can be selected for a particular document or batch only manually. See also the FinPeriod.IsAdjustment field.
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
Description:No description available
LastModifiedByScreenID
char(8)-
Description:No description available
LastModifiedDateTime
datetime-
Description:No description available
PeriodLength
smallintLength of Financial Period (days)-
Description:Obsolete field. The length of periods of the year in days.
PeriodsStartDate
datetime2First Period Start Date-
Description:The start date of the first period of the year.
PeriodType
char(2)Period Type-
Description:The type of financial periods that make up the year. Allowed values are: "MO" - Month, "BM" - Two Months, "QR" - Quarter, "WK" - Week, "BW" - Two Weeks, "FW" - Four Weeks, "DC" - Decade, "FF" - 4-4-5 Weeks, "FI" - 4-5-4 Weeks, "IF" - 5-4-4 Weeks, "CL" - Customer Periods Length, "CN" - Custom Number of Periods.
tstamp
timestamp-
Description:No description available
UserDefined
bitUser-Defined Periods-
Description:The read-only field indicating whether the periods of the year can be modified by user. Depends on the value of the PeriodType field - returns "true" if the PeriodType is ""CN"" (Custom number of periods).
YearLastDayOfWeekNonexistent in DB
intDay of Week-
Description:The day of the week of the last day of the financial year. Relevant ony for the period types based on weeks and if the EndYearCalcMethod is not ""CA"" - Last day of the financial year.