Tracking batches but expensing item

[former_member42743]

Issue: A manufacturing suite utilizes tubing to transfer a raw material from the drum to the manufacturing equipment. The tubing is in product contact so we want to track the batch number of the tubing used. The box of tubing has 500 ft. of tubing,. Approx. 30 ft. of tubing is used for each process order. How to consume?

We want to do a one time expense of the box (BOX UOM), to a manufacturing cost center when a new box comes in to the suite. This writes the inventory off. When we process the process order we want to include the batch number of the current box of tubing in the room. We also want to see the tubing in the batch where used list. And we want the tubing material number in the BOM to show the operator that 30 ft. of the tubing is to be cut and used.

So basically we need to expense by the box when it is moved into the suite. But somehow include the material number in the BOM, and record the batch number against the order so it can show up in the batch-where used list. This is so that if a batch of tubing is later found to be defective, we can see what final products had their raw materials transferred via that batch of tubing.

Any idea on how this can be accomplished? I can't believe this hasn't been asked before.

Thanks in advance!

Craig

[JL23]

never touched it myself, but documentary batches seem to fulfill exactly this requirement

[former_member42743]

Thanks Jurgen! I forgot all about those. I've never used them either but I read about them years ago. I'll have to see if I can set it up and test with them to see exactly how they work. But it looks like a potential solution.

Thanks for reminding me about them!

I did some searches but any of the key words I used never pulled up any links to documentary batches.

Craig