Same concern here. We are taking a similar approach by adding a formula field to display on a Saved Search, as well as an additional field to use for Inline Edits (since formula fields are available for inline editing).

Make sure your ID is correct. Look at Setup>>Accounting>>Accounting Lists For the Price Level list, you should look up the IDs and that is the ID you want to place in here instead of "1" - so, in my item search for example, the price level I was looking for had an ID of 5: {pricelevel5} I was just wondering if this works…

Perfect. I believe this is exactly what I needed. Thanks!

That would be the best way to get the backordered number. In related news, the item record field Quantity Backordered in not working today for some reason. We noticed an hour or two ago that this number is way off, and sometimes items with no backorders associated with them are showing quantities in this field. We have…

This is having a severe impact on our account, actually, because the issue with Backorders not showing properly means we placed POs for the wrong amounts on tons of items. Not to mention alerts that are all wrong, etc.

Are there any enhancement requests filed with Netsuite on this? This is ridiculous. Any suggestions on getting to this number? I need to see only POs. I guess I could have a static field that is updating via scripts around the clock...

I cannot believe this - is this a joke??? We are trying to calculate GP in many instances, and whereas we used to add the cost figures to the sales amount to end up with Gross Profit - which Netsuite doesn't tell you - we now end up adding two positive numbers instead of a positive and a negative? How can this change with…

EVAN! Thanks a lot!

It should be {user}, as in the following: {user.entityid} Does that work for you? If you hit the dropdown in the builder there are options for User Fields... and then you can select any field from the User record that you are interested in comparing. The above (entityid) is the value for the "Name" User field.

My head is spinning just a bit, so let's throw this one into the mix: I have a percentage stored in a custom field, which represents the percentage of sales that should be spent in a certain category of items. Let's call this an item-level field, a custom field on the item. Next, I have a search that pulls up the actual…

I've decided to do something similar to what you are suggesting, Vicente. I am storing the total sales for this customer in a custom entity field, and using that to divide the sales in a category by that number. Thanks!

Has there been any movement on this? Even if you look in the Records Browser, the Packages sublist is not even listed. Fields, search fields, nothing. There has to be a way to get to that information. We would love to see package weight (lbs) as well. Anyone? Netsuite?

That's great, and that'll work if you want to sort by both fields. However, I want to be able to sort by any single field. There are plenty of use cases for it, but I can't seem to think of a way to sort by either or, without modifying the search and moving the results around so that it is the first formula field. (That is…

Thanks, Robert! I think that from what you're saying I now understand - I enjoy seeing internal ids, but just want to prevent others from seeing them. So, when I hit save and email it shouldn't send them the results with the internal id, correct? Thank you.

Well, that is the thing - my preference is set to show internal id's. However, if I schedule this to run and send emails, it won't. Correct?

Thanks! This is true, I can now verify. Not only that, after posting I ran a few tests and when you hit Save & Email it will not send the internal ids based on your preference, rather it leaves them out. As intended.

One more caveat: THIS SEEMS TO ONLY BE HAPPENING WHEN I FILTER BY ITEM NAME OR TRANSACTION NUMBER. I AM AT A LOSS - IF ANYONE HAS ANY INPUT, PLEASE RESPOND. THANKS AGAIN.

NOTE: I am performing an Item search and not a Transaction search. I am not sure if that plays a key role in the results being returned in this manner or not. The quantity I am trying to SUM is coming off of the joined field on the Transaction. Thanks!

Additionally, I believe I found a flaw in this recommended search! The From location is not always going to be the Maximum, for example in our case where we have a location that is a sublocation of another. The maximum in such a case shows the child location, and the minimum the parent location, even though the transfer…

I am, Dave. See my post above (#3). . .

No go, Evan. I'll tell you what seems to work, and I can't imagine why or how this went on for so long without me realizing the following, but I still can't really explain it: If I remove my filter by name (Name Is Widget A) then the results are correct. I had even had it to the point where the results were returning the…

Olivier, Thanks, but I don't think going that route is helping me. I believe you are referring to a method that Evan Goldberg suggested to you in this thread. I saw that one (coincidence that you were very active in that thread as well?) and tried it, as well as many variations thereof, but keep on running into timeout…

Olivier, Thanks. I am performing an Item search, joining on Transactions. Let me explain. We are searching Items and filtering out only those items that were sold in the last six months, based on the following criteria: Transaction : Main Line is false Transaction : Date is within previous one half Transaction : Type is…

Thanks. Actually, I thought of jwenzer's solution right after posting, with a slight modification - which will answer your question as well, trimblee: I was looking for all items that are not under a certain income account. So, I wrote the same formula that jwenzer suggested (almost identical), with the exception of the…

Any update on this? I am attempting the same kind of search, but to no avail.

What about items with NO activity? Will this filter only by items with activity prior to 12 months ago, or any items even with no activity ever?

I apologize - I am using that (@ and not .), I just wasn't copying it directly from the PDF template when I posted. So, any other ideas?

I already did, this morning: Case# 2299897 Created: Advanced PDF/HTML Template Bug with Record Title

I am going to hardcode it, but this is being used for more than one Custom Form, and we wanted some to read differently. Either way, seems like a big to me too! Thanks for the confirmation, thought I was losing it!

kimosalen There seems to be something wrong with Netsuite for me. When I add a custom field on the transaction in this manner, I cannot source the sales rep's email field. Just about every other field shows up in the list, but not Email. Why would that be? I actually had this issue a long time ago, and made my way around…