Product Records

1. Open the Product window

updated 3/23/18 for 2018.0.0.5

Navigate to Warehouse Management ➤ Products (Inventory ➤ Products in AV 2015 and earlier).

Open the Product window

2. Create a New Product record

Click the Create New Record icon or use the keyboard shortcut Command + N.

3. Enter the Product info

See below for a description of each section of the Product Info tab.

3.1. Product

  • Name: The full name of the Product as it is to appear on Invoices and Reports.
  • Part Number: Your company’s unique number for the Product (up to 20 alphanumeric characters). This field is mandatory. No two Products can have the same Number.
  • Product Class: This determines certain default settings for this Product record including the GL distribution for Income, Cost of Goods and Inventory accounts. Once a Product Class has been assigned it cannot be changed.
  • SKU:  This is an alpha-numeric, 20 character field. It can be entered for the base Unit of Measure (on this tab) and all alternate UM (on the new Unit of Measure tab).
  • Category: This is a user-definable choice list that allows you to categorize your Products for reporting purposes.
  • Description: A description of the Product (up to 50 alphanumeric characters). The Description can be printed on Invoices and Purchase Orders.
  • Default Sales/PO Line Memo: A larger description field.
    • Uncheck the "Use Description..." box in order to use this field as the default description.
Product

3.2. Cost and Weight

  • Default PO Cost: This field is used as the reference cost for the item. This is the cost that will be used by default when issuing Purchase Orders or processing Inventory Maintenance draw transactions.
    • The cost that posts to the General Ledger (for Cost of Goods Sold and Inventory Valuation) is drawn from the amount entered on the Accounts Payable Voucher or Inventory Maintenance add transaction for the affected Lot.
  • Markup %: The percent of the actual cost used to obtain the sell price. Enter the value in whole numbers. (For example, enter 15% as 15.)
  • Sell Price: The price that your company is charging for this item, not including tax.
  • Vend List Cost: This is the cost that the Vendor lists for the Product in their catalog.
  • List Price: The manufacturer’s suggested retail price.
  • Commission %: The percentage of the sale price received by the sales person for the sale of this product. Enter the value in whole numbers.
  • Weight: The weight of the Product’s shipping unit. This information will be used for shipping purposes. Be sure to use a consistent unit in all products (for example, always use kilograms or pounds).
  • Volume: The 3-dimensional size of the Base UM.
  • Base UM: The base quantity in which the Product is bought or sold. There is a limit of 5 characters. This information appears on Purchase Orders and Invoices.
  • Lock Price: This checkbox indicates that the Product is not subject to Discount or Margin calculations when entering a Sales Order.
  • Built Cost: The Built Cost equals the default cost of inventoried Bill of Materials components (Deflt PO Cost) + the BOM's Non-Inventory component costs + the Default Setup Cost. The Built Cost is your true cost to add a single unit of an Assembly to stock.
    • Note: The Default Setup Cost is prorated for quantities greater than 1. Therefore, the Built Cost listed on the Product record is only an estimate for the cost it takes to build one unit.
Cost and Weight

3.3. Unit of Measure

*New for AV2015*

Alternate Units of Measure are now defined on their own tab of the Product record. Please see the new Units of Measure article for more information.

3.4. Product Type

  • Freight: Select this Product Type for your shipping methods. Items marked as Freight are available in the Ship Via fields of Client records, Sales Orders and Bill To/Ship To addresses. These items are also used when processing shipping documents via your 3rd Party Shipping Software.
  • Inventory: If selected, AcctVantage will track Inventory levels for this item.
    • Assembly: If selected, you are able to define a Recipe of component parts that make up this finished good. A Work Order or Inventory Maintenance transaction is used to relieve the component parts from Inventory and add the finished good to Inventory. Assembled goods can also be purchased via a PO. The default cost of an Assembled product is the sum of the component parts costs plus any GL/Expense costs indicated. When adding Assemblies via Work Orders or Inventory Maintenance Transactions, you are able to add labor and overhead charges to the new units.
      • Auto-Build: If the Auto-Build Assembly box is checked, then AcctVantage will attempt to build the Assembly (using the standard Recipe) when there is a shortage at point-of-sale. Please see the section on Assembly versus Kit Product Types for more details on this process.
    • Serialized: If selected, AcctVantage will track individual units of the Product with a unique Serial Number.
  • Non-Inventory: Select this Product Type for services, fees, misc. items.  Anything that is intangible is non-inventory.

In this context non-inventory simply means an intangible item.  A service or fee for example.  This has nothing at all to do with your decision to regularly stock or not stock a tangible item.  If a product has a physical presence, it is always inventory!

  • Kit: A Kit consists of a Recipe of inventory and non-inventory items sold under a single part number. Unlike Assembly’s, a Kit does not draw available Inventory until the item is sold; there is no need to “build” a Kit prior to sale.
    • Fixed Price: The Sell Price for a standard Kit is the sum of the components' Sell Prices, as opposed to a Fixed Price Kit, which you can lock in a price so it won't change if the components' Sell Prices changes or items are substituted in the Recipe.  
  • Template: Templates are similar to Kits in that they consist of a BOM of Inventory items. However, when a Template is entered on a Sales Order, AcctVantage replaces the Template line item with an individual line item for each Template component.
Product Type

3.5. Attributes

  • Inactive: If selected, the product is inactive. Inactive products cannot be sold and do not appear in pop-up lists for data entry, but will still be searchable in the Product List View. You can reactivate a product by unchecking the option box.
  • Taxable: If selected, sales tax is calculated for the item on Sales Orders.
  • Do Not Print: Checking this box will prevent any Sales related document (Invoice, Pick Ticket,Order, etc.) from from printing a line item for this part number.  This can be helpful for special instructions, items that need to be tracked as sold but not included on an invoice, etc.
  • AvaTax Tax Code: If using the integration with AvaTax, this code determines the tax status of the product.
  • Harmonized Tariff Schedule: Required for international shipping
  • Country of Origin: Required for international shipping
Attributes

3.6. Vendor

  • Primary Vendor Name & Primary Vendor Code: The name and code of the default Vendor that supplies the Product. This field must be used if you plan on using the Auto-PO feature.
  • Vendor’s Part Number: A Vendor Part Number for the Product.
  • Vendor's bar code: A Vendor bar code for the Product.
  • Memo: Any pertinent information regarding the Product in this field. AcctVantage uses this field to automatically record important system modifications. For example, if a user changed the name of the Product, AcctVantage will state this fact in the Memo field, along with the date and user name.

This section also includes options for data from a 2nd Vendor and the ability to Swap these 2 Vendors if the secondary Vendor becomes primary at some point in the future.

Vendor