18 Work with Hours and Quantities
This chapter contains these topics:
-
Section 18.2, "Where in the Process Do You Enter Hours and Quantities"
-
Section 18.4, "Entering Hours and Quantities through Payroll Time Entry"
18.1 Overview
As you work to produce the process on a work request, you need to record the hours spent on production and the number of co-/by-products completed in that time. This allows you to monitor progress and actual costs and compare them against the standard hours and quantities you estimated for the job.
If your estimates are fairly accurate, you can have the system automatically enter the standard values for you at various points in the routing. Or, you can have all of your employees individually enter their time and quantities completed.
The Shop Floor Control system interfaces with the JD Edwards World Payroll system so that you only have to enter an employee's hours and quantities produced once. The single entry saves time and reduces the risk of data entry error, while ensuring that data across your systems is consistent.
The information is recorded in the Payroll system as well as against a work order in the Manufacturing system. The hours and quantities can be applied to a specific work order so you can maintain accurate manufacturing accounting and costing data. You can record hours and quantities per work order or per employee, to accommodate both piece-work and hourly rate employees.
The Shop Floor Control system manages hour and quantity information in the same whether you enter it on the Hours and Quantities Entry screen or the Payroll Time Entry screen. If you want to interface with the Payroll system, you should use the Payroll Time Entry screen to enter hours and quantities information.
After you enter hours and quantities, either manually or through payroll time entry, you can review and revise them before you process them to the Manufacturing system for further tracking and cost accounting. You can review the hours and quantities either online or using a report.
| Topic | Description |
|---|---|
| Changing the status | When you change the status of a routing operation, the change does not take effect until you run the Hours and Quantities Update to update the Shop Floor Control Routing Instructions table (F3112). |
| Resources | The header information comes from the Work Order Master table (F4801). The detail information is stored in the Work Order Time Transactions table (F31122). |
| Quality Management test results | As you record actual hours and quantities to a work order, you can:
See Working with Test Results in the JD Edwards World Quality Management Guide for more information. |
See Also:
-
Work with Work Orders in the JD Edwards World Product Costing and Manufacturing Accounting Guide
18.2 Where in the Process Do You Enter Hours and Quantities
Figure 18-1 Where in the Process Hours and Quantities Are Entered
Description of "Figure 18-1 Where in the Process Hours and Quantities Are Entered"
18.3 Entering Hours and Quantities Manually
From Shop Floor Control (G31), choose Daily Order Reporting under Process
From Daily Order Reporting - Process (G3114), choose Hours and Quantities Entry
Use the Hours and Quantities program to charge actual hours and quantities to a work order. You can use the processing options to display the information in order number format or employee number format. Use these formats to record time and quantities for employees against work order routing steps or work order routing steps against employees.
Note the following important information about entering hours and quantities:
-
Enter the quantity completed only once per operation sequence number. Entering it for each type of hours will cause a variance amount.
-
Enter the hours using begin and end times for each entry or the actual hours up to 2 decimal places.
-
To reverse completed or scrapped quantities you have entered, enter the quantity you want to reverse as a negative quantity.
As an alternative to entering hours and quantities manually, you can use the Work Order Hrs & Qty - Z File program (P311221Z) to import an extensive amount of hours and quantities into your system. See Appendix C, "Import Mass Data into Manufacturing Systems" for more information.
To enter hours and quantities manually
On Hours and Quantities - Order Number format
Figure 18-2 Hours & Quantities Entry screen
Description of "Figure 18-2 Hours & Quantities Entry screen"
-
Complete the following fields:
-
Work Date
-
Shift
-
Order Number
-
Operation Sequence Number
-
Type of Hours
-
Hours
-
Quantity
-
Unit of Measure
-
Status
-
-
Figure 18-3 Hours & Quantities Entry screen, Detail area
Description of "Figure 18-3 Hours & Quantities Entry screen, Detail area"
-
Complete the following optional fields:
-
Miscellaneous Dollars
-
Employee Rate
-
Equipment Rate
-
Reason Code
-
Explanation
-
| Field | Explanation |
|---|---|
| Work Date | A date that identifies the financial period to which the transaction is to be processed. The general accounting constants specify the date range for each financial period. You can have up to 14 periods. Generally, period 14 is for audit adjustments.
The system edits this field for PBCO (posted before cutoff), PYEB (prior year ending balance), and so on. |
| Op Seq | In routings, this number is used to sequence the fabrication or assembly steps in the manufacture of an item. You can track costs and charge time by operation.
In bills of material, this number 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 for the item. The Shop Floor Control system uses this field in the backflush/preflush by operation process. In engineering change orders, this number is used to sequence the assembly steps for the engineering change. Skip To fields allow 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. Form-specific information This is the sequence number of the routing step on the work order. You must enter this number. |
| T H | A code to indicate the type of time entered. Valid codes are:
1 – Run Labor Hours 2 – Setup Labor Hours 3 – Machine Hours 4 – Quantities Completed 5 – Quantities Scrapped 9 – Miscellaneous (piece rate bonus and so forth) |
| Hours | The number of hours associated with each transaction. |
| Misc. Dollars | The actual gross pay amount for an employee. This is to be distinguished from the distributed gross pay amount used for labor distribution. See data item DPAY.
When using Work Order Time Entry, use this field to record miscellaneous pay for an employee, such as piece rate bonus. The employee's insurable gross pay for the listed pay period. |
| Equipment Rate | A code that represents the amount 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 Accounting system, the system recognizes credits in revenue accounts for each of the rate components. This allows you to separate portions of the equipment billing by type of cost. Note: You are not required to use rate components. Manufacturing Accounting for Shop Floor work orders does not use rate components. |
| Explanation | A name or remark that describes an element in the JD Edwards World systems. |
18.4 Entering Hours and Quantities through Payroll Time Entry
From Shop Floor Control (G31), choose Process Daily Order Reporting From Daily Order Reporting - Process (G3114), choose Payroll Time Entry
The manufacturing interface to the Payroll Time Entry screen lets you enter payroll information plus additional manufacturing information that appears on the Hours and Quantities Entry screen. On the Payroll Time Entry screen, you can:
-
Designate hours as setup, labor, or machine related, and record them against a specific routing operation for the process
-
Record the quantity of pieces completed and scrapped by the employee against a specific routing operation for the process
-
Update the status of a routing operation for a process
You can use processing options to enter:
-
A work order status code beyond which entries to the work order cannot be made
-
The document type associated with shop floor activity
-
The version of the Hours and Quantities screen to access
The system concurrently enters the entries you make on the Payroll Time entry screen on the Hours and Quantities screen. After you have entered the data into the Payroll system, you can process it.
You can use Toggle Display Format (F17) to change the display of the fields in the detail area (fold). If you set up Enhanced Subledger Accounting, you can view and change these values in the detail area. See Work with Enhanced Subledger Accounting in the JD Edwards World General Accounting I Guidefor more information.
18.4.2 What You Should Know About
To enter hours and quantities through payroll time entry
On Payroll Time Entry
Complete the following fields:
-
Employee
-
Date
-
Order Number
-
Operation Sequence Number
-
Type
-
Beginning Hours
-
Units
-
Unit of Measure
-
Status
-
Hourly Rate
18.5 Updating Hours and Quantities
To process the hours and quantities into the Manufacturing system, you must run the Hours and Quantities Update batch program. This updates the Shop Floor Control Routing Instructions table (F3112) and supplies the manufacturing accounting programs with the current data. After you run this program, you cannot locate the data on the Hours and Quantities screen. Before the data is updated, you can locate it and change it as necessary.
You can process hours and quantities transactions in the Manufacturing system by:
-
Running the Hours and Quantities Update batch program from the menu
-
Selecting the online update from the Hours and Quantities screen
The method of processing you use depends on how you enter the transaction data.
-
If you use Super Backflush to enter hours and quantities, the quantities transactions are processed in real time. However, you must run the update to process the hours. Super Backflush enters the transactions for you at the point in the routing that you specify. Super Backflush has a processing option to run this update automatically.
-
If you enter the data on the Payroll Time Entry screen, or run Super Backflush, you must either run the update or locate the data on the Hours and Quantities Entry screen, and then use the online update selection.
-
If you enter the transaction data on the Hours and Quantities Entry screen, you can use the menu selection or the online update selection to run the update.
Complete the following tasks:
-
Update hours and quantities manually
-
Update hours and quantities by batch
18.5.2 What You Should Know About
| Topic | Description |
|---|---|
| Using quantities at operation for intermediates | For the Hours and Quantities Update program, when the system updates the quantity completed or scrapped for an operation in the routing table, the system deducts the quantity from the operation and adds it to the next operation. If the next operation has an intermediate, the system converts the quantity added to the intermediate unit of measure. |
To update hours and quantities manually
From Shop Floor Management (G31), choose Daily Order Reporting under Process
From Daily Order Reporting - Process (G3114), choose Hours & Quantities Entry
On Hours and Quantities
Figure 18-5 Hours & Quantities Entry screen
Description of "Figure 18-5 Hours & Quantities Entry screen"
-
Order Number/Employee Number
The system only processes the records that are in the current entry session. Therefore, if you exited the screen after you entered the transaction data or entered it on the Payroll Time Entry screen, you must locate the data on the Hours and Quantities screen, and change the records to make them current to the system.
The update takes the hours and quantities recorded against work order operations and updates them to their matching fields in the Shop Floor Control Routing Instructions table (F3112). After the update, the screen clears and the records that were processed no longer appear. The system enters a P in the Processed Code field for each entry it updates so that the record cannot be updated again.
To update hours and quantities by batch
From Shop Floor Management (G31), choose Daily Order Reporting under Process
From Daily Order Reporting - Process (G3114), choose Hours & Quantities Update
You should only update those records that have not yet been processed. Records that have not been processed have a blank Processed Code field. Run the reporting version to process the transactions.
18.6 Reviewing Hours and Quantities Transactions
After you enter hours and quantities, either manually or through payroll time entry, you can review and revise them before you process them to the Manufacturing system for further tracking and cost accounting. You can review the hours and quantities either online or using a report.
Complete the following tasks:
-
Review the status of hours, quantities, and operation quantities
-
Review the hours and quantities report
To review the status of hours, quantities, and operation quantities
From Shop Floor Management (G31), choose Daily Order Reporting
under Process Daily Order Reporting - Process (G3114), choose Production Status
The Production Status program allows you to review the status of all work orders by work center, item number, or order number within status and date ranges. This program displays historical and work remaining information.
On Production Status
-
Complete the following fields:
-
Work Center/Line
-
Item Number
-
Branch/Plant
-
-
Complete the following optional fields:
-
Order Number
-
Status
-
Date Range
-
-
Access the detail area.
To review the hours and quantities report
From Shop Floor Management (G31), choose Daily Order Reporting
under Process Daily Order Reporting - Process (G3114), choose Hours & Quantities Proof
The Hours and Quantities Proof report lists all labor hours and completed quantities recorded against a work order. You can total the hours and quantities in various ways, such as by employee, work order, item, operation, and so forth.
Using the Hours and Quantities Proof, you can print the hours and quantities transactions that have been entered and review them before you process them to the system. Before they are processed, the transactions can be changed and updated. After you process them, they cannot be changed.
Figure 18-6 Hours & Quantities Journal report
Description of "Figure 18-6 Hours & Quantities Journal report"