1.  Verify that you have a FundWare Division Backup done through Division Maintenance.  All users must be signed out of FundWare during this procedure. 
2.  Print a Date Tables List Report in Report Manager, General Ledger, Systems Lists.  Create a report to include all ID Types and all date tables. 
3.  Sign out of FundWare.  Use Windows Explorer or DOS to delete the ##CSD*.* files ( ##=Division) from your \Fundware\Data folder. This will delete all of your current date tables. 
4.  Select File, Open FundWare. 
    Verify that 00-System Administration appears in the drop down box, click OK. 
    Select System Administration, System Utilities.
     **If you are at FundWare versions 7.20 or below, you will access System Utilities through Classic FundWare under System Utilities, System Management, Execute Program. 
    Enter the following in the Execute Program portion of the screen: 
       Program Name                   CST208
       Switches                       20
       Parameters                     GLS,DF
       Business Date                  Use today's date
       Division                       Select the appropriate division.
       Click Run.
Type in C to Change, enter your ID Type if prompted, change field 4 Year End Day to the month and day of new year end.  Accept changes, esc or E to End program.
5.  Enter the following in the Execute Program portion of the screen: 
       Program Name                   CST228
       Switches                       20
       Parameters                     GLS
       Business Date                  Use today's date
       Division                       Select the appropriate division.
       Click Run.
Type in A to Add, enter your ID Type if prompted, Option 1 (next year), enter desired adjustment periods.  The end of the first period should be the last day of the first month of your new year (skipping the short period year addition).  In the example above, this first period would be July 31, 2009.  Accept the additions, then esc and E to End program. 
6.  Enter the following in the Execute Program portion of the screen:
       Program Name                   CST208
       Switches                       20
       Parameters                     GLS,DF
       Business Date                  Use today's date
       Division                       Select the appropriate division.
       Click Run.
Type C to Change, enter your ID Type if prompted, change field 4 Year End Day back to the month and day of old year end.  Accept changes and end program.
7.  Using the Date Tables list created in step 2 as a guide, add all prior date tables. 
       Enter the following in the Execute Program portion of the screen:
       Program Name                   CST228
       Switches                       20
       Parameters                     GLS
       Business Date                  Use today's date
       Division                       Select the appropriate division.
       Click Run.
Type in A to Add, enter your ID Type if prompted, Option 2 (previous year). The first date table it sets up will be the one month short period. Continue using the Add selection until all prior date tables are added per your Date Tables List.
8.  Enter the following in the Execute Program portion of the screen: 
       Program Name                   CST208
       Switches                       20
       Parameters                     GLS,DF
       Business Date                  Use today's date
       Division                       Select the appropriate division.
       Click Run.
Type in C to Change, enter your ID Type if prompted, change field 4 Year End Day back to the month and day of new year end.  Accept the change and end program. 
9. Enter the following in the Execute Program portion of the screen:
       Program Name                   CST900
       Switches                       (blank)
       Parameters                     CST901
       Business Date                  Use today's date
       Division                       Select the appropriate division.
       Click Run.
If you do not have any Saved years, select your ID Type when prompted and enter through the date range.  (Date range should be 00/00/0000 - 99/99/9999.)  This program will repost all the existing transactions to the new date table.
If you do have saved years, then the date range should be the first date of a year that is not saved and the last date will be 99/99/9999.
(You can see if a year is saved on the Date Tables List you ran. Under system information, it will have a Status of S - Year is saved)
12.  Run a Date Tables List and review carefully, making sure all the settings are the same as those in step 2.

13.  If the Budget Prep module is used, a copy of the ChangeFYE.sql script must be requested from Support.  Once received, copy that script to the root of the drive where fundware is installed and run it as below to complete the process. 
If Budget Prep is not licensed, the script is not necessary. 
If additional ID types are involved, this script can be run after all ID types have been reentered.
Copy the ChangeFYE.sql to the root drive where fundware is installed and run the attached script (ChangeFYE.sql) to complete the process:
     a.  Log into the server as a network administrator.
     b.  Save the file received from Support to the drive where FundWare exists, such as C:\.
     c.  Select Start, Run.
     d.  At Open, type cmd.
     e.  At the command prompt, change the directory to show where you saved the ChangeFYE.sql file, type C:
     f.   At the command prompt, type osql -E -d AFW## -i C:\ChangeFYE.sql (where ## is the appropriate division number).
     g.  When the script is finished running, type exit. 
 
**** Additional steps for more than one ID Type **

When you removed the ##CSD*.* files in step 3, you removed the date tables for all ID Types.  If you have other ID Types with new fiscal year end dates, complete steps 4 through 12 for each ID Type that has a new fiscal year. 
1.  If all other ID Types keep their original fiscal year ends, recreate the date tables.
    Select File, Open FundWare.
    Verify that 00-System Administration appears in the drop down box, click OK.
    Select System Administration, System Utilities.
    Enter the following in the Execute Program portion of the screen: 
       Program Name                   CST228
       Switches                       20
       Parameters                     GLS
       Business Date                  Use today's date
       Division                       Select the appropriate division.
       Click Run.
Type A to Add, enter your ID Type if prompted, Option 1 (next year), enter desired adjustment periods.  The first period ends will be the last day of the first month in the fiscal year, with the year being the earliest year from the date tables list.
2.  Continue with Add option 1 to re-add all the date tables for this ID Type.
3.  Enter the following in the Execute Program portion of the screen:
       Program Name                   CST900
       Switches                       (blank)
       Parameters                     CST901
       Business Date                  Use today's date
       Division                       Select the appropriate division.
       Click Run.
Select your ID Type when prompted and enter through the date range.  (Date range should be 00/00/0000 - 99/99/9999, unless you have saved years as above.)  This program will repost all the existing transactions to the new date table.
4.  Repeat steps 1 through 3 for every ID Type. 
Run a Date Tables List and review carefully.