Edit Transaction Item

3min
You can edit Transaction items, also known as line items using the respective transaction update actions. There will be scenarios when you only need to update line items instead of the entire transaction. 
Action values for different Transactions will be ("update" + Transaction Name). Ex: to update Sales Order line items, we need to use the "updateSalesOrder" action.
Supported Transactions
Sales Transactions: Estimate, SalesOrder, CashSale, Invoice, CreditMemo, CashRefund, RMA
Purchase Transactions: Bills, Purchase Orders
Update Sales Order Line Items
When updating transaction line items, set "replaceAll" to false to prevent deleting existing line items. Also, to update existing lines, include the "line" value of the line item.
Getting "line" value for existing line items
Use the key "line" to update a specific line item of the transaction and it takes the line item number as the key to achieve it. And the line number of the line item can be found under the "Additional Information" section of the respective line item in the salesforce. And if the requirement is only to add new line items, then no need to specify the "line".
Example
The following is an example of editing line item/s of a transaction. This example demonstrates editing the line items of the sales order and is also generically used to edit the line items of other transactions by modifying action values.
Request
Response
//  Create a Map to store all the data of a Sales Order
Map<String, Object> nsSalesOrder = new Map<String, Object>();
nsSalesOrder.put('internalId', '83943'); // Internal Id of the transaction 
whose line items need to be updated


// Initialize the Sales Order Line Items
List<Object> lineItemList = new List<Object>();
Map<String, Object> lineItem = new Map<String, Object>();
lineItem.put('description', 'A weapon for shooting arrows test');
lineItem.put('item', new Map<String, Object>{'internalId'=>'239'});
lineItem.put('line', 1); // Use this to update the existing line items  
lineItem.put('amount', 10);
lineItem.put('quantity', 2);
lineItem.put('grossAmt', 220);
lineItem.put('tax1Amt', 210);
lineItem.put('taxRate1', 1);
lineItem.put('revRecEndDate', DateTime.newInstance(2021, 09, 07).getTime()/1000);
lineItem.put('revRecStartDate', DateTime.newInstance(2021, 09, 07).getTime()/1000);


// Initialize the Line Item custom fields
List<Object> liCustomFieldList = new List<Object>();
Map<String, Object> liCustomField = new Map<String, Object>();
liCustomField.put('fieldType', 'boolean');
liCustomField.put('scriptId', 'custbody_checkbox');
liCustomField.put('value', 'true');
liCustomFieldList.add(liCustomField);

// Adding the Sales Order Line Item Custom Fields
lineItem.put('customFieldList',new Map<String,Object>{'customField'=>liCustomFieldList});
lineItemList.add(lineItem);

// Addg the Line Items to Sales Order
Map<String, Object> soLineitemList = new Map<String, Object>();
soLineitemList.put('item',lineItemList);
soLineitemList.put('replaceAll', false); //false means it will append to existing lines

nsSalesOrder.put('itemList',soLineitemList);

// Initialize the RequestJSON Data to be passed.
Map<String, Object> requestJSONMap = new Map<String, Object>();
requestJSONMap.put('salesOrders', new List<Object>{nsSalesOrder});
String reqJSON = JSON.serialize(requestJSONMap);

Map<String, Object> reqObj = new Map<String, Object>();
reqObj.put('version', '1.0');
reqObj.put('action', 'updateSalesOrder'); //look table above for more action keys
reqObj.put('requestJSON', reqJSON);

// Place a request to Breadwinner Global API
Map<String, Object> resp = breadwinner_ns.BreadwinnerNetSuiteAPI.call(reqObj);
System.debug(resp);
//  Create a Map to store all the data of a Sales Order
Map<String, Object> nsSalesOrder = new Map<String, Object>();
nsSalesOrder.put('internalId', '83943'); // Internal Id of the transaction 
whose line items need to be updated


// Initialize the Sales Order Line Items
List<Object> lineItemList = new List<Object>();
Map<String, Object> lineItem = new Map<String, Object>();
lineItem.put('description', 'A weapon for shooting arrows test');
lineItem.put('item', new Map<String, Object>{'internalId'=>'239'});
lineItem.put('line', 1); // Use this to update the existing line items  
lineItem.put('amount', 10);
lineItem.put('quantity', 2);
lineItem.put('grossAmt', 220);
lineItem.put('tax1Amt', 210);
lineItem.put('taxRate1', 1);
lineItem.put('revRecEndDate', DateTime.newInstance(2021, 09, 07).getTime()/1000);
lineItem.put('revRecStartDate', DateTime.newInstance(2021, 09, 07).getTime()/1000);


// Initialize the Line Item custom fields
List<Object> liCustomFieldList = new List<Object>();
Map<String, Object> liCustomField = new Map<String, Object>();
liCustomField.put('fieldType', 'boolean');
liCustomField.put('scriptId', 'custbody_checkbox');
liCustomField.put('value', 'true');
liCustomFieldList.add(liCustomField);

// Adding the Sales Order Line Item Custom Fields
lineItem.put('customFieldList',new Map<String,Object>{'customField'=>liCustomFieldList});
lineItemList.add(lineItem);

// Addg the Line Items to Sales Order
Map<String, Object> soLineitemList = new Map<String, Object>();
soLineitemList.put('item',lineItemList);
soLineitemList.put('replaceAll', false); //false means it will append to existing lines

nsSalesOrder.put('itemList',soLineitemList);

// Initialize the RequestJSON Data to be passed.
Map<String, Object> requestJSONMap = new Map<String, Object>();
requestJSONMap.put('salesOrders', new List<Object>{nsSalesOrder});
String reqJSON = JSON.serialize(requestJSONMap);

Map<String, Object> reqObj = new Map<String, Object>();
reqObj.put('version', '1.0');
reqObj.put('action', 'updateSalesOrder'); //look table above for more action keys
reqObj.put('requestJSON', reqJSON);

// Place a request to Breadwinner Global API
Map<String, Object> resp = breadwinner_ns.BreadwinnerNetSuiteAPI.call(reqObj);
System.debug(resp);
﻿
﻿
Updated 29 May 2024
Did this page help you?
Update
Custom Object