would something like this work on a page init function? function sale_init(type,name) { if (type = 'invoice') { nlapiSetFieldValue('customfieldname',' '); } } That's just about right, aside from a few little things: function sale_init(type,name) //Type is the event type, not record type { var recordType =…

Free-Form Text and List/Record are two completely different things. If you want to convert the existing field, I would suggest exporting all data from that field into a CSV file (with the internal ID of each associated record, to keep a link), map your new List/Record values to the old values and re-import through CSV.…

NetSuite's API doesn't allow disabling of tabs. May I ask what the underlying requirement is? Why do you need to disable a tab in certain situations?

Just like in your previous post I answered, don't forget that nlapiGetFieldValue('entity') returns the entity's internal ID. You need to filter your search on the internal ID, not the Entity ID.

Hi Damon, What is the formula used in your custom field to calculate its value?

Hi Bushra, 1) What type of field is it? 2) Are you using a Default Value on your custom field?

If you just want to see the PO# from the Fulfillment, try unchecking "Store Value". If you want to EDIT the PO# from the Fulfillment, that's not possible. You can't edit fields from one record while editing another. Sourcing it with "Store Value" checked would basically copy the value on the Fulfillment, but once it's…

Generally for Yes/No fields, you're better off with a Checkbox field, unless you're planning to have a third option (like "Maybe"). List/Record fields don't support formulas to specify a default value. If you absolutely need a List/Record field, you'll need to use scripting to do what you're asking. With a Checkbox, you…

First and foremost, do you have any scripts running on the form? Other than that, I've seen custom forms just being corrupted and acting strangely. Usually, deleting the form and recreating solves the problem.

I believe Item Labels are limited to Item fields, so you won't be able to display transaction columns on them. Evan/yang/Phil, correct me if I'm wrong.

What are you trying to customize on the Quantity and Amount fields?

Hi shirley, How did you set up the "Global Subscription Status" field on your Online Customer Form? Did you just select the field in the "Select Fields" tab? A custom field can't link to a standard field automatically based on its name or ID. In fact, the ID of a custom field always starts with "custevent" or "custentity",…

Hmm, I guess checkboxes don't allow using Formulas for default values either. At this point, I'd say just use a Free-Form Text field. Make sure Store Value is not checked, or the field will never update itself. Note that Store Value False fields aren't available in Reports, only Saved Searches. If you need to do Reports…

{shipaddress} isn't a real field, it's only available in Saved Searchess and possibly Reports.. See this thread: https://usergroup.netsuite.com/users/showthread.php?t=17550

Hi Gary, You can use the CASE statement in formula fields to do conditions. Something along the lines of: CASE WHEN {custentity_expiration_date} < {today} THEN 'F' ELSE 'T' END Let me know if that works for you.

I've never had issues with Store Value False fields, and I use them on a regular basis. Note that if you stick to Saved Searches, you technically don't need to have an actual "Support Active" field. You can just make a Formula Field (Text) and insert your CASE WHEN statement as a result column. Of course, if you do this,…

Hi Edgard, Try putting your code in Post Sourcing of the item field instead of Recalc and let me know if that works. If you're still having trouble, please post your code and I'll try to help.

{name} has just entered a <%= case when {totalamount}>=1000 then 'large ' end %>order Nice! I knew about getAttribute(), but I didn't know you could literally embed SQL expressions within those special tags. Thanks Evan, I'll be trying that out real soon.

the help indicates that it should support CASE statements but it doesn't. I was positive that "Default Value" formulas on custom fields supported CASE statements so I tried it for myself: - Created an inline HTML Transaction Body Field; - In "Default Value" I entered "CASE WHEN {status} = 'Paid In Full' THEN 'HELLO' ELSE…

82 listboxes and 450 forms? Talk about pushing NetSuite to its limits! Did you consider maybe moving some of that data onto Custom Records, and making the Customer the parent of those Custom Records?

Hi Edgard, Could you be more specific on what you're trying to do? I'm not sure I understand.

The simplest solution is to just have a field on the SO/Invoice where the sales rep can enter the last 4 digits of the credit card to be used. Since those digits are visible to everyone, the accountant can then use the digits to determine which credit card is to be used. On top of that, you could have a script that chooses…

I don't understand what you're trying to do in there. Are you trying to update the "Quantity" field or are you trying to update your custom fields? At any rate, you shouldn't need to update all your lines every time postSourcing is triggered. Here's an example of code that will trigger every time an item is selected:…

I hope I was clear that SQL expressions are not allowed within web store templates, but instead within the customized message body of email alerts. Thanks, -e Right. I may have gotten excited a little too quickly there.

Yeah, it should be pretty easy to code in a client script: 1) On fieldChange, check if the "item" column is being changed; 2) If it is, run a Saved Search that finds all PO's that include that particular item and retrieve the transaction date; 3) Run through the dates and keep the most recent; 4) Set your custom "Last…

Setup > Company > Printing, Fax & Email Preferences -> Printing Tab -> PDFs Section. Check the "Add Extra Space Between Items" checkbox. I found it in the help by searching for "print spacing". Hope that helps!

Hey JMU, I tested it out in one of our demo accounts and the "Item" column shows the vendor code. I'm pretty sure it's like that by default, but it may be a setting.

That section lists all Script Parameters that have their Preference set to Company. See "Defining Parameter Preferences" in the Help Center for more details.

There is no easy way to navigate the year. The user must type is in manually, versus selecting Day, Month and Year seperately. I really need to be able to customize the registration page to address this and other related issues. You could create 3 custom drop-down fields with day/month/year choices, then combine them into…

Looks like the Territory list is not accessible through Sourcing & Filtering. Depending on your needs, you may want to consider populating a custom field using client or server-side script. For example, you could have a script that, upon choosing the customer on the Opportunity, copies the name of the Territory into a…