Jeff in GR Green Ribbon

Our biggest issues have been with services and support being atrociously bad at communicating and unconscionably slow. We’re looking at Manhattan, Softeon, and Oracle WMS at the moment, but haven’t made any final decisions about anything. We just know the situation has to change.

We're in the same boat (except we've been using it for 6 years). I'd be curious to know what alternatives you're looking at.

Thanks, though this really needs to be a transaction-based search because I need to send email alerts when one of these new product arrives. The key is in establishing the first receipt date and using that date to filter the search. This is the part I can't figure out. I only want the search to return a result for an item…

Hi Matt, did you ever figure how to do this natively? We have a workaround that essentially achieves this, but I'd like to know if NetSuite allows for it out of the box.

Is it possible to source the quantity available at a particular location in a custom field (i.e. no scripting, just getting the value).

We use a custom checkbox "flagged" (or whatever you want to call it) for orders we don't want picked yet. The warehouse saved search for orders to pick excluded such sales orders. We do the same thing. We created a custom field on the SO called "Ready to Fulfill." When a salesperson enters an SO that they want quantities…

On second thought, maybe not, I just can't explain it. I'm giving up.

While I still have no explanation for the bin entry changes, I've come to accept that the chart of accounts issue must've been user error, perhaps complicated by the fact that the opening balances page only numerically sorts accounts by type. I guess it just can't be explained any other way.

Any more information on this? We need this feature as well.

Does this work? We have a customer who just requested this too.

Was a good solution ever found for this? We're in the same boat. We need to allocate duty charges based on specific item rates, but freight charges can be allocated based on weight.

Robert, doesn't that slow down the user interface whenever it is you do the sort? If you do it on save, does it make the save take a lot longer?

Felix! We're trying to create a saved search to produce a commission report that groups by the company name field on the partner record instead of the partner name itself. The company name field does not seem accessible from a saved search. There is inexplicably no "Partner fields..." option for the results columns. Can…

The line between static and dynamic is a little blurry. In this case, I'd say the list was static. A salesperson just told me he needed info on 30 items. But tomorrow he may tell me that he needs info on a different random set of 150 items. I don't know if that makes this static or dynamic. Creating a custom field on the…

Thanks. I tried that, but it requires me to manually type in the internal IDs one by one. I may need to do this for hundreds of items. One workaround I found is to use "CASE WHEN {internalid}=## or" and just repeat the "{internalid}=## or" part. This requires using excel first to do a vlookup of item names to get internal…

If you'll permit me, I have one more question: The search works. Now, I want to receive an e-mail alert any time a new transaction record with a duplicate number is created. Under the "email" tab I checked "Send Email Alerts when Records are Created/Updated" and I entered my name under "Specific Recipients." I also checked…

Never mind. I figured it out. Makes sense to me now. Thanks! For anyone else interested: There IS only one number, because they are duplicates. So "greater than 1" on number will show 0 results. But there are two internal IDs being grouped together under the same number result, so using "internal ID" (or name, for example)…

Can someone explain to me why Evan's search works? I can't figure out what the role of the "Summary: Count of Internal ID > 1" is in this case, though I can see that it's the linchpin of the entire thing. I tried to solve this same problem with a saved search. I ended up trying all sorts of complex criteria and results. It…

Thanks. I think I understand, though it's actually a little hard to wrap ones mind around. One question, though: Why doesn't it still work when I change the summary criteria field to "Number" instead of "Internal ID"? I'm grouping on the results tab by Number, so shouldn't "number" as the criteria summary produce the same…

We're evaluating Accellos right now as well. I was surprised to see no topics on this user group that even mention Accellos until this one. Surely someone on here has an experience they can share. zvictor, who else are you considering?

Our sandbox went down AGAIN during a refresh more than 10 days ago and we still have no access. NetSuite just endlessly tells us that they are working on it and will have a resolution "soon," but we get no more detail than that. I've never been so disappointed with NetSuite as I am now. Major failure on their part.

It's happening to us too. We were attached to the defect. It also affects the Total Value field in saved searches. Seems like it's pretty much anything related to inventory quantity or value.

Nope, unfortunately.

Thanks, tgrimm! I've been trying to do this forever. One question, though. The items are sorted as string values (e.g. 400, 4500, 460) But I'd prefer to sort by numeric value (e.g. 400, 460, 4500). I can't figure out how to do this. Any ideas? Is it possible to specify a custom sort order?

We did go with Arena. At the time, the Autodesk integration was still being developed. I'm not the one who uses Arena on a daily basis, but so far we've been happy with it. We're maybe not a typical Arena user as we do contract-based manufacturing of products we import from overseas, and we rarely design anything from…

I asked this question to NetSuite support, and below is the answer I got: Good question. Please see this Help Guide article for more information - Workflow Execution Model in Exit States Basically, the Workflow enters state (ie. creates an instance of itself in the record) during the 'Before Submit' trigger, where your 1st…

Of the workflow.

is the custom field set to store value=T? Yes, it is.

One key point that may help you. The search that triggers the alert must be a transaction search, not an item search. The item record does not "know" one way or the other about quantity levels. A quantity change does not actually alter the item record in the same way that changing a field on the item record does. The only…

No problem, I learned that from someone else on this board, so I figured the least I could do was pay it forward. Did you use the {results} tag in your email body?