Knowledgebase
[QODBC-Desktop] How to run a Job Estimates vs. Actuals Summary Report in QODBC
Posted by Juliet (QODBC Support) on 07 April 2010 06:40 AM

Typical Job Estimates vs. Actuals Summary Report in QuickBooks

Report Displayed in QODBC

Stored Procedure Command

      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'

Display in QODBC

 

Keywords: Job Estimate vs Actual Detail, Job Estiatme vs Actual Detail

(177 vote(s))
Helpful
Not helpful
Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).