Looking for advice on how to setup our inventory for this use case. I know netsuite has the 'package' and 'unit of measure' records, but I don't think those are the right use case here.
How do you handle inventory purchased from a vendor which is offered in multiple package sizes?
For example, lets say the product is screws. Lets say our vendor has the ability to purchase:
- 1 'individual' screw for $1
- a 'Box' of 100 screws for $80
- or a 'Case' of 1000 screws for $500.
Sometimes we may purchase any of these types of 'packages'. Then we may turn around and sell any given quantity to a customer at the weighted average cost.
We can't figure out how to accomplish this in Netsuite. The Unit of measures seem more suited for 'generic' type quantities. Each of our thousands of products come in different package variations (one may be a 'box' of 5, one may be a 'box' of 100, for example). So unless we want to essentially create a unit of measure (type) for each and every product, I don't think that is the right approach?
Additionally, when we go to create a purchase order, how do we specify which 'package' we want to order? Maybe on the same order we want to order a case of 1000 + 3 boxes of 100 each. Obviously just typing in '1300' is going to be problematic for both the vendor receiving the purchase order, and the warehouse receiving the shipment.
How should this be handled in netsuite inventory?