Although I think the chances are VERY slim it is still good practice so I tried to change. Using {internalid} || '_' || {line} did not work for me. Strange... But I did get this to work: Formula (Text) CONCAT({internalid}, CONCAT('-', {line})) Either way I learned something very useful today. Thanks. Didn't mean to hijack…

Good catch. I had gotten burned on count when mainline=yes and didn't dawn on me when reading your initial question. Sorry...

Add the field Internal ID to your results and under Summary Type select Count. When you run the search, all you will get is the total number.

I have had the same issue when I have a search that works and I then try to add filters on the footer and it will not allow yet is I recreate from scratch the check box is available.

Try using a formula(Date) in the criteria??? I seem to remember that worked.

Depending on the field/values, your best bet is probably a workflow.

Chris, I don't believe you can populate the second field until the record has been saved (unfortunately)

Create a search that just displays the created by field and use that search to source a custom field that is not stored?

you ONLY need a Filter as field Internal ID (so it will "join" to the record you are viewing with the custom field). You do not need to check the checkbox to display the filter Actually, you DO want criteria at least of Main Line=True/Yes plus if you are only displaying the field on specific transactions, Type could be…

If you edit the Form you are on, you will proably see the the Custom Form field is unchecked (ie: Hidden)

you ONLY need a Filter as field Internal ID (so it will "join" to the record you are viewing with the custom field). You do not need to check the checkbox to display the filter

David, Unrelated but maybe helpful... You can string multiple concat's together using the "||" '<img src="http://www.domain.com/image/' || {itemid} || 'something else' || {storedisplaythumbnail}

Yes, if I understand this correctly. It would be a field sourced from the Contract that calculates the total value of POs currently allocated to the selected contract. You will first need a custom field on the Contract with the current value of POs that will have to be updated on a schedule???

I believe that if the field is hidden it will not be available. Since you are new, hopefully you use Chrome. Check out the NetSuite plugins for Chrome. Some let you search values of fields on the form. Also if you add "?xml=T" to the url you can see the underlying data

Just be forwarned, when you do a sales order saved saved search, non-stored fields will be blank. Only visible if you view the actual record or print.

I actually just did it and it worked for Estimates. Did you have Store Field as NO? If not it would work only on new sales orders created from quotes.

Yes it did with 2018.1. It is now its own subtab "Sublist Fields"

We have a different form for our Canadian Currency vs. US Dollar. So we have 2 custom fields (1 for each currency) and place the appropriate on on each form.

For Kits, you need to have SUM for summary type on results and also need a filter of Internal ID (does not need check box checked to display)

Yes, tried both. Ended up using the suggestion of a Scheduled search to populate another field that does store the value.

Actually on the Item record there is a field labeled "Copy From Sales Order" this will take whatever description is on the SO and use that on the Drop Ship PO Check this box to copy the purchase description from the item description you enter on a sales order. Clear this box to enter a purchase description in the field…

Here you go:

Bump!

I may be missuing something but when you create a new custom field, click save and apply to forms. Uncheck the forms you do not want the new field on.

I am assuming you mean for printing purposes? You can use the Custom HTML forms to add anything that appears on the SO.

I may be mistaken but I believe the tab will not show "by design" as a lead does not have sales (once a sale is made the record transforms for a customer). You can create your own tab and create the appropriate search(es) that you can then display on the Lead Record.

I sometimes have to use the Customer Internal ID as the filter to get things like this to work. If you join to the Customer record in your search and use the Customer Fields... Internal ID as your filter it may just work.

No unfortunately. You should be able to create a customer transaction column field that sources from the item record (been a long time since I had to do it) which you can then reference.

Matthew, You should just be able to use CSV import to initially populate (If I understand your question.)

It has been a while so I went back to see what I did. First you need to create a custom item field (for all applicable item types) and then use a workflow to copy the NetSuite Manufacturers Tariff value to the custom field that can then be sourced into a transaction. Check out Suite Answer [LEFT]33655 for the workflow…