Overview of Value Lists

Value Lists define the choices available in Accolent ERP for things like Product Categories, Customer Types, or Tax Jurisdictions. They are organized by usage. A set of Value Lists that is only available from Product records is found in the Product Only Lists menu arranged alphabetically. Other Value Lists are shared amongst Products, Customers, Prospects, Vendors, Receivables, Payables, etc. and are found in two alphabetical lists from Settings > Value Lists.

Value Lists

Below is a summary of the key Value Lists with a brief description of what each Value List is used for. Each hyperlink below links to the Accolent ERP Help wikis for that Value List.

  • Bank Accounts: Used to set up the bank accounts you use to track, add deposits to and use to pay checks.
  • Categories: Used to set up organize, select and report on products. Categories belong to groups. Categories are composed of sub-categories.
  • Commission Types: Used to specify different types of sales commissions.
  • Country Codes: Accolent comes a standard list of countries already defined. You can add additional Countries for foreign customers and vendors.
  • Credit Statuses: Credit status codes assigned to a customer determine whether the customer will be allowed to place an order and under what conditions.
  • Currencies: Used to add additional Currencies for foreign customers and vendors.
  • Customer Types: Used to group customers for reporting purposes.
  • Delete Code: Used to identify why line items were removed from an order.
  • Delivery Routes: Used to assign customers to specific routes for delivery purposes.
  • Departments: Used to track GL transactions for budgeting or other financial management and control purposes.
  • DOT Codes: Used to track Department of Transportation requirements related to the shipment of hazardous materials.
  • Dynamic Lookup: Used to create configurable value lists (e.g., landed cost types).
  • eCommerce Product Filters: Used to set up the product filters available from the Accolent Self-Service portal.
  • Groups: Used to organize products into meaningful groupings.
  • Linked Document Types: Used to identify types of linked documents. Types that are marked as MSDS and Web types will be available to customers from product detail pages in the Accolent Self-Service portal.
  • Locations: Used to define the layout of locations within the warehouse.
  • Lots: Used by the Lot Control system to track lot numbers for lot controlled products.
  • Pricing Tiers: Used to create pricing profiles for customer groups (e.g., retail, resellers, contractors, competitors, etc.).
  • Prospect Types: Used to group prospects for the purposes of reporting.
  • Sales Routes: Used to track a salesperson’s customers in his/her sales territory.
  • Sales Territories: Used to set up the types of territories that can be assigned to salespersons.
  • Ship Vias or Shipping Methods: Used to specify shipping methods in both order entry and PO entry.
  • State Codes: US state codes are included with Accolent.
  • Sub-categories: Used to set up sub-categories used to organize and report on products. Each sub-category can be associated with one category.
  • Tax Codes: Tax codes determine whether order lines will be taxed and at what rate. Tax codes should be assigned to customers and products.
  • Tax Jurisdictions: Tax jurisdictions are defined by state.
  • Terms: Used to specify the payment and or credit terms you make available to customers and receive from vendors.
  • Warehouse Discounts: Used to specify warehouse discounts given.

Certain Value Lists are minimally required before you can set up particular master Records. However, it is generally the best practice to set up all the Value Lists before entering or importing any of the Master Records

Value Lists Required for Customer and Vendor Records

Following are the Value Lists required before the Customer and Vendor master Records can be entered:

  • Credit Statuses
  • Customer Types
  • Pricing Tiers
  • Tax Codes
  • Tax Jurisdictions
  • Terms

Value Lists Required for Product Records

Following are the Value Lists required before the Product master Records can be entered:

  • Categories
  • Commission Types
  • Groups
  • Locations
  • Sub-categories

Sub-Master Records Required for Customer and Vendor Records

If you are importing your data, the following sub-master Records files also need to be created.

The following Sub-master Records files need to be created before the main master Records can be entered or imported.

  • Salespersons: sub-master listing all salespersons who can then be assigned to customers.
  • Warehouses: sub-master listing of all warehouses.

 

 

  • Was this Article Helpful ?
  • Yes   No
Tagged: