How Accounting Calendars Are Validated

Calendar validation is automatic and prevents serious problems when you begin using a calendar. Once you set a calendar period status to open or future enterable, you can't edit the period.

Settings That Affect Calendar Validation

Calendar validation runs automatically after you save the calendar.

How a Calendar Is Validated

The following table lists the validation checks that are performed when an accounting calendar is saved.

Validation

Data Example

Unique period number

2 assigned for two periods

Unique period name

Jan-17 entered twice

Period number beyond the maximum number of periods per year

13 for a 12 period calendar with no adjusting periods

Entered period name contains spaces

Jan 17

Single or double quotes in the period name

Jan '17

Nonadjusting periods with overlapping dates

01-Jan-2017 to 31-Jan-2017 and 30-Jan-2017 to 28-Feb-2017

Period date gaps

01-Jan-2017 to 28-Jan-2017 and 31-Jan-2017 to 28-Feb-2017

Missing period numbers

Periods 1 through 6 are defined for a calendar with 12 months

Period number gaps

1, 3, 5

Period numbers not in sequential order by date

Period 1 covers 01-Jan-2017 to 31-Jan-2017 and period 2 covers 01-Mar-2017 to 31-Mar-2017, and period 3 covers 01-Feb-2017 to 28-Feb-2017.

Quarter number gaps

1, 3, 4

Quarters not in sequential order by period

1, 3, 2, 4

Period start or end dates more than one year before or after the fiscal year

July 1, 2015 in a 2017 calendar