Need to have total sales (Sales person) per employee…
Now what are the risks of having a formula or the system allowing on HR to type an sql command ex. (select sum(total) from tabSales Invoices where sales person like employee name).
The ability to select any or all doctypes where employee is used.
I know that at the moment it does not support and will have to do a custom script… But think is something to think about??