Hello,
I work for a company that is implementing a Netsuite system, and we have to rethink our internal SKU system and I'm wondering what is the best way to approach this in NS.
So in reality we have 2 Customers who both take the exact same base item. For the purpose of this exercise let's use FoodItemA as the name (in netsuite this will be a lot numbered inventory item).
Our stock comes into our warehouse in bulk cartons of 48. The easy part which I am clear on, is that I should create a purchase SKU in Netsuite of:
BULKFoodItemA48
In reality, these bulk cartons come into our 3PL - get broken down and assembled with packaging components to fulfill customer specific requirements
But in terms of how to capture finished foods in Netsuite - I've gone down a bit of a rabbit hole and am unsure how to proceed.
Now, both customers take FoodItemA but in different packaging configurations, and each customer has packaging components that are unique (i.e we cannot interchange). They also have their own unique SKU code that is referenced when they send us EDI orders. See below example of a breakdown of the components pre-assembly.
Customer 1:
Customer code via EDI: CUS1fooditemA
x6 Eaches of FoodItemA [lot numbered inventory item]
x6 Eaches of PackagingComponentA [inventory item]
x1 Each OuterComponentA [inventory item]
Customer 2:
Customer code via EDI: CUS2fooditemA
x10 Eaches of FooditemA [lot numbered inventory item]
x10 Eaches of PackagingComponentB [inventory item]
x1 Each OutercomponentB [inventory item]
In netsuite, the above will be assembled and become lot number assembly items.
So in terms of how we are developing the system, our orders come to us via EDI and will be routed to Netsuite. The plan is for there to be an automated process where these EDI orders are converted to customer specific sales orders - but in terms of how these are mapped leads onto the below..........
Now - my actual question. In terms of reporting I want to ensure I can track sales of FoodItemA and be able to check on a granular level, how much have I sold to Customer 1 and how much have i sold to Customer 2 i,e total sales of FooditemA = 200, but Customer 1 bought 150 and Customer 2 bought 50.
Do I create customer specific Bill of Materials for FoodItemA? If yes, where do I capture the customer Codes (CUS1fooditemA and CUS2fooditemA)?
Do I create customer specific lot number assembly items for FooditemA? I.e CUS1fooditemA and CUS2fooditemA? Would this require an item matrix system so Netsuite can understand it is the same product family?
Chatgpt is sending me in circles and thought i'd ask good old humans.
Hope the above is clear