Sales Help

Question by

meenu rawat

3d ago

Define Item status query

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

1 Comment

Free Tool: SSL Checker

LVL 10

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.

LVL 1

Question by

NewAvenues

5d ago

Ricoh printer won't print black

I purchased a Ricoh MP C307 printer directly rather than going through the Ricoh sales people. It's a brand new printer with new toner, but for some reason it won't print black, we have to change font color to blue in order to print it. I called the seller, he told me I haven't done the setup right and that there is nothing wrong with the printer, he advised me to hire a Ricoh tech to do the proper setup. I've setup 100s of printers in my life time, I am pretty sure there is no magic step that I missed during setup. Would appreciate any tips on how to fix this. Thanks!

3 Comments

In a sales report I want to enter a date range from two DB fields used in a formula and then list two columns of results that list the results from the date range entered, as well as a comparison column of data from exactly one year previous. I'd like them to be listed side by side. Would I use a Subreport for the comparison data? And if so, how would I take the entered date range and have the Subreport use data from the previous year? I want only one prompt for a date range and have the report handle pulling data from the previous year for the comparison.

For example:

LEAD SOURCE CURRENT DATE RANGE: LEAD SOURCE ONE YEAR AGO:
Lead Source: (formula 1) Sales TTL: (formula 2) Lead Source: (formula 1) Sales TTL: (formula 2)

I hope this is clear enough to follow, and thanks for the help!

12 Comments

Question by

snyperj

2017-09-10

MS Dynamics 2016

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! -

1 Comment

Hello,

What Excel method(s) are most useful or valid for analyzing the relative sales success of a number of products?

That is a much less-specific question than I would like to be asking but suppose you have a sales report with the following information:

Products: 200 SKU's
Date Range: 3 years
Number of Sales: 11,000+

...and containing the following data (file attached):

I had in mind creating a chart with the [# of items sold] as the vertical axis vs [time elapsed since product introduced] as the horizontal axis. However, that would be quite cluttered with 200 products so I'm interested in other approaches.

Thanks
Sales-report_2017-09-05_EE.xlsm

4 Comments

LVL 17

Post by

Kyle Santos

2017-09-05Edited

Need a report button for bad sales call attempts.

Just had an interesting sales call. Well, there wasn't any call per se. The phone rang and the caller ID was for a website. When I answered, all that was playing was music and no person on the other end. Annoying, right? I hung up, looked up the website and found out it was a cloud VoIP website. As soon as I went to the website a chat window popped up welcoming me. Ugh.

Not sure if clever sales attempt phone call or rude way of luring me to their website. I'm feeling the latter and also feeling taken advantage of. I want to report this deceitful attempt at a sales call, but don't know if that's a thing? If I mention the name then I also feel I'm spreading the word for them for free.

>: (

4 Comments

load previous comments (2)

LVL 7

Expert Comment

by:Brian Matis2017-09-05

Fortunately, I bet the people dealing with things like this complaint system might actually be the ones likely to care ;-)

For example: in the past I had great success with the FCC's Do Not Call list (Which I honestly wasn't expecting to work, but it absolutely did! I had needed to get a landline, and as soon as I did, it got a ton of daily telemarketing calls. Soon after adding the number to the DNC list, the calls dropped to nothing. The system worked!)

LVL 17

Author Comment

by:Kyle Santos2017-09-05

Nice. In retrospect, I am just being bitter about it haha. Just like we at EE do need data, I'm sure FCC needs the data as well to look upon and see 'do we deal with this now? Is it a large or small problem?' :) Who knows maybe they've already been reported or maybe I'm the first!

Add Comment

Adding curb appeal to your small business can attract your audience’s attention and convince them to come in to shop around. However, if you go overboard, you may cause your small business to look tacky or even annoying—pushing your ideal customer further away.

0 Comments

Add Comment

Question by

Moxie co

2017-08-30

Organize Sales Order in Magento by SKU

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 Comments

Question by

Chay Jones

2017-08-28

Copied wrong sales in date

I would like to know if it is possible to restore sales in files and start over. I entered the wrong date for sales and I just would like to put them back and bring the correct date over.

Sales
as/400

1 Comment

Question by

Member_2_7948725

2017-08-24Solved

Joining Two related queries

Dear all;

I would like to find out whether it is possible to join two related queries to come up with summary data before create a report , example:

Query 1
Has the following fields

ProductID SalesDate SalesMixValue

Query 2

ProductID SalesDate SalesMixvalue

The idea here is to find the cumulative movement in terms of SalesMixValue , the thing is that each customer is given a discount on daily basis $200.00 any unused discounts is carried forward on a daily basis for future use , hence the need to determine the sales value on cumulative basis by product ID and Sales Date:

The mechanism here is that Query 2 must be always behind by one day lets say instead of pulling the current data as on 24/08/2017 it should just pull as on 23/08/2017

Query 1 must always pull the current data that is as on 24/08/2017

Now what is required here is to subtract Query 2 (salesMixvalue) from Query1 (salesMixvalue) so that the accurate sales value netted with discount is reported as daily sales value.

Kindly see how you can help, I have heard of net query but frankly I do not understand it .

Regards

Chris

11 Comments

Better audio for more successful meetings

LVL 2

Challenge: S&ME was tired of poor audio quality of Skype for Business calls in mid-sized meeting and training rooms. They were looking for a reliable and cost efficient solution to replace the existing conferencing system.

Post by

Daniella Barion

2017-08-24Edited

Target teenage and young adult is not an easy job. It's a challenge for a lot of companies. Let's wait for Facebook next move.

https://venturebeat.com/2017/08/21/facebook-faces-new-scare-that-teens-are-like-totally-going-to-snapchat-and-instagram-again/amp/

Facebook faces scare that teens are, like, totally going to Snapchat and Instagram. Again. | VentureBeat | Social | by Chris O'Brien

7 Comments

load previous comments (5)

LVL 3

Expert Comment

by:Anthony Pangilinan2017-08-25

Is it possible to have a place where people with different age range will hang together?

It sounds funny, and I think Kyle can also attest to it, but Pokemon Go achieves this. I've done raids that have included elementary aged kids and retirees. I've seen a lot of stories about children playing with their parents and grandparents and rejuvenating their relationships. The key to achieving this balance could be giving the users something on which to focus besides their own social lives. A 16 year old's social interests most likely won't align with a 30 year old's interests, but creating a common goal that interests people of any age can bring their worlds together.

LVL 17

Expert Comment

by:Kyle Santos2017-08-25

Well said. That is one good example for sure.

Add Comment

Question by

mburk1968

2017-08-22Solved

SQL 2012 Query Syntax

I have the following query. The way it is written currently I have a column for each Customer. I was wondering if perhaps there is an easier way to write this. Basically so that I have two columns Customer and Net open Sales for 2017?

SELECT DISTINCT
        ( SELECT    SUM(price * total_qty)
          FROM      [KLL Open Orders - Header & Detail]
          WHERE     ( ( CUSTOMER IN ( 'AMA0010', 'AMA9010', 'AMA9011' )) )
                    AND ( (division = 'KLL') )
                    AND ( (end_date > = DATEADD(DD, -30, GETDATE())) )
                    AND ( ( ORD_STATUS = 'O' ) )
        ) AS Amazon2017 ,
        ( SELECT    SUM(price * total_qty)
          FROM      [KLL Open Orders - Header & Detail]
          WHERE     ( ( CUSTOMER IN ( 'BJS0010', 'BJS9010' )) )
                    AND ( (division = 'KLL') )
                    AND ( (end_date > = DATEADD(DD, -30, GETDATE())) )
                    AND ( ( ORD_STATUS = 'O' ) )
        ) AS BJ2017 ,
        ( SELECT    SUM(price * total_qty)
          FROM      [KLL Open Orders - Header & Detail]
          WHERE     ( ( CUSTOMER IN ( 'MOD0010', 'MOD9010' )) )
                    AND ( (division = 'KLL') )
                    AND ( (end_date > = DATEADD(DD, -30, GETDATE())) )
                    AND ( ( ORD_STATUS = 'O' ) )
        ) AS Burlington2017 ,
        ( SELECT    SUM(price * total_qty)
          FROM      [KLL Open Orders - Header & Detail]
          WHERE     ( ( CUSTOMER IN ( 'COS0010', 'COS0015',

Open in new window

…

6 Comments

Question by

Richard Korts

2017-08-16Solved

Sign Up for Google Analytics

I want to do this for a customer.

I know I can access their Google Account from my computer (I have the email & password), I don;t remember how to do that (or even access my own Google Account, I know I have one)

How do I do that?

Thanks

1 Comment

Question by

grnow

2017-08-04Solved

Referral system for sales people

Looking for a system which can reward sales people in a fair and transparent way such that easy for them to trace their own performance online and for us to reward, incentives, training, manage

3 Comments

I have one Facebook account and would like to talk with someone via chat who knows about how to properly configure Facebook, so that it can be used for professional, personal, as well as to sell products.

I currently have this page https://www.facebook.com/ted.penner.7 that is supposed to be my professional Facebook presence and people, even "friends" complain that they can't see anything at all.

1. I would like to be able to have a professional view as the default available at that URL to all the public.

2. I would also like to promote a video designed to sell a product from my website to a Facebook audience that cannot see any of my personal contacts such as so-called "friends" or "acquaintances".

Assistance is greatly appreciated.

2 Comments

Hi

In my WP blog, I'd like to give my users the opportunity to sell their associated art (their music)
Now that CD's don't exist, what are the opportunities here? mp3's, iPod?
How is music sold?
Do most people have the ability to acquire this music, in practicality?

Thanks

2 Comments

Post by

Drew Frey

2017-07-24

We're excited to announce the launch of our Webroot Certification Program.

The Webroot Certification Program covers key feature differentiators, deployment best practices, cybersecurity management, and basic troubleshooting techniques for SecureAnywhere® Business Endpoint Protection. The program enables the sales and technical teams at managed service providers (MSPs), value-added resellers (VARs), and other distributor partners to better sell and support the solution, as well as streamline and enhance their IT services business.

Get certified by signing up here.

0 Comments

Add Comment

I am about to launch a WordPress/WooCommerce site but worry about around the clock support for my site since my developer's in India, Monday thru Friday.

That's about 25% of the week! That being said, I would expect the bulk of sales to be on Eastern Standard Time, 8AM to Midnight, which means his coverage percentage is higher that 25%.

Are there are support models you can think of which would be me paying some small retainer for a WP developer to be on call and getting notified if there is a hiccup or site outage? Then, if there is real work that's needed, I'd pay on an hourly basis?

Curious...

Do I need to be worried at all about the site have problems which could cause it to be unavailable to process further orders?

I am not worried there may be a one in a hundred error rate which I can resolve when the email comes in, but instead, having a site outage causing orders to stop.

2 Comments

Question by

dpm1028

2017-07-19Solved

Color shade line chart by quarter

Hi,
I have a line chart that I use to show sales information. I use it all year, but would like to highlight (via background shading) each quarter of the year. I have had no luck so far. Any suggestions?
Dan

6 Comments

[Video] Create a Disruption-Free Workspace

LVL 2

Open offices have their challenges. And Sometimes, it's even hard to work at work. It's time to reclaim your office and create a disruption-free workspace. With the MB 660, you can:

-Increase Concentration
-Improve well-being
-Boost Productivity

Question by

frugalmule

2017-07-17Solved

Tie sales efforts to purchase

I have a youtube video with a pitch for a subscription service.

I plan to get some assistance in promoting the service and want to find a way to tie the link being passed around by each individual salesperson, back to that individual so that I know what commission to pay them if those viewers become customers.

Assistance in figuring out how to do this is greatly appreciated.

4 Comments

I've got three columns: Individual, Amount, and Date. Each individual has multiple sales for each date, and I want to find the simplest way in which to see how much they sold on their best day, and potentially, what day that was. I can make a new sheet, with one column full of every date from January 1 to December 31, the second column containing the individual's name, and then a SUMIF to pull the totals for each day, then use MAX on that column to find the number, but I'm guessing there's a better way.
Best-Day-Experiments.xlsx

3 Comments

Post by

Cory Pettit

2017-07-14

Hello!

Here's the issue: I've got three columns of data: Individual, Amount Sold, Date Sold.

People have multiple sales for each given date.

I want to find each person's best night, i.e. all the sales for each given date combined for that date, and then I'd like to see the max for each individual, so I can show them their best night.

I can do this by creating a new sheet with three columns, one containing every date from 1/1/17 to 12/31/17, the next containing the name of a single person, and the third containing a SUMIF formula, so that I have the sum of each person's sales for each day, and then take the MAX from that column. I am sure, however, that there is a better way. A PivotTable seems to only give me the largest single sale from each individual, instead of the night with the largest sale.

What's the simpler solution here?

2 Comments

LVL 12

Expert Comment

by:Andrew Leniart2017-07-14

Hi Cory, welcome to Experts Exchange.

What you have done is made a post here. To get expert help, you need to "Ask a Question" so that more experts are able to see you need help. Click the Big blue button near the top of your screen.

The following link explains more about asking for help at Experts Exchange..
http://support.experts-exchange.com/customer/portal/articles/336330

LVL 22

Expert Comment

by:Roy Cox2017-07-14

Hi Cory, you need to look at a PivotTable with dates grouped by day

Add Comment

Question by

Ann Chukwukadibia

2017-07-13

Sales Tax

How do i compute sales tax in monthly turnovers for the year in quickbooks.

Sales

1 Comment

The Sales reps absolutely love these and won't gve them up - I need to keep them on the road. 2GB RAM isn't upgradeable, best strategy for using virtual RAM ?

2 Comments

I have this view with the year to date sales values for each stock item sold: -
SELECT Year, [Stock Code], SUM(SalesValue) AS TotVal
FROM dbo.tbl_My_Table
GROUP BY Year, [Stock Code]
HAVING (Year = YEAR(GETDATE()))

I want to create a SQL job to populate a table overnight e.g. tbl_Inventory_Category

I need to add StockCode and Category to the table, StockCode comes from the view. 'Category' is calculated thus:

•      A= Products that make up 65% year to date sales.
•      B= Next 20%
•      C= Next 10%
•      D= Next 5%

Does anyone know how to achieve this?

7 Comments

COURSE of the MONTH

Sales

Related Topics

Sales

Related Topics