i am trying to run a sp_report for job profitablilty. The problem is that I am trying to be job specific. In quickbooks-- our job list consists of Customer names with each job name beneath it. I am able to pull the profitability for the customer but that lumps all the totals for all the jobs.
This is the formula that I use to pull the customer:
sp_report JobProfitabilityDetail show AmountActualCost_Title, AmountActualRevenue_Title, AmountDifferenceActual_Title, Text, Label, AmountActualCost, AmountActualRevenue, AmountDifferenceActual parameters DateMacro = 'All', entityFilterFullNames = 'Granite Properties', SummarizeCulumnsBy = 'TotalOnly'
Granite Properties is the customer name but I need to pull the report for a certain job of that customer. the job name is:
07060 TXCO Resources 10370 Richmond
Please Please....any help is appreciated. |