JMUnderwood Green Ribbon

You can add a price level that is discount based and then make that the default price level for that customer. I would advise against creating one price level per customer (instead create a bunch of discount levels). I understand this is the standard approach for customer pricing in NetSuite. However, this will NOT work…

Ok. That takes care of one. How do you export 300+ simultaneously? And what about updating them? I would create two Transaction searches: [LIST=1] [*]Criteria: Mainline = Yes to capture all of the SO body data [*]Criteria: Mainline = NO to capture all of the items.[/LIST]Run each search and export as CSV. You will, of…

[quote=BradB]You can do via ODBC (with adv analytics). You should be able to query them via SMBxml and/or webservices, although I have only imported through these interfaces. ??. that would be a lot of development. [/quote] Actually it would be pretty easy IF you know Oracle SQL and have setup ODBC for NetSuite previously.…

It sounds like what you want is to update the "Item Pricing" subtab on the customer if the prices are really unique per customer. John, Thanks for the suggestion. This would make sense, except that the "Item Pricing" on the Customer record still requires you to select a Price Level for each Item. So I may as well go ahead…

Good morning all. My company has given me a task of documenting all current NetSuite settings/preferences before we begin some massive customization/new projects. . . . Does anyone have best practices or experience with this? I'd greatly appreciate some feedback/advice. Dan, I agree with Olivier. Use of a Sandbox is…

A lot of us for found that it is best to just NOT use NetSuite's auto-number for Customers:[LIST=1] [*]As you have found, makes almost all customer lists sort by Customer number [*]All reports are grouped/sorted by customer number [*]At every turn you find yourself fighting this. [/LIST]Yes, with a lot of work you can work…

Looks like a 2011.2 Upgrade Defect. We had similar issue and had to change to LoadRecord, rec.setField, SubmitRecord.

- Restricted Column Checkbox - This from will be restricted to this role you mark as preferred. Patrick, Let me make sure I fully understand the significance of checking the "Restricted Column" box. Does this mean that users with that Role will be restricted to using that form, and that form only, even when viewing/editing…

Jay, Thanks for the suggestion. May I ask: [LIST=1] [*]Why the Ganymede SR1, vs SR2 and the other Eclipse versions? [*]Have you tried the Eclipse IDE for JavaScript Web Developers ? [/LIST] There are so many choices, it is overwhelming. The only guidance NetSuite gives if for Eclipse Classic with Aptana plug-in But the NS…

I have taken to just installing the newest Eclipse for Javascript and placing the Suitescript definition files into my basic (workspace) Javascript project. I think that may be my problem. Where do I get the "Suitescript definition files"?

Hi Jay, Glad to hear that something works! What do you mean by "old version"? Eclipse, Aptana, both? What is "3.4.1 (ganymede)"?

Resolution: The fields you want to use with DLE must appear on all forms for that record type. So, in our case, we had to add/show the custom fields to all versions of the Sales Order form.

Here is what we have learned after much trial and error. There is a known defect that results in the Seconds being required even though the Help system says Seconds are NOT required (see below). FOR NOW, the Date/Time format must be conistent with your system preferences: System Preferences: MM/DD/YYYY hh:mm:ss AM/PM…

Thanks for the suggestion Olivier, but yes, Mainline is TRUE. The same setup works find in the Sandbox. I added a new Custom Trans Body field to the search, and you can DLE it.

You might try: Formula (text) CASE WHEN ({custbodya} > {custbodyb}) THEN '2' ELSE '1' END If that still gives an UE, then try using Formula (numeric) CASE WHEN ({custbodya} > {custbodyb}) THEN 2 ELSE 1 END Also double-check that both fields are actually Date/Time, and output them on separate Formula ( Date/Time)…

Steve, A few years ago we made an extensive effort to create custom Centers, and Roles to go with them. It seemed the logical thing to do when you have a highly custom set of permissions/dashboards you need to deploy. Turned out it was a disaster. We frequently discovered issues/roadblocks to using Custom Centers. Since…

. . . I just wanted to document it for their QA team. You will probably need to submit a support case to do this. You could do it using the NetSuite Online Support form.

. . . I changed the Track Messages and Email Template permissions to Full. . . Michael, You may want to double-check this with NS Support, but I don't think you need access to the "Email Template" just to view/create email messages. But more important, you may want to review carefully who you give "Full" permissions to.…

. . . There was a defect #193750 which was fixed yesterday. In the meantime if you wish to fix the affected transactions, please edit and then save. The value will now appear. I will email a case with additional information. Best, Maria Maria, Can you please provide more information on which Saved Searches might be…

Aparently putting Field Groups in columns is completely broke. I have tried with both entry and transaction forms: [LIST] [*]Customer [*]Project [*]Sales Order[/LIST]As I understand it, all you have to do is CHECK the box under "Single Column". I've done that, but it doesn't change anything. Here's the layout of the Sales…

That's because it's a subcategory that doesn't appear until you've selected a category that is in no way intuitively related. NetSuite Performance > Reports / Searches Actually I think the intent of that category is just for performance problems with Searches. Saved Searches are now supported in the same queue/category as…

This defect appears to have been fixed, although I have not received official notification. I was able today to upgrade all standard and custom forms on my Release Preview.

NetSuite has officially created a Defect Issue for this and is actively working to resolve the issue. Defect # 185909 - BLOCKING > UE > Form Migration Tool > Upgrade Checklist > Click Edit next to any custom form > nothing happens SUMMARY: Result: Nothing happens > Returned back to Upgrade Checklist: Review and Deploy…

It appears that this issue was able to be solved as follows: We checked the item record and under the History tab > Transactions sub tab, the inventory distribution is dated 09/02/2010 while the sales order date is set to 08/28/2010. Once the date of the sales order was changed to a date after the inventory distribution…

. . . but another thing you can try to do is re-create the report from scratch. That may fix the issue since it doesn't seem to happen with new reports. We are having the same issue with both old and new reports.

This is because of post-processing we do on that function. I will fix. Thanks Evan. Much appreciated. :D

Thanks for the feedback and ideas. I just got a suggestion from NS to clear the WS App cache using this code: public void ClearApplicationCache() { List<string> keys = new List<string>(); // retrieve application Cache enumerator IDictionaryEnumerator enumerator = Cache.GetEnumerator(); // copy all keys that…

We have a transaction search that has a filter of item location that is designed to only report transaction details on items that are in that one location. The filter mostly works, but we have found at least one case where the filter is clearly letting through an item that is in the wrong location. John, Could you please…

I agree that having the "register look" would be very helpful. As a workaround you might try playing with the color scheme. I have one that displays the locations as black text on a gold background with white lines between each row. Much more readable than a solid background, but not as good as "register look". HTH.

. . .because I am saving the import as a template to be used for both Adds and Updates). . . Steve, This is an example of one of the many reasons I do NOT combine UPDATES with ADDS, even on the template. I have seen elsewhere in the UG that many people recommend to NOT use the "Add and Update" option. This results in…