I need to create a report that will show me all Quotes that were completed this week. (We are not using the Quote related list for this.) We have custom fields on the Opportunity that will show the Quote #, Quote Due Date, Quote Complete Date, how many hours is took to do the quote, etc. The Quote # field will change for each revision. My issue is that if there was a revision done to a quote in the same week the quote was created the report only shows one quote. I need the report to show me both...the original quote and the revised quote.
I tried a custom field that will count the revisions but when I run a history report all fo the fields are changed to the latest quote information.
