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







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

I use a feature in Sage500 called Doc Transmittal, which allows my users to email a copy of a Sales Order to remote customers. The Doc Transmittal feature is configured using SMTP, via the IP address of the Exchange server. Basically when the Sage500 users enters a sales order for a customer, they are asked if they want to send a notification email to the customer, and the Sage500 users says OK. A email is sent to the customer and to the group email.

There are five people in the Sage500 group. They all have "Send AS" permission to the mailbox.  We can call the mailbox "SageMailbox".

A relay has been setup for SageMailbox.

Out of the five people that have access to SageMailbox, only three people can successfully use the Doc Transmittal successfully. The other two get the error attached.

Please help!!!
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.

Hello :-)

I have an excel spreadsheet where there is a product code and the sales amount of that product per day. I need to take the average sales per day range for a given product. How many sales for product 01 between 10/11 and 02/12 for example.

Some idea?

The spreadsheet:
(1) I'm required to deliver the access application system in a supermaket envirnoment, now the number of cashiers will be 20 (Users) accessing the same sales accounting or tables. My application is split into backend & front end of which per user will have their own front end linked to the backend on the server.My fear here is the locking system even if all my forms show the record locks property  - No Locks, any idea how go about this?

(2) I have also experienced some issues of power failure in some clients work place, now because of the same you find in the FE folder sometime their is an extra file generated after power failure any idea how to sort out this? Though my current advice to the clients is to invest in UPSs


Example.xlsxExample.xlsxI have a spreadsheet, attached, of my prior year monthly sales, and my current YTD monthly sales.

How do I write a formula (not an array or VBS please) to compare YTD totals through this month last year, compared to this month this year?

Thank you.
I have DAILY sales data for 3 products in this form: TABLE1
Product1|SaleAmount|UnitsSold|TimeStamp (there are multiple records for each day)
Product2|SaleAmount|UnitsSold|TimeStamp (there are multiple records for each day)
Product2|SaleAmount|UnitsSold|TimeStamp (there are multiple records for each day)

I have DAILY expense data for 3 products in this form: TABLE2
Product1|ExpenseAmount|ExpenseType|TimeStamp (there are multiple records for each day)
Product2|ExpenseAmount|ExpenseType|TimeStamp (there are multiple records for each day)
Product2|ExpenseAmount|ExpenseType|TimeStamp (there are multiple records for each day)

I need a few SQL statements:
1. I want to show the following columns on a MONTH BY MONTH basis for each product:
Thus, the rows will contain the name of each product; there will be ONE row for each product for each month.
The Month will show as Jan-2018, Feb-2018

2. I also want to show the following columns on a MONTH BY MONTH basis for each product:
Thus, the rows will contain the name of each product; there will be MULTIPLE ROWS for each product for each month, i.e. the number of rows for each month will …
I need traffic to my website. I have started with Social Media, Submitting my sites to Search Engines.

Several years ago, I studied SEO but, I have found that things have changed so much as it pertains to traffic such as Meta Tag's submissions and PPC.

I am looking to building up my traffic up to my E-commerce Websites / Aliexpress Affiliate websites.

Can you help me to build my traffic to my websites and to build my SEO?  My sites are very new in the development stages. If possible I would like free or low costing options.

Thanks in advance Experts.
I have a website that I designed with the Aliplugin.  This is it: http://essmen.com/.  My website visits are about 400 visits per day with any advertising other than links on Facebook, Twitter, and Google Plus.  I have two problems. One is the traffic and the other is that fact that no one is buying any of the affiliate products.  I have close to 19000 products on the website and can add more. I was advised by the Alipartnership to add as much product to increase my chances of indexing quickly.  I am a complete newbie and want to stop spinning my wheels on these issues. Can I get a little help on getting possible free traffic or very cheap traffic? And, I want to know how I can possibly get some one to buy something on my website to start making affiliate income?  I have had the website up going on two months. I do not want to just jump ship now based on the advise of the Aliplugin people. i'm just sayin'
Hi, I need help in coding sales ration in sql, plsql. I have a file attached with details
How to calculate Last 2 months average sales in sql server (excluding the current month)
I have been working as a consultant for a number of years,    I have a diverse and pretty extensive background, I basically do server\desktop\network\firewall\VPN\Exchange hosting\DR\Business continuity down to desktop preventive maintenance, builds etc.. Basically whatever is needed.

One of my larger clients has concerne if I were to die where that leave them.  From day one due to my background of managing IT, and staff for companies with multiple location and being a senior IT person prior to consulting. I always put in place what I could to minimize exposure.  I do the same with the current client base.  Admin passwords are on file, all prod servers always covered by contracts with an SLA of on site in 4 hours etc.

This is a difficult one to answer.  They are under the false impression they would be safer with a larger consulting company. They will never get this level of responsiveness/expertise/service/or price.   I would love to grow the business and bring on someone else, or possibly acquire another consulting business, do I try to find a commissioned sales rep?  Or even take over accounts of a small consulting business in the area where the owner was close to retiring, but for the life of me, I am not sure how to find consulting businesses that might be for sale, or someone in a similar situation that I can trust, and would not go after our clients etc.
Surely there are other consultants on this site that are in similar situations.    If you think about it, we…
Exploring SharePoint 2016
LVL 12
Exploring SharePoint 2016

Explore SharePoint 2016, the web-based, collaborative platform that integrates with Microsoft Office to provide intranets, secure document management, and collaboration so you can develop your online and offline capabilities.

Doing a pst migration in tandem with an email migration into O365. We are using native tools so far, but with the nature of pst imports into O365, the manual process of setting up batches has been a bear to deal with. All the users are storing psts on their personal network share, so not a centralized location. Many users have multiple psts of varying sizes.  They are willing to consider a 3rd party tool to help, but there are so many out there. I haven't used any yet. Can anyone suggest what tools they have used, what they liked and disliked? Trying to make an informed decision without all the sales hype. Thanks!
I'm planning to go for Amazon FBA business & was recommended to get
Helium 10 to do analysis of sales in Amazon.

Someone told me it's almost US$200/month subscription or is it
US$200 once off?

While waiting for promo (heard sometimes there's half price), anyone
can suggest a similar freewares (that once I key in an ASIN ie Amazon
Stock I...  Number), it will list competitive products with their $ sales
turnover, profit margins (for each product), sales in terms of qty
I have now hit a brick here full time,after creating a DSN Less file and code below this works well with the same network and as long
the computer/Servername remain the same:

Driver={SQL Server Native Client 11.0};Server=Sales\SQLEXPRESS;Database=MDCAccounting;Trusted_Connection=yes;

Now our client is using his own network which is different to the one we are using or where the DSN Less was compiled as result the connection has failed even after doing the following:
(1) Installing the same Express server on their server ( This server is now called FINANCE not SALES as above)
(2) Ms Access runtime & correct ODBC on their Four work stations were all properly installed
Is there something I'm not understanding here, could it be there is need for a table relinker code? If yes do we have a sample somewhere?
I strongly believe that the fact that I'm moving the data base from one network to a diffrent customer network and server has caused this

Kindly assist with a working code if possible.
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.

I signed up for costco membership in person at the costco store giving my united states state id.
I thought costco stored information by recording my state id number.

But when I used my costco membership number to sign up for costco.com online I was asked questions about my credit report.  
Where were you living in 1990?
a b c d choices.

In this example I am the consumer.
But I would like to be the merchant using customer state id.
Do you have examples of websites offering this service?
Are the following business scams (I registered for a talk) or genuinely, there are people
who made it in the businesses?  I've heard of a neighbour's friend who made about
US$600k of sales via Amazon.


And the bitcoin talk below as well:

What are the tell-tale signs if they are scams or anyone had been through them before & care to share?
Hi Expert,

I have a following requirement could anyone please suggest on this!

Assume a Sales table with columns for Sales_Amount, Customer_Name, and Region.
There are other columns and indeed other tables, but that’s not important.
 Give me the top 5 customers by total Sales_Amount, within each Region.
 The number of regions may vary over time, and your query needs to keep working as regions come and
 go (i.e., you don’t get to handle this with a CASE statement). You may assume there are more than
 5 customers with sales for each Region. So if I have 3 unique values of region in the table,
 I should get 15 rows, 5 for each region. But if there are 5 regions, I should get 25 rows.
 Write a Oracle-SQL script for this. No JOINs are needed, you’re only using one table.
You can use as many queries, and as many Temp Tables, as you need.

create table sales (customer_name varchar2(10), region varchar(20), amount number(10));


insert into sales values ('ahmed2', 'Asia', 40000);
insert into sales values ('ahmed3', 'Asia', 60000);
insert into sales values ('ahmed4', 'Europe', 210000);
insert into sales values ('ahmed5', 'Europe', 30000);
insert into sales values ('ahmed6', 'Europe', 210000);
insert into sales values ('ahmed8', 'Europe', 5000);
insert into sales values ('ahmed9', 'Africa', 8000);
insert into sales values ('ahmed10', 'Africa', 86000);
insert into sales values ('ahmed11', 'Africa', 99000);
insert into sales values ('ahmed12', 

Open in new window

Designing a scientific calculator in Ms Access,I'm almost done with the calculator VBA in Ms Access. The current issues that I cannot sort out are below:

(1) I want the form size to open like the size of a pocket calculator, I want this form to be used as a calculator on all sales & purchases forms in ms access

Is there a code or something that can reduce the size of the form? in design format I'm able to that , but when I open the form it fills the whole screen, that what I do not want.

(2) the form must be called from the sales invoice form and appear like a calculator, I want the simple method of calling it like using a macro or VBA ( Do.cmd) , is it possible?

I have assembled a called for calculator , like the one we use in C#


hye, EE experts, i am thinking to get advertisement to my own web site that  has 6000 chinese visitor as  monthly in English site about taxi fares calculating , is there any idea or advice  for getting online advertisement affiliate commpany??
Another question related,  i have domain name  such as htttp:// www.fastfood.[city name]. How to and where to sell this domain name as godaddy recommended price 650 $ ??
Learn Ruby Fundamentals
LVL 12
Learn Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

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
I had this question after viewing PayPal IPN, PHP, & MySQL.


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
We are trying to setup an API in Magento when the current admin password is entered, the system comes back with Invalid current password. Does any one know what password is magento expecting? I am the admin of the system so should be able to use my password, but the role name is not admin, is Sales API.

Any one here have an idea of how to fix this? Cannot setup my taxjar account because of this issue.



Every business relies on effective marketing to get the word out and sell products. It doesn’t matter what industry you’re in—if people don’t know your product or solution exists and why they should buy it, your company will not be successful. Unfortunately, many people working in tech today don’t have much knowledge of what strategies are used, and which tactics are most successful. 

If you don’t know that much about modern marketing, you’re definitely not alone! With that said, you should at least know the basics of effective tech marketing. Even if you’re not involved with marketing, knowing best practices will help you understand your consumers and help you serve them better.

Shifts in Marketing Strategies

Marketing today is much the same as it was a few decades ago, but the Internet has given us new mediums and the potential to reach an unimaginably large audience. Ads were once the biggest portion of any business’s marketing budget, but Americans have become more and more jaded about them over the years (with the possible exception of Superbowl commercials). 

With the more immersive environment of the Internet, ads have begun to lose their power and have become more annoying to the average buyer. 91% of people feel that ads are more intrusive today than they were two years ago, and 81% have navigated away from a webpage or closed it entirely because of pop-up ads. With these shifting attitudes, marketing tactics have changed as well. If your tech marketing could use some improvement, here are some best practices for modern marketing that can help any company succeed.

Understand Consumer Behavior

This is one of the most important principles of marketing. If you don’t know what your customer wants, you cannot market to them effectively. Fortunately, there are a lot of tools for gaining market intelligence, and the ability to collect data through big data platforms and Google Analytics gives marketers a lot to work with. There is also danger in relying solely on the numbers, however—it takes time and patience to build a brand, and it can’t be done by just plugging in the right numbers. You need to use your analytics as a supplement. Talk to your customers. Use surveys, focus groups, and interviews. Find out what they need and want from the source!

Create Better Content

One of the biggest shifts that has taken place in marketing over the last few years is the amount of content that is being created. Content can include blogs, videos, articles, quizzes, whitepapers, and more. Companies that create good content can gain goodwill with customers by providing value upfront and building customer trust and authority. The idea is that when they’re ready to buy, customers will think of the brand that gave them the best information, and choose that brand.

In order to effectively leverage content marketing, you don’t just have to produce content—you have to create good content. That may seem obvious, but there are a lot of tech companies out there just putting out blog posts for the sake of having a blog—the information isn’t necessarily valuable or even interesting. Tech companies that actually produce valuable content will stand out from the competition and catch the notice of consumers.

Create Emotional Responses

We like to think we’re rational creatures, but in general, emotions overshadow logic. Appealing to consumer’s emotions is what ultimately makes sales—emotional ad campaigns outperform rational campaigns by almost double. People want to make a personal connection to a brand in whatever way they can. That’s one of the reasons personalized marketing is becoming more and more popular as analytics empower marketers to hyper-segment their customers. 

One good way to create emotional responses in your audience is to tell a story. This helps you to connect more deeply with your customers and help them relate to your message. Think about it: would you rather make a recipe that just lists the steps and ingredients, or the one with a great family story behind it? It’s the same principle in tech marketing. Stories make everything better.

Marketing in Tech: Remember the Human Connection

People see everything your business posts and does online. Improve your brand awareness by implementing good online marketing strategies and connecting with customers. Getting noticed and building trust is a marathon. You need to continually add value, share your content, and look for new insights into your customers’ wants and needs. Numbers matter in tech marketing, but the human connection is absolutely crucial.

I want to get a list of sales orders that are 7 years old so I wrote the following query:

SELECT SalesOrderNumber, CAST (OrderDate AS date) AS 'Date of order'
FROM Sales.SalesOrderHeader
WHERE  DATEDIFF(YYYY, OrderDate, GETDATE()) = 7                            

I am concerned about the effect the  DATEDIFF expression in the WHERE clause will have on the execution plan that is decided upon by the optimizer because I know that one should not   have an expression on the lhs , so I changed it for this query and I gave me exactly the same execution plan:

DECLARE @compdate INT = 7
SELECT SalesOrderNumber, CAST (OrderDate AS date) AS 'Date of order'
FROM Sales.SalesOrderHeader
WHERE  @compdate = DATEDIFF(YYYY, OrderDate, GETDATE())  

Is there a better way of doing it ?
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.






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.