TABLE OF CONTENTS
Overview
The Web Application allows user to inquire historical transactions records through material transactions, job transactions, machine transactions, field value changes and background task. The form can be found as shown below:
User can export the records via:
- Click Export to Excel button to export the result into Excel format.
- Click Export to CSV button to export the result into CSV format.
Job Transactions
The Job Transactions form records all historical transaction related to job orders that happen on the production shop floor.
The fields in the Job Transactions form are:
| FIELD | DESCRIPTION |
|---|---|
Trans. Num | Transactions number. This is system generated unique number to tag each transaction. Note: By default, they are sorted in descending order. |
Trans. Type | Transaction Type. Defines the nature of the transaction performed for that particular record. Refer to Appendix 1 for the full list of transaction types and their meaning. |
Start Time | Labor job run transaction start date and time. |
End Time | Labor job run transaction end date and time. |
Hours | Total hour(s) spent for the job run transaction. |
Employee ID | The employee who performed the transaction. |
Machine ID | The machine which is use in performed the transaction. |
Job Order | Job order number for the transaction. |
| Suffix | The job order suffix number. |
Operation | Job operation number for the transaction. |
| Work Center | The station/work center performing this process |
Item | Item used in the transaction. |
Description | The transacted item’s description. |
Indirect Task | The indirect task code for the indirect task transaction. |
Qty Completed | Quantity completed from the operation. |
Qty Moved | Quantity moved to the next operation. |
Qty Scrapped | Quantity scrapped from the operation. |
UOM | The actual unit of measure transacted. |
Reason Code | Reason code for the scrapped from the operation. |
Warehouse | Warehouse where the transaction was performed. |
Location | Location where the transaction was performed. |
Lot Number | Identifies the lot number for the item if is lot tracked item. |
| Doc Number | An external document or note reference number. |
| Remarks | Remarks for the reversal transaction |
| Rev. Trans. Num | Newly generated Transaction Number for the corresponding WIP Reverse, facilitating a direct reference between the original transaction and its reversal. |
Created Time | Date and time stamp of the transaction. |
Created By | Identifies the user who performed the transaction. |
Site ID | Identifies the site. |
| Action |
Important Note: It's important to note that this reversal does not affect the last operation that moved the item to the warehouse. To reverse that, users must perform a Job Return. |
Filter Results
User may filter result by:
- Start Time Date - Select the range of start time date to filter the results.
- End Time Date - Select the range of end time date to filter the results.
- Trans. Type - Select a transaction type from the drop-down list.
- Click the Filter button to filter result.
- Click Reset button to clear all the filters.
Machine Transactions
The Machine Transactions form records down all historical transaction related to a machine that happen on the production shop floor.
The fields in the Machine Transactions form are:
| FIELD | DESCRIPTION |
|---|---|
Trans. Num | Transactions number. This is system generated unique number to tag each transaction. Note: By default, they are sorted in descending order. |
Trans. Type | Transaction Type. Defines the nature of the transaction performed for that particular record. Refer to Appendix 1 for the full list of transaction types and their meaning. |
Machine ID | The machine which is use in performed the transaction. |
Start Time | Machine run transaction start date and time. |
Start By | The employee who starts the transaction. |
End Time | Machine run transaction end date and time. |
Stop By | The employee who ends the transaction. |
Hours | Total hour(s) spent for the machine run transaction. |
Job Order | Job order number for the transaction. |
| Suffix | The job order suffix number. |
Operation | Job operation number for the transaction. |
Item | Item used in the transaction. |
Description | The transacted item’s description. |
Qty Completed | Quantity completed from the operation. |
Qty Moved | Quantity moved to the next operation. |
Qty Scrapped | Quantity scrapped from the operation. |
UOM | The actual unit of measure transacted. |
Reason Code | Reason code for the scrapped from the operation and machine downtime. |
Warehouse | Warehouse where the transaction was performed. |
Location | Location where the transaction was performed. |
Lot Number | Identifies the lot number for the item if is lot tracked item. |
| Doc Number | An external document or note reference number. |
Created Time | Date and time stamp of the transaction. |
Created By | Identifies the user who performed the transaction. |
Site ID | Identifies the site. |
Filter Results
User may filter result by:
- Start Time Date - Select the range of start time date to filter the results.
- End Time Date - Select the range of end time date to filter the results.
- Trans. Type - Select a transaction type from the drop-down list.
- Click the Filter button to filter result.
- Click Reset button to clear all the filters.
Active Labor Run List
Active Labor Run list provide an option for admin to stop the labor transaction from the web version. All pending transaction including job run, indirect task and job setup will be list in the table. Admin can manually stop the labor transaction and define the stop date and stop time. This function is useful when the employee forgot to stop the transaction. When the pending transaction is stop or end by the employee, it will be auto removed from the Active Labor Run List. The fields in the form are:
| FIELD | DESCRIPTION |
|---|---|
Job Type | Identifies what is the running job type: Job Run, Job Setup, Indirect Type |
Warehouse | Warehouse where the labor and machine run (Must exist in Warehouses master) |
Job Order | A job order number uniquely identifies a job order (Must exist in Job Orders transactions and is from the selected warehouse) |
| Suffix | The job order suffix number |
Operation | Sequence number of the job route |
Work Center | The work center to operate this job route (Must exist in Work Centers master) |
Machine/Employee Id | Identifies the labor or machine which is running |
Employee Name | This is the full name of the employee. |
Machine Description | This is the description or name of the machine. |
Start Date Time | The start date and time of the running job |
Stop Date Time | Identifies the stop date and time to record the end of the running job |
Reason | Identifies the reason for machine downtime |
Stop Labor
1. In the Active Labor Run List form, click the Edit button of the running job which needed to stop.
2. Fill in the Stop Date Time field.
3. Click Stop button to complete.
Active Machine Run List
Active Machine Run list provide an option for admin to stop the machine transaction from the web version. All pending transaction including machine run and machine down time will be list in the table. Admin can manually stop the machine transaction and define the stop date and stop time. This function is useful when the employee forgot to stop the transaction. When the pending transaction is stop or end by the employee, it will be auto removed from the Active Machine Run List. The fields in the form are:
| FIELD | DESCRIPTION |
|---|---|
Job Type | Identifies what is the running job type: Down Time, Machine Run |
Warehouse | Warehouse where the labor and machine run (Must exist in Warehouses master) |
Job Order | A job order number uniquely identifies a job order (Must exist in Job Orders transactions and is from the selected warehouse) |
| Suffix | The job order suffix number |
Operation | Sequence number of the job route |
Work Center | The work center to operate this job route (Must exist in Work Centers master) |
Machine/Employee Id | Identifies the labor or machine which is running |
Employee Name | This is the full name of the employee. |
Machine Description | This is the description or name of the machine. |
Start Date Time | The start date and time of the running job |
Stop Date Time | Identifies the stop date and time to record the end of the running job |
Reason | Identifies the reason for machine downtime |
Stop Machine
1. In the Active Machine Run List form, click the Edit button of the running job which needed to stop.
2. Fill in the Stop Date Time field.
3. Click Stop button to complete.