I am having difficulty developing a validation. We have a formula field that calculated contract value. The problem is you can not track history/changes to formula fields. As a work around, I was asked to create a field "Verify Contract Value" that will require users to verify the amount of the contract value by entering it in this newly created custom currency field...which I can track the changes.
I am attempting to right a validation formula that says Verify Contract Value must = contract value and if it doesn't then he user should not be allowed to save the record. Please help...I'm really new to validations. I sincerely appreciate it.
We are very new to Visual Workflow and are wondering if the following can be done.
We have an object related off of the Opportunity called ObjectA. When the user goes to the Opportunity there are multiple ObjectA records and they need to create a case off of each ObjectA (which is the child record). So we want to create a visual workflow button where a case is automatically created (with all required field filled in) on all related ObjectA records of that Opportunity.
I get the following error when I compile my apex classes:
line -1, column -1: Method 'CodeCoverage' exceeds the maximum number of allowed op codes. Please break this method into multiple, smaller methods. line -1, column -1: Previous load of class failed: CodeCoverageTest: line -1, column -1: Method 'CodeCoverage' exceeds the maximum number of allowed op codes. Please break this method into multiple, smaller methods.
repeats...
repeats...
repeats...
I had never received this error before in my sandbox. I have not changed anything in the apex since I last ran the compliation.
We currently use Cases for many types of requests. I want to split IT requests away from Account cases. I created a new object and have Googles Docs,Notes and Attachments with the new object.
I want to take all of the previous cases and move them to the new custom object. I need a note function and want to use Google notes. Is there anyway to enter all of the cases comments in Google notes? I use the Salesforce.com data loader but I do not see an option to upload under the Google.
I am an administrator that is working on someone elses code. I know the basics about Java programing and even less on apex. My goal is the get the test coverage above 75%.
Most of my errors are
"System.QueryException: List has no rows for assignment to SObject".
From what I am reading on other boards I have a basic idea of what I need to change. But once I change it, something else down the code gives me an errors.
Here is the original code
public static testMethod void testManageVendorBillDetails(){
Invoice_and_Billing_Detail__c invoiceDetails = [Select Id,Adjustment_amount__c,Amount__c, Vendor_Bill__c
from Invoice_and_Billing_Detail__c limit 1 for Update];
Then I changed it to a List<>
public static testMethod void testManageVendorBillDetails(){
List <Invoice_and_Billing_Detail__c> invoiceDetails = [Select Id,Adjustment_amount__c,Amount__c, Vendor_Bill__c
from Invoice_and_Billing_Detail__c limit 1 for Update];
But now I get an error further down the method. Here is the whole method and I will note what line (towards the bottom) that is giving me the error.
public static testMethod void testManageVendorBillDetails(){
List <Invoice_and_Billing_Detail__c> invoiceDetails = [Select Id,Adjustment_amount__c,Amount__c, Vendor_Bill__c
from Invoice_and_Billing_Detail__c limit 1 for Update];
Vendor_Bills__c vendorBillRecord = new Vendor_Bills__c();
vendorBillRecord.Bill_Date__c = System.today();
vendorBillRecord.Due_Date_On_Bill__c = System.today().addDays(10);
vendorBillRecord.Vendor_Invoice_Number__c = 'Test Bill Record';
Account vend = new Account(Name = 'Test Vendor',
Phone = '(508) 555-1212',
Fax = '(508) 555-1213',
Type = 'Vendor',
Address1__c = 'asfasd',
City__c = 'myTstVen',
State__c = 'MA',
Zip_Code__c = '2090',
Company_Name__c = 'Test Vendor',
QB_Account__c = 'QB Account Name',
Account_QB_Account_Name__c = 'QB Account Name Ven',
Account_Code__c = 'testven1');
insert vend;
vend = [select ID from Account where Name Like '%myTstVen%' Limit 1];
User userNAM = [select Id from User limit 1];
Account acct = new Account(Name = 'Test Account Name',
Phone = '(508) 555-1212',
Fax = '(508) 555-1213',
Type = 'Client',
Address1__c = '2234234',
City__c = 'ShortPayTstClnt',
State__c = 'MA',
Zip_Code__c = '2090',
QB_Account__c = 'QB Account Name',
Account_QB_Account_Name__c = 'QB Account Name',
Account_Code__c = 'aewrew',
NAM_User__c = userNAM.Id,
Generate_Tree_Report_Data__c = false,
Generate_Tree_Report_As_Of__c = date.today());
insert acct;
Contact tstContact = new Contact(LastName = 'test',
AccountId = acct.Id,
Contact_Type__c = 'Client',
Phone = '(555) 555-5555',
Contact_Region__c = 'test');
insert tstContact;
Location__c loc = new Location__c(Name = 'myTst Location',
Account__c = acct.Id,
Address__c = '12543',
City__c = '233',
State__c = 'ID',
Zip_Code__c = '2090',
Location_County__c = 'asfsd',
Active_Date__c = date.today(), //.parse('1/1/2009'),
//Location_Billing__c = 'TestLoc2',
Non_Active_Date__c = date.today(),
Non_Active_Reason_Code__c='asfsd',
Close_Date__c =date.today(),
Billing_Address_1__c = '23q234',
Billing_City__c = 'Westwood',
Billing_Zip__c = '2090',
Billing_State__c = 'MA',
Quickbooks_Account_Name__c = 'QB Account Name',
Market_Type__c='Open Market',
Contact2__c = tstContact.Id);
insert loc;
loc = [select ID, Name, Account__c, Account__r.Name from Location__c where Name = 'myTst Location' Limit 1];
Vendor_Location__c vendLoc = new Vendor_Location__c(Name = 'mytestven1 (sgfsdf)',
RecordTypeId = '01280000000BTSPAA4',
Locationnew__c = loc.ID,
Vendor__c = vend.ID,
PO_Number__c = 'sgdfds',
Commencement_Date__c = date.today(), //.parse('1/1/2009'),
Vendor_Account_Number__c = 'sgfsdf',
Quickbooks_Account_Name__c = 'QB Account Name',
Billing_Vendor__c = vend.ID);
insert vendLoc;
vendLoc = [select ID, Locationnew__c from Vendor_Location__c where Locationnew__c = :loc.ID Limit 1];
System.debug('vendloc = ' + vendLoc + ' Loc.ID = ' + loc.ID);
vendorBillRecord.Vendor_Location__c = vendLoc.ID;
insert vendorBillRecord;
invoiceDetails.Vendor_Bill__c = vendorBillRecord.Id;/*Save Error: Initial term of field expression must be a concrete SObject List<Invoice_and_Billing_Detail__c>*/
update invoiceDetails;
delete invoiceDetails;
}
We have a Force.com organization and have been using it as a development tutorial environment. Is there anyway to reset the Force.com organization back to default?
When I go into the sandbox I have to modify the intance number. Someone told me you can exclude the instance so you don't have to modify sandbox custom buttons.
We have a dilemma where we have two sandboxes. One is a temporay sandbox and the other is good for a year. We did some major development in a full sandbox that we are not ready to move to the live instance yet. The problem is that development ended up on the temporary sandbox which will expire in a few weeks. Is there a way to move our changes from a full sandbox to another full sandbox?
If there is please direct me to the reference on how to do this.
I have fields that add up the number of days. I want the formula to pick the mininum number out of the Days it has counted. What it is doing is if the number of days is zero it chooses that as its min. How do I get it to ignore zero?
Example:
NoDaysOne = 0
NoDaysTwo = 52
NoDaysThree = 60
Out of these three number of Days I want to return 52 (the real min) not 0.
We currently have a formula that does not allow the user to enter a start date less than the current period. The problem is, this formula below works with the ISNEW. Users are figuring out that if they save the new record, the next time they edit they can put in any date they want. How can I get this formula to work evertime the record is edited?
I have a check box on the cases that lets A/R know to process the account via email alert. The workflow alert is triggered when the check box is true. This has worked until we found out that if anyone created a related note and copied the parent details it kept the checkbox true. So I thought to fix this I would create a workflow (separate from the email alert) to uncheck the box if the record is new.
What happened next is that the email is sent out and then the check box is unchecked.
How do I fix this? Is there a workflow order issue or do I need to somehow combine the two workflows?
I am trying to create a report to use on a dashboard to show us the count of how many states we have opportunities in.
I have tried grouping by state but it still shows the record count. I don't want that. I want to end up with a gauge that shows the number 23 out of the 51 (states and territories).
I get the following error when I compile my apex classes:
line -1, column -1: Method 'CodeCoverage' exceeds the maximum number of allowed op codes. Please break this method into multiple, smaller methods. line -1, column -1: Previous load of class failed: CodeCoverageTest: line -1, column -1: Method 'CodeCoverage' exceeds the maximum number of allowed op codes. Please break this method into multiple, smaller methods.
repeats...
repeats...
repeats...
I had never received this error before in my sandbox. I have not changed anything in the apex since I last ran the compliation.
Has anyone noticed that the "Recent Items" in sidebar started acting weird after the Spring '12 release if you're using Chrome? When you click a link in the recent items it collapses and most of the time doesn't direct you to the new page. I noticed it in the sandboxes that were upgraded to Spring '12 over the last few weeks but figure that it was such a glaring issue that it wouldn't find it's way to production orgs; this morning, I'm seeing that the issue is in production. Is there a setting in Chrome that causes this or an oversight by SFDC's QA?
I am an administrator that is working on someone elses code. I know the basics about Java programing and even less on apex. My goal is the get the test coverage above 75%.
Most of my errors are
"System.QueryException: List has no rows for assignment to SObject".
From what I am reading on other boards I have a basic idea of what I need to change. But once I change it, something else down the code gives me an errors.
Here is the original code
public static testMethod void testManageVendorBillDetails(){
Invoice_and_Billing_Detail__c invoiceDetails = [Select Id,Adjustment_amount__c,Amount__c, Vendor_Bill__c
from Invoice_and_Billing_Detail__c limit 1 for Update];
Then I changed it to a List<>
public static testMethod void testManageVendorBillDetails(){
List <Invoice_and_Billing_Detail__c> invoiceDetails = [Select Id,Adjustment_amount__c,Amount__c, Vendor_Bill__c
from Invoice_and_Billing_Detail__c limit 1 for Update];
But now I get an error further down the method. Here is the whole method and I will note what line (towards the bottom) that is giving me the error.
public static testMethod void testManageVendorBillDetails(){
List <Invoice_and_Billing_Detail__c> invoiceDetails = [Select Id,Adjustment_amount__c,Amount__c, Vendor_Bill__c
from Invoice_and_Billing_Detail__c limit 1 for Update];
Vendor_Bills__c vendorBillRecord = new Vendor_Bills__c();
vendorBillRecord.Bill_Date__c = System.today();
vendorBillRecord.Due_Date_On_Bill__c = System.today().addDays(10);
vendorBillRecord.Vendor_Invoice_Number__c = 'Test Bill Record';
Account vend = new Account(Name = 'Test Vendor',
Phone = '(508) 555-1212',
Fax = '(508) 555-1213',
Type = 'Vendor',
Address1__c = 'asfasd',
City__c = 'myTstVen',
State__c = 'MA',
Zip_Code__c = '2090',
Company_Name__c = 'Test Vendor',
QB_Account__c = 'QB Account Name',
Account_QB_Account_Name__c = 'QB Account Name Ven',
Account_Code__c = 'testven1');
insert vend;
vend = [select ID from Account where Name Like '%myTstVen%' Limit 1];
User userNAM = [select Id from User limit 1];
Account acct = new Account(Name = 'Test Account Name',
Phone = '(508) 555-1212',
Fax = '(508) 555-1213',
Type = 'Client',
Address1__c = '2234234',
City__c = 'ShortPayTstClnt',
State__c = 'MA',
Zip_Code__c = '2090',
QB_Account__c = 'QB Account Name',
Account_QB_Account_Name__c = 'QB Account Name',
Account_Code__c = 'aewrew',
NAM_User__c = userNAM.Id,
Generate_Tree_Report_Data__c = false,
Generate_Tree_Report_As_Of__c = date.today());
insert acct;
Contact tstContact = new Contact(LastName = 'test',
AccountId = acct.Id,
Contact_Type__c = 'Client',
Phone = '(555) 555-5555',
Contact_Region__c = 'test');
insert tstContact;
Location__c loc = new Location__c(Name = 'myTst Location',
Account__c = acct.Id,
Address__c = '12543',
City__c = '233',
State__c = 'ID',
Zip_Code__c = '2090',
Location_County__c = 'asfsd',
Active_Date__c = date.today(), //.parse('1/1/2009'),
//Location_Billing__c = 'TestLoc2',
Non_Active_Date__c = date.today(),
Non_Active_Reason_Code__c='asfsd',
Close_Date__c =date.today(),
Billing_Address_1__c = '23q234',
Billing_City__c = 'Westwood',
Billing_Zip__c = '2090',
Billing_State__c = 'MA',
Quickbooks_Account_Name__c = 'QB Account Name',
Market_Type__c='Open Market',
Contact2__c = tstContact.Id);
insert loc;
loc = [select ID, Name, Account__c, Account__r.Name from Location__c where Name = 'myTst Location' Limit 1];
Vendor_Location__c vendLoc = new Vendor_Location__c(Name = 'mytestven1 (sgfsdf)',
RecordTypeId = '01280000000BTSPAA4',
Locationnew__c = loc.ID,
Vendor__c = vend.ID,
PO_Number__c = 'sgdfds',
Commencement_Date__c = date.today(), //.parse('1/1/2009'),
Vendor_Account_Number__c = 'sgfsdf',
Quickbooks_Account_Name__c = 'QB Account Name',
Billing_Vendor__c = vend.ID);
insert vendLoc;
vendLoc = [select ID, Locationnew__c from Vendor_Location__c where Locationnew__c = :loc.ID Limit 1];
System.debug('vendloc = ' + vendLoc + ' Loc.ID = ' + loc.ID);
vendorBillRecord.Vendor_Location__c = vendLoc.ID;
insert vendorBillRecord;
invoiceDetails.Vendor_Bill__c = vendorBillRecord.Id;/*Save Error: Initial term of field expression must be a concrete SObject List<Invoice_and_Billing_Detail__c>*/
update invoiceDetails;
delete invoiceDetails;
}
We have a dilemma where we have two sandboxes. One is a temporay sandbox and the other is good for a year. We did some major development in a full sandbox that we are not ready to move to the live instance yet. The problem is that development ended up on the temporary sandbox which will expire in a few weeks. Is there a way to move our changes from a full sandbox to another full sandbox?
If there is please direct me to the reference on how to do this.
I have fields that add up the number of days. I want the formula to pick the mininum number out of the Days it has counted. What it is doing is if the number of days is zero it chooses that as its min. How do I get it to ignore zero?
Example:
NoDaysOne = 0
NoDaysTwo = 52
NoDaysThree = 60
Out of these three number of Days I want to return 52 (the real min) not 0.
We currently have a formula that does not allow the user to enter a start date less than the current period. The problem is, this formula below works with the ISNEW. Users are figuring out that if they save the new record, the next time they edit they can put in any date they want. How can I get this formula to work evertime the record is edited?
