AQ Issues

The following are solutions to the most common AQ upload errors.

Customer Detail Discrepencies

The Customer name in Autoquotes needs to match verbatim to the NetSuite record. If you have misspelled anything, or you have extra spaces at the beginning or end of the name, this could throw an error.

Similarly, if the address or point of contact do not match, it can throw an error.

Missing NetSuite Opportunity

You need to create an opporunity from the Customer record before you export the file from AQ. That number needs to go in the JobRef field in AQ.

Missing or Incorrect Customer Subsidiary

Make sure the Customer record has access to the your subsidiary. Go to the Customer record and select the Subsidiary tab. If you do not see your subsidiary, please contact a NetSuite Admin.

Creating an Opportunity for the Wrong Subsidiary

Make sure the subsidiary matches which ever one you work for.

Negative Values in AQ

Make sure the line items in the AQ file do not have any negative dollar values. If they do, please ask your Supervisor to assist you with identifying the correct value.

Previously Processed AQ File

Make sure your AQ file hasn't already succesfully processed.

AQ Cells Exceeds 3,000 Characters

Make sure none of the cells in AQ exceed 3,000 characters. Normally the Spec column is the culprit.

Missing or Incorrect Item Subsidiary

Make sure the item record lists your subsidiary. If they do not, you will need to contact a NetSuite Admin.