Picklists for composite items

Picklists for composite items

We are an electrical contractor. We moved to Zoho earlier in the year, due to the diverse functionality offered, and the reps answered 'yes' to all of our questions in relation to functionality (as well as the promise of the 'imminent' release of a service management application). We, unfortunately, asked the questions "can we create kits to simplify selecting products for quotes" and "can we make picklists" separately, which, more fool us, lead us to think that we would be able to pick composite items on quotes, and then generate a picklist of items required for the composite item. On discovering this was not the case, we began looking into various avenues within the platform, and that maybe this is possible with some form of coding (without the use of a 3rd party application).
If we were to, for example, generate a sales order from a quote (we currently do not do this and take the accepted quote as the sales order) is there some way to 'intercept' the generation of the picklist? For Example
On selection of Create Picklist (from Sales Order)
For each item in list
If item flags as composite then
Add Associated Items and quantities
Multiply quantities by composite item quantities
Remove OG composite item
Next
Else
Next
This would (in my mind at least) run through each of the items on the sales order, check if it is composite, add on all of the associated items in the required quantities, remove the composite item, then check through all of the associated items (as they have been added to the list) and break those down as well. This would either then give a picklist in editable form (to modify for alternatives - we could not create composite items for every possible alternative for a service. Replacing a consumer unit is one single service, but has thousands of possible iterations for the items required), or a generated picklist that can be edited.
The issues I am currently scratching my head over are 1) is this even feasible to attempt, and 2) I don't really know how to code such a thing (yet); I don't want to spend days poring over various forums to build the code if it isn't possible to do in the first place.
Has anyone else attempted such a thing? I have seen it is not an uncommon issue that people have, but I'm sure there is someone else out there who will have thought to use a sledgehammer to open a nut.
Also, are we going to be able to associate goods to services in the FSM app, that would enable us to generate picking lists, materials consumed, etc which would in turn mean we could actually use the Inventory app as an inventory app, not just a long list of products and their prices. Such a thing would render my above query moot, assuming that the app is due to be released in a similar timescale as it would take to build the suggested workaround above.

    Access your files securely from anywhere

        All-in-one knowledge management and training platform for your employees and customers.







                              Zoho Developer Community




                                                    • Desk Community Learning Series


                                                    • Digest


                                                    • Functions


                                                    • Meetups


                                                    • Kbase


                                                    • Resources


                                                    • Glossary


                                                    • Desk Marketplace


                                                    • MVP Corner


                                                    • Word of the Day


                                                    • Ask the Experts





                                                              Manage your brands on social media



                                                                    Zoho TeamInbox Resources



                                                                        Zoho CRM Plus Resources

                                                                          Zoho Books Resources


                                                                            Zoho Subscriptions Resources

                                                                              Zoho Projects Resources


                                                                                Zoho Sprints Resources


                                                                                  Qntrl Resources


                                                                                    Zoho Creator Resources



                                                                                        Zoho CRM Resources

                                                                                        • CRM Community Learning Series

                                                                                          CRM Community Learning Series


                                                                                        • Kaizen

                                                                                          Kaizen

                                                                                        • Functions

                                                                                          Functions

                                                                                        • Meetups

                                                                                          Meetups

                                                                                        • Kbase

                                                                                          Kbase

                                                                                        • Resources

                                                                                          Resources

                                                                                        • Digest

                                                                                          Digest

                                                                                        • CRM Marketplace

                                                                                          CRM Marketplace

                                                                                        • MVP Corner

                                                                                          MVP Corner









                                                                                            Design. Discuss. Deliver.

                                                                                            Create visually engaging stories with Zoho Show.

                                                                                            Get Started Now


                                                                                              Zoho Show Resources

                                                                                                Zoho Writer

                                                                                                Get Started. Write Away!

                                                                                                Writer is a powerful online word processor, designed for collaborative work.

                                                                                                  Zoho CRM コンテンツ




                                                                                                    Nederlandse Hulpbronnen


                                                                                                        ご検討中の方