Sales

109

Solutions

247

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

For control purpose I was thinking that, if  a sales tax invoice is approved in the application then it should never be reprinted again the same way we do not allow the approved sales invoice not to be deleted. I know we can still delete unapproved invoice but once approved it is locked , now I want to do the same with reprinting:

(1) I'm thinking of designing a VBA code like below:

Dim Cancel as Interger
IF " approved" = Dlookup(" Status", " tblCustomerInvoices"," [InvoiceID] = " &Me.CboInvoiceID) Then
MsgBox " Please note that approved invoices cannot be reprinted"
Cancel = True
Exit Sub
End If

Can the above code stop the printing  or are there better ways of doing it , any suggestion is very welcome

I have not yet tried the code, I can clearly state here that the code is my own thinking in term of financial internal controls

By the way assuming it is okay which event should I place it on a form used to print the invoices

Regards

Chris
0
Meet the Family that is Made for Collaboration
LVL 2
Meet the Family that is Made for Collaboration

The TeamConnect Family product group as part of the Sennheiser for Business Portfolio comprising high-quality, technically well-conceived meeting solutions for business communication – designed for any meeting room and any meeting situation.

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

i want to put in a variable th sum of sales.
example:

var myvariable =
EVALUATE
SUMMARIZE('Internet Sales'
,"Internet Sales",'Internet Sales'[Internet Total Sales])

i am just getting error from SQL server management studio.
Thanks for your help
0
Hello - we have a handful of new excel spreadsheets that were created for our company by another consultant company to be used by our sales force to use for running pricing scenarios and finding sales volume figures.  the spreadsheets are very large - about 10MB.  When a user is local to the domain network here and they open one of these spreadsheets, they work fine.  But when a user who is remote to the network opens one of these spreadsheets on their laptop, everything becomes very slow, until they close the spreadsheet.  Is this an AD / VPN thing?  or what?

Thanks,
Damian
0
Sample data:
Date_sold   Qty_Sold   Product_descrip   Amt  
1/2/14             1              Apple                    $1.00
1/2/14             3              Pear                       $2.50
1/6/14             2              Pear                       $1.00
1/12/14          6              Apple                      $5.00
1/15/14           4             Apple                     $3.00
1/15 14          2              Pear                      $1.50

I want to show Qty_Sold & Amt delta (change in values) over time - day, month, quarter & year, and Product.  This has got me stumped.  I'm a Beginner DAX programmer & more experienced with Power Query.  Any thoughts?

Using this sample data< i hope to get a pivot table with Dates in Row, Product in Column, Qty & Amt in Values  What would the DAX measures to show the following:

                                Pear   Pear         Apple         Apple
                                 Qty    Amt          Qty             Amt
1/6/14                    -1     -$1.50  
1/12/14                                                  5               $4.00
1/15/14                   0          $.50           -2             -$2.00
0
Where do I find a list of email addresses that are:

- current
- opt-in
- American citizens
- with a certain political orientation

Suggestions?
0
Lenovo Laptop

Intel i7 3630QM processor
Nvidia Geforce GT 650M graphics card
8gb ram
128GB solid state drive
I have a 1TB drive as well but the SSD is ALOT faster
Red LED backlit keyboard
Windows 10
DVD/cd drive

$280 sold locally.
0
Dear Experts

I understand there are two approaches to handle the duplicate records when same prospect enters the CRM application
approach 1) append duplicate prospect data to a single record approach 2) create duplicate record and mark it status as "Repeated/Duplicated"

approach1) if we go for append duplicate prospect data to a single record would it be possible to have a marketing analysis like current month how many leads entered into SugarCRM including the duplicate leads also would it be possible to understand prospect journey touch points through multi channel showing interest.
OR
approach2)same prospect entering through multiple channels setting duplicate records to “repeated” status would be the most straightforward to implement and link it with the original lead may provide the marketing analysis like current month how many leads entered into SugarCRM including the duplicate leads and from which all campaigns and source.
if we go for approach two then the manual operation can be applied with the same treatment that is if the already existing prospect makes enquiry to the call centre then call centre user applies the same treatment that is copy/create the existing lead and mark the status as "Repeated" and attach it to the respective campaigns
Please suggest which approach in the above is  recommended and best practice , thanks in advance
0
Dear All,

Good Day,

I am now preparing the database for the sales transactions. I need to know that how to calculate the Customer's current balance from the list of transactions that he/she made.

For Example:

Customer_ID     Sales Date       Sales_Amount      Previous _Balance     Total_Amount    Debited_Amount    Current_Outstanding
      001                 01/09/17               10000                         15000                       25000                    9000                            16000
      001                 02/09/17                 5000                         16000                       21000                   15000                             6000
      001                 03/10/17                        0                           6000                         6000                     2500                             3500
      001                 05/11/17                        0                           3500                         3500                            0                             3500
      001                 06/12/17                  6500                          3500                       10000                   10000                                    0


I am using a form to enter this sales transactions for every customers and while entering a second transaction for the same customer, I need to show the current outstanding balance of the particular customer by calculating from his last transactions in the form. …
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
Sign your company up to try the MB 660 headset now
Sign your company up to try the MB 660 headset now

Take control and stay focused in noisy open office environments with the MB 660. By reducing background noise, you can revitalize your office and improve concentration.

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
The COO of AEON Co. Ltd would like to know each store’s percentage of sales from the total sales of all 12 AEON stores in Malaysia. Write the pseudocode and draw the flowchart for this program. Hint: Use array.

To check your understanding of this problem, answer these questions:
How many times the loop should be running?
→12
What will be entered by the user in the loop?
→ total sales of each store
List down all the values of the input (you can fake it but make sure the values are logic) that the user need to enter.

What will be accumulated in the loop?

From the fake values that you’ve entered, what is accumulated value?

From the accumulated value, what do you need to find?

How to find it? Where should this equation be used? In the loop or outside the loop?


Where to save it?
0
Hi
Recently I received a mail from http://www.tobuy-cn.com/
I don’t know this website is fack or real
Anyone tel me can I buy?  From this site
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
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!
0
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!
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
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):

 2017-09-05c_EE.png
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
0
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.  

>: (
2
 
LVL 7

Expert Comment

by:Brian Matis
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!)
1
 
LVL 17

Author Comment

by:Kyle Santos
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!
1
Important Lessons on Recovering from Petya
LVL 10
Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

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
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.
0
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
0
5
 
LVL 3

Expert Comment

by:Anthony Pangilinan
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.
4
 
LVL 17

Expert Comment

by:Kyle Santos
Well said.  That is one good example for sure.
0
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

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

Sales

109

Solutions

247

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.