KMcC7808 Red Ribbon

Unfortunately, I found that there is no option for making a group price "custom" under a customer. Price levels apply to all customers. We solved this by adjusting Item Pricing (setting the price of individual items, not groups). I believe this was ultimately the NetSuite solution, as proposed by their Professional…

Thank you Mikko. I appreciate the help. Trust me, I use those two publications all the time. I was hopeful there was somebody out there that had solved this for me. But now I'm growing less confident that that is true. I think the problem is not with the SuiteScript 2.0 download. I believe the problem is with VSCode's…

I'm replying to my own question to add additional info. I went back and rewrote my React example using native NetSuite code. In fact, it was much simpler and more easily understood/maintained. This example also completes the demonstration which pulls results from the SuiteCommerce SOLR search API. If you haven't thought…

Robert, Thanks for following up. I get it... when you remind me I've gotten numerous notifications and didn't read them. Acknowledged. I hope you can appreciate that when NetSuite buries things like that (hey... we're turning off our proxy) in general updates (see your two examples), I'm not going to see it. I have enough…

So here is my latest research. There is a field on an item record called "Last Quantity Available Change." It is a date/time field. I've tried a couple of saved searches to see if I could narrow items to just those that have changed recently. I was able to limit my list to just those that have changed within hours or…

Thank you for this post. I'm up against the same problem. My issue is including a facet in our SCA website that filters to include only items we have in stock. We've found in our existing Magento website that this feature has brought us quite a bit of business. Buyers are trying to avoid waiting on lead times. They want it…

Thank you for responding. I really appreciate those who are watching the forum posts and helping others. My blog post is actually not a question but a tutorial on how to navigate transaction statuses in SuiteScript 1.0. Again, thanks!

Josh, sounds like you are really digging into NetSuite. Excellent! It is very customizable, even for non-developers. Here's some reading for you. Hopefully it helps.

This works on the client side. I actually tested this time before publishing. And it's pretty fast. var filters = new Array(); filters[0] = new nlobjSearchFilter('name', null, 'is', 'fullCalendar.min.js'); var columns = new Array(); columns[0] = new nlobjSearchColumn('internalid'); columns[1] = new…

Thanks again for the help. I'm going to call this the final solution. // This library refactors all references to URLs. // It works in both production and sandbox as long as the files have the same name. // It loads files using jQuery.get(lib_urls.file_url()) in the browser. // It does not use the file path to locate a…

Thanks for continuing to hang in there with me. I'm augmenting a library with that dynamically builds HTML which ultimately gets sent to a browser. I call my libraries from both client and server sides. Sometimes they are called via AJAX and sometimes they are called from Servlets and RESTlets. They also get called from…

Thank you. Thank you! You beat me by about 10 seconds. I was just testing this when you responded. This works. And to my surprise, the path actually worked too, not just the ID. var url = nlapiLookupField('file', fileUNCpath, 'url'); nlapiLogExecution('DEBUG', 'url', url);

And now... with a little egg on my face... I report that although the method I described works and returns a result, it returns the wrong file's URL. nlapiLookupField('file', 'SuiteScripts/myfile.js', 'url') nlapiLookupField('file', 'myfilenumber', 'url') These do not return the same thing.

Here is my solution which downloads items under a full commerce category path into a local database. The next step, which is not shown here, is feeding a treeview control that lets our SCA website admin see all products in all category paths. Although the SMT tools in SCA are helpful, they are not robust enough for…

I didn't notice this post until after I'd just posted basically the same question. I'm in agreement with mosgath, SuiteTalk cannot reference CommerceCategory records. They are not exposed. With regard to your question about the WSDL API, the WSDL is what SuiteTalk applications bind to when connecting to NetSuite's web…

Here's the answer...

This one rang a bell with me. When I connect with TBA and forget to set my service.tokenPassport, or it is incorrectly coded, the error I get back is "Your connection has timed out." Not very helpful!

I had to address the "On Credit Hold Issue" when importing sales orders into NetSuite, and my company decided not to use the "Auto" setting. See SuiteAnswer #9627. We now set it on or off manually. Our issue wasn't creating invoices using SuiteTalk. We create SalesOrders programmatically and then manually process them. I…

See if this helps. If not, let me know.

First, thank you Lewalsh11741 for the feedback. Much appreciated. Second, I gave up on this and submitted a case to NetSuite Support. They basically told me they could not help me. So here's my email response to their rejection letter. Here’s where I’m at with this project. I go to SuiteWorld 2018, where your experts are…

Thank you for including this link. Very helpful. Your link is where you can download the NSClientERP code I was referring to prior to coding up my example. You are right, it gets you most of the way there. I am hopeful my example gets you 100% of the way there, if you add the correct access settings to your TBA role (very…

Just so you'll know. I went back to basics. I thought about my post and how I was looking for a simple example. I opened the NSClientERP solution, part of NetSuite's SuiteTalk examples in C#, which is where I started as a SuiteTalk developer. It actually has an example of how to do TBA authentication. I'm coding up my…

Since department is a very short list and rarely changes, I'd recommend hard-coding the translation. For things like custom lists, here is some sample code. public static Dictionary<string, long> GetCustomListValues(NetSuiteService service, string custom_list_name) { Dictionary<string, long> results = new…

Here is a better thread to research SuiteTalk problems accessing CommerceCategories.

OK... Here's the simple example. NetSuite, I'd recommend making this very easy to find. Before using this code, start by reading SuiteAnswer #41898. Make sure you assign "Login Using Access Tokens" and "Web Services" to the Token Based Authentication Role you create. Sorry about the formatting. This will clean up nicely…

I thought this was a great question. I hope somebody answers you. I've looked into this and I don't see a way to get column headers. When you reference a search using SuiteTalk, it appears you need to know the scriptid and the columns you wish to include. At least that has been my experience.

Thanks for mentioning this great resource. Yes, I've certainly checked this out. This is where I started when I began learning SuiteTalk. If I've missed something please let me know. However, I don't see any examples of where you pull a list of column names and data types at run time.