There is no such standard field. Creating a custom field is your best bet.

For the moment at least, yes. I don't think any Report has a column for internal id. In a saved search though, Internal ID is readily available.

Yup, scripting.

Send a case to NS. I mentioned to the guy in charge of the app (sorry, I forget who) that I had seen some oddities, and he said they weren't aware of any problems, but if you saw anything to send a case.

x = nlapiLoadRecord("customer", customer); Load record returns you a complex Record object. Outputting X will simply tell you it's an object. var y = x.setFieldValue("last_sales_date", date); nlapiLogExecution("debug",y); setFieldValue does not return anything, thus y is undefined. That aside, this script isn't working…

I'm not sure I follow - what "Questions" are you referring to? Maybe I'm drawing a blank, I just can't think of where in NS you might be referring to, aside from the login questions, but I don't think that's what you mean.

Oh, do you mean Cases?

Hmmm... I was double-checking Role configs, and there is maybe the "Is Support Role" checkbox. The help says: "If you have set restrictions in the Employee Restrictions field, check this box if employees using this role should be restricted based on the Assigned To field on cases." I can't recall ever having tried doing…

you can automate csv imports? Yes, since 2012.2

That would require customization. A live synch will be challenging. What is more common to see is a daily CSV import.

Oliver, i appreciate the input. I would ideally like to automate the process as opposed to importing the csv file every day. There may end up being several locations that i want to sync inventory qty's from so it could get kind of tedious having to do 5 "csv imports" per day for example. I think you'll need to do a…

Yes; scripting. It's your only option. There are no settings that control this and Workflows cannot affect line items.

The advantage is they are less technical and thus easier for non-technical people to learn them. They also actually work better than scripting when doing Approval workflows. In every other regard, they are by far inferior to scripting.

Well... I mean, if you have a badly optimized script, if you redid it as a workflow, it might execute better. But, if you simply re-designed your script as a script, it would be even better than a workflow, if you see what I mean. A good worklfow is better than a bad script, I guess is what I'm saying. But a good script…

Hi all. I've been trying to set the createdfrom field on a PO using code like below: var po = nlapiCreateRecord('purchaseorder'); po.setFieldValue('createdfrom', so.getId()); // ... set other fields on PO nlapiSubmitRecord(po, true, true); However, it does not appear to work. When the PO is generated, the Created From…

It is not. You could tie them together using custom fields, but then you'd be missing several unique features of Special Order/Drop Ships (such as the stock being forcefully assigned to this SO and things like that). Drop Ship/Special Order behaviour cannot be perfectly recreated and cannot be modified from what it is.

List->Financial History

No, you can't do that. But it's not very hars to code - nlapiTransformRecord() in a big loop, a little overhead to control the batch processing and you're done.

Hi, Saved searches can be programatically DELETED but not inactivated. However, there is no way to programatically determine when the search was last executed.

That's not quite what he's asking. He'd want to query Netsuite's sales rep assignement by territory engine to know which Sales Rep NS would have assigned given a certain order. I don't know of any way to do this without submitting the record for the logic to kick in. So, let's say you are creating a Lead and want to know…

I only know a little about those things, but if I'm not mistaken, the multiselect fields give popup behavior when the list becomes too large to fit in the dropdown. That is correct. You can control just exactly how many values it takes the dropdown to turn into a little popup window under Home->Set Preferences->Maximum…

Hmm... Try setting the quantity received to 0 as well? But wait, you say it errors literally on the set field value, or it errors further down when you submit?

Well, one thing you could do is build a Saved Search that outputs all that info. The user can then output to Excel using native funcitonality of the Saved Search.

Yup, you can use scripting, Workflows, or an Email Alert. Since Email Alerts requires the least amount of technical know-how, you can try with those first. You'll need to create a Saved Search such as: TYPE: Transaction CRITERIA: Main Line = True Type: Sales Order SUMMARY CRITERIA: Count of "Internal Id" greater than 1…

Very true. Except only an Admin can set a script to Run As Admin, so you can have your developpers run at lower permissions so that they can only script on what they have access to. Of course, sooner or later somebody will need to go tick in that Run As Admin box. And, of course, once a deployment is Run as Admin, very…

Hello, Which Netsuite transaction do you refer to when you say "DO"?

It is exposed, you could script it, yes. I have done this before.

The <%> tags generate at server-side side, and javascript triggers client side. Therefore, you cannot use javascript to generate values to feed to the <%> tags.

See this thread.

I'm not sure if that's what you want, but this would be Revenue Recognition with a Variable recognition method. You invoice the hours up front, and recognize them as time is actually entered against the invoiced project. This requires the Advanced Financials module.