42 Update Work Order Information

This chapter contains these topics:

42.1 Updating Work Order Information

You can update certain work order information globally to reduce the amount of processing time it takes to maintain current information throughout your organization.

42.2 Updating Work Order Cost

Navigation

From Equipment/Plant Management (G13), enter 27

From Advanced Operations (G1331), choose Update Work Order Cost

Run the Update Work Order Cost program to replace the actual hours in the Work Order Routing table (F3112) with the total hours for each operation sequence from the Payroll Transaction History table. The program also reads the Account Ledger table for material and subcontract amounts. The program then updates the following information in the Work Order Master table:

  • Actual labor costs

  • Actual material costs

  • Actual hours

  • Actual amount

  • Actual other costs

  • Actual duration (downtime hours)

42.3 Updating Work Order Status Based on Purchase Order Receipt

Navigation

From Equipment/Plant Management (G13), enter 27

From Advanced Operations (G1331), choose Update Work Order Status/PO Receipt

You can update the status of work orders based on whether parts ordered from associated purchase orders have been received. This is especially useful to schedule work orders based on the arrival of ordered parts. You can specify the status that the system updates work orders based on both partial and full receipt of the items on the associated purchase order. You can also specify the recipient of an e-mail message informing of the change in work order status.

When you choose Update Work Order Status/PO Receipt, a versions list appears. The versions list contains a DEMO version that you can run, or copy and modify to suit your needs. When you run a version, Processing Options Revisions appears before the system submits the job for processing.

42.4 Updating the Standard Parts List

When you change a work order parts list, you can update the Bill of Materials Master table (F3002) to ensure that all future work orders that use the same standard parts list reflect the change.

When you add a part to a work order parts list, the Update Standard Parts List program adds the part to the standard parts list. When you change the quantity of a part on the work order parts list, the program updates the quantity on the standard parts list.

42.4.1 What You Should Know About

Topic Discussion
Updating parts quantities The Update the Standard Parts List program compares the transaction quantity on the work order part to the quantity indicated on the standard parts list when it updates the standard parts list.
Updating the equipment parts list You can use the Update the Standard Parts List program to update the equipment parts list. The update program works the same way as for the standard parts list, except that it updates the standard parts list from the Equipment Master table(F1201) instead of the Work Order Master table (F4801).

42.5 Updating the Phase or Equipment Number in the G/L

Navigation

From Equipment/Plant Management (G13), enter 27

From Advanced Operations (G1331), choose Update Phase/Equipment Number in the G/L

If you post work order transactions to the general ledger and then change the equipment number or the phase code on the work order, you should run this update to ensure that the Account Ledger table (F0911) reflects the most current work order information. You can use this program to reflect changes to the phase code or equipment number for multiple work orders. You can also use this program to enter a value in the phase field on many general ledger transactions.

When you choose Update Phase/Equipment Number in the General Ledger, the system submits the job directly to batch processing.

42.5.1 Before You Begin

  • Back up the Work Order Master table (F4801)

  • Verify that no one accesses the Work Order Master table while you run this procedure