Part/BOM Sold Counts

Epicor ERP 10
1

Hello folks,

We have parts that have BOMs of other parts we manufacture.

We’re looking to get counts of any part – whether a part sold direct or a part of a part. For example, we sell trays that slide into tackle boxes. We sell these trays on their own or as part of a tackle box – so we’d like to see a count of qty consumed (either sold direct or as a part of a tackle box).

Is there an existing tool that shows us quantities sold of a PartNum for a given timeframe? We’re trying to ramp up our materials team’s Epicor knowledge so they can do this the right way, but in the mean time we need to determine these consumption quantity counts so that we can see trend data over the last X months, and help us establish reorder MINs based on that sales consumption rate.

I have a UD dashboard already that shows sales orders containing that part, but that doesn’t delve inside parts where the part we’re look for is used inside (eg. doesn’t look inside the BOM).

Any tips/thoughts?

2

this is hard, because it is harder to determine “When” the item was used… is it when you shipped the top item, or when the tray was put into the top item during assembly.

I would rather look at a simpler number that shows “How many trays were consumed” and “Where”.
Look at the PartTran table. It shows all Ins and Outs of a part… then look at the transaction types. anything with an “STK” at the beginning is coming from stock and going (consumed) somewhere. This table shows date and where it was consumed. It will show the Job it was issued to or the Sales Order it was shipped on.
Careful… this has LOTS of data in it if you do lots of transactions. Typically you may want to summarize this data.

3

I’ll give this a try and report back… Thanks!