MANUALS > Settings > Settings Module > Settings, Update Menu > P/N Master (General Inventory) > P/N Master (General Inventory) Buttons > Vendor Cost Listing Button, via P/N Master (General Inventory) > Vendor P/N Information Buttons > Import Button, via Vendor P/N Information

From the Vendor P/N Information window, select the Import button for the quick import of many records (instead of manually entering) into the R/O Capability window.

Criteria for Vendor P/N Information Import file:

Vendor P/N Information:

Note: Before importing a file, it must be formatted in text-delimited (.txt) format. Otherwise, the system will not be able to process the file's information and display it correctly within this window. The file to be imported must exist somewhere on a stored or shared drive, it must be in text delimited format, and it must contain information that is organized according to the window above, by designated fields. If the first line of the text delimited file is a header, then the related checkbox in the above screen must be selected. In this way, the system will separate the data from the header information. 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.

Enter/update the following information. The following table lists the fields (left to right) in the above import window:

_____________________________________________________________________________________

Import File

The file to be imported must be Tab delimited. Individual records that will be imported must contain a Location/Site that matches the location that is currently selected.

First Line is Header

Check to indicate that the first line in the Tab delimited text file represents a Header line and should not be imported.

P/N

The Part Number reference for the aircraft part.

Type (V or L)

Vendor or Location (V or L).

Vendor/Location

The system code for the service/part provider. The Location for maintenance events, inventory stores, orders, transactions, or training events.

Site

The Site where the work should be carried out (if applicable).

Condition

The condition of the part.

Prefer (Y or N)

Preferred vendor (Yes or No).

Price

Part number price.

Currency

Currency in which price has been set.

Lead Days

Number of lead days.

Warranty Hours

Number of hours that covers repair process.

Warranty Cycles

Number of cycles that covers repair process.

Warranty Days

Number of days that covers repair process.

Schedule A/C Days

Number of days installed on A/C (under the warranty).

Minimum Order QTY

Minimum number of parts required per order.

Valid Until Date

Date until which vendor is able to retain part cost.

Minimum Order QTY 2

Minimum number of parts required per order.

Price 2

Part number price (total price for total units ordered).

Minimum Order QTY 3

Minimum number of parts required per order.

Price 3

Part number price (total price for total units ordered).

Minimum Order QTY 4

Minimum number of parts required per order.

Price 4

Part number price (total price for total units ordered).

Location

Location origin for prices.

Earliest

Whichever schedule parameters happens first.

Under Contract (Yes or No)

Yes or No if vendor is under contract for repair of designated parts.

_____________________________________________________________________________________

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

Note: Data that could not be processed will appear on the Exceptions Tab.

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