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 information. This Query helps find supplier details with specific columns like vendor name, alias, address, station, state, pincode, phone, mobile, e-mail, etc.
In SwilERP Supplier Query is an option to view Vendors' every detail in one window. In this option, users can view the Vendor Detail, Transactions Detail, Product Detail, and Ledger Detail of the supplier by selecting a vendors' name only.
Do follow these instructions to view the Supplier details
Open the SwilERP dashboard in Queries Section:
Go to Queries> Supplier Query.
SwilERP Dashboard Window
Go to the Supplier Query window to view vendor detail:
Go to the Home Tab.
Enter the Date Range 'From' to 'To'.
Select the Vendor name from the given list.
And, click on the View Tab.
In the first column, you'll see the Vendors' Detail i.e Vendor name, Alias, Address, Station, State, etc.
Vendor Detail Window
To view details of Vendors' transaction detail:
Click on the Transaction Detail Tab.
There you'll view the Transactions invoice, Frequency, Amount, and Tax Amt.
Transaction Detail Window
To view details of Vendors' Product detail:
Click on the Product Detail Tab.
There you'll see the Products' name, Invoice qty, Invoice amount, Return qty, etc.
Product Detail Window
To view details of Vendors' Ledger detail:
Click on the Ledger Detail Tab.
In this window, you'll see the Ledgers' Debit and Credit entries and As on Date Balance.
Ledger Detail Window
There is an also option to view Ledger Account and outstanding Amount:
If a user wants to view Vendors' Ledger Account then click on the given option, and they will see the same vendors' ledger account in the next pop-up window.
To view, the Outstanding amount click on the Given tab.
How to Analyze Supplier Ledger Report in SwilERP Supplier Ledger Analysis report. The Supplier Ledgers consist of all transactions relating to each Supplier. The open entries for each Supplier will show the invoices that have yet to be paid or ...
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 ...
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 ...
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 ...
How to Create Scheme (Supplier) in SwilERP In SwilERP, there is an option to create a scheme for suppliers it is a fixed promotion that is created by a buyer for the vendor. When buyers will buy a product in fixed quantity and then they will get free ...