Q: What is the best report to run to compare YTD 2007 to 2008 commissions earned? This report needs to reflect the accurate commission amount when account changes have been made.
A: It depends on what you are looking for...
A: It depends on what you are looking for...
1) Data Analysis's Sales and Commission Analysis cube shows sales and commissions based on the invoice date. Using the Sales Rep on Invoice dimension, you can look at the commissions by who was assigned to the account at the time the invoice was issued (sales and commissions at the time, regardless of how many times the account has been reassigned). Using the Sales Rep on Customer dimension, you can look at the commissions by who is currently assigned to the account (the total business base of the currently assigned rep).
Sales Rep on Customer vs. Sales Rep on Invoice
2) Report Explorer's Sales and Commissions report shows similar information to the Sales and Commission Analysis cube, equivalent to using the Sales Rep on Customer dimension.
Reports: Sales and Commissions
3) Report Explorer's Commission Statement report shows the commissions paid to the agency and sales rep, based on the payment entry screen. This report uses the Sales Rep on Invoice since it captures who was actually paid these commissions.
Reports: Commission Statement, Agency Commission Statement, Sales R...
The first two will show the 2007 vs. 2008 comparison.
Sales Rep on Customer vs. Sales Rep on Invoice
2) Report Explorer's Sales and Commissions report shows similar information to the Sales and Commission Analysis cube, equivalent to using the Sales Rep on Customer dimension.
Reports: Sales and Commissions
3) Report Explorer's Commission Statement report shows the commissions paid to the agency and sales rep, based on the payment entry screen. This report uses the Sales Rep on Invoice since it captures who was actually paid these commissions.
Reports: Commission Statement, Agency Commission Statement, Sales R...
The first two will show the 2007 vs. 2008 comparison.