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
|
|
How do I change the price of a line in an existing Invoice? |
Author |
Message |
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-02-21 20:06:58 |
You can use the following update statement to change the price of a invoice line:
update InvoiceLine set InvoiceLineRate=200 where InvoiceLine.Txnid='C38-1080104832' and InvoiceLine.InvoiceLineSeqNo=1
Where: InvoiceLineRate is the new price per item before tax. Txnid is the Transaction ID for the existing Invoice. InvoiceLineSeqNo is the Invoice Line number
Note: You always need to reference the Txnid for all update operations you do using QODBC and obviously the InvoiceLineSeqNo for the right line in your invoice.
|
|
|
|
jeff |
|
Group | : Members |
Posts | : 76 |
Joined | : 2006-06-03 |
|
Profile |
|
Posted : 2006-07-22 05:25:43 |
Is it possible to update an invoice line if it is a group item? If so what is the sql syntax? thanks in advance |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-07-22 09:55:04 |
The above method will not work with items within a group as all items of a group have the same InvoiceLineSeqNo. I am looking into a procedure to do this, but for the moment it's not possible to update invoice lines within a group. You need to use the QuickBooks user interface for now.
See: How do I invoice item groups? for more. |
|
|
|
|