プロフィール
コメント
-
Mm, alrighty. Even if I can't edit the disposal script, I am able to download it and inspect it, but yea, no way of triggering it from outside of the asset disposal function. For now though I think my solution is going to be to create a record that stores all of the FAM Asset records that will need to be disposed of at the…
-
Ok, a simple but hard to find fix. I needed to use selectLine instead of selectNewLine Reference #1 Suite Answer 81448 "Using selectNewLine method on a newly created Inventory Detail subrecord sublist returns an error "You still need to reconfigure the inventory detail record after changing the quantity" when the Inventory…
-
Mm, no. I've set up a new test IR with both lot numbered, serialized and inventory items and am having the original issue again which is getting stuck on the lot numbered items. You'll see from the logs that it goes through the first inventory item fine, then tries to process the lot numbered item with 2 lot numbers and…
-
It seems to work if I remove the 'inventoryDetail.commitLine ({ sublistId: 'inventoryassignment' });' lines, but these seem pretty necessary for if I were handling serialized items or multiple lots numbers for it to be able to move from one line to the next, no?
-
Yes, exactly that. I would be able to create it myself, but I don't actually know all the functions that the asset disposal form performs in order to mimic it. So I was hoping it might be possible to just script the filling out and submission of the disposal form.
-
Ahh, that's frustrating. Even more so that the error message doesn't match what's perhaps really the cause of the issue then.
-
Oh 53080 is the vendor! My bad. Why would it care about the relationship between the account to the vendor, vendor records don't hold account details… Does the vendor record have the correct subsidiary? The same as the subsidiary using the account?
-
Usually for me this message means that the Account is not available for the subsidiary you are using on the CSV. Are you using multiple subsidiaries? My first suggestion would be to check the Account that it's assigned to the correct subsidiary.
-
I may be off the mark again with what you're asking for. But on a saved search you should be able to add Amount and Amount (Foreign Currency) to the results. At least, this works for how I use it. Hope that's of help.
-
In the file cabinet if you edit a folder, there are a number of restrictions by group/subsidiary/department to choose from. Perhaps it would could work for you to utilize this and add only the users that you want to have access to the SuiteScripts folder to a particular department or group, then restrict the folder to that…
-
If you can do it in a certain role and it's a case of permissions, is the checkbox 'Run Unrestricted' in the Results subtab of any help?
-
Seems that BoM Revisions just don't provide logging. :shrug: Created a simple workflow that sets the memo to 'test' when only I view it and got the same results, workflow is functioning but there are no logs on the record.
-
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.