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