There are several 3rd Party Products for Microsoft Dynamics GP which integrate into Manufacturing by creating an MO Header (WO010032), but then require manual action by a user to select the MO in Manufacturing Order Entry and click the Schedule MO button. This action, click the Schedule button, causes Manufacturing to create the missing records that were not created by the integration, which may include building the Picklist and Working Routing, and populating MRP and CRP tables. Additionally, the user may have to Release the MO, which, depending on Manufacturing Setup, may also create a Manufacturing Allocation transaction.
The MO Scheduler performs these tasks automatically. It can create the Picklist and Working Routing, populate the MRP and CRP tables, release the MO, and create a Component Transaction Entry “Allocation” transaction.
Additionally, MO Scheduler can be used to reschedule existing MOs, and Child MOs (if the Setup option is enabled to reschedule child MOs). See the Setup chapter.
MO Scheduler can reschedule MOs in Quote, Open, and Released statuses, but the MOs cannot have WIP Labor or Machine recorded.
Likewise, the SQL integration table would require only MO and Due Date.