BOM Changes

[Chris Kelleher]

Hi peggers,

I like to make changes to the product structure. These changes can be
additions, deletions or modifications. Is it possible to do this with a
progress program or do I need to use a CIM load?

I prefer to use a progress program, but I like to know how I can be sure
that changing the ps_mstr table will not infect other tables? Or are these
releated tables automaticly updated with the ps_mstr?
Do I need to change the work order tables also (manualy) for the released
work orders, because they will also have a new product structure?

The changes will be read from a text-file, and I like to use the MFG-PRO GUI
interface to load my program.

Kind regards,
Wim.

P.S. We are using MFG-PRO 8.6E and progress 8.3A.

*********************************************************
* T H O M S O N - C S F S Y S T E M S B E L G I U M *
*********************************************************
Wim VAN BALEN
Design Engineer
Berkenrodelei 33, B-2660 Hoboken, Belgium
Tel: +32 3 820 5071
Fax: +32 3 820 5004
General fax: +32 3 820 5000
General Tel: +32 3 820 5011
E-mail: Wim.VanBalen@tsb.thomson-csf.com
*********************************************************

 

[Chris Kelleher]

Wim,

Have you already looked into using the Product Change Control Module.
The PCC module provides functionality for change management, exactly what
you seem to require.

Apparently you are creating the changes elsewhere and import them
afterwards. Maybe the PCC import functionality can help you out.

The changes in the product structure will not reflect on the work order bill
if the status is exploded or higher.

kind regards,
Danny Gaethofs
Origin QAD

 

[Chris Kelleher]

Wim,

see my answers below

Wim.VANBALEN@tsb.thomson-csf.com wrote:

> Hi peggers,
>
> I like to make changes to the product structure. These changes can be
> additions, deletions or modifications. Is it possible to do this with a
> progress program or do I need to use a CIM load?

The recommended, safe and supported way of loading data into MFG/Pro is through
the CIM load interface. It's not pretty, it's not fast but it's safe. After a
while, you get a "hang" of it and it's not as hard and clumsy as it is at the
start.

Depending on how you change your product structure data you can make it harder
or easier on yourself. You should not delete or modify your product
structures. Once a certain structure becomes "invalid" you should use the
effectivity dates to make sure you won't use it again in its present form. The
main advantage of this method is that you keep a historical view of how your
structure has changed through time.

> I prefer to use a progress program, but I like to know how I can be sure
> that changing the ps_mstr table will not infect other tables? Or are these
> releated tables automaticly updated with the ps_mstr?

No, changing the ps_mstr will not change all the other required tables. Things
you have to keep in mind whenever you change your structures: product cost, work
orders, repetitive schedules.

> Do I need to change the work order tables also (manualy) for the released
> work orders, because they will also have a new product structure?

It depends on how you want your costs to be affected. If you don't update your
work orders once you change the structures you will record method variances on
the work orders. If you execute 16.22 WIP Material Cost Revaluation then the
BOMs related to the work orders will be modified and your WIP will be revalued.
If you're running advanced repetitive you will have to close your cumulative
work orders and so a new cum order will be created with your new cost settings.
Some or most of these processes can be avoided by correctly using the effective
dates on the product structure.

> The changes will be read from a text-file, and I like to use the MFG-PRO GUI
> interface to load my program.

If you're going to do a CIM load you can't use the GUI version of QAD. You have
to use a character version in order to do it.

I hope this helps,


Carlos

--
=======================================================
Carlos Colmenares http://www.protech.com
Senior Programmer ccolmenares@protech.com
Protech Systems Inc. (609) 714 0700 - Ext. 50
PEG Member 1999061404
I'm the only one to praise/blame for whatever I do/write/say
=======================================================

 

[Chris Kelleher]

Wim,

First off, you can't do deletions via CIM. It just doesn't do it.

Second, I'd be wary of direct database updates. We do not enforce
referential integrity at the database level; we do it at the application
level. So you'd need to review the programs and the source code cross
reference to ensure that everything else is updated.

Third, I'd suggest using the Product Change Control module, as has already
been mentioned. It provides ECN (and thereby BOM) import and export
capabilities, which would allow you to format data from the outside world
and load it in as an ECN, which can then be incorporated and implemented.
Probably the safest way, all around.

And for the record, any kind of batch-type process is usually better served
by running in character, not GUI. GUI implies, if not mandates,
client/server, and your performance will be slower by definition. You
should have access to character MFG/PRO even if you're running on an NT
server; just get the code from your distributor and make sure (if on NT)
that you also get the self-service character client from Progress (it's
free).

Good luck.

Scott
===============================================================
Scott M. Dulecki /* 1998061901 */ +1 616 975 6322
Senior Technical Consultant scott_dulecki@qad.com
QAD, Inc. http://www.qad.com
1188 East Paris SE Grand Rapids, MI 49546 USA

Next Michigan Progress Users Group: 19 April 2000
Next Midwest MFG/PRO Users Group: 20-21 March 2000

All opinions are my own, and don't necessarily reflect those of
any other living being.
===============================================================