Dext3r Gold Medal

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~ 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…

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

That did the trick, excellent! The fields were indeed not checked to show on the form. I wouldn't have guessed that was the case since they were showing anyway, how odd. Thank you both for your help with this, the accounting team will be delighted to have this working. I am still trying to populate the list for selecting…

Both the Standard and the Custom reports start with it unchecked. It's driven (I think only) from my personal settings, as Patrick instructed me to do, where I have it set to be unchecked as default. Which again sounds backwards but it's certainly what's allowing me to see the three fields in the CSV mapping for the…

Yes, but only after I check the 'Use Multi Currency' box. We use our custom MOPO Expense Report. The CSV also uses the same form. Still only seeing ***currency in mapping. However, if I change the mapping to use the default form I do see ***currency ***exchangerate and ***foreignamount. Unfortunately, there are some custom…

Mm, I cleared cache and tried again. No luck unfortunately. Still only seeing ***currency

No worries! I'm still investigating this on my end as the hierarchy of where the price comes from is still unclear. Like first it takes the purchase price, then the purchase price but only if it's higher on the same day/hour if it's higher, then the purchase price whether higher or lower after updating, then I think it's…