try nlapiGetLineItemText() Since this is a client script you might consider taking the nlapiGetLineItemCount() out of the loop as that will be evaluated each iteration. One more thing, concatenation is a bit expensive, you could use an array to build up your list then join var disp = new Array(); // loop disp.push('some…

Thanks for the post. I think why I'm not able to get this to work is that I'm not trying to get a field from a record, but a list. (Setup->Customization->Lists) Here is the code I'm trying to use (throws INVALID_RECORD_TYPE) var phyStateID = patient.getFieldValue('custentitypatientmergeutil_physstate'); var physState =…

*bump* Anyone know how to accomplish this? NetSuite support is saying it's broken, so I'm wondering how else I can load a value from a custom list given the id of the list item. I really don't want to model my custom lists with arrays in javascript so I can do lookups :(

Need help in pulling string name instead of internal id from a select field via script. getFieldText()

Hi Yang, I modified my code what follows and am still getting errors? Any idea where I'm going wrong? My Code: function grab_line_options() { var disp=""; for (i=1;i<=nlapiGetLineItemCount('item');i++) { var item_name = nlapiGetLineItemValue('item','name',i); var item_name_text = nlapiLookupField('item',…

AfterSubmit User Event script on the custom record? yes, exactly. Does this script work if you create the custom record from a logged in session? yes it does. I have opened a case for this issue: 479441 Look forward to seeing how this one ends up!

Hi, Did you ever figure out how to insert a line item from server script? Thanks, Steve

It appears that subject has a maximum length that isn't documented and throws a useless error when encountered. Much wasted time. :mad:

User Event scripts fire when leads are created via online forms. Are you deploying a User Event script (beforeSubmit/afterSubmit) on lead/customer records (depending on your account type)? Thanks, Yang This thread has kinda been hijacked by other questions. I'm having the same problem as the original poster, my online form…

Thanks for the reply! I've re-read your response a few times and I must admit that I'm not following you. :confused:

Oh wait, I get what you mean! It's actually very clear, not sure why I wasn't getting it. Getting old.. my brain is rotting. OK, so what's the down side to this solution? [LIST=1] [*]It prolongs our business relationship with Company B which we are trying to avoid. For example, if a PO is back ordered for 3 months we will…

Are you saying that you don't like Please open the attached file to view your Invoice. ?? ;) I agree, in fact I found this thread after opening case #975968 asking if there was a way to modify it. Imagine if we could create a template and use merge tags with the customers name, sales rep name, details of the invoice, etc.…

Enhancement # 94013 - Customer needs to customize the invoice email template (upon save and to be emailed = T)

To track progress of calling customers to pay up, I created a custom list of progress statuses and added a custom field to sales orders, sourcing this list. Wouldn't it be nice if we could manage the status list of transactions like we can for customers? I'm very surprised to find this doesn't appear to be possible. I had…

Thanks Ray, I just emailed skyytek sales to discuss implementation, I mentioned your name. Just an FYI. Thanks again, Steve

Thanks for the response Walter. I agree with what you said and think we'll stick to the paper for now.

Pft!, sailing... Ha! I'm at work! Wait.... :(

What are you switching to and why is it superior? I would really like to leave paper behind if possible but need a solution that is just as simple for our lowest skill level users.

Hi Jim, Thanks a lot for the detailed response, I appreciate it. I read your post and banged out two test files real quick and as soon as I clicked the "Multiple Files" option I had my "ah-ha!" moment. See, I was trying to use a single file (which I had read on the UG and been told by support WAS possible) and was…

Thanks for the confirmation and suggested solution. I ended up using the debugger to throw together a quick script to accomplish what I needed. It did the job.

Hi John, Thank you for the reply! One of my concerns is minimizing table size. It would seem that my best option would be to dump my code field from the record and store the 'code' in the Name field - this would serve two purposes: [LIST=1] [*]Facilitate updating [*]Minimize required storage space (I won't be storing…

John, I've got a new challenge related to this issue. I realize that I want the description to be the field that users search for or in a list, I would want them to see the description, not the numeric code. This poses a potential problem: If my data's 'code' is the field that I want to use as the unique ID and I map it to…

Glad it worked out. Thanks, me too. The order is internalId (if mapped), externalId (if mapped), then name. It could be that it's there and I didn't see it, but this would have been great if it were in the help. It's such a simple statement but would have made such a difference. :) Actually, in addition to the help it…

WooHoo! (did a quick test, it uses the externalId, thank god!)

Thanks for the reply. Yeah, I know what you've mean, I've seen that happen (or not happen!) as well. However with my situation I don't think that is the cause, not for the majority of them at least. It's turned into a real mess, I finally resolved myself to just update the period and get through it, but right away I…

BTW, if you want to create a Saved Search that will locate Data/Period mismatches you can use a formula criteria ( == 0) like this: CASE WHEN UPPER(TO_CHAR({trandate}, 'mon yyyy')) = UPPER({postingperiod}) THEN 1 ELSE 0 END I've setup a scheduled search to alert our accounting department whenever a transactions meets this…

Thanks Ianic. I think your shipping reconciliation process would be the best option at this time. As our volume grows I can consider a WorkFlow or script to automatically discount shipping for customers with a certain custom field value. The other advantage to using a discount would be that I don't need to create a shadow…

Did anyone ever find a solution to this? I just ran into this same problem and realized that lame-o NetSuite doesn't transform the Item Fulfillment into a valid Invoice. :h_a_w:

Sorry for late response, several other fires flared up and I had to run to them :p Anyway, this issue came up again and it made me seek out this thread to update it. Here is the current situation: Balance: 0.00 Overdue Balance 0.31 (just like my first post...) Transaction History has: [LIST] [*]1/22/2011 Invoice w/ 0.31…

we just converted 100+ items to L/N inventory items. There is no conversion I'm afraid, here is what we did: 1. Export the current list of items to be converted to CSV 2. Import the CSV back as L/N Inventory Items 3. Export all unshipped sales orders that contain the "old" items to CSV 4. Update the item ids and import…