How to create a new inventory item in EBMS
The new inventory item wizard is used to create a new item in the EBMS Product Catalog. Review the Changing Product Information section for instructions on changing existing items. Complete the following steps to add a new inventory item.
Note: EBMS uses the terms inventory item and product interchangeably.
-
Create a new product record from any of these locations:
-
Open Inventory > New Product from the main EBMS menu.
-
Open Inventory > Product Catalog from the main EBMS menu. Click the New button in the lower right-hand corner of the page to start a new record.
-
Click the plus sign (+) next to Inventory > Product Catalog on the main page.
-
-
Any of the options above will launch the new inventory wizard.
-
Highlight the category or subcategory folder where you want to place the new inventory item and click Next. Review the Adding and Deleting Product Categories section for more details on creating new inventory category folders.
-
Enter a Description of the inventory item. This description may span up to three lines. Note that if information is typed on the second and third lines, the Show on Invoice switch is turned ON. The description line will show on the sales invoice if the Show on Sale option is enabled (checked) and will show on the purchase order/expense invoice if the Show on Purc option is enabled.
-
Disable either Show on option to exclude the description from either the sales or expense invoice. If the first line Show on options are disabled, the user will be prompted to manually enter the item description.
-
Enter the main unit of measure into the Default Selling Unit entry. This entry can be kept blank if no unit of measure is desired. Review the Unit of Measure Overview section for more details on the unit of measure option in inventory.
-
Enter an optional UPC or Alternate ID. Review Entering Barcodes for more details on these options.
-
Enter an ID into the Manufacturer section if all of the inventory items within the category folder are made by a common manufacturer. Go to Manufacturer Settings for more details. Click the Next button to continue to the Information page.
. -
Change the default classification, if necessary, by clicking on the down arrow button to the right of the Classification field. The proper selection of the inventory Classification is important since changing this setting is restricted. Asset G/L transactions are generated based on the Classification setting. Review the Inventory Classifications section for descriptions of the classification options and other details.
-
Enter the Gross Weight of the inventory item. This weight is used within a sales order or invoice to calculate the total weight of an order. Review the Calculating and Comparing Freight Charges section within the Sales documentation for more weight and shipping configuration options. This field can be kept blank if total weight is not needed or if the inventory item does not have a weight.
-
Choose a Tax Group option from the drop-down menu. Review the Sales Tax section of the sales documentation for more details on sales tax set up. Review the Calculating Fuel Taxes section within the sales documentation for an example of calculating flat taxes such as fuel taxes or FET taxes for specific items.
-
Enter the stock location or locations of the inventory item within the Location list. This optional list allows the user to identify one or more locations of the item within a warehouse or store. Review the Stock Locations section for more details.
-
Enable the Pick option by clicking on each location that is included in the pick list form.
-
Click the Next button to continue.
. -
It is optional to enter an amount in the Cost field since the cost will automatically be updated the next time an expense invoice is processed. However, it may be useful in setting the pricing for this item if a value is within the Cost field.
-
Set the Margin or Markup setting to Equal to if the price of the items is normally calculated from the cost. Set the Margin or Markup to (None) to manually enter the base price and calculate different price levels from the base price. An example of using a manual base price is if all price level prices are derived from a suggested list price. The base price would equal the list price that is manually entered.
-
The Price Level and Unit columns cannot be edited within this wizard. To add additional price levels to the list, go to Inventory > Options > Price Levels tab. The Unit column depicts the main unit of measures that is set within the folder defaults. See the Adding a New Unit of Measure section for more details.
-
A G/L Account column will appear if the Use Price Level G/L account switch is turned ON. This option is found in the product record's Advanced tab. Enter the 5-digit sales general ledger account code for each price level. This feature allows the sales total of each price level to be posted to a different general ledger account. For example, the retail sales could be posted to a different general ledger account than the wholesale sales.
-
Set the Formula column to (None) to enter a price amount for each price level. Enter the desired formula to calculate the price from the base price. Review the Pricing Overview section for more details.
-
Click the Next button to continue.
-
Enter the Product ID. This ID code is required to be unique for each inventory item. The Product ID is used throughout the entire accounting system for all transactions associated with this inventory item. Choose an ID format that makes sense, since changing the inventory ID is a lengthy process. Code the item from the most general characteristic to the most specific. For example, for a 25-foot measuring tape, a possible ID could be TLMT25. TL Tool, MT measuring tape, and 25 for the size. Review the Creating IDs section from the main documentation for more details.
-
Complete the following steps if this new item is classified as No Count:
-
Check the box next to I want to view the new inventory item now.
-
Click Finish.
-
Click on the product record Advanced tab after the new product opens and look for the option that says "This is a shortcut, discount, or other non-product code. Disable this option for a service code used as a consumed item in a manufacturing batch or purchased for a job."
-
Verify that this shortcut option is disabled unless this inventory item identifies a shortcut such as a Service item, a No Count item, or other non-product shortcut. Review Product Shortcuts and Credit Offset Switch for more details.
-
Click Finish to create the new inventory item or Cancel to exit saving the new record.
-
When the new inventory item is created, there may be other item details that need to be edited. To view all inventory item information, review the Changing Product Information section.