Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

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

Forum : AR Aging and Journal EntriesSearch Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC v9 Forum

 New Topic 
 
 Post Reply 
[1]  
 AR Aging and Journal Entries 
 Author   Message 
  Kurpal 
  
 Group: Members 
 Posts: 6 
 Joined: 2008-05-10 
 Profile
 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?

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 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?  

 

  Top 
  Kurpal 
  
 Group: Members 
 Posts: 6 
 Joined: 2008-05-10 
 Profile
 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.

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 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.

 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to