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. |