If i buy a Tank of refrigerant that is 25Ib and the cost is $500, how do I keep the track of replenishment in purchasing module.
if my item is “Tank of R-410” with cost $500. I can simply create a PO with that item and request 1 or 2.
however when I am selling a task that has a linked material of 1ib I have to do the math and create 1/25 Ib= 0.04 Ib for 1Ib of r-410a task. Now when we sell that service, in the replenishment I will see 0.04 and …. Which I have to go and add those decimals and ensure when It getting closer to 1 I get one Tank. Is there an easier way for this kind of items?? Any input will be appreciated
Solved! Go to Solution.
Yep! That's exactly what we're doing right now, keeping the bulk quantities as the 1 unit of inventory and consuming them with less than 1 quantities. Definitely looking forward to the multiple unit of measure feature!
This does fix the problem in a sense, but is ultimately a work around as the 25 lb tank is really one unit from the purchasers perspective. This would complicate dealing with cost changes, which are a common thing in 2023. We deal with it ourselves as we order multiple inventory items in bulk on a pallet or on a roll and consume them in much smaller amounts.
There was supposed to be a Unit of Measure feature rolling out that would fix this very problem but I haven't heard any more about it. I'll post the section and copy the link to the article here:
Items can be ordered at one Unit of Measurement and consumed at a different Unit of Measurement.
Reduce vendor confusion when placing orders.
Eliminate the need for multiple part numbers to maintain accurate stock levels.
Define multiple ordering and consumption units of measurement.
Howard says this one is a big deal, especially for contractors who may buy certain parts in bulk, but only use a small portion on each job. Without this feature, he says, it’s like using one screw on a job, but saying you used a whole bucket of screws.