Sales

84

Solutions

16

Articles & Videos

194

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

Hello All,

I wrote small query where select query will fetch the status of one ORder . If the order status is not 1 it will update the status to another status. If not found it will handle the exception.
I am made one script.In the comment can you help in recitfiying the script asap. Need this script in this format only.



DECLARE
       
        v_REFERENCE_CODE varchar2(30);
        v_status_lkp varchar2(30);
        cursor ObsoleteSalesOrder is
               select a.REFERENCE_CODE,a.status_lkp from BASE_SALES_ORDER a,BASE_SALES_ORDER_LINE b where
                    a.SALES_ORDER_ID =b.SALES_ORDER_ID
                    and a.REFERENCE_CODE ='10132834';
       
BEGIN
open ObsoleteSalesOrder;
loop
fetch ObsoleteSalesOrder into v_REFERENCE_CODE,v_status_lkp;
exit when ObsoleteSalesOrder%notfound;
loop
if v_status_lkp !=1

--Do Below update
update base_sales_order set obsolete_flag = 1 where reference_code IN ('10132834');
update base_sales_order_line set obsolete_flag = 1 where sales_order_id
IN (select sales_order_id from base_sales_order where reference_code IN ('10132834'));
commit;
DBMS_OUTPUT.PUT_LINE('SalesOrder MArked it obsolete');

else if v_status = 1
DBMS_OUTPUT.PUT_LINE('SalesOrder is in obsolete');

else
DBMS_OUTPUT.PUT_LINE ('No sales ORder Found');

--Exception handling
end loop;
--Exception handling
else
end loop;
--Exception Handling
close ObsoleteSalesOrder;            
end;
/
0
Free Tool: IP Lookup
LVL 8
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.

Dear Experts,

I have created a business to consumer website in Umbraco. I want to get started on marketing. I have linked the site with google analytics and considering how to use log4net and splunk to see what pages are being viewed but what tools/techniques can I utilise to really get it going and get the low down on all traffic. Essentially i want to see whether the google adwords are working as efficiently as possible. Any help greatly appreciated.
0
Please provide me with a URL address of the Sprint PCS add a phone program.

I know several users who all currently have a single Sprint PCS cell phone and are interested in finding the details of how they can add a second phone to their Spring PCS account using the current Sprint PCS promotion that we have heard is going on until the end of June of 2017.
0
Dear Experts

We are using SugarCRM enterprise edition for sales force automation for marketing campaigns and sales work force now we have a requirement for business intelligence solution for SugarCRM enterprise edition.
1.  I have heard of CognosBI from IBM few years ago is this still the best BI to go for.
or any other BI tool please suggest

Thanks in advance.
0
Hello my name is Troy Bilbro I have put an application in for a customer service sales rep, a cashier position and a freight receiving associate. I received a phone call from the call center a few days ago but some how I got disconnected so I'm just wanting to know if it's possible to get another call from the call center to set me up with an interview because I am still interested in employment there. I'm currently living in Springfield IL but moving to santa fe new Mexico no Tuesday 6/20/2017 my cell phone number is 217-494-5357 thank you...
0
I am just thinking about this very cliched phrase that is so often used by corporate executives. And this dawned upon me when my friend asked me what is my USP when I decided to setup a store on an online marketplace.

I am thinking of this from 2 angles:
  1. From a business angle
  2. From a product angle

Example:
What really differentiate Supermarket A from Supermarket B,C, or D?

  • They will likely be selling the similar range of brands at likely the similar prices.
  • They will likely have the similar facilities like parking, children friendly facilities, etc
  • The level of service will likely be the same

So how can a business as such really differentiate themselves? And even if they do, how can prevent it from being duplicated.

And at the end, if they really came with something unique .. is it really a uniqueness that matter to the consumers?
0
I am looking for some kind of website where I can find sample proposals for different kind of IT projects? I know I can deliver the technology to my clients but I can't write a decent proposal which probably caused me to loose several bids. I right for example I am writing one for a VDI solution for a school. Does anyone know any resources?

Thank you!

Martin
0
Hi all,
i have the unenviable task of updating an onliine sales portal made at least 10 years ago, and which links into a customers SAP system.

there are no problems when i am updating prices, but if i need to add items to the page, there is code i obviously need to alter:
onClick="buyItem('5247 BURN AID GEL 50G PK10','6.10', document.itemsform.box10.value)">

The question is, what and where does the "document.itemsform.box10.value" refer to, and can i just add to the box value if i am adding more items? i.e. if box11.value didnt exist, could i add that code to a new item?

thanks in advance
0
Hello!

I am designing a template that sales people will use to log their activity. I want to make it so that, for example, cell D3 changes to "someone@example.com" when email is selected from the drop down list in E3 or "(XXX)-XXX-XXXX" when mobile phone is selected. This is easy to be done, however, when a sales person goes to log the data they will have to erase the formula to put in the info. Is there any way it can display the data I want but then act like an empty cell when a user goes to input data?
0
Hi
I have 2 different methods which are used to forecast future product returns, the problem is that the answers from each method are drastically different - ie; one method is nearly double the forecast qty of the other (4966 vs 2689), and I'm looking for some advice on which is the most appropriate or "statistically correct" (if there is such a thing).

See attached file to better understand the methods used, and their results.

The data that is involved is Sales and Returns of a product across the product timeline.
The product timeline refers to the date from when the product was first sold, to the date when the warranty runs out on that first sale.
The warranty period for the product is eg; 36 months - so 36 months after the first sale is made, the warranty expires and the product is no longer in the Warranty Install Base (WIB).

The WIB is cumulative sales from the first sale of the product until the warranty runs out.

The first method uses the returns per month against the WIB (for that month) to provide the monthly return rate.

The second method uses the cumulative returns per month against the WIB (for that month) to provide the cumulative return rate.

The first method:
Assuming we are running the report in May, n order to project/predict the return rate for June, the report looks at the average return rate for the previous 12 months, and uses this average as the return rate for June.
Then, to predict the return rate for July, we use the  average of…
0
On Demand Webinar: Networking for the Cloud Era
LVL 8
On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Hi Guru's


I have 10 item material in sales order, 8 from 10 material already delivered and delivery status is complete.
But 2 from 10 material it wasn't delivery and delivery status "not delivered" and overall status is open.
I want to try complete this open status with "reason for rejection", but I can't do it because field reason for rejection still "blue" and can't maintain. I was try complete status with tcode MASS, but it didn't work.

So wht should I do?


Thanks & Regards,
Yulia
0
Dear Experts

please suggest me on how to convince the sales users regarding the benefits of sales force automation.  not too technically but make them understand on how it helps to them and organization, please help me here listing few points.

Thanks
0
Dear EE,

We are a small financial services entity that has 40,000 members who communicate with us across multiple channels.

I've been tasked with researching innovative, easy to interact with delivery channels that will provide great member fulfillment at 1st contact. It should work across all the channels (email, web, mobile, telephone, face-to-face, chat, text, etc).

Could you point me in the right direction to begin my research? What solutions do you hear about the most?
0
Amazon [PC Download] software program.
Anyone know  how to add a license key to an Amazon customers email?
or how other companies are including an activation license key?

I can generate bulk license keys, but do not how to include them to be used in an Amazon purchase.

Thank You
0
Hi Experts,

We have BES 5 and 12 and have BB handheld devices configured to access user's corporate mails in Exchange 2010.

Users are complaining that Auto generated mails from Salesforce are not visible (content Not visible) on BB hendhelds. those mails are visible in outlook like normal emails.

The issue is with all mails from salesforce.

as part of troubleshot, i have found http://support.blackberry.com/kb/articleDetail?ArticleNumber=000024048 and http://support.blackberry.com/kb/articleDetail?ArticleNumber=000003265 but i think these are not solution for me as the mails are delivered as normal mails instead of attachments.

if anybody has encountered such issue and resolved please provide the details so that we can try that too.

Regards,
Aanand
0
Dear Experts

One of my branch are using sales force automation software sugarcrm, we outsourced the sales force work to the agency but we facilitated the sales force automation software and we track the activities of every lead done by the sales users,
At present we have provided our domain email accounts for every sales users and also mobile device with SIM/voice and data plan for mobile devices and they use Mobile App of sales force automation for the follow-ups like outbound calls , sms, emails.
Now new Sales head joined our company he says let the agency sales users  use our software but remove all the email IDs and SIM's let the agency use their email and their SIM's for data and voice,  reason that he  says if the agency sales users  communicate  to the prospect/buyer through  their email ID which is not as per our terms then prospect reaching us we can tell that it is agency email and we are not responsible for this.
I want to put the best practice here, can you please help me with few things that go wrong if we ask agency to use their email, I request the best industry practice , please suggest.  I work as VP IT and I took initiative to implement the sales force automation software.
0
I am having an issue with some of our customer service folks - when they open an order that has had manual adjustments to pricing it automatically updates the entire order to the original item card pricing. I have went into AR > Setup > Accounts receivable parameters & checked both updates (prompts are on) and also Prices to make sure manual is a source that activates dialog. I am at a loss for what else to look into. They do not get any prompts or anything it just automatically updates it upon clicking modify even before they add anything or make adjustments.
0
Hi There!

I am trying to find  a bit of software we can load on-prem, which will serve 5-10 people, which is basically a little intranet.
Wishlist:
1) Must work on-premise
2) Be able to create pages where links to suppliers sites etc, ideally simply controlling who can see which pages inside the intranet so admin team can see different sites to sales for example
3) Link to documents

Ideally might have wiki functionality
Ideally might integrate with AD

Something simple, easy to use and cheap/free if possible.
0
All i have a problem with one of my clients.

They use Intuit POS  v9.0. Recently they noticed that some sales data was missing.  when running a payment summary report for the month of October. they noticed that only data from the 20-31 was showing up. Upon more investigation we found out that all the sales data history from 9/11-10/20 is gone. how can this be? is there a way to get it back? can users manually delete these?

where can i find out if it was deleted?

thanks
0
What Is Transaction Monitoring and who needs it?
LVL 1
What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

Let me known which kind of gifts men like most? When we are thinking about to gift a very special man in our life, then how we can get ideas about them?
0
I have come across 3 types of clients who are reluctant to jump into an ecommerce solution. They feel little workarounds are sufficient such as 1) a link to their email on the buy now button instead of a proper checkout experience. They then take it manually from there. 2) A link to an external site to place the order for their product. This is either a (2)  marketplace with many other products or an (3) external online POS system with their products.

I am certain their conversion rate in all 3 cases they would be better off with a proper on-site ecommerce solution but am at a loss to find either statistics or a couple good articles backing me up.

Would you know of any such statistics or articles I could refer to?
0
Hi,

one of our client is looking for lead generation activity in US for its newly set-up web hosting business.  Can anyone help me to share some website where we can advertise to lead generation for server hosting business at lowest cost. I have some publisher as below mentioned but I need more with lowest cost, also investing in Google but all waste.

www.buysellads.com
7search.com

thanks
0
We're a global marketplace of art and design, pioneered by the faculty/graduates/students of art and design schools around the world. Love Making Things!
0

Sales

84

Solutions

16

Articles & Videos

194

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.