I'm not sure I understand what you are trying to do. Are you going to use a script to create a bunch of customers in the system? Where is the data going to come from? Shouldn't this be handled via an import? If you import your customer, insteas of a scheduled script, you could then simply have an AfterSubmit script that…

Well, the email title will be the name of the Search, and the email will display the Columns you have selected in your Saved Search. That is the extent of what you can 'customize'. The Alert email also links to the record that was created, so the user can just click that and see the whole record anyway. If you need…

From memory, I think custom form is still not exposed to CSV or Mass Update. That leaves a scheduled script as your option.

Have you tried putting doSourcing as True on your submit?

Remove the right to "Non Posting Register" under List.

Steve, Hopefully Yiggy will drop by and go over this, but I don't think you can set the form field on beforeLoad, as only non-stored value fields can be changed on beforeLoad. Plus, I'm not sure using nlapiGetNewRecord(); is a good idea, since it's beforeLoad, hence no commit was done, so I don't think there is an Old or a…

Yeah, you will have to re-create the dropdown as a UI Object and populate it with only the values you need - i.e., it is impossible to dynamically remove values from a dropdown, so you must recreate it and leave out the values you do not want. As UI Objects don't store value, you'll want to transfer the selected value into…

Well, for one client-side script I once tried to have a button write an XML file and save it on the user's computer. You can google around for more information on this, but the general principle is that you open a new window (using window.open() ), write in there whatever you want, and then when you are finished you can…

Yeah... the closest thing you can do is a Mail Merge. You can create your PDF template (you'll need Adobe Acrobat, not just the reader), making sure to place the tags that pull data, and then merge it. Not quite a SO-style printout, but it may work depending on what you want to do with your custom record.

I think your best bet is a Before Submit server-side script. Read all your items, stuff them in an Array, clear all of your line items, sort your array alphabetically, and then re-enter all your line items. Bit of a pain, but you should be able to do exactly what you want.

You have to specify each field, sorry. There is no array or collection of existing fields you can iterate through. It may not be that bad - many of the core fields are never going to be removed, so tat shouldn't be a problem. You can make your script try to copy all of the possible standard fields, and make your code…

I'd just like to add that when checking the value of a Hidden checkbox that isn't checked, it no longer returns 'F', just '' as above. If the checkbox is visible, though, it returns 'F'. Edit: Hmm, I think this recently got fixed. My hidden checkbox just returned 'F'...

Sounds like a good approach, though it does leave you vulnerable to problems such as someone deleting that record, or something else along those lines. A safer, but maybe a bit time-costlier approach would be run an nlapiSearchRecord to grab the Max line number from all existing SO lines. Then you don't have to worry about…

You can't change the name of buttons, no.

Luke, I tried this again today and noticed it wasn't fixed in the 2007.0.5 release. Do you have an ETA for this fix? We had the same problem and called up Support. Basically, any form that was created while the bug was in effect continues to be bugged. If you create a new PDF layout, it shouldn't have any problems. That's…

For those interested, I've written a short blog article explaining how to use a formula to output the correct Unit of Measure Item Rate in your searches, instead of outputting the Base Unit Item Rate like Netsuite does by default.

Easily - perhaps not. But you can grab the current system time which which is simili random enough and then somehow use it as a seed number to generate letters out of the numbers. If anyone seriously asked me that I'd check the full use case though, possibly it'd be a better idea to do it some other way.

Yes and no. To get "As Of" quantity, you need to manually recompile all ins and outs of the inventory-affecting transactions. It's a heck of a search that takes hours to get right. But having done it before, it IS possible. Just very painful to create.

That's cool then, you have access to all the fields you need. Take a look at an item search, you have Member Quantity and Member Item... fields, you should be able to build the results you need. Again, NOT in a formula field, but in a sublist.

You can't use a Formula field, but you can put a sublist on the item record to show this information, provided your Kit only has 1 level of members. I.e., if you have : Kit A - Member 1 - Member 2 You can get the cost by joining on "Member Item..." If you have a structure like Kit A - Member Kit 1 - Member 1 - Member 2 -…

Your fields must not be outputting what you expect (i.e., they are actually indeed outputting blank values). Add 3 new formula fields and output only the values of your fields, 1 by 1. I imagine you'll find there's a problem with your search.

Oliver, I couldn't figure it out. It was way to complicated for me. I did find and vote for this enhancement: I'm surprised that the NetSuite developers made a button to get the sum of the weight of the kit members, but forgot to do the same for vendor costs. -T Farrago, I finally got around to making a blog post detailing…

You need to set on the custom record that the Customer is a parent. I'm a little rusty on the details, but it goes something like this: On your custom form, you must have a field that is sourcing Customers. On that field, click the "Record is Parent" box. I think that's all... give it a try and if it doesn't work, let me…

Nevermind, found a way by calling a search, which can return credit card expiration dates.

Where is your script being called from? The Puchase Order?

Was that a copy/paste of your script? Cause you're missing a ' in: if (name == 'custform') && (nlapiGetFieldValue('custform) == 14) on the second custoform. See it? Further, you're going to want to use nlapiDisableField(whatever,True) instead of false. Saying you're not disabling a field won't get you far (double negative…

What kind of info are you looking for? Post Sourcing and Line Init are described along with the other interfaces under "Functions" in the guide, page 6.

Well, the custom code guide is pretty much all you get, so I'll try to clarify things a bit for you: Post Sourcing relates to fields that fire off changes in other fields. For example, when you select an Item on a line item in a Sales Order, the Unit Price automatically loads, right? Well, putting code on Post Sourcing for…

1. Timehseets and Time Entry are vastly different and script differently. The OP said Timesheets, so if that is accurate, Time Entry code cannot be compared 2. Timehseets have been deprecated, so if you are indeed using them, now is the time to consider an exit strategy. I would not add more code to them 3. It is very true…

Ok good, not Timesheets then. But, yeah. I ran into that exact same problem in our own Tribridge instance (we are after all a services organization). In our case we dodged the bullet by telling people not to use the Employee Center, which we can do cause everyone needs general access anyway. The only workaround you can…