IT Asset Management Suite IT Asset Management Blog Tracking Inventory Stock In Assetsonar 6ffb2735b977

[How-to] Track 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 ย Company Settings & Add Ons โ†’ Inventory Module โ†’ Enabled.

1. Adding Inventory Items

Before you can start tracking inventory, you first need to add your inventory items to AssetSonar. 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, Asset 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), create inventory with initial stock (Initial Stock Quantity), choose quantity for reorder (Reorder Quantity) 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 events. These can also trigger alerts at the dates specified.

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 Files Tab โ†’ Click โ€˜Attach Fileโ€™.

1.1. 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 functionality to work, you must enable โ€˜Barcode Readerโ€™ beforehand from Company Settings & Add Ons โ†’ Go to Integrations Tab โ†’ Handheld Scanner Integration.

1.2. Adding Items via an Excel Import

You can add multipleย inventory itemsย into AssetSonar using an excel sheet, fromย Items โ†’ Inventory โ†’ Add Inventory โ†’ Import From Sheet โ†’ Create Inventory.


2. 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. Users can also 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 adding or removing stock.

2.1. 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 โ†’ Moreโ†’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 โ†’ Actions โ†’ Print Label. The number of copies you will choose in this case will impact all the items separately, e.g. 4 copiesโ€Šโ€”โ€Š 4 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 โ†’ Add Print Label Template.

It will take you to a new overlay where you can add a new print label template.

2.2. 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.


3. Managing Stock Locations

Location managementย is found deep in the AssetSonar inventory control software. You can use the software to create multiple locations and sub-locations. For example, a location in 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.

3.1. 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 stock. For example, if you add stock to your inventory item, the field location will be automatically populated with your default location and the 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.

3.2. 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.

Stock Locations 1

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.


4. Actions on Inventory

4.1. 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 needed. 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ย Company Settings & Add Ons โ†’ Inventory module โ†’ Check โ€˜Allow staff users to add stock.โ€™

4.2. Request Stock

An Admin can give staff users the option to โ€˜Request Stockโ€™, fromย Company Settings & Add Ons โ†’ Purchase Orders โ†’ Check โ€˜Allow staff users to create purchase order requests for Administrators to review and replenish stockโ€™.

To request stock go to Inventory ย โ†’ Select Itemย  โ†’ More, which will take you to the overlay shown in the image below, from where you can click on โ€˜Request 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 Requests.

4.3. 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 โ†’ More โ†’ Remove Stock.

The following overlay will appear and require you to specify the location from which you are removing the stock and other details.

Once you have added the relevant details, click on the โ€˜Process Orderโ€™ button to continue.

4.4. 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ย Company Settings & Add Ons โ†’ Transfer of Inventory โ†’ Enabled.

Then go to theย Items โ†’ Inventory โ†’ Select Inventory Item โ†’ Transfer Stock.

A selection overlay (displayed below) will allow you to choose the transfer source and destination locations, along with the stock quantity, price, and additional details.

After you add the relevant details, click on the โ€˜Transferโ€™ button to continue.

4.5. Reserve Stock

You canย reserve stockย for consumption at a later date fromย Items โ†’ Inventory โ†’ Select Inventory Item โ†’ Reserve.

An overlay will appear where you can set the date, quantity, price, location and more. 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ย Company Settings & Add Ons โ†’ Reservations โ†’ For Inventory โ†’ Check โ€˜Enforce Conflict-Free Reservation for Inventoryโ€™.

4.6. 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 โ†’ Update Existing Inventory.

You can then upload an Excel sheet with details of the new stock, and the locations to which it will be added.

Adding Stock to Multiple Inventory Items 1

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.

Adding Stock to Multiple Inventory Items 2

Frequently asked questions

How do I know when my stock is running low at a location?

You can set a low quantity threshold by going to Items โ†’ Inventory โ†’ Select an Item โ†’ Edit โ†’ Scroll down to Location Specific Thresholds.

An Email alert will be sent out to you if an inventory item reaches the predefined lower threshold. The threshold can either be customized for multiple locations or it can be set to default.

Is there a way I can checkout multiple inventory items together?

Multiple inventory items can be checked out in a single click. Go to Items โ†’ Inventory โ†’ Select Multiple Items โ†’ Go to Actions โ†’ Add to Cart โ†’ Check out.

Was this helpful?

Thanks for your feedback!
Picture of Ramiah Adeen
Ramiah Adeen
Senior Product Marketer | Content Strategist
rum-ee-ah ยท She/Her ยท Fort Collins, CO
Ramiah Adeen is a Product Marketer and a Content Strategist at EZO, a modern asset management solution for leading Fortune 500 enterprises. Sheโ€™s also a guest blogger who is passionate about emerging trends in the ITAM space and everything marketing. When she’s not writing, you can find her working on her non-profit, brewing a cup of chai, or trying new rhythms on her ukulele.

Powerful IT Asset Management Tool - at your fingertips

Empower your teams, streamline IT operations, and consolidate all your IT asset management needs through one platform.
Index