Here is a guide to viewing stock queries in SwilERP

View Stock Query

How to view Stock Query in SwilERP

What is a Stock Query? 

The Stock Query report provides complete information about a particular stock item. The details include Alias, Lot Number, MRP, Batch Number, Expiry Date, Current Stock, Stock Location and so on. 

SwilERP featured an option of Stock Query in which you'll see the details of Products' Stock. In this option, users can select these following details to view the details in selected items. By selecting one option from these, you can view particular detail for the same. 
  1. Barcode 
  2. Lot Number
  3. Manufacturer 
  4. Color
  5. Batch
  6. MRP 


Do follow these step-by-step instructions to view the details 
  1. From the SwilERP dashboard:

    1. Go to Queries> Stock Query.
SwilERP Dashboard Window
  1. On the next page, you'll see the Stock Query window:

    1. Go to the Home Tab.
    2. If users want to view all the Products Stock including Nil stock lots. 
    3. Then tick mark on the Show Nil Stock Lots
    4. Select all the Products from the given option. 
    5. Click on the View option. 
Note: You don't need to select other options to view all the Products' detail. 
Home Window
  1. To view the stock details Lot Number wise:

    1. Select the Lot Number from the below-given list. 
    2. If users want to view Vendor wise stock details then, select the Manufacturer's name. 
    3. Users can also choose Batch number and MRP if required.  
    4. Tap on the View option. 
    5. For Example, you've chosen Lot number 10000001 and then, all the lot number-wise details will show on the screen. 
stock details Lot Number wiseLot Number Wise Tab
    1. Go to the Display option. 
    2. Click on the Print and Preview option to print your query details. 
Display optionDisplay Window
  1. Convert your details into different Formats:

    1. Go to the Display option.
    2. Click on the 'T' point and there you'll see the options of different formats.
    3. Select the Option in which you want to convert your details. 
Convert your details into different FormatsDisplay Window



      • Related Articles

      • View Retail Stock Query

        How to view retail stock query in SwilERP What is the meaning of retail? The Retail Stock Query report provides complete information about a particular stock item. Retail refers to the activity of selling products directly to customers or end-users ...
      • View Rate and Stock Query

        How to view rate and stock query in SwilERP  What is Rate and Stock Query?  The Rate and Stock Query report provides complete information about a particular stock item. The details include Rate detail and Lot details in which products' stock, MRP, ...
      • Retail Product Query

        How to View Retail Product Query in SwilERP What is a retail product? A Retail Product means, when a business sells a product or service to an individual consumer for their use. With SwilERP, users can view particular products' sales and purchase ...
      • View Patient/Customer Query

        How to view Patient/Customer Query in SwilERP What is a Patient/Customer Query? The patient query is also called a customer query because it provides details of customer-wise transactions. You can view particularly selected account details by ...
      • View Supplier Query

        How to View Supplier Query in SwilERP Meaning of supplier query The supplier query file contains listings of suppliers available on SwilERP. This query allows you to search by multiple criteria such as supplier name, vendor number, and diversity ...