Inventory Enquiry

Understanding Inventory Enquiry

What is Inventory Enquiry?

The Inventory Enquiry screen provides real-time visibility into inventory levels and distribution across your warehouse. It enables users to:

• Locate specific items

• Review stock availability and status

• Examine inventory across different locations

You can access Inventory Enquiry via:

• Navigation Menu > Inventory > Inventory Enquiry

• Or use the search bar and type “Inventory Enquiry”

Tabs in Inventory Enquiry

1. Inventory Tab

Displays location-specific inventory records, showing item availability at a granular level. 

2. Summary Tab

Provides a high-level overview of item-specific inventory across all locations.

Some of the key details found within each screen include:

• Item Code
• Batch number
• Item Description
• Location Code
• On Hand Quantity
• Allocated Quantity
• Expiry Date
• Status

Accessing Inventory Enquiry

Within the Navigation menu, click on the search bar, type and click "Inventory Enquiry". Inventory Enquiry is also in Inventory > Inventory Enquiry.

Finding General Information on Inventory

The searchable fields within Inventory Enquiry are as follows:

• Searchable fields (Inventory Tab):

  • Item Code

  • Company Code

  • Location Code

  • Warehouse Code

  • License Plate Number

  • Item Description

  • Item Reference

  • Batch Number

  • Item Group

  • Inventory Status

• 
  

To view additional columns, use the horizontal scroll bar to navigate through the available headers. Below is a list of column headers you can scroll through to access the full set of information. Columns can be dragged and fixed into place. Please find a list of columns below:

• Item Code
• Description
• Location Code
• Warehouse Code
• With User
• On Hand Quantity
• Batch Number
• Expiry
• License Plate No
• In Transit Quantity
• Suspended Quantity
• Allocated Quantity
• On Hand Units
• In Transit Units
• Allocated Units
• Suspended Units
• Company Code
• UoM with Factor
• Inventory Status
• Created At
• Updated At
• Last Cycle Count Date
• Location Type

If you want to go back and input more information, click on the search icon and enter whatever data you need to refine your search.

Finding Inventory Summary

Searchable fields (Summary Tab):

• Item Code

• Company ID

• Location Code

• Warehouse Code or ID

• License Plate Number

The information found on Inventory Summary is as follows:

•  Item Code
• Description
• On Hand Quantity
• In Transit Quantity
• Allocated Quantity
• Unit of Measure
• Inventory Status
• Free Stock
• Unallocated Quantity

If you want to go back and input more information, click on the search icon and enter the data you need to refine your search.

How to complete a Bulk Inventory Adjustment

Within the Inventory tab in inventory enquiry, click on the red action button, then click "Bulk Inventory Adjustment".

Complete required fields

To adjust inventory in bulk:

1. Go to the Inventory tab.

2. Click the red action button → select "Bulk Inventory Adjustment".

3. Download the CSV template provided.

4. Fill in the required fields in your CSV using the same header structure.

5. Upload your completed file:

   • Choose File

   • Select Warehouse

   • Select Company

   • Click Import

If you experience issues, contact Support@Canary7.com via email.

Quantity Definitions