Reporting assistance

Hi, 

I am working on end of the year reports and struggling to run a few specific reports I need for end of the year sales review.

Can you help me create a report for the following:

1) Revenue (in dollars) and number of rooms nights from groups who use their corporate rates.  We have some groups who will come in and use a corporate negotiated rate for transient travel but ALSO use a group block rate tied to events held on property. When I run the top producers report, it's showing overall spend including group rooms and catering.  I need to isolate out specifically those who are using their corporate negotiated rate (or their contracted) rates in their company cards.

2) To piggy back off of that, is it possible for me to see a report on all companies who have active and past company contracts? We renegotiate the contracts each year and having a list of who has one active is widely helpful. The way the system is now, I'm having to manually go into each company card which is a huge inconvenience. 

Any help would be great!

Login or Signup to post a comment