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
|
|
cash vs accrual basis in spReport |
Author |
Message |
Elin |
|
Group | : Members |
Posts | : 2 |
Joined | : 2009-02-21 |
|
Profile |
|
Posted : 2009-02-21 12:04:28 |
I am a new user of QODBC and have set up an Access 2003 database that I am using as a central point to integrate our financial data from QB 2009 and other sources. I have an Access query set up as a pass-through query to pull in data from sp_Report ProfitAndLossDetail. This is a report that I frequently use in QB, but when I do, I change the report options to "cash basis" rather than "accrual basis", since that is how our company is set up. I was tearing my hair out trying to figure out why my numbers weren't matching between Access QODBC and QB, when I realized that if I run the QB report as ACCRUAL, the numbers DO match up. So this is leading me to the conclusion (perhaps wrong?) that when I run profit and loss detail from spReport, that it is using ACCRUAL basis. Is there any way to get cash basis data from this report, like I can do in QB? If not, is there a different way to get the data that I want besides figuring out the myriad of QB tables that I have to join to get the data? I was so excited when I figured out spReport saves me all this work, so this is rather distressing....
Thanks for any help/insights! |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-02-22 10:24:33 |
The basics are covered in How do I run a Profit & Loss Standard Report?
To change the reports to "Cash" reporting just add the ReportBasis parameter:
sp_report ProfitAndLossStandard show Text, Label, Amount_1 as Amount, Amount_1_Title as "As of" parameters DateMacro = 'ThisMonthToDate', SummarizeColumnsBy = 'TotalOnly', ReportBasis='Cash'
The options are: |Cash|Accrual|None| |
|
|
|
Elin |
|
Group | : Members |
Posts | : 2 |
Joined | : 2009-02-21 |
|
Profile |
|
Posted : 2009-02-22 13:52:08 |
Thanks so much Tom! I'm just discovering all the resources out there for this product (I'm a long time DBA, so am thrilled to have SQL access to QB!!!) |
|
|
|
|