Alpha Video Training
Results 1 to 2 of 2

Thread: New user - trouble with QB budget reports

  1. #1
    Member
    Real Name
    Robin Carlstrom
    Join Date
    Oct 2008
    Posts
    1

    Default New user - trouble with QB budget reports

    I am evaluating this software to expand our reporting capabilities with QuickBooks. We are a church, so our needs are a bit different from other businesses. I'm having trouble getting the QB budget reports data. I'm getting the following error when trying to create the report:

    Could not create local cache for data from your Database.
    Database API specific error
    Your database has returned the following error code and description to Alpha Five. (...)
    10004 -'[QODBC] Error
    SQL State is: 42S00 while converting ResultSet to DBF table.

    Any help would be appreciated.

  2. #2
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,573

    Default Re: New user - trouble with QB budget reports

    Robin

    The reports require some parameters to be selected to get a resut set.

    One of those parameters is the fiscal year - in some reports anyway.

    I usually look at the report in Quickbooks and then try to match the selections in QRB.

    Which report are you trying to use? I'll take a look to see if I've used it before.

    You can also look at the SQL examples on the QODBC site. Then make your selections match the ones listed.

    For instance, the Budget vs Actual (P&L) can look like this..
    Code:
     
     
    sp_report ProfitAndLossBudgetVsActual show Amount_Title, Budget_Title, Difference_Title, Percent_Title, Text, Label, Amount, Budget, Difference, Percent 
    parameters 
    FiscalYear = 2003, 
    BudgetCriterion = 'Accounts', 
    SummarizeBudgetColumnsBy = 'Date', 
    SummarizeBudgetRowsBy = 'Account'
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

Similar Threads

  1. Budget Reports: error converting ResultSet?
    By plumtv in forum QReportBuilder
    Replies: 3
    Last Post: 05-01-2008, 05:25 PM
  2. Charting – Show Budget, Target and Actual values on single chart??
    By Robert Rough in forum Alpha Five Version 7
    Replies: 4
    Last Post: 01-31-2006, 01:23 PM
  3. Budget comparison Report
    By pcman_chris in forum Alpha Five Version 6
    Replies: 0
    Last Post: 10-10-2005, 03:54 PM
  4. End-User Custom Reports
    By davej in forum Alpha Five Version 5
    Replies: 14
    Last Post: 08-17-2002, 05:23 PM
  5. Trouble with reports
    By Jason Hunsberger in forum Alpha Five Version 4
    Replies: 3
    Last Post: 12-19-2000, 09:32 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •