SwilERP - How To View Retail Stock Query

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 If you talk about a retail business, you mean  a business that sells goods directly to the public.  A retail stock query provides you with all the related data of stock. 

In SwilERP there is an option to view  related details of Retail Stock Query. Users can view Products' Lot Number wise details along with their MRP, Batch Number, Expiry Date, Current Stock, Stock Location, etc.  If required, then users can also view more information by using Grid Layout Option.

These are the step-by-step instructions to view Retail Stock Query
  1. Go to the Queries section in SwilERP dashboard:

    1. Click on the Retail Stock Query
 Retail Stock Query

 To view the Stock of all Products

  1. In the next slide Retail Stock Query will Appear:
    1. Go to the Home section. 
    2. Tick mark on Show Nil stock Lots to also view nil stock. 
    3. If you want to view every product detail then, click on the View tab.  
Stock of all Products

 To view Lot Number wise Stock Details

  1. Go to the Retail Stock Query window: 
    1. Select the Lot number for which you want to view stock details.  
    2. Select Vendor name to view vendor-wise detail. 
    3. To view MRP  wise detail enter the Amount in a dialog box.
    4. Select and Filter the Products from the given option .
    5. Click on the View Tab .  
( Note: If you want to view a particularly detail-wise query, then select it from the given columns)
Lot Wise Detail Window
    1. Go to the Display option.
    2. Click on the Print and Preview option to print your query details.
Display option

  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


Note: You can view the details at your convenience by selecting the options in which you want details. 


      • Related Articles

      • 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 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 ...
      • MIS Report View

        How to view MIS Report Through SwilERP (RetailGraph) What is MIS View Report? MIS report stands for management information system. In the simplest terms, an MIS report does describe as a system that provides essential information for the management ...
      • 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, ...
      • GST Query

        How to view GST Query in SwilERP (RetailGraph) What is a GST Query? A GST Query Data is an option in SwilERP; if users want to view their GST Sales and Purchase transaction data in a report, they can view it from the GST section. SwilERP also ...