Any help with this solution is greatly appreciated!

Advertising company needs to report the Qtrly revenue amount, for ads running. More specifically: $Amount for deals with Prob > 50%, where the ad run date(s) encompasses X Qtr.

Here are the fields I have and an example:

• Amount $12,000.00 [standard field]
• Start Date 8/15/2011 [custom field created]  
• End Date 10/20/2011 [custom field created] 
• Number of run days: 67 [custom field: End_Date__c - Start_Date__c +1]
• daily rate: 179.10 [custom field: Amount / Number_of_Run_days__c]

Desired results for reporting:

Ref details for this example:

17 days (8/15/2011 -8/31/2011) 17*179.10= 3,044.78

30 days (9/1/2011-9/30/2011) 30*179.10= 5,373.13

20 days (10/1/2011-10/20/2011) 20*179.10= 3,582.09

Thank you for your time!

Karen

Greetings All,

Long time user, first time post. Looking for some help with customization of revenue schedule formulas… The default divides the $ by # of months. I need the actual monthly amount - even if there's only 1 day remaining in the month an ad starts.

Scenario: Advertising Sales co. – Opptys/products to display the amount of revenue, by month, for the Ad term. In other words: actual “ad run” $ amount, per month. Also, the number of days/months an ad will run vary. Can be 1-day to 26-months...

Here is a simple example:

• Amount Closed $12,000.00
• Ad start date 8/15/2010
• Ad end date 10/20/2010
• Total of 65 days @ 184.62 per day

# of days the ad will run in each month is:

• 16 days, first month (8/15/2010 -8/31/2010). 16*184.62= What I need displayed is: 2,953.85 August.

• 30 days, second month (9/1/2010-9/30/2010)30*184.62= "    "  5,538.46 September.

• 19 days, third month (10/1/2010-10/20/2010). 19*184.62= "    " 3,507.78 October.

ANY help is greatly appreciated! I’ve spent countless hours on the discussion boards and developer pages looking for this solution... no luck (found similar postings; not resolved).  

Thank you!

Karen

Any help with this solution is greatly appreciated!

Advertising company needs to report the Qtrly revenue amount, for ads running. More specifically: $Amount for deals with Prob > 50%, where the ad run date(s) encompasses X Qtr.

Here are the fields I have and an example:

• Amount $12,000.00 [standard field]
• Start Date 8/15/2011 [custom field created]  
• End Date 10/20/2011 [custom field created] 
• Number of run days: 67 [custom field: End_Date__c - Start_Date__c +1]
• daily rate: 179.10 [custom field: Amount / Number_of_Run_days__c]

Desired results for reporting:

Ref details for this example:

17 days (8/15/2011 -8/31/2011) 17*179.10= 3,044.78

30 days (9/1/2011-9/30/2011) 30*179.10= 5,373.13

20 days (10/1/2011-10/20/2011) 20*179.10= 3,582.09

Thank you for your time!

Karen

- Products Pricebooks

- Record Types

- Workflow

- Validation

Working 3 projects & need help ASAP.  Be local (US) & willing to sign NDA. 

If replying include your name, phone # & email address.  Looking for independents only! 

Please submit resume to jobs@sfdcjobs.com

Administrators (Location Flexible) 

The Salesforce.com Administrator will be responsible for support and enhancement of the company’s Salesforce.com environment.  The Salesforce.com Administrator will maintain, enhance and create workflows, functions and configurations within the Salesforce.com environment. The Administrator will provide system administration of the Salesforce.com environment and create new reporting capabilities and respond to ad hoc reporting requests as needed. The administrator will provide support functions as needed and work with business and technical team member to drive projects related to Salesforce.com. Desired skills:

·        2 to 3 years experience in CRM system support and administration with a specific focus in Salesforce.com 

·       Strong reporting background using standard BI tools and Salesforce.com reporting tools. 

·       Previous re-engineering experience updating an existing Salesforce.com configuration to provide solutions for reporting, workflows and enhanced functions. 

·       Salesforce.com Administrator certification required. Advanced certification preferred 

In addition to Administrator positions, we are hiring full-time and contract for the following:

Engagement Manager (Location Flexible)

The Engagement Manager builds strong, trusted relationships with clients around the implementation of Salesforce.com. The Engagement Manager is the primary liaison with the client executives and project sponsors. The Engagement Manager will effectively and strategically manage a project/projects. The Engagement Manager is able to scope, architect, conduct requirement sessions and assist in technical architecture in a Business Process Review.  The Engagement Manager is responsible for risk mitigation, resource management, quality assurance, the User Adoption Strategy and post-deployment transition. Desired skills:

·        Bachelor’s degree required

·        5+ years of CRM consulting experience

·        3+ years leading dynamic and highly effective teams

·        Effective interaction with Senior Management

·        Outstanding  oral and written communication skills

·        2+ years hands on with packaged applications (Salesforce.com, Siebel, SAP or similar enterprise-level applications)

·        Analytical approach to identifying business challenges; visionary and creative approach towards their solutions

Functional Consultant (Location Flexible)

The Consultant will work with clients to implement solutions around salesforce.com.. This role is able to scope, architect, conduct requirement sessions and assist in technical architecture in a Business Process Review. The Consultant will manage implementation projects from post sale to post go-live. The Consultant will manage resource requirements on each project and write customer deliverables and implementation plans. The Consultant will provide customer training as required and configure Salesforce.com.  Desired skills:

·        Bachelor’s degree required

·        4+ years of consulting experience (1+ years of CRM consulting)

·        2+ years hands-on experience with one or more CRM applications (Siebel, Clarify, Vantive, Peoplesoft, SAP, NetSuite or other enterprise application)

·        Salesforce.com Configuration experience preferred

·        Salesforce.com Certifications preferred

Sales Engineer (Chicago, San Francisco) 

The Sales Engineer is responsible for presenting company and Salesforce.com's product offerings and architecture in the best light to prospects and customers, to evoke confidence in the technology infrastructure, and removing all technical objections in the sales cycle.  Sales Engineer must understand the needs of prospects and translate those needs into a demonstration of Salesforce.com's functional and technical capabilities. The Sales Engineer will build and present customized demos. The Sales Engineer will present Salesforce.com's technology infrastructure, including demonstrating deep familiarity with salesforce.com hardware, software, networking and security stack. The Sales Engineer will participate in all appropriate product, sales, and procedural training and certification to acquire and maintain the knowledge necessary to be effective in the position. The Sales Engineer will respond effectively to RFPs. Desired skills:

·        B.S. Computer Science, Software Engineering, MIS or equivalent work experience

·        Previous experience as a sales engineer for a CRM product

·        Knowledge of related enterprise applications, relational database and web technology

·        Basic programming experience in HTML and other web based technologies

·        Solid oral, written, presentation and interpersonal communication skills

·        Proven time management skills in a dynamic sales environment

·        Ability to work as part of a team to solve technical problems in varied political environments

·        Ability to travel domestically

Account Executive (Portland, San Francisco, Los Angeles) 

The Account Executive is responsible for building and maintaining customer relationships, from pursuing leads to closing the final sale and identifying potential upside sales. The Account Executive will work closely with prospects to understand and analyze existing business issues, and apply existing solutions in the form of a proposal.  The Account Executive will monitor the customer engagement through implementation and maintain customer relationships from the initial engagement through the lifecycle of the relationship. This position carries a quota and is compensated through a combination of base + commission. MBA strongly preferred; commensurate business or consulting experience is acceptable. Desired skills:

·        2+ years of CRM domain experience (Salesforce.com, Siebel, SAP or similar enterprise-level applications)

·        2+ years leading account executive/sales experience

·        Effective interaction with C-suite executives

·        Outstanding and professional oral and written communication skills

·        Analytical approach to identifying business challenges; visionary and creative approach towards their solutions

In my .net application I'm trying to attach a campaign to a new lead using the API. Creating new lead works fine when I'm not trying to pass a campaign to it. I'm trying to locate the campaign by id, load t into a campaign object, pass that campaign object to the lead and create lead. I do locate the campaign using the query but I may be missing a step. I get error: "Invalid foreign key relationship name Campaign".

Please help.

 The code

objSF.Url = l.serverUrl;
objSF.SessionHeaderValue = new SessionHeader();
objSF.SessionHeaderValue.sessionId = l.sessionId;
GetUserInfoResult userInfo = l.userInfo;

// Adding new lead to SalesForce.com //
sObject[] aLeads = new sObject[1];
Lead lead = new Lead();
lead.FirstName = FirstName.Length > 25 ? FirstName.Substring(0, 25) : FirstName;
lead.LastName = LastName.Length > 25 ? LastName.Substring(0, 25) : LastName;
lead.Company = CompanyName.Length > 50 ? CompanyName.Substring(0, 50) : CompanyName;
lead.Title = Position;
lead.State = StateAbbr;
lead.PostalCode = Zipcode;
lead.Phone = "NA";
lead.LeadSource = "Web";
if (CameFrom == "Demo") strLeadStatus = "New Lead";
lead.Status = strLeadStatus;
string strLeadSoureDetail = "Community";
if (CameFrom == "Demo") strLeadSoureDetail = "Online Demo";
lead.Lead_Source_Details__c = strLeadSoureDetail;
lead.Email = Email;
lead.Practice_Specialties__c = "Unknown";
lead.Num_Providers__c = 1;
objSF.Url = l.serverUrl;
objSF.SessionHeaderValue = new SessionHeader();
objSF.SessionHeaderValue.sessionId = l.sessionId;

// Adding campaign to the lead //
//Web - Community Campaign ID: 701400000009wgw
//Web - Online Demo Campaign IS: 701400000009kBS
string strCampID = "701400000009wgw";

if (CameFrom == "Demo") strCampID = "701400000009kBS";
QueryResult qr = new QueryResult();
objSF.QueryOptionsValue = new QueryOptions();
objSF.QueryOptionsValue.batchSize = 250;
objSF.QueryOptionsValue.batchSizeSpecified = true;
qr = objSF.query("select id, Name from Campaign where id='" + strCampID + "'");

if (qr.size > 0)
{
for (int i = 0; i < qr.records.Length; i++)
{
Campaign camp = (Campaign)qr.records[i];
lead.Campaign = camp;
}
}

// Community Section //
lead.First_name__c = FirstName.Length > 25 ? FirstName.Substring(0, 25) : FirstName;
lead.Last_Name__c = LastName.Length > 25 ? LastName.Substring(0, 25) : LastName;
lead.NGC_ProfileID__c = ProfileID.ToString();
lead.Username__c = UserName.Length > 50 ? UserName.Substring(0, 50) : UserName;
lead.Primary_Email__c = Email;
lead.Company_name__c = CompanyName.Length > 50 ? CompanyName.Substring(0, 50) : CompanyName;
lead.Industry__c = IndType.Length > 50 ? IndType.Substring(0, 50) : IndType;
if (PositionDesc != null)
{
lead.Position__c = PositionDesc.Length > 30 ? PositionDesc.Substring(0, 30) : PositionDesc;
}
lead.Created_Date__c = DateTime.Now;
aLeads[0] = lead;

SaveResult[] sr = objSF.create(aLeads);