You could also do {custbody_xxx}/nullif({Amount},0) which will omit the formula if amount=0. Evan, I must be missing something here. How does the "nullif" avoid division by zero? My understanding of "nullif" is if {Amount} is NOT null, then it uses the value of {Amount}. If it is NULL, the it uses the alternate value,…

When you drill down on a summary search, any fields that do not have the "Group" summary type, including any fields with no summary type, are displayed. This is how you can customize what is displayed on drilldown, though you can't remove any of the summary fields. Thanks, -e Why not just use the fields on the "Drill Down…

We have plenty of custom KPIs here that we wrill down from. Evan, would you mind sharing the definition of your custom KPIs if you feel they might be of general interest? Thanks.

Temple, Irrespective of whether or not the system allows the user to make a change, here are some things you can do to help mitigate their action: [LIST=1] [*]Remove the permission to delete ("FULL") from all roles except Administrator (which you can't change anyway). [*]Limit the users with Admin role to the absolute…

This has been discussed before in this UG -- you might do a search to find the topics. As I remember, the solution is really a work-around. There are a couple of choices. [LIST=1] [*]Provide Terms as a separate PDF file [*]Append Terms to end of SO PDF using a PDF editor like Acrobat. [/LIST]

I'm trying to do a transaction column field formula with a default value as: {item.itemid} (the formula button is checked) When I do this, the value provided is always the itemid of the first item on the sales order. I would like this to use the itemid related to the line item I am entering.. I know its possible to use the…

Thanks for the suggestion. Unfortunately we do need the selected Roles to be able to EDIT using the UI.

We have several forms for various records, and we'd like to find a way to associate a given record with whichever custom form we want. Kyle, I pretty sure the only way currently to achieve this is by using a script: [LIST] [*]When you create a new record a onLoad script would use some criteria you provide to determine…

. . . Ideally, I'd like to add an "On Hold" checkbox next to any address which has given us problems. We'd want this at individual address level though, so if a customer has multiple addresses against their account, we can set this option on a single address. Thanks. One possible work-around is to use the Address LABEL…

The Item Description field autosizes on the Invoice entry form based on the number of columns and the width of your browser window. You might try maximizing your browser window if you haven't already. Another option is to provide a default value for the description that is very long. For Example:…

If the delivery date is based on when the order is shipped, then you might want to use Ship Date in the formula instead of Transaction Date. Of these two are the same, but not always.

While you can set different preferred forms for different roles, this only applies during record creation for transactions. Transactions always display in the same form it was last saved in regardless of role restrictions. I really wish NetSuite would change this. HTH.

Hello David, You can make use of SuiteFlow/Workflow Manager to do this. Here is a sample I can give you. Thanks for the example Ben. Very helpful. :)

How do I set the default value for a standard field on an entity form? I know how to do this if the field is custom. This requires a simple script. Check in the Help system and this UG for examples of beforeLoad scripts.

. . . doesn't mention OR or AND operators as far as I can tell. That's somewhat surprising. Although I guess NS isn't really a primer for any programming language, including SQL and Javascript.

Yes. The standard Oracle SQL operators are available, like AND, OR, etc. For more info, see the online Help, and search for "SQL Expressions" HTH.

This seems so obvious, doesn't it? How could the designers have missed it?

Do you know if the formula could be ammended to show the details marked as 'Residential Address'? Chris, Not that I know of. Billing and Shipping addresses have special fields that capture the data for display. I think you would have to do this with a little scripting: Search for Address label = "Residential" and then…

I don't think it is possible to change the default address, but you can create a custom field (not stored) to show the shipping address. It's a bit complicated formula. Do a forum search on "shipping address" and you should find it. HTH.

On the Custom Record, use the "ID" field for your license number, and the "Name" field for your description.

You can use inline HTML fields to do this. See NS Help for details.

Wow. Every one I have checked has an inactive checkbox. "When you check this box, this custom list no longer appears unless you check the Show Inactives box at the bottom of the list page. Field ID: isinactive" I think you are referring to Custom Lists. At the bottom of the Setup > Customization > Lists page there is a…

How do I add a signature field to an estimate, similar to what NetSuite does with its estimates? At the very bottom (of the last page only, if multiple pages), I need to add: I AGREE TO THE FEES AND TERMS OF THIS STATEMENT OF WORK: ________________ _____________________ _______________ Print Name Signature Date The above…

. . . What we would like to be able to do with this is add a checkbox to each address record, to indicate to our custom site if the address is to be included in the list of addresses that the customer chooses from when placing an order - the site would display only those addresses which are unchecked, etc.. . . Perhaps you…

Maybe you should checkout Transfer Orders, they do allow custom fields, etc Thanks for the suggestion. Does Web Services (SuiteTalk) support Transfer Orders?

I don't understand why NS would roll-out a major new feature like Inventory Transfer and not allow ANY customizations. As Miguel points out, Inventory Management is one of the areas that is most likely to need customizations. NetSuite, can you please share with us what's on the roadmap for Inventory Management?

I want to put some formula fields on the transaction columns. Eg. Length * Width = Area Is this possible so that the user can see the result without saving or is it only possible post saving? You should be able to create a custom transaction column field and UNCHECK the "Store Data" box. On the Default Value field, check…

I have a legacy field called 'SF Account Owner' that I brought over from our old system. This is a text field. I have a new field called 'Account Owner' which is a list pulled from employees. How can I default the value of the old legacy field if the new field is null? ....meaning display SF Account Owner in the Account…

I think you are going to need a simple script to set the field to empty on the Invoice.

My team work together a lot and are often complaining that Netsuite looks different to them depending on who's login they are using... Charlie, This is a problem many of us have noticed: The different NS Roles use different role "Centers", which changes dramatically the tab/menu structure. Our solution was to create all…