How to Check Stock in Product Query

How to Check Stock in Product Query


How to Generate & Check Product Query

In this article, we have explained you how to generate & check Product Query in Unisolve. Product Query is very powerful report, when you check product query report then you can check Sales, Purchase, Sales/Purchase Return, Shortage/Surplus & many more other transaction of single product in single screen.

To Check Product Query, Please select Product Query in Query Menu. Image as per below:


After open product query, please enter From & Upto Date & after that enter Product Name for which you want to see details. Product query shows batch wise Sales/Purchase Details & Print option also available in this report. We have explained you as per following:

  1. Date From & Upto: You can enter Date Range from & Upto in this field. Please select Date Range from & upto Date which you want to check detail of particular product.
  2. Product: You can select Product Name which you want to check.
  3. Batch No. Details: If you want to check all batch stock please press enter key in batch no. detail and if you want to check only one batch detail then please select batch number and press enter key.
  4. Opening: If you want to check all batches opening stock please press enter key opening menu and if you want to check only one batch opening stock please select batch number and press enter key on opening menu.
  5. Receipts: If you want to check all batches purchase stock please press enter key receipts menu and if you want to check only one batch purchase stock please select batch number and press enter key on Receipt menu. Image as per below:


  1. Issue: If you want to check all batches sale stock please press enter key Issue menu  and if you want to check only one batch sale stock please select batch number and press enter key on Issue menu. Image as per below:


  1. Print [80]: If you want to print all detail please select Print [80] option. When you click on Print option then software shows Print Parameter window. Image as per below:


Print: In this caption Software provide 2 options.

  1. Summary: if you want to print only product summary please select summary option. 
  2. Detail: If you want to print product all detail then please detail option.


Select Transaction Type: click selection transaction type option then show all transaction voucher type.

a. Print party Name: If you want to print Party Name then select “Print Party Name” option.

b. Print Station Column: If you want to Print Station Column then select "Print Station Column" option.

c. Print Only Total Column: If you want to Print Only Total Column then select "Print Only Total Column" option.

d. Print Discount Column: If you want to Print Discount Column then select "Print Discount Column" option.

e. Print Rate Column: If you want to Print Rate Column then select "Print Rate Column" option.

f. Print Amount Column: If you want to Print Amount Column then select "Print Amount Column" option.

g. Print Total Issue/Rcpt. Before 01/04/18 Column: If you want to Print Total Issue/Rcpt. Before 01/04/18 Column then select "Print Total Issue/Rcpt. Before 01/04/18 Column" option.

h. Only For Discount Or Scheme: If you want to Print only for discount or scheme then select "Only For Discount Or Scheme" option.

i. Print Challan\Purchase Bill No.: If you want to Print challan & purchase bill number then select "Print Challan\Purchase Bill No." option.

j. Print DL No Column: If you want to print Customer and Supplier DL No. then select "Print DL No. Column" option.

k. Print Address Column: If you want to print Customer and Supplier Address Column then select "Print Address column" option.

l. Print Challan to Invoice Date: If you want to print challan & invoice date then select "Print Challan To Invoice Date" option.

M. Print Refer By's Name: If you want to print Refer By's Name then select "Print Refer by's Name " option.

8. Correct Balance: IT WILL BE CORRECT THE PRODUCT & BATCH CLOSING BALANCE.

9. Grid: If you want to export the report in excel format select Grid option.

10. PDF: If you want to export the report in pdf format select pdf option.


Now check your particular product’s complete transaction in single screen with help of Product Query Report.



If you require support please read: 

How to get online support (Guide & Video)


Thanks



SWIL Team




    • Related Articles

    • How to solve problem of negative stock or stock mismatch ?

      Whenever you see this problem in particular product, you should check product query option till current date. If you see difference in stock as on and current balance, you can run correct balance from product query itself to rectify current stock of ...
    • How to Check GST Query in Unisolve/Cross

                          GST Query   GST: Indian system of taxation of goods and services is characterized by cascading, distortionary tax on production of goods and services which leads to miss-allocation of resources, hampering productivity and slower ...
    • How to Enter Product Opening Stock in CrossERP

             How to Enter Product Opening Stock in CrossERP Opening Stock is the amount and value of materials that a company has available for sale or use at the beginning of an accounting period. The closing Stock of the previous accounting period ...
    • How to Enter closting stock value in balance sheet ?

      When you view final accounts - Balance Sheet/Trading or Profit & Loss A/c from Reports or Queries, software asks you to enter closing stock value. If it does not ask or you are not able to see closing stock accounts when you click on stock entry ...
    • How to Check & Solve Opening Balance Difference in Accounts ?

      Some Time we find a difference in the trial balance due to Opening Balance Difference in Accounts. When a total of Debit & Credit Balances of opening balances of all accounts is not equal then an account “Opening Balance Difference" is auto-created ...