Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Subtracting Parts used in Manufacturing (Inventory Management)

941 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Suzanne_Ransom
4 - Data Explorer
4 - Data Explorer

I'm trying to create an inventory management base. I have two products that use several parts to make. I want to be able to enter the quantity when I buy the parts, and then when I manufacture, have those numbers subtracted from the quantity of each part.

So product COF01 uses 1 jar, 1 lid, and 1 desiccant with 70 grams of coffee. I don't know how to get the 1000 quantity manufactured to translate back to deducting 1000 pieces from each part and then 1000x70 from the coffee product.

In my products table, I don't know if I can list all the supplies in one field or if each piece needs it's own field.

I feel like this should be simple but I'm completely stalled.

0 Replies 0