Excel Map

Excel Map

The Excel file must not have Column Headers (data should start in Row #1).  A spreadsheet to change the Due Date/Start date on an MO, and reschedule it will look like this:

//willoware.com/wp-content/uploads/2016/10/MOGenRescheduleXLS.png

Note that the only two columns needed are MO Number and Due Date.

Col Name Required Notes
A MO Number NO MO Number must exist in GP.

MO Number will be truncated at 30-characters and converted to upper case.

B Item Number NO Not Used. Default to empty string.
C Quantity NO Not Used. Default to empty string.
D Due Date NO Default to 1/1/1900 or 19000101.

If a Due Date is provided, the Start Date and Due Date on the MO will be set to the new date, and then it will be rescheduled using the Scheduling Method on the MO.

If Due Date is blank, the MO Scheduler will create a Working Routing (if one does not exist), and Release the MO if the MOGen MO Status is set to RELEASED. If Manufacturing Setup has the “Allocate when MO is Released” checkbox marked, an Allocation transaction will be created.