This appendix contains the following topics:
Section A.1, "JD Edwards EnterpriseOne Shop Floor Management Reports: A to Z"
Section A.2, "JD Edwards EnterpriseOne Selected 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.
This table lists the JD Edwards EnterpriseOne Shop Floor Management reports, sorted alphanumerically by report ID.
| Report ID and Report Name | Description | Navigation |
|---|---|---|
| R3118P | Lists shortage details for each short item. | Periodic Functions - Discrete (G3121), All Shortages |
| R31400 | 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 | Lists the component parts required to complete a work order and indicates their current availability. | Periodic Functions - Discrete (G3121), Component Shortages |
| R31435 | 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 | Displays the supply, demand, and available quantities for an item. | Periodic Functions - Discrete (G3121), Supply/Demand |
| RF31011P | Archive lean transactions records based on the master transaction ID. | Daily Orderless Reporting - Discrete (GF3112), Lean Completions - Purge |
This section provides detailed information, including processing options, for individual reports. The reports are listed alphanumerically by report ID.
This processing option specifies whether you want one or two detail lines for each short item.
Specify the number of detail lines you want to appear. Values are:
1: Print one line of detail.
2: Print two lines of detail.
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. |
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).
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.
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)
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
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.
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
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
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.
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.
Specify whether the system enables Engineer-to-Order (ETO) functionality. Values are:
Blank: Do not enable.
1: Enable.
Specify if past due quantities are included while calculating available quantity. Values are:
Blank: Do not include.
1: Include.
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.
Specify whether the system displays planned orders from MPS/MRP/DRP generations. Values are:
Blank: Do Not Include
1: Include Planned Orders
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.
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.
Specify whether the system displays bulk stocking type records. Values are:
Blank: Do Not Exclude
1: Exclude Bulk Items
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.
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.
Specify whether the system converts quantities to the standard potency. Values are:
Blank: Do Not Convert
1: Convert To Standard Potency
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.
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.
Specify whether the system summarizes all in receipt routing steps. Values are:
Blank: Do Not Summarize
1: Summarize
Specify whether the system summarizes item balance quantity records. Values are:
Blank: Do Not Summarize
1: Summarize
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: