Importing Updates to Your Line Item Codes

aACE provides robust features to update information on existing line item codes (LICs). These updates are initiated from the Actions menu. In addition, system administrators can update even more data using the Admin Actions menu. 

Many of these update processes allow you to enter text values, enter number values, select relevant options, or select other aACE records. 

Update LICs Using the Import Process

A few update processes allow you to import data from a spreadsheet. These include:

• Update pricing data (e.g. costs, rates, and commissions)
  Note: For enhanced flexibility on rates and rate structures, you can also leverage rate cards.
• Update physical specifications (e.g. dimensions and weights)
• Update AvaTax codes (system administrators only)

You can update all, some, or a single value on an import spreadsheet. To simplify an import spreadsheet you're working with, delete columns that are not being used.

Before you import updates to your LICs, be sure you understand the general process for importing records.

1. Navigate from Main Menu > Order Setup > Line Item Codes.
2. Use the Quick Search bar to display the desired LICs in the list view.
3. Click Actions and select an option:
   • Update Costs, Rates, Commissions for Line Item Codes in List
   • Update Product Specs for Line Item Codes in List
   • System administrators — Click Admin Actions > Update AvaTax Tax Code for Line Item Codes in List
4. At the confirmation dialog, click the appropriate option:
   
   • Import — If you already have an Excel or FileMaker spreadsheet with the needed LIC(s) and update information. Then continue with Step 5.
   • Export — If you do not have a prepared spreadsheet. This generates a spreadsheet on your workstation showing the currently displayed LIC(s) and their information.
     1. Save the export in Excel or FileMaker format.
     2. Edit the spreadsheet with the needed LIC updates.
        Note: Some spreadsheet editing software will not round by default. If you don't include a rounding instruction in the calculation, your data in aACE may have more decimals than you require. For example, if you need to update all costs by 5%, add a new column called "Rate Value Update" and enter a calculation such as "Round(Rate Value*1.05,2)".
     3. Begin this process again. At Step 4 click Import.
5. Continue with the steps for the general import process.
   Warning: At the Specify Import Order dialog, you must set the import action to "Add". Incoming data is first added to a cache table for validations. After that stage is complete, the data is transferred to your existing records.

Vendor-Specific Updates of Costs, Rates, and Commissions 

For vendor-specific updates, the import spreadsheet includes a column for Vendor Abbr. These LIC update processes focus on modifying existing data rather than adding new data. This means that in order for vendor-specific updates to work, the vendor must already be associated with the LIC. New vendors cannot be added to an LIC by an import.

To update the information for a specific vendor on the LIC's Vendors tab, enter the abbreviation or code for a vendor already connected to the LIC, then specify the desired modifications.