Lot Consolidation

Epicor ERP 10
1

Is there a built-in way to do lot consolidation? We sometimes have the situation where we have many lots of one part that we want to combine into one.

For instance we have 22 lots of a single part that we’d like combined into one. Is there a built-in process or screen that can do what inventory transfer or qty adjustment does and move them all to a specified lot?

Alternatively, we’re going to need to write some kind of external task that runs on a schedule.

2

Yes, you can use Inventory Transfer to do that. Just overwrite the existing Lot to the new one.

3 Likes
3

I know it can but my question is there a way to do it en-masse?

4

You could always do a DMT. Or you could create a function.

2 Likes
5

the way that I would do that, AND keep your tracability:

  1. create a job to “make” the part “X”, lot “COMBINED”.
  2. add one material… Part X into the job
  3. issue all the lots of the material that you want combined into this job
  4. Receive the “completed quantity” into the new “Combined” lot

This offers the best foolproof way to keep track of what was done, and when it happened for full tracability.

(but otherwise, there is no standard process to do this)

4 Likes
6

Liking that. Doing the reverse you would use, I’m assuming co-parts.

Example use: taking a pack of timber that had a lot number allocated to it and cutting it into two or more lengths.

1 Like