Hello. I have created a custom Crystal report showing sales by Salesperson code. I realize there is a "standard" report in Sage already, but our director is wanting one that exports to a clean Excel format. A couple of issues...
1. The custom report is showing ALL transaction for each customer, by period and Salesperson code. How do I only show ONE customer record per Salesperson code and their total dollar amount spent for that particular sales order/invoice?
2. I was able to locate the Gross Profit Amount field for this report via the vSalespersonSalesHistory table - where do I find the Gross Profit Percentage field (which table)?
Thanks in advance for any assistance!
T. Helm