|
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
|
|
| InvoiceLineRate not showing in QBOnline invoice |
| Author |
Message |
|
|
| Posted : 2006-05-02 10:27:17 |
I am trying to insert an invoiceLine, but have not been successful with getting the invoice line rate displayed.
Here is my query:
Insert Into InvoiceLine (InvoiceLineItemRefListID, InvoiceLineDesc, InvoiceLineRate, InvoiceLineAmount, InvoiceLineServiceDate, InvoiceLineQuantity, FQSaveToCache)
values
('2',
'Abcess Drainage',
100.00000,
540.00,
{d'2006-04-24'},
3,
1)
I have tried using 100, 100.00, and even '100' (which obviously threw an error). I can't seem to get 100.00 to be displayed in the rate field. Keep in mind that the query always works and the invoice shows up in QBOnline, just not with the rate field. Any ideas?
-Noah |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2006-05-02 11:12:01 |
| The InvoiceLineRate and InvoiceLineAmount need to be the same value as all invoice lines are for service type items in the QuickBooks OnLine Edition, not stock parts. |
|
|
|
|
|
| Posted : 2006-05-03 08:31:09 |
Thanks for the answer Tom.
I did a little more searching on QBOnline and turns out that there is an option on Company->Preferences called "Quantity and Rate." If checked, it will do the math of quantity * rate automatically when you insert an invoiceLine.
So, the way I fixed my issue was checking that option, then only inserting the rate and quanity in my query. That worked just as I wanted.
-Noah |
|
|
|
|