I'm curious if there is a best practice, or at least a consensus to setting up inventory. There are likely lots of variables but would welcome input and suggestions from those who have gone through the trial and error.
First, we are not using website ordering so my concern is with sales people doing quotes/estimates out of NetSuite directly.
We, like many enterprises, have a published price list, a set of products with model numbers and list prices as well as discount classes (identifying maximum discounts allowed). Sales people use this price list to develop quotes.
The model numbers and specific line items of a price list many times have a one-to-one relationship with an inventory product that has an internal part number different from the price list (internal part numbers are created and managed by operations for their tracking and management purposes). Many other times however, a single item on the price list may relate to multiple items that actually get fulfilled. Here's two examples:
Example 1:
Price List:
Part # abc123 Server Class I w/RedHat Enterprise
Inventory that fulfills the above:
Part # CS-0001-01 Dell xxxx single processor server - 1U Rack Form Factor
Part # CS-0234-01 Red Hat Linux Enterprise vX build Y
Example 2:
Price List:
Part # SW-00301 Enterprise Software v3.01
Inventory that fulfills the above:
Part # CS-020301-03 Enterprise Software v3.01.03 Product Disc
Part # CS-040001-01 Software Container Box
Part # CS-040002-01 Software Container Cardboard Insert
Part # CS-080301-03 Release Notes v3.01.03
For example 1, I have identified the price list item as a Kit/Pkg (which has revenue account assigned so therefore shows up in the drop down items menu for sales people doing quotes). I have assigned inventory as members (which has CoGS so costs are tracked properly and pick lists are printed correctly but does not have revenue so does not show up in the item drop down so sales people don't see.)
For example 2, I have again identified the price list item as a Kit/Pkg (with revenue account so it shows up in the quote drop down for sales people) but this time I have created a finished product assembly called CS-010301-03 with the members of the assembly the items above. I did this so that a number of these could be packaged and put on the shelf ready to ship as well as be able to assign CoGS to the lower level individual items. It also seems to provide a good task list that all these items are needed to package software for shipment.
In both cases, it is important that sales people only see items that are "Price List" based and fulfillment/shipping know only the actual physical items that need to be put together to ship. Also, we want reporting of revenue and CoGs to be appropriately identified (revenue against the price list items, CoGS against the actual physical items/materials that need to be ordered and stocked. For one-to-one items, I still do a Kit/Pkg with the price list part # assigned the revenue account and a single member item assigned the CoGS. I know I don't have to do this, but it just keeps things more consistent from a departmental tracking standpoint.
It seems like the right approach, but being new to NetSuite and to inventory management in general, was hoping to get some validation or correction.
Thanks.
-Steve