Does anyone have a better way to unlink customer deposits from sales order? My accounting team does not want to have to go into the sales order and change the form to cash sale.

is it possible to generate price lists via script (like using the render module)

Is the Sales Quota record available via N/Query? My script just say it’s an invalid record type.

Is there anywhere in the DB that links a transaction to an account? I looked through the transaction table but don't see anywhere an account is stored This is on netsuite2.com

I'm trying to group items utilizing a descriptive item in Netsuite, has anyone done any work like this in Shopify ?

Does anyone know why this code works in

beforeLoad

for a user event script, but doesn't work in a Suitelet? In the Suitelet

window

appears to be

undefined

.

form.addButton({
    id: 'custpage_cancel',
    label: 'Cancel',
    functionName: "window.open('" + revenueArrangementUrl + "','_self' );"
});

I’m trying to set up an approval system for purchase orders using a Suitelet. The idea is that an email is sent via a Workflow with an email template, and the template contains a link to the Suitelet that performs the “Approve” action. Example of the link sent in the email:

<https://9319243-sb1.extforms.netsuite.com/app/site/hosting/scriptlet.nl?script=1372&deploy=1&custscript_approvalmail_action=approve&custscript_approvalmail_recid=43283>

Even though the Suitelet is set as Available Without Login and the audience is Online Form User, clicking the link returns the error:

Invalid page parameter. Unable to view page.

Has anyone encountered this issue? What is the correct way to send parameters to a Suitelet via email so that non-logged-in users can perform actions?

Hi team, building a (hopefully) straightfoward Suitelet to allow us to accurately reconcile landed cost estimates vs actuals (FX involved and the bosses want a good indication of how close we are). Basic plan is to have a few header fields then a sublist populated from a saved search, and checkbox to select each transaction to be dealt with. Pretty confident with most of that, but I am hoping to have a header field that shows the 'balance' of the selected transactions (ie the variance). Is this best achieved via a fieldUpdated script for the sublist to add/subtract the value of the relevant line when the checkbox is ticked/unticked, or is there a better way to handle this?

This message was deleted.

using the https module and ping external service, how can i know if the other service redirected to a different page

let raw = https.get({
      url: url,
      headers: {
        "Content-Type": "application/json",
        Authorization: `Bearer ${response_token.access_token}`,
      },
    });
    log.debug("res", { raw, url });

Server logs used to be around for 30 days, did that change in the last year? Do they get truncated early if there's excessive logging going on?

Hello - have a SS 2.x map/reduce script that I've written. We have a custom transaction type in our instance for consolidated invoices, and each line is made up of underlying invoices. We have custom currency fields that we are leveraging, and so the goal is to keep the native total (header level) and native amount (line level) at $0, since this is a consolidated invoice, is non-posting, and want to avoid GL impact. When I attempt to set the value to $0 as shown below

ciRecord.setCurrentSublistValue({sublistId : 'line', fieldId : 'amount', value : 0.0});

I receive the following error message... Value 0.0 outside of valid min/max range for field amount For additional context, this is a rewrite of the original process and SS 1.0 that created these consolidated invoices via scheduled script, and was able to set the amount line item field to $0. Anyone have an idea of how I can get around this and set the value to $0. I'm able to edit the transaction after it has been created, through the UI and set the value to $0

Does anyone know if there's a way to access the intelligent recommendations via suitescript?

Hey y'all, we're trying to programmatically access attached files for a list of expenses; this expense list is generated by querying a saved search via suitescript. Is there any identifier we can return from a saved search to look up in the N/file Module if it has any file attachments? Also open to alternative ideas about how we can find attached files for an expense.

Does anyone have idea to connect NetSuite with Github for Code deployment by using Jenkins?

Just to be sure... the timeout of the http requests initiated from NetSuite using SuiteScript to other systems, is something that we can't control, right?

We have added a button on a sutelet which we want to trigger a post request to an external server with a payload

Does anyone know how to kill a schedule script ;( My schedule script is falls into an infinity loop, the loop is trying to print logs, so no governance will be consumption.... it's been 4 hours now ;( I've tried: 1. Inactive the schedule script 2. unchecked deployed checkbox 3. set Priority to Low 4. Try to delete the deployment but popup an error message:

An instance of this scheduled script deployment already exists in the work queue.

None of these works ;(

Hi everyone, I have a question: I'm currently trying to create a report with HTML rendering in Suitelet. The report is a budget report using a standard budget. I'm currently using SuiteQL to retrieve data from the "Budgetimport" table. However, there's a problem: the data in that table isn't grouped according to the custom segments applied to the Budget Import records. It only groups by default segments like Department and Location. How can I save and group the data according to the custom segments as well? Thank you.

I want my client script to automate the setting of inventory detail quantity on an item receipt. Thankfully all my items have a default bin and the global setting to use the default bins is on. However when changing the quantity I get a "Not supported on current subrecord: CurrentSubrecord.setCurrentSublistValue.". This happens in both create and edit client contexts Here is a sample code

require(['N/currentRecord'], function(currentRecord) {

const record = currentRecord.get();

record.selectLine({

sublistId: 'item',

line: 0

});

const quantityToSet = record.getCurrentSublistValue({

sublistId: 'item',

fieldId: 'quantity'

})

const inventoryDetailSubrecord = record.getCurrentSublistSubrecord({

sublistId: 'item',

fieldId: 'inventorydetail'

});

inventoryDetailSubrecord.selectLine({

sublistId: 'inventoryassignment',

line: 0

});

// this line throws the error "Not supported on current subrecord: CurrentSubrecord.setCurrentSublistValue."

inventoryDetailSubrecord.setCurrentSublistValue({

sublistId: 'inventoryassignment',

fieldId: 'quantity',

value: quantityToSet

});

// Commit the line

inventoryDetailSubrecord.commitLine({

sublistId: 'inventoryassignment'

});

});

I have a question. would you recommend validateline or saverecord for a client based script validation?

trying to use hte following.

search.lookupFields({
    type: record.Type.SALES_ORDER,
    id: createdFrom,
    columns: [ 'subtotal' ],
});

but getting an error

{"type":"error.SuiteScriptError","name":"SSS_INVALID_SRCH_COL","message":"An nlobjSearchColumn contains an invalid column, or is not in proper syntax: subtotal."}

Record Browser shows Sales Order having

subtotal

as a valid field, and loading the record via

record.load()

and then using

.getValue({fieldId: 'subtotal'})

does actually return the value. So what am I missing?

"message": "You have entered an Invalid Field Value false for the following field: isperson",

customerRecord.setValue({fieldId: 'isperson', value: false});

Should I be setting something other than a boolean?

Do you know if it is possible to create a suitelet to handle multiple invoice payments? The idea is to have a payment link on customer statements (open invoices) to allow customers to select which invoices they want to pay and then somehow leverage the payment processing profile (Cybersource) to handle the credit cards and get back a response to finally create the customer payments or display any error message. I know there are a lot more involved here, so I would like to know your experience on similar scenarios.

Our map reduce script fulfills our orders every day. Recently, we have had a strange bug, even though the order fulfills, we get an error message even though we have the available qty

error that we received:   message: "You can not over-fulfill an item unless you have selected the 'Allow Overage on Item Fulfillments' preference.",
let salerodernumber = data.id;
      try {
        fulfillmentRecord.save();
      } catch (error) {
        let message = error.message;

        let errodata = {
          message: error.message,
          info: shipid,
          address: address.shipaddress1,
          phone: address.phone,
        };
        log.debug({
          title: "create error",
          details: { salerodernumber, message, errodata },
        });

How do I make a bundle so that its script files are not editable, nor downloadable by any?

Heya folks, I know there are several buttons in Netsuite that can enter in multiple line items at a time into a transaction, client side. Is there any way to do this with client side Suitescript? Trying to avoid having to add lines individually since it either breaks sourcing if you do it really quickly, or it is really slow as you wait for sourcing to finish.

Hi Help required. I tried applying a User Event script on Request for Quote record but the option wasn't available on script deployment (Let like to know if I am doing anything wrong here). Would like to know what is the extent of customization options we can apply to NetSuite's standard "Request for Quote" record type. Thanks

Good morning. Anyone in here using Netsuite Fast track Tookit SS2 in their suite scripts? Looks like the github repository that was hosting it has been moved under gitter-badger and the npm repository package has been removed. Does anyone have a recommendation on another Netsuite ORM?

It's been too long since I worked with Restlets, and the documentation is not clear on a few things: • How external systems should get the domains of restlets on your NS account. The docs mention using the roles service, but the URLs provided in the documentation either go to a Page Not Found page, or an 400 error message {"error" : {"code" : "USER_ERROR", "message" : "You provided an invalid Authorization header."}} . Because of this, I'm thinking of just giving them the hardcoded restlet URL. • What permissions are required on Role and User of the Access Token being used by the external system in order to make the requests to the Restlet. They think we need Rest Web Services enabled, but I was making external requests to Netsuite Restlets a few years before Rest Web Services even existed, so that doesn't sound correct.