Example: Calendar Date Pattern Changes to a Fiscal Date Pattern

Your company has been operating under a calendar year and now needs to convert to a November through October fiscal year pattern.

The fiscal year is 2006. The current calendar year is January through December 2006. The new fiscal year pattern is November 2006 through October 2007.

Possible solution:

  1. Set up a new fiscal date pattern and pattern code for all of the existing years to be restated to the November through October pattern.

  2. Run the Calculate Fiscal Year and Period program and print the report only.

  3. Review the report and compare, on a line-by-line basis, the old and new CT, FQ, FY, and PN columns for accuracy.

  • Run the Calculate Fiscal Year and Period program to update the F0911 table to reflect the new fiscal date pattern.

  • Run the Repost Account Ledger program to restate the account balances to reflect the new fiscal date pattern.

    This updates the F0902 table with amounts that are based on the new period number and fiscal year that were previously assigned to the F0911 records. Use the same data selection that you used when you ran the Calculate Fiscal Year and Period program.

Note: None of the financial reports processed under the old fiscal date pattern match the information on the financial reports for the restated years.

See Also