I am looking for someone to create a Report for us so we can Calculate Commission to pay out to our Sales Reps.
We need the following Columns
Showing Only Invoices paid within a two week period that we can determine before running report.
Invoice Date - Invoice Number - Item Number - Item Description - Sell Price - Cost Price - Margin % - Paid Date
Total Line: Sell Price - Cost Price - Margin % (Average)
See example Report below.