How can you report timesheet entries for projects showing the Invoice number they were billed through

How can you report timesheet entries for projects showing the Invoice number they were billed through

I am having great difficulty in finding how, from within BOOKS or ANALYTICS, I can get a report of all the timesheet entries against a client/project etc in BOOKS that not only tells me that the time entry has been approved and invoiced but shows me the invoice number for the invoice that included the time log.

We can see the invoice number if we select the time log entry in the Timesheet data screen of BOOKS under Time Tracking (it shows up only on hover or select) but I am just unable to get this CRUCIAL pièce of information in any report or even better, export.

Does anyone have any suggestions on whether this is possible, if not why we can't get this or how I might otherwise get this information?

In my particular case, the timesheets are captured in PEOPLE and pushed, after approval, to BOOKS from there they are invoiced.

            Zoho Marketing Automation

                      Zoho Pagesense Resources

                        Zoho SalesIQ Resources



                              Zoho TeamInbox Resources

                                Zoho DataPrep Resources



                                  Zoho CRM Plus Resources

                                    Zoho Books Resources


                                      Zoho Subscriptions Resources

                                        Zoho Desk Resources

                                          Zoho Projects Resources


                                            Zoho Sprints Resources


                                              Qntrl Resources


                                                Zoho Creator Resources


                                                  Zoho WorkDrive Resources



                                                    Zoho Campaigns Resources

                                                      Zoho CRM Resources

                                                            Design. Discuss. Deliver.

                                                            Create visually engaging stories with Zoho Show.

                                                            Get Started Now