Page History: AMS Cross-Reference (XRef) Import
Compare Page Revisions
Page Revision: Wed, 17 Jul 2019 10:26
General Information
Default Menu Location Transactions >> Importers/Exporters >> Item Control >> AMS Item X-Ref Import
Screen Name AMSIMPORT
 AMS CrossRef Importer |
Item File Name/Browse: Use the Browse button to locate and select the completed AMS Import template file (in XLS format).
Map Fields: Fields must be mapped prior to importing. If no changes have been made to the column headings, the mapping screen should show all green, and you can click OK to continue. If any of the Input Field Name columns on the left are red, single-click on the line on the left column, and then double-click the desired mapped field in the right column to complete the mapping. Repeat for any red lines on the left that should be mapped. If there are additional columns in the source file that should NOT be mapped, they can be left unmapped (displayed in red). Mandatory fields will require that they be mapped before clicking OK.
Template: The AMS Cross-Reference Import does not have an 'Export Template' option. You can either create a new Microsoft Excel file with the exact column labels indicated below, or download a sample of the template file linked below. For the desktop import program, the file must be formatted as a Microsoft Excel 5.0/95 Workbook (*.xls).
The columns needed for the AMS Cross-Reference Import Template are listed below. Note that the f1-f255 column identifiers and the third row descriptions are not used on this template. The imported data should begin on row 2.
AMS Attribute: The AMS Item Attribute (text1 Name = 'AMS') must exist in Rule Maintenance with the 'AMSPROD' form name. The AMS Cross-Reference Import will create the required attribute for all imported item records (as long as the AMS attribute exists in Rule Maintenance).
AMS Cross-Reference File Definitions
Required fields are indicated with an *
*Item - Production item code in Adjutant
Material - Material code/name for the AMS integration
Product - Product code/name for the AMS integration
MachineNum - Machine number value for the AMS system
Sample Import File
Sample AMS Import FIle
