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
|
|
AR Aging and Journal Entries |
Author |
Message |
|
Posted : 2008-10-17 16:32:30 |
I am creating an AR Aging report with Crystla Reports by transferring QB Ent 9 data to SQL Server. How can I identify Journal Entries with an Open Balance? What is the best table to pull from? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-10-17 23:21:56 |
Sorry, on one hand you are saying Account Receiveable Aging report and then you talk about Journal Entries with an Open Balance? There's no General Ledger Transactions file in QuickBooks so you can't build reports that way. All transactions in QuickBooks have an account field, so QuickBooks creates Balance Sheets and Profit and Loss reports from reading all the sub-ledgers.
Try taking a look at: How do I run a ARAging Summary Report? |
|
|
|
|
Posted : 2008-10-18 07:16:09 |
I bring up Journal Entries because those will show on an Aging if they are entered for a customer.
Can I have the SP used for the AgingReportDetail, or any other built in QODBC Stored Procedures, output the results to a table instead of generating a report? I am using a VB application to connect QB and MS SQL for multiple company files. If I can have the data sent to a table, I can create the reports I need.
Thanks for the help. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-10-18 10:50:36 |
That's:
sp_report ARAgingDetail show Text, Blank, TxnType, Date, RefNumber, PONumber, Name, Terms, DueDate, Aging, OpenBalance parameters DateMacro = 'Today', AgingAsOf = 'Today'
See: How do I use the QuickBooks Reporting Engine with QODBC? I've heard something about sp_report ? for more. |
|
|
|
|