Introduction


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?


  1. Navigate to the Main menu

  2. Click on administration

  3. Click on role

  4. Search the role

  5. Click on set role configuration button from right top of the screen

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


  1. Navigate to the Main menu

  2. Click on administration

  3. Click on role

  4. Search the role

  5. Click on set role configuration button from right top of the screen

  6. Enable “Show Profit Inclusive of Tax”