Importing a parts list

Importing a parts list

Postby Stevenspeaking » Fri Jun 26, 2009 4:01 pm

I have a parts list in excel. How can I check these parts against my system to check my availability? I am assuming there is a way to do this without cutting and pasting each number. I am on websuite 2007s and also have reflections set up on my computer.

I am trying to review closed dealers inventory to see if there is anything I could use. It may also save some time while checking promos.

Thank you
Steven

------------------
Its like a big lifesize chess game.
Stevenspeaking
 

Importing a parts list

Postby jazdale » Fri Jun 26, 2009 10:47 pm

You are going to LOVE this!

Function RPG, use the PART-NO. file

Go to option 1 and choose prompt for ID
Paste your list of part numbers and watch them fly into the screen.

Setup 3 (sort) and 4 (output fields)as desired

R to run it.


Service can do the same thing with last 8 of VIN in the VEHICLES file.
jazdale
 

Importing a parts list

Postby exmopar » Sat Jun 27, 2009 4:58 pm

Jaz - that's fantastic - THANKS!!!

ex

------------------
No, i'm sure you said left, right?
exmopar
 


Return to ADP Users Forum

Who is online

Users browsing this forum: No registered users and 19 guests