Import/export template > Module Manufacturing > Import/export template MFG (Import work order)
 |
 |
Import work order
Use this template to extract firm or planned work orders. You can use it to import work order data from any third party product into Sage X3 and to export from Sage X3.
This template uses automatic processes developed for the Planning workbench. The controls and updates are managed by a specific/custom process (no object). Imported data uses the global variable GIMP to provide information not carried in the released product (MFI) record, where:
GIMP(1) - Routing
GIMP(2) - Alternative
GIMP(3) - Update code (C=Creation; M=Modification; A=Deletion)
GIMP(4) - Work order status (1=Firm; 2=Planned)
Prerequisites
Parameters to be entered
The following parameters must be entered
Inventory
MFGMTSNUM (defined at level Site) : Automatic WO transaction
Mandatory fields in the template
According to the import type:
Creation:
- Production site
- Product reference
- Start and end dates
- Planned quantity
- BOM code (alternative)
- Routing
- Routing code (alternative)
- WO status (firm or planned)
Modification:
- WO number (work order number)
- Start and end dates
- Planned quantity
- BOM code
- Routing
- Routing code
- Project
- Lot
- Priority
- BP (Business partner)
A planned work order can be converted to a firm work order.
Deletion:
- WO number
Error messages
In addition to the generic error messages, the following messages can appear during the entry :
Error messages on creation
- Site [site code] is not a production, purchase or storage site
- Non-existent Product Code
- Product not managed in stock for the site
- Start Date Invalid
- End Date Invalid
- Order Status Invalid
Error messages in modification
- Expected quantity less than the actual quantity:
- Manufacture in progress. The start date cannot be questioned!
- Order Status Invalid
Error messages on deletion
- The work order status does not authorize its deletion