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

I have a query where I am trying to get one line for each sales agent for a particular month, with total sales for that agent for that month. I can't get the syntax. I have tried everthing I know of and it's probably very simple. the date field is called paid date. Can anyone help me?
I only have three columns in my query, 1. Agent, 2. Sum of Price and 3.  Paid date. The Agent is group by,  the Sum of Price field  is summed and the Paid Date  field is group by
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.

So, I've done some AMAZING research and found...some VERY out-of-the-way places.  I'm thinking of building a Google map.

But, seems like then anyone could take the same data and recreate it.

Don't want to debate the merits of information be free.

Need suggestions about to monetize the work that I've done.  Sharing it puts it out there.  I can see that.  But...what can I consider to do with the page that holds the information?  Or, even the map itself? Should I even MAKE a map?  How can I use what I've got?  One suggestion I can see is...if my page is popular enough, put the map in there and let people who would copy it...go ahead.  A more popular page will always win the day.

Thanks!

OT
0
I have plotted sales revenue graphs on all the items under a certain brand.

From the graphs that I have plotted, can you help me identify any patterns or trends in the sales of each of the items under the brand? :)

Charts.xlsx
0
I am trying to write a query in oracle for sales vs received per day of the same item.

Basically I have two identical tables with the exception of one column - one tables shows sales per day, the other shows received per day.

I need to write a report showing the sales AND received per day on the same line, even if one or the other is zero.

How do I write this particular query?
0
Hi,
I am building an integration for Microsoft Dynamics 365 especially for Sales product in it.
The plan is the following -
Any user within a company who is using Microsoft dynamics 365  can install my application. My application i have registered on Azure portal.
After doing OAuth for a particular user i intend to send him data for example the number of leads created in last month etc..
For this i will use the dynamics 365 Web APIs.
My question is will any organization be able to use it ?
Does any application registered through microsoft Azure portal allowed to do OAuth for any dynamics 365.
And will Microsoft dynamics 365 CRM allow to use the web APIS to access its data.

As i see that there are many versions of Microsoft Dynamics 365.
I have doubt regarding this.
I have also heard about developer service account.. Where does that fit into here.. If i have to build such an application.
Thanks
0
Hi there,

I am looking for a partner portal which enables my company to organize and streamline questions and requests from partners. Moreover, things like static technical sales and technical information, ticketingsystem, partner status (level & training), onboarding process are very welcome. My company is active in the contact center industry where it sells its contact center solution through partners.

Any advice will be appreciated!

Kind regards,

Joep Vreeswijk
0
Dear Experts

Our organisation has decided to implement ERP -   our management is convinced with SAP to be chosen however not yet finalized, our objective is to have one unified solution across the organisation at present we are using sales force.com for marketing and sales function,
1. would like to understand does SAP has capability for sales force automation and does it support the integrations like CTI, web, face book, mainly does it allow web API integrations
2, if not SAP please suggest other ERP product which can handle sales force automation and other process, we are in real estate vertical (we do not construct we only sell the flats).
3. what all the measures to be taken to implement ERP,  is CIO needed as the technology is one part, do we require Consultant who has implemented in our vertical and project manager who leads the implementation,
4. please help me with the list for the need of technology and IT head role in detail for this project similary consultants and Project Manager and what are various types of roles to be put in place to choose and start ERP implemtetion who can drive and implement successfully.
5. Please let me know the approach or methodology for implementing the  ERP what top management should do and what all the roles to be created to implement the ERP, thanks
0
Getting started with EventBrite

I am new to the web seminar business and need to rely on proven platforms for max guidance, so I cam spend my time prepping my seminar.

Has anyone used EventBrite for ticket sales?

Promotion?

Organizing event schedules and attendee lists?

 would be happy to hear from you and perhaps with some guidance about the steps I need to take.

Thanks
0
I have a client with an office365 account with a single e-mail address 'user@hisdomain.com'.  This user does outside sales work for other companies that have their own e-mail systems and domain names, and they have created e-mail addresses for my client in their domains 'user@theirdomain1.com and user@theirdomain2.com'.
My client uses office365 OWA, Outlook and Outlook for Mobile to access email
We currently have forwarded 'user@theirdomain1.com to user@hisdomain.com'.  When my client receives an e-mail from 'user@theirdomain1.com' they want to be able to reply to the e-mail and change the 'from' address to 'user@theirdomain1.com'
How can I set this up in office 365 so they are able to change the 'from' address to the proper Domain for the reply to keep e-mail continuity?
Thank you
0
Hi,

We are working with a marketing strategy  for assisting surveying certain areas.  The front end is a screen with a series of questions which will later be analyzed.  Our concern to EE  is how can we protect or make sure that visitors are not repeating the questionair.   Also, detect if same ip or if the visitors somehow hiding their ip.  We are trying to assure the visitors is one visit per actual visit to the pages, no repeats.

Please advice.
0
Free Tool: IP Lookup
LVL 12
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

Need to launch a nationwide speaking tour but need a plan involving Social Media Marketing

I have a timely book whose message needs to be heard by the world, ASAP. And I hope to start a tour going from Boston to New York City, then on to Washington, the general routes of the carnage on 9/11/2001. I want book signings at various book sellers, some small free presentations at locations where I would get a warm audience and live presentations where I will sell tickets. It's the ticket sales which will be paying my travel costs, I think, rather than the books sales.

So, I look to my ability to schedule online presentations at no cost as the way to generate the traction I can use as I start to book physical speaking engagements.

For example, I am thinking about using online presentations like a Ted Talk, or even crowd funding to get it going.

You can see, my book topic is like none other, and has wide appeal, given it contains the secrets of secret societies, hidden in plain sight. And it proves there is much we do not know about America's history of massacres, on the occult date of 9/11 (September 11th in America and November 9th in Hitler's Germany)

https://www.amazon.com/Fortress-Harvard-ThinkTank-Royal-Revenge-ebook/dp/B077ZS8XJ7/ref=sr_1_2?ie=UTF8&qid=1513561863&sr=8-2&keywords=fortress+harvard

What is involved with making a Ted Talk?
What can you tel me about Crowd Funding?

I WILL use someone like GoFundMe. The 5% is NOT AN ISSUE for me.

I want quick…
0
Hi, I wonder if I could get a little advice with regards to the direction I should go with my website please. I'm an independant Windows software developer and I'm about to release a major upgrade of my one of my softwares "The DataSurgeon" (www.thedatasurgeon.net). Up till now, sales have been pretty thin, partly I suppose because marketing is not my strength, and also being a one-man show - I don't have a lot of time for it while trying to simultaneously do software development. Partly too, is that the software itself is sort of a multi-purpose package and I find it hard to explain it in a succinct, brief and "punchy" way (hence the reason why my current site is so wordy). It's a unique and specialized software for people who work with very large raw data files (ie. data warehouse, data archivists, IT back office people, contact list vendors/brokers, etc). It lets them (1) Easily do complex queries at a very low character-level (2) Modify/fix those found matches (3) Perform tallies and aggregates on the matches found. In effect, it does things easily that normally one would need to hire a programmer to accomplish - I guess that's my best angle here. I really don't know what to compare it to other than an easy to use "regex engine" or "grep software" without the learning curve. And again, it's much more than that.

Anyway, the existing format/layout of my website is clearly not hitting homeruns. I realize the current capture page is not the best and fanciest thing going, …
0
Hi Experts

Sorry people may be I mislead you. All what I want is how to include a productID range within Dsum

Dsum(“Closing”,”QryOpFinalstocks”,” [ProductID] = “ & Forms![<formname>]![<controlName>]& “ And [Warehouse ID] = “& Forms![<formname>]![<controlName>]& “ And [PPDate] <= “#& Forms![<formname>]![<controlName>]& “ #” )

I need that so that the selected code from the form query are picked correctly

How do we insert a product ID range in the above code??????????????

Regards

Chris
0
Hi all Experts!

I want your help on cost of sales, the second sub report attached to the invoice is supposed to calculate the cost of goods sold. At the moment staff are keying in the calculated average unit cost of the products manually which is prone to errors, and so to try and solve this problem I have created the code below, the idea here is that, the code will first sum all the total invoices values and then divided by the sum of all units for that product bought, the result is supposed to be an average cost per unit. But it is giving an error, any idea?

Private Sub Form_BeforeInsert(Cancel As Integer)
    Me.Cost = (Dsum(“TotalCost”,”tblInventory”,”ProductID = “ &Me.ProductID))/ (Dsum(“QuantityBought”,”tblInventory”,”ProductID = “ &Me.ProductID))
End Sub

Before select the product Id I have also notice an error, it disappears temporary after product ID selection. I understand there is a function in Ms Access called ISERROR(Value)that can suppress this error but I’m not sure how to use it.

Accomplishment

Here what I want to archive is that the moment a product ID is selected, the cost field on the form must be field and once the form was finished and saved then the cost should be inserted in the underlying table. Does this sound possible?

Regards

Chris
0
Need a ticket management system for a speaking tour

I need an easy to configure ticket sales service with some basic features:

- At first I will give tickets for free
- I want to switch to charging money per ticket, with the flip of a switch
- I'd like eventually offer the first X tickets for free, then charge a fee after that the free tickets have been taken

I need to support multiple speaking dates with multiple locations

I have no merchant credit card service and need a service which combines payment processing.

I need to accept many payment methods and not require a person to have a PayPal account in order to use a Visa card.

What are some choices?

I do have a WordPress site with a WooCommerce plug-in. But I suspect I would get up and running faster if a choose a full-service website for this.

Thanks
0
Hi Experts

I have four controls on a form as below:
1.      Total sales
2.      Cash Received
3.      Change
4.      Shortage
The shortage control will only filled in if the cash received is less than total sales , quite okay I have this VBA Code below , but I want the message part to be showing numbers or amount showing as shortage in the string as well.
If (Me.TotalSales > Me.CashReceived) Then
Beep
MsgBox “Please note that you received not enough cash for this transaction”
Cancel = True
Exit Sub
End If

Now suppose the shortage amount is $20, our business rule require that in the message the $20 should appear as well, example:
MsgBox “Please note that you have received not enough cash for this transaction, and so you have a shortage of $20, please check again”
0
I wanna buy a tablets for sales staff at the company to use Citrix Apps and also to track their track.

1- What are the best brands with best price.
2- These tablets must be easy to monitoring by auditing account staff.
3- Is there a mobile printer that can be connected to the tablets and what are the best types?

Thanks
0
The user feels that the apartments they rent out have been unfairly reviewed on Google reviews.  Some of the reviews are over 5 years old. They have lots of maintenance records to support that they took care of any repair needs that the renters had, and a long history of good service.  

Is there anything they can do to remediate the old reviews? Any insight into the process of Google Reviews?


Thanks.
0
My weeks start on a Saturday and end on a Friday. In TSQL how can I return the correct quarter?

For instance if I have a weekly sum of sales that is from week '12/30/2017' is there a way to convert that value to Qtr1?
0
Cloud Class® Course: Microsoft Azure 2017
LVL 12
Cloud Class® Course: 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 two tables. One Table has Weekly Sales by Store and by Week. Our week starts on a Saturday and ends on a Friday. The second table defines the week and all the dates within it.

Is there a way to use both tables so I can come up with average sales across all the different days. Sales differ by week and so the daily average would be different if spread across the days.

The use case of this dataset would be to upload it to another system that only accepts sales by day instead of week.

I have uploaded an example. Columns A-C represent the first table. Columns E-F represent the second table. Columns H-J represent the results I am looking to achieve.
Example.xlsx
0
I was once told that ending a sale on Sunday at 6PM PST was best for maximum prices on auctions. That meant it was 9PM EST and Sunday, the most people were browsing Ebay.

Is this true?

I find myself holding back a sale until that time each week, so I can end at the time, but this slows me down.

I have a laptop to sell, and wanted to hit the sweet spot on that.

So, I wanted to ask.

Thanks.
0
1-In the reports tab, under the monthly sales, how can I add a profit and loss for the month?
2-How to delete a completed related customer?
0
I'm almost finishing the point of sales application in ms access , now I have three issues:

(1) While on the form I have developed a code using Dsum that calculate the current stock balance immediately when a user select the stock code,this code give an error before the stock code selection is made , I feel like it will scare the users. The error is caused by the fact that at that point the product ID is not yet select and the code is evaluating a null value. How do I suppress this ? Otherwise the code works well.

(2) I have also tried to include a control called Quantity Sold within Dsum so that when a user punches more stock than on file it should not accept saving

((DSum("QuantityReceived","QryPurchases","[ProductID]=" &[ProductID]) - DSum("QuantitySold","QrySold","[ProductID]=" &[ProductID])) - ([Quantity Sold])) (This is housed in a control called [stock control])

Now I'm trying to attach a code to control called [Quantity Sold] which will not accepted if stock is more than what is on file.

Private Sub Before update_ Quantity Sold( Cancel as integer)
If (Stock Control < = 0) Then
Beep
MsgBox " Please check your inventory you do not have sufficient stock"
Cancel = True
Me.Quantity Sold.Setfocus
Exit Sub
End If
End Sub

The above code is giving an error it does not want to exit, where have I gone wrong????

(3) How do we format our ms application to print on pos printer? example receipt not those A4 pages????????

Regards


Chris
0
Trying to build a report but I am running into several issues. The first should be simple: I need to label the total field for a group of items. The group name is in the database, as an entry of 0 for a section. I have attached an example of how the database table is laid out. Basically, in the group footer with the subtotals I want to pull a record for the description where the section entry is a 0.

The second issue is more complex: I want to show previous years sales data and compare it with current year. the date selection in the report has a start date and an end date. This field is set up YYMM, like 1711 for November 2017. The record is stored as a character type though, which makes subtracting a digit difficult. I already have the report built to show current year data for whatever date range is entered, an example is attached
GroupDB.PNG
SaleReport.PNG
0
For Ms Access 2016 the size is 2GB, if we have 100 tables in BE how do we create 20GB space? Its just a suggestion what if we do the following:

(1) Put all related tables with referential integrity in one backed for example a sales accounting will have the following tables :
 - customers
 - Price details
 - Invoice
 - Invoice line datails
 - Products
 - Receipts/Line details
 - Credit notes/Memos
As long as the RI remain intact in blocks of 10 (Total BEs required 10)why can't an application work well, even I have not tried it , I still think that is the other way to get around  2GB limit

Any suggestion?

My current BE has 110 tables but is seating at 2.56MB while my FE is at 11.15MB which quite okay, I'm simply looking at the future, I have seen the challenges on migration , its very involving see below:

 Implementation

Configure SQL Server
Use the data diagram that is part of your development plan to implement the first
version of SQL Server objects, such as tables, views, and stored procedures.
Implement users, groups, and roles as needed. It is important to have these
objects in place before development starts—developers can’t work against a SQL
Server backend that isn’t there. Don’t worry about performance optimization yet,
that happens later.

Development

Based on your development plan, staff your development team and provide the
resources necessary. Make the existing Access application available to the team
for use a benchmark or …
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.