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.

...

Manual Price Update Process

Export from TRX and Import into AQ

...

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 DescriptionITEM_DES”

      2. “Item-Item-Manufacturer” MANUFACTURER”

      3. ”Item-Mfg Part Number”MAN_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

...

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 and Update items

Once you have your AQ files, you can either Add or update items.

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.

...