Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Lookup in VI?

Status
Not open for further replies.
Sorebrek

Sorebrek

MIS
Jan 14, 2005
29
US
Anyone know if there is a way to do a lookup in a VI Sales order import? I'm on V4.05.

I will be receiving orders with the customers DUNS number in it. I need to translate that number into the division & customer number I use.

Any ideas or direction is appreciated.
 
Sort by date Sort by votes
Not really. Your best bet would be to use Access and link in the file you receive. Then do a SQL specific pass through query to the Customer Master file where I am assuming you have the DUNS number stored somewhere. Create a select query linking on the DUNS number. The create a DSN data source with the Access database. Then create a VI job based on ODBC and read the query.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

fuel4u
  • Locked
  • Question
Error 43 in Program CLWRGB.INC at line 5810
Replies
0
Views
184
fuel4u
fuel4u
DarbyIT
  • Locked
  • Question
VI Work Order Import
Replies
0
Views
218
DarbyIT
DarbyIT
hhhugo
  • Locked
  • Question
MAS 90 VI Payroll Import Job
Replies
2
Views
96
hhhugo
hhhugo
keithd21
  • Locked
  • Question
Saving daily sales journal in Micros 3700
Replies
0
Views
196
keithd21
keithd21
SQL3301
  • Locked
  • Question
connect to the ODBC located in the remote server
Replies
0
Views
201
SQL3301
SQL3301

Part and Inventory Search

Sponsor

Back
Top