39 Reposting the Account Ledger and Recalculating a Fiscal Year

This chapter contains the following topics:

Note:

Country-specific functionality for reposting the account ledger table exists for Chile, Peru, and Poland.

39.1 Understanding the Repost Programs

This table describes the four repost programs in the JD Edwards EnterpriseOne General Accounting system:

Repost Program Description
Repost Account Ledger (R099102) Use this program to:
  • Correct damaged account balances in the F0902 table.

    You must update account balances with the posted amounts from the F0911 table.

  • Post by currency when it becomes an organizational requirement.

    You must update the F0902 table to reflect the currency information.

Calculate Fiscal Year and Period (R099103) Use this program to restate account balances to a new fiscal year or period. This program recalculates the fiscal year and period in the F0911 table using a revised fiscal pattern that is specified in the Date Fiscal Patterns table (F0008). This program also maintains an audit trail of account ledger transactions that transfer account balances to new periods or fiscal years.

If you run this program, you must also run the Repost Account Ledger program to update the F0902 table.


39.2 Prerequisites

Before you complete the tasks in this section:

  • Place security on the repost program.

  • Post all transactions to avoid creating automatic offsets to the incorrect period.

  • Update fiscal date patterns for the company, if necessary.

  • Back up the F0901, F0902, and F0911 tables.

39.3 Reposting the Account Ledger

This section provides an overview of when to repost the account ledger, lists a prerequisite, and discusses how to:

  • Run the Repost Account Ledger program.

  • Set data selection and sequence for Repost Account Ledger.

  • Set processing options for Repost Account Ledger.

39.3.1 Understanding When to Repost the Account Ledger

The examples in this section describe situations in which you might run the Repost Account Ledger program (R099102). Possible solutions are provided for each situation.

39.3.1.1 Example: F0911 and F0902 Tables Are Out of Balance

You post all account ledger transactions and the amount in the F0911 table appears to be correct. You compare the amounts in the F0911 and F0902 tables and note that the amounts are out of balance.

Possible solution:

  1. Run the Repost Account Ledger program with the processing option set to print the report only.

  2. Review the report and compare the amounts in the Old Balance (current F0902) and Detail Amount (current F0911) columns to verify that the amount in the F0911 table is correct.

  3. Run the Repost Account Ledger program in update mode to print the report and update the F0902 table with the amount from the F0911 table.

39.3.1.2 Example: Batch Is Partially Posted

A post program ends abnormally and the batch is only partially posted.

Possible solution:

  1. Post the specific batch out of balance.

  2. Run the General Journal by Batch report (R09301) to locate the automatic entries that were created for the batch during the post program.

  3. Change the Intercompany Settlements field to * on the General Accounting Constants form to allow manual intercompany settlements.

    Remember to set the Intercompany Settlements field back to its original setting after you complete these steps.

  4. Manually create any missing balancing entries for the batch using the Journal Entry program (P0911).

  5. Post the batch of manually created entries out of balance.

  6. Run the Repost Account Ledger program to print the report only.

  7. Review the report, and compare the amounts in the Old Balance and Detail Amount columns to verify that the amount in the F0911 table is correct.

  8. If necessary, Run the Repost Account Ledger program in update mode to print the report and update the F0902 table with the amount from the F0911 table.

39.3.1.3 Example: After Recalculating Fiscal Year and Period

After you run the Calculate Fiscal Year and Period program (R099103) to recalculate the fiscal year and period, you must run the Repost Account Ledger program to:

  • Update account balances with the posted amounts from the F0911 table.

  • Maintain an audit trail of account ledger transactions that transfer account balances to new periods or fiscal years.

If you purge the transaction detail for one or more years, the processing options enable you to specify the beginning balance forward for one fiscal year to be carried forward to the first fiscal year under the new date pattern.

39.3.2 Prerequisite

Run the Repost Account Ledger program during non-business hours when no users are on the system because it can take a considerable amount of processing time.

39.3.3 Running the Repost Account Ledger Program

Select Global Updates (G09316), Repost Account Ledger.

39.3.4 Setting Data Selection and Sequence for Repost Account Ledger

If you have recalculated the fiscal year and period, you must use the same data selection that you used when you ran the Calculate Fiscal Year and Period program.

If only one period needs to be reposted, do not specify the period. Instead, specify the entire fiscal year in the data selection. Otherwise, only information for that period exists in the F0902 table and all other period information is cleared.

The system does not repost ledger type BA because budget amounts do not require transaction support in the F0911 table. If you have defined ledger types that do not have complete transaction support, change the data selection to bypass the ledgers.

The system automatically reposts unit ledgers with the amount information. For example, to repost an actual amounts ledger (AA) with units (AU), enter ledger type AA in the data selection. The system reposts both the amount and unit ledgers.

Do not change the data sequence.

39.3.5 Setting Processing Options for Repost Account Ledger (R099102)

Processing options enable you to specify the default processing for programs and reports.

39.3.5.1 Mode

1. Process Mode

Specify the processing mode. Values are:

1: Print report.

The system prints a report that shows the changes to the F0911 table that occur if you run the report in update mode.

2: Print report and update.

The system prints a report that shows the changes made to the F0911 table and updates the F0902 table to match the F0911 table.

39.4 Recalculating the Fiscal Year and Period

This section provides an overview of when to recalculate the fiscal year and period and discusses how to:

  • Run the Calculate Fiscal Year and Period program.

  • Set data selection and sequence for Calculate Fiscal Year and Period.

  • Set processing options for Calculate Fiscal Year and Period.

39.4.1 Understanding When to Recalculate the Fiscal Year and Period

The examples illustrate situations in which you might run Calculate Fiscal Year and Period program (R099103). Possible solutions are provided for each situation.

39.4.1.1 Example: Fiscal Date Pattern Changes to a Calendar Date Pattern

Your company has been operating under a July through June fiscal date pattern. Due to a merger, you must change to a January through December calendar date pattern.

The current fiscal year is 2006. Your current fiscal year pattern is July 2006 through June 2007. The next calendar year is January through December 2008.

Possible solution:

  1. Set up the new fiscal date pattern and pattern code for July 2007 through December 2007.

  2. Using the new fiscal date pattern and pattern code (from step 1), set up the new fiscal date pattern and pattern code for January through December 2008.

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

  4. Review the report and compare, on a line-by-line basis, the old and new century (CT), fiscal quarter (FQ), fiscal year (FY), and period number (PN) columns for accuracy.

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

    To calculate a new balance forward amount in the F0902 table, complete the processing options on the Balance Forward tab.

  6. 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.

  7. Run the Annual Close program to close the year for 2006 or set the Balance Forward processing option to recalculate balance forward amounts.

  8. Run the Annual Close program to close the year for 2007 or set the Balance Forward processing option to recalculate balance forward amounts.

Important:

For the fiscal year 2006, the current fiscal year pattern is July 2006 through June 2007. For the fiscal year 2007, the current fiscal year pattern is July 2007 through December 2007. For the fiscal year 2008, the calendar year is January through December 2008. Be aware that when comparing period 1 amounts for different fiscal years, you are viewing amounts for different months.

39.4.1.2 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

39.4.2 Running the Calculate Fiscal Year and Period Program

In update mode, the Calculate Fiscal Year and Period program restates account balances to a new fiscal year or period. Specifically, it recalculates the fiscal year and period in the Account Ledger (F0911) and the Revenue Recognition G/L Information (F03B117) tables using a revised fiscal pattern in the F0008 table.

Select Global Updates (G09316), Calculate Fiscal Year and Period.

39.4.3 Setting Data Selection and Sequence for Calculate Fiscal Year and Period

For the data selection, enter a company, ledger type, and fiscal year or any combination of the three. If you are changing fiscal periods, do not specify a fiscal year.

Do not change the data sequence.

39.4.4 Setting Processing Options for Calculate Fiscal Year and Period (R099103)

Processing options enable you to specify the default processing for programs and reports.

39.4.4.1 Mode

1. Process Mode

Specify the processing model. Values are:

1: Print report.

The system prints a report that shows the updates that occur to the F0911 table if you run the report in update mode.

2: Print report and update.

The system updates the F0911 table and prints a report that shows the updates made to the F0911 to use for an audit trail. You must also run the Report Account ledger program to update the F0902 table.

2. Version Name For R099102

Specify whether to run the Repost Account Ledger program. Values are:

Blank: Do not run.

XJDE0001: Print.

The system prints a report that shows the updates that occur to the F0902 table if you run the report in update mode.

XJDE0002: Print and update.

The system updates the F0902 table and prints a report that shows the updates made to the F0902 table to use for an audit trail.