Skip to main content
S
sweetesthoneybee
March 6, 2020
Solved

Buying in lbs, Selling in feet in inventory

  • March 6, 2020
  • 1 reply
  • 0 views

Hi! Please help. I'm at my wit's end. I've called support upwards of 10 times and each time I get a different answer. I'm in manufacturing. Think of it as playdoh. They are sold by weight (lbs), then you extrude them so they come out as long strips of shapes. They can be thick or thin. Depending on thickness, it can affect the length of possible extrusion. For example, 1 lb of playdoh can extrude 14ft of star shape. Or 1 lb of playdoh can extrude 18 feet of heart shape. I sell the extruded product by the feet, in bulk or in kits. Bulk can be 500ft or 1000ft, etc. Kits can come in 8ft, 10ft, 200ft or 300ft, with poly bags and alcohol preps.

I am unable to convert the raw material playdoh into extruded feet in UOM. Can someone please help me? No one seems to understand how to do it or if it is even possible.

Best answer by IntuitLily

Let me be the first to welcome you to the Community, @sweetesthoneybee.

 

You can convert the raw material into feet using the Build Assembly feature. Let's create first an inventory item for the playdoh and use lb for the UOM.

 

Here's how:

 

  1. Go to the Lists menu and select Item List.
  2. Click the Item tab at the bottom and select New.
  3. Select Inventory Part for your raw material and enter the Item Name.
  4. Add a new U/M Set and select Weight.
  5. Click Next and choose Pound (lb).
  6. Tap Next twice then Finish.
  7. Enter all the necessary details for this inventory before clicking OK.

Next, create a new item for the Inventory Assembly:

 

  1. Go to the Item tab again and select New.
  2. Choose Inventory Assembly Type.
  3. Based on your example, you may use star shape as the Item Name.
  4. This time, choose Length on the U/M Set and click Next.
  5. Select Foot (ft) and click Next twice.
  6. Tap Finish when done.
  7. Enter the Bill of Materials by choosing the raw item you first created.
  8. Then divide the (lb) by (ft) and enter it as the quantity.
  9. Fill in the rest of the needed details before clicking OK.
  10. Repeat these steps for the other shapes.

Once you're done, you can now build assembly for the assembly items you've created. You can check this article guide to learn more about the process: Combine your inventory items to build finished goods.

 

If you have additional questions with the setup, do let me know. I'm always here and ready to help. Have a great day!

1 reply

IntuitLily
IntuitLilyAnswer
March 6, 2020

Let me be the first to welcome you to the Community, @sweetesthoneybee.

 

You can convert the raw material into feet using the Build Assembly feature. Let's create first an inventory item for the playdoh and use lb for the UOM.

 

Here's how:

 

  1. Go to the Lists menu and select Item List.
  2. Click the Item tab at the bottom and select New.
  3. Select Inventory Part for your raw material and enter the Item Name.
  4. Add a new U/M Set and select Weight.
  5. Click Next and choose Pound (lb).
  6. Tap Next twice then Finish.
  7. Enter all the necessary details for this inventory before clicking OK.

Next, create a new item for the Inventory Assembly:

 

  1. Go to the Item tab again and select New.
  2. Choose Inventory Assembly Type.
  3. Based on your example, you may use star shape as the Item Name.
  4. This time, choose Length on the U/M Set and click Next.
  5. Select Foot (ft) and click Next twice.
  6. Tap Finish when done.
  7. Enter the Bill of Materials by choosing the raw item you first created.
  8. Then divide the (lb) by (ft) and enter it as the quantity.
  9. Fill in the rest of the needed details before clicking OK.
  10. Repeat these steps for the other shapes.

Once you're done, you can now build assembly for the assembly items you've created. You can check this article guide to learn more about the process: Combine your inventory items to build finished goods.

 

If you have additional questions with the setup, do let me know. I'm always here and ready to help. Have a great day!

S
sweetesthoneybeeAuthor
March 7, 2020

@IntuitLily OMG! THANK YOU SO MUCH! It worked! The critical step that was missing is Inventory Assembly step 8. Dividing the lb by ft and entered as the quantity in the BOM. No one knew how to help me and told me this was impossible to do and it was a Quickbooks limitation. I truly appreciate your help!

Terms & ConditionsAccessibility statement