Hi,
So I'm kind of new to custom records, but I found a use for them for a functionality we specifically need.
The requirements are to have basically a third party warehouse system where we store items that have no actual inventory value and we charge for holding the items for a certain amount of time as well as sometimes we kit the items before going back out.
I thought about doing this with Netsuite's normal warehouse system, but also being a warehouse distribution company it just posed too many problems to try to run the items into other third party warehouse locations. For instance:
1. We'd have to bring in the items at 0 value and thus it could throw off our costing.
2. We have numerous locations where we house our own inventory as well as store inventory, and I don't want the two different types mixing. (Thought about using alternate SKUs, but I argued against this move as basically we'd wind up with a ridiculous SKU list that would eventually become unmanageable at some point in the future.)
3. Etc.
So my proposed solution is to make a custom record called "Storage Units". I've made a field to attach a customer to them, they have a location select-able, and other various data points in the header such as date received (not through item receipt, it'll just be noted as received), date shipped, days in storage, etc.
Then in order to get lines in the custom record, I've created another custom record called Storage Item. This references a storage unit, allows one to select an item from our normal SKUs, add in quantity, a received checkbox, a shipped checkbox etc. Then I created a sublist for the custom record Storage Unit referencing the storage items associated with that unit.
Here's my question: Is there a way to create a custom record where you have an item sublist without having to go this route of a second custom record? Is there some way I can have a sublist like on a sales order or purchase order or any transaction where I can allow the user to enter line items directly into the storage unit?
Also, as a secondary question, is there a way to allow users to print the custom record in some format where they could read these items?
tl;dr : Can you add a sublist to a custom record like the sublists on sales orders, purchase orders, other transactions, etc.
Thanks