[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

Sales

171

Solutions

351

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 need help in coding sales ration in sql, plsql. I have a file attached with details
C--Tanuja-Lake_IL-BRDs-sales-ratio-.docx
0
Microsoft Azure 2017
LVL 12
Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

I have a new client with a light speed web filter appliance. It's currently licensed for just web filtering. Does anyone know if they also offer licensing for virus/malware filtering and detection? I am waiting for a call back from sales but this is time sensitive.

Thanks
0
Database7.accdbHi Guys,

I am trying to create some meaningful CRM style reports and forms based on our accounts transaction file.
I need to create this kind of output:-

                          TOTAL SALES       FRESH          SAUSAGE            HAM             PIES          OFFAL           OTHER                  
customer          LYTD   YTD        LYTD  YTD      LYTD YTD    etc
                          TOTAL TOTAL   TOTAL TOTAL    etc

I think I am fast approaching my current query/crosstab/union etc  ability.
btw  LYTD is last year to date, I have achieved most things with a selection of select queries, crosstab queries, left/right and union queries and i think
I am making this more complicated than is necessary.

1. The reason i need left and right join query is because some customers have no data for LYTD or YTD so in order to get everything I need to do the whole left/right/union thing
but if i injected 0 where there is NULL can i dispense with the l/r/union.
2. I cant seem to work out how to get totals for all sales and categorys.


many thanks in advance.
Your humble servant
Andy
0
I had this question after viewing PayPal IPN, PHP, & MySQL.

Hi,

I am selling CDs (and other stuff) mainly via eBay but also in other outlets (BigCommerce shop) and I want to do that following to automate this:
1. Collect payment notifications via Paypal IPN message using an IPN Listener Script and verify the payment - this bit has been tested as ok
2. Add CD/DVD sales information to a MySQL Database - I've created the database and attempted to add some lines to index.php to create entries
3. Transpose (parse) the resulting table information so that this can then be sent to Kunaki to ship the discs - I have found and partially updated a php file for this that does connect with Kunaki
4. As Kunaki is somewhat slow to send to anywhere but the USA, I wish to provide a link to a download for the software contained on the discs, immediately, so the buyer has instant access (currently, I've been doing this bit manually as I have access to the files on my home Synology NAS drive and have been sharing the links via email - I am eager to automate this somehow)
5. If I could also update the sale by providing a USPS tracking number that Kunaki provide, to the customer somehow, that would be great
6. Also, if I could update eBay or Paypal to state that the item has been sent, that would also be ideal.

So far, I have 3 files:

ipnlistener.php - to interface with the Paypal IPN
0
I need to subscribe to office365 to access email, office suite online/offline and onedrive for 3 users. I see 10 - 15 month per user, but seems the sales person keeps trying to sale me implementation, deployment and other services. can anybody help me? this is for business and may expend to 9 users in future.
0
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
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
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
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
Amazon Web Services
LVL 12
Amazon Web Services

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

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
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
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
Hi all,

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

Kind regards
0
CompTIA Security+
LVL 12
CompTIA Security+

Learn the essential functions of CompTIA Security+, which establishes the core knowledge required of any cybersecurity role and leads professionals into intermediate-level cybersecurity jobs.

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
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
Hello- I have recently gotten involved with our new MS Dynamics 2016 rollout for our sales teams and I am just kind of feeling my way through the many screens, etc.  I have one issue that I have inherited that I could use a little help troubleshooting.  We have two regional presidents.  Sales managers and sales team members are ultimately roll-up to these two presidents.  The way it has been explained to me is that when the presidents go into dynamics they have access to an 'exectuve view' (dashboard?) and one of the combo boxes on that view is 'My Open Opportunites'.  When the president selects 'My Open Opportunites' he is supposed to see ALL of the open opportunities in his region, from all sales team members.   This is working correctly for President A, but when President B looks at this screen there are no results.   Can someone point me in the right direction on what permission to check for President B in comparision to the settings for President A so that I might see if this can be corrected?  I have much to learn in the weeks ahead about all this but if I could get this little issue corrected it would be a great start!  Thanks for any help! -
0
Hi,

I am trying to figure out how to sort SKUs in the sales order and in the shopping cart in Magento (ver. 1.9.0.1). Ideally we would like ascending SKU order. Any ideas on how to accomplish this?

Thanks in advance!
0

Sales

171

Solutions

351

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.