Mi contenido
Nominate Your Peers for NetSuite Support Community's Choice of the Quarter! Submit your nomination today.
Intelligent Payment Automation version 1.0.3 is now available in the SuiteApp Marketplace. The SuiteApp, powered by BILL, lets you automate payments, manage vendor details, and bank account information within NetSuite. Learn more
No Limits. Just possibilities.
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Celebrate Your 2025 Community Recap & Achievements!
We’re excited to announce that the 2025 Community Recap is now available! This special recap highlights the amazing contributions and achievements of our members over the year and celebrates the collective success of our community.
Check your personalized recap to see the impact you made in 2025 and how your efforts helped shape our community’s growth and success.
View Your 2025 Community Recap
Thank you to everyone for your passion, collaboration, and support. Here’s to building an even stronger community together in the year ahead!
We’re excited to announce that the 2025 Community Recap is now available! This special recap highlights the amazing contributions and achievements of our members over the year and celebrates the collective success of our community.
Check your personalized recap to see the impact you made in 2025 and how your efforts helped shape our community’s growth and success.
View Your 2025 Community Recap
Thank you to everyone for your passion, collaboration, and support. Here’s to building an even stronger community together in the year ahead!
Comentarios
-
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.
-
https://community.oracle.com/netsuite/english/discussion/comment/16877557#Comment_16877557 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~ https://community.oracle.com/netsuite/english/discussion/comment/16871918#Comment_16871918
-
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'] });…
-
It certainly should be a supported type. INVENTORY_BALANCE https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_4483165708.html#bridgehead_4483165790 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…
-
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…
-
https://community.oracle.com/netsuite/english/discussion/comment/16871553#Comment_16871553 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…
-
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…
-
I would be very wary of using summaries for the search on your script. It means it's grouping sets of data together that you or at least I certainly can't visualize in my head what it might look like on the screen. If for example I was grouping by location for a search of items, I'd get all my items grouped onto one line,…
-
It looks like you're using your customsearch_avg_daily_sales in the script which is the search you shared an image of first, is that right? If so, I don't see any field for the item type on that search. Can you share your logs please? What value is coming out of the log for itemType?
-
No, there were many more. It was just the first one at the new location that the upload was getting stuck on. Having split the uploads per location, all items uploaded just fine.
-
I often find a good way to start to figure out what I might be missing is to copy the url of the page I want, then try to load it on one of the restricted accounts. Would this be of any help?
-
Yep, needed to have separate from and to locations for each transaction. So when looking for a particular serial number at a particular location, it was likely still using or looking in the first location where the serial number is not at.
-
Oh.. I'm gonna guess it's because it doesn't accept multiple locations and I have to do those as separate uploads. One sec..
-
Thanks @Tigran Shahnazaryan , it's happening on multiple types of items for multiple users with varying set ups as to where the items are coming from, which account it's going to. I think I'll open a support ticket to see if someone can investigate it yea, thanks for the suggestion. I'll come back with a solution later if…
-
Mm, a good answer @Nicole Mendoza-Oracle . I'm sure I could utilize this in my other scripts. Thank you for the suggestion~