Working with Hours and Quantities

This chapter provides an overview of hours and quantities and discusses how to:

• Enter hours and quantities.

• Update hours and quantities.

• Review statuses and transactions.

Understanding Hours and Quantities

As you produce the items on a work request, you need to record the hours spent on production and the number of items (or co-products and by-products, for process manufacturing) that are completed in that time. This enables you to monitor progress and actual costs and compare them to the standard hours and quantities that you estimated for the job.

If the estimates are reasonably accurate, you can use the Super Backflush program (P31123) to have the system automatically enter the standard values at the pay point operations in the routing instructions. Otherwise, you can have all employees individually enter their time and the quantities that they completed.

The JD Edwards EnterpriseOne Shop Floor Management system interfaces with the time entry feature of the JD Edwards EnterpriseOne Time Accounting system so that employee hours and quantities produced have to be entered only once. The single entry saves time, reduces the risk of data entry error, and ensures that data throughout the enterprise is consistent.

The system can record hours and quantities in the work order record and in the JD Edwards EnterpriseOne Time and Labor system. Hours and quantities can be applied to a specific work order so that you can maintain accurate manufacturing accounting and costing data. To accommodate both piecework and hourly-rate employees, you can record hours and quantities either per work order or per employee.

The JD Edwards EnterpriseOne Shop Floor Management system manages hour and quantity information in the same manner whether you enter it in the Hours and Quantities program (P311221) or in the Speed Time Entry program (P051121) in the JD Edwards EnterpriseOne Time and Labor system. If you use the JD Edwards EnterpriseOne Time and Labor system in conjunction with the JD Edwards EnterpriseOne Shop Floor Management system, you should use the Speed Time Entry program to enter hours and quantities information.

After you enter hours and quantities on either time entry form, you can review and revise them before you post them to the JD Edwards EnterpriseOne Manufacturing system for further tracking and cost accounting. You can review the hours and quantities either online or by printing a report.

Note. When you change the status of a routing operation, the change does not take effect until you run the Hours and Quantities Update program (R31422) to update the Work Order Routing table (F3112).

The system stores header information from the Work With Work Order Time Entry form (W311221B) in the Work Order Master File table (F4801). Detail information is stored in the Work Order Time Transactions table (F31122).

If you use the JD Edwards EnterpriseOne Quality Management system, as you record actual hours and quantities for a work order, you can access the Enter Test Results program (P3711) for completed items that require testing.

Entering Hours and Quantities

This section provides an overview hours and quantities entry and discusses how to:

• Set processing options for the Hours and Quantities program (P311221).

• Enter hours and quantities.

Understanding Hours and Quantities Entry

Use the Hours and Quantities program (P311221) to charge actual hours and quantities to a work order. You can use the processing options to specify either of these formats for work order time entry:

Consider this important information about entering hours and quantities:

• Enter the quantity completed only once per operation sequence number. Entering it for each type of hours causes a variance amount.

• Enter hours using beginning and ending times for each entry or the actual hours, up to two decimal places.

• To reverse completed or scrapped quantities that you have entered, enter the quantity as a negative quantity.

• If you activate the Apply Yield to Completed Quantity processing option, the system applies the operation yield percentage to the completed quantity. When you enter the completed quantity, the system automatically adds a scrap quantity line that is calculated based on the yield percentage.

• The system verifies that the completed and scrapped quantities that you enter do not exceed the quantity at operation.

  Note. If you use the Speed Time Entry program (P051121), you can set the Manufacturing Time Entry processing option to update the information in the Hours and Quantities program.

After you enter hours and quantities, you can review the entries on the Work With Work Order Time Entry form.

If you entered a quantity that you want to be posted as complete, the system adds a separate detail line for the completed quantity (Type of Hours 4). If scrap exists, the system adds a scrap quantity line (Type of Hours 5).

See Also

Hours and Quantities

Processing Test Results

Entering Timecards for Employees

Forms Used to Enter Hours and Quantities

Setting Processing Options for the Hours and Quantities Program (P311221)

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

Display

This processing option controls whether the system displays the Time Entry Revisions form (W051131A) in order number or employee number format.

Defaults

These processing options control the default values for the document type and work order status code that are used in the Hours and Quantities program.

Edits

These processing options control processing in the Hours and Quantities program, such as whether the system performs quantity verification or applies a yield percentage to the completed quantity.

Versions

These processing options control which version the system uses when these programs are called from the Hours and Quantities program.

Interoperability

These processing options control which transaction type the system uses for outbound hours and quantities transactions and whether the system writes a before image for the work order header.

Entering Hours and Quantities

Access the Time Entry Revisions form.

Oper # (operation number)	Enter a number used to indicate an order of succession. In routing instructions, a number that sequences the fabrication or assembly steps in the manufacture of an item. You can track costs and charge time by operation. In bills of material, a number that designates the routing step in the fabrication or assembly process that requires a specified component part. You define the operation sequence after you create the routing instructions for the item. The JD Edwards EnterpriseOne Shop Floor Management system uses this number in the backflush/preflush by operation process. In engineering change orders, a number that sequences the assembly steps for the engineering change. For repetitive manufacturing, a number that identifies the sequence in which an item is scheduled to be produced. Skip To fields enable you to enter an operation sequence that you want to begin the display of information. You can use decimals to add steps between existing steps. For example, use 12.5 to add a step between steps 12 and 13. This is the sequence number of the routing step on the work order. You must enter this number.
Ty Hrs	Enter a code that indicates the type of time entered. Values are: 1: Run Labor Hours 2: Setup Labor Hours 3: Machine Hours 4: Quantities Completed 5: Quantities Scrapped 9: Miscellaneous (such as piece rate bonus)
Hours	Enter the number of hours associated with each transaction.
Quantity	Enter the number of units committed for shipment in Sales Order Entry, using either the entered or the primary unit of measure defined for this item. In the JD Edwards EnterpriseOne Manufacturing system and the Work Order Time Entry program, this field can indicate completed or scrapped quantities. The quantity type is determined by the type code entered.
Equipment Number	Enter an identification code that represents an asset. You enter the identification code in one of these formats: 1: Asset number (a computer-assigned, eight-digit, numeric control number) 2: Unit number (a 12-character alphanumeric field) 3: Serial number (a 25-character alphanumeric field) Every asset has an asset number. You can use unit number and serial number to further identify assets. If this is a data entry field, the first character you enter indicates whether you are entering the primary (default) format that is defined for the system, or one of the other two formats. A special character (such as / or *) in the first position of this field indicates which asset number format you are using. You assign special characters to asset number formats in the fixed assets constants.
St (status)	Enter a value from UDC 31/OS (Operation Status) that identifies the current status of a work order or engineering change order as the operation steps in the routing are completed.
Employee Rate	Enter the employee's hourly rate as retrieved, entered or calculated during time entry. (See also GRT, PWRT, BRT.) In the Employee Master file, this is the employee's base hourly rate. In the Union Rates file, this is the straight time rate. Note. If you change the value of the DATA DISPLAY DECIMALS for this field, you must also change the field GRT to have exactly the same data display decimals
Equipment Rate	Enter a code that represents the amount that you want to charge the job. Each piece of equipment can have numerous billing rates based on the rate code. The equipment billing rate can be composed of up to ten different rates. For example: Billing Rate = 200 100 Rate 1 (Ownership Component) 25 Rate 2 (Operating Component) 50 Rate 3 (Maintenance Component) 25 Rate 4 (Other Costs Component) When you post time entries to the general ledger, the system recognizes credits in revenue accounts for each of the rate components. This enables you to separate portions of the equipment billing by type of cost. Note. You are not required to use rate components.
Reason Code	Enter a value from UDC 42/RC (Reason Code) that explains the purpose for a transaction. For example, you can indicate the reason that you are returning items.

Updating Hours and Quantities

This section provides an overview of hours and quantities update and discusses how to:

• Update hours and quantities.

• Set processing options for the Hours and Quantities Update program (R31422).

Understanding Hours and Quantities Update

To post hours and quantities to the JD Edwards EnterpriseOne Manufacturing system, you must run the Hours and Quantities Update program (R31422). This program updates the Work Order Routing table (F3112) with unaccounted labor units and amounts for each work order operation. This table then supplies the manufacturing accounting programs with the current data. Before the data is updated, you can locate and change it as necessary. After you run this program, you cannot locate the data on the Time Entry Revisions form (W051131A).

If you use the Super Backflush program (P31123) to enter hours and quantities, the quantity transactions are posted in real time. The program enters the transactions at the points in the routing instructions that you specify. To post hours, you still have to run the Hours and Quantities Update program. The system posts only the records that are in the current entry session. Therefore, if you exit the Super Backflush form after you enter the transaction data, you must locate the data on the Time Entry Revisions form and change the records to make them current with the system.

When you run this batch program from the menu, you use data selection to update those records that have not yet been posted. The system retrieves the hours and quantities information from the Work Order Time Transactions table (F31122). The system enters a P in the Processed Code field for each entry that it updates so that the record cannot be updated again. If you access the update program from Time Entry Revisions form, the system updates the time entry lines that appear on the form for the selected work order or employee. After the update, the system clears the form, and the records that were processed no longer appear.

Updating Hours and Quantities

From the Daily Order Reporting - Discrete menu (G3112), select Hours and Quantities Update.

Setting Processing Options for the Hours and Quantities Update Program (R31422)

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

Interoperability

These processing options control the transaction type for outbound hours and quantities transactions and the call to the batch program for the outbound subsystem.

S/WM

These processing options control processing for JD Edwards EnterpriseOne Service Management. For example, the processing options control whether the system creates journal entries, whether flex accounting is used, and whether the order number should be used as a default value for the subledger field.

Defaults

This processing option controls the status that the system assigns to the work order when hours and quantities are posted to the work order routing.

Reviewing Statuses and Transactions

This section provides overviews of the review of statuses and transactions and discusses how to:

• Run the Hours and Quantities Proof report.

• Review the status of hours.

• Review the status of quantities.

• Set processing options for the Operation Quantity Inquiry program (P31124).

Understanding the Review of Statuses and Transactions

After you enter hours and quantities, you can review the information either online or by printing a report. To review hours and quantity entries before you post them, you can use the Hours and Quantities Proof program (R31322). Then, you run the Hours and Quantities Update program (R31422) to post the entries.

You can use the Order Hours Status program (P31121) to display the actual hours for machine, labor, and setup hours entered for each operation that is associated with a work order. You can also access the Work Order Status - Hours Revisions form, on which you can review the actual, standard, and variance values for the hours.

You can use the Order Quantities Status program (P31122) to display the quantities entered for the operations that are scheduled for a work order, including the actual quantity ordered, completed, and scrapped for each operation. You can also access the Quantities Revision form, on which you can review the actual, standard, and variance values for the quantities.

You can use the Operation Quantity Inquiry program (P31124) to display the routing instructions, operation quantity, quantity completed, and quantity scrapped for a work order, including the projected quantity complete and projected yield, for each operation and for the entire order. Processing options enable you to define the default from and through statuses.

To review hours and quantities entries before you post them, you can use the Hours and Quantities Proof program (R31322)

Reviewing Hours and Quantities Transactions

The Hours and Quantities Proof program (R31322) enables you to print a report that lists all labor hours and completed quantities that are recorded for a work order. You can print the hours and quantities transactions that have been entered and review them before you post them to the JD Edwards EnterpriseOne General Ledger system. Before you post the transactions, you can change or update them. After you post them, you cannot change them. The system retrieves the hours and quantities information from the Work Order Time Transactions table (F31122).

Forms Used to Review Hours and Quantities Transactions

Running the Hours and Quantities Proof Report

From the Daily Order Reporting - Discrete menu (G3112), select Hours and Quantities Proof.

Reviewing the Status of Hours

Access the Work Order Status - Hours Revisions form.

Reviewing the Status of Quantities

Access the Work Order Status - Quantities Revisions form.

Setting Processing Options for the Operation Quantity Inquiry Program (P31124)

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

Defaults

Status Info