## Appendix: JD Edwards EnterpriseOne Shop Floor Management Reports

This appendix provides an overview of shop floor reports and enables you to:

- View a summary table of all reports.

- View details for selected reports.

### JD Edwards EnterpriseOne Shop Floor Management Reports: A to Z

This table lists the JD Edwards EnterpriseOne Shop Floor Management reports, sorted alphanumerically by report ID.

Report ID and Report Name | Description | Navigation
R3118P Shortage Revisions Print | Lists shortage details for each short item. | Periodic Functions - Discrete (G3121), All Shortages
R31400 Open Work Orders | Lists work orders in the system. The report displays the planner ID, item number, order quantity, completed quantity, and start and due dates. | Periodic Functions - Discrete (G3121), Work Order Summary
R31418 W. O. Component Shortage List | Lists the component parts required to complete a work order and indicates their current availability. | Periodic Functions - Discrete (G3121), Component Shortages
R31435 Scheduling Workbench by Work Center | Displays scheduling information for a work center. Use this program to plan and run the production in a work center. You can review and change this information in the Dispatch List program (P31220). | Periodic Functions - Discrete menu (G3121), Dispatch List
R4051 Supply and Demand | Displays the supply, demand, and available quantities for an item. | Periodic Functions - Discrete (G3121), Supply/Demand
RF31011P Lean Completions - Purge | Archive lean transactions records based on the master transaction ID. | Daily Orderless Reporting - Discrete (GF3112), Lean Completions - Purge

### JD Edwards EnterpriseOne Selected Shop Floor Management Reports

This section provides detailed information, including processing options, for individual reports. The reports are listed alphanumerically by report ID.

#### Processing Options for Shortage Revisions Print (R3118P)

This processing option specifies whether you want one or two detail lines for each short item.

Print

Detail Lines | Specify the number of detail lines you want to appear. Values are: 1: Print one line of detail. 2: Print two lines of detail.

#### R31418 - W. O. Component Shortage List

The W. O. Component Shortage List report (R31418) includes this information:

- Quantities available

- Quantities on order

- Quantities required

- Quantities short

Note. If you use JD Edwards EnterpriseOne Warehouse Management, the Component Shortages report does not include parts that have a status of In Warehouse.

#### Processing Options for Component Shortages (R31418)

Use the processing option to specify whether the system prints only parts with shortages. A part with a shortage is included on more than one order only when the sum of the on-hand quantity and the on-order quantity, minus the required quantity, is negative. You can also generate this report as part of the shop paperwork when you run the Order Processing program (R31410).

Edits

Enter Allowed Lot Status Group to validate | Specify a Lot Group name. A Lot Group is the name of a user-defined list of allowed non-blank lot status codes. Entry of a Lot Group name in the Processing Option will allow this Application to process lots whose lot status code is defined within the specified Lot Group Name.

Print

Print All Parts or Just Shortages | Specify whether the report contains all parts, or just parts with a shortage. Values are: Blank: Print all parts (whether or not there are shortages) 1: Print only parts with a shortage (print shortages only)

#### R4051 - Supply and Demand

The Supply and Demand report (R4051) can include quantities of materials in these categories:

- On-hand inventory

- Safety stock

- Sales orders

- Purchase orders

- Work orders

- MPS/MRP planned orders

- Forecasts

- Rate schedules

#### Processing Options for Supply and Demand (R4051)

You can set the processing options to customize the report in various ways; for example, you can decide which quantities to include and what date range to consider for the report.

Process

1. Deduct Safety Stock From Available Quantity | Specify whether the system displays the safety stock line and decreases the safety stock from the available quantity. Values are: Blank: Do Not Deduct 1: Deduct Safety Stock
2. Receipt Routing Quantities Considered On Hand | Specify whether you want quantities in routing steps to be considered as on hand. Values are: Blank: Do Not Consider 1: Consider As On Hand Routing quantities fields that appear on the processing option form: Quantity in Transit Quantity in Inspection User Defined Quantity 1 User Defined Quantity 2
3. Supply/Demand Inclusion Rules | Specify the supply and demand inclusion rules version for the system to use. These rules define the order type, line type and line status. Enter a value from UDC 40/RV (Inclusion Version) that identifies the version to use for processing. Enter an inclusion rule to use as the default value or select it from the Select User Define Code form.
4. Subtract Expired Lot Quantities | Specify whether the system deducts the expired lot quantities from the available quantity. Values are: Blank: Do Not Subtract 1: Subtract Expired Lots This processing option does not work with available to promise lines. If you select value 1 in this processing option, you must set the Available to Promise Line Flag processing option, under the Display tab, to either blank or 2.
5. Enable Engineering Project Management (EPM) | Specify whether the system enables Engineer-to-Order (ETO) functionality. Values are: Blank: Do not enable. 1: Enable.
6. Include Past Due Supply In Quantity Available | Specify if past due quantities are included while calculating available quantity. Values are: Blank: Do not include. 1: Include.
7. Rate Based Schedule Type (Future) | Specify a value from user-defined code (UDC) table 31/ST (Schedule Type) that identifies the type of schedule, for example, AC for actual schedule and PL for planned schedule. If you leave this processing option blank, the system does not display any rate based items.
8. Include MPS/MRP/DRP Planned Orders | Specify whether the system displays planned orders from MPS/MRP/DRP generations. Values are: Blank: Do Not Include 1: Include Planned Orders
9. Forecast Types (5 Types Maximum) | Specify which forecast types, up to five, that the system includes in the inquiry. If you leave this field blank, the system does not include any forecast records. Enter multiple forecasts: to enter 01, 02, and BF, type 0102BF.
10. Days From Today To Include Forecast | Enter the number of days (+ or -) from the system date that you want the system to include forecast records. If you leave this field blank, the system uses the system date.
11. Exclude Bulk Items | Specify whether the system displays bulk stocking type records. Values are: Blank: Do Not Exclude 1: Exclude Bulk Items
12. Lot Hold Codes (up to 5) | Enter the lots to be included in the calculation of on-hand inventory. You can enter a maximum of 5 lot hold codes from UDC 41/L (Lot Status Codes). Values are: Blank: Include no held lots in calculation of on-hand inventory. *: Include all held lots in calculation of on-hand inventory.

Display

1. Display Unit Of Measure | Enter a value from UDC 00/UM (Unit of Measure) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box). If you leave the field blank, the system uses the primary unit of measure.
2. Convert Quantities To Standard Potency | Specify whether the system converts quantities to the standard potency. Values are: Blank: Do Not Convert 1: Convert To Standard Potency
3. Effective Thru Date | Enter a date that indicates one of these conditions: When a component part is no longer in effect on a bill of material. When a routing step is no longer in effect as a sequence on the routing for an item. When a rate schedule is no longer active. The default date is December 31 of the default year defined in the Data Dictionary for Century Change Year. You can enter future effective dates so that the system plans for upcoming changes. Items that are no longer effective in the future can still be recorded and recognized in JD Edwards EnterpriseOne Product Costing, JD Edwards EnterpriseOne Shop Floor Management, and JD Edwards EnterpriseOne Capacity Requirements Planning. The JD Edwards EnterpriseOne Material Requirements Planning system determines valid components by effectivity dates, not by the bill of material revision level. Some forms display data based on the effectivity dates you enter.
4. Display ATP Line | Specify whether the system displays an available to promise line, a cumulative available to promise line, or neither. Values are: Blank: Do Not Display 1: Display ATP Line 2: Display CATP Line If you select to display the available to promise line (value 1) in this processing option, you cannot use the Reduce Expired Lot Quantities processing option on the Process tab.
5. Summarize All In Receipt Routing Steps | Specify whether the system summarizes all in receipt routing steps. Values are: Blank: Do Not Summarize 1: Summarize
6. Summarize Item Balance Quantity Records | Specify whether the system summarizes item balance quantity records. Values are: Blank: Do Not Summarize 1: Summarize

#### RF31011P - Lean Transactions - Purge

The volume of records create by lean transactions can be significant. To forestall performance problems, use this program to purge lean transaction records from the primary tables and move them to corresponding archive tables.

Based on the master transaction ID, you can purge and archive both active and canceled transactions. A transaction is active if you have performed a completion against a daily plan from Demand Flow® Manufacturing or a JD Edwards EnterpriseOne Shop Floor plan, or if you have performed an ad hoc completion. If you have reversed a completion, the transaction has a status of canceled.

If you select a master transaction ID for archiving, the system archives all related transaction records and deletes the transaction records from their respective tables. If you select to archive a subassembly transaction, you can archive all transactions related to the corresponding master transaction ID, or you can archive only the selected transaction.

Note. If the purge process does not clear existing data from the primary tables or fails to copy all selected data to the archive table, the system issues an error message.

The archiving process moves transaction records from these primary tables to the corresponding archive tables:

Primary Table | Archive Table
Transaction ID Master File (FF31011) | Purge - Transaction ID Master File (FF31011S)
Lean Transaction Parts List (FF31111) | Purge - Lean Transaction Parts List (FF31111S)
Routing Transaction Table (FF31112) | Purge - Routing Transaction Table (FF31112S)
Lean Transaction Labor Detail (FF31113) | Purge - Lean Transaction Labor Detail (FF31113S)