Difference between revisions of "SOP-42Q-MES0051 Reporting Part Traceability"
| Line 1: | Line 1: | ||
| − | <small>[http://hsvmeswiki.sanmina-sci.com/mes_wiki/index.php/Cirrus#Categories Cirrus] > [http://hsvmeswiki.sanmina-sci.com/mes_wiki/index.php/Reporting Reporting] > Part Traceability</small><br> [[Image: | + | <small>[http://hsvmeswiki.sanmina-sci.com/mes_wiki/index.php/Cirrus#Categories Cirrus] > [http://hsvmeswiki.sanmina-sci.com/mes_wiki/index.php/Reporting Reporting] > Part Traceability</small><br>[[Image:42Q_Logo.jpg]]<br> |
<br> | <br> | ||
| Line 6: | Line 6: | ||
<br> | <br> | ||
| − | <center>This Work Instruction is | + | <center>This Work Instruction is 42Q's corporate standard.</center> <center>This document is under revision control. The latest revision is located on Intranet.</center> <center>Once printed it is an uncontrolled copy. All alterations to this work instruction require approval.</center> <center>Contact the IT Global Education and Training Department to submit suggested alterations and or updates.</center> |
''This edition applies to MES15 Portal 1.0 Application and all subsequent releases and modifications until otherwise indicated in new revisions.''' | ''This edition applies to MES15 Portal 1.0 Application and all subsequent releases and modifications until otherwise indicated in new revisions.''' | ||
| Line 31: | Line 31: | ||
4. Alternatively, users may perform a search by entering a '''Lot Code''' or '''Date Code''' in the respective fields. | 4. Alternatively, users may perform a search by entering a '''Lot Code''' or '''Date Code''' in the respective fields. | ||
| − | 5. Select the '''Search''' icon. | + | 5. Select the '''Search''' icon. |
6. The report information displays. | 6. The report information displays. | ||
| − | + | '''Figure 1: Material Report''' | |
| − | ''' | + | '''[[Image:SOP-5-I-MES0051-C_RAI_Material_Report.jpg]]''' |
| − | |||
| − | |||
'''Figure 2: Material Report-Log Report''' | '''Figure 2: Material Report-Log Report''' | ||
| − | [[Image:SOP-5-I- | + | '''[[Image:SOP-5-I-MES0051-C_RAI_Material_Log_Report.jpg]]''' |
| − | <br> | + | <br> |
'''Figure 3: Material report-usage report''' | '''Figure 3: Material report-usage report''' | ||
| − | [[Image:SOP-5-I- | + | '''[[Image:SOP-5-I-MES0051-C_RAI_Material_Report-Usage_Report.jpg]]''' |
| − | <br> | + | <br> |
<u>'''Log Report'''</u>''':''' | <u>'''Log Report'''</u>''':''' | ||
| Line 61: | Line 59: | ||
2. Select '''Log Report'''. The Component Log Report displays. | 2. Select '''Log Report'''. The Component Log Report displays. | ||
| − | <br> | + | <br> |
<u>'''Usage Report'''</u>''':''' | <u>'''Usage Report'''</u>''':''' | ||
| Line 67: | Line 65: | ||
1. To use the Usage Report portlet, check the box of an item from the Material Report list. The Usage Report is now available for selection. | 1. To use the Usage Report portlet, check the box of an item from the Material Report list. The Usage Report is now available for selection. | ||
| − | 2. Select '''Usage Report'''. The Usage Report displays. | + | 2. Select '''Usage Report'''. The Usage Report displays. |
=== Receipt Traveler Report === | === Receipt Traveler Report === | ||
| Line 73: | Line 71: | ||
The Receipt Traveler report can be used to display all the receiving records processed in ERP. | The Receipt Traveler report can be used to display all the receiving records processed in ERP. | ||
| − | + | <br> | |
'''Figure 4: Receipt Traveler Report''' | '''Figure 4: Receipt Traveler Report''' | ||
| − | [[Image:SOP-5-I- | + | '''[[Image:SOP-5-I-MES0051-C_RAI_Receipt_Traveler_Report.jpg]]''' |
| − | |||
| + | <br> | ||
1. To view the report, navigate to the Receipt Traveler report page: '''Reporting <nowiki>></nowiki> Part Traceability <nowiki>></nowiki> Receipt Traveler Report'''. | 1. To view the report, navigate to the Receipt Traveler report page: '''Reporting <nowiki>></nowiki> Part Traceability <nowiki>></nowiki> Receipt Traveler Report'''. | ||
| Line 87: | Line 85: | ||
3. Enter the appropriate information in the fields adjacent to the Search by field and select the '''Search icon''' to generate results. | 3. Enter the appropriate information in the fields adjacent to the Search by field and select the '''Search icon''' to generate results. | ||
| − | 4. Click the receipting number of a result in the list. The Material Report window displays. | + | 4. Click the receipting number of a result in the list. The Material Report window displays. |
=== Material On Hold === | === Material On Hold === | ||
| Line 93: | Line 91: | ||
The Material On-Hold report can be used to display information about materials that are presently on-hold. | The Material On-Hold report can be used to display information about materials that are presently on-hold. | ||
| − | + | <br> | |
'''Figure 5: Material On Hold''' | '''Figure 5: Material On Hold''' | ||
| − | [[Image:SOP-5-I- | + | '''[[Image:SOP-5-I-MES0051-C_RAI_Material_On_Hold.jpg]]''' |
| − | |||
| + | <br> | ||
1. To view the report, navigate to the Material On Hold report page: '''Reporting <nowiki>></nowiki> Part Traceability <nowiki>></nowiki> Material On Hold'''. | 1. To view the report, navigate to the Material On Hold report page: '''Reporting <nowiki>></nowiki> Part Traceability <nowiki>></nowiki> Material On Hold'''. | ||
| Line 111: | Line 109: | ||
NOTE: The status of material that is on hold and cannot load is indicated by a red X. | NOTE: The status of material that is on hold and cannot load is indicated by a red X. | ||
| − | + | <br> | |
'''Figure 6: Material On Hold (update status)''' | '''Figure 6: Material On Hold (update status)''' | ||
| Line 117: | Line 115: | ||
[[Image:SOP-5-I-PTSXXXX-1 Reporting Part Traceability 06.png|700px|SOP-5-I-PTSXXXX-1 Reporting Part Traceability 06.png]] | [[Image:SOP-5-I-PTSXXXX-1 Reporting Part Traceability 06.png|700px|SOP-5-I-PTSXXXX-1 Reporting Part Traceability 06.png]] | ||
| − | + | <br> | |
'''Update''' | '''Update''' | ||
| Line 129: | Line 127: | ||
NOTE: Check boxes that are grayed cannot be put on hold, as this means the materials have been used in some product. | NOTE: Check boxes that are grayed cannot be put on hold, as this means the materials have been used in some product. | ||
| − | + | <br> | |
=== Board In Production === | === Board In Production === | ||
| Line 135: | Line 133: | ||
The Board in Production report can be used to display information about materials from scanned boards that are in production in a select line. | The Board in Production report can be used to display information about materials from scanned boards that are in production in a select line. | ||
| − | + | <br> | |
'''Figure 7: Board In Production''' | '''Figure 7: Board In Production''' | ||
| Line 141: | Line 139: | ||
[[Image:SOP-5-I-PTSXXXX-1 Reporting Part Traceability 07.png|700px|SOP-5-I-PTSXXXX-1 Reporting Part Traceability 07.png]] | [[Image:SOP-5-I-PTSXXXX-1 Reporting Part Traceability 07.png|700px|SOP-5-I-PTSXXXX-1 Reporting Part Traceability 07.png]] | ||
| − | + | <br> | |
1. To view the report, navigate to the Board in Production report page: '''Reporting <nowiki>></nowiki> Part Traceability <nowiki>></nowiki> Board in Production'''. | 1. To view the report, navigate to the Board in Production report page: '''Reporting <nowiki>></nowiki> Part Traceability <nowiki>></nowiki> Board in Production'''. | ||
| Line 151: | Line 149: | ||
4. The report results are displayed. | 4. The report results are displayed. | ||
| − | NOTE: If required, define the Start Date and the Stop Date for limited production history boards. | + | NOTE: If required, define the Start Date and the Stop Date for limited production history boards. |
=== Boards In Model === | === Boards In Model === | ||
| Line 157: | Line 155: | ||
The Board in Model report can be used to display information about serials that have been scanned with a selected BOM P/N. | The Board in Model report can be used to display information about serials that have been scanned with a selected BOM P/N. | ||
| − | + | <br> | |
'''Figure 8: Boards In Model''' | '''Figure 8: Boards In Model''' | ||
| Line 169: | Line 167: | ||
3. Define the '''Start Date''' and the '''Stop Date''' box for limited production history boards. | 3. Define the '''Start Date''' and the '''Stop Date''' box for limited production history boards. | ||
| − | 4. Select the '''Search icon'''. The results are displayed. | + | 4. Select the '''Search icon'''. The results are displayed. |
=== Boards In Work Order === | === Boards In Work Order === | ||
| Line 175: | Line 173: | ||
The Board in Word Order report can be used to display information about board scanning times according to work order number. | The Board in Word Order report can be used to display information about board scanning times according to work order number. | ||
| − | + | <br> | |
'''Figure 9: Boards In Work Order''' | '''Figure 9: Boards In Work Order''' | ||
| Line 181: | Line 179: | ||
[[Image:SOP-5-I-PTSXXXX-1 Reporting Part Traceability 09.png|700px|SOP-5-I-PTSXXXX-1 Reporting Part Traceability 09.png]] | [[Image:SOP-5-I-PTSXXXX-1 Reporting Part Traceability 09.png|700px|SOP-5-I-PTSXXXX-1 Reporting Part Traceability 09.png]] | ||
| − | + | <br> | |
1. To view the report, navigate to the Board in Work Order report page: '''Reporting <nowiki>></nowiki> Part Traceability <nowiki>></nowiki> Board in Work Order'''. | 1. To view the report, navigate to the Board in Work Order report page: '''Reporting <nowiki>></nowiki> Part Traceability <nowiki>></nowiki> Board in Work Order'''. | ||
| Line 191: | Line 189: | ||
4. Click the search icons. | 4. Click the search icons. | ||
| − | + | <br> | |
=== Board History Report === | === Board History Report === | ||
| Line 209: | Line 207: | ||
2. Enter a board barcode into the '''Input Board Barcode''' field, and select the search icon. | 2. Enter a board barcode into the '''Input Board Barcode''' field, and select the search icon. | ||
| − | 3. The required information is displayed. | + | 3. The required information is displayed. |
=== Break Panel Query === | === Break Panel Query === | ||
| Line 215: | Line 213: | ||
The Break Panel Query report can be used to view when a material or a component is consumed. | The Break Panel Query report can be used to view when a material or a component is consumed. | ||
| − | + | <br> | |
'''Figure 11: Break Panel Query''' | '''Figure 11: Break Panel Query''' | ||
| Line 221: | Line 219: | ||
[[Image:SOP-5-I-PTSXXXX-1 Reporting Part Traceability 11.png|700px|SOP-5-I-PTSXXXX-1 Reporting Part Traceability 11.png]] | [[Image:SOP-5-I-PTSXXXX-1 Reporting Part Traceability 11.png|700px|SOP-5-I-PTSXXXX-1 Reporting Part Traceability 11.png]] | ||
| − | + | <br> | |
1. To view the report, navigate to the Break Panel Query report page: '''Reporting <nowiki>></nowiki> Part Traceability <nowiki>></nowiki> Break Panel Query'''. | 1. To view the report, navigate to the Break Panel Query report page: '''Reporting <nowiki>></nowiki> Part Traceability <nowiki>></nowiki> Break Panel Query'''. | ||
| Line 227: | Line 225: | ||
2. Enter Panel Barcode, Work Order, Break Date Start, and Break Date End into the respective fields. | 2. Enter Panel Barcode, Work Order, Break Date Start, and Break Date End into the respective fields. | ||
| − | 3. Select '''Search'''. The results are displayed. | + | 3. Select '''Search'''. The results are displayed. |
=== Load Material Report === | === Load Material Report === | ||
| Line 233: | Line 231: | ||
The Load Material Report can be used to show which materials are loaded at a workstation<nowiki>’</nowiki>s production line. | The Load Material Report can be used to show which materials are loaded at a workstation<nowiki>’</nowiki>s production line. | ||
| − | + | <br> | |
'''Figure 12: Load Material Report''' | '''Figure 12: Load Material Report''' | ||
| Line 239: | Line 237: | ||
[[Image:SOP-5-I-PTSXXXX-1 Reporting Part Traceability 12.png|700px|SOP-5-I-PTSXXXX-1 Reporting Part Traceability 12.png]] | [[Image:SOP-5-I-PTSXXXX-1 Reporting Part Traceability 12.png|700px|SOP-5-I-PTSXXXX-1 Reporting Part Traceability 12.png]] | ||
| − | + | <br> | |
1. To view the report, navigate to the Load Material report page: '''Reporting <nowiki>></nowiki> Part Traceability <nowiki>></nowiki> Load Material Report'''. | 1. To view the report, navigate to the Load Material report page: '''Reporting <nowiki>></nowiki> Part Traceability <nowiki>></nowiki> Load Material Report'''. | ||
| Line 247: | Line 245: | ||
3. The report information is displayed. | 3. The report information is displayed. | ||
| − | + | <br> | |
=== Replace Barcode Report === | === Replace Barcode Report === | ||
| Line 253: | Line 251: | ||
The Replace Barcode report can be used to view the replacement history of barcodes, including replace time, original barcode, new barcode, workstation, production line, and the position of the person who replaced the barcode. | The Replace Barcode report can be used to view the replacement history of barcodes, including replace time, original barcode, new barcode, workstation, production line, and the position of the person who replaced the barcode. | ||
| − | + | <br> | |
'''Figure 13: Replace Barcode Report''' | '''Figure 13: Replace Barcode Report''' | ||
| Line 259: | Line 257: | ||
[[Image:SOP-5-I-PTSXXXX-1 Reporting Part Traceability 13.png|700px|SOP-5-I-PTSXXXX-1 Reporting Part Traceability 13.png]] | [[Image:SOP-5-I-PTSXXXX-1 Reporting Part Traceability 13.png|700px|SOP-5-I-PTSXXXX-1 Reporting Part Traceability 13.png]] | ||
| − | + | <br> | |
1. To view the report, navigate to the '''Replace Barcode Report''' in the MES Portal: '''Reporting <nowiki>></nowiki> Part Traceability <nowiki>></nowiki> Replace Barcode Report'''. | 1. To view the report, navigate to the '''Replace Barcode Report''' in the MES Portal: '''Reporting <nowiki>></nowiki> Part Traceability <nowiki>></nowiki> Replace Barcode Report'''. | ||
| Line 269: | Line 267: | ||
4. Select the '''Search icon'''. The search results are displayed. | 4. Select the '''Search icon'''. The search results are displayed. | ||
| − | 5. View the Barcode History report for a given result, click on the name of the new barcode (in blue) for the respective result. | + | 5. View the Barcode History report for a given result, click on the name of the new barcode (in blue) for the respective result. |
=== Prepare Material Report === | === Prepare Material Report === | ||
| Line 275: | Line 273: | ||
The Prepare Material report can be used to see which materials are prepared for a given production line and workstation. | The Prepare Material report can be used to see which materials are prepared for a given production line and workstation. | ||
| − | + | <br> | |
'''Figure 14: Prepare Material Report''' | '''Figure 14: Prepare Material Report''' | ||
| Line 281: | Line 279: | ||
[[Image:SOP-5-I-PTSXXXX-1 Reporting Part Traceability 14.png|700px|SOP-5-I-PTSXXXX-1 Reporting Part Traceability 14.png]] | [[Image:SOP-5-I-PTSXXXX-1 Reporting Part Traceability 14.png|700px|SOP-5-I-PTSXXXX-1 Reporting Part Traceability 14.png]] | ||
| − | + | <br> | |
1. To view the report, navigate to the Prepare Material Report in the MES Portal: '''Reporting <nowiki>></nowiki> Part Traceability <nowiki>></nowiki> Prepare Material Report'''. | 1. To view the report, navigate to the Prepare Material Report in the MES Portal: '''Reporting <nowiki>></nowiki> Part Traceability <nowiki>></nowiki> Prepare Material Report'''. | ||
| Line 287: | Line 285: | ||
2. In the Prepare Material Report page, select a production line from the '''Production Available''' drop-down box; then select a workstation from the '''Workstation Available''' drop-down box. The report information is displayed. | 2. In the Prepare Material Report page, select a production line from the '''Production Available''' drop-down box; then select a workstation from the '''Workstation Available''' drop-down box. The report information is displayed. | ||
| − | + | <br> | |
== Further Information == | == Further Information == | ||
| Line 293: | Line 291: | ||
This completes SOP-5-I-PTSxxxx Reporting Part Traceability information. For further information on a specific functional area refer to PTS Web. | This completes SOP-5-I-PTSxxxx Reporting Part Traceability information. For further information on a specific functional area refer to PTS Web. | ||
| − | + | <br> | |
== Document Revision History == | == Document Revision History == | ||
Revision as of 16:37, 14 December 2016
Cirrus > Reporting > Part Traceability
This edition applies to MES15 Portal 1.0 Application and all subsequent releases and modifications until otherwise indicated in new revisions.'
Reporting
MES can provide various traceability reports to meet the needs and documentation requirements of its users. Traceability reports provide users with information about the status of materials, production lines, and workstations.
Part Traceability
This section introduces the reports relating to part traceability. To access the pages for the various reports discussed herein, log on to the MES15 Portal and navigate to Reporting > Part Traceability. After expanding the Part Traceability menu, users can then select the pages for the various PTS reports.
NOTE: Online Help is available on PTS web.
Material Report
The Material Report is one of the most important and frequently used reports for incoming processes. The Material Report can be used to search and display a variety of information about certain materials.
1. To use the report, navigate to the Material report page: Reporting > Part Traceability > Material Report.
2. Specify the manner in which to search material by selecting an option from the Search by drop-downbox. Options include Create Time, Material Barcode, Receipting Number, Part Number, Expired Material, and LPN.
3. Enter the corresponding information in the field of fields adjacent to the Search by drop-down box.
4. Alternatively, users may perform a search by entering a Lot Code or Date Code in the respective fields.
5. Select the Search icon.
6. The report information displays.
Figure 1: Material Report
Figure 2: Material Report-Log Report
Figure 3: Material report-usage report
Log Report:
1. To use the log report portlet, check the box of an item from the Material Report list. The Log Report is now available for selection.
2. Select Log Report. The Component Log Report displays.
Usage Report:
1. To use the Usage Report portlet, check the box of an item from the Material Report list. The Usage Report is now available for selection.
2. Select Usage Report. The Usage Report displays.
Receipt Traveler Report
The Receipt Traveler report can be used to display all the receiving records processed in ERP.
Figure 4: Receipt Traveler Report
1. To view the report, navigate to the Receipt Traveler report page: Reporting > Part Traceability > Receipt Traveler Report.
2. Select an option for displaying the search results from the Search by drop-down box. Options include Create Time and Receipting Number.
3. Enter the appropriate information in the fields adjacent to the Search by field and select the Search icon to generate results.
4. Click the receipting number of a result in the list. The Material Report window displays.
Material On Hold
The Material On-Hold report can be used to display information about materials that are presently on-hold.
Figure 5: Material On Hold
1. To view the report, navigate to the Material On Hold report page: Reporting > Part Traceability > Material On Hold.
2. Select an option for displaying search results from the drop-down box. Options include Material Barcode, Receipting Number, and Part Number.
3. Enter the corresponding search information in the fields adjacent to the drop-down box, and select the search icon to generate results.
4. The search results are then displayed.
NOTE: The status of material that is on hold and cannot load is indicated by a red X.
Figure 6: Material On Hold (update status)
Update
Use the update portlet to update the material status of an item from on hold to active.
1. Check the box of an item from the search results and select Update.
NOTE: You can check multiple boxes and update them at the same time.
NOTE: Check boxes that are grayed cannot be put on hold, as this means the materials have been used in some product.
Board In Production
The Board in Production report can be used to display information about materials from scanned boards that are in production in a select line.
Figure 7: Board In Production
1. To view the report, navigate to the Board in Production report page: Reporting > Part Traceability > Board in Production.
2. Select a production line from the Production Line drop-down box. Alternatively, users may search be entering the barcode into the Search Barcode field.
3. Enter a date range by which to filter the search results, and select the Search icon.
4. The report results are displayed.
NOTE: If required, define the Start Date and the Stop Date for limited production history boards.
Boards In Model
The Board in Model report can be used to display information about serials that have been scanned with a selected BOM P/N.
Figure 8: Boards In Model
1. To view the report, navigate to the Board in Model report page in the MES Portal: Reporting > Part Traceability > Board in Model.
2. To generate search results first select a BOM P/N from the BOM P/N drop-down box. Alternatively, users may enter the barcode of an item in the Search Barcode field.
3. Define the Start Date and the Stop Date box for limited production history boards.
4. Select the Search icon. The results are displayed.
Boards In Work Order
The Board in Word Order report can be used to display information about board scanning times according to work order number.
Figure 9: Boards In Work Order
1. To view the report, navigate to the Board in Work Order report page: Reporting > Part Traceability > Board in Work Order.
2. Select a work order number from the Word Order down-down box. Alternatively, users can enter the barcode of the item they are searching for in the report.
3. Enter the Start Date and the End Date in the respective fields.
4. Click the search icons.
Board History Report
The Board History report can be used to view information regarding all the workstations that are associated with a given board barcode.
Figure 10: Board History Report
1. To view the report, navigate to the Board History Report main page: Reporting > Part Traceability > Board History Report.
2. Enter a board barcode into the Input Board Barcode field, and select the search icon.
3. The required information is displayed.
Break Panel Query
The Break Panel Query report can be used to view when a material or a component is consumed.
Figure 11: Break Panel Query
1. To view the report, navigate to the Break Panel Query report page: Reporting > Part Traceability > Break Panel Query.
2. Enter Panel Barcode, Work Order, Break Date Start, and Break Date End into the respective fields.
3. Select Search. The results are displayed.
Load Material Report
The Load Material Report can be used to show which materials are loaded at a workstation’s production line.
Figure 12: Load Material Report
1. To view the report, navigate to the Load Material report page: Reporting > Part Traceability > Load Material Report.
2. Select a production line from the Production Available field, and select a workstation from the Workstation Available field.
3. The report information is displayed.
Replace Barcode Report
The Replace Barcode report can be used to view the replacement history of barcodes, including replace time, original barcode, new barcode, workstation, production line, and the position of the person who replaced the barcode.
Figure 13: Replace Barcode Report
1. To view the report, navigate to the Replace Barcode Report in the MES Portal: Reporting > Part Traceability > Replace Barcode Report.
2. Select an option for searching results using the Search by drop-down box. Options include Original Barcode and New Barcode.
3. Enter the corresponding barcode information into the field adjacent to the Search by drop-down box. Enter the Start Date and the Stop Date to further filter the search results.
4. Select the Search icon. The search results are displayed.
5. View the Barcode History report for a given result, click on the name of the new barcode (in blue) for the respective result.
Prepare Material Report
The Prepare Material report can be used to see which materials are prepared for a given production line and workstation.
Figure 14: Prepare Material Report
1. To view the report, navigate to the Prepare Material Report in the MES Portal: Reporting > Part Traceability > Prepare Material Report.
2. In the Prepare Material Report page, select a production line from the Production Available drop-down box; then select a workstation from the Workstation Available drop-down box. The report information is displayed.
Further Information
This completes SOP-5-I-PTSxxxx Reporting Part Traceability information. For further information on a specific functional area refer to PTS Web.
Document Revision History
| Date | Author | Title | Version | Change Reference |
| 14/01/06 | Helena Wang | Tech Writer | 1.0 | Initial User’s Guide |
| 05/03/14 | Dane Parker | Tech Writer | 1.0 | General review and new screen capture |
| 05/03/14 | Elaine Fonaro | Tech Writer | 1.0 | Review and format for WIKI |
| 03/04/16 | Elaine Fonaro | Technical Writer | v 1.0 | Updated Oracle occurrences to ERP |
