How to view retail product queries in SwilERP

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 details any many other details related to the stock. But you need to select product first and after that products' detail will show according to this.  

In the Queries section, users can view their Products ' Stock detail by selecting a product name. With this option, you can view the "Opening Stock, Received Stock, Issued Stock, Current Stock, Stock Location, and Lot Number". And also they can check the details of stock Received (In) or Issued (Out) in the same window.

Users can easily manage their  Inventories data of every Product .

These are step-by-step instructions to view the Queries
  1. From the Dashboard in Queries section:
    1. Go to Queries> Retail Product Query.

Retail Product Query SwilERP Dashboard Window
  1. In the Retail Product Query window: 

    1. Go to the Home Tab.
    2. Enter the Date Range from where you want to view the details. 
    3. Select the Product name whose you want to view stock details. 
    4. Select the Bar Code of Product if you want to view a particular bar code-wise detail.
    5. After that, select Stock Locations
    6. Click on the View tab. 
Home Tab Home Window
  1. There is an option to Recalculate the Product balance :

    1. Users have to click on the option that is given on top of the right side. 
    2. And, you'll be notified that the balance has been recalculated automatically. 
Recalculate the Product balance Recalculate balance Tab
  1. To view Received and Issued data in same window:

In retail product query detail, users view the products' purchased and sales entries by double-clicking on the Received and Issued dialog box. You can see all the product details over there, i.e. invoice date, entry no, ref. no, qty, customer/vendor name, rate, and MRP and view the invoice by clicking on a particular invoice. 
Received And Issued Window
  1. Then, a pop-up window of product Received or Issued will appear in front of you.
  2.  It indicates how much stock is purchased (In) or sold (out).  
  Note : Product  Issued window will show as same as product received window show. 
Product Received Window
    1. Go to the Display option.
    2. Click on the Print and Preview Option to print the Details. 
Display option Display Window
  1. To convert your product details into excel format:
    1. Go to the Display tab.
    2. Then, click on the 'T' point and   select the option in which you want to convert details. 
convert your product details into excel format Display 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 ...
      • 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 ...
      • 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 ...
      • Product Query

        Product Query In RetailGraph,there are many useful tools which are very helpful in many contexts.In this article,we will take a look at one of those which is called Product Query.This option can be found in View module in RetailGraph. In Product ...