On this screen, you will be able to view and download the report for product wise sales information. This will help you to determine your fast and slow moving products, to understand customers buying pattern and will also help your stock replenishment process. Please note this screen will not display any open and return invoices. Only invoiced sales orders.
As soon as you open this screen, all the invoiced orders will display along with product details. You can narrow down your search using the above options- SO ID, Customer Name, Branch Name, Product Name and Date Range.
SO ID : If you want to see the product sales detail for any specific sales invoice, please enter that Sales order ID and click on submit.
Customer Name: To view the product sales detail for a single customer, please enter the customer name or to select the customer from the list of all customer records, please type *.*
Branch Name : In order to view the product sales detail for a branch, please select the branch name. This field is only applicable for multi branch company. If you are a single branch company, please ignore this.
Product Name : If you want to view the sales detail for any particular product, please type the product name here and click on submit.
Date Range : Please enter the start and end date on this field. Once you are done with the above selection, please click on SUBMIT. You can control the total number of transaction to display on the screen by selecting the number through “Show” drop down box. Example-50, 100 etc.
Data will display with following column headings :
SO ID : This column will display sales order number.
Invoice Date : Date of invoice.
Product Name : Product which was sold against this invoice.
Customer Name : Customer whom you have sold this product.
Branch Name : Name of the selling branch/ location.
Qty. Sold : Total quantity sold against this sales invoice.
Extended Price : Extended price filed will display total selling price of that product on that invoice. ( Unit price X Sold Qty)
If you want to copy, download or print the data from this screen, then please click on Copy/CSV/Excel/PDF or Print.