I'm struggling to query transactions by location using suiteql, the location field is not available it seems... am I missing something?

You're out of luck, I just removed my config that I was using for a previous client.

I have a client script for the Sales Order line, when the item is changed, in a client script on valuechange I want the value of the customer on the screen, and then I want to update the price on the line, I mean the field on the screen. Easy ?

Does anyone know if you can invoke the create work order process linked on a sales order line, via script? You can check the create work order box on the line only when the order is created. Once created, it has the hyperlink.

Hi All, is there a way to customize FAM Manage Proposals Screen (Add dom manipulation logic by script) which is created by a locked standard suitelet script?

I have noticed a script type that is new to new in the list called “”Custom Record Action Script”. Can anyone tell what the script type is used for? I searched Suite Answers and found nothing about it.

Has anyone tried to convert a free-form text to Date format in the saved search? I tried to use

TO_DATE

function in the formula, but when I hardcode

TO_DATE('2022/03', 'YYYY/MM')

is worked, but if I pulled from record

TO_DATE({custrecord_yyyymm}, 'YYYY/MM')

it failed 😞 Not sure where I did wrong...

Hi Everyone, Im checking one value in a string but seems to be not working!! below is the code: The last two logs are not showing!! includes is not working, even i used toString() in afterSubmit():

var swm_shipping = newRecord.getValue({fieldId:'custbody_swm'});

              

              swm_shipping = String(swm_shipping);

              log.debug('swm_shipping',swm_shipping);

              var swm_ship = swm_shipping.includes("ups");

              var swm_ship1 = swm_shipping.includes("UPS");

              log.debug('swm_ship',swm_ship);
              log.debug('swm_ship1',swm_ship1);

Best methods for pulling raw record data out of NetSuite via SuiteScript? Hey all, We are attempting to pull raw record data out of NetSuite via a SuiteScript so that it can be handled by our downstream processes. The record objects provided to us in SuiteScripts have some odd structures which need to be manually cleaned up on our end (null numbers come back as empty strings, sublists are not structured as arrays, etc). We are trying to find solutions which allow us to grab this record data "pre-cleaned" so that we don't have to create a process which addresses all of these oddities, of which there are many. We found that NetSuite's REST Web Services API allows us to query for a given record and returns a JSON representation of the record with all of the above "cleaning" already done. We are attempting to use this API within our SuiteScript to grab the "cleaned" record and send it off to our downstream services. During our testing, we found that only a subset of NetSuite record types are fully supported; the rest are in beta. A few of the record types in beta are needed for us to progress on this sync process (Return Authorizations, Item Receipts). Question 1: We are wondering if, by enrolling in the beta program, we will have access to these record types via the REST Web Services API within our production environment.(?) If not, we will have to pivot back to cleaning the record data ourselves, barring another solution which we have not yet uncovered. Question 2: Are there any other methods of accomplishing our needs? #general #suitescript #suitetalkapi

Interesting issue i've discovered. We use Stitch data to sync Netsuite data to Redshift. I've come across a scenario where I have lines on a Sales Order that get updated to committed when Inventory lands in the warehouse, but the header level

lastModified

timestamp is not updated for the sales order transaction when the line commitment updates. Does this sound correct? Looks like Stitch uses the

lastModified

field to do delta syncs, and these updates then get missed.

Is there character limit for custom fields being pulled into SuiteScript? I have a field with the Long Text type that I’m trying to pull into my script and it seems to be getting truncated at 1300 characters. Anybody know why this would be or any way around it?

For a script that creates a UI page in NetSuite ERP, how can I restrict it to only allow certain roles to access that page? I don't know how to write scripts, but I downloaded this one from Tim Dietrich that allows users to run SQL queries in NetSuite. It seems to be available for all roles, but I believe the query can be used to add and update data in NetSuite in addition to being able to export data. I only want admins to be able to add or update data via the SQL tool.

Hello everyone, how to control the time of automatic bank statement. if I want the auto pulling to be on 9:00 am ex.

Is there a way to add a script on an item's inventory? Reason: Custom item status field is selected for "Ready for Deletion" (inactivates the item). Once inventory hits 0, we inactivate the item. So I need the ability to, as soon as an item inventory is marked as zero, change a field on an item. I could use a map/reduce, but I was curious if there was a way to do it this way first.

Is there any way to automatically export a CSV report to the file cabinet? I know you can schedule to be sent through email in different formats

how would one allow users to edit transactions only a handful of records on a line level and restrict access of everything else in that line? so if say i have 30 columns on the line level and want the user to edit 3 or 4, what is the simplest solution for this?

Is it possible to set a default value for a multi-select field before record load?

Can we merge saved searches in script with the intention of displaying the output in a Suitelet?

@mg2017 You can perform multiple searches, get the results in objects or array of objects and merge them to create the final object with all the data you need and then display it in a Suitelet sublist. (Tip: you can probably get all the data you need with a single dataset or workbook).

NetSuite support are complaining about me having lodash in the file cabinet

'third-party unauthorised custom module' is their term for lodash

Hello, did anyone encounter this type of error in Restlet

[com.netsuite.suitescript.scriptobject.ScriptNullObjectAdapter

] ?

Running a CSV import from script (N/task) I'm getting date format errors that don't seem to make sense to me. Anyone seen something like this before? when doing

csvTask.submit()

getting back

FAILED_TO_SUBMIT_JOB_REQUEST_1

and date formatting message something like

Failed to submit job request: Date field not in your preferred date format for field "Date" : 57 You have entered an Invalid Field Value 09/21/2022 for the following field: trandate : 4 You have entered an Invalid Field Value 09/22/2022 for the following field: trandate : 53.

I can access quantity, item & expirtaion date but not the bin/lot number. Anyone see why? Tried both getText and getValue.

obj_result['binnumber'] = result.getText({
    name: 'binnumber',
    join: 'inventoryDetail'
});
obj_result['issueinventorynumber'] = result.getText({
    name: 'issueinventorynumber',
    join: 'inventoryDetail'
});
obj_result['tobinnumber'] = result.getText({
    name: 'tobinnumber',
    join: 'inventoryDetail'
});

I have a User Event Script that is unwilling to run after a CSV Import. Any Ideas why the CSV import would not cause the script to run?

Anyone knows why xml.Parse.fromString() won't properly parse the xml when the first tag is a <Document xmlns="urn:iso...etc..." xsi:schemaLocation="urn:iso...etc">? If I remove the attributes xmlns, xmlns:xsi xsi:schemaLocation from the Document-tag it gets properly parsed.

I'm having a problem, I'm trying to call a scheduled script from a client script. It looks that it's not working. Am I right /

Any tips for getting started with a Financial Institution Plugin. I started with the example in the documentation about it and removed most of it just to point getConfigurationIFrameUrl() to a suitlet. But it fails with UNEXPECTED_ERROR before even running that entry point. I'm trying to select my connectivity method in a format profile and expect it to show a suitelet in an iframe.

/**
 * @NApiVersion 2.1
 * @NScriptType fiConnectivityPlugin
 * @NModuleScope SameAccount
 */
define([],function(){
    
        function getConfigurationIFrameUrl(context) {
            log.debug('start getConfigurationIFrameUrl')
            context.configurationIFrameUrl = "/app/site/hosting/scriptlet.nl?script=2090&deploy=14817&configurationId=abc"// + configurationId;
        }

        function getAccounts(context) {
            log.debug('start getAccounts')
        }

        function getTransactionData(context) {
            log.debug('start getTransactionData')
        }

        return {
            getConfigurationIFrameUrl: getConfigurationIFrameUrl,
            getAccounts: getAccounts,
            getTransactionData: getTransactionData
        }
    });

a client script runs a search of a custom record and returns the values. the custom record is set to "no permission required" (aka public) so this has always worked even for users in employee center role triggering the script. however as of today (after our 2022.2 release upgrade), there is now an "insufficient permission" error being returned when the script attempts to run the search for a user in an employee center role. has anyone run into this/know if it can be resolved any way other than creating a suitelet running as admin to perform the search? the whole point of using a public custom record was to avoid the suitelet route so i'd like to avoid it still if possible.

Hi all, are there any articles or best practice for cleaning old customization?