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
|
|
Getting complete data |
Author |
Message |
gigi |
|
Group | : Members |
Posts | : 2 |
Joined | : 2006-11-17 |
|
Profile |
|
Posted : 2006-11-17 00:21:40 |
Hi: I'm new to QuickBooks and QODBC. In my previous job, I did SQL queries to the accounting database that allowed me to get all the information from one table -- that is, all the credits or debits to every account would come out in one query. That way I knew I was creating a report that gives all the information. Here I have different tables that each give only one piece of the picture. I haven't yet managed to link tables that are not already intrinsically linked -- that is, to query both the invoice table and the bill table together. Even if that worked, it would not give me non-billed expenses, such as payroll. What can I do?! |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-11-17 08:36:09 |
Wouldn't it be nice if Accounting was so simple it could be one table? Well life isn't that simple because QuickBooks just doesn't have a General Ledger Transaction table, but what you describe is closer to what I describe as being an Audit Trail where I can see everything that happened in a day, week, month or year.
Try looking at: How can I query the audit trails?
You can also look at our Transaction table, which is good approximate of a GLTran file and closer to what you are wanting:
SELECT * FROM Transaction where TxnDate >= {d '2007-12-01'} and TxnDate <= {d '2007-12-31'}
|
|
|
|
gigi |
|
Group | : Members |
Posts | : 2 |
Joined | : 2006-11-17 |
|
Profile |
|
Posted : 2006-11-21 23:36:49 |
Dear Tom: Thank you. The transaction table really does give me what I need, with just one problem -- it doesn't deal well with corrections! If I paid a bill on a particular date and corrected it on a different date the "BillPaymentCheck" brings out two lines with the same transaction number and date created, but different date modified and different amounts. How do I tell it that if the transaction was modified I only want the final modification? -- Gigi |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-11-22 08:39:10 |
You are looking at a TRANSACTION listing not at the actual ledger listing. See the BillPaymentCheck table for the current Check details. |
|
|
|
|