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 |