Excel Import
Importing MO Receipts from Excel supports importing the MO Header data, Picklist, Routing and Serial Numbers for the finished good.
MORI Excel Import does not support WIP Inventory Transactions.
The Excel workbook can have up to four worksheets as specified below. The sheets must be in the order shown below:
- MO Header (Sheet 1)
- Picklist (Sheet 2)
- Routing (Sheet 3)
- Serial Numbers (Sheet 4)
The workbook does not need to have all sheets, but Sheet 3 (for example) is always assumed to be the Routing, so to import the Routing the workbook must at a minimum have a blank Sheet 2 (Picklist). Likewise, to import finished good serial numbers, the workbook must have at a minimum blank Sheets 2 and 3.
The first row of each worksheet is assumed to be column headers and will not be read. Data should start in Row 2.
Excel import works with the “Run Once” setting only.
See the following sections for the Excel File layout.