TABLE OF CONTENTS
- Overview
- Job Operation Hours
- Item Scrap Summary
- Job Scrap Summary
- Machine Status Summary
- Material Issued
- Item Production Completion Summary
- Job Order Status
- Job Scrap Summary By Operation
- Job Processing Hours By Operation
- Labour Status Summary
- Aggregated Materials Requirement
- Job Materials Requirement by Operation
- Transaction – Print Job Sheet
Overview
There are several production reports where user can view information and transaction summary related with production shop floor in Axacute system. You can find it via this path:
Reports -> Production
User can export the reports 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.
- Click Print to print out the report from PDF if applicable.
Job Operation Hours
This report allow user to analyze the total setup, labor and machine hour spent on a job order.
The fields in the Job Operation Hours report are:
| FIELD | DESCRIPTION |
|---|---|
Job Order | Job order number. |
| Suffix | Job order suffix number. |
Status | Job order status. |
Item | The designated code given to the job order item. |
Item Description | The full description, specifications, or name of the job order item. |
| Qty Released | Total quantity released for the job order. |
| Qty Completed | Total quantity completed for the job order. |
| Qty Scrapped | Total quantity rejected for the job order. |
| UOM | Unit of measure for the item. |
Setup Time (Hrs) | Total hours spent on job setup. |
Labor Run Time (Hrs) | Total hours spent on job run by employee. |
Machine Run Time (Hrs) | Total hours spent on job run by machine. |
Total Time (Hrs) | Sum of setup time, labor run time and machine run time for the job order. |
| Ave Labour Run Time per Piece | Total labor run time divide by total quantity completed. |
| Ave Machine Run Time per Piece | Total machine run time divide by total quantity completed. |
| Ave Total Run Time per Piece | Total run time divide by total quantity completed. |
| Planned Labour per Piece | Planned labour hour per piece for the job order. |
| Planned Machine per Piece | Planned machine hour per piece for the job order. |
Filter Results
- User may filter result by:
- Start Date - Select the range of job start date to filter the results.
- End Date - Select the range of job end date to filter the results.
- Job Order - Select the range of job order number to filter the results.
- Status - Select the job order status to filter the results.
- Item - Select the range of items to filter the results.
- Product Code - Select the range of product code for the job item to filter the results.
- Click the Filter button to filter result.
- Click Reset button to clear all the filters.
Item Scrap Summary
This report provide user the information of total scrapped quantity and how many time scraps occurred for an item.
The fields in the Item Scrap Summary report are:
| FIELD | DESCRIPTION |
|---|---|
Item | The designated code given to the job order item. |
Item Description | The full description, specifications, or name of the job order item. |
| Product Code | The product code of the item. |
| Completed Qty | Total completed quantity. |
Total Qty Scrapped | Total quantity rejected. |
UOM | Unit of measure for the item. |
| Yield | Completed Qty / (Completed Qty + Total Qty Scrapped) |
| Reason Code | The reason code of the reject. |
| Reason Description | The description of reason code. |
Total Occurrences | Total number of reporting incidents. |
| Qty Scrapped | Quantity rejected for the reason. |
Filter Results
- User may filter result by:
- Trans. Date - Select the range of transaction date to filter the results.
- Item - Select the range of items to filter the results.
- Product Code - Select the range of product code for the item to filter the results.
- Reason Code - Select the reason code to filter the results.
- Click the Filter button to filter result.
- Click Reset button to clear all the filters.
Job Scrap Summary
This report give user the information of the job scrap in details including the scrap reason, quantity, and its number of occurrences.
The fields in the Job Scrap Summary report are:
| FIELD | DESCRIPTION |
|---|---|
Job Order | Job order number. |
| Suffix | Job order suffix number. |
Status | Job order status. |
Item | The designated code given to the job order item. |
Item Description | The full description, specifications, or name of the job order item. |
Reason Code | The reason code of the reject. |
Reason Description | The description of reason code. |
Qty Scrapped | Total quantity rejected. |
UOM | Unit of measure for the quantity rejected. |
Total Occurrences | Total number of reporting incidents. |
Filter Results
- User may filter result by:
- Job Date - Select the range of job order date to filter the results.
- Job Order - Select the range of job order number to filter the results.
- Status - Select the job order status to filter the results.
- Item - Select the range of items to filter the results.
- Product Code - Select the range of product code for the job item to filter the results.
- Reason Code - Select the reason code to filter the results.
- Click the Filter button to filter result.
- Click Reset button to clear all the filters.
Machine Status Summary
This report provides the details of machine including the machine total setup time, total run time and total down time recorded in hours.
The fields in the Machine Status Summary report are:
| FIELD | DESCRIPTION |
|---|---|
Machine ID | Machine code. |
Machine Description | Description/name of machine. |
Setup Time (Hrs) | Total hours spent on job setup. |
Run Time (Hrs) | Total hours spent on job run by machine. |
Down Time (Hrs) | Total down time of the machine. |
| Down Time Occurences | Total number of reporting downtime. |
Total Time (Hrs) | Sum of setup time, run time and down time for the machine. |
Filter Results
- User may filter result by:
- Date - Select the range of date to filter the results.
- Machine ID - Select the range of machine code to filter the results.
- Click the Filter button to filter result.
- Click Reset button to clear all the filters.
Material Issued
This report allows user to identify the quantity of each material allocated and issued to specific job order.
The fields in the Materials Issued report are:
| FIELD | DESCRIPTION |
|---|---|
Job Order | Job order number. |
| Suffix | Job order suffix number. |
Item | The designated code given to the job order item. |
Item Description | The full description, specifications, or name of the job order item. |
| Qty Released | Total quantity released of the job order. |
| Operation Number | Job operation number for the material issued. |
| Sequence | Job material sequence. |
Material | The designated code given to the issued material required for the operation. |
Material Description | The full description, specifications, or name of the material item. |
| Qty Per | Quantity of material required to produce one job item. |
| Scrap Factor | The expected loss factor. |
| Qty Required | Total quantity required for the job material. |
| Qty Issued | Total quantity of material issued to the job operation. |
Qty Balance | Quantity Required - Quantity Issued |
UOM | The unit of measure transacted. |
Filter Results
- User may filter result by:
- Date - Select the range of date to filter the results.
- Warehouse - Select the range of warehouse to filter the results.
- Job Order - Select the range of job order number to filter the results.
- Item - Select the range of job item to filter the results.
- Operation - Select the range of operation number to filter the results.
- Material - Select the range of job material item to filter the results.
- Product Code - Select the range of product code for the job item to filter the results.
- Click the Filter button to filter result.
- Click Reset button to clear all the filters.
Item Production Completion Summary
This report allows user to analyze the quantity of finished goods that were produced from daily manufacturing.
The fields in the Item Production Completion Summary report are:
| FIELD | DESCRIPTION |
|---|---|
Item | The designated code given to the job order item. |
Item Description | The full description, specifications, or name of the job order item. |
| Product Code | The product code of the job order item. |
| UOM | Unit of measure for the job item |
Job Order | Job order number. |
| Suffix | The job order suffix number. |
| Status | The job order status. |
| Qty Released | Total quantity released of the job order. |
| Qty Completed | Total completed quantity. |
| Qty Balance | Quantity Released - Quantity Completed + Quantity Scrapped |
Receipt Date | Identifies the date when the job item was received into inventory. |
| Lot | The lot number for lot item. |
Quantity | The total quantity of job item received on that date. |
Filter Results
- User may filter result by:
- Job Date - Select the range of job date to filter the results.
- Warehouse - Select the range of warehouse to filter the results.
- Job Order - Select the range of job order number to filter the results.
- Item - Select the range of job item to filter the results.
- Product Code - Select the range of product code for the job item to filter the results.
- Click the Filter button to filter result.
- Click Reset button to clear all the filters.
Job Order Status
This report allows users to monitor the status for all job orders.
The fields in the Job Order Status report are:
| FIELD | DESCRIPTION |
|---|---|
| Job Order | The job order number. |
| Suffix | The job order suffix number. |
| Customer Code | The customer for the job order. |
| Customer Name | The customer name. |
| Job Date | The job date of the order. |
| Start Date | The start date for job order. |
| End Date | The end date for job order. |
Item | The designated code given to the job order item. |
Item Description | The full description, specifications, or name of the job order item. |
| Qty Released | Total quantity released of the job order. |
| Qty Completed | Total completed quantity. |
| Qty Scrapped | Total rejected quantity. |
| Qty Balance | Quantity Released - Quantity Completed + Quantity Scrapped |
UOM | Unit of measure for the job item. |
Filter Results
- User may filter result by:
- Item - Select the range of job item to filter the results.
- Job Order - Select the range of job order number to filter the results.
- Customer - Select the range of customer code to filter the results.
- Job Date - Select the range of job date to filter the results.
- Status - Select the job order status to filter the results.
- Past Due - If is tick, only job order already past due will be show in results.
- Click the Filter button to filter result.
- Click Reset button to clear all the filters.
Job Scrap Summary By Operation
This report give user the information of the job scrap in details for each operation including the scrap reason, quantity, and its number of occurrences.
The fields in the Job Scrap Summary By Operation report are:
| FIELD | DESCRIPTION |
|---|---|
Job Order | Job order number. |
| Suffix | Job order suffix number. |
Status | Job order status. |
Item | The designated code given to the job order item. |
Item Description | The full description, specifications, or name of the job order item. |
| Operation Number | Job operation number for the job scrapped. |
| Work Center | Work center code of the operation. |
| Work Center Description | Work center name or description. |
Reason Code | The reason code of the reject. |
Reason Description | The description of reason code. |
Qty Scrapped | Total quantity rejected. |
UOM | Unit of measure for the quantity rejected. |
Total Occurrences | Total number of reporting incidents. |
Filter Results
- User may filter result by:
- Date - Select the range of transaction date to filter the results.
- Job Order - Select the range of job order number to filter the results.
- Status - Select the job order status to filter the results.
- Item - Select the range of items to filter the results.
- Product Code - Select the range of product code for the job item to filter the results.
- Work Center - Select the range of work center to filter the results.
- Click the Filter button to filter result.
- Click Reset button to clear all the filters.
Job Processing Hours By Operation
This report allows users to monitor the processing hours for all job operations.
The fields in the Job Processing Hours By Operation report are:
| FIELD | DESCRIPTION |
|---|---|
| Job Order | The job order number. |
| Suffix | The job order suffix number. |
| Status | The job order status. |
Item | The designated code given to the job order item. |
Item Description | The full description, specifications, or name of the job order item. |
| Operation Number | The job operation number. |
| Work Center | Work center code of the operation. |
| Work Center Description | Work center name or description. |
| Qty Received | Total quantity received of the job operation. |
| Qty Completed | Total completed quantity. |
| Qty Scrapped | Total rejected quantity. |
UOM | Unit of measure for the job item. |
Setup Time (Hrs) | Total hours spent on job setup. |
Labor Run Time (Hrs) | Total hours spent on job run by employee. |
Machine Run Time (Hrs) | Total hours spent on job run by machine. |
Total Time (Hrs) | Sum of setup time, labor run time and machine run time for the job operation. |
| Ave Labour Run Time per Piece | Total labor run time divide by total quantity completed. |
| Ave Machine Run Time per Piece | Total machine run time divide by total quantity completed. |
| Ave Total Run Time per Piece | Total run time divide by total quantity completed. |
| Planned Labour per Piece | Planned labour hour per piece for the job operation. |
| Planned Machine per Piece | Planned machine hour per piece for the job operation. |
Filter Results
- User may filter result by:
- Start Date - Select the range of job start date to filter the results.
- End Date - Select the range of job end date to filter the results.
- Job Order - Select the range of job order number to filter the results.
- Status - Select the job order status to filter the results.
- Item - Select the range of job item to filter the results.
- Product Code - Select the range of product code for the job item to filter the results.
- Work Center - Select the range of work center to filter the results.
- Click the Filter button to filter result.
- Click Reset button to clear all the filters.
Labour Status Summary
This report provides the details of labour status including the total setup time, total run time and total indirect task time recorded in hours.
The fields in the Labour Status Summary report are:
| FIELD | DESCRIPTION |
|---|---|
Employee ID | Employee code. |
Employee Description | Employee name. |
Setup Time (Hrs) | Total hours spent on job setup. |
Run Time (Hrs) | Total hours spent on job run. |
Indirect Task Time (Hrs) | Total indirect task run time. |
| Indirect Task Occurences | Total number of reporting indirect task. |
Total Time (Hrs) | Sum of setup time, run time and indirect task time for the employee. |
Filter Results
- User may filter result by:
- Date - Select the range of date to filter the results.
- Employee ID - Select the range of employee code to filter the results.
- Click the Filter button to filter result.
- Click Reset button to clear all the filters.
Aggregated Materials Requirement
This report consolidates all materials requirements across various job orders, providing a comprehensive overview of materials needed for upcoming production schedules.
The fields in the Aggregated Materials Requirement report are:
| FIELD | DESCRIPTION |
|---|---|
| Warehouse | Job Order’s warehouse indicates the designated warehouse to receive the job. |
Material | Item number or identifier refers to the material item. |
Description | The full description, specifications, or name of the material item. |
| Total Qty Required | Calculated as the total of (Qty Per * Qty to Release entered from the "Job Order List") for each material. |
UOM | Unit of measure for the material item. |
Filter Results
- User may filter result by:
- Job Order - Select the range of job order number to filter the results
- Suffix - Select the range of job suffix number to filter the results.
- Job Date - Select the range of job date to filter the results.
- Start Date - Select the range of start date to filter the results.
- Item - Select the range of job item to filter the results.
- Click Reset button to clear all the filters.
- Click the Filter button to produce the “Job Order List” popup listing based on selected filters.
- Filters only include 'Released' job orders with (Job order’s qty released minus qty completed) greater than zero.
- User can enter different "Qty to Release" values for each job order as needed.
- Click Reset button to to reset all the "Qty to Release" value to "Qty Required".
- Click Generate button, the popup window will close and return to the parent page.
- Filters only include 'Released' job orders with (Job order’s qty released minus qty completed) greater than zero.
- Filters result include Job Material’s Qty Required greater than zero.
Job Materials Requirement by Operation
This report details the materials required for each operation within a production process, aiding in precise planning and allocation of resources.
The fields in the Aggregated Materials Requirement report are:
| FIELD | DESCRIPTION |
|---|---|
| Warehouse | Job Order’s warehouse indicates the designated warehouse to receive the job. |
| Job Order | The job order number. |
| Suffix | The job order suffix number. |
| Qty to Release | Qty to Release entered from the "Job Order List" for each job |
| Operation | The job operation number. |
| Work Center | Work center code of the operation. |
Description | The full description of the work center. |
Material | Item number or identifier refers to the material item. |
Description | The full description, specifications, or name of the material item. |
| Qty Required | Calculated as the total of (Qty Per * Qty to Release entered from the Job Order List) for each material. |
UOM | Unit of measure for the material item. |
Filter Results
- User may filter result by:
- Job Order - Select the range of job order number to filter the results
- Suffix - Select the range of job suffix number to filter the results.
- Job Date - Select the range of job date to filter the results.
- Start Date - Select the range of start date to filter the results.
- Item - Select the range of job item to filter the results.
- Click Reset button to clear all the filters.
- Click the Filter button to produce the “Job Order List” popup listing based on selected filters.
- Filters only include 'Released' job orders with (Job order’s qty released minus qty completed) greater than zero.
- User can enter different "Qty to Release" values for each job order as needed.
- Click Reset button to to reset all the "Qty to Release" value to "Qty Required".
- Click Generate button, the popup window will close and return to the parent page.
- Filters only include 'Released' job orders with (Job order’s qty released minus qty completed) greater than zero.
- Filters result include Job Material’s Qty Required greater than zero.
Transaction – Print Job Sheet
This report displays the information of the job orders, job operations and the job materials.
Note: Within the Transaction Parameter form, if the "Enable Multi Scan (Production)" checkbox under the System object is selected, then the QR code at the top of the Job Sheet will include both the Job Order and Suffix values. Additionally, in the Job Sheet's listing section below, each record's QR code will incorporate the Job Order, Suffix, and Operation Number. Conversely, if this checkbox is unchecked, the system will revert to generating individual barcodes for each of the Job Order, Suffix, and Operation Number, instead of combining them into a single QR code.
The fields in the Print Job Sheet report are:
| FIELD | DESCRIPTION |
|---|---|
Start Date | The date to begin production. |
Job Date | The date when the job order is created. |
Status | The job status. |
Item | The designated code given to the job order item. |
Item Description | The full description, specifications, or name of the job order item. |
| Action | User can click on Print button to print out the job sheet. |
Filter Results
- User may filter result by:
- Start Date - Select the range of job start date to filter the results.
- Job Date - Select the range of job date to filter the results.
- Job Order - Select the range of job order number to filter the results.
- Status - Select the job status to filter the results.
- Item - Select the range of job item to filter the results.
- Click the Filter button to filter result.
- Click Reset button to clear all the filters.