I feel defeated with such an easy task but here is what I have...
Background: We are a sales, production, and service company primarily focusing on Industrial Manufacturing Facilities. We can sell off the shelf solutions from our vendors or we can design, engineer, and produce custom solutions with or without installation and general contracting services. Thus making everything we do a challenge...I have never heard our sales team say NO! After recently implementing NetSuite into our workplace I have moved into a "Phase 2" approach and have been targeting each stage of our Sales Life Cycle starting with Opportunity first. One of the major issues we are currently having is with the communication of the "Job Details" for any job requiring custom engineering or services. The goal being to design a form that Travels with the Order throughout the entire life cycle that can identify the following items: Labor Hours Required, Scope of Work, Safety Assessment; Production and Labor Budgets (see below)...so on and so forth.
Issue: I have no idea where to begin with the design and implementation of a custom record form capable of hosting "Job Details" information. One of the things I would really like this form to do is to have a list similar to the canned "Items" list but setup where the sales team can enter in new or select from existing records. An example may look like this...notice 3 columns for "Expense", "Cost", and "Description"
Steel - $2500.00 - Steel required for fabrication of dunnage rack "ABC-123"
Paint - $350.00 - Paint pricing for all 3 racks
Engineering - $1250.00 - Engineering fee for redesign of existing dunnage rack to accept new parts
**Add New Line Feature - Similar to item list for quotes, sales orders...etc.
I want these items to be saved but I do not want them to be a part of the "Item" list.
My thoughts so far on options or avenues of approach...I am not a developer but could figure out some basic scripts with a little time.
1. Utilize NS Opportunity Form and Customize with new subtabs, fields, and list. My issue here is not being able to remove the "Items" section of the NS Opp. Form and/or creating a new list similar to the "Items" list. Requires the least amount of work from an admin standpoint...which by itself make this avenue the most appealing.
2. Create Custom Record Form and Design it to be called upon if certain fields such as "Requires Installation" or "Requires Engineering" fields are check on the Opportunity Form. The issue here is the same as above...only now I have to deal with this on a custom record form.
I am hoping someone on this forum has done something similar to what I have listed above...I don't feel as though it is asking for to much but being so new to this software I can't quite wrap my head around the "Best Practice" of this task as there are so many avenues under Customization.