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

x

Sales

175

Solutions

363

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 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!!!
Doc-Transmittal.png
1
Python 3 Fundamentals
LVL 12
Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

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)
TimeStamp in in YEAR:MONTH:DAY:HH:MM:SS

I need a few SQL statements:
1. I want to show the following columns on a MONTH BY MONTH basis for each product:
Product1|SaleAmountForMonth|UnitsSoldForMonth
Product2|SaleAmountForMonth|UnitsSoldForMonth
Product3|SaleAmountForMonth|UnitsSoldForMonth
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:
Product1|ExpenseAmountForMonth|ExpenseTypeForMonth
Product2|ExpenseAmountForMonth|ExpenseTypeForMonth
Product3|ExpenseAmountForMonth|ExpenseTypeForMonth
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 …
0
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
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
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.

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
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
Starting with Angular 5
LVL 12
Starting with Angular 5

Learn the essential features and functions of the popular JavaScript framework for building mobile, desktop and web applications.

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

Sales

175

Solutions

363

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.