Salesforce Developer Community

Chatter

Feed
0

Best Answers
0

Likes Received
0

Likes Given
13

Questions
17

Replies

1 replies

order by grand total column in a matrix report

Is there a way to sort (order by) the grand total column in a matrix report??

If so, how??

Thanks for your help!

Karen

NewGirl
April 25, 2011
Like
0

SOLVED

2 replies

Test Case Trouble! Please Help

I run my test case (see below) and it only covers it 60%. when I read the detailed output it doesn't look like the trigger is working? thanks for your help! After the test case I listed the debug log....

Also why do my System.assertEquals statement return : System.assertEquals(ANY, ANY) - instead of the value???

Thanks for your help!

Karen

@isTest
private class ConvertOppLIQtyTest{
    static testMethod void testOppLIQty(){



    //Setup the Account record
    Account a = new Account(Name = 'Test Account');
    a.Type = 'Customer';
    insert a;

    // Verify that the initial state is as expected
    a = [SELECT Name, Type
        FROM Account
        Where Id = :a.Id];
    System.assertEquals ('Customer', a.Type);

    // setup the Opportunity record

    String opportunityName = 'Test Opportunity';
    Opportunity o = new Opportunity(AccountId=a.Id, name=opportunityName, StageName='4 - Closed Won', CloseDate = Date.today(),PO_Number__c='999', Order_ID__c='999', opp_ship_to__c='017' );


    insert o;

    opportunity opp = [select name from opportunity where Id = :o.Id];
     System.assertEquals (opportunityname, opp.name);

//     ----------------------------------------

     // set up product2 and Verify that the results are as expected.
        Product2 p2 = new Product2(Name='AMS300',isActive=true);
        insert p2;
        Product2 p2ex = [SELECT Name FROM Product2 WHERE Id = :p2.Id];
        System.assertEquals('AMS300', p2ex.Name);

// set up PricebookEntry and Verify that the results are as expected.
        PricebookEntry pbe = new PricebookEntry(Pricebook2Id='01s700000002a7TAAQ', Product2Id=p2.Id, UnitPrice=99, isActive=true);
        insert pbe;
        PricebookEntry pbeex = [SELECT Pricebook2Id FROM PricebookEntry WHERE Id = :pbe.Id ];
//       System.assertEquals(standardPriceBookId, pbeex.Pricebook2Id);

// set up OpportunityLineItem and Verify that the results are as expected.
        OpportunityLineItem oli = new OpportunityLineItem(PriceBookEntryId=pbe.Id, OpportunityId=o.Id, Quantity=1, TotalPrice=99);


//------------------------

            // set up product2 and Verify that the results are as expected.
        Product2 p2a = new Product2(Name='AMS305-10PK',isActive=true);
        insert p2a;
        Product2 p2exa = [SELECT Name FROM Product2 WHERE Id = :p2a.Id];
        System.assertEquals('AMS305-10PK', p2exa.Name);

// set up PricebookEntry and Verify that the results are as expected.
        PricebookEntry pbea = new PricebookEntry(Pricebook2Id='01s700000002a7TAAQ', Product2Id=p2a.Id, UnitPrice=99, isActive=true);
        insert pbea;
        PricebookEntry pbeexa = [SELECT Pricebook2Id FROM PricebookEntry WHERE Id = :pbea.Id ];
//        System.assertEquals(standardPriceBookId, pbeexa.Pricebook2Id);

// set up OpportunityLineItem and Verify that the results are as expected.
        OpportunityLineItem olia = new OpportunityLineItem(PriceBookEntryId=pbea.Id, OpportunityId=o.Id, Quantity=1, TotalPrice=99);


    Test.startTest();
          insert oli;
          insert olia;
    Test.stopTest();



    }
}

---------------------------------DEBUG LOG----------------------------------------------------------------

NewGirl
April 25, 2011
Like
0

4 replies

Trigger - multiple iterations when inserting multiple line items at once to opportunitylineitems

I have written a trigger to update the amount and quantity on the opportunitylineitems table.

It works fine if I am insertingonly one product to the opportunitylineitem. However, if I am writting 2 or more products (line items) it runs through tthe trigger multiple times and I end up with incorrect data.

Any help would be appreciated!!

thanks,

Karen

trigger opplineitemstest on OpportunityLineItem (before insert, before update){

Set<Id> OrderLineIds= new Set<Id>();
Set<Id> LineItemIds= new Set<Id>();

Set<String> PBEIdSet = new Set<String>();
Set<String> Prod2IdSet = new Set<String>();

    for (OpportunityLineItem insertedlineitem : system.Trigger.new)
    {

System.debug('INSIDE OPP FOR LOOP!!!');

        if (insertedlineitem.PricebookEntryId  != null) {
System.debug(insertedlineitem.PricebookEntryId );
            PBEIdSet.add(insertedlineitem.PricebookEntryId );
        }
        List<PricebookEntry> ParentPricebookEntry = [SELECT Product2Id
                                            from PricebookEntry
                                            where id in :PBEIdSet];
        for(PricebookEntry pbes: ParentPricebookEntry) {
            if (pbes.Product2Id != null) {
                System.debug('PROD ID ' + pbes.Product2Id);
                Prod2IdSet.add(pbes.Product2Id);
            }
            List<Product2> ParentProd = [SELECT ProductCode
                                                   from Product2
                                                   where id in :Prod2IdSet];
            for(Product2 prods: ParentProd) {
                System.debug('PROD CODE ' + prods.ProductCode);
                if(prods.ProductCode == 'AMS300' || prods.ProductCode == 'AMS305' || prods.ProductCode == 'AMS310-5PK' || prods.ProductCode == 'AMS350-5PK' || prods.ProductCode == 'AMS505' || prods.ProductCode == 'MDS405') {
                   System.debug('BEFORE QTY ' + insertedlineitem.quantity);
                   insertedlineitem.quantity = insertedlineitem.quantity * 5;
                   insertedlineitem.unitprice = insertedlineitem.unitprice / 5;
                    System.debug('AFTER QTY ' + insertedlineitem.quantity);

                }

                if(prods.ProductCode == 'AMS300-10PK' || prods.ProductCode == 'AMS305-10PK' || prods.ProductCode == 'AMS600' || prods.ProductCode == 'AMS604' || prods.ProductCode == 'AMS607' || prods.ProductCode == 'AMS612'|| prods.ProductCode == 'AMS700') {
                   insertedlineitem.quantity = insertedlineitem.quantity * 10;
                   insertedlineitem.unitprice = insertedlineitem.unitprice / 10;
            }
System.debug('77');
        }
        }
        system.debug('END OF OPPLINEITEM LOOP');
        }
        system.debug('end!!!!!');
        }

NewGirl
April 19, 2011
Like
0

2 replies

Need Help with a simple trigger...

I am trying to update opportunitylineitem quantity when the productcode equals a certain value.

I wrote the below trigger as a first pass before I put in more detailed code.

I am receiving a compile error :

Compile Error: Invalid field productid for SObject OpportunityLineItem at line 10 column 86

I highlighted the field that is in question in red.

thanks for ANY help!!!!

trigger convertproductqty on OpportunityLineItem (before insert, before update) {

// string ProdCode;

Opportunitylineitem[] OppLI = Trigger.new;

for(OpportunityLineItem s:OppLI){

if (s.productid != null)

{

string prodcode = [select productcode from pricebookentry where product2id = :s.productid].productid;

if (prodcode == 'AMS300')

{

s.quantity = 999;

}

NewGirl
April 15, 2011
Like
0

2 replies

Advise requested

I have two systems one is an ERP system...that will allow me to get the data out in a CSV or excel file, the other is Salesforce. I have about 5000 accounts in each of them. I need to update salesforce accounts (a custom field) with the organization id from the ERP system.

Does anyone know an easy way to do this? How will I match the 2 up...based on account name and address.

Its difficult to compare S. Main St. with South Main Street.

Is there a tool that could at least help update all the exact matches? I imagine it wouldn't reconcile all 5000 records but maybe a few thousand.

Please advise!

NewGirl
February 02, 2011
Like
0

SOLVED

2 replies

Where can I find a user's user id?

When I say "user id," I mean literally the ID, the primary key of the user record, like 00530000000elgt?

Thanks for your help!

Karen

NewGirl
January 18, 2011
Like
0

12 replies

How do I evaluate a check box field in an apex trigger

I have a custom field called Really_Big_Deal__c that is a data type "checkbox".

I need to evaluate it in an apex trigger. I know checkbox is a boolean - what do I need to do to evaluate this?

The code is as follows...

trigger OrderOwnerUpdate on Opportunity (before insert, before update) {

//change the owner from customer service to RSM

ID TerritoryId;

Opportunity[] opp = Trigger.new;

for (opportunity s:opp)

{

if (s.name != null)

{

ID OpportunityOwnerId = [Select User_id__c from territories__c

where name = :s.opp_ship_to__c].user_id__c;

s.ownerid = OpportunityOwnerId;

if ((s.amount >9899) && (s.Really_Big_Deal__c == true ))

{

s.addError('Check Big Deal Field if sale is over $9899.00');

}

Thanks for any insight to this issue!

Karen

NewGirl
January 10, 2011
Like
0

3 replies

Need a Message on Field Validation - but then proceed with process

I have created a field validation - but once the error is displayed I want to continue...

Is this possible?

Thanks for your help!

NewGirl
January 10, 2011
Like
0

SOLVED

2 replies

Need Help with test case....

Hello All -

I am new to SF and I just wrote my first apex trigger. I believe that in order to deploy the trigger into production I need to write test cases? How and where do I do this? I have looked at samples but they seem complex?

Any help would be great!

Below is my trigger....

Thanks!!!

trigger OrderOwnerUpdate on Opportunity (before insert, before update) {
//change the owner from customer service to RSM
ID TerritoryId;

Opportunity[] opp = Trigger.new;
for (opportunity s:opp)
  {
    if (s.name != null)
        {
            ID OpportunityOwnerId = [Select User_id__c from territories__c
            where name = :s.opp_ship_to__c].user_id__c;
            s.ownerid = OpportunityOwnerId;
        }
  }

}

NewGirl
January 06, 2011
Like
0

2 replies

How can I do look up field on the opportunity product table?

I have a custom object (table) and I need to do a related list with the opportunity product table.

Thanks for your help!

NewGirl
November 04, 2010
Like
0

2 replies

Scaning barcode into SF - how to parse string into different fields

Hello All -

I need to scan a barcode into a salesforce screen. How do I then break up the barcode string into different salesforce fields?

Thanks for you help!

NewGirl
November 02, 2010
Like
0

2 replies

Show Report folder from a Custom Tab??

I have created a custom tab as well as some custom reports.

I was hoping there was a way to display the folder of custom reports from the custom tab. That way Regional Sales Managers who have access can run their reports off of the custom tab.

Thanks in advance for your help!!!

NewGirl
August 17, 2010
Like
0

SOLVED

4 replies

Trying to use length function in Sforce Explorer or Force.com Explorer

Does either Sforce Explorer or Force.com Explorer support the length function?

I can't seem to get it to work?

NewGirl
August 06, 2010
Like
0

SOLVED

2 replies

Test Case Trouble! Please Help

Also why do my System.assertEquals statement return : System.assertEquals(ANY, ANY) - instead of the value???

Thanks for your help!

Karen

---------------------------------DEBUG LOG----------------------------------------------------------------

NewGirl
April 25, 2011
Like
0

4 replies

Trigger - multiple iterations when inserting multiple line items at once to opportunitylineitems

I have written a trigger to update the amount and quantity on the opportunitylineitems table.

Any help would be appreciated!!

thanks,

Karen

NewGirl
April 19, 2011
Like
0

2 replies

Advise requested

Does anyone know an easy way to do this? How will I match the 2 up...based on account name and address.

Its difficult to compare S. Main St. with South Main Street.

Is there a tool that could at least help update all the exact matches? I imagine it wouldn't reconcile all 5000 records but maybe a few thousand.

Please advise!

NewGirl
February 02, 2011
Like
0

SOLVED

2 replies

Where can I find a user's user id?

When I say "user id," I mean literally the ID, the primary key of the user record, like 00530000000elgt?

Thanks for your help!

Karen

NewGirl
January 18, 2011
Like
0

12 replies

How do I evaluate a check box field in an apex trigger

I have a custom field called Really_Big_Deal__c that is a data type "checkbox".

I need to evaluate it in an apex trigger. I know checkbox is a boolean - what do I need to do to evaluate this?

The code is as follows...

trigger OrderOwnerUpdate on Opportunity (before insert, before update) {

//change the owner from customer service to RSM

ID TerritoryId;

Opportunity[] opp = Trigger.new;

for (opportunity s:opp)

{

if (s.name != null)

{

ID OpportunityOwnerId = [Select User_id__c from territories__c

where name = :s.opp_ship_to__c].user_id__c;

s.ownerid = OpportunityOwnerId;

if ((s.amount >9899) && (s.Really_Big_Deal__c == true ))

{

s.addError('Check Big Deal Field if sale is over $9899.00');

}

Thanks for any insight to this issue!

Karen

NewGirl
January 10, 2011
Like
0

3 replies

Need a Message on Field Validation - but then proceed with process

I have created a field validation - but once the error is displayed I want to continue...

Is this possible?

Thanks for your help!

NewGirl
January 10, 2011
Like
0

SOLVED

2 replies

Need Help with test case....

Hello All -

Any help would be great!

Below is my trigger....

Thanks!!!

NewGirl
January 06, 2011
Like
0

2 replies

How can I do look up field on the opportunity product table?

I have a custom object (table) and I need to do a related list with the opportunity product table.

Thanks for your help!

NewGirl
November 04, 2010
Like
0

2 replies

Scaning barcode into SF - how to parse string into different fields

Hello All -

I need to scan a barcode into a salesforce screen. How do I then break up the barcode string into different salesforce fields?

Thanks for you help!

NewGirl
November 02, 2010
Like
0

2 replies

Show Report folder from a Custom Tab??

I have created a custom tab as well as some custom reports.

I was hoping there was a way to display the folder of custom reports from the custom tab. That way Regional Sales Managers who have access can run their reports off of the custom tab.

Thanks in advance for your help!!!

NewGirl
August 17, 2010
Like
0

SOLVED

4 replies

Trying to use length function in Sforce Explorer or Force.com Explorer

Does either Sforce Explorer or Force.com Explorer support the length function?

I can't seem to get it to work?

NewGirl
August 06, 2010
Like
0