Sage 100

Does anyone still have clients that are electronics manufacturers who manufacture here in the US. We have a prospect who buys all the components, packages them up and send to contract manufacturer. The challenge is they have to send reels of small parts and track the reels balances back into stock. Is anyone doing this? we want to lot# the reels so they can track quantity on the reels, i.e. available for future use and due back from contract mfr.

I'd think that is a problem for other manufacturers as well. I know something similar has been discussed before. What is the issue you are trying to solve exactly?

@ClaudiaGallegos - I use lot and serial numbers quite often for my manufacturing clients and have also used them with clients that have virtual mfg vendors. The system works well if you plan well. If they don't have a lot of contract manufacutures then setup multiple warehouse one for each of the contract mfg and transfer parts (when the ship to the vendor) to their warehouse. Then run your boms/wos and set the parent warehouse to the vendors warehouse. When the vendor sends the completed items back use another warehouse transfer to move back to the clients warehouse. That's assuming the cleint retains control of the parts/component inventory.

I used to have a client that sold electronic connectors on reels. The Lot# method works great as long as they don't mind costing by lot. If this POS had native bin capability (FYI, Business One is getting that finally in January) you would just create a bin per reel and the contiguous # of feet would be the quantity in the bin.

Miora, thanks for your suggestions. You hit the nail on the head but the issue they see is: the list of parts is long, so doing standard transfers seems cumbersome. And i have now spoke with two of our clients. The prospect transfers the whole reel of components to the contract mfr but wants visibility to see what they have on the reel that will not be used. I think this all can be done in standard mas but again when the list of components is long, it will make the transfer data entry long. The only thing i can think of is to get a modification to handle this. By having the IM transfer read the BOM's components list into the transfer screen. Does anyone know a developer who has written something like this already?

Claudia (and I'm not your typical partner because I'm more involved in the existing market than selling new deals) I think you're in a very weak area of Sage and it will be important to look ahead 5 years to what functionality might be required. In many cases when I've had to squint real hard to see the fit the reality is that there isn't a great one.

@ClaudiaGallegos since I don't know what modules the client owns, @WayneSchulz point may be more or less valid. I don't think BoM is going away but true WO is still a legacy module. The transfer, btw, of the completed items would only be at the top level bill so there won't be any individual components to transfers, they'll have been consumed during the production entry process (parent/component whse).