This chapter contains these topics:
Section 45.2, "Changing from a Calendar Year to a Fiscal Year Date Pattern"
Section 45.3, "Changing from a Fiscal Year to a Calendar Year Date Pattern"
There might come a time when you will be required to switch your date patterns from a calendar year to a fiscal year or from a fiscal year. Such a change may have impacts far beyond just the system. JD Edwards World recommends thoroughly investigating the impact of changing your date patterns before beginning this process.
Caution:
If using the Fixed Assets or Job Cost modules, please consult with a Fixed Assets/Job Cost consultant prior to proceeding.With in JD Edwards World, you can:
Change calendar date patterns to fiscal date patterns
Change fiscal date patterns to calendar date patterns
Note:
There are a variety of different situations that may arise when changing date patterns. This document outlines the basic steps necessary to change date patterns but cannot encompass each possible scenario.Within JD Edwards World there are two methods to change from a calendar year to a fiscal year date pattern. You can:
Repost all history to a new fiscal year date pattern
Set up a new company
Repost all history to a new fiscal year date pattern
Changing a date pattern from a calendar year to a fiscal year requires:
Setting up a new date pattern for all prior years
Setting up a new date pattern for the current year,
Setting up a new date pattern for at least one future year.
Changing the date pattern code in Company Numbers and Names (P00105) to the new code
Running the Repost Account Ledger (P099102 or P099105) for each year
Running the Annual Close (P098201) for each year
These processes will change all account balances as well as retained earnings for each year. Since JD Edwards World defines fiscal years by the last day of the first period, the Repost needs to be executed to realign period buckets and fiscal years.
To convert a company that is on a standard calendar year to a fiscal year, for example the calendar year 01/01/16 to 12/31/16) to the fiscal year 04/01/16 to 03/31/17, do the following:
Set up each fiscal year, beginning with the first year the company was on JD Edwards World.
Backup the following files:
Company Constants (F0010)
Account Master (F0901)
Account Ledger (F0911)
Account Balances (F0902)
Run all integrity programs and note any discrepancies.
Note:
Running integrities, both before and after the date pattern change enables you to detect any discrepancies that arise as a result of changing date patterns.Post to the existing date pattern, as usual. On the first day of the first period for the new fiscal year, change the date pattern field in Company Numbers and Names (P00105) to the new date pattern with the new beginning date.
Run the Repost Account Ledger (P099102 or P099105) with a '4' in Processing Option number '1', for all fiscal years that have supporting detail, to recalculate the periods within each fiscal year.
Run the Annual Close (P098201) for each fiscal year, one year at a time, beginning with the first year on JD Edwards World World.
Run all integrity programs and compare the results to those of previous integrities.
All account balance records (F0902) as well as account ledger records (F0911) will now reflect the correct period number based on the new date pattern.
Set up a new company
To change from a calendar year to a fiscal year by setting up a new company, do the following:
Set up a new company in Company Numbers and Names (P00105) with the new fiscal date pattern code.
Set up new business units using Revise Single Business Unit (P0006).
Create a chart of accounts for the new business units using Copy Accounts to Business Units (P09804).
Note:
The chart of accounts should be consistent across all companies.Change all company specific Dreamwriters, World Writers, FASTRs, AAIs, and the like to reflect the new company number.
Run all integrities for the old company.
Set up Indexed Allocations (P09121 and P093021) to allocate balances from the old company to the new company.
Run all integrities for the new company and verify the results.
Within JD Edwards World there are two methods to change from a calendar year to a fiscal year date pattern. You can:
Set up a short year
Set up a new company
Set up a short year
Changing a date pattern from a fiscal year to a calendar year requires:
Creating a new date pattern for a short year and the calendar year
Changing the fiscal date pattern code in Company Numbers and Names (P00105) to the new date pattern code
Running the Annual Close program (P098201) for the short year.
In addition, options exist to convert all history to the new calendar-year date pattern using the Repost Account Ledger program (P099102 or P099105) and the Annual Close program (P098201), or maintain history in the original fiscal-year date pattern format and post all current and future transactions to the calendar-year date pattern.
To change a date pattern from a fiscal year to a calendar year by setting up a short year, do the following:
Set up a short year pattern and a calendar year date pattern
Note:
The short year is necessary if other companies are to remain on the existing fiscal-year date pattern. If you are converting all of a company's history to the new calendar-year date pattern, each calendar year needs to be set up beginning with the first year on JD Edwards World. Additionally, you will need to run the Repost Account Ledger program (P099105).Execute the Annual Close program (P098201) for fiscal year 2002.
Backup the following files:
Company Constants (F0010)
Account Master (F0901)
Account Ledger (F0911)
Account Balances (F0902)
Run all integrity programs and note any discrepancies.
Note:
Running integrities before and after the date pattern change will allow you to detect any discrepancies that arise as a result of changing date patterns.Change the date pattern in Company Numbers and Names (P00105) to the short-year date pattern with the new beginning date.
Post entries as normal through year-end.
Execute the Annual Close for the short-year.
Run all integrity programs and compare data to previous integrities.
To change from a fiscal year to a calendar year by setting up a new company, do the following:
Set up a new company in Company Numbers and Names (P00105) with the new fiscal date pattern code.
Set up new business units using Revise Single Business Unit (P0006).
Create a chart of accounts for the new business units using Copy Accounts to Business Units (P09804).
Note:
The chart of accounts should be consistent across all companies.Change all company specific Dreamwriters, World Writers, FASTRs, AAIs, and the like to reflect the new company number.
Run all integrities for the old company.
Run Indexed Allocations (P09121) to allocate balances from old company to new company.
Run all integrities for the new company and verify the results.