Dext3r Gold Medal

Internal ID appears to work. However, I'm not sure this is the intended solution as it means I am having to run an additional search to first grab the internal ID. It's certainly not very good for the universal credits. Ran a search first as shown below, used the internal id in place of the name when creating the IA.…

It turns out there is a limit of 10 Client Side scripts that are allowed to run at a time on a single record type. Currently there are 18, time to get the trimmers. 10 of these scripts however are locked, I would otherwise combine them but since I can't even look at the code I'm not sure what to do about this. I suppose I…

No, it is not checked Yes the correct colour list is selected. I know I'm seeing the correct list as it contains all of the colour options on that list, but not just colours specific to the item which is what I'm trying to achieve. All very useful information to learn, thank you. There's are some custom templates for the…

Blank, not initiating at all. All I'm doing is swapping the deployment between SO to PO or IR or IF and it's only the SO that it won't trigger on. I have un-deployed 5 scripts that were deployed to SOs and unfortunately has not made a change.

Hey Bry, sure thing~ 1. Here's the search for the 1 matrix item I have on the webstore currently. There is only the 1 matrix item and its 7 children each with 1 color option. These color options come from the matrix list for all of our other products with color options, but as shown above I've limited this on the item…

I've completed the first stage of creating all the replacement items. Now I need to plan for swapping over the inventory. I think the best approach would be to leave the open orders as they are and simply swap only the available inventory (i.e. not on open orders) for the new inventory using inventory adjustments. That…

ARghghgh, it appears to be caused by one of these two custom color fields. Since I had 3 fields of Color to try and map my matrix color option to, I was trying to do all 3 though the correct one to use seems to be Matrix - Color. Need to retest with testing external ids all over again, but thankfully found the issue. Now…

Oh for goodness sake, it's not working without the external IDs now either. I ALREADY DELETED THE CHILD RECORDS, does it think they still exist?!

If I map the children with the same external ID as the parent I get a different error: "Invalid parent reference key M21LM." Which again, not an issue when uploading without an external ID. Is it just not possible to map children with external IDs? What would I do if I want to update their name?

Scratch that, it was working because I had not got the external ID field mapped. The external ID is still the primary issue for the children, even when using external IDs like DefinatelyNeverUsedIDM21LMBK.

Perhaps the External IDs were too simple? I double checked the existance of the ones I was attempting to upload and found no duplicates. But upon extending the external ID to be more complex it appears to be working now with all the chained files. Now onto the next issues, perhaps in another thread if I can't solve them…

Thanks for the suggestion Sho, I'm afraid I've also tried changing and removing the external ID's, but I'll give it another go. It might be one of the chained files I'm trying to upload (Bins, Locations, Suppliers and Pricing). I'm going to start my day by trying just the line item file upload and then report back.

All very helpful considerations. Thank you for the detailed response, Trixie~ The discussion is still open if other people would like to offer suggestions. I will accept multiple answers 🤗

✨ Thank you! ✨

I'm aware, thank you. I'm trying to consider what to take into account for achieving this process myself.

The items I felt I was missing on the GL impact were received at 0 value, so there's no reason for them to show on the GL impact. I think everything is working as intended.

No sorry, it did not answer my question. Though I think I have worded my question poorly to begin with. I'll come back with an answer if I have one.

Thanks for that! The reason for modifying the netbook value would be when I merge two assets with the same lot number and depreciation start date, but I think instead I'm just going to keep them separate if there is any depreciation that has started as it does indeed seem too complicated to update netbook value via…

They're 2 different items. Never mind

Ah, that's a useful reminder. I always forget what the limit is. Also 10 on a single record?! Goodness you've done a lot of work~

Great answer~

I agree with Amanda, it's all up to you and your group to review how it will affect business performance and processes and then test, test and test in your sandbox. There is no clear guide as each business and the way they use their apps are totally unique.

Searches, in my experience, are usually written like so. var mySearch = search.create({ type: search.Type.CUSTOMER, columns: ['entityid', 'firstname', 'lastname', 'salesrep'], filters: ['entityid', 'contains', 'Adam'] }); So, simply putting type: 'csvimporterror' sounds wrong to me. Perhaps you need to import…

It certainly should be a supported type. INVENTORY_BALANCE Only suggestion I could offer without seeing the script and saved search: Ensure the correct internal ID Ensure that the user running the script has permission to access the saved search. The error may arise if your role or user doesn’t have access to saved…

Start by contacting your account manager, pretty sure these are all paid features and you'll need to get a license for them through your account manager first.

I can't see anything wrong with your script. More likely it's an issue with the script record or deployment record. Make sure it's deployed and testing and that it's deployed against the correct record. As a possible outlier, I've sometimes run into the issue of not naming my script files with .js i.e. 'script_file' won't…

Ah, right you are. Created the form and set the print template of that form to the PDF template. Cheers!

Thanks for the clarification Amanda~ From support: "Upon checking, your NetSuite Package has recently renewed and the Training On Demand pass that is bundled with your license suite hasn’t been assigned to a specific user yet. Your previous access has already expired; hence, you no longer have access to it." Asked them to…

Yes, certain details could add multiple lines to the search, but in this case I'm referring specifically to that the only subsidiary data on inventory searches is from the item record, which isn't useful because it doesn't tell me that the inventory is in that subsidiary, but that the subsidiary has access to that item…

Ah, yea I'm not sure sorry. I don't have a lot of experience using premade searches in scripts, I would prefer to make my own within the script like so. (Note: This exact script won't work as I have SALES_ORDER as the search type. I wasn't sure what search type to use that has both the item type and its sales details.) But…