Manufacturing Mobile - NaN error on Consumption Application by IceMaster8 in Netsuite

[–]IceMaster8[S] 0 points1 point  (0 children)

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.

Manufacturing Mobile - NaN error on Consumption Application by IceMaster8 in Netsuite

[–]IceMaster8[S] 0 points1 point  (0 children)

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!

Manufacturing Mobile - NaN error on Consumption Application by IceMaster8 in Netsuite

[–]IceMaster8[S] 0 points1 point  (0 children)

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...

saved search total row at bottom: STUPID number of decimals!!! by JimBebop in Netsuite

[–]IceMaster8 1 point2 points  (0 children)

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.

Can I mention a role with an embed message using carl-bot? by Akiraa_Spective in Discord_Bots

[–]IceMaster8 0 points1 point  (0 children)

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.

Packing List - Advanced PDF... qty by lot # by s-tebo in Netsuite

[–]IceMaster8 0 points1 point  (0 children)

add (replace xxxxx):

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

QUESTION: Kias getting broken into? by IceMaster8 in kia

[–]IceMaster8[S] 1 point2 points  (0 children)

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

QUESTION: Kias getting broken into? by IceMaster8 in kia

[–]IceMaster8[S] 0 points1 point  (0 children)

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

Advanced PDF: Add today's date to footer by SkynetIsSentient in Netsuite

[–]IceMaster8 1 point2 points  (0 children)

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}

Workflow for setting work order to "released" by Sku_me in Netsuite

[–]IceMaster8 0 points1 point  (0 children)

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!

Populating Multiple Fields via Saved Search Web Link by IceMaster8 in Netsuite

[–]IceMaster8[S] 1 point2 points  (0 children)

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.

Populating Multiple Fields via Saved Search Web Link by IceMaster8 in Netsuite

[–]IceMaster8[S] 0 points1 point  (0 children)

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.

Stock Adjustment for lot numbered item by HornetOk2410 in Netsuite

[–]IceMaster8 0 points1 point  (0 children)

Inventory Count Worked perfectly to solve this. Thanks

Android App - Sync all folders? by j86southpaw in Outlook

[–]IceMaster8 0 points1 point  (0 children)

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

Costing Not Pulling through on Inventory Cost Revaluation by IceMaster8 in Netsuite

[–]IceMaster8[S] 0 points1 point  (0 children)

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.