Thank you for the information @Patrick Fresnosa-Oracle . It does seem much more than I need. I've created a script this morning instead to handle the update of Tax Codes myself. Since it only needs to happen on Sales Orders between particular subsidiaries, it wasn't much work to fix.…

Mm, looking at the xml of a workorder record and also the schema browser, most things all seem to point at it being 'item' and no other obvious option, but certainly through a join. Is there a particular way you need to access it since it's in the item sublist? Are you able to query the tables like so? Inspect the…

As another option, would this perhaps have worked? - var itemSubclassText = itemSubclassData[0]['text'];

Is it perhaps because the order is pending approval and thus certain fields are locked? If you reject the order, can you change the approver before submitting it again? You likely would need to edit the workflow you're using to change this. Or build your own if the workflow is locked.

Yep, above comment was indeed the issue. 'anyof' only works for searching fields with certain value types, at least, not text which in my case is the serial number field I'm searching for ('custrecord_assetserialno'). I modified the script to add each serial number by searching 'is' for each serial number and separating…

I found this thread that suggests I cannot use 'anyof' for searching text values. So perhaps I need to think of a way to add each of the results as individual filters. Will continue investigating this approach for now.

Not quite @Patrick Fresnosa-Oracle , more like I want the Tax Code on the line items of Sales Orders and Purchase Orders to be preset by the Subsidiary and Customer/Vendor combination. So when adding a new line item, the tax code will default to the appropriate value and this should also trigger when creating Sales Orders…

Thanks @Richard James Uri-Oracle Attached is the full script, line 222 is the line "var assetResults = assetSearch.run().getRange({ start: 0, end: 100 });" (File removed) Nothing out of the ordinary around the error in the logs. But at the moment it's a bit verbose as it's logging all of the arrays that are being created…

Oh well that's just silly… I'll have to try and get all the admins block it on the receiving end. Thanks for the help Nicole~

Actually, it does work when the event type is CREATE, so this works just fine for my goal with this script here. Simply added the check to my script for if context.type === context.UserEventType.CREATE

It would appear that 'You cannot modify fields on existing records in beforeLoad'.submitFields can be used but not for sublist values. So I don't have a way to achieve this with scripting I think. Unless I do afterSubmit, but I didn't really want to have to store the values, it's unnecessary but oh well.…

It's a locked script, so I can't uncheck that. Also, I don't think what it's doing is in error, it's a notification that's written into the scripts code, so I'm not certain that would work anyway.

Of course, yea we don't make profit off of it. It's just to be able to manage the shipping costs. When we sell them back, that's typically when we are transferring them between subsidiaries but want to manage the transactions in GBP, so rather than going from Nigeria to Liberia, the stock would in NetSuite go from Nigeria…

Mm, I understand your curiosity as I think you're right that in most cases it would be correct to leave in on the AP/AR. One of my team mates can explain it better than I: "we have a few issues if having these costs in PnL instead of part of the material cost (adding onto the part material costs via landed cost) 1. the…

Mm, figures. I'll go leave my vote. Thank you~!

No @Angela Bayliss we're not using intercompany transfer orders but instead paired intercompany transactions. I'm able to add shipping costs on the SO but they don't appear to be reflected at all on the PO, the PO and IR don't even have numerical fields to fill in the value of any shipping costs.

No, no change. Again, this is working on many other record types, just specifically not the new location record. Here's the script log, showing that it's preventing me from saving the record. Just not showing a dialogue on my side. The location record cannot be saved, but no dialogue appears to show the user why it's not…

Unfortunate. Another NetSuite let down. Thanks for the suggestion, I do think that would work but we'll try marking it down as an expense on the PO side.

I'll have to remember that one, I'm sure I'll run into it many more times in the future. Thanks Wee Ming.

No change I'm afiraid. It's deployed to all records as there isn't an option for location as a record to deploy to. But I can tell that it functions on the location record, as it does correctly prevent me from saving the record and displays the logs on the script record. Just that the message doesn't appear on the new…

https://community.oracle.com/netsuite/english/discussion/comment/16865508#Comment_16865508 That doesn't seem to be it, sorry. Although a good suggestion, it appears to be working without that change. However, it's working on most other forms and not the new location form. So it appears to be an issue with the page/form…

A suitable fix. Thanks @Wee Ming ~!

I think I have it. By adding &xml=t to the url I was able to inspect the item receipt further and found the following fields in existence. One of these likely works, more than likely the amount one.

Ah ok, so it will fix itself at the next quarter. Though I am still curious if you know what might have caused this to begin with?

One of my users just got this notification emailed to them. This is me looking at the script in question that it warned them on the error. I'm not sure what caused it to trigger, 12 min after I ran the script you suggested that fixed my issue at 4:17. Should I be concerned?

https://community.oracle.com/netsuite/english/discussion/comment/16864160#Comment_16864160 This solved the original issue, thanks! Where did you find the answer and what is it that the script actually does? Based on the execution log it 'migrates assets with new and depreciating status' to the depreciation schedule? I…

OK, no I don't know if this Retrieve Asset Vales script works. It's throwing the same error on all of my other assets that have been generated normally and don't have the transfer location issue. Here's FAM000736 as an example. No issue transferring.

Oh, actually it didn't succeed. It completed, but there was a map error(?). map error FAM000750 {"type":"error.SuiteScriptError","name":"INVALID_ASSET_ID_FORMAT","message":"The specified Asset ID either does not exist or has an invalid format.","id":null,"stack":["Error"," at Object.create (/SuiteBundles/Bundle…

https://community.oracle.com/netsuite/english/discussion/comment/16864157#Comment_16864157 Attempted that just as you suggested it, haha. No success I'm afraid. I don't think the error has changed at all. {"type":"error.SuiteScriptError","name":"SSS_MISSING_REQD_ARGUMENT","message":"load: Missing a required argument:…

At this point, I'm fairly certain it's the last purchase price.