Tracking Inventory Stock in AssetSonar

You can easily track and manage inventory using AssetSonar. There are three types of items you can add here: assets, asset stock, and inventory. Inventory items are consumable items that are not returned once they are checked out. For this reason, only the stock level or quantity of each inventory item is tracked. To track inventory items with our IT asset management software, go to Settings → Add Ons → Inventory Module → Enabled.

Adding Inventory Items

Before you can start tracking inventory, you first need to add your inventory items into the software. To add an inventory item, go to Items → Inventory → Add Inventory. This button is also available on the dashboard. Here you can record all the details that are specific to the inventory item including item Name, Identification Number, Group, Product Model Number, and so on.

You can also record vendor details (Vendor), purchase price per unit (Price For Add Stock), price per unit for removal (Price for Remove Stock), location (Default Location), and set minimum stock quantities (Low Stock Thresholds and Location Threshold).

To record additional details like serial number and expiration date you can create Custom Fields. These fields can be made mandatory at create/edit event. These can also trigger alerts at the dates specified. Custom Fields can be created from More → Custom fields → Add Custom Field.

To learn more about Custom Fields

Additionally, you can associate documents and images with inventory items and add comments. To associate documents with inventory items, go to Items→ Inventory → Select an Item → Scroll down to the Documents and Images Tab → Click ‘Attach Documents’.

Adding Items via Scanning

AssetSonar allows you to print new barcodes for your inventory items. In case your items already have barcodes printed on them you can scan them to add new inventory items. To do this, go to Items → Inventory → Add Inventory via Scanning. For this to work, you must enable ‘Barcode Reader’ under Settings → Add Ons → Handheld Scanner Integration.

Adding Items via an Excel Import

You can add multiple inventory items into AssetSonar using an excel sheet, from Items → Inventory → Import From Excel Sheet → Add New Inventory.

Printing Labels for Inventory Items

An important aspect of inventory control is labeling inventory items. AssetSonar allows users to generate new labels for their inventory items as well as use the existing barcodes on their inventory items. Inventory items have one unique label that is pasted on all your stock items. This barcode or QR Code label can be scanned to bring up the inventory item and take actions like add or remove stock.

Printing New Labels

Before you can print barcodes you must specify an ‘Identification Number’ for your items. This number is used to uniquely identify items and is used as their barcode number. In case of QR Codes, you do not need to enter an identification number for your inventory items.

To print labels, go to Items → Inventory → Select Inventory Item → Print Label → Specify the number of copies you want to print.

You can also print labels for multiple inventory items from Items → Inventory → Check Inventory Items → Click ‘Actions’ → Print Label. The number of copies you will choose in this case will impact all the items separately, e.g. 20 copies — 20 labels will be printed for each selected item.

Note: In order to print barcodes you will first need to create a custom print label template from More → Printout Templates → Label → Click ‘Add Print Label Template’.

Using Existing Barcode Labels

If you already have barcode labels printed, you can simply enter their barcode numbers in the ‘Identification Number’ field from Items → Inventory → Select Inventory Item → Edit.

Once the barcode number is recorded, the software will recognize the barcodes upon scanning, allowing you to easily scan and take actions on items. An easy way to add the identification number is through scanning. To do this simply configure your external barcode scanner and scan your barcode number into the ‘Identification Number’ field.

Managing Stock Locations

Location management is pretty deep in our inventory control software. You can use the software to create multiple locations and sub-locations. For example, a location New York may have a sub-location Warehouse_1 and that in turn may have sub-locations like Section_A, Shelf_001. This type of location tagging makes it quick and easy to locate items. Each inventory item only has one Default Location but can have multiple Stock Locations.

Default Location

This is the location at which your initial stock quantity is added at the time of creating an inventory item from Items → Inventory → Add Inventory. This location is also used as the default location when taking actions like add, remove, reserve or transfer or stock. For example, if you add stock to your inventory item, the field location will be automatically populated with your default location and stock will be added to that location. You can easily change this location. The default location is also the location that is used when you add inventory items to a cart.

Stock Locations

Different quantities of an inventory item may be spread out across locations, for example, Warehouse_01 may have 200 boxes of ‘Disposable Plastic Cups’ and Warehouse_02 may have 100 boxes. In such cases, tracking inventory by its specific location is important. You can check the total quantity available of an item at different locations from Items → Inventory → Select Inventory Item → Quantity by location.

You can also change the way assets are listed on the asset detail page by using the ‘Location Stock View’ button on the top left. This will show stock quantities by location instead of showing one total quantity per item.

Actions on Inventory

Add Stock

Administrators can add inventory stock using the action buttons on the right of the inventory detail page. To add stock, go to Items → Inventory → Select Inventory Item → Add Stock. This will open an overlay that will prompt you to add the quantity, per unit price, location for stock to be added to, vendor name, and the name of the member who has made the order request.

The ‘Price/ unit’ is automatically populated by the value specified in the ‘Price for Add Stock’ field on the inventory details page. You can change this value if you need to. You can also add the ‘Total Price’ of the quantity ordered and the system will automatically calculate and change the ‘Price / unit’.

Staff users can also be allowed to Add Stock to Inventory from Settings → Add Ons → Inventory module → Check ‘Allow staff users to add stock.’

Request Stock

An Admin can give staff users the option to ‘Request Stock’, from Settings → Add Ons → Purchase Orders → Check ‘Allow staff users to create purchase order requests for Administrators to review and replenish stock’. When creating a stock request, staff users can identify a delivery location. They can also add the request to an active purchase order or create a new one by hitting ‘Send Request’. An administrator can then approve/deny these requests from the Notification Bell → Purchase Orders.

Remove Stock

Stock can be removed whenever it’s checked out or sold. Remember that inventory is never checked back in. To remove stock from an inventory item, go to Items → Inventory → Select Inventory Item → Remove Stock. The following overlay will appear and require you to specify the location from which you are removing the stock and other details.

Transfer Stock

In addition to removing stock from inventory, members can also transfer stock. This comes in handy when moving stock from one warehouse to another or simply changing the location of stock within a warehouse. To transfer inventory stock between locations, go to Settings → Add Ons → Transfer of Inventory → Enabled. Then go to the Items → Inventory → Select Inventory Item → Transfer Stock.

Reserve Stock

You can reserve stock for consumption at a later date from Items → Inventory → Select Inventory Item → Reserve Stock. Use this to ensure that the required stock quantity is available at a specific time. You can also ensure that reservations on inventory items do not conflict with each other from Settings → Company Settings → Reservations → For Inventory → Check ‘Enforce Conflict-Free Reservation for Inventory’.

To learn more about reservations, click here.

Adding Stock to Multiple Inventory Items

You can add stock for multiple inventory items at the same time through an Excel import. To do this, go to Items → Inventory → Import From Excel Sheet → Add Stock to Existing Inventory. You can then upload an Excel sheet with details of the new stock, and the locations to which it will be added.

You will then be asked to map your columns to fields in AssetSonar. If everything looks good, you can go ahead and click Import. This will allow you to add stock to multiple locations instantly.