3962086 Newbie

Is the bundle up to date in NetSuite? There was a mandatory update that was not too long ago.

I did it a different way. I have a saved search that sums the amount of that item on sales orders pending approval (could do on PO's as well), then I have it populating a field and I added it to an item availability search. This way it shows up easier on the item record as well as in a search. The only issue that I was…

There are some formulas in the help section that calculate only business days. You could use one of those and just use that as a criteria to make it only show up when 10 business days have elapsed. This should make it so that it does not fire on weekends because it does not count weekends.

Are they previously created saved searches or new saved searches as well? It could possibly be a server migration thing. Is the URL switching from NA1 to NA2 or vice versa?

I seemed to have resolved this. I did a case when statement on the is incoming field in messages fields... and assigned values and summed them to get my results. Thanks for your help!

Hi Dew, The issue is that we also need to check to make sure that a message has been sent out. We do not want a purchase order in the list if there is no message going out. It basically needs to check that a message has gone out and then show results if there has not been an incoming message from the vendor. What I would…

What kind of list are these? If they are custom lists, you could convert them to custom records and then change the "Access Type" to "Use Permissions List" and then add their role to the list. You cannot make it employee specific. You will have to also give people access to the list that also need to view it. I would try…

You can't because it is a subrecord. You could create custom fields up top and then have a script set them into an address line, but you cannot make subrecords editable in the main section on the record.

Another thing to note is that the owner of the record will always have access to edit it.

Multiple Currencies has to be turned on to get that list. Setup>Company>Enable Features and check Enable Multiple Currencies under the company tab. You may not want to keep multiple currencies however.

Are you referring to the Purchase Order title next to the magnifying glass at the top of the page or do you have an actual title field that you created?

My mistake. This isn't actually something that's in wide-spread use. It looks like something custom that NetSuite Professional Services implemented on one of our sites. I know it's definitely on the roadmap, though. Sounds exactly like what I built, the record name is even the same. I wonder if that is using my code... I…

Do you have 2 functions then? One for the bit above the delay and one for the bit after it? >I already deal with that function and it gives me the error mentioned (function not found) "Try window.setTimeout(FunctionName(), 10)". Are you putting your function name for the second half under the delay in for "FunctionName"?

Try window.setTimeout(FunctionName(), 10)

If all you need is an email alert on the Sales Order that shows what changed, you could accomplish this with a Saved Search. On searches, there is an Email tab where you can select "SEND EMAIL ALERTS WHEN RECORDS ARE CREATED/UPDATED" then add in who you want the recipients to be below (and check Send On Update and Show…

As a follow up to this, I just tried it in a search and it is only pulling system note changes, not item changes. I need to see what items were added or removed from the order. Thanks, Zack

Why cant this be done by workflow? Are you trying to add it to the lines on the transaction as well or in the main? You could have them set after field sourcing of employee and then set department and location based upon employee custom fields.

Why not nlapiGetFieldValue('total')?

I would make sure to leave the deployment in testing. Don't want people deleting everything accidentally when they don't know what they are doing.

Hey Martha, Are you using the advanced HTML/PDF printouts? If so, you can change the print out to not show lines if they have $0 as the amount. You will need to have HTML and Freemarker experience to change these. I can provide you examples of the set up. Thanks, Zack

<td align="center" colspan="3" line-height="150%"><#if item.amount != 0 && item.quantity gt 0>${item.quantity}</#if></td> This would have to be the format of the <td> lines in the item table. The <if> statement tells it that if the amount is not-zero and the quantity is greater than 0, show the item. You could remove the…

Are you in an admin role? You should be able to go to the system information tab and find the workflow in the active workflows list and cancel it. This will turn off the workflow on that record. If you know how to use SuiteScript, you could run a NlapiSubmitField command in the console to change it.

There should be a "Standard Sales Order - Cash Sale" transaction form. You may have it disabled. This is how we disable customer deposit links to sales orders. It should work in your scenario as well. When we flip ours to unlink it, they have invoices at that time, so it should be the same.

Have you tried changing the Sales Order form to a Cash Sale form? That should break the link, then you can just revert back to the Sales Order form.

As far as I am aware, you cannot do that.

How is your online form set up? Do you have fixed widths in the HTML?

This happens to me in workflows. If you edit and save it, sometimes the email template will not save.

They are having a SuiteCommerce issue in the NA west facility. It might be more than that as well. But yes, those did load very slow.

If you break that up into two separate sets, do they display results? I think you should be able to if you add inventory location and location available in the results.

If you edit the role and go to the lists subtab, you can remove their access to "Perform Search". This should remove their rights from running searches. Nevermind, this actually takes away global search.