×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

external BOM / parts list database suggestions...

external BOM / parts list database suggestions...

external BOM / parts list database suggestions...

(OP)
I would like to get suggestions from the community about an external B.O.M. or parts list program. What are your thoughts about it? Suggested software or programs or ideas...

 I am building a database to handle an external parts list, using MS Access. It's very detailed and relatively complicated. It has a web interface and you can select certain cells for commonly stocked items like fasteners and materials.

But what I am asking for is, does anybody already have a similar a product or database?

And if not, I would like collaboration on the suggestions to build one...
 

RE: external BOM / parts list database suggestions...

How much do you want to spend? Or what's it worth to you?
Like Kenat said there are TONS of ERP programs that do exactly what you want...

There are some cheap ones too.. Like even Quickbooks has stocking,etc.. functionality  

Many free/open source ERP programs also out there.

Typically a decision like this requires a team of every department to discuss what they need, then get demo's/testing/training,etc... Accounting/production/manufacturing/engineering,etc..

RE: external BOM / parts list database suggestions...

tzinger,

   I would not use Microsoft Access.  It does a rotten job of running across the different versions that are installed on the computers in your office.  

   This is a job for ERP or MRP software.  This is not going to be cheap.

               JHG

RE: external BOM / parts list database suggestions...

Let make myself clear, I wasn't suggesting SAP, it's just what we use to fulfill similar functions if I understand the OP questions.

SAP stands for "Stops All Production" as far as anyone around here is concerned.

KENAT,

Have you reminded yourself of FAQ731-376: Eng-Tips.com Forum Policies recently, or taken a look at posting policies: http://eng-tips.com/market.cfm?
What is Engineering anyway: FAQ1088-1484: In layman terms, what is "engineering"?

RE: external BOM / parts list database suggestions...

Kenat,
Couldn't agree more about SAP... We had numerous vendors switch to SAP about a year ago and we do not use those vendors anymore because the problems it caused. They are still digging out of the crater it created.
We switched from one ERP system to our new one over the weekend with no issues at all. Their SAP implementations have been going on for months now with nothing but problems.

We have been really happy with our current ERP software Made2Manage. But it's not cheap either...
 

RE: external BOM / parts list database suggestions...

If you don't possess an ERP system and don't entend to buy one, then stick with using Excel.  It is easy, robust, translates to dozens of engineering software packages and stays usable even as Excel matures.

It is easy to program and easy to find support and help online.

By far the shortest learning curve and the most cost effective.

RE: external BOM / parts list database suggestions...

My wife has been tortured by poor SAP implementation and training. I won't say where. She now needs yoga, meditation, contemplative prayer... MS Access might work if you are good at it but carefully read thick books on configuration management FIRST. I have done two Access databases that are still used. One is used at a medical company and another at an aviation company. They don't pretend to be full ERP systems. They do what ERP can't: Managing documents to maintain specific compliances with things like external standards and ECOs. Not parts, for the most 'part'. The best solution would probably be a system like Made-to-Manage with a limited Access database for other stuff not in the ERP. I checked out M2M awhile back. They looked good but we couldn't afford it. Sorry OTHGWayne, but Excel is not right for keeping data. Spreadsheets are great for many things, but if you need to keep important data properly organized by any more than one single person then do it in some sort of database.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources