This section covers how to import and / or update a list of Master Part Number Vendor Relationships and associated Vendor Part No data
The purpose is to allow the User to:
- Import / update a list of preferred vendors (defined by a rank) and their vendor part no associated with a particular Master (i.e. MasterNo item that we buy/sell), including the default cost of the item from the Vendor
- Note: This is an alternate option instead of accessing the system interface and adding/editing each MasterNo > Vendor tab record one by one
To obtain the Import Template for this process, contact your Q360 Administrator
- For more information, you may also refer to Import Map Builder and Forms with Data Import Capabilities
- Go to Inventory > Import / Update Master Vendors
- An Import / Update Master Vendors popup appears
- Select the applicable Import Filters checkbox(es) for your purpose
- Import items not found in database? and / or
- Import items found in database?
- Select or browse for the data Import File previously filled out and saved (as per pre-requisite)
- Click Import File. You have now updated the Master Part Numbers as listed in your Import Sheet
- Go to Inventory > Master Part Numbers
- Search for Master Part Number(s) on your data Import File
- Notice those Vendors tab > Vendor Master record(s) you imported have been updated