When I set up our Pricebook, I tried looking ahead to inventory. Because of the nature of garage doors being a combination of many parts, I worked under the premise that you have to inventory all of the parts that make up a door, not the whole door itself, to have a meaningful count. The result was a Pricebook in which full garage doors were Equipment and all of the component parts were linked Materials. The perceived benefits of this were that we could accurately track inventory with linked Materials, but that we'd put Equipment on Estimates and Invoices so that we don't have to manually add the Materials to each installation job. But this has a number of problems:
I hear folks in here advise to "simplify" the Pricebook. However, one of my assumptions has to give in order to do that. It sounds like this isn't how other folks do their inventory, but then I'm not sure how that's an effective inventory count.
One idea is to stop using Equipment and start using Services w/ linked Materials to track inventory parts. For ex, the Service "16x7 Non-Insulated White Short Panel Installation" (for lack of better name right now), and then all of the panels, springs, etc. would be linked. This solves the double costing problem but not the Pricebook size problem, so I'm not sure which way to go and hoping for some guidance. Thanks for reading a lengthy post and thanks for any guidance.
Happy to hop on a quick 15min phone call with you and share my experiences with how to best make the pricebook work for garage door companies. Just send me a direct message and I will share my cell phone. I am pretty open tomorrow if you have time. If not, I will be at Pantheon next week, so if you are going to be attending that, we can meet up as well. Let me know what works best for you. Adam