AQ Update Inventory (File)

Overview

You can export the FEDA data or a Project from AQ to Add new items or to update their pricing. You can even export your TRX data to be imported into AQ, Update the Pricing in AQ, then Export to update in TRX.

Export from TRX and Import into AQ

To quickly update data manually, we will start by exporting the TRX data in a format that AQ can read.

1. Create TRX Export

   1. Go to INV>INV Special Functions>Export Data

   2. Follow Guide to Create a Template: Export Data

   3. Use these TRX Fields:

      1. “Item-Item Description”

      2. “Item-Item-Manufacturer”

      3. ”Item-Mfg Part Number”

   4. Export Template

   5. Put the data in this Order

      1. Line_No - Set ascending numbers on the lines to be imported as a project

      2. Quantity - Set for importing the Project, you can set to 1

      3. Description - This is TRX field “Item-Item Description” from the Export

      4. Manufacturer - This is TRX field “Item-Item-Manufacturer” from the Export

      5. Model Number - This is TRX field “Item-Mfg Part number” from the Export

2. Import into AQ

   1. Remove Header from Export File

   2. Import using KCL Import in AQ

Here is template of what the Export should look like:

Export from AQ and Import Into TRX

1. Update Pricing on Project in AQ

2. Export Project from AQ for TRX

3. Use Update Prices guide below to import Project into TRX

Add New Items

You can add new items by using an AQ Project or AQ FEDA export. The Item Category field, Class field, and Attributes checkboxes will appear once you select the Checkbox.

1. Select “Add New Items” Checkbox

2. Select the correct file type: “AQ Project” or “AQ FEDA”

3. Hit Browse to find your file

   1. If you get an error when you select the file, you may need to move the file to another folder on your machine, or remove any apostrophes

4. Set Category and Class

5. Select/Adjust any Control points

   1. These Default based on Category

6. Hit Lightning Bolt to Add Items

*Select the correct file type: “AQ Project” or “AQ FEDA” before hitting Browse to select the file. Otherwise, you will receive an error.

Update Prices

You can update items by using an AQ Project or AQ FEDA export. Checkboxes to select which item details get updated will appear once you select the Checkbox.

1. Select “Update Prices” checkbox

2. Select file type: “AQ Project” or “AQ FEDA”

3. Hit Browse to find your file

   1. Error: Move file or remove any apostrophes

4. Select which data will get updated

5. Hit Lightning Bolt to Add Update Items

*Select the correct file type: “AQ Project” or “AQ FEDA” before hitting Browse to select the file. Otherwise, you will receive an error.