Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Quickbooks IIF import - AUTO NUMBER Invoice on import

Posted on 2006-11-16
6
Medium Priority
?
1,191 Views
Last Modified: 2011-03-02
Looking to see if anyone has figured out how to AUTO NUMBER an imported INVOICE in a QuickBooks IIF file.

QB Pro 2006

FIELD: DOCNUM
AutoNumber entry: ?

I have read elsewhere it is not possible, but I wanted to ask you kids.

Thanks,
Scott
0
Comment
Question by:sddavis
  • 3
6 Comments
 
LVL 30

Expert Comment

by:Marc Z
ID: 17959201
0
 
LVL 30

Expert Comment

by:Marc Z
ID: 18025891
sddavis,

We have not heard from you. Did any comment help you solve your problem? Do you need any clarification? If an Expert helped you, please accept his/her answer above with an excellent or good grade.


Marc
0
 

Author Comment

by:sddavis
ID: 18027635
The answer lies in a QuickBooks (QB) ODBC driver.  Problem is that the driver is like $150!  Some have written import programs for less.

You can get the ODBC, write a querry to get the last invoice number in QB, and stop off of that.

Thanks,
Scott
0
 
LVL 30

Expert Comment

by:Marc Z
ID: 18027806
Thanks for the update and finding a solution.
See this to get your points refunded. http://www.experts-exchange.com/help.jsp#hi70
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 18212186
PAQed with points refunded (500)

Computer101
EE Admin
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If something goes wrong with Exchange, your IT resources are in trouble.All Exchange server migration processes are not designed to be identical and though migrating email from on-premises Exchange mailbox to Cloud’s Office 365 is relatively simple…
When you discover the power of the R programming language, you are going to wonder how you ever lived without it! Learn why the language merits a place in your programming arsenal.
This video demonstrates how to use each tool, their shortcuts, where and when to use them, and how to use the keyboard to improve workflow.
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question