Company Wise Products Query
How To View Company Wise Products Query in SwilERP
Overview
A Product Query provides details about the
product's company name. A 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
-
Go to the Queries
section in SwilERP dashboard.
-
Click on the Company Wise Product.
Reference image:
SwilERP Dashboard Window
To view all products' company details
-
Go to the
Home
Tab.
-
If you also want to view
Nil
stock then, tick mark on the
Show Nil Stock Lots.
-
Click on the
View
tab.
-
There you'll see every
Company's name
along with their
products' name
and other details.
Reference image:
Company Details Window
To view Lot Number wise Details
-
Open
Company wise product
window.
-
Select the
Lot Number
from the drop down list.
-
If you want to view
Manufacturer, Batch number, MRP
, wise details then select these options.
-
Users can also
Filter
the Products with the given option.
-
Click on the
View
tab.
Reference image:
Lot Wise Product Detail
Print
and
Preview
your details from the given options
-
Go to the
Display
option.
-
Click on the
Print
and
Preview
option to print your query details.
Reference image:
Print & Preview Tab
-
Go to the
Display
option.
-
Click on the
'T'
point and there you'll see the options of different formats.
-
Select the
Option
in which you want to convert your details.
Reference image:
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 ...