Sales Report from Custom Field

Hi,

How do I generate a Sales Report of all Salesman even from Salesman who have 0 (zero) sales. I have created a custom field in the Sales Invoice. We need this for Sales KPI for each employee.

The current “Sales Invoice Total by Custom Field” does not show salesman with 0 (zero) sales.

From this
image

You will not obtain such a report. Think about this logically. If a salesman has no sales, there are no transactions for that salesman in Manager. So there is nothing for the program to report. The absence of information is your result. Sometimes, desired reports for management must be generated outside the accounting system.

Yes, I get all this. I just wanted to know if there is any work-around or if someone could help/guide to create such a report in Manager.

See This @siyab
It is already Requested to include master data to custom reports.