PDA

View Full Version : Welcome to the QReportBuilder Forum!


ABC123

bradwww
09-11-2007, 06:46 PM
Welcome to the QReportBuilder Support forum.

Post your questions about QReportBuilder, the report writer designed specifically for use with QuickBooks.

We have different types of support people checking this board, from QuickBooks ProAdvisors fluent in QuickBooks, to programmers and consultants who know the report writer and it's abilities specifically because of it's parent product Alpha Five.

Between the two groups we hope you will get the answers you need to get your project completed quickly.

Thanks!

Brad Waddell
QReportBuilder Product Manager

Lance Gurd
09-13-2007, 02:44 AM
Ok, got to ask, what is Qreportbuilder? Only one reference to it in the help file and nothing in search of Alpha web site.

bradwww
09-13-2007, 08:15 PM
Again: QReportBuilder, the report writer designed specifically for use with QuickBooks.

This product is being jointly developed using a base of the Alpha Five SQL Report Writer and the QODBC Driver for QuickBooks.

For more details and to download see QReportBuilder.com - thanks!

brad

Lance Gurd
09-14-2007, 02:45 AM
Went there yesterday after a web search. Lots of under construction pages, broken links and the buy pages don't work. Downloaded the demo which didn't work due to me trying QODBC in the past, and finding no real need for it.

I then found that the Alpha software I was running at the time stated that I had an out of date version and had to be re-started.

All in all a waste of time for me.

bradwww
09-14-2007, 03:44 AM
Now you know how new this product is, as well as the web site, and we have 3 million potential customers using QuickBooks that need custom reports built.

Many will find it worth the effort to get all of these new customers as we move forward on this exciting new product! thanks for the feedback.

brad

Richard Rabins
09-14-2007, 06:12 PM
Some quick background on this.

QReportbuilder is a product that is being created as a joint venture between Alpha Five and the folks who make www.qodbc.com

On the QReportBuilder website it is described as follows

"Forget about exporting QuickBooks report data to Excel and manipulating that data to create custom reports, having to repeat this ordeal every time you need to run the report. QReportBuilder simplifies reporting: You build the report one time in the visual designer; one click runs the report on the latest company data at anytime.

QReportBuilder allows you to generate virtually any custom report you can imagine based on your underlying QuickBooks data. Your QuickBooks reports can even combine data with external sources such as Excel or MS Access.

Unlock critical information buried in QuickBooks to make better business decisions for profitability and growth through better reporting…with QReportBuilder!"

The product has been under development for about 2 years and its design goal is to make building custom reports based on QuickBooks data substantially quicker and easier than the manual processes that exist today.

The web site is www.qreportbuilder.com. The site is still under development. The product will be formally launched in the 4th quarter soon after this training event in Las Vegas http://www.greatstatements.com/sleeter2007/ (Alpha users and developers are welcome to sign up)

QODBC is the ODBC driver for interfacing with QuickBooks. It is the only ODBC driver for Quickbooks and is actually bundled in with QuickBooks Enterprise.

We know from surveys that many of Alpha users who use accounting software also use QuickBooks and that the number 1 frustration that QuickBooks users have relates to the limitations of the QuickBooks Report Writer.

If you are an Alpha Five user or developer and would like to find out more about the product before release, please email marketing@alphasoftware.com

Sincerely

edward.mattison@scbhn.org
12-28-2007, 01:31 PM
I am switching our accounting system from Peachtree to Quickbooks. I would like to be able to easily import info from Quickbooks in real time to a A5v8 database. Can I do this from A5 or would Qreportbuilder help. Mostly I want to import information about checks paid on behalf of particular clients. Thanks Ed

Al Buchholz
12-29-2007, 12:18 AM
I am switching our accounting system from Peachtree to Quickbooks. I would like to be able to easily import info from Quickbooks in real time to a A5v8 database. Can I do this from A5 or would Qreportbuilder help. Mostly I want to import information about checks paid on behalf of particular clients. Thanks Ed
Ed

1. QReportBuilder would help with understanding the data structure of QB, but isn't designed to integrate into an Alpha 5 system. You would use a passive link table to move data from QB to A5 or an Alpha DAO call to get data...

2. Real-time? Please describe more of what you want to do. Look at a client's record and then press a button and get data about checks paid? Or something else.....??

edward.mattison@scbhn.org
12-31-2007, 11:55 AM
Thanks for the info. Presently we have an A5 database that has info about each client and a child table that reflects the rental payment we make for that client. Clients can get up to 6 months of rent paid. We hand enter the payment information and it often is not quite the same as the checks paid in our accounting software. I would like to just have the checks that show in the database come directly from what will be Quick Books. Can this be easly done? Ed

Al Buchholz
12-31-2007, 12:37 PM
Thanks for the info. Presently we have an A5 database that has info about each client and a child table that reflects the rental payment we make for that client. Clients can get up to 6 months of rent paid. We hand enter the payment information and it often is not quite the same as the checks paid in our accounting software.

You re key the check information into A5?


I would like to just have the checks that show in the database come directly from what will be Quick Books. Can this be easly done? Ed

Yes this can be done...

michaelwpayton
12-31-2007, 12:37 PM
QODB (i.e. a QuickBooks "ODBC driver") will allow you to access your Quickbooks data via Alpha. For example, you would be able to use Xbasic code... related to an Alpha form's button... to access the check records in Quickbooks. As to if it can be "easily done," that, of course, depends on who's doing it but there are a number of examples posted here which discuss the details of using QODBC.

After thought:

You may also want to look into the QuickBooks Foundation Class (QBFC)... which is available from Intuit. It provides the same level of access to Quickbooks data, but does not require you to purchase QODBC.

Al Buchholz
01-04-2008, 06:33 PM
After thought:

You may also want to look into the QuickBooks Foundation Class (QBFC)... which is available from Intuit. It provides the same level of access to Quickbooks data, but does not require you to purchase QODBC.

That's what QODBC is based on. So you can always re-invent the wheel and update each time QB changes (annually) or let QODBC do it for you.

edward.mattison@scbhn.org
01-04-2008, 06:42 PM
Although we are planning in July to switch over to Quick Books, we presently use Peachtree. Is there anything that would work with that? Ed

Al Buchholz
01-04-2008, 06:43 PM
Although we are planning in July to switch over to Quick Books, we presently use Peachtree. Is there anything that would work with that? Ed

With Peachtree? Not that I know of.

edward.mattison@scbhn.org
01-04-2008, 06:45 PM
Thanks anyway. I'll be back in touch when we make the switch. Ed

Al Buchholz
01-04-2008, 06:50 PM
I posed the question to a Peachtree booth at a conference in Vegas, gave them my card, haven't heard anything.

I will let you know if I do find something that works for Peachtree/Sage.