Hi, thanks for the reply. I can see how the current design works, I'm only concerned that we are going to eat up space quick with a ton of duplicate data. Time will tell! ;)

I haven't reviewed the ER and didn't write it, so I'm not sure what it says. Can you be more specific about what you need to do? Yes. I would like to access the images for an inventory item. I don't know how they are stored on the backed (BLOB, FS, etc) but I need to get the images somehow. If there was a MediaItem view…

I've logged a case for this performance problem: 640808

Can't say that I'm terribly shocked that ODBC appears to have just gone down. Once again, I can't connect, can't login. It's 8:33PM PST and for 10 minutes I haven't been able to connect. Oh, finally timed out. Here's the error: ERROR [HZ520] [OpenAccess][OpenRDA ODBC]RDA error: Connection failure :mad: :mad: :mad:

Just for giggles I tried this: string weirdSql = "SELECT t.transaction_id " + "FROM transactions AS t, transaction_lines AS tl " + "WHERE tl.item_id in '434' AND t.transaction_id = tl.transaction_id AND t.transaction_type = 'Sales Order' AND (t.status = 'Pending Fulfillment' OR t.status = 'Pending Billing/Partially…

We had a scheduled release of code at 6:00. Did you notify your customers about this disruption? Why would you make system changes/updates so close to business hours? That makes no sense?

I'm not even close to a developer but I am very curious by your idea. Storing the email address's in one database (netsuite) but using another database (outlook) to send the email; this is driving me and our whole sale staff crazy. What exactly did you have in mind? Doesn't the current integration sync your contacts…

I'm just curious if any developers would be interested in an open source project to develop an Outlook add-in for NetSuite? I've toyed with the idea but can't do it alone. Lemme know...

I'm no developer, but I follow a lot of open source projects. Is it possible to use MAPI libraries from a project like openchange (http://apidocs.openchange.org/overview/index.html) with a webservices connector in netsuite? from http://apidocs.openchange.org/overview/index.html: Mark, As I just replied in the other post, I…

I just received this email from one of my employees commenting on a phone call email reminder he just received... [COLOR=navy][FONT=Arial]I know you didn’t create this system, but their email reminders are 100% useless.[/COLOR][/FONT]

Just a couple of no brainer sugestions:[LIST=1] [*]Customer (if attached to a customer) [*]snippet of the notes [*]phone number to call [*]LINK TO THE RECORD![/LIST]it can't really be this limited, can it? Is there a way to customize this s u c k e r and get some more data in the email? Sigh... Ah, here is a great example…

JM, you make some good points, especially the duplication of effort. I have some ideas for that, but first: I think it's inconsistent that we can't assign a task to a group. You can assign a case to a group? So why not a task? I'd be interested to see what NetSuite says about this. -Steve

(2 minutes later) Well this is embarrassing... Solution: Check the "Add Running Balance Column" option on the Report Builder Columns tab. Hmph!...

It seems to me that Netsuite is telling users that they can set up an Other charge item for freight and then also check the box for landed cost. However an other charge item does not have the landed cost checkbox. Netsuite may need to review their documentation to see if it should be corrected or at least clarified. I know…

Yes, the items I'm tracking landed cost for must be Inventory. I think I misunderstood the reported problem on this thread, I thought the confusion was whether the Landed Cost Item (e.g. "Customs & Duty") needed to be Inventory or not.

Thanks Evan and CoffeeGuy. I took the plunge and created a UOM with the same name as the Item it applies to and I feel as if a huge weight has been lifted off my shoulders. I can put the Xanax away at last! :p BTW, Evan you should let us define a UOM unit on the Vendor list so we can handle situations where diff. vendors…

I don't think there is a way to override it. If this is a workflow that you must have supported then I would suggest a fully custom approach consisting of: [LIST=1] [*]A custom minimum field [*]Client script deployed to sales transactions that would block if minimum not met with an option to enter credentials for an…

The limit is in place in part to discourage users from creating Locations to identify areas within your warehouse, such as a bin, shelf, or dock. Doing so causes difficulties with fulfillments, LIFO and FIFO costing, and NetSuite reporting. We have unfortunately done this very thing. What is the recommended best practice…

Hi Jim, I missed that you replied to this thread and just found the email notification. I appreciate your thorough reply and I think you're right, it does seem like we may have discussed this at one point. Your advice is sound and applies to many of my cases. I was *trying* to make a single UOM table for "common" scenarios…

Yes, the field is called Minimum Quantity and is located on the Basic tab. It does precisely what you want.

The rope thing was just a phoney example. I think maybe what I'm missing here is that I'm trying to create one big generic UOM for these odd situations. I already have "length", "volume", "weight", etc. Those are very simple to do. What I'm having trouble with is creating the setup for mixed units. Another example: We…

#1 - Support confirmed that order Pending Approval are not considered in the calculation.

Generic is good, I like generic and your suggestion made me re-evaluate my setup. I went generic. Thanks for the good info Jim, I appreciate it!

The only real problem is that you buy different "bundles" from different vendors. I think each of these will require a different Item and a different Units Type. Jim, I just did a test and was pleased to find that the Units column is presented on purchase transactions. So if I have a 3Bundle and a 4Bundle I can pick which…

Are these existing ERs or are they a result of this post? If they are brand new, do I need to vote or have I already been attached to the ER?

Jim, Thanks for the thorough response. I've got a good grasp of how the different units relate, the problem I was/am facing is whether I should create a single Unit of Measure to attempt to represent all different scenarios, e.g:[LIST] [*]Case10 [*]Case15 [*]Case30 [*]Case50[/LIST]or create a Unit of Measure for each Item…

Now the good thing that I have seen come from me using kits is that in my system I use it as a placeholder for a product that we sell. Since our company and they way we purchase/produce products is constently changing I have used kits to form the top level part that is sold and then I have 1 assembly as its member. THis it…

Wow, thanks for all the info. It's really too bad that I decided to use Kits. I did some research and experimenting but somehow missed many of these problems. What makes it worse is that I don't understand why any of the limitations are there. A BeforeLoad script is going to be required to set the amount buildable, but the…

no :( Check the first post in this thread

They aren't supported because you never have any kit inventory on-hand. (Well technically you do at the time of fulfillment, but it is immediately fulfilled. So in that infinitely small amount of time you have some kit inventory on hand I suppose). Because of this they are not supported for inventory transfers and you need…