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.
Manual Price Update Process
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.
Create TRX Export
Go to INV>INV Special Functions>Export Data
Follow Guide to Create a Template: https://sunsofterptampa.atlassian.net/wiki/spaces/TM/pages/6554008
Use these TRX Fields:
“Item-ITEM_DES”
“Item-MANUFACTURER”
”Item-MAN_PART_NUMBER”
Export Template
Put the data in this Order
Line_No - Set ascending numbers on the lines to be imported as a project
Quantity - Set for importing the Project, you can set to 1
Description - This is TRX field “Item-Item Description” from the Export
Manufacturer - This is TRX field “Item-Item-Manufacturer” from the Export
Model Number - This is TRX field “Item-Mfg Part number” from the Export
Import into AQ
Remove Header from Export File
Import using KCL Import in AQ
Here is template of what the Export should look like:
Export from AQ and Import Into TRX
Update Pricing on Project in AQ
Export Project from AQ for TRX
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.
Select “Add New Items” Checkbox
Select the correct file type: “AQ Project” or “AQ FEDA”
Hit Browse to find your file
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
Set Category and Class
Select/Adjust any Control points
These Default based on Category
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.
Select “Update Prices” checkbox
Select file type: “AQ Project” or “AQ FEDA”
Hit Browse to find your file
Error: Move file or remove any apostrophes
Select which data will get updated
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.
Processing the Update
When you hit the lightning bolt, the change record screen will come up. Here you can check, adjust, and update your items.
Header Fields
Model - Enter model number to search list of items by Model
Vendor- Enter Vendor number to search list of items by Vendor
Discount- Enter Discount to search list of items by Discount
Exit - This button will leave the update screen
Detail Fields
Item - Item number from TRX
Item Description - Item Description from TRX
Vendor - Vendor Number for the item
Sell U - Selling UOM for the item
Cost - The Cost of the item
List Price - The List price for the item
Net Price - The Net Price for the item
AQ Net Price - The Price coming from AQ Net
Disc. - The Discount for the Item
Per Off - Percentage off, based on Discount
Bottom Buttons
Process Transactions - This will Process all of the items in the screen, ignoring any items that had errors and weren’t marked to process.
Update All Records - This will process all items, including those with Errors