Custom Reports based on income from clients

Hi,

I would like to filter clients base on the income they provide me.

Eg: 20 clients have given me business worth 10,k$ and 30 have given me business worth 40k$

All clients who have given me business worth >= 3k$ I need to find them from the database. How can I accomplish this?

Thanks

Aditya



Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

    For more options, visit https://groups.google.com/groups/opt_out.
Aditya,

You will have to create a custom report and add filters via JS

https://github.com/webnotes/erpnext/tree/master/accounts/report/item_wise_sales_register

Check this report to get an idea.

- Rushabh

On Wednesday, October 23, 2013 5:42:07 PM UTC+5:30, Aditya Kumar wrote:
Hi,

I would like to filter clients base on the income they provide me.

Eg: 20 clients have given me business worth 10,k$ and 30 have given me business worth 40k$

All clients who have given me business worth >= 3k$ I need to find them from the database. How can I accomplish this?

Thanks

Aditya



Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

    For more options, visit https://groups.google.com/groups/opt_out.