I am running the Line Item Pivot Report to gather data to send to my clients at the end of each month. I'd like to suggest that the booking status be included in that report like it is on the Booking detail report. For example:
BOOKING DETAIL REPORT:
Sheehan, Brad [CANCELED]
LINE ITEM PIVOT REPORT:
Brad Sheehan
There is nothing on the Line Item Pivot report to alert that this was a canceled booking.
I want to include canceled bookings on the report because some of them may have charges that should be documented on a canceled booking. But some other canceled bookings may not and it is easy to miss the fact that any of these are canceled bookings.
I hope this is possible, thanks!