Report quantity/receive to stock in different UOM than on Job

Hey folks,

In a steel mill, we melt raw material scrap steel and produce steel billets for a variety of uses. Steel billets that don’t meet specifications for length, grade, etc. or aren’t usable for another purpose are returned to the raw material scrap bin for melting in a new batch. This type of scrap is called Cut Billets because the billets are cut up and loaded into a rail car.

We have a custom process completing and receiving prime and alternate grade billets, but a process for the scrapped billets going back into raw material scrap is pending.

Issue:

• We need to calculate and process scrapped billets into a Cut Billets raw materials part.

• Our prime and alternate grade manufactured billets are in a UOM of EACH, so the job UOM is in EACH.

• The Cut Billets part UOM is in LB, not EACH, so we can’t just add a coparts line on the job to complete to WIP and then receive to stock.

• Items valued in standard cost, but a pound of cut billet needs to have the last/average costs maintained.

• Billet material to return to raw material scrap is kept in “Scrap Feet,” in which a foot of scrap weighs 84 pounds.

Solution?:

• Create a new part, something like Temp Scrap Billet with a UOM of EACH.

• In the existing custom form, when we click the Complete Billets to WIP (report quantity) button, also complete a number of Temp Scrap Billets (Scrap Feet / 50). Eaches are in integers, so this would round up if less than 1 or round normally if greater than 1.

• When we click the Receive Billets To Stock (job receipt to inventory) button:

• Receive Temp Scrap Billet to stock

• Transfer Temp Scrap Billet (each) to Cut Billet (lbs). (via some method)

Question:

Any experience with this approach out there? I could create and process a job to issue x Temp Scrap Billets for y pounds of Cut Billets, but this seems like a long way around.

Thanks,

Joe

Adding to say that we considered job receipt to salvage, but we are in effect producing new raw material from the defective manufactured item and not “un-issuing” material from the BOM, although the part is on the BOM.

Joe