Skip to Content

Tracking batches but expensing item

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!


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 24, 2018 at 05:41 AM

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

    Add comment
    10|10000 characters needed characters exceeded

    • 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.