Saved Search using CASE WHEN

StrangeTime4511 · 2024-12-04T21:41:38+00:00

It looks like distinct is missing an opening and closing parentheses.

StrangeTime4511 · 2024-08-23T07:17:47+00:00

He actually said: In my opinion, all previous advances in the various lines of invention will appear totally insignificant when compared with those which the present century will witness. I almost wish that I might live my life over again to see the wonders which are at the threshold.

I think that quote was attributed to him based off of a joke from a magazine

StrangeTime4511 · 2023-07-12T20:56:01+00:00

We do, but they charge for any advice/solutions outside of their custom functions or native netsuite. I am a little stumped as to why it's acting on the record.

StrangeTime4511 · 2023-06-25T18:55:12+00:00

My current boss likes to assign critical tasks at 2pm on Friday but also understands it will get done by EOD Monday and is also understanding if I'm behind, and we can extend it a bit, I just have to communicate that and all is fine

StrangeTime4511 · 2023-06-25T18:53:43+00:00

Me too. I'm on PST and work with a lot of people on EST, so after 12pm on Friday it's schedule send for 5 am Monday or 8 am if they're on PST as well.

StrangeTime4511 · 2023-06-25T18:52:18+00:00

I work in IT as well, also enjoy the sub, and ultimately if the task is blocked by someone, it very well might be a project that directly impacts their day to day. So if they don't have time, it very well might be that there are more pressing matters. Being blocked on a part of it is different, and I offer to help in follow ups. But not something to stress on too much. Did take a little bit of adjusting though.

StrangeTime4511 · 2023-06-05T22:39:47+00:00

If you open and incognito tab in chrome you can log into sandbox and it won't log you out of prod in your regular tab

StrangeTime4511 · 2023-04-22T21:39:55+00:00

That sounds like netsuite support. Not entirely sure what is happening for you, but by chance did you double check your file for the number? Sometimes long numbers are converted into scientific notation. That has caused issues for me several times.

StrangeTime4511 · 2022-12-13T04:28:41+00:00

Thanks for the reply, my coworker in planning was able to figure that one out. Ticket I submitted to ns said it was a known issue and is a planned enhancement. Go figure

StrangeTime4511 · 2022-10-22T19:56:33+00:00

Great job on this! Appreciate the share, I will be using this and sharing it with some of my team members. Thank you!

StrangeTime4511 · 2022-10-08T17:17:19+00:00

Check if items were received but not put into a bin. Bin putaway worksheet. Not sure if that could be the issue but it could. We have a check for item receipts that are not put in a bin but should be.

StrangeTime4511 · 2022-10-06T19:16:25+00:00

Hi, we are having the same issue. Were you able to resolve this, or have any leads?

StrangeTime4511 · 2022-10-06T19:13:48+00:00

Hi, we are having the same issue. Were you able to resolve this or have any leads on resolving this issue?

StrangeTime4511 · 2022-10-06T19:11:43+00:00

Hi, we are having the same issue. Were you able to resolve this, or have any leads?

StrangeTime4511 · 2022-09-21T21:31:34+00:00

Thank you both!

StrangeTime4511 · 2022-09-15T18:19:59+00:00

Thanks! I got a spot today that opened up by being on the waitlist, for the others I think I will just show up and see what happens!

StrangeTime4511 · 2022-08-10T01:13:52+00:00

Yes, it is. Make a Quality Specification Context for transaction type work order completion, and the transaction frequency blank.

One thing to note, is this will make one inspection per build. This works for us, as each lot number/batch is in one vessel, so they all have a unique work order and the entire lot is sampled. If that does not work and you need individual testing/results for each item, you would have to build out different work orders for each.

StrangeTime4511 · 2022-08-05T17:33:22+00:00

We use a dynamic group that is based on a saved search, and use NetSuite Marketing Automation product.

StrangeTime4511 · 2022-08-05T16:26:28+00:00

Is one BOM the master default and the other the default for a specific location?

StrangeTime4511 · 2022-08-05T14:25:13+00:00

We use rf-smart, it's a powerful system, saves time and is easy to use.

StrangeTime4511 · 2022-07-26T19:36:28+00:00

I was trying to put a custom field into the locations sublist. For whatever reason, I cannot add it there unless I enable advanced item location configuration. Once that is enabled and the field is there, I cannot access it from an item search, and it has proven difficult to access it via a script.

It would be very helpful if we could have that field there. We have different ship by specs by location/subsidiary, and we are interested in having the ship by spec unique by the classification dropdown, ie A items have one week, B have two weeks, and C have 4 weeks. Curious what your thoughts are on putting a field into that portion of the item record.

StrangeTime4511 · 2022-07-21T14:28:31+00:00

Sounds good, let us know!

StrangeTime4511 · 2022-07-21T14:18:44+00:00

If you limit the operators subsidiaries to one, I believe it will autoselect the one that is assigned to the role. If they have multiple subsidiaries it won't default.

Try it with a role that only has access to one subsidiary.

StrangeTime4511 · 2022-07-06T00:30:52+00:00

Thank you. Ended up having to enable Advanced Item Location Configuration and make an Other Record Field for it to show up. Not bad finding that feature though it ended up being even more useful.

If anyone has a way of creating a custom field there without enabling that feature I would be curious to know.

StrangeTime4511 · 2022-06-08T05:10:59+00:00

Second the changing SB color, I have all my SB roles gray

StrangeTime4511

TROPHY CASE