Thanks @Richard James Uri-Oracle. Just to double check, are you sure? I don't know how to visualize it in my head but I'm reading that the serial numbers are inside of the inventoryassignment sublist. Is inventoryassignment not within inventorydetail subrecrod? Or are those two separate things? Inventorydetail is on an…

Thanks @Patrick Fresnosa-Oracle , this lead me to the answer. After checking the Consolidated Exchange Rates, the values were completely out of sync. In the wrong direction entirely even. I think this is indeed what I had been checking every period and was forgetting this time. Lists > Accounting > Consolidated Exchange…

Your fine, no worries :)

Yes, if the item only exists in UK records and inventory then the reports in £ all appear correct.

Nevermind. A simple log tells me it's running. I was just expecting something to go wrong. Apparently nothing is wrong but nothing is being created. Will continue~

It's not just be the reports, sorry I should have expanded this earlier. To expand on my examples, here's a purchase order worth £60, but following that the related record for one of the items shows it on the purchase order as instead being worth £12 million

Thanks Niks, after following the instructions, I don't think there appears to be any costing calculation or errors being run on my Inv Valuation Report.

Still an ongoing issue to date. Thank you for this! Glad I found it.

Ah, I found this article. All solved~ https://community.oracle.com/netsuite/english/discussion/4474345/nsc-other-sublist-fields-center-link-missing It mentions that the centre is defected and the link is missing but the url can be entered directly into the browser instead.

Ah, that's very unfortunate to hear. I'm going to have to come up with my own solution to this… Thanks for the confirmation though! I don't think I'll bother writing a request for it. Nothing on there ever seems to get implemented. Even the most upvoted one is over a decade old. 😂

Hey @Jack Daryl Espiel-Oracle , sorry to dig up this post but I'm having a similar issue over here. Has the functionality changed in the last few years? The SuiteAnswer you mentioned here appears to no longer exist. Would really appreciate the steer. Cheers!

The ability to enter the correct serial numbers into the field manually may be the preferable solution, as it looks like our process is most likely going to require manual generation of Warranty Records going forward.

Oh I see this is for Standard Costing items and all of ours are Average Cost, never mind I suppose. >_< I might go back to my original plan of adjusting the items out and back in at the correct price. The issue with this is that removing inventory only seems to take the last purchase price which I cannot edit. So if I…

That seems to be it, thank you!

Yes, the non reference serial field does in fact accept hashtags and spaces, frustrating. -_-;;

Just noticed smth interesting perhaps… When creating a dataset for other purposes, the test records that were created via the Apps automatic process of creating a record from the invoice have their serial numbers in a field called Serial/Lot. WHere as the manual records I create are Reference Serial/Lot Same with the…

Script answer: /** * @NApiVersion 2.x * @NScriptType ClientScript * @NModuleScope SameAccount */define(['N/currentRecord', 'N/log'], function(currentRecord, log) { function fieldChanged(context) { var rec = context.currentRecord; var sublistName = context.sublistId; var sublistFieldName = context.fieldId; if (sublistName…

https://community.oracle.com/netsuite/english/discussion/comment/16858928#Comment_16858928 Thanks for that. Very helpful!

I wanted the same functionality you're looking for and have edited the code following your example. When saving the script file from your code, I would get Error: invalid field id, but it wasn't hinting at what that might have been. By running it through chat gpt, it fixed the popup error. However, it doesn't sound like…

I've not, sorry. It sounds correct, but I've realized I should really be changing all of my workflows to use roles and group emails instead of individuals and individual emails. So I've since abandoned searching for all the users and am restructuring my workflows entirely.

It does appear to be the browser. Need to consider if it's worth the effort of switching… Probably not for this alone, but I have had one or two other issues before in NetSuite due to the browser.

Ah, easy enough. Just wrong positioning of parentheses. Correction below.

It's the default. However, I don't think next approver field has anything to do with this and is currently disabled. The approval permissions are defined in the workflow by showing the approve and decline buttons to the correct users based on what state of the workflow the document is in. I have since worked around my…

I can see this working, although I won't be testing it as I already have the functionality I need working as a script. Thank you though! I'll certainly need this again.

Thanks Nicole. I'm still having unknown issues with trying the functions you suggested and it's sapping my energy a bit. I need to take a break from it, maybe test out getting the sublist subrecord data in another project and study the documentation a bit more first. Also in some way where I'm not having to create and…

All seems to be working. Though now I'm stuck trying to get some of the values I want from the record. I want to get the serial numbers of the items using getSublistSubrecord but can't seem to get it to work? The error message appears to suggest that the function just doesn't exist. org.mozilla.javascript.EcmaError:…

Progress, I'm now able to get the location id of the first line item. https://us.v-cdn.net/6032262/uploads/L4G9GTNBSCMD/assets-js.txt Now to go back to seeing if it'll send an email with the correct checker in place.

Still frustrates me when fields just don't do what they suggest they're supposed to. :') Would make this so much easier otherwise. Oh well.

I'm going to leave this topic open, incase anyone has an idea of if this is possible to do this via workflow/saved search. But I'm going to create a new thread for the scripting trouble I'm having over here if you wish to follow the progress.

Think I may need to script this instead. Here's the script I have so far, it has been initiating with some errors but now that I've solved those errors I'm getting no feedback from the system, it would appear to be working but I'm not getting any emails. May need to try and put some more debug lines in there to try and…