JMUnderwood Green Ribbon

I know how to do a SQL JOIN with the related tables. The main question I have is how to EFFICIENTLY get the total (using a SUM(amount)) AND get the other data for the invoice. When you do a GROUP BY you can only include fields on the SELECT statement that are in the GROUP BY clause. SO, this DOES NOT WORK: SELECT…

By the way, a great example of this tool is that provided by Microsoft Access to copy code and objects from another Access DB into the current DB. JMU

NetSuite, It has been 3 weeks since I started this thread, but no one from NetSuite has seen fit to reply as of today. When do you plan to provide a developer's tool that will copy code (including forms, reports, custom fields, etc) between two NetSuite accounts? Surely you can see the need and benefits of this tool:…

Your code looks off. Here is some psuedocode to get started. I would recommend you do a select * for now just to post all the colum rows and then pick from those columns what you need. That code was typed real-quick off the top of my head without any review. Should not have posted it. However, I think I'm on to a solution.…

BTW.. here is a quote from one of your threads - and there are others you have posted. "Knowing about these issues in a timely manner would help eliminate a lot of wasted effort, not to mention hair-pulling. :) Maybe an alert on the login page pointing to a section here of known issues being worked to resolve ASAP. Thanks,…

Would be nice re: "copying meta data" - but cannot see that coming anytime soon. Netsuite would be able to better comment on this I think. But so far, we have had little issues when we are performing implementations, re-implementations in-situ and re-implementations in a new instance. At least relating to protyping that…

The good news is that the system - albeit production - lends itself to "real-time" testing if co-ordinated properly. We rarely have issues here and we do some pretty complex customization centered around web sites. Its pretty hard to fry the system doing this. I'm not sure I follow this statement. How do you perform proper…

May I suggest that anyone who would like to comment on customization of NetSuite please do so in this new thread: Customization Best Practices Thanks, Jim

Basically what I am saying is that we (skyytek) avoids customization like the plague; and never heavy customization That explains everything! :D IMO, customization is inherently neither good nor bad -- it depends on the need. Many, many companies have either highly customized SAP or PeopleSoft, etc, or have written…

IMO customizations break things, are not upgrade resilient and moreover should be undertaken with great care and planning; expecially in a product that can change at a whim. Interesting. That's the exact opposite of one of NetSuite major selling points, i.e., that customizations are NOT broken by NetSuite upgrades. I was…

Yang, Thanks for an excellent and useful example of Best Practices. May I suggest that NetSuite create a new forum section title "Best Practices", and that you and others publish this type of content to that section. IAC, your effort here is much appreciated. Jim

Is there a reason NetSuite doesn't automatically replace Y/X with Y/nullif(X,0) when the formula is executed? Everyone might not want that behavior. There might be use cases where X should never be zero or null, and you want an error to be thrown if that occurs. HTH.

I'm not sure exactly what you are looking for, but all of the documentation is available through the Online Help. This includes PDF guides you can download. HTH.

Thanks Cindy.

Steve, Thanks for the post. These are things that need to get fixed. Some need documentation, but some are API changes. You call them "nits", but they can cost many hours in lost productivity. Whether it be U/I or APIs, one of the MOST IMPORTANT things is to be consistent. Just my 2c.

I'm sure these things will be helpful. However, what I would find most helpful (and I think many other users), would be a table which lists each permission, and then the impact of having it, or not having it. ... I appreciate that you want to thoroughly vet any internal documentation you have before releasing it, but…

I am exploring a couple things internally: 1) Exposing the permission required for a page in some way in the UI (similar to the perf stats popup, e.g.) 2) Generating a list of all pages and their required permission. I'm sure these things will be helpful. However, what I would find most helpful (and I think many other…

Jim, The team is working on fixing this, but on Friday we think that we discovered that this problem won't happen if you use a browser session that is not logged into NetSuite. One of my people was able to access all of this content when she did so from a new browser session. FYI, Tom Tom, Thanks for the quick reply. I…

Phillip, It still does NOT work on 2007.1 accounts, but does work on 2008.1 accounts.

FYI, here's another thread expressing the same need/concern:[INDENT]Permissions [/INDENT]

We are planning extensive documentation for permissions, but I don't have an ETA, it is a pretty big project. Thanks, -e Evan, You have been promising this for quite a while -- seems like about a year. When will we begin to see some fruit from this project? May I make a suggestion? How about publishing what you have? IOW,…

Someone from NetSuite will probably jump in here, but AFAIK you must log in.

An example of that would be really great. I couldn't agree more.

Okay, so here's what is happening. If you create a CM from Transactions > Customers > Credit Memos and apply it to a specific invoice ... the eligible amount isn't reduced by the amount of the credit (I'm still not sure why, since I did apply it to the specific invoice). However if you create the credit memo by clicking…

It is still NOT working for us or our clients. We are starting training next week. When will this be fixed?

Thanks JM, One of our key goals is to make sure people review both the page under donations and a application guidelines (pdf documents) before they apply for a donation. Then I would suggest stating exactly that at the top of both the Donations page and the Apply page I'll look at putting together a better eye catching…

JM - Thanks for letting us know about your issue. I tested all the links myself in both FireFox and IE (v6.0 and v7.0) and each link opened without a problem. I am going to pass this issue along to a few more people to see if they run into what you are seeing (or if they know why you're getting this error message). Thanks,…

mmm.. and what happened to the software ?. Thats not reality. Hype (vaporware), then maybe Launch (so called beta), Fix, .... then document it. Much that what I have stated is not what people want to hear. But it is reality with most software. Sorry Ray, but I have to disagree with you here. Reality is what the SW…

Angela, You have made a number of good suggestions of how to work-around the problems with the current NetSuite PO workflow, some of which include customizations. However, IMO NetSuite still needs to address the key issues: [LIST=1] [*]Current PO documentation is confusing. [*]The most critical step/function in PO is not…

Hi Jim, Your are absolutely correct. However, much of what you are reqesting can be done via advanced customization (purchasing agent). Angela, I have no doubt that the PO workflow can be modified by advanced, substantial, customization. But the point is that out-of-the box the NS PO workflow doesn't seen to work well for…