Full Piece vs Partial Inventory

Hello,

Does anyone know what the standard way to handle full piece items vs partial items is in the inventory management world? We currently keep our full piece steel sheets in an entirely separate warehouse within Sage even though it's physically in the same warehouse. This causes some confusion when it comes to run reports for and process through physical inventory due to having to basically combine the two warehouses to get the information correctly for our one true physical warehouse.

I suspect that this is not how it should be done, and instead full piece should be added into a location/bin like everything else within the main warehouse. What is the recommended way to do this? One bin for full and one bin for partials? Full sheets and partial sheets currently share the same item code, what differs is the amount of steel available. Currently we store metal sheets on site but are only charged for what we use which is why keeping the distinction is important for us. Perhaps two different item codes, one partial one full?

Any recommendations? Thanks!

Parents
  • 0

    Create a second part number is another way.  The full piece item would be 123456, the partial piece number would be 123456C (C=Cut).  If you pull the full piece, it would be 123456.  Any leftover would be put back into inventory as 123456C.  Depending on how precise you want the process, you could make the "C" item a lot # valuation which would allow tracking of the cut pieces (print a bar code label with lot number to place on cut part).  A different type of complexity but IMHO working with two part numbers in ONE warehouse is a lot easier than working with one part number in TWO warehouses.  I used this process 25 years ago with MAS90 3.5 and it worked well at the time.

    I would recommend lot # tracking for the cut pieces if knowing individual pieces is important.  An example of this is I need 5,000 feet of uncut cable.  I have uncut cable in 10,000 foot spools.  I also have 9,000 of cable under the cut part number.  Should I use the cut number to fulfill the order?  If lot # is not in play with the cut number, you don't have an easy way to ascertain the optimal decision (full or cut).  This actually happened to me.  I ordered 5,000 feet of uncut fiber optic cable and received two partial spools.  NOT happy!

Reply
  • 0

    Create a second part number is another way.  The full piece item would be 123456, the partial piece number would be 123456C (C=Cut).  If you pull the full piece, it would be 123456.  Any leftover would be put back into inventory as 123456C.  Depending on how precise you want the process, you could make the "C" item a lot # valuation which would allow tracking of the cut pieces (print a bar code label with lot number to place on cut part).  A different type of complexity but IMHO working with two part numbers in ONE warehouse is a lot easier than working with one part number in TWO warehouses.  I used this process 25 years ago with MAS90 3.5 and it worked well at the time.

    I would recommend lot # tracking for the cut pieces if knowing individual pieces is important.  An example of this is I need 5,000 feet of uncut cable.  I have uncut cable in 10,000 foot spools.  I also have 9,000 of cable under the cut part number.  Should I use the cut number to fulfill the order?  If lot # is not in play with the cut number, you don't have an easy way to ascertain the optimal decision (full or cut).  This actually happened to me.  I ordered 5,000 feet of uncut fiber optic cable and received two partial spools.  NOT happy!

Children
No Data