Hi Rajaram, 

Let me clarify my problem. I have asked our Salesforce Consultants as well as those in the Cincinnati Salesforce User Group about this issue. Many people in the Cincinnati Salesforce group are running into this issue, as well as those in the Idea Exchange. I want to make sure that my Commission process is able to be implemented with an Apex Scheduler Class and Visual Flow, as of the Summer '12 release of Salesforce. 

As Director of Product Management for Visual Workflow, I am hoping you could share insight on our problem. 

It is my understanding that TBWF only trigger once. See http://success.salesforce.com/questionDetail?qId=a1X30000000JnPMEA0 , http://success.salesforce.com/questionDetail?qId=a1X30000000HvOQEA0 and more formal documentation: http://na10.salesforce.com/help/doc/en/workflow_time_action_considerations.htm.

I have Workflow rules in place that send an email to our Sales Director two weeks before an account review date for an account and triggers a flow which calculates the commission. This process needs to repeat EVERY YEAR indefinitely until the account is dead.

In addition, there are two flows to calculate commission based on how much an account has grown.

As a work around, I have built an Apex Scheduler class that sends an email and link to the flow that processes the commission to the Sales Director, two weeks before the Account Review Date. The email tells them there is an Account with an Account Review Date Two Weeks away.

However, when you click on the link to flow, you are able to get to the first screen and then the flow terminates. There is no link between flow and the scheduler. Flow doesn't know what account to lookup and grab information from and terminates. Without TBWF, there is no link between flow and where to pull the account information from. Is there a way to link flow and my Apex Scheduled Class so the flow knows what account to pull the information from?

The flow uses Lookup Account [Field] Id equals{!vaAccountID} which is a variable in flow populated with account information.

In theory, I wanted to make the Account ID from the Account With the Next Account Review Date equal to {!vaAccountID}  in flow and then the flow could complete the account lookup. However, it is my understanding that variables in flow can't exist outside of flow. 

There also needs to be a way for the scheduled apex class to determine which flow to use to calculate commission based on account growth. Is this possible as of Summer ’12?

Below is the code I have written with comments. I can provide clarification and/or screenshots of flows if needed.

Thank you for your time and attention to this matter.

May the force be with you,

Angelika (Same user as NewToSalesforce2012, my DEV account)

//implements schedulable interface

global class AccountEmail implements Schedulable{ 

global void execute (SchedulableContext ctx) 
{ 

// sends email

sendAccountEmail(); 

}
public void sendAccountEmail()

{
// allows the from address to be an organizational wide email address

 OrgWideEmailAddress Orgid = [Select Id,displayname from OrgWideEmailAddress]; 

// SOQL Query that grabs the Account ID and commission name when the Next Account Review Date is 14 days away.

    for(Account acc : [SELECT Id, Commission_Name__c FROM Account WHERE Next_Account_Review_Date__c = : system.Today().addDays(14)])
 
  {
  

// Sets up the email to be sent

Messaging.SingleEmailMessage mail = new Messaging.SingleEmailMessage(); 

// sets up to address

String[] toAddresses = new String[] {'jrampello@projetech.com'}; 

mail.setToAddresses(toAddresses);

// sets up from address to be an organizational email address

 mail.setOrgWideEmailAddressId(Orgid.Id);  

// In theory, this piece of code would set the Account ID of the Account that has a Next_Account_Review_Date to the {!vaAccountID} variable in flow, prompting a successful account lookup. However, variables created in flow don’t exist outside of flow, so I get the Apex error Variable not found

//acc.id = vaAccountID;

// sets email subject

mail.setsubject('Account Reminder');

// set HTML body with commission name and flow link. Flow link does not populate with account info.

mail.setHtmlBody('This is a scheduler-generated email to notify you that the Account Review Date of Name:  ' + acc.Commission_Name__c + '  is in two weeks. Please click the link to calculate commission: https://cs10.salesforce.com/flow/Organic_Commission_Determination_Flow?OldCommissionID=&vaAccountID=');

mail.setSaveAsActivity(false);

Messaging.sendEmail(new Messaging.SingleEmailMessage[] {mail }); 
}
}


}