Netsuite Integration: Transaction with Item Group

In Netsuite, Item Group can group a list of child items together. I will show you in this blog how to set/get Item Group data from an Opportunity.

 

Example #1: Create a Netsuite Opportunity with Item Group

There are a few things you should be aware of:

  • You can’t specify a price to an Item Group. Item Group price will be automatically calculated by Netsuite using the total of all child items.
  • You can specify a quantity.
  • You don’t have to provide all the child items. Netsuite will handle this automatically.

 

Below is a sample request:

   
  
   ...
   ...
   
     
       
       5
     
   
   ...
   ...
   

Example #2: Create a Netsuite Opportunity with Item Group

Integrate Netsuite with Salesforce. Query a Netsuite Opportunity (with Item Group) and sync it over to Salesforce Opportunity.

 

There are a few things you should be aware of:

  • All child items will be returned in the query. If the Netsuite Opportunity has 1 Item Group consisting 2 Child Items, you will get 4 line items in Netsuite Opportunity (see example below for more example)
  • You will need to calculate the price properly. If not, you will get duplicate pricing.

 

Below is a sample response:

 

   
  
  ...
  ...
  
    
    
      
        Group 1
      
      1
      5.0
    

    
    
      
        RAM - 128 MB
      
      2
      5.0
      PC 100 RAM - 128 MB
      
        Base Price
      
      39.95
      199.75
    

    
    
      
        DVD-R 5 pack
      
      3
      5.0
      5 pack of 4.7 GB DVD-RAM discs<br>Includes 5 cases
      
        Base Price
      
      27.95
      139.75
    

    
    
      
         
      
      5
      
        Base Price
      
      339.5
    
  
  ...
  ...
  

 

To synchronise the proper amount over to Salesforce, you may consider the following option:

  1. Take the price of the Forth Line Item and put it in the First Line Item. Ignore price for all the other Line Items.
  2. Ignore price of the Forth Line Item, use child items pricing.

Get in touch today to see how WDCi can help your business.