Generate a report that shows hour spent on a sales item for a specific job

Hi Community.

I have to find out the total number of hours my employees have spent doing a specific pay item on a specific job, that matches a sales item, so that I can invoice the client. Is there an easy way to do this. None of the reports collect this information together. I can get total hours on a pay item but not break it down in to a specific job.

I have their timesheets I could go through manually to get the info, but was hoping there is a way MYOB can do it quicker.