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:
Note that the only two columns needed are MO Number and Due Date.
|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.