JohnCCole

I know I can set the time to live, but there are things I may want to cache that stick around in public scope of my account for longer then the execution of a single script, but if a rare user action invalidates the cache I may want to remove/refresh a single item in a given cache or remove all cached items in a given…

in Flushing All Cache Keys Comment by JohnCCole Feb 7, 2017 3:26PM

I would just like to update the community on some of my findings. I actually filed a Case with NetSuite about this. In the Mandate document provided by Cybersource they describe a hybrid solution where you can set the default authorization type to be used for Mastercard, but then API requests (which would be NetSuite)…

in MasterCard Pre & Final Authorization Mandate Notification Comment by JohnCCole Dec 22, 2016 2:09PM

Carla, What your saying about the billing and the order amounts not being the same as the authorization makes sense to me. So when an order edit is made that causes an increase in authorization amount do you log into your payment gateway and cancel the authorization for the original amount. When dealing with credit card…

in Credit Card Processing Comment by JohnCCole Jun 18, 2014 3:51PM

Thanks guys playing with the replenishment enables and disables as described.

in Unable to edit item location details Comment by JohnCCole Jul 30, 2015 11:33AM

If the issue was just that the 3rd Party Can't request an image url without a file extension I wonder how the 3rd part would handle a 301 redirect from another server to NetSuite. So the url would be built from the internal id of the file and the type. someexternalserver.com/images/123456.jpg?url=urltonetsuitefilecabinet.…

in Full path to images with a file extension Comment by JohnCCole Aug 16, 2018 10:41AM

In a saved search the field is Memo for the line item description and Memo (Main) for the the header level (checkbox in your first image)

in How to search for descriptions (on the transaction level)? Comment by JohnCCole Aug 13, 2018 1:18PM

Thank-you leacelosacolumna and brandon.haiflich for your suggestions. I had thought of using search of saved searches but I want the data to be categorized better. I don't want a saved search producing a single resultset of 100+ searches and then my users having to sort through the list of 100 to find the one they want. If…

in Managing Saved Searches Comment by JohnCCole Sep 19, 2018 9:59AM

This sounds like a customization to me. You may have the tracking number on the bill, item fulfillment, and sales order, but I don't think there's a link from an AP Bill to an item fulfillment or a sales order so a Join query isn't possible, I think you would have to create a customization for this.

in Find transactions based on custom line item field in bill Comment by JohnCCole Jun 6, 2018 3:39PM

Pretty confident Eric is right on this one. I needed to have the selling unit price on the item fulfillment for purpose of declaring value on commercial invoices for international shipments, so I added a custom column field.

in Fulfillment Search to retrieve the Line Item's Unit Selling Price on Fulfillment line Comment by JohnCCole Sep 1, 2017 3:34PM

Oh, and another interesting bit... When viewing the XML of the Fulfillment, there are 2 fields for each item the DO link back. <orderdoc>345989</orderdoc> <orderline>2</orderline> Orderdoc is the internal ID of the Sales Order Orderline is the LineID of the Sales Order Yes there is map and this probably what Eric is…

in Fulfillment Search to retrieve the Line Item's Unit Selling Price on Fulfillment line Comment by JohnCCole Sep 1, 2017 4:06PM

Sorry didn't see the price was a formula field. Please disregard the below. If there are no formula, sum, group fields in the search results could you not create an Advanced PDF Template? In the advance PDF template you could track the previous company with a variable so you could compare it against the current row, and if…

in Non-Repetition of Vendor Name if with multiple transaction Comment by JohnCCole Aug 29, 2017 12:28PM

JohnCCole , I tried to create a custom transaction column field, store data was off but for the life of me I could not find a field to source from (Item Rate and Amount didn't work). To make matters worse, when I had it as Store Data False, could not make it show on fulfillment form even though it was checked to be…

in Fulfillment Search to retrieve the Line Item's Unit Selling Price on Fulfillment line Comment by JohnCCole Sep 1, 2017 4:08PM

Does the role with issue have the Lists permission Perform Search

in Custom Record Transaction List Permission Comment by JohnCCole Jul 19, 2018 10:46AM

I did something similar for Inventory Adjustments. We wanted to have an approval process, so I created a custom inventory adjustment that had a sublist just like the NetSuite out of the box adjustment record. When the custom record is approved an actual posting inventory adjustment gets created. So it can be done but…

in custom record with expense and item sublist like purchase order record Comment by JohnCCole Jan 31, 2018 1:55PM

So I get the general idea. I will point out one thing the internalid of the file is always consistent it's the other parameters in the URL that differ from sandbox and production. I got sick of this awhile ago and wrote a Suitelet that takes a file id returns the content to the requester. The Suitelet deployment URL after…

in How to get URL of a file without loading the contents Comment by JohnCCole Oct 30, 2018 1:25PM

You would use nlapiLoadSearch and on the returned nlobjSearchObject you would use the method setIsPublic followed with a call to saveSearch on the nlobjSearchObject to save the change

in Is there a way to load a saved search record (not the results but the record itself) using nlapiSear Comment by JohnCCole Sep 25, 2018 2:03PM

If you had the file id you could use nlapiLookupField (SS 1.0) or search.lookupFields (SS 2.0) to just get the URL. How are you building a UNC type path for a file? Could you pass the file id instead to your method?

in How to get URL of a file without loading the contents Comment by JohnCCole Oct 30, 2018 11:07AM

Darn... what exactly are you trying to do. You want the URL on the client side, are you trying to dynamically load a script file?

in How to get URL of a file without loading the contents Comment by JohnCCole Oct 30, 2018 12:07PM

david.lyle not a problem happy to help. Sadly we don't get much on the search object as far as what we can control with suitescript.

in Is there a way to load a saved search record (not the results but the record itself) using nlapiSear Comment by JohnCCole Sep 25, 2018 6:20PM

Excellent didn't know that about the path in relation to LookUpField so that's good to know.

in How to get URL of a file without loading the contents Comment by JohnCCole Oct 30, 2018 11:14AM

Not sure about the workflow route but in a script you can definitely do so by setting the orderstatus field to B.

in Script to Change Work Order Status From Planned to Released Comment by JohnCCole May 24, 2018 11:38AM

Mohandas how is the calculateShippingButton created do you know for sure it's actually hitting the getUPSRate function. In your field change I assume with this line you are trying to call getUPSRate but why not just call the method. What you're actually doing is setting the onlick attributing not simulating a click. [CODE]…

in problem with client script Comment by JohnCCole May 29, 2018 10:33AM

Check if the result array is null and accessing rawValues I don't think is possible server side. Also consider using mainline as a filter or you're going to get several rows in the array for the same transaction..unless of-course that's what you want. if(searchResult == null){ response.write('No results<br/>'); else{…

in Why is my nlapiSearchRecord's search results not displaying in my Suitelet? Comment by JohnCCole May 17, 2018 11:45AM

I don't know about the merge function but nlapiSendEmail has a parameter for attaching to records. For example you call should be nlapiSendEmail(fromID, email, emailSubject, emailBody,null,null,{transaction:'internalidofinvoice',entity:'internalidofcustomer'});

in Need help attaching email from Scheduled Script to transaction or customer record. Comment by JohnCCole Feb 16, 2018 12:25PM

Not sure if it's a un-intended feature but it appears if you write the response with write method instead of writePage it will work. If you use an NSForm object and then call writePage it appears an actual file field has to be added to the form (not raw html) for things to work, but then you're back to not being able to…

in External Suitelet <input type=file> instead of form.addField Comment by JohnCCole Feb 5, 2018 5:03PM

I've done something like what your asking. I have a node.js application uploading a file to a suitelet. As long as the enctype on the form is multipart/form-data, and the name and id of the form file field is 'file', I can access that file in the suitelet using getFile.

in External Suitelet <input type=file> instead of form.addField Comment by JohnCCole Jan 31, 2018 1:42PM

Not a problem. As long as you don't need the SuiteScript API on the client side it does the trick.

in External Suitelet <input type=file> instead of form.addField Comment by JohnCCole Feb 9, 2018 10:26AM

Currently the Restlet is 1.0. I did take the 2.0 course at SuiteWorld I guess this is a good time to try and write first my 2.0 script.

in Restlet File Download Comment by JohnCCole May 26, 2016 9:43AM

I already have a Suitelet accessed with NLAUTH headers, but I wanted to switch to Restlet so I can use TBA. All of my integration end points have been switched over to Restlets using TBA. The password change every 90 days I'm trying to eliminate, and I don't want the Suitelet available with no login. My use case is having…

in Restlet File Download Comment by JohnCCole Jun 1, 2016 8:23AM

oauth_consumer_key, is the the public consumer key not the secret, and not the application id oauth_token, is the public token not the secret and not the token id you will need the secret consumer key and token secret when generating your signature but they are not included in authorization header.

in Please clarify Helps confusing information on TBA/OAuth for RESTlets Comment by JohnCCole Feb 24, 2016 9:49PM

JohnCCole Green Ribbon

Comments