How to import by manufacturers part number on purchases

If your vendors name for a part is different from the inventory item name in QuickBooks then importing purchase orders, bills and item receipts into QuickBooks can lead to unrecognised inventory item names.  You can set the option in the Axis import module to use the Manufacturers Part Number field in QuickBooks and Axis will lookup the relevant item name in QuickBooks for you.

Vendor Part Number Lookup

 

 

Follow these steps:
  1. In the Axis import module click on the options button.
  2. Check the box for Vendor Part Number Lookup, and click OK.
  3. In the mappings map your column that contains the Vendor Part Number to the Item Ref Full Name field
  4. When the preview opens Axis lookups the Manufacturers Part Number field in QuickBooks to find the corresponding inventory item and displays it in the preview
  5. Click OK and your data will be imported into QuickBooks.