In NS there is not a native way to populate items from a pre-defined list of items (estimate templates). Since each project of my company is always based on a list of similar items and services, I need to find a way to create “Estimate Templates”. There is a feature under Invoices that allows users to create an estimate from the invoice simply by clicking the Renew button. However, this solution will require to create a new Estimate from a template Invoice and then link it back to the Opportunity. I don't really like this solution and if you link back the Opportunity it does not automatically transfer all the info that would usually flow from the Opportunity to the Estimate. Also, is not the natural flow since we always start a project from an Opportunity.
For this reason, it would be preferred to be able to generate the Estimated directly from the Opportunity and be able to add “pre-defined list of items” (template) directly in the Estimate subtab Item List.
This functionality can be achieved by creating Item Groups.
NetSuite allows you to create Items Groups. The member items of the group can be any Items (including other Item Groups, Description and Subtotal, discount etc). I could create pre-defined Item Groups like: Rough-in material, Mechnical Equipemnt, Controls, Layout Services, Design Services, Start-up etc that can be used to quicly create the estimate from scratch and also higher level Item Groups that includes some of these pre-defined Item Groups (e.g. Complete Project or Control Only Project). Item Groups can also have the quantity of item members set to zero. Once an Item Group is added to the Estimate’s item subsist, it automatically populates the next item lines with its member items. The user can make changes to the quantities (preset to 0), add and delete member items.
I’m not sure if the Item Group was designed also for this purpose but seems like it works well as pre-defined item list to be used as a “template” to quickly generate an estimate.
In the Item Group there is a setting DISPLAY COMPONENTS ON TRANSACTIONS that will show all its member components. This is critical for this purpose.
From my preliminary investigation it looks like Item Groups can act well as "predefined item list" (Item templates) to facilitate the creation of an estimate. At the moment I couldn't find any drawback. The only small issue is that when I use the Advanced HTML/PDF template there is the End Item Group that visualize the total it the Item Group and it is misleading and I need to find the way to eliminate this line from the print because it will be confusing (Any suggestions?). Unfortunately can not be eliminated (it requires to delete the whole group).
I'm kind of new to NetSuite and wanted to ask for an opinion.
Thank you! 🙏
Alessandro Arnulfo