1. Job Cost Implementation Guide
  2. Performing the Tasks to Set Up New Job Cost Ledgers

Performing the Tasks to Set Up New Job Cost Ledgers

To use additional ledgers to track job cost budgets and review job progress, you must perform specific tasks in sequential order. Because it is easy to neglect a simple setup task, this tasks are listed in the order in which you should perform them to successfully set up and use additional ledgers in JD Edwards EnterpriseOne Job Cost:

  1. Set up the amount and unit ledger types as UDC codes in 09/LT. Amount and unit ledger types share the same first initial; therefore, if you set up ledger type QA, you must use ledger type QU for units.

  2. Set up the ledger type rules, including the job cost rules, for each ledger type separately. Although the form has separate fields for Ledger Type and Units Ledger Type, you cannot set them both up simultaneously on one form. For example, you set up ledger type QA, and then you set up ledger type QU.

    These check boxes must be selected to distinguish the ledger types as JD Edwards EnterpriseOne Job Cost:

    • Roll Original Budget to Next Year on the Ledger Type Rules Setup form.

    • Revise Budget Ledger on the Job Cost Ledger Type Rules form.

  3. After you set up the ledger type rules for both the amount and units ledger, you must add the units ledger type in the Units Ledger Type field of the amount ledger type. For example, you must select the record for the QA ledger and add QU in the Units Ledger Type field.

  4. Set up the ledger types in UDC 51/IL, so that you can set up user defined columns for Job Status Inquiry User Defined Columns (P512000). The system automatically adds formulas for the numeric values that you use for the ledger types that you specify in the Description 02 field of the UDC. In addition to the ledger type, you must specify a value in the Special Handling field:

    • If you enter 1, the system retrieves the values in the net amount posting fields from the Account Balances table (F0902).

    • If you enter 2, the system retrieves the value in the BORG field from table F0902.

  5. For example, if you select UDC 13 for the QA/QU ledger, you must enter QAQU in the Description 02 field of UDC 13 with a special handling code of 1. When you do this, the system adds formula 13 for the budget ledger amount, formula 33 for the budget units ledger, and formula 43 for the header units. The units and header units formulas are hard coded based on the UDC code that you select in 51/IL.

  6. Set up the column formula for each ledger type using the Define Inquiry Columns program (P51921).

  7. Set up the column on the Job Status Inquiry form.

  8. Set up new versions of the Original Budget (P510121) and Budget Revisions (P510171) programs and specify the new budget ledger type (for amounts) in the Budget Amount Ledger Type processing option.

  9. Add the new program versions to the menu, for example, Original Budget QA.

See also: