suitescript - NetSuite: Need to get value Of Landed Cost Category Line Field using Transaction Saved Search

Question

I am trying to somewhat mimic NetSuite's Landed Cost feature using NetSuite's customization options (SuiteBuilder,SuiteScript etc.) and then further extend the functionality according to my requirements.

For this I need to in script, get value of "LANDED COST CATEGORY" line field of item sublist in the Transaction records (like Bill, Purchase Order etc.) using saved search.

But in a saved search I was unable to find any Column/scriptId which would give me value of LANDED COST CATEGORY line field. We ARE able to get this value using record.load().getValue() but I need this value from multiple transaction records and using this approach may cause performance issues. So, please can you tell how we can access this value using saved search.

Answer 1

I don't believe Netsuite exposes that field in saved searches at this time. This is the records browser in Netsuite listing all of the available search columns for Transaction searches. The internal id for that column is landedcostcategory, and that doesn't show up on the list.

However, if your goal is to get this information in SuiteScript, then you can use the 'N/query' module. Pull up one of your Purchase Orders, open the Javascript console (Ctrl+Shift+J) and try this:

require(['N/query'], (query) => {
  const suiteqlQuery = `SELECT 
                          transaction as transaction_id,
                          BUILTIN.DF(transaction) as transaction_name, 
                          BUILTIN.DF(item) as item_name,
                          item as item_id, 
                          landedcostcategory as landedcostcategory_id,
                          BUILTIN.DF(landedcostcategory) as landedcostcategory_name
                        FROM
                          transactionline
                        WHERE
                          transaction='<internal id of your PO here>'`;
  const results = query.runSuiteQL({query: suiteqlQuery}).asMappedResults();
  console.log(JSON.stringify(results, null, 2));           
  
  /*
    Example output for results:
    [
      {
        "transaction_id": "12345",
        "transaction_name": "Purchase Order #PO123456",
        "item_name": "My Favorite iPod",
        "item_id": 1234,
        "landedcostcategory_id": 1,
        "landedcostcategory_name": "Duties & Tariffs"
      }
    ]
  */
})