How to create a Sales Order by location (split by product) that can be exported into excel

How to create a Sales Order by location (split by product) that can be exported into excel

Hi all - I am not sure if i am pushing the capabilities of zoho enterprise but here goes...I would like to save our Sales team building off line quotes and having to re key information that we have each time the customers wants a quote.

Our data structure is Parent account, account, contact, site.  There are often 1,000s of site at and account level, there can be some cross over of contacts and site contacts but we given them different roles to separate. 

We delivery different types of consultancy at various sites / locations.  I would like to create an quote by site (we have created a module and uploaded over 30,000 sites).  Each site is often different in size and complexity, the most common work we do is assessments, but we basically sell time by the hour or square foot (this can be achieved in the product section)

Ideally i would like a person to be able to create a quote (linked the account) select the sites from the related list (would need to do this)....And then apply products to each of the sites.  Per sites there could be 1-5 products depending on what we are going to do.

I would like need to create a quote template that only show the cost at a site level, so would need a sub total for each site....

Once the Sale order / Quote is agree i would at the click of a button liek to be able to export all the sites data (thats in the system) and the cost by site...

Is this achievable? 

PS the time saving is that all the site data is in the system and not in spreadsheet and being lost every time.

    Access your files securely from anywhere

        Zoho Developer Community




                                  Zoho Desk Resources

                                  • Desk Community Learning Series


                                  • Digest


                                  • Functions


                                  • Meetups


                                  • Kbase


                                  • Resources


                                  • Glossary


                                  • Desk Marketplace


                                  • MVP Corner


                                  • Word of the Day



                                      Zoho Marketing Automation
                                              • Sticky Posts

                                              • How to Add Users to your Organization in ZohoMail?

                                                A better clarity so you can create other users to start using Zoho Mail. You can directly Add Users from the Control Panel to your Organization. You can invite users with the existing email address. If the person (user) already uses ZohoCRM, then you can import users from Zoho CRM. You can also import them using a .csv file. (if you are planning to add them in Bulk)  In this topic, We will be discussing on how to Add and Invite users only.  The Import options are self explanatory. ____________________________________________________________________________________________________________


                                              Manage your brands on social media



                                                    Zoho TeamInbox Resources

                                                      Zoho DataPrep Resources



                                                        Zoho CRM Plus Resources

                                                          Zoho Books Resources


                                                            Zoho Subscriptions Resources

                                                              Zoho Projects Resources


                                                                Zoho Sprints Resources


                                                                  Qntrl Resources


                                                                    Zoho Creator Resources



                                                                        Zoho Campaigns 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