Import Button, via P/N Inventory Level

MANUALS > Settings > Settings Module > Settings, Update Menu > P/N (Part Number) > P/N Master Buttons > Inventory Levels Button, via P/N Master > P/N Inventory Level Buttons > Import Button, via P/N Inventory Level

The Import button appears throughout the system and is used to quickly import files that do not exist in the system. The same process can be applied to any import found within the system.

Before proceeding with the following import, refer to the initial steps which have been outlined via the Import Button, via the Standard Buttons which can be found in the System Standards Training Manual.

Note: Import files for eMRO should be saved as .csv (comma delimited) or .xlsx and cannot have spaces in the title of the file. Spaces in the file path will cause errors when importing.

Criteria for P/N Inventory Level Import file:

Column Name	Data Type	Limitation	Path
Company	Alphanumeric	8	Settings/Update/P/N Master/Inventory Levels Button.
P/N	Alphanumeric	25	Settings/Update/P/N Master/Inventory Levels Button.
Location	Alphanumeric	8	Settings/Update/P/N Master/Inventory Levels Button.
Max Stock	Numeric	6	Settings/Update/P/N Master/Inventory Levels Button.
Min Stock	Numeric	6	Settings/Update/P/N Master/Inventory Levels Button.
Reorder Level	Numeric	6	Settings/Update/P/N Master/Inventory Levels Button.
Max Order	Numeric	6	Settings/Update/P/N Master/Inventory Levels Button.
Min Order	Numeric	6	Settings/Update/P/N Master/Inventory Levels Button.
Planner	Alphanumeric	10	Settings/Update/P/N Master/Inventory Levels Button.
Buyer	Alphanumeric	10	Settings/Update/P/N Master/Inventory Levels Button.
EOQ	Numeric	6	Settings/Update/P/N Master/Inventory Levels Button.
Trigger Requisition	Y/N	1	Settings/Update/P/N Master/Inventory Levels Button.
Group	Alphanumeric	N/A	Settings/Update/P/N Master/Inventory Levels Button.
POU	Y/N	1	Settings/Update/P/N Master/Inventory Levels Button.

From the P/N Inventory level window, select the Import button. The system displays the Import From File window.

eMRO-PN Inventory level import-0

From the Import From File window complete all of the Import steps.

eMRO-PN Inventory level import-1

For information regarding how to Import a file, refer to Importing a File via Import Button of the System Standards Training Manual.