Team, I am trying to run a transaction search via SuiteTalk SOAP, but I am having issues retrieving columns with custom fields. Anyone can help?

Team, on a transaction search via SuiteTalk SOAP, I am getting columns from the main transaction header but I would like to add columns from the lines. Do you know how to define columns form the line?

Transform a Transfer Order to generate an Item Fulfillment Event Hello everyone, I am currently trying to create a Transfer Order in NS through integration call, but when I try to submit the information to trigger the "Item Fulfillment" I am facing below error:

"Error while accessing a resource. You have attempted an invalid sublist or line item operation. You are either trying to access a field on a non-existent line or you are trying to add or remove lines from a static sublist."

I am currently using SuiteTalk REST API.

{
  "item": {
    "items": [
      {
        "itemreceive": true,
        "orderLine": 1,
        "quantity": 1
      }
    ]
  },
  "externalid": "test123"
}

however, if I change the orderline to "2", it generates the Item Fulfillment correctly, I already looked up in the original item (line:1), but there's nothing related to that id. the way I figured out that, was using the UI and then making a call to retrieve the Item Fulfillment and see what was different. any suggestion? I am a bit lost on this as our Transfer order has multiple lines

Hello, how can I set a percentage value in a field through the soap api?

I keep getting 400 responses when I perform a get request filtered by email. I've tried multiple ways of encoding it but nothing seems to work. If I send the same request using the email prefix before the @ symbol it works but I cant figure out how to send the whole email through. Any suggestions? I'm sure it's something simple I'm missing. https://xxxxxx.suitetalk.api.netsuite.com/services/rest/record/v1/customer?limit=1&q=email%20START_WITH%20emailaddress%40gmail.com https://xxxxxx.suitetalk.api.netsuite.com/services/rest/record/v1/customer?limit=1&q=email%20START_WITH%20emailaddress@gmail.com

Hi dudes, I know netsuite has a well documented openapi record endpoints which can be generated from the metadata-catalog, but do they provide the same for services such as

query/v1/suitql

?

I am attempting to create an Advanced Intercompany Journal Entry via a

POST

to the

{{REST_SERVICES}}/record/v1/advIntercompanyJournalEntry

endpoint as shown in the docs here. After working through some errors around permissions I am now only getting a very non-descript

INVALID_CONTENT

error. I validated that I have all the required fields by creating a record in the UI and setting all of the same data in my request body below:

{
  "trandate": "2025-01-16",
  "subsidiary": {
    "id": "1"
  },
  "currency": {
    "id": "1"
  },
  "memo": "testmemo",
  "lines": [
    {
      "account": {
        "id": "552"
      },
      "entity": {
        "id": "322"
      },
      "debit": 10,
      "eliminate": true,
      "lineSubsidiary": {
        "id": "3"
      },
      "department": {
        "id": "1"
      }
    },
    {
      "account": {
        "id": "482"
      },
      "entity": {
        "id": "1440"
      },
      "credit": 1000,
      "eliminate": true,
      "lineSubsidiary": {
        "id": "3"
      },
      "department": {
        "id": "1"
      }
    },
    {
      "account": {
        "id": "111"
      },
      "entity": {
        "id": "1440"
      },
      "debit": 1000,
      "eliminate": true,
      "lineSubsidiary": {
        "id": "6"
      },
      "department": {
        "id": "1"
      }
    },
    {
      "account": {
        "id": "551"
      },
      "entity": {
        "id": "319"
      },
      "credit": 1000,
      "eliminate": true,
      "lineSubsidiary": {
        "id": "6"
      },
      "department": {
        "id": "1"
      }
    }
  ]
}

I am receiving this error:

{
  "type": "<https://www.rfc-editor.org/rfc/rfc9110.html#section-15.5.1>",
  "title": "Bad Request",
  "status": 400,
  "o:errorDetails": [
    {
      "detail": "Invalid content in the request body.",
      "o:errorCode": "INVALID_CONTENT"
    }
  ]
}

I don’t think there is any issue in my json formatting although I could be wrong. I also tested by removing the entire

lines

array and then I get the below error so I do not think is is a permissions issue:

{
  "type": "<https://www.rfc-editor.org/rfc/rfc9110.html#section-15.5.1>",
  "title": "Bad Request",
  "status": 400,
  "o:errorDetails": [
    {
      "detail": "Error while accessing a resource. You must enter at least one line item for this transaction.",
      "o:errorCode": "USER_ERROR"
    }
  ]
}

Does anyone know of a good way to get a more descriptive error message to figure out which fields I might be missing? I verified that this is all the data that is being returned by viewing my integration record’s Execution Logs as well

Have you tried pasting this question on #C06V7S5E77Z?

For anyone doing boomi integration, how do you import or update an object profile, i.e inventory item without clearing the mappings?

How do i get lot numbers via api for assembly items? if I hit the assemblyItem endpoint, it doesn't contain the lot number info

in q rest query is there a way to return the text from a select field in addition to the value

Just got this from chatgpt ... "When a record (like a Journal Entry) is created via SOAP web services, it is often locked for editing within the same script execution cycle. This means that attempting to modify the line items (sublist) in beforeSubmit will not work as expected, and NetSuite may throw an error." Is this legit? I have a script using beforeSubmit that works fine when creating or editing a record in the UI, but when creating record through SOAP, the script runs without updating the record - the script completes without error.

Last ditch effort here When attempting to update an itemreceipt via REST i keep getting the following response:

{
  "type": "<https://www.rfc-editor.org/rfc/rfc9110.html#section-15.5.1>",
  "title": "Bad Request",
  "status": 400,
  "o:errorDetails": [
    {
      "detail": "Error while accessing a resource. You have attempted an invalid sublist or line item operation. You are either trying to access a field on a non-existent line or you are trying to add or remove lines from a static sublist.",
      "o:errorPath": "item",
      "o:errorCode": "USER_ERROR"
    }
  ]
}

My Payload is:

{
  "item": {
    "items": [
      {
        "orderLine": 1,
        "location": 3
      },
      {
        "orderLine": 2,
        "location": 3
      }
    ]
  }
}

doing PATCH /itemReceipt/{receiptID}

AI seems to just throw up a response about fulfilment, not what we're doing here.

Hi all! Does anyone know if it’s possible to create a custom record with custom record child instances via REST api in one single request? This body creates only the parent custom record: { “custrecord_sta_bike_status”: 1, “custrecord_sta_enduser”: 1, “custrecord_sta_size”: “100", “customrecord_sta_child” : { /_/ have also tried the name of the sublist starting with recmachcustrecord…_ “items” : [ { “custrecord_sta_bl_is_header”: true } ] } }

How can I create an RMA from a Sales Order using the REST API? Can someone share the correct URL and payload for Postman?

How can I remove line item on Purchase Order Record using REST API?

with SOAP, Is it possible to get more details about a saved search other than the scriptId, internalId, and name?

Does anyone have any input on how to default the nearest location based on the Ship To address zip code ? We would also like to check inventory availability for the defaulting location

Anyone else having connection issues into netsuite?

Hi everyone, does anyone tried storing the time or date an Invoice was sent in Versapay? Storing it on a custom field in the Invoice record. There is a Send Reminder button in the Versapay Network Invoice page then I would like to get the time or date when a user hit that button to store on a custom field.

When pushing a transaction to NetSuite via SuiteTalk (SOAP 2024_2), should we expect the currency field to update if the transaction already exists in NetSuite? In the update case, currency doesn’t seem to change. Just checking if anyone knows what the expected behavior is.

Hi team, anyone have a example of removing a single select option from a multiple select field using SOAP? Can't seem to get it to work.

Hello All, anyone have the advanced intercompany rest web services working JSON format to try with Postman? Appreciate the help.

Using the REST API to get Datasets. Is there a way to define and get aliases in the field names? Renaming the columns in the UI gives you the custom name in the UI but in the API response the Dataset has the internal names of the fields. The first problem comes when joining tables, because getting the department full name, subsidiary full name, etc all gets dumped as

fullname

,

fullname_2

,

fullname_3

, etc. The second problem with this arises when adding new fields to the Dataset because the API response orders the fields alphabetically. So the previous

fullname_2

is now

fullname_3

, etc.

I'm unable to afford a Company Learning Pass to access Oracle-provided MyLearn materials to prepare for the NetSuite Web Services Certification, So I'm taking the approach of reading all the documentation (and building projects to implement and understand it) about SuiteTalk in the NetSuite Help files. Navigating the documentation in a depth-first manner (which will land you at "Philosophy" every time if you do it in Wikipedia), I arrived at an article at SuiteTalk Web Services / SuiteTalk SOAP Web Services Platform Overview / Soap Web Services Setup / SOAP Web Services Quick Start / Building and Application with Java using Apache Axis. It turns out that for me at least, this is anything BUT a "quick" start. At this URL: NetSuite Applications Suite I have installed the JDK, unzipped the "Ant" thing, and the "Axis" thing, and now I'm at Step 4. "Configure Java to generate unreferenced types." It gives a snippet:

<axis-wsdl2java timeout="360000" output="${generated.src.dir}" verbose="true" 
      url="${wsdl-1.3.url}" all="true" wrapArrays="true">

But I guess I'm supposed to already understand where that goes. I saw lots of build.xml files in the "samples" folder, but I don't think it was talking about any of those, so maybe it meant the ant-build.xml file? A WinGrep over the various things downloaded for this "quick"-start found ant-build.xml matching that "axis-wsdl2java" in one place. But I can't tell if I'm supposed to add that snippet somewhere (and where to add it) or change the existing one to have those attributes. Looks like I'm in way over my head. Can I properly learn this stuff without learning all about Java app development first? It seems it would only make me a better developer, but I wonder if I'm starting from the wrong end of the elephant.

Is it true that it is not possible to set the Tax Code field using REST unless SuiteTax is enabled? Can we store it in a custom field instead and have another script within NS to copy it over to the standard Tax Code field?

If all I have is a token (account, client, secret, token, secret), what’s the best way to find the email and role associated with it. I can’t seem to get the /rest/roles endpoint to work. Is there nothing OOTB, do I have to write my own restlet?

Has anyone been successful using REST WS to create a customer payment that applies invoices, credit memos and journal entries? Wondering if it's limited to only Invoices, like CSV imports are.

Implementing NetSuite comes with its own set of challenges. We're curious—what was the biggest hurdle for your team during implementation? Share your experience in! 👇 https://www.linkedin.com/feed/update/urn:li:activity:7356659759879503872