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…

Thanks @Patrick Fresnosa-Oracle , one step closer but I can only get the ***currency to appear. I did log out and in after changing my preferences but still only seeing the one field. Hey @Angela Bayliss, for the billing subsidiary I worded that wrong sorry, but I appreciate the direction. I couldn't find any reading on…

So I think it was a mistake on my end, sorry! One of the lines had the wrong vendor and as a result the import was trying to upload multiple lines to the same PO but for the wrong vendor. I could have sworn the other POs were also not uploading correctly but I don't appear to have taken record of it, so maybe I'm…

Not sure. Looks like it might have smth to do with what account it's going against. Or perhaps if it's a debit. But entity does return vendors for me where it can. By adding a filter to only return Transactions that contain 'Bill' I'm not getting any empty entity fields. But perhaps it's due to the accounts you're looking…

No not at all, I assumed if I set the vendor price that it would do it there and then. So I'll set it to every hour and try the method I displayed earlier again by setting the MPUK Vendor -> MPSL Subsidiary price. Is that right? I think it's close to the point where I need to consider if using inventory adjustments would…

Sure, here you go.

Found this. It works but also really doesn't. NetSuite Applications Suite - Unbuilding Assemblies and Purchased Assembly Costing (oracle.com) NetSuite Applications Suite - Entering an Inventory Adjustment Before the Unbuild (oracle.com) This will affect the average cost of the item, which I can confirm is driving the price…

I've made progress on the PO by also setting a GBP value, since the PO is in GBP. I wonder if this correlates to the unbuild as well... Nope, it did not change anything on the unbuild.

Unless there's something wrong with my vendor setup? As it looks like the vendor price isn't being suggested on POs either based on Vendor. If I set the items global purchase price, that does work.

Hey @Angela Bayliss I've been having some trouble with this. The cost of the items coming out appears to be derived from the average cost to the item per location above all else. I've been trying to change the price via the location, vendor or global and it appears to be locked or I can't figure out how to overwrite the…

Yea, I understand that some of the transactions in my example have been filled where there is a purchase price on the item record. But what I'm asking is can I not set my own price or overwrite the purchase price for the item during the upload? Otherwise I would first have to do an item upload with the correct pricing and…

I think further to this however, my issue is that the assembly items are built in our subsidiary MPUK, they're then sold as fully assembled items to MPSL, but MPSL is where they become fixed assets. Because of this, it's not recognizing the item as a culmination of components but just as one item. To achieve what you have,…

I think it answers it, I need to do some more testing. Thank you for the detailed guide. If I can't list the components, can I have them each on different asset accounts?

I'm going to build my own last purchase price field that finds the value specifically from MPCN transactions. Transaction Saved Search > List Transactions for the basis of Last Purchased Price (custhelp.com)