LOL it's just part of the query language to the underlying database Netsuite uses

But interestingly enough you need to use a hack to actually use it, hence the

/* comment */

in the middle of the formula

ah ok. i have much to learn in that area

is it possible to remove the internal ID column on saved searches and/or export/emails?

@mattb I think only if you switch of the preference to "Show Internal IDs"

that did the trick although the internal IDs are handy with some import/export work and other bits

wonder if any integrations break without it or is it entirely visual

You can always add the Internal ID's to specific search results if you need them

It's supposedly just a visual thing, but I did hear reports of things breaking with the new release if that preference was on (to do with Saved Search to Advanced PDF template feature)

ah fair enough. will monitor it

now to figure out how to stop column O being converted to scientific notation in the CSV file (it’s a long number)

or is this just excel displaying it as such? the actual cell contents is the complete proper number

Best way I find is to open Excel to a blank document, then import the CSV via "Data > From Text", making sure to select all columns as Text in Step 3 of the Wizard

ah yes, ok

Yes excel auto-formats based on the data of the column which causes the scientific notation

thanks @rustyshackles

one last one for today: i want to assign a certain invoice advanced template to certain customers. just not sure how to make the link between the particular advanced template and the customer record

i can see where you assign the advanced template to the invoice record for example, but can’t determine how to assign a customer to a particular invoice form (if possible).

I dont think that is possible outside the box, you will have to use scripting. Store the template for the customer in a custom field.

@mattb You should be able to do this with a Workflow. Create a custom entity field of type List/Record = Transaction Form, then create a Workflow that runs on the Invoice, with an Action to set set the field value per the Customer's custom field

pretty sure jcurve strips out all the workflow stuff… unless it’s just been disabled from menus but i can still technically access 😉

(any URLs handy?)

Wow I thought it was just actual scripting

The feature ‘SuiteFlow’ required to access this page is not enabled in this account.

has anyone ever had an issue with an online form through Facebook? It returns an error saying the compay name field has not been entered

Hi everyone, I have a user that is getting an error message whenever they try to access a Sales Order via the global search bar. The error message is “That search or mass update does not exist (internal id=XXXX)“. The internal ID is of a saved search that is unrelated to that Sales Order. We’ve cleared cache, etc., but it’s still throwing an error. What could possibly be calling the search simply by entering an SO# in the search bar? I’m asking here before engaging NetSuite support. 😃 Thanks

@danav Is there a custom field on the Sales Order which is sourced from the missing Saved Search?

@markderrick - Nothing sourced from the search. Thanks, though! I’m going to do some more digging.

@danav are they searching on the internal id of the sales order or the document number? Maybe have them try the search with the sa: prefix and the document #, that should always work