Temporary table and BOM single level

Yahoo Archive
1
Look at the BOM cost Crystal report



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
amelie.pelletier2
Sent: Friday, May 10, 2013 8:56 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Temporary table and BOM single level





Hi Everybody,

I'm working with Epicor 701. Right now, I'm trying to develop a code in sql
to do the following job:

We have parts that contains partmaterial that are themselves containing
other part material and it goes on and on.

I need to make the sum of the materials that are called more that one time
for the final part.

I explain a little bit more... I have a table, I put a top and four legs on
it. On the top and on the legs, I have wood and paint. So, I have:

Table call a top with wood and paint. Table call a leg with wood and paint.
I need the total of wood and paint to do a table.

It seems simple, but with a lot of level, it begins to be trickier.

I need that to be able to work the final cost of my final pièces.

Did anyone of you already made something similar?

amelie.pelletier2





[Non-text portions of this message have been removed]
2
Hi Everybody,

I'm working with Epicor 701. Right now, I'm trying to develop a code in sql to do the following job:

We have parts that contains partmaterial that are themselves containing other part material and it goes on and on.

I need to make the sum of the materials that are called more that one time for the final part.

I explain a little bit more... I have a table, I put a top and four legs on it. On the top and on the legs, I have wood and paint. So, I have:

Table call a top with wood and paint. Table call a leg with wood and paint. I need the total of wood and paint to do a table.

It seems simple, but with a lot of level, it begins to be trickier.

I need that to be able to work the final cost of my final pièces.

Did anyone of you already made something similar?

amelie.pelletier2