|
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
|
|
| Problem creating new invoice |
| Author |
Message |
|
|
| Posted : 2007-03-01 15:06:28 |
| I have read all the topics on this problem and I can get it to work with the VB demo script, but I can not get it to work though an ASP page. I can create a new customer but not the invoice. Is there an easier way to create a multi-line invoiceline to an invoice in a one step process? I am using Windows SBS 2003, QuickBooks Enterpise 7.0, and a Windows XP SP 2 system running the QuickBooks. Any ideas? |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-03-01 15:23:36 |
| There's no one step process for a multi-line invoice. Each invoice line has to inserted in a sequence of INSERT statements, but you can also create the first invoice line and then append new invoice lines afterwards. This is sometimes easier as you don't need to use the FQSaveToCache flag, see Plan B in Using ClassRefListID when inserting invoice lines for more information on this alternative method. |
|
|
|
|
|
| Posted : 2007-03-02 01:29:52 |
Tom,
Would it be easier then to just create a single invoiceline then go back and append the other lines as needed? |
|
|
|
|
|
| Posted : 2007-03-02 02:21:36 |
| Also Tom, what is the minum information needed to get the invoice created so I can go back and append to it? |
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-03-02 08:14:16 |
If you already know the number of invoice lines in the invoice to be created, then the standard method is the best, but if you don't how many lines will be created, then creating each line as the user inputs them works better. To create a valid invoice, Customer ID (or Name), Part ID (or Name), Part description and the amount is all you need like this:
INSERT INTO "InvoiceLine" ("CustomerRefListID", "InvoiceLineItemRefListID", "InvoiceLineDesc", "InvoiceLineAmount")
VALUES ('470001-1071525403', '250000-933272656', 'Building permit Additional Room', 100.00) |
|
|
|
|
|
| Posted : 2007-03-03 01:26:53 |
| I am getting into a time problem here. It there a way to get some quick help on this over the phone? If so how can i go about it? |
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-03-03 10:33:03 |
| The paid for priority support options are on the Forum Home link. But it would be far more useful to actually paste the SQL statements and the errors you are getting in this post so I can actually see what the problem is. |
|
|
|
|