I'm trying to filter by item fulfillments that have a blank or empty custom record ref field in the UI. In SuiteScript I've used anyof

@NONE@

, but not sure how to set that in a filter in the search UI

If I create a standalone Credit Memo that is not linked to an Invoice or RMA because it is associated with multiple invoices or the invoices are not traceable and we do not want to go through the longer RMA process, is it true that if there is no location average cost then the cost of the returned items is 0? There is no Override Rate field on the Credit Memo as opposed to Item Receipt where we can literally enter any amount.

Hi, are we able to add CAPTCH or filter for Online Customer Forms to avoid Spam Leads created in Netsuite? Is this something possible?

Regarding Reconciliation rules, is there any way to re-run the reconciliation rules on previous imports. I.e Imports other than the latest import?

In the contract renewal preferences the renewal form based from has no options. Any idea why? Based on suite answers I should be able to select subsidiary or channel tier (suite answer 9099)

Hello, has anyone here dealt with getting the CTA or Retained Earning Balances through a saved search? Thank you.

Hello, is it possible anywhere in NS to create a table where you can apply conditional formatting (highlighting) to a cell, rather than the whole row? (a bit like an Excel spreadsheet)

How do you guys structure work orders with common sub assemblies?

I have assembly A and assembly B that both use a certain quantity of Assembly C.

If I set the source as "work order" on the bom it creates two separate work orders for Assembly C.

Hey guys, does anyone know how to reference a NS field in the standard HTML form? I have a field on my SO that links to our external website so we can see the sales order on the external site, but I don't know how to reference it on the a href in the HTML code...

Does anyone know if there are overall account limits for the “attach file” section on records, or in general the custom field types of ‘Image’ or ‘Document’ or other attachment type fields? I know there are limits on the individual file size, but I mean overall account storage up uploaded files. Our plan is to upload a scans of each of our vendor invoices on the vendor invoice iteself, and also photos of completed work we take on the jobsite. Are we likely to hit a data limit at some point?

Hey guys, does anyone know how to reference a NS field in the standard HTML form? I have a field on my SO that links to our external website so we can see the sales order on the external site, but I don't know how to reference it on the a href in the HTML code... I know the field name, I just don't know how to reference it in the a href, this is what I have so far... <a href="{custbodypg_link_so}">Securely View, Edit, & Track the status of this order </a> (in the curly brackets is my field name)

Hey NS friends, anyone know how to add RMA approvals to a role? My current role does not allow to approve, but does have RMA permission

Has anyone gotten the error message in Smartview...."The number of POV to be Set exceeds grid POV"

When I start a new Sales Order, the main "Location" field is pre-populated. I can't find any workflow or script that sets this automatically... is there a setting or preference that would play a role in setting this?

Hello, Is any of you using Mavenlink for PSA and integration with Netsuite? Are you willing to share your experience with me? I will appreciate any information you can share. Thank you,

likely you only have one form; create more and you should get your subs and channels

Anyone have any recommendations for an Odata endpoint addon? Want to use a salesforce connect product to bring in netsuite invoices to display in SF.

does anyone know what the limit for columns are in a saved search, both for the UI and also to export in integrator.io?

Hello, can someone here direct me as how to edit a Standard Action or at least identify the save search associated. I have a "View all Transactions' button on our customer cards, but I would like to include another field in the saved search it brings up, however I do not know what search it uses or how to find it as the action doesnt indicate so when editing the form

Is anyone getting

Items you have requested in the record have been deleted since you retrieved the form

errors on Purchase Order and Vendor Payment creation since the 2021.2 upgrade? I don’t think we’ve changed anything, Netsuite is investigating as a potential defect on their end.

Quick question, when AP is closed, can inventory adjustments still be posted into the period? or because they would go into COGs Ns wouldn't allow it?

I want to send mass emails with invoice pdf and ability to attached other files stored in the files subtab as schedule jobs. I can today send the email with the invoice as a pdf attachment but unfamilar how to attach other files (specifically uploaded to the transaction in the files subtab).. anyone has experience with this?

any advice^

any thoughts? I'm trying to upload this sample .js file from this SuiteAnswers article. Creating a Financial Institution Parser Plug-in Script File

How might I go about creating a CONCAT function with more than 2 characters?

Can NetSuite do FIFO on warehouse without using Lot Items?

I have two landed cost categories (Ocean Freight and Duties). I need to create a report that shows the item, its overall average cost, its total quantity on hand, its total value, the average duty based on the related landed cost template and the average freight based on the related landed cost template. I tried to do this via item and landed cost template saved searches but they are not BOTH accessible in a single saved search. So, I tried SuiteAnalytics. If I have 2 landed cost templates for an item and both have 2 cost categories, this results to 4 lines. When I average the duty, it is divided by 4 lines instead of 2 landed cost Templates. Same goes for freight. I'm fairly new to SuiteAnalytics, so excuse my ignorance here.