Item-wise sales report gives information about the invoices and CRO (customer returned order) done and the products sold in a specific range.
If you wish to see the GP%, Mark Up% or cost these are displayed when you enable “Display Purchase Price” from the Role Configuration.
How to enable view purchase price for a specific role to see GP%,Mark Up% of the item?
Navigate to the Main menu
Click on administration
Click on role
Search the role
Click on set role configuration button from right top of the screen
Enable “ Display Purchase Price”.
Image of the set role configuration screen
Main filters in the report
Filter by : Sorting Order of the report can be specified by choosing from the drop down.
Report by : Select the type of report to be generated.
It is based on any of the following options
* Invoiced,CRO : If you want to view both invoiced items and returned items.
* Invoiced : If you want to view only Invoiced items in report * Orders : If you want to view the items that are ordered.
* CRO : This report will display only the products that are returned by the customers
Product : You can generate the report for all the products or a specific product.
Business Partner : You can also select a specific business partner(Customer) and generate the sales report
Additional check boxes to select:
Show Cash Details : In the Item Wise Sales Info in the right hand side of the screen you can view all the payment modes used in the sales.
Show Invoices : In the table new columns will be added for the Invoice number, customer and invoice date.
Tax Included : In the table it shows the retail price as tax included value
How to display the profit inclusive of tax?
To display the profit inclusive of tax you need to enable the role config “Show Profit Inclusive of Tax” from the set role configuration.
Navigate to the Main menu
Click on administration
Click on role
Search the role
Click on set role configuration button from right top of the screen
Enable “Show Profit Inclusive of Tax”