Text File Import Inventory

 

Inventory is used for Material Requirements. 

 

To access Import Inventory, select Interface | Text Import | Import Inventory via Text File from the main calendar menu. 

 

The following screen will appear:

 

 

The following tabs and commands are available from the Manufacturing Order screen:

File

1.Text Import  Select File | Text Import to enter the import information to the prompts.

2.View File  Select File | View File to view a file.  The following window appears enabling you to select the file you want to view:

 
 

The following are explanations of the prompts: 

1.Import filename  Enter the import filename.  The import file must already exist and be in the correct format.  You can click on the open folder icon at the end of the prompt to browse for the import file.

2.Report status filename  Enter a filename where the report status will be written or press enter to take the default filename of ImportInventoryStatus.TXT.  DMS writes the status of the import to the file entered to this prompt.  Import errors with the offending import line are written to this file. 

3.Click OK to start the import, or click Cancel.

 

The Inventory Update record consists of one record type (INV).  During the import, if an Item No already exists in the inventory table, the Item No is updated with the new imported data.  Duplicate Inventory Abbrev and duplicate item numbers (Item No) are allowed as long as the Inventory Abbrev plus the Item No together are unique.