Dew2 Red Ribbon

The missing single quotes would indeed cause an Invalid Expression error. Not sure what would cause the quotes to go missing. When you say "the program deletes them", do you mean NetSuite? For example, Excel has a tendency to remove initial single quotes, so if you're pasting/copying from there, that could cause issues.

A workaround that I use for adjusting column widths is to use Formula (Text) something like: '<div style="width:100px">' || {fieldname} || '</div>' The double pipe || concatenates and the html must be enclosed in single quotes.

A workaround that might work for you is to sort by Internal ID rather than Formula (Text), because it's possible to sort by non-displaying fields.

I was involved with the creation of that defect 336043 almost 2 years ago. Our issue was with a CSV export; we worked around it by removing one of the criteria (and then filtering in Excel); it was never explained what in the criteria causes the issue. Maybe you can get what you need by playing with the criteria.

I don't have any experience with dealing with Payment Events, but it seems that you can do a Transaction Search with Payment Event criteria... [ATTACH=JSON]{"alt":"Click image for larger version Name:\tClipboard02.png Views:\t2 Size:\t54.5 KB…

There are 2 things you can look up in the NetSuite Help Center: "Inventory Adjustment Import" and "Single Inventory Worksheet Import". These might help you.

Unfortunately, all the Reorder Multiple does is suggest quantities to order when going through the "Order Items" page.

I don't know how NetSuite chooses the account to use; perhaps the preferences under Setup > Accounting > Accounting Preferences > Items/Transactions? Anyway, the way we would do it is to create/save the item with zero quantity and then do an Inventory Adjustment where you can specify the account you want to use.

We found that items would not show up on the Order Items page if the reorder point was not set. We set up a Saved Mass Update scheduled to run daily to look for items with an empty reorder point and set it to zero.

Yes, this is how you do it. We have done it frequently. It's misleading or incorrect when NetSuite says "xx failed".

Was it a drop ship PO? In that case the "Quantity On Order" is unchanged.

The 'Applied To Transaction : Item Rate' result is a good way to go. Just put an additional criteria on the search of 'Applied To Transaction : Account' set to your sales revenue account.

How many results were you expecting? Global search does not return all results if there are a large number of results.

Template doesn't seem to be available. You can use the Records Browser (search for "Using the SuiteScript Records Browser" in the NetSuite Help Center) and look under "item" - "Search Columns" to see what's available.

You should see a "Category" field, as well as "Category (no hierarchy)" and "Category (preferred)".

Oh, the inconsistencies of NetSuite... Try CASE WHEN ({billingtransaction}=' ') then 1 else 0 end That's 2 single quotes wrapping a space. By the way, that works for the line level, not Main Line.

If you use a date criteria of "on or before 12/31/2015", then it will omit any items that have no transactions. To include those items, instead use criteria of "not after 12/31/2015".

I picked this up on the forum somewhere, don't know who to thank, but to calculate business days between transaction date and today's date use: TRUNC((TRUNC(SYSDATE)-TRUNC({TRANDATE}))/7)*5 + MOD(TRUNC(SYSDATE)-TRUNC({TRANDATE}),7) - CASE WHEN TO_NUMBER(TO_CHAR(TRUNC(SYSDATE),'D')) &lt; TO_NUMBER(TO_CHAR({TRANDATE},'D'))…

Are the searches executing according to the "Execution Log" of the saved search? If they are, are the emails showing up in the "Undelivered Emails" page?

We had this issue with the standard field "Detailed Description", perhaps your issue is the same. After a lot of back-and-forth with support I got this response: Unfortunately, due to the limitations imposed by underlying technology (Oracle) we are not able to display in certain cases Detailed Descriptions longer than 1300…

Just FYI, {today} includes a factor for the time of day (so at noon it would essentially have a ".5" at the end). You can use the TRUNC function to reduce this to a "day only" value like so: TRUNC ( {today} )

How about something like: <span style="font-family:'courier new'">Criteria &gt; Standard: Type is Purchase Order Main Line is True Date is before yesterday Criteria &gt; Summary: (Maximum) Messages: Is Incoming is false Results: Date (Group) Document Number (Group) Name (Group)</span>

Instead of using the field "Available" in the results, try using a Formula (Numeric) of NVL({quantityavailable},0) , set a Custom Label of "Available", then sort on Formula (Numeric).

Couple things: First, I believe the color values need quotes around them. Second, changing the background color in the <style> section would apply it to every line, thus all the colors would be the same (whatever the color of the last line is). Therefore, you would need to reformulate the code to change the color within…

Add a criterion for "Pricing Fields..." (down at the bottom of the dropdown list), specifying the Price Level that you want. Then for the Results, use "Pricing Fields..." again, this time specifying "Unit Price".

Poorly written article. Step 1: You can also use an Item Search. Step 2: There is no "Results" subtab on the "Criteria" tab. Just use the "Standard" subtab. This step is unnecessary anyway. Use whatever criteria you need to filter the results. Step 3: Again, there is no "Columns" subtab. It doesn't mention that all other…

In SuiteAnswers, Article ID 13928 shows how to do this. The article doesn't make clear that you replace pricelevel1, pricelevel2 etc with the names of your own price levels and that on the results tab, other fields beside the formula fields (e.g. "Item") have to have a "Summary Type" of "Group".

I have a saved search for related items. The NetSuite logic is a little twisted, so here's what I have set up: Criteria Type: Inventory Formula (Text): Formula: {category} , Formula (Text) starts with: Related Results Category, Custom Label: Item/Name Number Name, Custom Label: Related Item Description Internally NetSuite…

I don't know of an option to control inline editing on transaction forms. Perhaps you're running into the limitation that "if a field on a record is referred to by a formula custom field, you cannot edit the referenced field with inline editing"?

Look at the custom form in which the field would be used, under Customization -> Forms -> Entry Forms