Bill Quinn

I seem to be spending hours and hours reconciling every week/month!... PayPal, ... Vicki, PayPal is a challenge for the following reasons: 1) You can receive money via PayPal standard before the item is shipped so PayPal online will show more money than is in the PayPal cash account. (ie: you have the money but no cash…

in Reconciliation nightmare! Comment by Bill Quinn May 21, 2010 7:17AM

khultquist Great idea but it does not solve the issue. The function parser is evaluating every field before doing the case statement so the nest does not solve the issue. pcutler I think you are on the right track, making a script/workflow that would set this field rather than doing a formula without saving the value.

in Suppress ERROR: Field 'cleared' Not Found Comment by Bill Quinn Oct 9, 2017 9:50PM

@khultquist - thank you for your post about pculter. I did not understand the solution the first time I read it. @pcutler Creating the two fields worked. @MikeBucklaew Thank you for testing it, the workflow works as well. The is the solution I used: custbody_cleared_hidden Type = Free-Form Text Applies to Purchase and…

in Suppress ERROR: Field 'cleared' Not Found Comment by Bill Quinn Oct 11, 2017 3:19PM

MikeBucklaew I will test but I am thinking Workflow may have issues as well because of the inability to trap the error. In script we can try/catch but I am not certain workflow can handle. We shall see...

in Suppress ERROR: Field 'cleared' Not Found Comment by Bill Quinn Oct 10, 2017 9:28AM

k_dunc I never thanked you. Yes, you are correct this is handled via preferences.

in Item sublist default behavior - Sales Orders in particular Comment by Bill Quinn Feb 23, 2017 9:50AM

@k_dun

in Item sublist default behavior - Sales Orders in particular Comment by Bill Quinn Feb 23, 2017 9:49AM

@fjannelle Great suggestion, I've implemented number 1. Dew Thank you for the reminder, I was looking in the wrong place! :o

in Print Sales Order # on Invoice Comment by Bill Quinn Aug 16, 2015 7:21AM

Have you tried the field {locationquantityavailable} ? MT, Thank you for the idea. I've tried {locationquantityavailable} and receive the same error message. I guess I will write a SuiteScript to calculate it but would prefer a formula field. :h_a_w:

in quantityavailable in a custom formula field Comment by Bill Quinn May 20, 2011 1:40PM

When you say all locations do you mean that your inventory is split between multiple warehouses? Luke, Yes, we have inventory split between multiple warehouses. It looks like your statement is true, {quantityavailable} is not working. Thank you for the information.

in quantityavailable in a custom formula field Comment by Bill Quinn May 20, 2011 1:39PM

Oz, Thank you for the idea. I tried {item.quantityavailable} but receive the same message "ERROR: Field Not Found". Anyone have any other ideas?

in quantityavailable in a custom formula field Comment by Bill Quinn May 11, 2011 12:21PM

Update: 1) I tried {quantityonhand} and received the same result 2) I was able to get nvl({quantityavailable},'0') to work as a formula result in a saved search. 3) I tried both nvl({quantityavailable},'0') and NANVL({quantityavailable}, '0') in the custom item field and neither worked. I also tried 0 instead of '0' Any…

in quantityavailable in a custom formula field Comment by Bill Quinn May 12, 2011 2:12PM

*** BUMP *** Would anyone from NetSuite have comment on this? This should work with no issue. It is not that complicated.

in Default Value for Custom Transaction Column Field Comment by Bill Quinn Sep 5, 2008 1:18PM

In general custom field values are carried over from the sales order. There may be some special provisions for drop ship purchase orders. I will investigate. Thanks, -e Evan, You are correct. I added the custom field to the sales order, filled in the value and this properly transferred to the Item Fulfillment. The Drop…

in Item Fulfillment Custom Fields Default Values Comment by Bill Quinn Sep 10, 2008 11:24AM

In working with support, the support rep says they cannot see the SQL statement being submitted to Oracle. They can only see the error message coming back. Does anyone know if there is a date format exclusive to the web store which is not governed by the date format in Setup -> Company -> General Preferences

in Default Value for Custom Transaction Column Field Comment by Bill Quinn Sep 8, 2008 1:26PM

When I display the field on the web store (which I do not want to do long term), the format is like 2008-09-09 00:00:00.0 instead of MM/DD/YYYY.

in Default Value for Custom Transaction Column Field Comment by Bill Quinn Sep 8, 2008 1:41PM

Try removing it from the webstore (for now) unless you need to accept user input for it. Yang, That field is not displaying on the site nor do I want it to display on the site. I think that support has been able to reproduce the error. I am not sure why they were not able to before.

in Default Value for Custom Transaction Column Field Comment by Bill Quinn Sep 8, 2008 4:25PM

To add more color: NetSuite Error Ticket: fkl5aknj1wph80dehfm27 The estimated ship date on the order header will not work because we have different estimated ship days for each location we ship from. We display the estimated ship date in the web store. We would like to include the estimated ship date in the order…

in Default Value for Custom Transaction Column Field Comment by Bill Quinn Sep 1, 2008 10:37AM

Try posting your code so that we can take a look. From the error looks like there is a date formatting error of some sort. What is the default company date format in your account? Thanks, Yang Yang, The estimated ship date gets populated ok when I enter an order using the NetSuite UI. This population occurs solely based on…

in Default Value for Custom Transaction Column Field Comment by Bill Quinn Sep 5, 2008 6:07PM

Robert, Great suggestion! I will give that a whirl.

in DateTime Custom Item Field Comment by Bill Quinn Aug 15, 2007 12:15PM

NetSuite will not generate a RSS feed.

in RSS Feed for Webstore and Information Items Comment by Bill Quinn Apr 12, 2012 4:26PM

Is there a solution to this yet? Not that I am aware of...

in Facebook Social Plugins / Open Graph Protocol Comment by Bill Quinn Jul 19, 2012 9:36PM

As a follow up, to define the open graph URL, this will work fine: This: <meta property="og:url" content="<%=getCurrentAttribute('sitecategory','canonicalurl')%>" /> Will produce: <meta property="og:url" content="http://www.christmastreeforme.com/Artificial-Christmas-Trees/Christmas-Tree-Video-Princeton-Pine">

in <link rel='canonical' href='<%=getCurrentAttribute('item','canonicalurl' )%>'/> Comment by Bill Quinn Oct 28, 2011 1:03PM

Actually, there is a way to make this work. This is how you do it: 1) Make sure you are logged in with your developer account so the appId is automatically included in the code. 2) When generating the Like button from: http://developers.facebook.com/docs/reference/plugins/like/ simply ignore the statement "Send Button…

in Facebook Social Plugins / Open Graph Protocol Comment by Bill Quinn Sep 22, 2011 10:40AM

As a follow up, the combined Like and Send buttons are working in IE. Unfortunately, the advanced functionality does NOT work in IE. For example, if a freind of mine likes it; I do not see my friend's image. Maybe there is a rig I can execute to make this work.

in Facebook Social Plugins / Open Graph Protocol Comment by Bill Quinn Sep 22, 2011 11:01AM

NetSuite and others may ask - Why does this matter? The Facebook like button can be executed via AddThis and a host of other methods. First: There have been many iterations of "FaceBook Sharing". The first version was very lightweight and simple. The latest version of "FaceBook Like/Send is EXTREMELY powerful. The short…

in Facebook Social Plugins / Open Graph Protocol Comment by Bill Quinn Sep 22, 2011 9:54AM

Guillaume, Fantastic pointer, I really appriciate it. Unfortunately, the solution works for Firefox but not IE. IE does not respect changed to <HTML>. To some extent, I understand why Microsoft did this. Why after all, would someone be forced to override <HTML> via script?

in Facebook Social Plugins / Open Graph Protocol Comment by Bill Quinn Sep 21, 2011 7:13PM

Hi Guillaume, Thank you for the idea. I'm going to give it a shot. I'll let you know what I find.

in Facebook Social Plugins / Open Graph Protocol Comment by Bill Quinn Sep 21, 2011 5:07PM

See this page http://diveintohtml5.org/semantics.html Brett, Thanks for the post. I really like diveintohtml5.org. It really helped me understand the <video> tag in html5.

in HTML5 and NetSuite ecommerce Comment by Bill Quinn Sep 28, 2011 6:38AM

can you say missing doc type? One can set the doctype but NetSuite forces the use of <table>, etc.

in HTML5 and NetSuite ecommerce Comment by Bill Quinn Sep 26, 2011 11:32AM

It works; Thanks Wiz!

in Sort by Name / Sort by Price Comment by Bill Quinn Oct 20, 2010 11:46PM

Bill Quinn Red Ribbon

Comments