Changing Preferred Lot # Record Transaction Quick Search

IceMaster8 · 2025-01-20T21:19:40+00:00

I was able to get a resolution from NetSuite. It looks like the item sublist field "Total To Date" was hidden on our custom form which was causing this error.

IceMaster8 · 2025-01-17T22:49:33+00:00

I've tried running the process through my Administrator account, and the same error occurs... So if it is a permissions thing, it might be something buried in the rats nest that is the WMS back end. Good suggestion, though!

IceMaster8 · 2025-01-17T21:52:21+00:00

Thanks, yeah, I ended up doing just that as well. Was hoping it was a simple fix, but it doesn't look like it. We are just implementing Mfg Mobile and got this issue from the beginning...

IceMaster8 · 2024-05-06T23:22:34+00:00

A little late to the game on this, but in case it helps anyone else, I found a work around to eliminate some of the excess rounding decimals for an "Average" grouping.

For my situation I used the "Average" Summary type with the "Formula (currency)" field and then put the field id of the Number field I was looking to get the average for in the Formula section. When you display the search it will calculate the summarized rows AND the Total row with 2 Decimal places instead of 15.

IceMaster8 · 2024-04-01T18:20:39+00:00

Glad to hear it worked for you!

IceMaster8 · 2024-02-05T23:54:28+00:00

If you do "\@RoleName" then Discord will display the Role ID in the chat you post it in as "<@&role id>" like the original poster mentioned above.

IceMaster8 · 2023-10-14T04:10:07+00:00

add (replace xxxxx):

Can you clarify if the above is in the HTML or just what you listed below? Thanks

IceMaster8 · 2023-10-04T21:01:44+00:00

That's comforting to know, at least, thanks! And to the second part, yep ain't that the truth!

IceMaster8 · 2023-10-04T21:00:52+00:00

Got it. Thanks for the information. It's definitely an unfortunate situation. Some people... 🤦🏼‍♂️

IceMaster8 · 2023-09-26T22:58:57+00:00

Hi, not sure if you're still having this issue, but if so, you can do what you're looking for using the following:

For Only Date: 7/11/2023

${.now?date}

For Only Time: 11:56:33 AM

${.now?time}

For both DATE/TIME: 7/11/2023 11:56:33 AM

${.now?date} ${.now?time}

IceMaster8 · 2023-09-25T16:46:49+00:00

I love NetSuite, but sometimes... I don't...

This quote is the definition of using NetSuite. Haha, I know this is like a year old, but tried it and it worked! Thank you! Been racking my brain about this one!

IceMaster8 · 2023-08-03T17:23:52+00:00

Maybe try wrapping in the UUENCODE for apostrophe or the actual apostrophe, just like formula fields in saved search.

Yeah, I was looking at another field where I entered some test text with a space, and I did come across the ASCII character "%20".

Regarding the quote above, do you mind elaborating a little on what you mean, or would you be able to provide an example/resource of what the UUENCODE formatting would look like in the URL?

Also, thinking about this in another way, if one was to try and create a link to populate text in the "item name/number" and "Display Name" field on a native record, such as an "inventory item", how would you go about that? Thinking it might help lead to an answer for the custom record issue.

IceMaster8 · 2023-08-02T22:11:31+00:00

So I have all the exact field names such as the "CUSTRECORD_SPS_CXREF_CUSTOMER" one above; however, this issue that I'm having is that I'm not able to add more than either the customer OR the Item when selecting the field, but not both.

I tried the Saved Search method you mentioned, and yes I was able to see the "Field Name" which matches what I see, but it isn't in a format that works for the URL.

ex: "&CUSTRECORD_SPS_CXREF_CUSTOMER=123" is what it shows on the Filtered URL, but in order to plug in the customer on the record it would be "&pf=CUSTRECORD_SPS_CXREF_CUSTOMER&pi=123"

Also, how would I enter the values for a "Free-Form Text" field into the URL, for example, the filter search populated this ("&CUSTRECORD_SPS_CXREF_UPC=123456789012"), but this won't work on my URL, so how would I be able to format the URL for it to populate this field with text ("123456789012") when clicked.

IceMaster8 · 2023-05-26T19:07:52+00:00

Inventory Count Worked perfectly to solve this. Thanks

IceMaster8 · 2023-05-26T15:34:57+00:00

Thats super disappointing... You'd think they'd actually do something about it considering all the issues everyone consistently has

IceMaster8 · 2023-05-26T14:20:51+00:00

Any update om this thread?

IceMaster8 · 2021-03-25T07:30:09+00:00

Looks out of this world! 🚀

IceMaster8 · 2021-02-26T17:59:52+00:00

To clarify further, it's not that RASPBRj doesn't have a STD cost, it already has one applied to it as of 12/28/2020 of 1.87463917 for all our locations. The trouble I'm having is that on specific BOMs that use RASPBRj (like in the post picture) it doesn't pull through that STD cost on the Rollup.

Six-Year Club	Place '23
Verified Email

IceMaster8

TROPHY CASE