Hi,

Well, I am using "QuickBooks Pro Professional Business 2006-07". I need to develop a Job Summary Report where i display Purchases, Sales, Labour Charges for each job type.

1. I can retrieve the purchases for a job since each purchase item is linked with customer reference id and using that Customer reference id, i can get the corresponding job type id for that customer and hence for that purchase. (Since the customers may be associated with jobtypeid in the customers table)

2. In the same way i can get the Sales for a job thru the customer reference id in the Invoice table.

3. My problem is I am not able to relate an Employee to a particular jobtype (or even customer). If so, please provide the necessary info how this can be done so that i can get the labour charges for a particular job.

Well, i was able to add a custom field by name "Job" in the Employee entry screen and enter the Job name. But i am not able find where this particular entry is stored in the database. Moreover, i cannot link this "Job" Custom field to the "JobType" table and hence calculating labour charges for a particular job is becoming a daunting task for me.

Please provide the necessary info, regarding how to proceed further regarding the labour charges by each job.

Thanks in advance,

With warm Regards,

Hari.

The actual Job Reports can be called directly in QODBC using stored procedures. See: How do I use the QuickBooks Reporting Engine with QODBC? I've heard something about sp_report ? 

Hi Tom,

Thanks for the Reply. But it doesn't solve my problem. You have just given a link to the list of all stored procedures. My query is to get the expenses( or charges) made on a particular employee grouped by Job Types. I Just want to know that how can we link an employee with a job type (the employee table doesn't have any JobTypeRefId or CustomerRefId as a foreign key).

Thanks & Regards,

Hari.

Take a look at the TimeTracking table,

select * from TimeTracking

it shows employees and the jobs they have labour for. If that doesn't help tell me the report using the QuickBooks user interface that gives you the information you are after?