Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
How do I access data in the standard QuickBooks report Time by Job Data for more flexible reporting? |
Author |
Message |
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-02-21 11:51:48 |
I am wanting to access data in the standard QuickBooks report Time by Job Data for more flexible reporting using excel pivot table reports. How can I do this? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-02-21 11:52:12 |
QODBC allows you to link the Time By Job Detail report directly into Excel. See How do I use the QuickBooks Reporting Engine with QODBC? I've heard something about sp_report ? for more details. Using QODBC you can create a Live Link to QuickBooks data in Excel. QODBC allows you to quickly merge live QuickBooks data into the cells of your Microsoft Excel worksheets for "dashboards", "what if" calculations and graphs. Your data will be retained as a live link to QuickBooks, and the worksheet will automatically update the data in your worksheet to the most current data in your QuickBooks Company file (.qbw) each time it's loaded, or as often as you like!
In MS Query you need to enter the SQL statement :-
sp_report TimeByJobDetail show Text, Blank, Date, Name, BillingStatus, Duration parameters DateMacro = 'ThisMonthToDate'
|
|
|
|
|