Solved

Quickbooks IIF import - AUTO NUMBER Invoice on import

Posted on 2006-11-16
6
1,152 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
mobile app idea 17 95
Veriface disable 2 38
ServiceCenter IR Query Expressions 1 51
How to recover unsaved document deleted from a recycle bin. 7 57
I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
If your app took Google’s lash recently, here are the 5 most likely reasons.
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…

749 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