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
|
|
get the invoice number |
Author |
Message |
sri |
|
Group | : Members |
Posts | : 19 |
Joined | : 2006-09-27 |
|
Profile |
|
Posted : 2007-02-21 02:04:28 |
Good Day,
i have been using a Java Application for sending invoice an its working fine and i am getting resutls.
but i want to get the invoiceNumber when i send the invoice to Quickbook using my application,
what are the method i should follow to get the invoiceNumber using my application.
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-02-21 08:44:31 |
Try doing:
select Top 1 RefNumber from invoice order by TimeModified DESC
straight after the insert. |
|
|
|
|
Posted : 2008-01-10 05:51:22 |
HI
I running this query select Top 1 RefNumber from invoice Where Name='Apollo Investments' order by TimeModified DESC, and return much slow (5 minutes +-), How optimized this?
Thank you attention,
Regards
MacTorvald |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-01-10 15:49:58 |
Because you most likely have just added the invoice, bypass the optimizer update operation and call QuickBooks directly by using the calldirect tag after the table name like this:
select Top 1 RefNumber from invoice calldirect Where CustomerRefFullName='Apollo Investments' order by TimeModified DESC
this is much faster for one off operations on new data. |
|
|
|
|