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
|
|
SQL for invoices |
Author |
Message |
|
Posted : 2009-01-15 09:51:51 |
We are looking for SQL code to help read in a batch of invoices (multiple line items and multiple invoices). It would also be nice if it read from a file or either Exel or comma delimited format. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-01-15 10:46:29 |
|
|
|
|
Posted : 2009-01-15 13:38:04 |
I want to be able to import Excel data for invoices into QuickBooks. If not using Excel, I can use comma delimited files, text files with a series of INSERT statements, or whatever. You tell me what options I have available. The invoice data is coming out of an existing web application. Using the VB Demo program I can create one line of an invoice at a time. I want to be able to start a batch and enter a series of lines one after the other, not one at a time. If I have 40 invoices I want to import into Quickbooks, I may have over 300 INSERTs needed. I want to be able to put all the inserts in at once in some sort of file, or put the data into an Excel file, and then update all the data at once into Quick books. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-01-15 13:53:24 |
|
|
|
|