Hello everyone, How to read data using Suitelet from an Excel file present in File cabinate and manipulate data by applying some filters using Suitelet script??

If I wanted to have a custom button print an advanced pdf what module and method should I look into?

Why would

context.newRecord.getValue({ fieldId: 'customform' })

return

undefined

in the

beforeLoad

on a view event of a Sales Order? I was seeing the same thing in a workflow where the action to add a button based on the form would log

customform

was not a valid field.

Hello! I have a script using API 2.0. which is triggered by a workflow. This script works fine when the workflow is triggered by the UI but I'd like this to be a scheduled workflow. However I cannot seem to get the script to trigger, no matter the action type. Does anyone have any ideas?

In SS2, is there a way to add an inactive item to a sales order?

Hi Everyone. I'm stumped and hoping someone can point me in the right direction. I have a userEvent script running on afterSubmit on Work Order transactions. I am trying to change the Bill of Materials field ('billofmaterials') if the customer has a specific configuration. I am successfully setting this field and the Revision and Routing is cascading down correctly. However, the line items are not changing like they do in the UI. Here is my setValue call: wo.setValue({fieldId: 'billofmaterials', value: customerProductBOM, ignoreFieldChange: false, forceSyncSourcing: true}) I am loading the Work Order in Dynamic mode and then saving the record. Any thoughts that might help here?

I'm copying a Charge Rule and trying to change the Date filter on it. Does anyone know how to do that? The Date filter that's currently on there uses "within". Getting the value returns something like "9/1/2022\u00059/30/2022", so I figured I could set it with a value like "10/1/2022\u000510/31/2022", but the new Charge Rules saves with the old value still. I also tried setting it with an array like this

['10/1/2022', '10/31/2022']

Hello Netsuite Pros! Question for the community here: Do you have a favorite tool you love for automated test cases for your suitescripts/workflows in Netsuite?

Is it possible to have a variable with global scope in a Custom Form Script in SS2, and have that variable be possible to be changed and referenced? I have some behaviour in my form that should call functions that are defined in my Custom Form Script, but it seems I need to call them via a

require

and as such, the script is loaded afresh and the value of the global variable is reset.

hello, I am trying to use https promise in my UE script but I am getting error - ReferenceError: "Promise" is not defined. If no promise it's working. Anything I might possiblly missed?

I am creating a Item Fulfillment using salesOrder.Transform My Goal is to create an IF for each location selected amongst the items. I am testing with a SO that has 2 items in 2 locations. I get One IF, with just the first item. But I am getting the error: You must enter at least one line item for this transaction. for both locations when I try to create a fulfillment. Any advice?

for (il = 0; il < items_by_location.length; il++) {
                    var item_loc = ''
                    item_loc = items_by_location[il]

                    if (item_loc.location == loc) {
                        loc_items.push(item_loc)
                    }
                }

                log.debug('total location items: ' + loc_items.length)
                if (loc_items.length == 0) { continue }

                log.debug('loc_items: ', loc_items)
                // var fulfillment = ''
                //transform SO to create a new Item fulfillment
                // try {
                var fulfillment = record.transform({
                    fromType: record.Type.SALES_ORDER,
                    fromId: sales_order.id,
                    toType: record.Type.ITEM_FULFILLMENT,
                    isDynamic: true
                });
                log.debug('got past transform')
                // } catch (err) {
                //     var subj = 'Failed to transform ' + transaction_id + ' to IF'
                //     var msg = err.message
                //     sendEmail_forceSenderReceiver(subj, msg)
                // }
                log.debug('fulfillment', fulfillment)


                //get line count of newly created fulfillment
                var lineCount = fulfillment.getLineCount('item');
                log.debug('fulfillment line count', lineCount)

                for (li = 0; li < loc_items.length; li++) {

                    var loc_item = loc_items[li]
                    log.debug('loc_item', loc_item)
                    if (loc_item.committedQty < loc_item.qty) {
                        log.debug(loc.item_name + ' is on BackOrder. Not Creating fulfillment for these items')
                        email_message += '</ br> Sales Order: ' + sales_order.id + ', Location: ' + loc + ' not creating an IF right now because ' + loc_item.item_name + ' is on backorder.'
                        break
                    }


                    //for each line set the "itemreceive" field to true
                    for (var i = 0; i < lineCount; i++) {
                        log.debug('i in lineCount: ', i)

                        var prod_id = fulfillment.getSublistValue({
                            sublistId: 'item',
                            fieldId: 'item',
                            line: i
                        })
                        log.debug('Item Name: ', prod_id)

                        fulfillment.selectLine({
                            sublistId: 'item',
                            line: i
                        });

                        // let items_location = loc_items.map(a => a.item_id);
                        var items_location = []
                        for (ll = 0; ll < loc_items.length; ll++) {
                            log.debug(ll + ': itemID: ' + loc_items[ll].item_id)
                            items_location.push(loc_items[ll].item_id)
                        }


                        if (!items_location.includes(prod_id)) {
                            continue;
                        }

                        log.debug('setting items to add')

                        fulfillment.setCurrentSublistValue({
                            sublistId: 'item',
                            fieldId: 'itemreceive',
                            value: true
                        });

                        fulfillment.commitLine({
                            sublistId: 'item'
                        });

                        log.debug('commited')
                    } //looping through line items in the SO

                } //loop of location items

                var ful_id = fulfillment.save({ ignoreMandatoryFields: true })

Hi, I am trying to make a simple solution to receive all requests from our customer's system in a queue, rather than giving them several endpoints. We will create the RESTlets as usual, but we won't give them the link, instead we will create a custom record, like:

id
action
json_body
status
error

and one RESTlet to receive everything, that will just save the requests to that record. Then, with a scheduled script, we loop over them, and call the RESTlets with the JSON bodies. What do you think?

Hello. (picture from sandbox, i did not implement this, but trying to copy it.) I created a custom record "WPS ITEM (routing)" Which i want to add to a subtab inside another custom record, so that you can create new WPS ITEM (routing) and fullfill the lines on the WPS (manufacturing routing) I have tried to do it inside customization --> sub-tabs But that does not seem right. Does anybody know how to do this

In Invoice not able to set billable time sublist values through script what may be the reason

good morning! does anyone knows how I can get the valid list of shipping carriers for a sales order? I mean via suitescript. I am creating a sales order via suitescript and I need to set a valid carrier. Thanks in advance

im trying to trigger a UE script, on EDIT button click. I tried this but it doesnt seem to work. Its still triggering on record load (view). how do i fix this?

Asked in SuiteFlow but figure this may get more of a response... "If I add a custpage_field via a User Event script beforeLoad is it accessible in a workflow?"

Is it possible to create a Sales Team record via script?

Hey all, I am currently working on creating a dashboard suitelet to visualize data using the chartjs library, currently the chart that I am creating is not rendering and I am not too sure why.

{                id: 'scripttopop',

label: 'Script to populate canvas',

type: serverWidget.FieldType.INLINEHTML,

breakType: serverWidget.FieldBreakType.STARTROW,

layoutType: serverWidget.FieldLayoutType.OUTSIDEBELOW,

`defaultValue: `<canvas id="mychart" width="100px" height="50px></canvas><script type="text/javascript" src="url in the file cab for the chartjs lib">const myChart = new Chart(document.getElementById('mychart'),${config});</script>``

}

If someone could either help me figure out why this isn't rendering, or point me in the direction of a different lib that would be great!

Anyway to get the XML of a Workflow via a URL? I can add "&xml=T" to the end of most URLs to see the XML but that doesn't appear to work with Workflows

Hi, On fieldchanged of a checkbox, if true i am adding items on line level but I am not able to set bin number fully. I am able to set the item when fieldchanged of checkbox is true but its bin number is setting and quickly getting unset. By that I mean, I am setting item and its related bin number through client script but bin number is unsetting on inventory count record by itself. I am able to set the same item and bin number through UI but CL it is not setting.

Does anyone know of a JWT library (need to decode and verify) that works with netsuite?

I am having an issue with a join in a search. I have created a search in the UI that does what I need it to do but when I convert this over to my script I start getting null results for the join fields.

var createSaveSearch = search.create({
                    type: "customer",
                    filters:
                        [
                            ["isinactive","is","F"],
                            "AND",
                            ["internalid","anyof","11980"]
                        ],
                    columns:
                        [
                            search.createColumn({name: "internalid", label: "Internal ID"}),
                            search.createColumn({name: "entityid", join: "contact", label: "Name"})
                        ]
                })

It's not bringing back the contact names.

does anyone know how to create an N/query wiht custom lists? if i use the custom list internal id as type i get an invalid type error and if i use query.Type.CUSTOM_LIST i cannot realize how to identify the list

Anybody have any experience setting vendor pricing on the item when multi-currency is enabled? This is how I was setting before multi-currency, but it's no longer working. I looked through the schema, but can't find anything related to item vendor price currency.

const preferred_vendor_line = itemRecord.findSublistLineWithValue({
                sublistId: 'itemvendor',
                fieldId: 'preferredvendor',
                value: true
            });

            itemRecord.setSublistValue({
                sublistId: 'itemvendor',
                fieldId: 'purchaseprice',
                line: preferred_vendor_line,
                value: parseFloat(price || '0').toFixed(2)
            });

            itemRecord.save({
                ignoreMandatoryFields: true
            });

I'm looking to understand the differences between these three context.UserEventType types: 1. EDIT (for full record edits? Does this event trigger WHILE the record is being edited, or after?) 2. XEDIT (for inline edits, field specific changes flagged only?), and 3. SUBMIT (is this the right user event type to subscribe to, so I can run an afterSubmit() event???) noting there is no documentation in NS** for this event, but I can actually select it in the dropdown in NetSuite itself... I'm getting a bit confused about these three and which is just a..."this record has now been updated, here's the oldrecord fields, and the newrecord fields, so now you can do whatever it is you need to do".. type of event Basically I just want to hook up to an event that essentially flags when a record has been updated, it's easy enough to intuitively say, if you want to subscribe to when a record is created, just use the ".CREATE" event... but I can't see many places that clearly help me choose which user event type I should really be hooking up to for an update. Some sources I have already looked at: https://riptutorial.com/netsuite/topic/7200/user-event--before-and-after-submit-events https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_4407992596.html ** https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_4387799721.html (all examples here are for .CREATE)

How can I call a restlet from a userevent script? Userevent script will trigger when a record is created through another restlet. https.request and http.post both are giving "The url must be a fully qualified url". Using restlet internal url. Even tried using the url which we got from using resolveurl (scriptid, deployment I'd). All of them giving the same error.

Are there any ways scripting or otherwise to mass delete multiple custom body fields?

I am trying to write a scheduled script to run each night. It will take any Transfer Orders that are NOT received in NetSuite but ARE received in Amazon and receive each line item. My code is as follows:

/**
 * @NApiVersion 2.x
 * @NScriptType ScheduledScript
 */
 define(['N/search','N/record'], function (s,r) {
	function execute(context) {
      var approvalSearch = s.load({
        id: 'customsearch_to_tbreceived'
      });
      var resultSet = approvalSearch.run();
      resultSet.each(processTransferOrder);
	};

	function processTransferOrder(result){
		var internalID = result.getValue(result.columns[0]);
      	log.debug({title:'InternalID',details:internalID});
      	var record = r.load({
			type:'transferorder',
			id:internalID
		});

      	var irRecord = r.transform({
          fromType: 'transferorder',
          fromId: internalID,
          toType: 'itemreceipt'
        });

      	var itemCount = irRecord.getLineCount('item');

      	for (var i = 0; i < itemCount; i++){
          var itemId = irRecord.getSublistValue('item','item',i);
          var quantity = irRecord.getSublistValue('item','quantity',i);
          var lineId = irRecord.getSublistValue('item','line',i);
          var location = irRecord.getSublistValue('item','location',i);
          log.debug({
            title:'Item - Quantity - LineId - Location',
            details:itemId + ' - ' + quantity + ' - ' + lineId + ' - ' + location
          });
          irRecord.setSublistValue({
            sublistId: 'item',
            fieldId: 'itemreceive',
            line: lineId,
            value:true
          });
        }

      	var idl = irRecord.save({
          enableSourcing: true
        });
        return true;
	};
	return({
		execute:execute
	});
 });

When it runs, it gives the following error:

{
  "type": "error.SuiteScriptError",
  "name": "UNEXPECTED_ERROR",
  "message": null,
  "stack": [
    "anonymous(N/serverRecordService)",
    "processTransferOrder(/SuiteScripts/bb_auto_receive_to.js:39)",
    "each(N/searchObject)",
    "execute(/SuiteScripts/bb_auto_receive_to.js:11)"
  ],
  "cause": {
    "type": "internal error",
    "code": "UNEXPECTED_ERROR",
    "details": null,
    "userEvent": null,
    "stackTrace": [
      "anonymous(N/serverRecordService)",
      "processTransferOrder(/SuiteScripts/bb_auto_receive_to.js:39)",
      "each(N/searchObject)",
      "execute(/SuiteScripts/bb_auto_receive_to.js:11)"
    ],
    "notifyOff": false
  },
  "id": "853f25fd-e6ab-452a-9ffb-13ced90c4b5c-2d323032322e30362e3238",
  "notifyOff": false,
  "userFacing": false
}

It gives this error on line 39 on the 2nd iteration through the items. Anyone see what I am doing wrong?

we are looking into using usps flat rate shipping , how can we choose this via script USPSPACKAGETYPE

packagingusps