3ric Red Ribbon

Thank you! That's really useful to know, however, it doesn't appear to relate the Department filter to the results -- the hope is to be able to pick different departments (or multiple departments) and have the results be relative to that. Setting the Department filter initially to "-Mine-" is just setting the initial…

I figured it out! Rather than looking at the "Created From" join, I had to look at the "Applied To Transaction" join. This transaction has the exact same "Created From : Quantity" and "Created From : Quantity Shipped/Received" fields. Then I can do something like the following to compare the two in a "Formula (Text)"…

I believe you'd do this with a Formula in your results. Something like Type: Formula (Text) Formula: CASE WHEN {taxcode} = '0%' THEN 'Zero' ELSE {taxcode} END Custom Label: Tax Code You would replace {taxcode} with whatever the actual variable name is of the field you're accessing

Thank you! That should be enough to get me started!

Can you include the base URL with the account number omitted? Like https://{account_number}.suitetalk.api.netsuite.com/services/rest/query/v1/suiteql but the REST version of this

The more cluttered version with two sub-queries is actually about 5x faster than the version where the two tables are just joined, so ignore my "better" alternative unless you like it for the purpose of readability. In most cases, even inefficient SuiteQL is fast enough, but in my case, I'm retrieving 160,000 records, so…

Would it be possible to have a client script check for the presence of Arabic Unicode characters before saving a record with that field? Here's a list to Unicode values for Arabic: https://en.wikipedia.org/wiki/Arabic_script_in_Unicode. I know containing Arabic characters doesn't make a string of text Arabic, but it makes…

@JRose85 This one: https://chrome.google.com/webstore/detail/netsuite-search-export/gglbgdfbkaelbjpjkiepdmfaihdokglp?hl=en-US. I am not affiliated with the developer nor do I know the risk in using this. This was recommended by one of our consultants for what it's worth

I've used the Saved Search Export plugin for Chrome to save saved searches and send them to people developing plugins for us. Here's an unnecessarily complicated search criteria: And after export, this is what it becomes: var itemSearchObj = search.create({ type: "item", filters: [ ["formulanumeric: CASE \tWHEN…

This is crazy helpful! During our implementation, we loaded about 135,000 extra items from our vendor catalogues just in case we might need them in the future, and now, a year and a half later, we're starting to realize that wasn't such a great idea. Thank you for this

So the indentation is lost when you save a post I guess -- here's that SQL in image form: [2021_11_15 edit] After benchmarking, the "wrong" way is actually much quicker. I also removed the image version or the "better" way due to a typo

Thank you! That is incredibly helpful! I got this working in two ways -- a really bad way (which works but causes an order of magnitude more queries), and the right way which took me way too much trial and error to figure out. Here's the bad way: SELECT Item.id, Item.itemid, Item.displayname, Item.cost, Item.upccode,…

If you can get that attribute as a variable or form you can use in a function, you can use ROUND({attribute}, 2) For instance, on an Item saved search or report, you can find and round the markup by way of ROUND(100 * (({baseprice}-{cost}) / {cost}), 2)

Hello! My name is Eric! I work at not-for-profit bookstore in Montana, USA. I was moved from Computer Repair Technician to IT Support about a year ago when we first began transitioning to NetSuite, and what I do now is mostly write programs to increase productivity. I'm doing my best to learn as much as I possibly can…