WIP Lot Trace > Reporting WIP Lot Trace Data
  
Reporting WIP Lot Trace Data
The WIP Lot Trace module provides 10 reports and inquiries for reviewing WLT data. These reports and inquiries are designed to clearly show consumption and production data at the operation and WIP lot/serial level.
Some existing reports and inquiries also display WLT data.
When using WLT, you should use the WLT reports to report any WLT-controlled WIP and item component material. WLT does not trace WIP at non-milestone operations even if those operations belong to a WLT-controlled routing.
If you use Advanced Repetitive reports to view QOH balances for WLT-controlled routings or BOMs, the report may show that there is WIP material in the input queue of non-milestone operations. If you report for the same routing or BOM using WLT reports, these reports will show that the WIP lot/serial QOHs are in the input queue of the following milestone operation.
WIP Lot Trace Reports summarizes WIP Lot Trace reports.

WIP Lot Trace Reports
 
Report
Menu Number
Description
WIP Lot Inventory Status Report
3.22.13.13
Displays the WIP lot inventory associated with each discrete work order, or repetitive cumulative work order.
Item Lot Ship Transaction Report
3.22.13.14
Shows ISS-SO transaction history (tr_hist) records created by Sales Order Shipments (7.9.15) or Pre-Shipper/Shipper Confirm (7.9.5) for a selected finished material lot. Lets you easily identify the customer or ship-to where the finished material lot was shipped.
WIP Lot Convert Transaction Report
3.22.13.15
Shows operation history (op_hist) data and tracing information for transactions where material conversion occurred. This refers to, for example, any operation where a component is introduced and becomes part of the WIP material, or where a rejected WIP material was reworked and assigned to a different lot/serial. The report shows the data recorded in these programs:
• Purchase Order Receipts (5.13.1)
• Purchase Order Returns (5.13.7)
• Work Order Component Issue (16.10)
• Work Order Receipt (16.11)
• Work Order Operation Backflush (16.19)
• Labor Feedback by Work Order (16.20.1)
• Labor Feedback by Employee (16.20.2)
• Labor Feedback by Work Center (16.20.3)
• Repetitive Setup Transaction (18.13)
• Repetitive Labor Transaction (18.14)
• Repetitive Rework Transaction (18.16)
• Repetitive Reject Transaction (18.17)
• Backflush Transaction (18.22.13)
• Run Labor Transaction (18.22.14)
• Setup Labor Transaction (18.22.15)
• Rework Transaction (18.22.17)
WIP Lot Non-Convert Trans Report
3.22.13.16
Shows operation history data that references WIP lot and serial numbers, but does not include records where material was converted. WIP lot and serial numbers recorded during transactions in the following programs are reported:
• Repetitive Reject Transaction (18.17)
• Reject Transaction (18.22.16)
• Repetitive Rework Transaction (18.16)
• Rework Transaction (18.22.17)
• Repetitive Scrap Transaction (18.18)
• Scrap Transaction (18.22.18)
• WIP Adjust Transaction (18.22.21)
Note: Information recorded in the rework transaction is reported only if the WIP lot or serial numbers remained the same for the reworked material.
WIP Lot Inquiry
3.22.13.17
Displays WIP lot cumulative quantities by lot or work order ID at each operation. The cumulative totals displayed at each operation are for cumulative quantity produced, consumed, scrapped, adjusted, rejected, reworked, transferred in, and transferred out. An enhanced browse version is available at menu 22 for .NET UI.
Supplier Lot Transaction Report
3.22.13.18
Displays PO Receipt transactions for the selected item, where a supplier’s lot number was entered into the Supplier Lot number field. Use the report to identify the supplier lot associated with an internally assigned lot.
WIP Lot Where-Used Report
3.22.13.19
Generates a where-used report for selected component or WIP material lots, showing where WIP material or component lots were consumed, and what material lots were produced from them.
WIP Lot Actual Bill Report
3.22.13.20
Displays which material was used to make a WLT-tracked finished or WIP lot. The report shows issue and receipt transactions related to the WIP or parent material.
WIP Lot Browse
3.22.13.22
Enhanced version of WIP Lot Inquiry for .NET UI users.