Reports - Master bookings

Post here if you cannot find a better category
Post Reply
kingszg
Posts: 21
Joined: Sat Sep 21, 2019 7:38 am

Hello,
A question concerning group bookings and reports.

Is it possible to include only "master" booking records into a report and to show the "sum of all invoice balances" instead of the "invoice balance" of the individual booking.

The reason for this: We are using a custom report with "non-zero balance after check-out" to track any unpaid items. The problem is that payments in a group booking - if they are invoiced and paid together - are assigned to the "master" booking. As a result, even if everything is paid, the master booking shows a positive balance, while the associated bookings all have negative balances.

Thanks.
annettemorgenroth
Posts: 1331
Joined: Sun Jun 30, 2013 8:44 am

Custom reports an not be generated by master bookings. What you can do is generate a report which lists both the group ref and the booking ref, download it to Excel and the remove the bookings where the group ref and the booking ref is not identical.
kingszg
Posts: 21
Joined: Sat Sep 21, 2019 7:38 am

Hi Annette,
Thanks for your quick reply.

Are you considering including additional "criteria" in the selection choices for Custom Reports (e.g.: "is master booking" or "is part of group booking" etc.?) going forward?

Also, is there a field that can be used to display the "group's invoice balance", instead of the "bookings's invoice balance"?

Many thanks,

Dirk
annettemorgenroth
Posts: 1331
Joined: Sun Jun 30, 2013 8:44 am

This is not in planning. Have you tried setting "Layout" = Group by Booking Group?
Post Reply