-
Inventory Class field: This field should contain one of the following 3 values:
-
Stock: An item should have a Class of Stock if it is a tangible item that you sell that is purchase to sell from stock, special ordered, or drop shipped.
-
Service: An item should have a Class of Service if it is not a Labor item or a Stock item.
-
Labor: An item should have a Class of Labor if the item is specifically an item that is tracked as a Labor item.
-
Descriptive fields: Look for missing or incorrect values in the item's descriptive fields, such as:
-
Description (the description used on Quotes, Orders, Invoices, and Purchase Orders)
-
Category (the item category)
-
Sub Category (the item sub category)
-
Sub Category 1 (the item's sub-sub category)
-
Sub Category 2 (the item's sub-sub-sub category)
-
Sub Category 3 (the item's sub-sub-sub-sub category)
-
Shipping Weight (the items shipping weight)
-
Unit (the unit of the shipping weight)
-
Item Unit of Measure (the item's unit of measure)
-
Case Pack (the item's case pack description)
-
Case Pack UOM (the item's case pack description unit of measure)
-
Default Supplier and Manufacturer fields: Look for missing or incorrect values in the item's default supplier and manufacturer fields, such as:
-
Default Supplier (the item's default supplier used for Auto PO's. This field is listed as the Supplier Number in the Inventory table)
-
Default Supplier Item #
(the item's default supplier item number used for Auto PO's. This
field is listed as the Manufacturer Item Number in the Inventory table)
-
Manufacturer (the manufacturer of the item, if different than the default supplier)
-
Mfr Model # (the item's manufacturer's model number
-
Item Characteristic fields: Look for missing or incorrect values in the item's characteristic fields, such as:
-
Active (if the item is actively used)
-
Taxable (if the item is generally taxable)
-
Special Order (if the item is a tangible item for sale, whether you stock it or not, that typically needs to be special ordered)
-
Multi-Warehouse (if the item will be received into and sold out of more than 1 warehouse)
-
Color/Style (if the item needs to be tracked by Lot, pallet, shipping ID, etc)
-
Serialized (if the item must be tracked and taken out of stock based on a unique serial number for the item)
-
Matrix Pricing (if you would like to display pricing matrix for the item--on the Financial tab)
-
Assembly (if the item is an assembly of more than one or more items in the Inventory table
-
Force Pre-Assembly
(if the item is an Assembly item AND if the item should attempt to
deplete its own inventory levels, rather than try to automatically
deplete the inventory levels of the sub-components in the assembly)
-
Editable Assembly
(if the item is an Assembly item AND if the item should attempt to
automatically deplete the inventory levels of the assembly's
sub-components (in order to fulfill an order for the item). This
setting also enables the item's sub-components to be edited (changed,
added, deleted, on the fly at the time of the order)).
-
Ecommerce (if the item is also sold on the company's ecommerce website)
-
Commissionable (if the item is to be included on commission reports)
-
Item Pricing / Costing fields: Look for missing or incorrect values in the item's pricing and costing fields, such as:
-
Retail
(this is the price used if no other pricing type is setup. This is
also the price used to calculate a discount, when the Default Pricing
Type is set to Discount)
-
Default Supplier Cost (the item's default supplier cost/price. This field is listed as the Cost from Mfg field in the Inventory table)
-
Product Pricing Group
(the Product Pricing Group name used in each customer's Custom Pricing
tab and in Custom Pricing Templates. If you are using Custom Pricing,
each item should typically be in a Product Pricing Group).
-
Price Unit
(this field is currently used by the MFG Rep type of Quote, Sales
Order, or Invoice to determine if the price if per each, per 100, per
1000, etc.)
-
Buyer
(this field is used to narrow the selection of items displayed on the
Automated PO's screen to only those of a particular buyer)
-
Price Change Datestamp (this field displays the last date the item price was updated)
-
Item GL Account fields: Look for missing or incorrect values in the item's characteristic fields, such as:
-
Inventory
(this field is normally the Inventory asset GL account in the Chart of
Accounts. Note: The actual GL Account ID number is stored in the table
rather than the Account Number)
-
Sales
(this field is normally the Sales revenue GL account in the Chart of
Accounts. Note: The actual GL Account ID number is stored in the table
rather than the Account Number)
-
COGS
(this field is normally the Cost of Goods GL account in the Chart of
Accounts. Note: The actual GL Account ID number is stored in the table
rather than the Account Number)
-
Item Stocking information fields: Look for missing or incorrect values in the item's characteristic fields, such as:
-
Picking Order
(this is a numeric field used by the Stock Picking Tickets to arrange
items to be picked off the shelf by Picking Order, then Location, then
Bin)
-
Location
(this is an alpha-numeric field used by the Stock Picking Tickets to
arrange items to be picked off the shelf by Picking Order, then
Location, then Bin)
-
Bin
(this is an alpha-numeric field used by the Stock Picking Tickets to
arrange items to be picked off the shelf by Picking Order, then
Location, then Bin)
-
(Min.) Reorder Point
(this field is used to display the minimum quantity in stock that you
would like to have at all times. This field is displayed on various
Inventory stocking reports and is also used by the Automated PO's
system).
-
(Max) Stock Level
(this field is used to display the maximum Stock Level that you would
like to bring the inventory level up to when the stock level has fallen
below the (Min.) Reorder Point. This field is displayed on various
Inventory stocking reports and is also used by the Automated PO's
system).
-
Quantity in Stock, Quantity on BO, Quantity on Order
(these fields display the Quantity in Stock available for sale, the
Quantity on Back Order, and the Qty on Order on PO's. These fields do not
need to be updated manually, as they are all auto updated each time an
item is received, each time an item is shipped on a Sales Order, each
time the Recalculate Qtys button (on the Availability tab) is pressed, and each time an Auto PO is calculated)