Welcome, Guest. Please Login.
05/14/25 at 00:52:31
News:
Home Help Search Login


ISTech Support Forum › Evo-ERP and DBA Classic › Items ‹ Previous topic | Next topic ›
Pages: 1
Send Topic Print
Parts List with Manufacturer (Read 793 times)
NTI STL
Browser
*


I love YaBB 1G -
SP1!

Posts: 1
Parts List with Manufacturer
09/07/04 at 09:04:30  
We would like to get a report with the following info:
Our part number
Description-both lines
Manufacturer Name and Number
 
Is this Possible without a special report or a great deal of editing in a program like Excel?
Back to top
 
 
  IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: Parts List with Manufacturer
Reply #1 - 09/07/04 at 09:58:53  
I would set up an ODBC connection an use the Query Manager in Excel to go and get that data. Then you can save that excel file and whenever you open it, it will ask if you want the data refreshed.
Back to top
 
 
Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
troesch
Browser
*


I love YaBB 1G -
SP1!

Posts: 5
Re: Parts List with Manufacturer
Reply #2 - 02/15/07 at 09:19:01  
could you explain how to set this up?
Back to top
 
 
  IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: Parts List with Manufacturer
Reply #3 - 02/15/07 at 13:30:02  
try http://www.istechforum.com/cgi-bin/YaBB.pl?board=ODBC;action=display;num=1163083 349;start=4#4 to start. I don't know how to use Excel to get the data.
Back to top
 
 
David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
JNAPIER
Active Member
*****


Evil-Evo Bad Dog!

Posts: 533
Gender: male
Re: Parts List with Manufacturer
Reply #4 - 02/15/07 at 15:26:28  
Once you have your ODBC connection working, in Excell go to DATA, GET EXTERNAL DATA, NEW DATABASE CONNECTION. I think the table you need is MTICMSTR. After you build the query, save it for use later.
 
John
Back to top
 
 
EVO-ERP, ISTS 3.27.08 , 2000I 10 user
Email WWW   IP Logged
Pages: 1
Send Topic Print
ISTech Support Forum › Evo-ERP and DBA Classic › Items ‹ Previous topic | Next topic ›

ISTech Support Forum » Powered by YaBB 2.1!
YaBB © 2000-2005. All Rights Reserved.

Valid XHTML Valid CSS Powered by Perl Source Forge