Olivier Gagnon NC Red Ribbon

Aren't address fields list item fields? What error are you getting and where?

Ok, Thanks.

The client side function nlapiGetCurrentLineItemValue('item','item',1) is not working correctly in my 2007 beta test account. The majority of my client side scripts are using this function which is only returning a null value. Is anyone else having this issue? What's the '1' at the end for? It should simply be…

Hmm, good suggestion, but no, it didn't do anything. Purchase Orders don't have Price Levels anyhow. Still getting the same unexpected error.

Ahh, seems I have to manually update the order total before saving. That's probably what's going on. I'll give that a try later today, but I'm almost certain that's the problem. Thanks!

yiggy & evan, I'm trying to write a Server-Side Scheduled Script that would go into an item record and set Location Preferred Stock Level and Location Reorder Point at 1 and 0 respectively. Here is the test script I am using: function setPrefAndReorder() { var record = nlapiLoadRecord('inventoryitem',1542);…

Evan, Yes, there are locations. In version 11 I know that was a problem, if you had no qty information for a location, it did not show up in the list. Version 2007 seemingly fixed that, as all locations appear even if they have no info. However, it seems that as far as scripting is concerned, those locations still aren't…

"is" used to work a lot more than it does now. We had to change most of our functionning scripts from "is" to "equalto" after v2007.

Yang, I've been trying for weeks to get someone to explain to me what I'm doing wrong (or confirm there's a bug in the function) and be able to properly attach scripts using setScript() but I'm getting nowhere. I innitially received an email that simply told me to use "setScript(script)". Totally unhelpfull. This problem…

Hi 7, Right off the bat, I'm seeing 2 'spelling' error that would cause problems: 'equalTo' should be 'equalto' 'getID' should be 'getId' Those two right there would throw unexpected errors.

Quick question: When you defined your client script did you correctly specify the field change and validate field functions on the Scripts tab? Yes. Field Change, not validate. I tried putting it on Post Source too. I realized I could not have 'overlapping' functions in the record-level and form-level scripts (e.g. you…

Ah, very good. Is there something I can use to track so I get an email notification when the update is released?

Thanks, case is 583381

Soo.. on the beforeLoad event, with a Server-side script, I would need to create from scratch my list. Then, during normal user events scripting, I would be able to manipulate the data from this custom-built list using the Remove/Insert methods? Or can I only use the Remove/Insert methods BeforeLoad as well?

Yiggy, I was able to use nlapiInsertOption with example you gave. However, nlapiInsertOption did not work when I tried applying it to the dropdown I made in the time item sublist. It simply did not do anything. No errors, nothing. I could, however, use nlapiRemoveOption But if I moved the dropdown from the sunblist to the…

This is very useful, thanks. Regarding creating fields with beforeLoad - is it possible to create a field in a sublist? I got the code you posted to work fine. It appeared in the 'Main' position of the record. If I wanted to make it appear in a sublist, or for that matter, another tab than Main, how would I do that? Thanks…

I have a question regarding anyOf : How do you specify "anyOf -None-"? That is to say, specify you want the field to be empty? isempty stopped working about a month ago. When you do a Saved Search in the UI, you can specify 'any of none' - how do you do that in javascript?

Ahh, that's why! Ok, I got my script working perfectly. Thanks Yang, your help was invaluable!

Yiggy, the 'contact' sublist does not seem to exist... when I do an nlapiGetLineItemCount('contact') I get -1, even though I have 3 contacts listed for the customer... Trying to write to 'contact' gets me an error. The code is being executed client-side, triggered by a button.

I'm still having trouble with this. I can read all of the contacts of a customer through a search, that's fine. But I cant write them into a new customer. I can't find any documentation or any way to add line items to the contacts sublist. How should I be doing this?

Ah, for some reason it took you to point out that there was a contact machine for me to notice that contacts are indeed listed in the Join documentation. Well, thanks Yang!:D

Thanks for the reply, but I'm looking for a way to do this using scripting. Sorry I didn't state that in my post.

I'm calling function onSave() { var tranid = memorizeItemsToSO(); nlapiSetRedirectURL('RECORD', 'salesorder', tranid, true); return true; } from a Suitelet. The OnSave is, as the name implies, the OnSave of the Suitelet as per the usage of a Submit Button. My tranid is correctly being populated with the internal id of a…

Because the name is "createddate" ;)

Thanks Long, I will try that.

Here you go - for(i=1;i<=record.getLineItemCount('item');i++) { vendor = record.getFieldValue('entity'); item = record.getLineItemValue('item','item',i); qty = record.getLineItemValue('item','quantity',i); price = getVolumePrice(vendor,item,qty); if(price!=null) { record.setLineItemValue( 'item', 'rate', i, price);…

Hmmm... I see. Very interesting. Okay, so to put you in context, the client I'm doing this script for can have up to 300 members on a kit. As it is, I'm making an API call for each member with nlapiLookupField. That won't get me far. If I were to try and switch instead to first gather all the member's internal IDs and then…

Is there any particular order you should set the item fields and the required total fields Yiggy mentioned? As i'm still getting unexpected errors therefore probably unbalanced! I set all these total fields below after i have set the rate, tax1amt, grossamt and amount for each of the line items:-…

Sorry for hijacking a thread, but Yiggy, does v2007 still have the issue where you can't commit more than 1 line item because of synchronisation problems?

Thanks, that answers my questions.