Hello,
It seems like when you say “Bookings” you are talking about total sales orders in a certain range of days. It seems like when you say “Billings” you are talking about total Invoices in a certain range of Days. If I understand the need correctly, then you will use the Sales Orders and AR Invoice tables/DACs in your report.
To find out which DACs/Tables, and fields to use on your report, try clicking Customize → Inspect Element in the screens where you see Invoices and Sales orders, to give you an idea of DAC names and Field names.
You can look at existing reports that show sales orders and invoices, or Generic Inquiries that show the same records that you want in your report. Look to see which DACs and fields the standard reports use, and how the Relations are configured. Then use these same DACs and fields and similar relations in your report.
How to link DACs: Use the key fields to join the tables that you need.
If I am not answering what you need, please explain in more detail what you need. Post examples of your report, the part that is not working or the part you specifically need help with.
Laura