Forum : How do I run a Job Estimates vs. Actuals Summary Report?Search Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC Reporting Forum

 New Topic 
 
 Post Reply 
[1]  
 How do I run a Job Estimates vs. Actuals Summary Report? 
 Author   Message 
  Tom Aczel 
  dd4bf_dawworld.jpg
 Group: Administrator 
 Posts: 6281 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-02-09 10:12:14

A typical Job Estimates vs. Actuals Summary Report in QuickBooks looks like this:

With QODBC the same report can be generated using stored procedure reports like this:

sp_report JobEstimatesVsActualsSummary show Text, Label, AmountEstCost_1 as "Est. Cost",
AmountActualCost_1 as "Act. Cost", AmountEstRevenue_1 as "Est. Revenue",
AmountActualRevenue_1 as "Act. Revenue"
parameters DateMacro = 'All', SummarizeColumnsBy = 'TotalOnly'

 

  Top 
  John Macko 
  
 Group: Members 
 Posts: 1 
 Joined: 2007-08-04 
 Profile
 Posted : 2007-08-04 03:53:09
Is there a way to bring the data from the description field for the items into the report? 

  Top 
  Tom Aczel 
  dd4bf_dawworld.jpg
 Group: Administrator 
 Posts: 6281 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-08-04 09:27:24

No, but try looking at:

sp_report JobEstimatesVsActualsDetail show Text, Label, AmountEstCost, AmountActualCost, AmountDifferenceCost, AmountEstRevenue, AmountActualRevenue, AmountDifferenceRevenue parameters DateMacro = 'All', EntityFilterFullNameWithChildren = 'International Buyers', SummarizeColumnsBy = 'TotalOnly'

using one of your customer job names.

 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to