How to determine last (or next) invoice number from SDK????

Jul 27, 2005 2 Replies

I am adding invoices to QuickBooks Pro 2004 from a Visual Foxpro app I am writing using the QBFC from the SDK.



Everything is working well.



In my app, I check to make sure the invoice number chosen by the VFP app user is not already in use by QB, and I so, I pop up a window, and make them choose another number. (There is a good reason why I do not just let QB assign the next number, but I will not get into that here)



Here's what I want to do...I want to look up the highest invoice number used so far by QB, and offer the next one digit highr to the user in my VFP app.



So, here's my question: How can I determine, or look up, what is the hight invoice number used by QB so far???


"Uncle Matt"

I think you'll have better luck getting an answer to this at:

formatting link

Well, ya could go to edit/find, choose transaction type = invoice. This will of course show all invoices but you could also filter for a date range... Or you could create a custom transaction detail report filtering for invoices and memorize the report so it's always ready to go...

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required