This chapter contains the following topics:
|
Note: Country-specific functionality for reposting the account ledger table exists for Chile, Peru, and Poland. |
|
See Also: |
This table describes the four repost programs in the JD Edwards EnterpriseOne General Accounting system:
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.
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.
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.
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:
Run the Repost Account Ledger program with the processing option set to print the report only.
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.
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.
A post program ends abnormally and the batch is only partially posted.
Possible solution:
Post the specific batch out of balance.
Run the General Journal by Batch report (R09301) to locate the automatic entries that were created for the batch during the post program.
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.
Manually create any missing balancing entries for the batch using the Journal Entry program (P0911).
Post the batch of manually created entries out of balance.
Run the Repost Account Ledger program to print the report only.
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.
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.
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.
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.
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.
Processing options enable you to specify the default processing for programs and reports.
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.
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.
The examples illustrate situations in which you might run Calculate Fiscal Year and Period program (R099103). Possible solutions are provided for each situation.
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:
Set up the new fiscal date pattern and pattern code for July 2007 through December 2007.
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.
Run the Calculate Fiscal Year and Period program to print the report only.
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.
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.
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.
Run the Annual Close program to close the year for 2006 or set the Balance Forward processing option to recalculate balance forward amounts.
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. |
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:
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.
Run the Calculate Fiscal Year and Period program and print the report only.
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
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.
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.
Processing options enable you to specify the default processing for programs and reports.
Use this processing option to specify the mode in which to run the Calculate Fiscal Year and Period program (R099103). Values are:
1: Run the Calculate Fiscal Year and Period program in proof mode.
If you run the Calculate Fiscal Year and Period program in proof mode, the system prints a report displaying the updates to the Account Ledger table (F0911) and the Revenue Recognition G/L info table (F03B117) that will occur if you run the report in final mode. The system does not update the F0911.
2: Run the Calculate Fiscal Year and Period program in final mode.
If you run the Calculate Fiscal Year and Period program in final mode, the system updates the F0911 and F03B117 tables. The system also prints a report displaying the updates made to the F0911 and F03B117 tables so that you have an audit trail.
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.