How to view company specific product queries in SwilERP Pharmacy

Company Wise Products Query

How To View Company Wise Products Query in SwilERP


A Product Query provides details about the product's company nameA query is a request for data or information from a database table or combination of tables, if a user wants to view company-wise details that they can do it from this option in the queries section.
Here is an option to view products' name company-wise in SwilERP, with this information you can easily categorize every product's detail. The user can also view the marketing group, lot number, MRP, batch number, current stock, and stock location.

Start with Login in SwilERP dashboard to initiate the process

  1. Go to the Queries section in SwilERP dashboard.
  2. Click on the Company Wise Product.
Reference image:
Company Wise Product Query SwilERP Dashboard Window

 To view all products' company details

  1. Go to the Home Tab.
  2. If you also want to view Nil stock then, tick mark on the Show Nil Stock Lots.
  3. Click on the View tab.
  4. There you'll see every Company's name along with their products' name and other details.
Reference image:
Products company details Company Details Window

  To view Lot Number wise Details

  1. Open Company wise product window.
  2. Select the Lot Number from the drop down list.
  3. If you want to view Manufacturer, Batch number, MRP , wise details then select these options.
  4. Users can also Filter the Products with the given option.
  5. Click on the View tab.
Reference image:
Lot Number wise Details Lot Wise Product Detail
  1. Go to the Display option.
  2. Click on the Print and Preview option to print your query details.
Reference image:
Print and Preview Print & Preview Tab

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.
Reference image:
Convert your details File Export Window

      • Related Articles

      • 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 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 ...
      • 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 ...
      • 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 Doctor Query

        How to view Doctor Query in SwilERP  What is Doctor Query? Doctors' query provided the data of Refer by wise transactions. In this section, you can view the selected doctor and transaction-wise details. For example, if you choose the Refer by Dr ...