9 JD Edwards EnterpriseOne Budget Planning and Forecasting Reports

This chapter discusses the report navigation, overview information and a report sample for the following reports:

Note:

This reports guide discusses reports that are commonly used in the JD Edwards EnterpriseOne system. This reports guide does not provide an inclusive list of every report that exists in the system.

This guide is intended to provide overview information for each report. You must refer to the appropriate JD Edwards EnterpriseOne implementation guide for complete report information.

9.1 Generate Forecast Basis Report (R1403)

On the Forecasting and Planning menu (G1411), select Generate Forecast Basis.

Use this program to automatically update the Forecast Basis table (F1403) with a range of accounts, based on AAI item GLGxx for expense and revenue, and basis amounts from the Account Balances table (F0902). In the processing options, you specify the revision number, the ledger type, the fiscal year, the range of periods, and whether to roll up subledger balances.

Review the Generate Forecast Basis report (R1403): Surrounding text describes r1403.png.

9.2 Purge Forecast Basis Report (R1403P)

On the Advanced and Technical menu (G14111), select Purge Forecast Basis.

Use this program to purge all cash forecast basis records in the Forecast Basis table (F1403).

Review the Purge Forecast Basis report (R1403P): Surrounding text describes r1403p.png.

9.3 Generate Forecast Results Report (R1404)

On the Forecasting and Planning menu (G1411), select Generate Forecast Results.

When you run this program, the system:

  • Uses the basis amounts that were retrieved and updated in the Forecast Basis table (F1403).

  • Applies the growth pattern to the basis amounts for accounts with any posting edit code except N (non-posting).

  • Generates forecast amounts only for accounts in the F1403 table that are locked.

Review the Generate Forecast Results report (R1404): Surrounding text describes r1404.png.

9.4 Purge Forecast Results Report (R1404P)

On the Advanced and Technical menu (G14111), select Purge Forecast Results.

Use this program to purge all header and detail results records in the Forecast Results - Header (F1404) and Forecast Results - Detail (F14041) tables.

Review the Purge Forecast Results report (R1404P): Surrounding text describes r1404p.png.

9.5 Apply Forecast to Budget Report (R1407)

On the Forecasting and Planning menu (G1411), select Apply Forecast to Budget.

When you are satisfied with the budget forecast records for a specific revision number, use this program to copy the finalized amounts from the Forecast Results - Header (F1404) and Forecast Results - Detail (F14041) tables and update the BREQ, BAPR, and BORG fields in the Account Balances table (F0902).

Review the Apply Forecast to Budget report (R1407): Surrounding text describes r1407.png.

9.6 Upload/Conversion Report (R14110)

On the Other Budgeting Methods menu (G1421), select Upload/Conversion.

After you review and, if necessary, revise your budget data on the Revise Batch Account Balances form, use this program to copy the data from the Account Balance - Batch File (F0902Z1) to the Account Balances table (F0902).

Review the Upload/Conversion report (R14110): Surrounding text describes r14110.png.

9.7 Budget Worksheet Report (R14113)

On the Budgeting menu (G1412), select Budget Worksheet.

Use this report to review requested, approved, and final budgets.

Review the Budget Worksheet report (R14113): Surrounding text describes r14113.png.

9.8 Budget Pattern Codes Report (R09001P)

On the Work with Budget Patterns form in the Revise Seasonal Patterns program (P09001), select Print Pattern Code from the Report menu.

Use this report to review detailed period budget pattern code information.

Review the Budget Pattern Codes report (R09001P): Surrounding text describes r09001p.png.

9.9 G/L Budget Checking Report (R14115)

On the Budgeting menu (G1412), select G/L Budget Checking Report.

Use this report to identify transactions that create budget overages.

Review the G/L Budget Checking report (R14115): Surrounding text describes r14115.png.