How can I get a list of fields for tables or views from NetSuite using a SuiteQL connection? I tried select * from oa_columns where table_name = 'account'; but that did not work. I'm using the CDATA O...

Any clue why the following works? with tbl as (select itemprice.item as stock from itemprice) select stock from tbl and with tbl as (select item.id as stock from item) selec...

I am facing a problem that NetSuite Serial/ Lot number can be duplicated Like the picture below, And I wanna prevent duplicated Lot Numbers from occurring by setting/ developing, Or one step back, on...

I’m trying to generate a CSV of a dataset via scripting. I’m using the task.create function and was able to generate a CSV File. the only problem is that I’m getting internalids instead of texts (exam...