Editing Inventory

In the Inventory section of the Inventory module you can setup and access all inventory items. View stock for the item, move stock between warehouses, view item purchase history, and setup ordering information for the item. You can also initiate a PO from the inventory item.

== Inventory Item Summary ==
In each inventory item you can track your stock levels and see how many parts are available for orders and how many parts are reserved on orders.<br>
To see how SME handles inventory stock valuation see [[Inventory Valuation]]

Circled in the image below, you will see the inventory summary for an inventory item.

[[File:StockSummary.jpg]]

'''On Hand''' - The quantity of stock in your warehouses. On Hand increases when stock is added to your warehouses, decreases when stock is delivered to customer (reserved on an order and the order is closed)

'''Allocated''' - Number of parts requested to be reserved for a service order, install orders, or itemized invoices.

'''Reserved''' - The number of parts applied to service orders, install orders, or itemized invoices.

'''Unallocated''' - The number of parts that are available to allocate to an order (parts available to request to reserve on an order)

'''Available''' - The number of parts in your warehouses that aren’t reserved. (on hand – reserved = available)

'''ON PO''' - Number of items on purchase orders

'''RMA Out''' – Number of items on return

'''Cost''' – The cost of all stock available for the item (On the Material Details tab, Quantity * Item Cost)

'''Retail Value''' – the retail value for all stock available for the item (On the Material Details tab, sum up Quantity * Item Retail)

== Create a New Inventory Item ==
If you are syncing SME with QuickBooks and you have inventory items in QuickBooks, your inventory items will be imported. If you are not syncing with QuickBooks, this is how you can create inventory items in SME.

<br>1.       In the Inventory module, click '''Inventory'''.
<br>2.       Click '''New'''.

<h3>Details and Settings Tab</h3>
{| class="MsoTableGrid" style="border-collapse: collapse; border: medium none"
| style="width: 9.65in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" colspan="2" width="926" valign="top" |
[[Image:BlankInventoryItem.jpg]]

'''Description of Fields'''
|-
| style="width: 2.45in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="235" valign="top" |
'''Item Name'''
| style="width: 7.2in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="691" valign="top" |
Name of the inventory item
|- style="height: 11.65pt"
| style="width: 2.45in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt; height: 11.65pt" width="235" valign="top" |
'''Description'''
| style="width: 7.2in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt; height: 11.65pt" width="691" valign="top" |
Description of the inventory item
|-
| style="width: 2.45in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="235" valign="top" |
'''Item Cost'''
| style="width: 7.2in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="691" valign="top" |
Your cost to buy this item
|-
| style="width: 2.45in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="235" valign="top" |
'''Retail'''
| style="width: 7.2in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="691" valign="top" |
The amount you sell this item for
|-
| style="width: 2.45in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="235" valign="top" |
'''Condition'''
| style="width: 7.2in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="691" valign="top" |
Select a general condition for the item.
|-
| style="width: 2.45in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="235" valign="top" |
'''Status'''
| style="width: 7.2in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="691" valign="top" |
You can customize the drop down values to describe the status of the items
|-
| style="width: 2.45in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="235" valign="top" |
'''Default Location'''
| style="width: 7.2in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="691" valign="top" |
Select the warehouse you are using to store this item. When receiving items on a PO, SME will add the stock to the default location.
|-
| style="width: 2.45in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="235" valign="top" |
'''Man. Part Number'''
| style="width: 7.2in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="691" valign="top" |
Manufacturer part number
|-
| style="width: 2.45in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="235" valign="top" |
'''Class'''
| style="width: 7.2in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="691" valign="top" |
Select the Class. Classes are imported from QuickBooks.
|-
| style="width: 2.45in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="235" valign="top" |
'''Shelf and Bin'''
| style="width: 7.2in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="691" valign="top" |
Enter where you are storing the item in the warehouse
|-
| style="width: 2.45in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="235" valign="top" |
'''HW and SW Version'''
| style="width: 7.2in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="691" valign="top" |
Hardware and Software Version
|-
| style="width: 2.45in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="235" valign="top" |
'''Item Number'''
| style="width: 7.2in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="691" valign="top" |
You can type the barcode number here
|-
| style="width: 2.45in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="235" valign="top" |
'''System Type'''
| style="width: 7.2in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="691" valign="top" |
<span class="apple-style-span"><font color="black">Used to designate major systems of inventory or customer equipment.</font></span>
|-
| style="width: 2.45in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="235" valign="top" |
'''Group code'''
| style="width: 7.2in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="691" valign="top" |
<span class="apple-style-span"><font color="black">Used to group or categorize parts.  For example, plumbing, electrical, etc. </font></span>
|-
| style="width: 2.45in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="235" valign="top" |
'''Cust. Warranty Months'''
| style="width: 7.2in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="691" valign="top" |
Enter the warranty period you offer your customers for this part
|-
| style="width: 2.45in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="235" valign="top" |
'''Vendor Warranty Months'''
| style="width: 7.2in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="691" valign="top" |
Enter the warranty period your vendor offers you
|-
| style="width: 2.45in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="235" valign="top" |
'''Labor Hours'''
| style="width: 7.2in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="691" valign="top" |
Enter the estimated labor hours associated with this item. When this item is added to an order, your user will be prompted to add those labor hours in the Labor Editor window.
|-
| style="width: 2.45in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="235" valign="top" |
'''MTBF'''
| style="width: 7.2in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="691" valign="top" |
Enter mean time before failure is applicable
|-
| style="width: 2.45in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="235" valign="top" |
'''Non –Taxable'''
| style="width: 7.2in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="691" valign="top" |
Check here if this item is non-taxable
|-
| style="width: 2.45in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="235" valign="top" |
'''Add to Cust EQ'''
| style="width: 7.2in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="691" valign="top" |
If this is checked, when this item is added to an order, the item will be automatically added to the customer equipment list. Check this for all major items.
|-
| style="width: 2.45in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="235" valign="top" |
'''Is Active'''
| style="width: 7.2in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="691" valign="top" |
Check if the item is active
|-
| style="width: 2.45in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="235" valign="top" |
'''Serialized'''
| style="width: 7.2in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="691" valign="top" |
Check here if this is a serialized part
|-
| style="width: 2.45in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="235" valign="top" |
'''Maintain Price Books'''
| style="width: 7.2in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="691" valign="top" |
<span class="apple-style-span"><span>When the cost/retail is changed in the price book (depending on settings), then all records with this flag checked will also be updated.</span></span>
|-
| style="width: 2.45in; border: medium none; padding: 0in 5.4pt" width="235" valign="top" |
'''Non-Inventory'''
| style="width: 7.2in; border: medium none; padding: 0in 5.4pt" width="691" valign="top" |
Check here if you don’t want to track inventory on this item. For example, with a bucket of screws you might not want to count every item in the bucket.
|}

'''Image below'''
The image below show how the Name and Description fields in SME Inventory Item sync to QuickBooks Inventory Item

[[File:InventoryItemFields_SyncToQB.png]]<br>

<h3>Ordering Information Tab</h3>
On the Ordering Information tab, you setup ordering information such as the vendor, minimum quantity on hand and the reorder amount.  Below is a description of all the fields on this tab.

[[File:OrderingInformationTab.jpg]]

'''Minimum On Hand''' – Enter the minimum quantity you want in stock in your warehouse.

'''Reorder Quantity''' – Set the quantity you want to reorder if you hit your minimum threshold.

'''Quantity Sold YTD''' – This is a calculated field that shows you how many you have sold year to date. The field is updated when the order containing the item is invoiced.

'''Count required to fill orders (JIT)''' –  The number of items tied to orders

'''Manufacturer''' – Enter the part manufacturer.

'''Vendor''' – Select your default vendor. When placing a PO for this item from an order, this vendor automatically populates the vendor field.

'''Lead Time (Days)''' - The typical time it takes the vendor to deliver the part. Used as a reference field.

'''Count Cycle''' – Select how often you want to count this inventory item (e.g. annually, quarterly, or monthly)

'''Unit Of Measure''' – Reference field for the items unit of measure (feet, lbs, etc).

'''Item Weight (lbs)''' – Enter the item weight as reference.

'''Last Sold Date''' – The last date the item was sold.

'''Last Order Date''' –The last date the item was placed on a Purchase Order.

'''Last Received Date''' – The last date the item was received into inventory on a Purchase Order.

'''Last Reconciliation Date''' – The last date the item quantities were reconciled using the Inventory Reconciliation utility.

<h3>Vendors Tab</h3>
On the Vendor tab, enter additional vendors that supply this part.

[[File:ItemVendor.jpg]]

{| class="MsoTableGrid" style="border-collapse: collapse; border: medium none" border="1"
| style="width: 74.25pt; border-width: 1pt medium; border-style: solid none; border-color: black -moz-use-text-color; padding: 0in 5.4pt" width="99" valign="top" |
'''Vendor'''
| style="width: 262.35pt; border-width: 1pt medium; border-style: solid none; border-color: black -moz-use-text-color; padding: 0in 5.4pt" width="350" valign="top" |
Select the vendor from the drop down list.
|-
| style="width: 74.25pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="99" valign="top" |
'''Vendor Zone'''
| style="width: 262.35pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="350" valign="top" |
Shows the zone assigned to the vendor.
|-
| style="width: 74.25pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="99" valign="top" |
'''Item name, Number and Description'''
| style="width: 262.35pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="350" valign="top" |
Populated from the inventory item
|-
| style="width: 74.25pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="99" valign="top" |
'''Manufacturer'''
| style="width: 262.35pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="350" valign="top" |
Enter the manufacturer of the item
|-
| style="width: 74.25pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="99" valign="top" |
'''Lead Time'''
| style="width: 262.35pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="350" valign="top" |
Enter the vendors lead time
|-
| style="width: 74.25pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="99" valign="top" |
'''System type & Man. Part Number'''
| style="width: 262.35pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="350" valign="top" |
Populated from the inventory items Defaults and Settings tab.
|-
| style="width: 74.25pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="99" valign="top" |
'''Vendor Part Number'''
| style="width: 262.35pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="350" valign="top" |
Enter your vendor’s part number
|-
| style="width: 74.25pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="99" valign="top" |
'''Item Cost, PO Item Cost and Retail Price'''
| style="width: 262.35pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="350" valign="top" |
Populated from the inventory item Defaults and Settings tab.
|}
<h3>Stock Tab</h3>
On the Stock tab, you will see a summary of stock for each warehouse location. You can see the stock quantity, the amount reserved, and the amount of stock available at each location. Although the inventory count information is shown on the main page of the inventory item, it is not directly editable as an item. Instead stock levels are controlled through adding of stock (typically only initially), purchase orders (PO's), and inventory reconciliation adjustments.

[[File:STockTab.jpg]]

<h4>Add Stock Item</h4>
Once you get started using SME, you will add stock to inventory through purchase orders. When getting started setting up your stock in SME, you may need to manually enter stock.

[[File:AddStockItem.jpg]]


'''*NOTE*''' If you are tracking inventory quantities in QuickBooks, any stock manually entered in SME using “Add Stock Items” will also need to be entered into QuickBooks.  Only invoices from SME automatically deplete inventory in QuickBooks. Only POs or Bills from SME automatically increase inventory in QuickBooks. Therefore, it is recommended for most stock transactions to go through purchase orders.


'''Adding Non-Serialized Stock'''

#       Select the inventory item you need to add stock for.
#       Select the Stock tab.
#       Click Add Stock Items.
#       In the top portion of the Inventory Stock Editor window, you can change the warehouse you are adding stock to.
#        Update the quantity in the Add Qty field.
#      Enter additional information such as condition, shelf and bin number.
#      Click OK and the stock is added to inventory. Notice the summary quantities at the top of the inventory item.

[[File:addingserialized.jpg]]

<h4>View Stock Details in Warehouses</h4>

To see stock details by warehouse location and change serial numbers, you can use the Inventory Stock Editor. 

#       On the '''Stock''' tab, select the warehouse location you want to edit.
#       Click '''Edit'''.
#       The material details for that stock warehouse location will open in the Inventory Stock Editor.
#       You can right click on a material detail item to edit the serial number.

[[File:ViewStockDetails.jpg]]


<h3>Material Details Tab</h3>
The Material Details tab provides details on all the material for this inventory item. For serialized items, the Material Details tab shows each stock item on a separate line. Notice the Quantity, Reserved, Available and Serial # columns. For non-serialized items each line is a stock lot, meaning something is different in each lot such as vendor or pricing.

[[File:MaterialDetails2.jpg]]

<h4>Move stock to another warhouse</h4>
This allows the movement of individual stock items. If items are moved to a warehouse, that warehouse will be created in Stock tab if it does not already show. 

<br>1.       On the '''Material Details''' tab, select the stock you need to move.
<br>2.       Click '''Move Stock'''.
<br>3.       In the Move Stock window, select the warehouse you are moving the item to in the Destination field. Enter Shelf and Bin if applicable.

<br>If you are moving non-serialized stock, you may be moving part of a stock lot. Enter the quantity from the lot you want to move in the '''Move Quantity''' field.

[[File:MoveStock.jpg]]

<br>4.       Click '''OK'''.
<br>5.       Notice the location change on the Material Details tab and the Stock tab.

<h4>View stock item transactions</h4>
To view the history of transactions for material:

<br>1.       Select the''' Material Details''' tab.
<br>2.       Right click on item.
<br>3.       Select '''View Item Transactions'''.
<br>4.       The transaction history will open in another window. (image on right)
<br>5.       Click '''OK'''. 

[[File:ItemTransactions.jpg]]

<h4>Export material details to Excel</h4>

1.       Select the Material Details tab.
2.       Right click in the grid and select Export to Excel (image on right).
3.       Select where you want to save the file and click Save

[[File:excelmaterialDetails.jpg]]

<h3>Kit Items</h3>
When you add material to an order, you may need to know what parts go with that material. You can add this related material on the Kit Items tab. When you are adding the material to an order, you can reference the kit items so you know what other material you may need to add to the order. 

'''Add kit items to an inventory item'''

#    Go to an inventory item in the Inventory module.
#    Select the '''Kit''' Items tab.
#    Click '''Add Kit''' Item.
#    Click '''Select Inventory''' and select the inventory item.
#    Click '''OK'''.

'''Referencing kit items in an order'''

#    Create a new order.
#    Click the '''Order Items''' tab.
#    Click '''New Materials'''.
#    Select the inventory item you created the kit for.
#    In the window that opens, select the '''Kit Items''' tab and you will see the material in the associated kit. 
#    Click '''OK'''.

[[File:ReferenceKitItems.png]]

<h3>Purchase History</h3>
The purchase history tab provides information about all purchase orders placed for the inventory item. Double click on a line in the grid, and SME will jump to the purchase order.

<h3>Syncing Inventory with QuickBooks (Link Options tab)</h3>
To read about syncing inventory between SME and QuickBooks, go to the [[Default Export to QuickBooks Settings]] page.

http://high5software.com/mediawiki/index.php?title=Default_Export_to_QuickBooks_Settings#Export_Options_for_Inventory_Items



== Inventory Pricing Options ==
There are several options for setting up pricing for inventory items. 
<br>1. Standard Retail Price 
<br>2. Price Book
<br>3. Pricing Levels

<h3>Standard Retail Price</h3>
The amount entered in the Retail field on an inventory item will be the standard price for the item when added to an order.
<br>[[File:StandardRetailPrice.png]]


<h3>Price Book</h3>
Price Books are used to assign customer specific pricing during order entry. You can assign a price book to a customer and all orders created for the customer will use the pricing rules assigned in the price books. An example of a price books is “30% higher than cost” or “10% less than retail”. You may also have a price book for customers that have special service pricing, different than your standard service prices.

<br>To learn about setting up price books and adding items to price books, go to''' [[Price Books]]'''
<br>[[File:InventoryItem_PriceBooksTab.png]]

<h3>Price Levels</h3>
You can also create pricing levels, either a perfect markup on the standard or a price you enter. When adding the material to an order, you can select what price level you want to use for that item (image below)
<br>[[File:AddItemToOrder_SelectPriceLevel.png]]
<br>To setup price levels:
<br>1. Go to your inventory items > Price Levels tab.
<br>2. Level 1 will be your standard retail price.
<br>3. for levels 2 - 5 you can either do a percent markup from retail (first image below) or enter in a specific amount (second image below).
<br>[[File:AssigingPriceLevels.png]]
<br>When adding the inventory item to an order, the price field will populate with the standard retail. Select a price level and the price field will be updated based on the price levels setup.

<br>For more information about adding material to orders, go to '''[[Add Items to Orders]]'''

<br>'''Markup Field'''
<br>The Markup field will take the cost from the Details and Settings tab and multiply it by the Markup field to update the Retail field.
<br>[[File:PricingLevelsTab_Markup%Field.png]]
<br>The way SME calculates the Markup:
<br>Cost * 1 + Markup = Price
<br>1.92 * 1.58 = 3.03

== Searching Inventory ==
Use the Search window to look up inventory items and export your inventory item list to Excel.

<br>1.    Select Inventory module.
<br>2.    Click Search and select Search Active Items.

[[File:SearchActiveInventoyrItems.jpg]]

<br>3.    Double click on the item in the list to go to the item.


<h3>Choose columns in Search Active Items</h3> 

<br>You can sort your items by every column you view in the Search Active Items window. You can also select which columns you are viewing in this window.  You might want to have the ability to sort your items by Item Number, System Type, minimum on hand, or Available.  To choose columns:

<br>1. In the Search Active Items window, click '''Views, Add Remove Fields'''.
<br>2. In the '''Grid Columns''' window that displays, check the item fields you want to view as columns. Uncheck the ones you don’t want to view. (image below)

[[File:GridColumns.png]]

<br>3. Click '''OK'''.
<br>4. Notice the columns you selected added.
<br>5. Click on any column header to sort the data.
<br>6. When you close the Search Active Items window, you will be prompted to save your new view. If you want to, click OK and type a name for the view. The view will be saved for you. 

'''**NOTE**''' When you save a new view, all SME users will have access to the view.


<h3>Select Saved View</h3>

<br>1. In the Inventory module, click Search, Search Active Items.
<br>2. In the Search Active Items window, click Views, Apply View and select the custom view. (image below)

[[File:ApplyView.png]]

<br>3.The grid will change to the custom view you created. 


<h3>Search For Field</h3>

This field allows you to type the name of the record you want to find instead of scrolling through your list. This can save you time if your list is long.

<br>1. Click the column header you want to search by.(1)
<br>2. Type the name you are searching for in the Search For field. (2) As you type, the row will be highlighted.
<br>3. Either double click on the record to open customer, or when the customer is highlighted hit enter on your keyboard.

[[File:SearchForO_Inventory.png]]


<h3>Grouping by Columns</h3> 

In the search window, you can group the data by a column. 

<br>1. Drag and drop column header into the gray header area above the columns.

[[File:DragToGroup.png]][[File:Grouped.png]]

<br>2. Notice the data grouped by the data in the column selected.
<br>3. Click the plus sign in each group to expand the group.  (image on right)
<br>4. Remove grouping by dragging the column header back in place.


<h3>Export Search View to Excel</h3> 

<br>1. In Search window, click Export and select '''Export to Excel'''.

[[File:ExportInventorySearch.png]]  [[File:InventorySearch_Excel.png]]

<br>2. In the window that opens, Click '''OK''' and Excel will launch with your inventory data.
<br>3. Use Excel tools to manipulate the data


<h3>Filtering Search</h3>

Apply filters to your search view to see only the data you want to see. 

#    Make sure the data you want to filter by is added as a column in your view.
#    Click the Filter icon [[File:FilterIcon.jpg]] at the bottom of the search window.
#    In the Filter Builder window, click '''press the button to add a new condition'''.
#    Click '''UID''' to select the field that contains the value you want to filter by. (1)
#    Click '''like''' to select the filter type.
#    Click '''<empty>''' and type the value you want to filter the search by. (2)
#    Click '''OK''' and your search view is filtered.

You can apply more than one filter to your search view by clicking '''press the button to add a new condition and setting the condition.'''


[[File:Filtering.jpg]]


<h3>Look up by Item Number</h3>

<br>1. Click '''Navigate'''.
<br>2. Select '''Go To'''.

[[File:Navigate.png]]

<br>3. In the '''Find Item Number''' window, type the item number you want to open and click '''OK'''.

== Manage Grid Columns on Tab ==
Throughout the many tabs in SME, you will find grids. You can rearrange the order of the columns in the grid, remove columns from the grid and add them back to the grid. 

<h3>Rearrange column order and width</h3>

You can move and change the width of the columns. To change the width, click your cursor in the column header between two columns and you will see the cross arrow. Drag your cursor to the desired column width. To change the order, click the column header and drag the column header to the desired column header location in the grid.

<h3>Remove columns</h3>

To remove a column, drag and drop the column above the grid as shown in the image below. 

[[File:Grids.png]]

<h3>Add columns that were previously removed</h3>

#    Right click on any material.
#    Select Add Columns to Grid.
#    In the Customization Window you will see all columns that were previously removed.
#    Drag and drop the column you want to add back to the grid as shown in the screenshot below.

[[File:AddColumnToGrid.png]]
@@ Line 1: / Line 1: @@
 In the Inventory section of the Inventory module you can setup and access all inventory items. View stock for the item, move stock between warehouses, view item purchase history, and setup ordering information for the item. You can also initiate a PO from the inventory item.
-== Inventory Management ==
-Managing inventory takes different levels of effort depending upon the amount of inventory control you want for your company.  SME does LOTS of automation to automatically handle many of the steps and business process, however if you want complex inventory control, it will require more effort from inventory personnel.  SME will handle any of the level of inventory control you want for your business.  You can also start with simple inventory control and get more elaborate as your business needs by adding warehouses and serialized inventory tracking.
-Here is a list of amount of inventory management required based upon how much inventory control you want from least amount of effort to most amount:
-# Don't track any stock and everything is just JIT.  This requires no additional effort or management, but also you would not know how much stock you have.
-# Normal inventory stock management with one warehouse.  This requires someone to track inventory allocations, manage PO's and make sure allocations are made if for example you added something that doesn't exist to an order now and then do an independent PO later.
-# Inventory stock with multiple warehouse.  Requires the above plus making sure inventory pulled and added to correct warehouse and requires transfers between warehouses.
-# Serialized inventory with multiple warehouses.  Requires serial number tracking from PO receipt all the way through system
-# Serialized, multiple warehouse, and strict inventory control.  Requires the most management.
 == Inventory Item Summary ==
@@ Line 25: / Line 15: @@
 '''Reserved''' - The number of parts applied to service orders, install orders, or itemized invoices.
-'''Unallocated''' - The number of parts that are available to allocate to an order (parts available to request to reserve on an order) (Unallocated = Available - Allocated)
+'''Unallocated''' - The number of parts that are available to allocate to an order (parts available to request to reserve on an order)
 '''Available''' - The number of parts in your warehouses that aren’t reserved. (on hand – reserved = available)
@@ Line 109: / Line 99: @@
 | style="width: 7.2in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="691" valign="top" |
 You can type the barcode number here
-|-
-| style="width: 2.45in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="235" valign="top" |
-'''Parent Item'''
-| style="width: 7.2in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="691" valign="top" |
-To create a hierarchy of inventory items, you can select another item as the parent item. You can then search your items by parent.
 |-
 | style="width: 2.45in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="235" valign="top" |
@@ Line 159: / Line 144: @@
 | style="width: 7.2in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="691" valign="top" |
 Check if the item is active
-|-
-| style="width: 2.45in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="235" valign="top" |
-'''Pre-approve Purchase Orders'''
-| style="width: 7.2in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="691" valign="top" |
-If this is checked, SME will not require approval when placing the item on a purchase order.
 |-
 | style="width: 2.45in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="235" valign="top" |
@@ Line 175: / Line 155: @@
 <span class="apple-style-span"><span>When the cost/retail is changed in the price book (depending on settings), then all records with this flag checked will also be updated.</span></span>
 |-
-| style="width: 2.45in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="235" valign="top" |
-'''Force JIT'''
-| style="width: 7.2in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="691" valign="top" |
-<span class="apple-style-span"><span>If you check this and this item is added to a service order, install order, or itemized invoice, SME will not try to allocate stock. The item will go to "has ordered items" automatically, even if there is stock available.</span></span>
-|-
-| style="width: 2.45in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="235" valign="top" |
-'''Don't update cost when receiving from PO'''
-| style="width: 7.2in; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="691" valign="top" |
-<span class="apple-style-span"><span>If this is checked, when you add the item to a PO and change the cost of the item on the PO, the cost of the inventory item won't change.</span></span>
-|-
 | style="width: 2.45in; border: medium none; padding: 0in 5.4pt" width="235" valign="top" |
 '''Non-Inventory'''
@@ Line 192: / Line 160: @@
 Check here if you don’t want to track inventory on this item. For example, with a bucket of screws you might not want to count every item in the bucket.
 |}
 '''Image below'''
@@ Line 277: / Line 244: @@
 | style="width: 262.35pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="350" valign="top" |
 Populated from the inventory item Defaults and Settings tab.
-|-
-| style="width: 74.25pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="99" valign="top" |
-'''Landed'''
-| style="width: 262.35pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0in 5.4pt" width="350" valign="top" |
-Check [[Landed]] if you are including the shipping cost in the PO Item cost. This is a reference field only.
 |}
 <h3>Stock Tab</h3>
@@ Line 309: / Line 269: @@
 #      Click OK and the stock is added to inventory. Notice the summary quantities at the top of the inventory item.
-'''Adding Serialized Stock'''
-#       Select the inventory item you need to add stock for.
-#       Select the Stock tab.
-#       Click Add Stock Items.
-#       Enter Serial Number
-#       Click '''Add''' for Single Serial entry or click '''Add Range''' for Range
 [[File:addingserialized.jpg]]
 <h4>View Stock Details in Warehouses</h4>
@@ Line 398: / Line 350: @@
 http://high5software.com/mediawiki/index.php?title=Default_Export_to_QuickBooks_Settings#Export_Options_for_Inventory_Items
 == Inventory Pricing Options ==
@@ Line 555: / Line 509: @@
 [[File:AddColumnToGrid.png]]
-== SnapShot tab ==
-<br>[[File:InventoryItem_SnapShotTab.png]]
-<br> The SnapShot tab in an inventory item summarizes the following information for that item when the snapshot is taken:
-<br>[[File:SnapShotGridDefinitions.png]]
-<br>
-<br>To setup how frequently SME takes a snapshot of your inventory items, go To Setup module > Company > Inventory. Click '''[[Company]]''' and go to the Inventory section to learn more.