This process replaces the AQ Import screen under P/A, and is now found under the API module, API>Auto Quotes>Project Import.

Table of Contents

...

Import Project

1. Open the Project Import screen

   1. API>Auto Quotes>Project Import

2. Select the file from your computer

   1. Hit “Browse” button

      1. 

   2. Find file folder

   3. Double-click on file

...

This tab opens by default and allows you to fix the Missing Manufacturers and Cross-Reference.

...

Correct Missing Manufacturers

...

1. Enter the Manufacturer name

2. Enter a Vendor Xref

   1. This is the TRX Vendor associated with the AQ Manufacturer

3. Create the Manufacturer/Cross-reference

   1. Hit the “Add Mfr” button

Correct Missing Cross-Reference

...

If the Manufacturer on the project file doesn’t have a cross-reference, you can correct that here. This is not required to create the Project.

1. Enter the Vendor Xref

   1. This is the TRX Vendor associated with the AQ Manufacturer

Item Errors (tab)

This tab allows you to fix Invalid Units of Measure, Duplicate or Missing AQ Line Number, and Discontinued Items.

...

Invalid Unit of Measure

...

If the UOM on a Project item doesn’t exist on the item in TRX, you will need to correct it here.

1. Select how you want to resolve

   1. Select one of the options from the dropdown

   2. Create Project UOM – This will create the UOM on the project

   3. Use Exiting UOM – Use the UOM already in TRX

2. Confirm the UOM and Qty

3. Create Unit of Measure

   1. Hit the “Update” button

...

Duplicate or Missing AQ Line Number

1. A

Discontinued Items

...

If the Project file has duplicate AQ line #'s, you will need to correct them here.

1. Review the duplicates

2. Decide which one you want to Change

3. Set the new AQ Base line and AQ Sub Line

4. Update the record

   1. Hit “Update” button

...

Discontinued Items

If Discontinued items are on a project imported into TRX, you will need to either remove them from the project or re-activate the item. Removing a base item will remove all of it’s accessories.

...

Removing Discontinued Items

This will remove the item from the project.

1. Hit “Remove” button next to the item

Activating Discontinued items

This will mark the item as Active in TRX.

1. Hit “Activate” button next to Item

Remove Discontinued Base Item, Without Removing Accessories (Workaround)

TRX does not allow a discontinued item on the project, and you can’t remove the base item without removing its accessories. With a few extra steps, you can save needing to re-export the project using this workaround.

1. Activate the Base and Sublines

   1. Hit “Activate” button next to Items

2. Finish setting up Project

3. Process to create Project

4. Create Internal Change Order

   1. Mark for Original Contract

   2. Replace Discontinued item with correct item

   3. Process Change Order

5. Mark item as discontinued again

   1. Open Item (INV>Item Query/Change)

   2. Set Status dropdown to discontinued

   3. Image Added

Process Project

Once the New Items are setup properly and the errors have been corrected, we are ready to finalize the details on our project and process.

Enter/Confirm Project Details

Now that line items are cleaned up, we can enter the Customer and Project information.

1. Select the Customer

   1. Enter Customer # or hit F9 to find it

   2. Hit Enter to load details/defaults

2. Confirm the Customer details

3. Confirm Project details

4. Process the Project

   1. Hit “Process” button

...