Raw Material Generator - Issue Purchasing List & Tracking revisions

[lgracio]

Hi Everyone,

Let me know if someone are able to help me on this, providing some tool or info about database generator or knowledge regarding how is the best way to create a Raw Material Generator to put information on purchasing department, if I have several lists of raw-materials for each category, where source information is coming from drawings, BOM's, etc. The issue is the controling and tracking the changes from drawings/BOM's, keep the Raw material Lists updated equal to the source documentation, and update the all old revision lists. The challenge passes by producing a table database where is very complex, in order to track/replace/updating information constantly from designers. Before put the raw material lists on purchasing I have to know what material is available on stock and/or what is the best length to buy to fit on partial items to be worked out.

Luís Grácio
Mechanical Engineer (Energy Solutions)
Portugal-Setúbal

 

[KENAT]

It sounds like you may be talking about an ERP system. We use SAP, though I'm loathed to recomend it. You may also be talking about a PLM system.

Google these 2 terms and see if it helps.

KENAT,

Have you reminded yourself of faq731-376 recently, or taken a look at posting policies:

http://eng-tips.com/market.cfm?