We have an eyewear line whereby we buy all the packaging from vendor A, send to vendor B and Vendor C. Vendor B and C, we purchase the eyewear from and labor to assemble into our packaging. Vendor B/C sends to us the Finished item, as well as drop ships to our bigger customers in bulk.
We do hundreds of sku's due to style, colors, different lens, etc,. and creating a WO for each assembly is a horrendous task. Since we own the packaging and are shipping to vendor B, this is the only way we see that we can get the roll up costs in Netsuite for the
Glasses (vendor
Packaging (Vendor A)
Labor (Vendor
And manage our inventory quantities, etc.
If we do a SO/DropShip order in NS, the WO side is fairly easy as we can click on the Create WO on the SO and it is done. With a direct shipment to our warehouses (we have 3 locations) we enter the PO to Vendor B for the Glasses, then do a corresponding WO for each line/item on the PO to our warehouse locations for the qty of the finished item they are going to receive. Upon receipt, we have to receipt the PO, then do Build WO for each line that was received on the PO. Again, this can be a 100 line item PO and this task is daunting to say the least.
I tried using the "Phantom" item logic and was hoping it might be an option but no go....
I can't image other companies don't have a similiar situation that they have dealt with ? Is there a way to enter the FG item number from vendor B, but have it roll up the costs so the FG item is costed correctly that I'm not aware of in NS ? I don't see any option for "value added" etc on an assembly item.
Any ideas would be very helpful !!!
It is not an option for vendor B/C to incorporate the price of the packaging into their costs and we have them buy the packaging direct from our vendor, as they all want to upcharge this anywhere from 25-40% which is ridiculous.