How to View Transactions Query in SwilERP Software

Transactions Query

How to View Transactions Query in SwilERP Software


SwilERP Software provides users with the ability to view transaction queries using parameters. This report allows users to view two types of details in the same report: transaction details and product details. The transaction details provide information such as the transaction date, invoice number, transaction name, and total amount, while the product details provide information such as the product code, product name, quantity, price, lot number, and total amount.

Start with login in SwilERP dashboard to initiate the process

  1. Go to the View Menu> Transaction Query.
Reference image:
SwilERP Dashboard Window

How to view Transaction Query

  1. Select the the Date Range "From to To" in which you want to view the transaction details.
  2. Here you can select Lot & Tax to view details accordingly.
  3. Tick mark on the Virtual Product & Only Draft to consider it in report.
  4. Invoice Range, Date modified, Qty, Unit, and Free Qty options are available to view details accordingly.
  5. If you want to view query of particular Product, Transaction, Series, Color, and Users select it from the given options.
  6. Click on the View button.
Reference image:
Transaction Detail Window

How to view Product Detail

  1. If you want to view product details by selecting same parameters as above.
  2. Then, click on the Product Detail tab.
  3. Users can also change the Parameters to view product details.
Reference image:
Product Detail Window

      • Related Articles

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

      • GST Query

        How to View GST Query in SwilERP Software What is 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 features an ...

      • Inquire Transactions Details

        How to Inquire Transaction in SwilERP Software What is Inquire Transaction? The INQUIRE TRANSACTION command retrieves information about a particular transaction of SwilERP. The inquire transaction lets you view the details according to the selected ...

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

      • Reposting of Transactions Data

        How to do Reposting of Transaction Data in SwilERP (RetailGraph) What is Reposting? Reposting is used to re-post or reconcile transaction data from the SwilERP software. Selecting the date range allows you to easily reconcile transactions of a ...