I am trying to get the billed and/or unbilled time for a customer. When I try the following I get data for all customers:

sp_report TimeByJobDetail  show  ReportTitle,  RowType, Text, Blank, Date, Name, BillingStatus, Duration, DurationHours  parameters DateFrom = {d'2006-01-01'}

When I try using a filter I do not get any data:

sp_report TimeByJobDetail  show  ReportTitle,  RowType, Text, Blank, Date, Name, BillingStatus, Duration, DurationHours  parameters DateFrom = {d'2006-01-01'}, EntityFilterFullNameWithChildren = '50-000 Apache Corporation:50-824 WD 40A ScadaPack Panel'

When I try using "AccountFilterFullNameWithChildren" i get an error saying that this is not a valid parameter.

So I know that I am not doing the filter correctly.

Can you help me out and tell me what the correct query would be?

Thanks

The EntityFilterFullNames filter is a Multi Lookup, but the EntityFilterFullNameWithChildren filter is a Single Lookup. For example:

sp_report TimeByJobDetail  show  ReportTitle,  RowType, Text, Blank, Date, Name,
BillingStatus, Duration, DurationHours parameters DateFrom = {d'2006-01-01'},
EntityFilterFullNames = 'Gregg O. Schneider', 'Elizabeth N. Mason'

sp_report TimeByJobDetail  show  ReportTitle,  RowType, Text, Blank, Date, Name,
BillingStatus, Duration, DurationHours parameters DateFrom = {d'2006-01-01'},
EntityFilterFullNameWithChildren = 'Gregg O. Schneider'

Use:

sp_parameters TimeByJobDetail

to see all the filter parameters for the report and

sp_reportcolumns TimeByJobDetail

to see all the report columns in the report.

Tom,

Thanks for the information. I guess that I am using the wrong report. From the sp_TimeByJobDetails I can get the time for each employee but I would have to know what employees worked on a project.

What I need is the billed and unbilled time for a job so I guess that I need to use sp_UnbilledCostsByJob. This would give me all of the employees who had time to a project and if the time was billed or unbilled.

Is this correct? I am still learning what report to run to get certain information

Thanks

Tom,

I have looked at the the sp_report information and the sp_parameters, sp_reportcolumns.

When I run the TimeByJobDetail report in QB and I use the 'billing status' filter and the 'customer:job' filter i get the data that i am looking for. My problem is that these filters do not showup as options when i run the sp_parameters and the sp_reportcolumns.

Does the reports in QB have extra filters that are not available in the sp_reports?

You can use the standard SQL WHERE clause in reports to do further filtering, for example:

sp_report SalesByItemDetail show Account, Text, Blank, TxnType, Date, RefNumber, Memo, Name, Quantity, UnitPrice, Amount parameters DateMacro = 'LastQuarter' where Account = 'Maintenance Renewal'