This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I am running the same search through a UserEvent script, and a Scheduled script, and one return value, and one doesn't.

```search.create({
  type: "transaction",
  filters: [
   ["type", "anyof", "CustDep"],
   "AND",
   ["internalid", "anyof", "3149"],
  ],
  columns: [
   "amountpaid",
  ],
})```
The result of the search in the scheduled have value for `amountpaid` but in the UserEvent, it doesn't.

on the UE event when did you call the search?

can you show us the complete code :slightly_smiling_face:

```/**
 * @NApiVersion 2.1
 * @NScriptType ScheduledScript
 */
define([
  "N/record",
  "N/search",
  "N/runtime",
  "N/task",
], function (record, search, runtime, task) {
  function execute(context) {
   let script = runtime.getCurrentScript();

   search.create({
    type: "transaction",
    filters: [
     ["type", "anyof", "CustDep"],
     "AND",
     ["internalid", "anyof", "3149"],
    ],
    columns: [
     "amountpaid",
    ],
   }).run().each(function (result) {
    if (script.getRemainingUsage() &lt; 100) {
     task
      .create({
       taskType: task.TaskType.SCHEDULED_SCRIPT,
       scriptId: runtime.getCurrentScript().id,
       deploymentId: runtime.getCurrentScript().deploymentId,
      })
      .submit();
     return false;
    }

    let amountpaid = result.getValue("amountpaid");
    log.debug("amountpaid", amountpaid);
    
    return true;
   });
  }

  return {
   execute: execute,
  };
});```
Scheduled

```/**
 * @NApiVersion 2.1
 * @NScriptType UserEventScript
 */
define(["N/search", "N/record"], function (
  search,
  record
) {
  function beforeSubmit(context) {
   try {
    search.create({
     type: "transaction",
     filters: [
      ["type", "anyof", "CustDep"],
      "AND",
      ["internalid", "anyof", "3149"],
     ],
     columns: [
      "amountpaid",
     ],
    }).run().each(function (result) {
     let amountpaid = result.getValue("amountpaid");
     log.debug("amountpaid", amountpaid);
     return false;
    });
   } catch (err) {
    log.debug("ERROR", err);
   }
  }

  return {beforeSubmit};
});```
UserEvent

image.png

Screenshot 2023-10-12 111013.png

can you try loging of the "result" on your UE

`{"recordType":"customerdeposit","id":"3149","values":{"amountpaid":".00"}}`

not sure if this will work can you try removeing the double quotation on *3149.*  or try to parseInt("3149") the value

will give it a try, will see also if using N/query instead would help

It worked with this.

```let resultSet = query.runSuiteQL({
  query:
   "SELECT foreignpaymentamountunused FROM transaction WHERE id = '" + context.newRecord.id + "' AND type = 'CustDep'",
});```
