1. Advanced Job Forecasting Implementation Guide
  2. JD Edwards EnterpriseOne Advanced Job Forecasting Process Overview

JD Edwards EnterpriseOne Advanced Job Forecasting Process Overview

There are two main components of the Advanced Job Forecasting system:

  • User-Defined Methods of Computation (MOC)

    Users can create advanced formulas, and then use those formulas to create user-defined MOCs that can be entered in the Job Cost system when you set up the cost code structure for a job. These user-defined MOCs can provide your organization with added flexibility in how projected final amounts are calculated for each task associated with a job.

  • Advanced Job Forecast Creation

    Users can create job forecasts that enable them to enter detailed forecast information about each account associated with a job. These forecasts can then be reviewed, edited, and approved, and used to update financial information, which can provide your organization with timely, accurate details regarding the costs associated with a job or project.

User-Defined Method of Computation

The method of computation (MOC) determines the fields to which you have access to affect the projected final values, and ultimately, the percent complete. In the JD Edwards EnterpriseOne Job Cost system, users are provided with several hard-coded MOCs to use when creating cost code structures for jobs.

For organizations that require more complex methods of calculating projected final values, the Advanced Job Forecasting system provides the ability to create customized MOCs. When you build user-defined MOCs, you enter rules with sequential steps. Each rule in the MOC you create is color coded for easy viewing. You can base rules upon values or formulas. If you choose to use formulas in your MOCs, you must build the formulas before you build the MOC.

After you create your user-defined MOCs, you use them in the Job Cost system just as you would use the standard Job Cost MOCs. However, in addition to standard job cost processing, you must also activate system 51F, and run the Update Projected Final for User-Defined MOC program (R51F140) to update the HA, HU, FA and FU ledgers in the F0911 and F0902 tables.

Advanced Job Forecast Creation

You use the Advanced Job Forecasting system to create detailed forecasts of the costs associated with a job. Using this system, you can automatically load the cost codes and cost types (accounts) associated with a job, for a given time period, into the forecast. The accounts are each represented by a row in the forecast grid and include the current amounts and previous amounts (if they exist) from the general ledger.

Each row in the forecast includes a method of computation (MOC), which is retrieved from the F0901 table. The MOC determines how the system calculates the Projected Final Amounts and Projected Final Units for each account. The MOC can be:

  • One of the standard MOCs from the Job Cost system.

  • A user-defined MOC.

You can leave the MOC as it is, or you can change it to one of the Advanced Job Forecasting methods. These methods enable you to enter forecast estimates in different ways for each account.

The Advanced Job Forecasting methods of computation include:

  • W

    Use this MOC to update the Revised Estimate At Completion (EAC) amounts and units for the account.

    You use this method when the best estimate you have for the account is what the total amounts and units will be when the task is complete. For example, if your vendor tells you their total cost will be $1,000,000.00 USD when they have completed their work, you would use this method to enter your estimate for the associated account.

  • Y

    Use this MOC to update the Revised Estimate To Complete (ETC) amounts and units for the account.

    Use this method when the best estimate you have for the account is what the total remaining amounts or units are required to complete the task. For example, if your vendor tells you it will cost $25,000.00 USD to complete the work, you would use this method to enter your estimates for the associated account.

  • Z

    Use this MOC to update remaining work information for the account.

    Use this method when the best estimate you have for the account is the amount of remaining work that is required to complete a task. For example, if your vendor tells you it will take 200 man-hours and 300 cubic yards of concrete to complete a task, you would use this method.

Use the Revised Estimate to Complete and Revised Estimate At Completion amounts and units fields only when you want to make changes to the Projected Final Amounts or Projected Final Units for that account. If there are no changes to the Projected Final Amounts or Projected Final Units for that account, you should leave the respective Revised EAC or ETC amounts blank. Amounts in these fields are indicators that there are changes to the forecast.

You can also leave the MOC as it is. Regardless of the MOC, you can also update the To-Be-Committed amounts and units for an account.

After you enter your estimates, you can change the status of the forecast to In Review and allow your management team to review the current estimates for the job.

When the forecast has been reviewed, and all updates are complete, you can change the status to Approved. When you change the status to approved, you can set up the Advanced Job Forecasting system to automatically update the general ledger with the revised forecast estimates, or you can run batch programs to update the general ledger for selected approved forecasts.