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 ...
      • 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 ...
      • Sales Transaction Report

        How to View Sales Transaction Report in SwilERP In this article, we'll discuss regarding sales transaction report. In this, users can view every transaction report related to the sales. The Sales Transaction report in SwilERP enables comprehensive ...
      • Analysis of Sales Transaction

        How to Do Sales Analysis in SwilERP Enterprise This report provides a comprehensive overview of sales transactions, categorizing them by customer bills. You have the flexibility to adjust details for better comprehension, such as utilizing pivot ...
      • Create Transaction Series

        Steps to Create a New Transaction Series in SwilERP A transaction series helps you to maintain your every transaction. When users want to create transaction series in SwilERP, they can create it from the Masters menu. In SwilERP, there is an option ...