Item Search, Criteria: CASE WHEN (NVL({locationquantityavailable}, 0) <= 0 AND {inventorylocation} = 'test1' ) AND (NVL({locationquantityavailable}, 0) <= 0 AND {inventorylocation} = 'test2') THEN 1 ELSE 0 END if one of these locations is empty on the inventory table, this criteria will filter out the product. as if NVL is not working. Can NVL not be used in criteria like this?

can anyone tell me the difference between SuiteBilling and Recurring Billing?

We have Searches that trigger email when a transaction is updated. the thing is, four fields are updated by the system and they seem to relate to Spanish Tax (release Notes from 2018.2 refer to Spain SII reporting), but we don't use Spanish Tax, and I cannot see any guides on how to stop this. These are the fields:

Invoice With No Counterpart Article 6.1.d
Simplified Invoice Article 7.2 7.3
Billing Record Cannot Be Submitted On Time
Issued By Third Party

Any thoughts on how we prevent these fields being updated?

I'm looking to attach email to a Tranfser Order? anyone do this before, tried creating custom sublist, doesn't appear that I can tie that to a TO

Any idea why I can't switch a roles dashboard from the role settings? I'm on a sales admin role with permission to publish dashboards at full? Also, I can only get the dashboards to change for roles when creating a new one dashboard, I can never get them to change to an older one.

logged in as a user and getting the following error when trying to create a record: "There is no valid license for the current user." Any ideas why this is happening?

This message was deleted.

Is there a way to include Open Purchase Orders in Item Average Costing?

Hi all, has anyone successfully used a webservice API to connect Workday HRIS and NetSuite? Also, how are employees managed once they are marked Inactive in NS? I assume if they are inactive it will not accept a data feed similar to imports, is that correct?

Hi All,

This message was deleted.

Does anyone have a work around for being unable to use custom multi-select fields as an available filter on saved searches? NetSuite has it as an enhancement, but I'm sure it won't be available any time soon

Could the server disruptions today have caused a custom field created today to be delayed when showing up in a search?

I created a custom record called "Travel Request" and gave employee center full rights to the record. But they cant see it or create one. Any tips?

Hi all, is there any quicker way to export a Role from one account to another account (say production to Sandbox) - I tried "Copy to Account" feature but it gets stuck in step 2 where it says "Calculating dependencies. Do not refresh or close this page". -- I waited for a long time but nothing gets loaded.. is there a reason why this happens?

I'm creating a custom record type and I want the Name Field to be a unique value. I'm trying to avoid duplicate records from being created. Is there anyway to do this with Suitebuilder?

I'm trying to get a conditional date function to work within a saved search, the formula currently is Case WHEN {today} - {transhippeddate} <=14 Then 'Green' ELSE END This is returning 0 results but the {Today} - {transhippeddate} standalone returns numeric values. Any ideas?

Double-posting this from #accounting in case there are non-accountants with a perspective to share: Does anyone here use the Planning and Budgeting module (NSPB) to help with forecasting? If so- is it worth the money?

When created a Saved Search, when I put a transaction on the Results Tab (Paired Intercompany Transaction) it returns the internal ID of the Transaction. Does anybody know of a way to get it to display the ID ({number}) instead?

Any company here who uses Requisitions? Any reason why you went with that over Purchase Request?

Is anyone here using virtual cards in their company? Note: Unlike corporate cards, they are cards issued to employees so when they request a Purchase, a training course for example, a PO is issued and money is deposited to the Corporate Card. We're looking for a way on how to record these transactions in NetSuite wherein there are multiple vendors in one transaction. e.g. on Main Line Vendor -> Paypal on Transaction Lines -> different vendors such as Udemy, Linkedin Learning, etc.

we accidentally activated a sandbox refresh before we were ready. Is there anyway to stop that or revet it back?

Has anyone recently integrated Netsuite and Salesforce? If so, what did you use as middleware? I've used Celigo in the past, however, Salesforce is suggesting middleware called Mulesoft, which I assume they have a partnership with. Mulesoft appears to be a very easy to use connector but comes with a hefty price tag

Good afternoon, Every time we do a SANDBOX refresh, it breaks their ability to log in via Okta. We are trying to find out if there's a way to do the refresh that won't break SSO w/ Okta. • Is either of you're aware of how to do it? • Have you come across any Netsuite help or documentation that shows that? I will appreciate your help. Thank you

Hi, all. Does anybody have issues when returning items that were applied promotions on NetSuite? We used credit memo as a way to perform the refund with invoices. The invoices are created from fulfillment/sales order where SuitePromotion is applied. The returning process does not seem to be logic in our end. Ex: When we apply a BOGO promotion on the sales order, it does not pop up any further message if we are performing credit memo with returning ONLY one of the items.

Is there a way to subscribe to the NetSuite Status page? To get notified automatically when its down for a specific data center or account? Any alternate way of doing this? Thank you

In the following saved search formula(text) column, what does the

||

do? I've never seen this syntax before...

<span style="color:#a31c38">'||{status}||'</a>'

How to do case when condition using dates, for example, in a formula(numeric) field you want to get amounts of transactions before a specific date something like

{trandate} < '2020-10-02'

? This one didn't seem to work.

We have 27 invoices overdue (open invoices) but the ‘Invoices Overdue’ reminder shows 8…why woould this be different

If I click on the reminder, it takes me to open invoices, which shows 27