Questions tagged [netsuite]

NetSuite is a vendor of business management SaaS. The platform's scope includes ERP, CRM, PSA, and Ecommerce. Primarily tailored to mid-market companies.

Netsuite is a software platform founded in 1998 that provides a number of business related services targeting mid-market companies, as well as divisions of larger enterprises. As a platform it is highly customizable through a Javascript-based API called SuiteScript.

4709 questions
1
vote
1 answer

Creating a linked server connection to NetSuite

I'm trying to access NetSuite's data from SQL Server as the NetSuite reporting by itself isn't enough. For doing so, I installed the NetSuite ODBC adapter on the server and tried creating a linked server connection from SQL Server in order to be…
Patthebug
  • 4,647
  • 11
  • 50
  • 91
1
vote
1 answer

How to get the item color and size in netsuite

Can someone help me to get the item color and size of specific item. I got the id of item called "custcol_coloroption" with value of 8. how can i translate that to value Ex. Black,White and etc. Thank you
user3627301
  • 21
  • 3
  • 10
1
vote
1 answer

does netsuite support preventDefault()?

Im using Bootstrap to create a tab content. It works fine outside netsuite. but once i put this page into netsuite it gives me an error saying "Cannot assign to read only property 'preventDefault' of error" My page is like this HTML:
1
vote
1 answer

Netsuite Subscriptions Restlet

I have a restlet script that updates the customer. In the customer I want to loop through the subscription objects passed in but I only have the subscription names to match them on. Does Anyone know how to access the subscriptions object in…
1
vote
0 answers

Get list of all roles in Netsuite using java ( using either direct approach or saved searches)

I want to get list of all roles in netsuite. I am using wsdl2java to generate client port and service from netsuite wsdl. I can assign Access Role to Employee in Netsuite using UI. I can view the existing Role to the employee on UI. I can search…
1
vote
1 answer

Get the internal Id for a Role in Netsuite

I am using wsdl2java to generate client port and service from netsuite wsdl. I can assign Access Role to Employee in Netsuite using UI. I can view the existing Role to the employee on UI. I want to do the same using the generated code through API. I…
1
vote
1 answer

NetSuite. How to select all attached files for current user (filter by InternalId)

I am using C# implementation of netsuite api from web reference com.netsuite.webservices I released filter fileSearch.basic by name (you can see it commented) it is working fine. Please help to write function to achieve all attached files for…
1
vote
1 answer

NetSuite: Create WorkOrder and Sublist with SuiteScript

NetSuite newbie here. I have a SuiteScript that loads the results of a sales order query and then creates a work order for each of those results. Is it possible to also create sublist items in the same stroke or will I have to load each new…
dah97765
  • 679
  • 1
  • 13
  • 29
1
vote
2 answers

Accessing FTP through netsuite

I want to schedule a script on NetSuite to upload and download a txt file from an FTP location. I am able to create a file and store it in a file cabinet but that is as far as I can go. I am a bit new and don't know if at all is it possible to have…
Nitin Chhajer
  • 2,299
  • 1
  • 24
  • 35
1
vote
2 answers

SQL Formula - value of field is twice the old value of field

I am trying to find a formula for a search that pulls any items twice the value it was before. I don't know any SQL formulas and am looking for any guidance. {systemnotes.newvalue} is twice the value in {systemnotes.oldvalue}
Alexis Rua
  • 11
  • 1
1
vote
1 answer

How to look up tax schedules using SuiteTalk?

I have the internal id of a tax schedule and I want to look up the name using SuiteTalk. In NetSuite tax schedules are found at Set up > Accounting > Taxes > Tax Schedules. The records browser and schema browser don't seem to mention tax schedule,…
cja
  • 9,512
  • 21
  • 75
  • 129
1
vote
1 answer

How can I associate NetSuite TRANSACTION_LINES with REVENUE_RECOGNITION_SCHEDULES via ODBC?

How can I associate NetSuite TRANSACTION_LINES with REVENUE_RECOGNITION_SCHEDULES via ODBC? I have researched the Connect Schema. While it says that it should be possible to join REVENUE_RECOGNITION_SCHEDULES.JOURNAL_ID TO…
Tarzan
  • 4,270
  • 8
  • 50
  • 70
1
vote
1 answer

How to get attached file from NetSuite record

Have some troubles with automatic uploading files from NetSuite. For example: I need uploaded files from SuiteScript (RESTlet), attached to one of employee (Communication -> File subtab). For attaching files, we can use nlapiAttachRecord(), but I…
1
vote
3 answers

How can i upload/use my client script in suitescript NetSuite

Can somebody explain to my how can i use or upload my client script in suitescript creating a form in netsuite? Appreciate the help. Thank you.
user3627301
  • 21
  • 3
  • 10
1
vote
1 answer

How do you compare a record value with an integer in NetSuite advance PDF/XML

I'm using the NetSuite advanced HTML editor to make a custom statement. I am trying to check if the statement has an outstanding balance or if it has been paid. Here's what I'm writing: <#if record.amountremaining > 0 >${record.duedate}<#if…
taylah
  • 11
  • 2
1 2 3
99
100