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 |