Sales

154

Solutions

341

Contributors

Sales is the act of selling something; the exchange of goods, services, or property for money. Use this topic to talk about sales cycles & funnels and sales strategy. Please do not use this topic for Marketing.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hi、

I would like to use online "Map" service like Google Earth, Google Map, and etc. in order to display about 1000 customer locations on the map.
It is for the internal use, so I do not want to share the data on public, so that our sales staffs can use the tool for analyzing the route or location to set their sales strategies.

Could you share with me how to accomplish it and what are the actual steps?


Thank you,
AW
0
Free Tool: Subnet Calculator
LVL 12
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Using Access 2016:  I have a Query which groups agents by sales. Not every one will have data that month. I would like to email each individual agent his sales for that month. My questions are:
1. what's the best way to set this up, IE should I use a query, or a report based upon the query. I would need to create an agents table with email and name.
2. what are the steps involved?
3. what would be the code, we currently use go daddy for our email. We do not have a server in-house.
4, what event of the report or query would I use to add the code?
5. can you share code that works for 2016 access?

is this even possible? If the agent has no sales for that month, it should not create the email or should not create a report, if the report is based on a query?
If you can help, I would be gratefully appreciative, or if you can point me to a "dummies" link where I can try to create something.

The last question I had, I got some awesome answers from PatHartman and John . I am in hopes that one of the experts can help me with this as well as those two helped me with my query question. I know this is a lot to ask, but if you know, please help.
0
Does anyone have a Proposal template that they are willing to share?

I have a client who I am quoting for Windows Server 2016, VMs, Outsourced Exchange etc. The last time I did a complete setup and proposal was SBS2003. Just wondering if anyone might have something that I can use as a start to work from.

Thanks
0
Hello,

Are cloud phones better than an on premise solution?
We currently have a Siemens 4K phone system used with a PRI.
We have about 230 voice over IP phones and about 15 digital line phones.
Most of the ip phones have a basic setup with add on module to configure additional lines.

The 15 digital lines are for our sales department, the have a ACD routing setup(similar to a hunt group). Each sales person has their prime line and 2 secondary lines. We have it configured so that that each sales person is able to answered each others lines. Each sales person has about 50 lines configured on two phones at their desk that they can answer when any line rings. We it setup this way because our president wants sales to try and answer all calls and not have them go to voicemail.

We recently started to look at cloud phones and providers like ring central, 101voice and others. Our main concern is QOS and if our setup in sales will be supported.

We are not sure if cloud phones will be more reliable and if we will have the same quality of service?

Thank You


Let me know if you need any clarification.
0
I want to attract sales people to sell my affiliate product, but I don't want to go beyond the limit of a few hours a week of managing the website.

So, I posted my offer on Freelancer and one person applied to the position, and then suddenly the job offer was taken down from Freelancer. (I am not sure why).

The job offer was a good offer, it said that sales person would earn 80% of the commissions. That's a good offer for someone to earn from the website. But the statistics
reveal that only that one person applied for the position.

If I have to spend many hours soliciting the job offer in order to get a sales person, then instead, I should close the website(s) because there is no time to deal with that.

Can anyone tell me where I can find such a sales person who will work in that scenario so as to expedite the sales of the website? (but without exceeding three hours a week
of management).
0
I have a table (tMain) of sales... one entry for each sale.  In this table is the model (FrameModel) and an office (Office, currently just testing for all offices in the table.)  I would like to run a query that will pull the max similar model sold and display their count and also find their percentage (based on the total number of FrameModels sold) .  I am using the following query to try to pull this and a date range based on a form for the user,  (Basically trying to find models that have sold over 1 to find out "top model" sellers.

Its returning results but  I know for sure that there are other fame models not even showing up that have many sales (over 10)

SELECT tMain.DOS, tMain.FrameModel, Count(tMain.FrameModel) AS CountOfFrameModel, tMain.FrameLine, tMain.Office
FROM tMain
GROUP BY tMain.DOS, tMain.FrameModel, tMain.FrameLine, tMain.Office
HAVING (((tMain.DOS) Between [Forms]![FReportSelect]![DateStart] And [Forms]![FReportSelect]![DateEnd]) AND ((Count(tMain.FrameModel))>1))
ORDER BY Count(tMain.FrameModel) DESC;

Thank you.
0
Has anyone managed to tap into 365 Client Management tenant details including subscription renewals with PowerBi. I dont want to give my sales team full delegated access to 365 to review subscriptions.
0
How do i use macro to auto update my formulas and cell references? I have a pivot table containing sales data, with the columns stating months from January to March. But for every start of the month, i need to update the latest month (i.e. update to April when it's May) to show to a new column. I cant use getpivotdata because i need to track the cell reference, and the data will change for each month so i cant pre-count April's values. Beneath the pivot table, I have a normal table stating sales data total [i.e =sum(Jan-Mar)] which i have to manually update. Is there any way for macro to automate the normal table to update =sum(Jan-Mar) to Jan-Apr? Example like =sum(b1:d1) to =sum(b1:e1) and for subsequent months?
Book1.xlsx
0
Hi, I am using Access 2010. I want to learn advance and complex queries writing to manipulate data in tables, in VBA, which can perform on some events of form / report. I am familiar with query builder and basic queries.
Now I have an assignment to prepare a periodic summary for stock inventory, filtered by date and/or stock item. View, in datasheet on form / report, format as follows:
Filters applied: Date Range, Stock Group
Columns: StockItem, PackSize, PreviousQty, PreviousAvgRate, PreviousStockAmount, PurchaseQty During Date Rate, AvgRate of Buying During Date Rate, PurchaseAmount in Date Range, SalesQty During Date Range, AvgRate of Sales During Date Range, SalesAmount During Date Range, Qty of Balance Stock, AvgRate of Balance Stock, Amount of Balance Stock. AvgGain (AvgRateSale)-((PreviousStockAmount+PurchaseAmount in Date Range)/(PreviousQty+PurchaseQty)

Tables & Columns: (Interlinked columns only mentioned here)
tblStockItem: StockId, StockGroup, StockLabel, PreviousQty, PreviousBuyingAvgRate
tblStockPackSize: PackSizeId, StockId, PackSizeLabel
tblPurchase: PurchaseId, StockId, PackSizeId, Qty, Rate, Amount
tblSales: SalesId, StockId, PackSizeId, Qty, Rate, Amount

I am looking for expert guidance to write queries and how to set its recordset to any object to display data, in Access VBA. I will be thankful for your help.
0
Employee Tracking - GPS - I want app to web solution for tracking my sales employee and location with form to be filed when they reach that location.
0
Cloud Class® Course: SQL Server Core 2016
LVL 12
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

I set out trying to find an android app that would allow me to add a previously called number to sales prospects from my phone easily. I downloaded the Base app here https://support.getbase.com/hc/en-us?return_to=%2Fhc%2Frequests but it doesn't seem to do this.

I know Base has a large following and I think it has free features. Do I need a different product or can Base do this?

Assistance is greatly appreciated.
0
Guys,
Looking for a market research firm before launching a product? Any suggestions?
0
We use the Sales portion of Dynamics 365 CRM, specifically our current issue is with uploading quotes via the Custom Data Maps under Import Data. We have used this tool for over a year and randomly yesterday our most used custom data map was not showing up in the selection when importing a quote. The custom data map was still listed on the back end under Data Management/Data Maps, so I was able to export it, rename it, and import it. That got the team moving again yesterday, but we came in today and all of the custom data maps were missing from the end user import screen. We tried the export/rename/import trick and it worked for a few minutes but now the entire Custom Data Map section is missing as a selection while uploading through import data. I'll attach a screenshot of this. Has anyone run into this before, the custom data maps are listed under Data Management but the End Users do not see them, no changes have been made to the config.
0
Hi

I have below scenario and need help to address this issues. What would be your approach to solve this problem in bullet points or brief summary like  what is your assumptions,explain your analysis approach and chosen analytics techniques, expected output results, what recommendations do you suggest,do you see limitations

1. How would you assess the impact of weather on consumer spend last winter?

2. How would you determine if a specific block in your neighborhood is suitable for a new grocery store?

3. Bank XYZ has created a new credit card product, how would you determine the targeting strategy?

4. Bank XYZ  has observed declining credit card sales volumes in their core markets. How would diagnose the cause and what potential remediation’s may be put in place (if any)

5.  Credit Card company recently announced a new partnership with a key tech company. How would you quantify the per customer incremental value of this partnership?

Thanks
0
I have a large database with many years of sales transaction records by customer, by stock code, by month by year.
I want to compare information form one year versus another year.
The Crosstab returns variable Column Headings which I want to change to Fixed Column Headings to work with the various queries, tables and reports I have compiled.
Row Heading: Customer
Row Heading: STOCK_CODE
Column Heading:TRN_YEAR:
Vaue: SalesValue
0
Ethernet and T1 service-
How they are related to CLLI?
Is there any link between switch and service wire center CLLI?
What are LATA? How it used in modern communication?
Thanks
0
Hello.I was wondering anybodies have a suggestion for me to earn money! In my family there are a lot of young people that don't have a job I can also prepare money for starting business I satisfied for only 250$ for a month.stock trading or produce somthing... please tell me your idea I really need help.
You can contact me with meitiluti at gmail dat com.🙏🏼🙏🏼🙏🏼🙏🏼
1
Hi,

Am fresher to Wordpress Am searched product only for product show with category wise No need to sales product like cart,Payment section.

Is there any Free wordpress theme for only related to show product Please help me..

I don't need to use Woocoomerce plugin Want pure e-commerce site
0
Hi,

Is there an equation/ formula to calculate market growth of a product? Or in other how to forecast growth of a product for the next years?
0
Free Tool: SSL Checker
LVL 12
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Hi all,

does anybody have a market survey with regards to temperature sensors?

Kind regards
0
Hi
Appreciate some help with this - I have a custom calendar, and I need a DAX formula to provide me with the MIN/MAX dates for the previous month (or time period).
For example, our company calendar month of May 2017 goes from 04/30/2017 to 05/27/2017, the month of June 2017 goes from 05/28/2017 to 07/01/2017.
Let's say I have a report which is looking at Sales for June 2017, I also want a column in the report showing Sales for May 2017, (and a column showing the % difference between them)
I need a DAX query which knows that the previous period/month to June, is May, and that the dates in May are from 04/30/2017 to 05/27/2017 (I have a CompanyDates table with the various dates and months in it)
Appreciate your help with this!
Thanks
Fergal
0
I've put together a spreadsheet for approx. 20 sales people (1 sheet per salesperson), which contains plan and actual sales numbers, month by month. Each sheet is identical in terms of it's set-up. I want to be able to select one of these sales people, through a dropdown list (done that bit!), and then create a graph for that specific sales person (and as you select a different sales person, the graph updates with the details in the sheet for that person) based on the selection.

Is this possible? It's easy enough to create a separate graph for each individual, but this seems a bit of a waste.  I keep thinking there must be an easy way, but I can't seem to find anything on it.

Thanks, in advance, for any help!
0
how to set Datagridview first column as autocomplete search box from database table. And if I select one product from search box then related details should be shown in other columns. For example

If I select car product from first column then its price and configuration should be shown in next two columns from database

In my database I added the product and its related field
Jay.accdb
WindowsApp1.sln
0
Hi
Recently I received a mail from http://www.tobuy-cn.com/
I don’t know this website is fack or real
Anyone tel me can I buy?  From this site
0
I am in process of adding new item status to existing one. What all key fields , transactions I need to check and consider before making any chnages.

Thanks
0

Sales

154

Solutions

341

Contributors

Sales is the act of selling something; the exchange of goods, services, or property for money. Use this topic to talk about sales cycles & funnels and sales strategy. Please do not use this topic for Marketing.