2.2 Work Order excel template upload

Below steps illustrates the usage of excel upload functionality for uploading work orders. Once the upload is completed user should be able to schedule it from Production Scheduler application.

Step 1: Download the Work Order upload blank template

Go to Masters

Click on General Sync

Click on Download button to download the excel template

Step 2 : Fill up the template

Multiple sheets exists in the template which corresponds to data sets required for uploading the work order template. Below steps explains in detail data entry for each one of them.

Ensure each field follows the appropriate pattern as per shown in the below sample data.

Instructions for filling the template has been also provided in the template itself. Please refer the sheet with the name Help .

Step 2.1 : Work Order data entry

Key values high lighted in yellow color.

Refer below image for Sample Work Order data

Step 2.2 :Sub Work Order data entry

Refer below image for Sample Sub Work Order data

Step 2.3 : Routing data entry

Refer below image for sample Routing data

Make sure Operation Code is mapped correctly in Operation Master.

Step 3: Click on the Upload icon to upload Work Order template.

Step 4: Once upload is successful work order can be verified in Production Scheduler application