IT SUPPORT
asked on
Automate Invoicing / Quickbooks 2010
We are using quickbooks 2010 pro for our invoicing system.
We are looking for a solution to be able to send an email or fill out an app on our blackberrys when we are not in the office that will contact our quickbooks database and auto create an invoice. We want to eliminate the steps of sending a work order email to admin....admin has to manually create an invoice in quickbooks then email this to the client.
Thanks!
We are looking for a solution to be able to send an email or fill out an app on our blackberrys when we are not in the office that will contact our quickbooks database and auto create an invoice. We want to eliminate the steps of sending a work order email to admin....admin has to manually create an invoice in quickbooks then email this to the client.
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It wouldn't be that difficult to build an ASP-based front end customized to the Blackberry screen dimensions that provides a data entry form with the needed information, and then push the data to QuickBooks with QODBC.
Although I've not tried it myself yet from ASP, I have written ASP database inserts and updates via ODBC, I've written simple ASP-based pages for the BB that query a database (m.goldstarsoftware.com), and I've also parsed data from Emails and inserted into QuickBooks to create an invoice, so it should be fairly straightforward to merge the three solutions into one do-it-all block of code.
The database connections and SQL statements tyo handle the invoice creation are easy, and QODBC.com has sample SQL statements to do it all for you. Once you're pastthe initial connection, the biggest difficulty is to define how detailed you want the BB interface. A simple data-entry-only interface is VERY easy to build in ASP for the BB (as the page above shows). However, you could continue to expand it with customized drop-down lists and the like and make it quite complex, as well.
Such a solution would require the set up of a web server (if you don't already have one) with QODBC installed (which is a purchased product), but would otherwise be a slam dunk. Of course, it won't be directly integrated with the BB like a true BB application would be, but it's a LOT easier to build.
Although I've not tried it myself yet from ASP, I have written ASP database inserts and updates via ODBC, I've written simple ASP-based pages for the BB that query a database (m.goldstarsoftware.com), and I've also parsed data from Emails and inserted into QuickBooks to create an invoice, so it should be fairly straightforward to merge the three solutions into one do-it-all block of code.
The database connections and SQL statements tyo handle the invoice creation are easy, and QODBC.com has sample SQL statements to do it all for you. Once you're pastthe initial connection, the biggest difficulty is to define how detailed you want the BB interface. A simple data-entry-only interface is VERY easy to build in ASP for the BB (as the page above shows). However, you could continue to expand it with customized drop-down lists and the like and make it quite complex, as well.
Such a solution would require the set up of a web server (if you don't already have one) with QODBC installed (which is a purchased product), but would otherwise be a slam dunk. Of course, it won't be directly integrated with the BB like a true BB application would be, but it's a LOT easier to build.
ASKER
Thanks we are working with Wireless Merchant to beta the app
ASKER
That link you sent is the idea. I dont need the whole wireless card swipe etc...just interested in the invoice to backend accounting system. I dont see mention of QB on their site.
I may check out their service!